Sales Order Management Affected by the Conversion

The base currency conversion programs in Oracle's JD Edwards EnterpriseOne Sales Order Management, unlike those in Oracle's JD Edwards EnterpriseOne Procurement, convert the unit price and then use the converted unit price to recalculate the extended price.

The conversion programs were specifically designed to convert the unit price:

• To minimize rounding issues in the Sales Order Detail File (F4211).

  The number of decimal positions stored for unit amounts, such as UPRC (Amount-Price per Unit), is determined by the data dictionary and is typically 4 decimal places, whereas the number of decimal positions stored for extended amounts, such as AEXP (Amount-Extended Price), is determined by the currency decimals and is typically 0 to 3 decimal places. Converting the unit price instead of the extended price helps minimize rounding issues.

• To maintain consistency with programs in JD Edwards EnterpriseOne Sales Order Management.

  For example, when you enter a foreign currency order, the entry program converts the domestic unit price to the foreign price and then extends out the foreign price. The conversion programs for JD Edwards EnterpriseOne Sales Order Management convert amounts in the same way.

• To avoid possible rounding issues in the Price Adjustment Ledger File table (F4074).

  Price adjustments are applied to the unit price, with the net price extended out to the extended price. If the conversion program recalculated the unit price based on a converted extended price instead, the potential for rounding issues would increase between the unit prices in the F4211 and F4074 tables.