Difference in GL balances between MR and Finance Statement traditional

(0) Share

Report

Posted on by psinghal

Hello,

We are planning to configure financial statements in MR. However, the GL balances as per Finance Statement Traditional and as per TB taken in MR do not match. We have a muiti-currency setup (DKK, Euro, USD & INR) with 10 entities to be consolidated.

In the P&L statement, the largest difference is in the foreign exchange gain/loss account. In the balance sheet, most of the accounts do not match. We have looked at many configuration options but are stumped in trying to match the numbers.

Can someone point out why there are differences in the two reports? We do not know which is the correct version of the truth.

Thanks,

Pankaj

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hello Pankaj,

At the ledger account level you can specify how AX should convert foreign currency amounts for the Management reporter. As far as i know there is no comparable feature available for the traditional financial reports. You will thus not be able to match both financial statements if you have a lot of foreign currency transactions. Have you already checked the MS financial reporting blog? There are a lot of additional information available there that might help you understanding how foreign currency amounts are converted for the Management reporter.

Best regards

Ludwig

Was this reply helpful? Yes No