JD Edwards Amount and Units

[shalensookdeo]

Good day All

Trust you are well!

I am looking to convert the amount and units received from a JD Edwards tables.

Line 1: The amount should be in the format R3 920.00 but instead it spits out 392000 and when i change he number format to Money it gives me R392 000.00 which is incorrect.

Also the units should be 16 but it gives me 16000.

[Gysbert_Wassenaar]

Check the values of these system variables in the script of your document.

SET ThousandSep='.';

SET DecimalSep=',';

SET MoneyThousandSep='.';

SET MoneyDecimalSep=',';

Perhaps in your document you need to change the values of these variables.

[shalensookdeo]

Thanks for the help, but still getting the same after changing the variables.

[Gysbert_Wassenaar]

Did you change the variables in the script and reload the data?

[shalensookdeo]

Yes i did it in the script.