topic JD Edwards (JDE) Amount in QlikView

JD Edwards (JDE) Amount

shalensookdeo — Mon, 26 Jan 2026 18:19:17 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 (JDE) Amount

jonathandienst — Mon, 20 Aug 2018 11:33:30 GMT

It looks like JDE has been set up to scale the amounts by 100 and the quantities by 1000. I would correct those when loading the data from JDE

Load Amount / 100 as Amount,

Quantity / 1000 as Quantity,

....

SQL Select ....

Re: JD Edwards (JDE) Amount

shalensookdeo — Mon, 20 Aug 2018 12:01:43 GMT

You are brilliant.

Why did i not think of this?

Thank You