4 decimal unit price & truncation

[sasbrown]

Has anyone else had problems with the JDE Advanced Pricing and sales order systems using base price and markup percentages? The data dictionary specifies a 4 decimal unit price, markups multiply this by a 2 decimal factor and extensions of quantity-ordered with the resulting 4 decimal unit price yield an extended amount which has been truncated to 2 decimals. If you change the data dictionary to 2 decimals for unit price, manual price adjustments in sales order results in amounts that are multiplied by 100. JDE says that they do not support changing the decimals and if we want that, we must make a custom modification to the programs to work with that. Has anyone else solved this problem?

 

[Guest]

While its

 

[jean_driscoll]

Decimal points in JDE are implied. Meaning a unit price with 4 decimal points does not actually show decimal points in the data file where it is kept. You can see this by using AS/400 query or SQL. If you display a unit price field in either of these tools, a unit price of say .25 will be displayed as the number 2500. JDE uses subroutines in their programs that look up the how many decimal point that should be and in JDE programs the unit price is displayed correctly. So if you just change the data dictionary decimal places from 4 to 2, the price that is in a data file as 2500, will be displayed by JDE programs now as 25.00 instead of .2500. Therefore, if you really want to change the data dictionary to use 2 decimals, you have to convert all of the data fields in the files. Although there are JDE tools out there that tell you where a data item is used, I believe JDE is nervous about writing a program that would convert all of the files for a particular data item, as it would affect alot of files and be difficult to test. That is why they do not support the changing of decimal places.

On the other hand, there is a place to change the number of decimals displayed, by currency. Look on menu G1131, type Help 10 and read the documentation. You will still need to convert existing data.

Jean Driscoll
AS/400 Co-existent Xe SP15+17.1, Update 1/A73Cum12