topic Re: JD Edwards Amount and Units in Integration, Extension & APIs

JD Edwards Amount and Units

shalensookdeo — Mon, 13 Aug 2018 12:34:05 GMT

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.

Re: JD Edwards Amount and Units

Gysbert_Wassenaar — Tue, 14 Aug 2018 07:02:37 GMT

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.

Re: JD Edwards Amount and Units

shalensookdeo — Tue, 14 Aug 2018 07:47:11 GMT

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

Re: JD Edwards Amount and Units

Gysbert_Wassenaar — Tue, 14 Aug 2018 08:09:57 GMT

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

Re: JD Edwards Amount and Units

shalensookdeo — Tue, 14 Aug 2018 09:10:46 GMT

Yes i did it in the script.