E9.2 amount decimal issue

[shivam]

Hello,

I am inserting Tax/Amount STAM/ATXA.F03B11 value --> custom file STAM/ATXA.F55XXXX.

I am surprised to see values getting inserted ex :3567 will be inserted as 35.67 not known how to deal with this .

please suggest...

Thanks in advance .

 

[Tom_Davidson]

Decimals are implied. You need to multiply/divide as appropriate

 

[DaveWagoner]

Shivam welcome to JDE and numbers storage You need to look at the data dictionary for STAM, look at the "Display Decimals" value, and then divide the number by 10^n where n is the number of the display decimals for that field. In your case the display decimals is 2, so 10^2 = 100, so divide by 100 to see the "real" value. JDE does it for you but if you're writing external apps or reports you'll need to do it manually. I typically just do it myself within SQL for better or worse