the reporting currency values on balances reported on Trial Balance do not match to closing (Accounting) currency values. After the upgrade to v. 10.0 we have been introduced to this new special 'Reporting currency adjustment journal' in General Ledger module which we started using to fix reporting currencies to all affected accounts balances at each month-end. At the beginning we did the adjustments to the main account level only, but ideally we should be doing it to every dimensions level used along with the main account. This actually creates a larger list of adjustments to be made and to avoid manual input I attempted to use the 'open in excel' function to upload my adjustment via excel file but there is no such template available under this function as it normally is available with regular GL-JRL journals. Is this something that it could be configured for us to avoid manual line input?
Comments
Do we know if a end user can use the "Open in Excel" add in for this entry yet?
I found the new data entity for the lines of the entry - it's called "LedgerReportingCurrencyAdjustmentJournalLine", but the "form name" where we post the entries is called "LedgerJournalTransReportingCurrencyAdjustment" - are these two separate entities or can we somehow link a excel template to the "open in excel" menu?
Category: General Ledger
Can we confirm this is live in 10.0.10? We are on that version and cannot locate this data entity. What is the name of the data entity?
Category: General Ledger
Hi Kristi,
Is there an update on this by chance? We are trying to find some way to record "Reporting currency adjustment journals" without line-by-line keying.
Category: General Ledger
Hi Kristi,
Would you happen to have an update on this? Our Client is looking forward to this feature. Is it part of the 10.0.10 release?
Category: General Ledger
Administrator on 8/10/2020 7:28:30 PM
Kristi Slininger, PM
Microsoft