JD Edwards (JDE) Amount

[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.

[jonathandienst]

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 ....

[shalensookdeo]

You are brilliant.

Why did i not think of this?

Thank You