Excel Export issue in ax

(0) Share

Report

Posted on by Vignesh R

535

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 the same question (0)

All responses (11)

Answers (1)

Sort by

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Vignesh,

I do not see this issue in AX2009. Can you specifiy what data you export and from which report/form?

Many thanks,

Ludwig

Was this reply helpful? Yes No
Vignesh R 535 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

I'm extracting data directly from Customer/Vendor transaction form using export to excel button.

Many thanks for your reply.

Regards,

Vignesh

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Vignesh R 535 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello Vignesh,

I see. If your colleagues are doing this export are they facing the same issue?

Best regards,

Ludwig

Was this reply helpful? Yes No
Vignesh R 535 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

Yes, My colleagues also facing the same issue.

Regards,

Vignesh

Was this reply helpful? Yes No
Vignesh R 535 on at

Like (0)

Report
Copy link

Link copied!

Hi expert,

Need your help to resolve this issue.

Thanks and regards,

Vignesh

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Vignesh R 535 on at

Like (0)

Report
Copy link

Link copied!

Hi Ludwig,

I have tried with CTRL+A(for all) but few rows only copying from grid while pasting into excel.

Regards,

Vignesh

Was this reply helpful? Yes No
Verified answer

guk1964 10,888 on at

Like (0)

Report
Copy link

Link copied!

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.

https://cloudblogs.microsoft.com/dynamics365/no-audience/2010/07/15/solving-various-issues-when-using-export-to-excel-feature-in-chart-of-accounts-form-microsoft-dynamics-ax-2009/

Was this reply helpful? Yes No