format-currency

jaxNZ

Member
Hi there,
I have an issue related to using format-currency function to format numeric values according to currency.
With JPY there are records where the formatting doesnt work. It occurs where the extended amount is under 100. However on the same record it works for Unit Price under 100. Its consistent and not random. Both Unit Price and Amount fields have a default Word format of number #,##0.00. I've checked the currency code by displaying the currency code against each record. Has anyone see this sort of thing before?
Thanks
Jackie
 
Hi there, forgot to add that this isn't an issue when previewing in the desktop. Its only an issue when the PDF is merged in JDE.
thanks
Jackie
 
Back
Top