Detailed GL Trial Balance Report and Multicurrency

(0) Share

Report

Posted on by Sherryll Penney

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

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

RE: Detailed GL Trial Balance Report and Multicurrency

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.

Was this reply helpful? Yes No
Sherryll Penney 430 on at

Like (0)

Report

RE: Detailed GL Trial Balance Report and Multicurrency

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.

Was this reply helpful? Yes No
Bill Campbell 12 on at

Like (0)

Report

RE: Detailed GL Trial Balance Report and Multicurrency

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.

Was this reply helpful? Yes No
Sherryll Penney 430 on at

Like (0)

Report

RE: Detailed GL Trial Balance Report and Multicurrency

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.

Was this reply helpful? Yes No
babubaskaran@outloo... 12 on at

Like (0)

Report

RE: Detailed GL Trial Balance Report and Multicurrency

Hi Sherryll what do change in setup to print the multicurrency ending balance.

Was this reply helpful? Yes No
Suggested answer

soma 24,410 on at

Like (0)

Report

RE: Detailed GL Trial Balance Report and Multicurrency

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!!!

Was this reply helpful? Yes No