Travis Wendland
Member
We have a situation where we have zero decimals in our quantity fields but our cost per EA is too small to precisely cost our products when the primary UOM is EA. We cannot set the primary UOM to thousands of eaches because we sell in EA.
We have 2 options. We can change the display decimals on the quantity fields to be at least 3 or we can change the display decimals on the unit cost fields from 4 to 7.
The officially supported solution from Oracle is to change the display decimals on the quantity fields. That is a daunting task because we have been live on JDEdwards for 15 years.
It seems to me that changing the display decimals on the unit cost fields would involve less data conversion. It is also the preference of our business users to not have decimals in the quantities.
Has anyone changed the display decimals on the unit cost fields? If so, do you have any words of advice about such a project? We realize that we will have to write programs or SQL statements to change the existing data in the files to have the correct number of implied decimal places. Also, if we move forward with this project, we would do it as part of an E1 upgrade project where we would have a separate data dictionary for our test environment.
We have 2 options. We can change the display decimals on the quantity fields to be at least 3 or we can change the display decimals on the unit cost fields from 4 to 7.
The officially supported solution from Oracle is to change the display decimals on the quantity fields. That is a daunting task because we have been live on JDEdwards for 15 years.
It seems to me that changing the display decimals on the unit cost fields would involve less data conversion. It is also the preference of our business users to not have decimals in the quantities.
Has anyone changed the display decimals on the unit cost fields? If so, do you have any words of advice about such a project? We realize that we will have to write programs or SQL statements to change the existing data in the files to have the correct number of implied decimal places. Also, if we move forward with this project, we would do it as part of an E1 upgrade project where we would have a separate data dictionary for our test environment.