GL Summary translating USD to CAD$

(0) Share

Report

Posted on by Community Member

Hi everyone,

We have a GP Company ABC with CAD$ as base currency however, we use two checkbook ID(s) for Financial postings. One is for CAD$ and the other for USD$ Account. If I open GP>Financial Summary window, I'm able to see the CAD$ balances and entries as CAD$, however, the USD$ transactions and period activity is reported as CAD$.

I know I can force GP to use functional currency in GL to show me USD$ as USD$, but when I take a period look at yearly balances, I see GP is translating it as CAD$ i.e. the base currency. Even if I try to export the USD$ GL to excel, the reporting is automatically translated to CAD$.

This is really a limitation of numbers reporting in GreatPlains. I have always had encountered such reporting problems in GP, esp. in dual reporting books. Can any one please provide a fix for this issue ?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: GL Summary translating USD to CAD$

Multicurrency is not my wheelhouse, but this behavior is caused by your selection of CAD$ as the reporting currency ID for the Company.

The reporting currency is used to convert functional currency amounts to another currency on inquiries and reports. For a subsidiary, the reporting currency typically is the functional currency of the parent company. You can change the reporting currency at any time.

This setting is controlled in Tools > Setup > Financial > Multicurrency - the window is Multicurrency Setup at the company level.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: GL Summary translating USD to CAD$

So I post $25k, it prints back $28k CAD$. How can I know the exact USD$ balance for my accounts. Dont you think its system limitation?

Was this reply helpful? Yes No
Suggested answer

Redbeard 12,931 on at

Like (0)

Report

RE: GL Summary translating USD to CAD$

Have you tried using this button in the various GP windows?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: GL Summary translating USD to CAD$

That works for the GL transaction translation, I knew this.

What about the Summary Inquiry window. I need Balances to translate me USD, but it translates into CAD$. Any help?

Was this reply helpful? Yes No
Verified answer

Redbeard 12,931 on at

Like (0)

Report

RE: GL Summary translating USD to CAD$

Sorry,

In my first post I mentioned two things... Multicurrency was not my wheelhouse and You can change your reporting currency at any time.

If you prefer to see amounts in $US, instead of $CAD, perhaps most of the time you should leave the Reporting Currency set to $US, and set it to $CAD only when you want to see $CAD.

This setting is controlled in Tools > Setup > Financial > Multicurrency:

Was this reply helpful? Yes No
DinB 3,944 on at

Like (0)

Report

RE: GL Summary translating USD to CAD$

See if you can use the Checkbook Balance Inquiry window for that checkbook ID.

Inquiry >> Financial >> Checkbook Balance

Was this reply helpful? Yes No