E1: DD: Display Decimals Update for Data Item Class QTYINV and Data Dictionary Item QNTY (Doc ID 626475.1)

Last updated on DECEMBER 10, 2024

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.

Purpose

The following explains the functionality of the Display Decimals Update for Data Dictionary items belonging to data item class QTYINV (Inventory Quantities) and for Data Dictionary item QNTY (Bill of Materials).

Display Decimals Definition

Display decimals define how many decimal places are placed to the right of the decimal point when a numeric variable is displayed or used in a calculation. It is defined for numeric data dictionary items and can be set from zero (0) to eight (8).

How Data is Stored and Displayed Based on the Display Decimals Defined for the Data Dictionary Item in P92001

How data is stored and displayed is best explained in the screen-print example below for the input number 1.2345.

The decimal shifting occurs provided the Decimal Shift flag in the Database Data Source definition is turned ON for both System and Server Map data sources. It should be turned ON for EnterpriseOne tables residing in SQL, Oracle and DB2/400 databases, (all databases except for Microsoft Access databases). Go to GH9011 > Database Data Sources > Select Data Source System - xx. Find & select any Data Source name e.g. Business Business - Test. Goto Form > Advanced. "Use Decimal Shift" box is checked.

This document details how to update the display decimals for Data Dictionary items belonging to data item class QTYINV (Inventory Quantities) and for Data Dictionary item QNTY (Bill of Materials).

Scope

This document is intended for the EnterpriseOne Data Dictionary administrator who will be responsible for making these type of data dictionary display decimal changes.