Different Amount in GL When Export to Excel

Have you checked the Account balance in excel it will be same as in AX. This positive sign in being because of Paramter activated on GL Paramters > Ledger Tab > Correction = Yes. The same functionality exists in AR and AP and it is used to differentiate the reversal transactions in AX. No need to worry as AX takes care of balancing whille exporting to Excel.

Thanks Sachin because want help me. I have tried to change the setting in parameter as you said, but it still same. Actually I'm vendor, so my client want to know, why it can happen like that. Could you give me suggestion answer to tell to my client?

This parameter will not change the Old Transactions and it can only impact the new reversal transactions to be posted.

If you can convince your client for Old Transactions then after deactivating this parameter New transactions will not have this issue.

AX takes care of the Balancing of these transaction during export to Excel.

If you really want to remove these extra signs from transactions then you need Developer's Help here.

Hi Aiman,

Check if there is any customization done GeneralJournalAccountEntry table, AccountingCurrencyAmount is the field which is highlighted above showing wrong figure, it must be inherited from AmountMSTDebCred EDT. If it does then none of the amount will show a sign. As on the EDT SignDisplay property is set to None.

U can check and post, don't try n make any changes over this. It may create a mess for u...