Hello, I have an email template for the dunning mo...
# advancedpdfm
Marc
09/05/2023, 8:13 PMHello, I have an email template for the dunning module on which I would like to display the amount remaining with the transaction currency symbol dynamically. However I can't do it. When I generate the email, if the amount is in dollars, then it will display 1000.00 € even though I have a currency column on the template which specifies that it's in dollars.Iwould like to see $1000.00
watching following 1
s
scottvonduhn
09/05/2023, 9:02 PMNot exactly sure what you mean by “have a currency column on the template which specifies that it’s in dollars”. Is the transaction’s currency actually in dollars (using the standard currency field), or is this a custom field that specifies the currency, and the actual transaction is Euro?
scottvonduhn
09/05/2023, 9:04 PMBy default, NetSuite will display things according to the actual transaction currency. Also, each currency has default formatting, and it is also possible to override formatting for each currency, so you may need to check that the format for dollars is set correctly.
m
Marc
09/05/2023, 9:10 PMyes the transaction is really in dollars but whatever I do, the remaining amount always comes out in euros. For example my invoice is 1000$, on my template it will display 1000€.
s
scottvonduhn
09/05/2023, 9:13 PMNote that there are two amount remaining fields:
Amount Remaining:
amountremainingfxamountremainingscottvonduhn
09/05/2023, 9:16 PMbut what confuses me is that, if you had a transaction with an amount of $1000, the base currency amount will usually not be 1000€, unless somehow the conversion rate was overridden to be exactly 1. Normally, you’d get a value like 932€, or whatever the converted amount is
6 Views