Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 ....
You are brilliant.
Why did i not think of this?
Thank You