519
Hi Experts,
I need your efforts here to resolve issue. I'm trying to extract data from ax to excel. After extracting of customer or vendor transaction into excel, (credit/debit) both values are showing positive in excel. The correct excel should have credits in Negative and Debits in positive. Kindly give me some idea to find out the solution and root cause.
Thanks in advance and Regards,
Vignesh
*This post is locked for comments
I have an old note in my file - see this link - the site is still active.
This is one of three problems mentioned and there is a suggested code fix.
Hello Vignesh,
If it is acceptable then a workaround would be marking all data with CTRL + A (for All) and then copy and paste those values to excel where you obviously get the right signs (+/-) in front of the data.
If this workaround is not acceptable then you need a developer taking a look at this issue because AX2009 is already out of support and you won't get any hotfix or support for this old system from MS.
Best regards,
Ludwig
Hello Vignesh,
I see. If your colleagues are doing this export are they facing the same issue?
Best regards,
Ludwig
Hi Ludwig,
In excel, it is showing all amount value as positive. But if i copy paste value from ax to excel, amount value is coming properly.
if i use export to excel button, Wrong output is coming in excel.
Thanks and regards,
Vignesh
Hello Vignesh,
I just tested that and get the minus symbol in front of credit amounts. Here is what I see.
Can you share how you see the exported data?
Many thanks and best regards,
Ludwig
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,409
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
