Our support engineers have assembled the top recommended solutions for you.
Microsoft Dynamics AX 2012CRM Connector in Microsoft Dynamics AX 2012Financials Management in Microsoft Dynamics AX 2012Upgrading to Microsoft Dynamics AX 2012
Microsoft Dynamics AX 2009
Application Object Server (AOS)
Enterprise Portal and Role Centers
Inventory Costing in Microsoft Dynamics AX 2009
SSRS and SSAS Integration
Hello everyone, I'm newbie in AX. So I need help from you all. My problem is, when I want to export Account transaction into excel, the amount in excel is different. Please help me..! :(
Account Transaction ( Form ) :
Account Transaction ( 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.
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...
Other Microsoft Sites
I'm a Customer
I'm a Partner
Use the official Twitter tags:
#MSDYNCOMM | #CONV13