Did you tried setting the locale?
# advancedpdfa
Andrea Rivetti
06/12/2025, 2:10 PMDid you tried setting the locale?
e
Emily S
06/12/2025, 2:11 PMyes.
a
Andrea Rivetti
06/12/2025, 2:11 PMSorry for asking, maybe is the same locale in Canada but I guess we have a different locale for a different language in Canada?
Andrea Rivetti
06/12/2025, 2:11 PMAh ok, then it's not handled correctly
Andrea Rivetti
06/12/2025, 2:11 PMNS side
e
Emily S
06/12/2025, 2:12 PMYeah, for locale there is "en_CA" and "fr_CA", so it does recognize that there are two different locales, but Canadian Dollar seems to be hard coded to one currency format and I need two.
a
Andrea Rivetti
06/12/2025, 2:13 PMAs an input, I think you should follow more the billing country locale than the language. If you customer language is Norwegian but you are invoicing in Germany, is the Germany countr -> currency that determines how numbers and dates should be printed more than his language
e
Emily S
06/12/2025, 2:14 PMBut the billing country locale has two formats for the same currency... that's my issue.
a
Andrea Rivetti
06/12/2025, 2:14 PMYeah, got it. Was just a comment about the language. But you can also force a specific format
Andrea Rivetti
06/12/2025, 2:15 PM Copy code
<#assign dateformat = 'yyyy-MM-dd'>
<#assign numbersFormat = '#,##0.00'>
<#assign numbersFormatDecimals = '#,##0.000000'>
<#setting locale="en_CA">Andrea Rivetti
06/12/2025, 2:15 PM(sort of, just as an input)
Andrea Rivetti
06/12/2025, 2:16 PMI found multiple cases where setting the locale is wrong in NS, but for small countries. I always assumed Canada was handled correctly
Copy code
${itemUnitPrices[itemid]?string[numbersFormat]}e
Emily S
06/12/2025, 2:17 PMOh god no Netsuite is HORRIBLE for handling canadian things.
a
Andrea Rivetti
06/12/2025, 2:20 PMAh, good to know. Anyhow, then you can test the currency AND / OR the customer language and add your formatting
Andrea Rivetti
06/12/2025, 2:20 PMcustom, as in the sample above
e
Emily S
06/12/2025, 2:30 PMI've tried something along those lines but it always seems to get confused about what to use for the decimal separator vs grouping separator. This number should be formatted like $20,74 but it prints $20 74