1. Product Data Management Implementation Guide
  2. Understanding Quantity Decimal Conversion

Understanding Quantity Decimal Conversion

Some tables in the JD Edwards EnterpriseOne Manufacturing systems from Oracle maintain the Quantity (QNTY) data item:

  • Bill of Material Master File table (F3002).

  • Bill of Materials Change File table (F3011).

  • ECO Parts List Detail table (F3013).

  • Work Order LSN table (F3105).

  • Rules Table Detail table (F3283).

  • Assembly Inclusions Rules table (F3293).

The JD Edwards EnterpriseOne system ships the QNTY data item in the data dictionary with the display decimals set to zero. You can change the decimals on this data item to a value other than zero. If you change the display decimals, the system displays any data that has already been entered into the tables incorrectly on forms and reports. To insure that the display decimals are correct, run the QNTY Decimal Conversion program before anyone enters any new data using the new display decimals.

Use the QNTY Decimal Conversion program to convert the QNTY data items on all affected tables from a specified number of decimal places to a new number of decimal places. You use the processing options to identify these numbers. If you enter 0 as the Display Decimals From value and 2 as the Display Decimals To value, the system adds two decimal places to the existing QNTY value. For example, the system converts 1 to 100 and displays it as 1.00. If you convert from two decimals to zero decimals, the system removes two decimal places. For example, the system converts 100 (displayed as 1.00) to 1.

Note: The system first rounds the value before adding or removing decimal places. If you convert from two decimals to zero decimals, and the display quantity is 1.51, the system rounds the quantity to 2.00 and then converts 200 to 2.

You should run this program only if you have changed the Quantity field to display decimal places. You can run this program in proof mode and final mode. Proof mode displays the changes that you made to the decimal placement but does not update any tables. Final mode displays the changes and updates the tables.

The system performs special processing based on these conditions:

  • Prints a warning message when rounding a co-product or by-product quantity on the Bill of Material Master File table or the Bills of Materials Change File table.

  • Prints a warning message when rounding a percent bill quantity on the Bill of Material Master File table or the Bill of Materials Change File table.

  • Prints an error message, and does not convert the quantity when you are increasing the number of decimals and the quantity value is too large, such as adding decimal positions that would cause an overflow on the nondecimal portion of the quantity.

  • Converts only P and Q type records on the Rules Table Detail table and the Assembly Inclusions Rules table.

    Note: You should understand the changes that this program makes to the system and the existing data before you run this program. Because of the way that the system stores numeric values in Microsoft Access databases, you should not run this program for any Access tables.