430
Customer uses multicurrency in GP v2010. When they process a Detailed Trial Balance and include multicurrency, why are the beginning and ending balances reporting only in USD? Customer needs to see both beginning and ending balances in the foreign currency as well as USD.
*This post is locked for comments
Hi Sherryll,
Normally, if you select the Include Multicurrency option in GL details TB report. It will print all the transactions with functional & appropriate originating currencies in detail level only. But, you can not see the beginning and ending balance with originating currency.
Because, how can we calculate the beginning and ending balance if the transactions having different currencies (eg. AED, EURO, CAD, etc.,,). So that GP report will print originating currencies in detail level only.
If all your GL having single originating currency, set this originating currency as reporting currency in Multicurrency setup window and select the "Reporting' radio option in Print Currency In of GL trail balance option window. And enter the exchange rate and calculation method.
Here you need to clear one thing, this report will print based on the entered rate and calculation type even the GL details having different rate.
Please have a look on my below example for your requirement.
| FUNCTIONAL | AMOUNT | ORIGINATING | AMOUNT | |
| USD | 100 | EURO | 60 | |
| USD | 100 | AED | 370 | |
| USD | 100 | CAD | 120 |
| BEGINNING BAL | USD | 0 | EURO,AED,CAD | ???? | |
| ENDING BAL | USD | 300 | EURO,AED,CAD | ???? |
Suppose if this report include the beginning and ending balance as like below, that is wrong.
| BEGIN ORG BAL | 0 | THIS IS WRONG |
| END ORG BAL | 550 | THIS IS WRONG |
Hope this helps!!!
Hi Sherryll what do change in setup to print the multicurrency ending balance.
Thanks Bill - I am for sure including multicurrency. I see the detail activity in both currencies, just not the beginning and ending balances. The work around is to change the setup window, run the report and change it back. Not all users have access to the setup window so it's a temp workaround and not a convenient one. Any further suggestions are much appreciated.
When building the Report Option, you are for sure including MultiCurrency. I don't recall seeing this type of behavior in our reports.
I will be on site with client that has many different currencies and I will see if I can at that time duplicate the issue.
Thanks for the reply. They use several different currencies so I can't select just one in the multicurrency setup window for reporting purposes. Need to a trial balance report based upon the currency assigned to the account. The detail in the report is correct, I just need to see the beginnning and ending balances in the originating currency as well as the USD. I looked to modify the report to add the fields or calculations but could not.
Hi sherryll,
The reports are printed based on the Multicurrency setup. Tools>>Setup>>Financials>>Multicurrency.
You have the option to print the reports either in Functional Currency/Reporting Currency. But not in both currency at the same time. The field on the Trial Balance Report options window is "Print Currency In" for choosing the currency type.
Please cross check your Multicurrency setup.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
