Share
ReportHi all,
Can you please let me know, how to add currency symbol with amount during excel export?
Please give me more shed on this
Thanks!
You’re offline. This is a read only version of the page.
5,901
Hi all,
Can you please let me know, how to add currency symbol with amount during excel export?
Please give me more shed on this
Thanks!
Hi Arpan,
Is it about the currency symbol or the currency (ISO) code? If you want to format the Excel amount column, it would be hard if there are multiple currencies involved. Most companies in the world do use two columns: Currency and Amount. Then they also know what can be summed up in Excel or not.
you can customize a display method to retrieve the currency symbol to your form.
if this form is a grid and allowed to export. you can export the amount and symbol easily
Hi @rp@n,
I think that the legal entity validation is not sufficient.
Imagine that users export inventory data, do you want to have a $, EUR or other currency symbol when exporting those data to Excel?
To overcome those issues, you would need additional checks on the nature of the data that is exported.
I assume that this can quickly get quite complex because you can export almost everything to Excel.
My recommendation would be not doing that and use Excel instead.
Best regards,
Ludwig
thanks Ludwig
as you said
"Trying to do that through AX might not be easy as you might have different companies that use different currencies and symbols, etc."
can i put legal entity validation during get currency symbol? it will work?
because customer wants currency symbol with amount
please give me more shed on this.
Good morning @rp@n,
Can't you simply do the currency formatting with the symbol in Excel directly?
Trying to do that through AX might not be easy as you might have different companies that use different currencies and symbols, etc.
Also thing about non-finance amount related Excel exports that just export numbers.
In Excel, it takes a couple of seconds doing the formatting...
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (