Configuring the Sales Order Management System

This chapter provides an overview of system configuration for Sales Order Management and discusses how to:

Set up user-defined codes (UDCs).
Set up constants.
Set up automatic accounting instructions (AAIs) for Sales Order Management.
Set up order line types.
Set up order activity rules.

Understanding System Configuration for Sales Order Management

Before you use JD Edwards EnterpriseOne Sales Order Management, you need to define certain information that the system uses during processing. You use this information to configure the system to meet the company's business needs.

This table describes the information that you must set up for this system:

Setup Information	Description
UDCs	You can set up UDCs to configure the system for order processing.
Constants	You set up constants to provide the system with these types of default information: System constants determine which functions to perform. Batch control constants determine whether an application requires management approval and batch control. Branch/plant constants control day-to-day transactions within a branch/plant. Location format determines how you identify item storage locations in a branch/plant. Item availability defines how the system calculates the number of items that each branch/plant contains.
Order line types	You can define codes that determine how the system processes a detail line in an order.
Order activity rules	You can establish the sequence of steps to process an order.
AAIs	You set up AAIs to provide JD Edwards EnterpriseOne Sales Order Management with accounting information and general ledger relationships that are necessary to interact with JD Edwards EnterpriseOne General Accounting.

Setting Up UDCs

This section provides an overview of each UDC that you should set up for JD Edwards EnterpriseOne Sales Order Management.

UDCs enable you to configure the way the system operates. You must add these code types in the UDC tables.

Auto TP Rollback Level - (00/AT)

Enter a value of 1 in the Special Handling field of this UDC to temporarily place data in the Transaction Workfile table (F41021WF). The system updates the data into the Item Location File table (F41021) and deletes data from the Transaction Workfile table after the commitment is successful.

See Understanding Transaction Processing.

Status Codes for Prepayments (00/SP)

You use status codes to determine the status of a prepayment. These statuses, which are hard-coded, have been predefined:

Blank: Pre-authorization
01: Sent for Authorization
02: Authorized
03: Ready to Settle
04: Sent for Settlement
05: Settled
06: Authorization Declined/Error
07: Settlement Declined/Error

Payment Instruments (00/PY)

To identify transactions for prepayment processing, you must use payment instruments that are assigned special handling codes. These payment terms are listed according to whether they are hard-coded. You should not change hard-coded codes.

Hard-coded codes include:

X: Use electronic data interchange (EDI) Remote Draft (AR & AP).
Y: Use EDI Remote Wire (AR & AP).
Z: Use EDI Remote Check (AR & AP).
?: Use credit card payment.

Soft-coded codes include:

C: Check - 8 3/4 (AR & AP).
D: Draft by invoice (AR & AP).
N: Print Check - Brazil.
T: Electronic funds transfer (EFT) (AR & AP).
W: Check - 8 1/2 (AR & AP).

Prepayment Special Handling Codes for 00/PY

Prepayment processing is driven by values in the special handling code column for the payment instrument type. That is, if you set up a handling code for a payment type, the system processes the transaction through the authorization and settlement cycle. JD Edwards EnterpriseOne has predefined payment types with these special handling codes:

11: Cash payment
12: Check payment
13: Credit card payment

Blanket/Quote Order Types (40/BT)

You use this UDC table to specify which order types are used to designate blanket orders and quote orders.

On Hand Quantity Relief (40/IU)

You use this UDC table to specify whether on-hand inventory for an order type is relieved during Shipment Confirmation (P4205). If no code is set up in this table, on-hand inventory is relieved when you run Sales Update (R42800).

Order Templates (40/OT)

Before you can create an order template, you must add the template name to this UDC table. If you do not add the template to this table, you cannot set up the template using the Customer Template Revisions form (P4015).

Cross Reference Type Code (41/DT)

You use this UDC table to specify different cross-reference types, such as substitutes, complimentary items, and replacement items. These codes are also used to reference customer or supplier part numbers. To leverage these codes, you must enter cross-reference codes for items using the Item Cross Reference program (P4104).

Hold Codes (42/HC)

JD Edwards EnterpriseOne provides you with a default code AH (Approval Hold), which is set up in UDC (42/HC), to use for approval processing. You can add other approval hold codes provided that you specify a special handling code of 1.

Setting Up Constants

This section provides an overview of constants for Sales Order Management, lists prerequisites, and discusses how to:

Set up branch/plant constants.
Set up item availability.
Set up system constants.
Set up batch control constants.
Set up location formats.
Set up locations in branch/plants.

Understanding Constants for Sales Order Management

A constant is a piece of information that you set up to define how the system processes information. The system uses constants as default information in many JD Edwards EnterpriseOne systems. After you determine the information to use throughout the system, you can enter the appropriate values or change any predefined values.

Branch/plant constants enable you to configure the processing of daily transactions for each branch/plant in the distribution and manufacturing systems.

Note. If you use Oracle's JD Edwards EnterpriseOne Warehouse Management, you must define the warehouse information on the Branch Location Definition form of the Branch/Plant Constants program (P41001). Otherwise, you should at least define location length information.

Item Availability

You must define how to calculate item availability for each branch/plant. Item availability affects how the system calculates back orders, cancelations, and customer delivery times.

Note. If you use Oracle's JD Edwards EnterpriseOne Configurator, you must set the Check Availability field in Configurator Constants (P3209) to check availability during sales order entry. If the system finds the exact item and string match, a window displays all locations containing the specific configuration.

System Constants

You define system constants to determine which functions to perform. For example, assume that you have several branch/plants and you use different units of measure for the items in each branch/plant. You can set a system constant to automatically convert units of measure by branch.

System constants apply to all branch/plants. You cannot configure the settings for each branch/plant.

Batch Control Constants

You define batch control constants to prevent the system from applying changes that unauthorized personnel make to the general ledger. Also, you can define a constant that requires you to enter batch control information before the system runs a batch-processing job. You might enter batch control information to compare the anticipated size of the job to the end result.

You must define management approval and batch control separately for each distribution and manufacturing system that you use.

Location Control

You can designate location information that is specific to each branch/plant. In each branch/plant, you can set up unique information about specific item locations.

Location control is a JD Edwards EnterpriseOne feature that you activate through the branch/plant constants. Location control is required for JD Edwards EnterpriseOne Warehouse Management, but optional for all other JD Edwards EnterpriseOne distribution systems from Oracle.

Location Format

Defining the location format enables you to determine how to set up item locations. You can define elements that contain more specific information about the actual location. For example, an element can represent an aisle, bin, shelf, or any other location that you use in a branch/plant.

You can define a location format using up to 10 different elements, such as aisle, shelf, and bin. For each element, you can define:

Length

The total length of all elements, including separators, cannot exceed 20 characters. The system does not store separators in the tables, but uses separators to edit a location on a form or report. If you do not want to use separators, leave the separator field blank. The system displays the location as one string of characters.
Justification
Separator character

If you are using JD Edwards EnterpriseOne Warehouse Management, you must also define default units of measure for volumes, dimensions, and weights.

Locations in Branch/Plants

After you have defined the format for the locations, you must define all of the locations in a warehouse. To locate items more easily, you can create a hierarchy of locations within the warehouse and enter information about zones.

You can define a primary location to store basic information about items in a warehouse. A primary location is not an actual physical location. For example, you could designate a primary location as Location A and then assign every item in the warehouse to a location that begins with A.

You can also define a blank location as the primary location for inventory items. How the system displays the primary location depends on the location format specifications that you define for the branch/plant.

Prerequisites

Before you complete the tasks in this section:

Create an address book record for the branch/plant.
Set up a branch/plant named ALL.
Set up the branch/plant as a business unit.

Forms Used to Set Up Constants

Form Name	FormID	Navigation	Usage
Work With Branch/Plant Constants	W41001B	Sales Order Management Setup (G4241), Branch/Plant Constants	Review and select branch/plant constant records.
Branch/Plant Constants	W41001H	Click Add on the Work With Branch/Plant Constants form.	Set up branch/plant constants. Add and revise branch/plant constant records.
Item Availability Definition	W41001G	Select the branch/plant constant record, and then select Availability from the Row menu on the Work With Branch/Plant Constants form.	Set up item availability. Add and revise item availability definitions.
System Constants	W41001F	Select Sys. Constants (system constants) from the Form menu on the Work With Branch/Plant Constants form.	Set up system constants. Add and revise system constants.
Application Constants	W41001E	Select App. Constants (application constants) from the Form menu on the Work With Branch/Plant Constants form.	Set up batch control constants. Add and revise batch control constants.
Branch Location Definition	W41001A	Select the branch/plant constant record, and then select Location Def. (location definition) from the Row menu on the Work With Branch/Plant Constants form.	Set up location formats. Add and revise location definitions.
Enter Location Information	W4100B	Select the branch/plant constant record, and then select Locations from the Row menu on the Work With Branch/Plant Constants form.	Set up locations in branch/plants. Add and revise location information for branch/plant.

Setting Up Branch/Plant Constants

Access the Branch/Plant Constants form.

Short Item Number Identifier

Enter a symbol to identify the eight-character short item number when you do not want to use it as the primary number.

Leave this field blank if you want to use this item number as the primary number. That is, you use it most often to enter or review information.

If this is not the primary number, you must enter a special symbol to identify it. Use a symbol that is not significant for any other purposes of entry, such as /, *, or &. Do not use a period or a comma as a symbol. When you enter this item number on any other form, you must include this symbol as the first character.

Note. Only one of the fields for item number symbols (SYM1, SYM2, SYM3, or SYM6) can be blank to identify it as the primary number. All others must include a unique symbol.

Symbol Customer/Supplier

Enter a character that identifies the customer's or supplier's number in the system. When you enter a number preceded by this character, the system recognizes the number as the customer's or supplier's number. The system then uses the cross-reference table to match the number to the item number. You must complete this field if you want the system to perform cross-referencing.

Commitment Method

Specify the method that the system uses to commit lot items from inventory. Values are:

1: Normal commit method. The system commits inventory from the primary location and then from secondary locations.

2: Commit method by lot number. The system commits inventory by lot number, starting with the lowest lot number and committing orders to available lots.

3: Commit method by lot expiration date. The system commits inventory from the locations with the earliest expiration date first. The system considers only locations with expiration dates that are greater than or equal to the sales order or parts list requested date.

Number of Days in Year

Enter the number of days in a year that the company is open for business. This field is required. You must specify a number from 252 to 365. The JD Edwards EnterpriseOne Procurement system uses this number to calculate the Economic Order Quantity (EOQ).

Purchasing

Enter a UDC (40/CM) that indicates the cost method that the system uses to determine the cost of the item for purchase orders. Cost methods 01–19 are reserved.

Sales/Inventory Costing Method

Enter a UDC (40/CM) that indicates the cost method that the system uses to calculate the cost of goods sold for the item. Cost methods 01–19 are reserved.

Interface G/L (Y/N) (interface general ledger (yes/no))

Select to indicate that inventory transactions that are processed through this branch/plant create general ledger entries.

Write Units to Journal Entries (Y/N) (write units to journal entries (yes/no))

Specify whether the system moves units to the general ledger after the system records a journal entry from these programs:

P31111 (Work Order Inventory Issues)

P31112 (Work Order Completions)

P31802 (Work Order Journal Entries)

P4112 (Inventory Issues)

P4113 (Inventory Transfers)

P4114 (Inventory Adjustments)

P4116 (Item Re-Classification)

P41413 (Cycle Count Update)

P41610 (Tag Update)

R42800 (Sales Update)

P4312 (Receipts)

P4314 (Voucher Match)

P415021 (Update Operational Reconciliation)

P415101 (General Stock Movements)

P41514 (Bulk Manufacturing Gains/Losses)

R49700 (Cycle Billing)

P49510 (Bulk Load Confirmation - XT49799)

P49515 (Bulk Load Confirm Batch - XT49799)

P49530 (Package Load Confirm - XT49799)

P49572 (Upload Gantry Data - XT49799)

P49710 (Bulk Delivery Confirm - XT49799)

P49711 (Bulk Delivery Confirm Milk Run - XT49799)

P49715 (Bulk Disposition - XT49799)

P49720 (Package Delivery Confirm - XT49799)

P49731 (Mass Confirm Batch - XT49799)

Location Control (Y/N) (location control (yes/no))

Select to indicate that the system uses only locations in the Location Master table (F4100). You use location control to use only locations that are in the F4100 table. When the Warehouse Control option is selected, the Location Control option must also be selected. Clear the option and the system does not restrict locations to those in the F4100 table. The system uses all locations that conform to the location format that are defined on the Branch Location Definition form.

Warehouse Control (Y/N) (warehouse control (yes/no))

Specify whether the system creates warehouse transactions for the branch/plant.

Quality Control (Y/N) (quality control (yes/no))

Specify whether to activate the JD Edwards EnterpriseOne Quality Management system from Oracle (system 37) for the branch/plant.

Use Product Cost Detail (Y/N) (use product cost detail (yes/no))

Specify whether distribution programs use total cost or detailed product costs.

Foreign Depot

Specify whether another company owns the branch/plant. The Bulk and Packed Load Confirmation programs use this code to determine whether the depot from which product is being loaded is a foreign depot. If it is a foreign depot, you must enter a valid borrow agreement during load confirmation.

Inventory Lot Creation (Y/N) (inventory lot creation (yes/no))

Specify whether the inventory transaction programs can create new lot or serial numbers in the system. If you leave this option cleared, the system will not allow the inventory transaction programs to create new lot numbers in the system. If you select this option, the system allows the inventory transaction programs to create new lot numbers in the system.

Current Inventory Period

Enter 1 to 14 to identify the current accounting period. The system uses this number to generate error messages, such as PBCO (posted before cut off) and PACO (posted after cut off).

Purchase Order Issue Cost

Enter the amount that JD Edwards EnterpriseOne Procurement uses to calculate the EOQ. This cost should be the estimate of the cost of materials, labor, and overhead that you incur when you issue a single purchase order. The default value is 00.

This example illustrates how the system calculates EOQ using the Purchase Order Issue Cost method:

S: Purchase Order Issue Cost = 15.0

I: Inventory Carrying Cost = .09 (9 percent)

Y: Annual Sales in Units = 3,000

C: Unit cost of Item = 10.0

EOQ = the square root of ((2S/I) × (Y/C))

The square root of [(2)(15) ÷ 0.09] × 3,000 ÷ 10.0 = 316.23

Inventory Carrying Cost (%) (inventory carrying cost (percent))

Enter the percentage of inventory investment that JD Edwards EnterpriseOne Procurement uses to calculate EOQ. The default value is .00. Enter the percentage as a decimal value.

This example illustrates how the system calculates EOQ using the Inventory Carrying Cost Percentage:

S: Purchase Order Issue Cost = 15.0

I: Inventory Carrying Cost = .09 (9 percent)

Y: Annual Sales in Units = 3,000

C: Unit Cost of Item = 10.0

EOQ = Square root of ((2S/I) × (Y/C)) = the square root of (2(15) ÷ .09)) × (3000 ÷ 10) = 316.23

Note. Access field help for the Economic Order Quantity field for more information about the EOQ formula.

General Ledger Explanation

Enter a code that the JD Edwards EnterpriseOne Inventory Management system uses to select the default description that appears on the second line of a journal entry in the general ledger. Values are:

1: Item master description (default value).

2: Primary item number.

Setting Up Item Availability

Access the Item Availability Definition form.

To specify items to exclude from the item availability calculation, click any of the options under the Subtract heading. To specify items to include in the item availability calculation, click any of the options under the Add heading.

Quantity Soft Committed to SO & WO (quantity soft committed to sales order and work order)	Select to indicate that the number of units that are soft-committed to sales orders or work orders are to be included in the item availability calculation.
Quantity Hard Committed to SO (quantity hard-committed to sales order)	Select to indicate that the number of units that are hard-committed to a specific location and the lot for sales orders are to be included in the item availability calculation.
Quantity Future Committed to SO (quantity future committed to sales order)	Select to include the quantity on any sales order in which the requested shipment date is beyond the specific commitment days.
Quantity Hard Committed to WO (quantity hard-committed to work order)	Select to indicate that the number of units that are hard-committed to a specific location and the lot for work orders are to be included in the item availability calculation.
Other Quantity 1 SO (other quantity 1 sales order)	Select to include the quantity specified as an additional reduction in the item availability calculation.
Other Quantity 2 SO (other quantity 2 sales order)	Select to include this quantity as an additional reduction in the item availability calculation.
Quantity on Hold	Select to include the number of units on hold in the item availability calculation.
Safety Stock	Select to include the number of units that are reserved as safety stock in the item availability calculation.
Quantity on Purchase Order Receipts	Select to include the number of units on purchase orders in the item availability calculation.
Quantity on PO - Other 1 (quantity on purchase order - other 1)	Select to indicate that the number of units on other purchase orders are to be included in the item availability calculation.
Quantity on Work Order Receipts	Select to include the number of units on work orders in the item availability calculation.
Quantity in Transit	Select to include the number of units in transit in the item availability calculation.
Quantity in Inspection	Select to include the number of units in inspection in the item availability calculation.
Quantity in Operation 1	Select to include the number of units in one operation of the receipt routing process in the item availability calculation. You define which operation from receipt routing corresponds to this field.
Quantity in Operation 2	Select to include the number of units in one operation of the receipt routing process in the item availability calculation. You define which operation from receipt routing corresponds to this field.

Setting Up System Constants

Access the System Constants form.

Unit of Measure Conversion by Branch

Select to display the item-specific conversion table when you add an item to a specific branch/plant. Clear this option and the system displays the item-specific conversion table for all branch/plants from the Item Master table.

Update Average Cost On-Line

Select to calculate a new average cost immediately after any transaction occurs that affects the average cost of an item.

Clear to indicate that all processes that affect average cost create transactions to the Average Cost Work File table (F41051). The system calculates a new average cost when you run the Average Cost Update program (R41811).

ECS Control (energy and chemical system control)

Select to use the JD Edwards EnterpriseOne Bulk Stock Inventory system.

Internet Enable PPAT Messages (internet enable people places and things messages)

Select to send any email messages that are generated by distribution programs.

Scientific Rounding

Select to perform scientific rounding.

Currently, this feature is enabled only for Quality Management Test Results.

Use Customer Set

Select to use the customer set feature.

Ship Ascending Date Rule

Select to apply the ship ascending date rule by customer and by item during the sales order entry, pick slip/commitment processing, and ship confirmation processes. When the system applies the Ship Ascending Date rule, the system sorts shipping customers' lots in ascending order by expiration date, sell by date, or best before date.

Allow Duplicate Lots

Enter a value to determine whether the system assigns the same lot to multiple items. Values are:

1: The system does not allow duplicate lots. The lot is restricted to one item and one branch/plant.

2: The system allows duplicate lots. You can create a lot that contains multiple items and branch/plants.

3: The system does not allow duplicate lots. The lot is restricted to one item, but can contain quantities in multiple branch/plants.

Sales Price Retrieval UOM (sales price retrieval unit of measure)

Enter a code that specifies the unit of measure for retrieving base prices and price adjustments for sales order processing, service and warranty management, and ship and debit processing. The system enables users to define base prices in the Item Base Price File table (F4106) and price adjustments in the Price Adjustment Detail table (F4072) in various units of measure.

If the base price or price adjustments are not found in the specified unit of measure, the system uses the primary unit of measure for the item.

Purchase Price Retrieval UOM (purchase price retrieval unit of measure)

Enter a code that represents the unit of measure for the purchase base price during purchase order processing.

If you specify the unit of measure for transaction or pricing and the system does not find a record in that unit of measure, the system repeats the process using the primary unit of measure of the item.

Sales Price Based On Date

Enter a code that determines how the system updates the price effective date in the Sales Order Header File table (F4201) and Sales Order Detail File table (F4211). In JD Edwards EnterpriseOne Sales Order Management, the system uses the price effective date to retrieve the base price from the F4106 table and price adjustments from the F4072 table.

Purchase Rebate Category Code

Enter a number that determines which category code the system uses in the criteria for inclusion comparison.

Preference Schedule

Enter a UDC (40/AS) that identifies the advanced preference schedule that the system uses when resolving preferences. The advanced preference schedule determines which preferences the system resolves when using the advanced preference functionality. You cannot maintain preference schedules directly through UDCs, but you can maintain preference schedules by using the Price Adjustment Schedule program (P4070).

Pref Retrieval UOM (preference retrieval unit of measure)

Enter a code that specifies the unit of measure that the system uses for retrieving advanced preference adjustments during sales order processing. The system enables you to define the advanced preference adjustments in the F4072 table in various units of measure.

If you specify the unit of measure for transaction or pricing and the system does not locate a record in that unit of measure, the system repeats the process using the primary unit of measure of the item.

Setting Up Batch Control Constants

Access the Application Constants form.

System Code

Enter a UDC (98/SY) that identifies a system. Values are:

01: JD Edwards EnterpriseOne Address Book

03B: JD Edwards EnterpriseOne Accounts Receivable

04: JD Edwards EnterpriseOne Accounts Payable

09: JD Edwards EnterpriseOne General Accounting

11: JD Edwards EnterpriseOne Multicurrency from Oracle

Mgmt Apprv (management approval)

Enter a code that indicates whether you require approval of batches before they can be posted to the general ledger. Values are:

Y: Yes, assign a status of Pending to each batch that you create within the listed systems.

N: No, assign a status of Approved to each batch.

Batch Ctrl (batch control)

Enter a code that indicates whether to require entry of batch control information.

For each batch, the system displays a batch control form on which you must enter information about the number of documents and the total amount of the transactions that you expect in the batch. The system uses these totals to edit and display differences from the actual transactions that you entered. This field applies only to JD Edwards EnterpriseOne Inventory Management and JD Edwards EnterpriseOne Procurement. In JD Edwards EnterpriseOne Inventory Management, Y indicates that the system displays a batch control form before you issue, adjust, or transfer inventory.

In JD Edwards EnterpriseOne Procurement, Y indicates that the system displays a batch control form before you enter receipts. Values are:

Y: Yes, require entry of batch control information.

N: No, do not require entry of batch control information.

Setting Up Location Formats

Access the Branch Location Definition form.

Location Format Specification

Select the Location Format Specification tab.

Location Separator Character	Enter a character that divides the elements of the location when you display them on forms or reports. For example, you might use a / as a separator character to divide elements such as aisle, bin, and shelf in a location code. The location code can contain up to 20 characters, including separators. Separators are not stored in the tables, but are used to edit a location on a form or report. If you do not want to use separators, leave this field blank. However, you must enter characters and spaces to equal the correct length of each element in the location code. The system then displays the location as one string of characters. The system uses the character that you enter in this field to separate the combination of tank/owner and aisle/bin as it appears on forms or reports. Companies commonly use a . (period) as the separator character.
Aisle	Enter a number that identifies the number of characters to represent the tank (or aisle for packaged stock). Values are numbers 1 through 8.
Bin	Enter a number that identifies the number of characters to represent the owner for commingled bulk stock (or bin for packaged stock). Values are numbers 1 through 8.
Code 3 through Code 10	Enter the number of characters to represent codes 3 through 10, respectively, in the location format specification.

Warehouse Control

Select the Warehouse Control tab.

If you do not use JD Edwards EnterpriseOne Warehouse Management, do not complete the fields on the Warehouse Control tab.

Request Inclusion Version	Enter a code (UDC 40/RV) that identifies an inclusion rule to use for this branch/plant. JD Edwards EnterpriseOne Manufacturing systems from Oracle and JD Edwards EnterpriseOne Warehouse Management use inclusion rules in this way: For JD Edwards EnterpriseOne Manufacturing systems, enable multiple versions of resource rules for running Material Requirements Planning (MRP), Master Production Schedule (MPS), or Distribution Requirements Planning (DRP). For JD Edwards EnterpriseOne Warehouse Management, enable multiple versions of inclusion rules for running putaway and picking. The system processes only those order lines that match the inclusion rule for a specified branch/plant.
Dimension Unit of Measure	Enter a UDC (00/UM) that identifies the unit of measure to display dimensions for the warehouse. The system enables you to establish inches, centimeters, meters, and so forth as a measuring standard.
Receiving Location	Enter the area in the warehouse where you receive inventory. The format of the location is user-defined and you enter the location format for each branch/plant.
Shipping Location	Enter the location that the system uses as the default value when you pick inventory and move the inventory for shipping. The format of the location is user-defined by Branch/Plant Constants.

Setting Up Locations in Branch/Plants

Access the Enter Location Information form.

You can set up locations for branch/plants after you have defined the location format for the branch/plant.

Location	Enter the area in the warehouse where you receive inventory. The format of the location is user-defined and you enter the location format for each branch/plant. A location format comprises elements and, optionally, a separator character. Elements represent more specific locations in a branch/plant. If the tank contains commingled stock, include the separator character that is defined on the Branch Location Definition form and identify the owner. The total length of all elements in this field, including separators, cannot exceed 20 characters. The location for a single tank can contain up to the number of characters identified in the fields in which you specify the aisle information on the Branch Location Definition form. The owner ID can contain up to the number of characters identified in the fields in which you specify the bin information on the Branch Location Definition form. If you leave this field blank and do not use a separator character, the system displays the location as an asterisk. If you use a separator character, the system displays the location with the correct number of spaces for each element, followed by the separator character.
Pick Zone	Enter a UDC (46/ZN) that identifies an area from which items are picked for shipment.
Put Zone (putaway zone)	Enter a UDC (46/ZN) that identifies areas in the warehouse where goods are put away or stored.
Replen Zone (replenishment zone)	Enter a UDC (46/ZN) that identifies replenishment zones, which are areas in the warehouse from which items are retrieved to replenish or refill picking locations. You assign zones to locations using Location Master.
LOD (level of detail)	Enter a code that summarizes or classifies locations and provides a hierarchy of locations for review purposes. For example, you can assign aisles to level 2, and individual bins within the aisle to level 3. Use the Detail Level field to specify the beginning level of detail that you want the system to display for the location.
Aisle	Enter a code that identifies a location in a warehouse. This code is used in conjunction with a bin and lot identifier to indicate a specific, tangible storage area within a warehouse or yard.
Bin	Enter a specific storage location within a warehouse or store. The system uses the bin with an aisle location to identify a storage area for which width, depth, and height can be readily measured.
Loc 03 (location 03)	Enter a code that the system uses for one of two purposes: To identify a specific location within a branch/plant as part of the location identifier. To use as a general reporting code for location information.

Setting Up AAIs for Sales Order Management

This section provides an overview of AAIs for Sales Order Management and discusses how to set up AAIs for Sales Order Management.

Understanding AAIs for Sales Order Management

AAIs are the links between the day-to-day functions, chart of accounts, and financial reports. The system uses AAIs to determine how to distribute amounts that are associated with general ledger (GL) entries that the system generates. For example, in JD Edwards EnterpriseOne Sales Order Management, AAIs specify how to record the journal entries that are associated with transactions such as selling a stock item to a customer.

For JD Edwards EnterpriseOne distribution systems, you must create AAIs for each unique combination of company, transaction, document type, and GL class that you anticipate using. Each AAI is associated with a specific GL account that consists of a business unit, an object, and optionally, a subsidiary.

If you are required to collect taxes on customer invoices, you must distribute the tax amounts to the correct GL accounts. When you set up AAIs for a specific type of tax, such as VAT or use tax, you designate which accounts you want to debit and credit for an invoice tax amount.

The system stores AAIs in the Distribution/Manufacturing - AAI Values table (F4095).

Search Sequence for AAIs

You set up AAI tables so that the system can assign account numbers to sales order transactions and account for the amounts that are associated with those transactions in the general ledger. Most organizations set up separate account numbers for each company within their organization. However, some use the same account numbers for each company. If you do not want to set up separate accounts for each company, you can set up account information for the default company, company 00000. The system searches for account numbers in this order:

The system first searches for a match on order company, order type, and general ledger category code.
If no match is found, the system searches for a match on order company, order type, and general ledger category code of **** (wildcard).
If no match is found, the system searches for a match on company 00000, order type, and general ledger category code.
If no match is found, the system searches for a match on company 00000, order type, and general ledger category code of **** (wildcard).
If no match is found, the system produces an error notifying the user that the AAI is not set up.

If an organization uses product detailed costing in addition to the fields Order Company, Order Type, and the G/L Category Code, then the system also includes Cost Type in the search for an account. This applies to the sales AAIs 4220 and 4240.

In addition, the Flexible Sales Accounting Setup (G4241) menu allows users further flexibility in defining the Business Unit, Subsidiary, and Subledger fields based on other driver fields in the F4211 table.

AAIs for Sales Order Management

This table describes the AAIs to set up for JD Edwards EnterpriseOne Sales Order Management:

AAI	Description
Cost of Goods (COGS) Sold (4220)	Provides the expense or cost amount to the cost of goods sold account.
Deferred Cost of Goods Sold (4221)	Used when Cycle Billing/Periodic Invoicing is being used.
Cost of Goods Sold - Accommodations (4222)	Used when loan agreement is in effect for bulk items on the transaction and Cycle Billing is not used.
Deferred Cost of Goods Sold - Accommodations (4223)	Used when loan agreement is in effect for bulk item on the transaction and Cycle Billing/Periodic Invoicing is being used.
Revenue (4230)	Provides the actual sales price of inventory in the sales revenue account.
Deferred Revenue (4231)	Used when Cycle Billing/Periodic Invoicing is being used.
Unbilled A/R Credit (4232)	Used when Cycle Billing/Periodic Invoicing is being used.
Allocated Revenue (4233)	Used to write additional allocated revenue entry when Freight Allocations by Item is set up from the JD Edwards EnterpriseOne Transportation Management system (determined at the time of Transportation Freight Update) and some or all of the total freight charge for a shipment is distributed to the existing sales order line items.
Inventory (4240)	Credits the cost amount to an inventory account.
Inventory In Transit (4241)	Used for load confirmed lines in place of 4240 AAI.
Accommodations (4242)	Used for bulk item transactions that have borrow agreements set up for Accommodations (B/P constants—select the Foreign Depot and Interface G/L check boxes.
A/R Trade (4245)	Debits the sales amount to an accounts receivable account. The system writes the accounts receivable offset entries to the general ledger only if the accounts receivable update option is deactivated.
Tax Liability (4250)	Provides journal entries to tax liability accounts that were created during a sales update.
Price Adjustments (4270)	Provides the journal entries for individual price adjustments that were created during a sales update.
Rebates Payable (4280)	Provides the offset entries of accrued accounts.
Ship and Debit (4234)	Adjusts the profit margins that are affected by ship and debit agreements.

The Account Revisions form of the Distribution AAIs program (P40950) displays each predefined AAI item and information about the document type, GL class, and accounts that are affected by transactions.

Forms Used to Set Up AAIs for Sales Order Management

Form Name	FormID	Navigation	Usage
Work With AAIs	W40950B	Sales Order Management Setup (G4241), Automatic Accounting Instructions	Review and select AAI tables.
Account Revisions	W40950D	Select an AAI table, and then select Details from the Row menu on the Work With AAIs form.	Set up AAIs for Sales Order Management. Add and revise account information for the selected AAI table.

Form Name

FormID

Navigation

Usage

Work With AAIs

W40950B

Sales Order Management Setup (G4241), Automatic Accounting Instructions

Review and select AAI tables.

Account Revisions

W40950D

Select an AAI table, and then select Details from the Row menu on the Work With AAIs form.

Set up AAIs for Sales Order Management.

Add and revise account information for the selected AAI table.

Setting Up AAIs for Sales Order Management

Access the Account Revisions form.

Setting Up Order Line Types

This section provides an overview of order line types and discusses how to set up order line types.

Understanding Order Line Types

When you enter detail information for a sales or purchase order, you enter the quantity, price, and cost for each item or service. You can also enter a credit item, a nonstock item, and text information in the same sales or purchase order.

Each entry is a line. A line is the information for an item or service that you are ordering as it pertains to the order. The system processes each line based on a line type.

A line type is a code that the system uses to process each detail line that you enter for a specific order type. For example, you can specify line type S for stock items. The system determines whether it should increase or decrease the quantity of the item in inventory. You can specify line type F for freight charges. The system determines from the definition of the line type that this item is not an inventory item.

You can specify how the system uses line types in the general ledger and within JD Edwards EnterpriseOne Inventory Management. For example, when you purchase or sell an inventory item, you might assign a line type for stock items. The system records the transaction according to the information that you specified for the line type. In this case, the system reflects the cost or price of the item in the general ledger. The transaction line also affects item availability in JD Edwards EnterpriseOne Inventory Management.

The line types that you define are applicable throughout distribution systems. For example, the system processes line types in the same way for JD Edwards EnterpriseOne Sales Order Management as it processes line types for JD Edwards EnterpriseOne Procurement.

Adding a Message Using a Text Line Type

During order entry, you can enter a message on an order detail line by using a text line type. For example, you can enter an order detail line for a stock item, such as a bike, and then enter an order detail line for text, such as Some Assembly Required. This order detail line functions like a message. Based on the line type definition, the information in an order detail line with a line type that is denoted by the text feature is a memo-only line. The system does not verify the information in the item field, which is the message, against information in the Item Branch File table (F4102) and the transaction does not interact with any other JD Edwards EnterpriseOne systems, such as JD Edwards EnterpriseOne Accounts Receivable and JD Edwards EnterpriseOne Accounts Payable.

Assigning a Line Type for Nonstock Items

You can set up the line type for nonstock items so that the system retrieves information from the Item Master but does not commit quantities. The Edit Item Master for Non-Stock Items option controls whether the system validates the sales order line's item against the Item Master table (F4101). This option is used only with nonstock inventory interfaces.

During order entry, the system verifies the item number in the F4102 table and the cost and price information in the Item Cost File table (F4105) and Item Base Price File table (F4106). However, the system does not create commitments or perform availability checks.

Forms Used to Set Up Order Line Types

Form Name	FormID	Navigation	Usage
Work With Line Types	W40205A	Sales Order Management Setup (G4241), Order Line Types	Review and select order line type records.
Line Type Constants Revisions	W40205B	Click Add on the Work With Line Types form.	Set up order line types. Add and revise order line type records.

Form Name

FormID

Navigation

Usage

Work With Line Types

W40205A

Sales Order Management Setup (G4241), Order Line Types

Review and select order line type records.

Line Type Constants Revisions

W40205B

Click Add on the Work With Line Types form.

Set up order line types.

Add and revise order line type records.

Setting Up Order Line Types

Access the Line Type Constants Revisions form.

Inv. Interface (inventory interface)	Enter a code that specifies how the system interacts with the JD Edwards EnterpriseOne Inventory Management system for order lines with the specified line type. Values are: Y: The monetary or unit value of any activity containing this line type is reflected in inventory. The system also edits the item that you enter to ensure that it is a valid item. This is the default value. A: The system recognizes the number that you enter as a GL account number. The system uses this code in purchasing only. B: The system performs edits when using format 4 in purchase order entry. The system retrieves price data from the inventory tables, but does not update the quantity on the purchase order. This code is valid only when you have set the G/L Interface field to Y (yes). Budget checking is fully functional when you use this interface code. D: The item in this line is an inventory item that does not affect availability or quantities. N: The item is not an inventory item. To verify whether the item exists in the F4101 table, use Inventory Interface N in conjunction with the option Edit Item Master for Non-Stock Item.
G/L Offset (general ledger offset)	Enter a UDC (41/9) that identifies the GL offset for the account to which the system posts the transaction. If you do not want to specify a class code, enter **** (four asterisks) in this field. You can use AAIs to predefine classes of automatic offset accounts for JD Edwards EnterpriseOne Inventory Management, JD Edwards EnterpriseOne Procurement, and JD Edwards EnterpriseOne Sales Order Management. You might assign GL class codes in this way: IN20 Direct Ship Orders. IN60 Transfer Orders. IN80 Stock Sales. The system can generate accounting entries based on a single transaction. For example, a single sale of a stock item can trigger the generation of accounting entries similar to this: Sales-Stock (Debit) xxxxx.xx. A/R Stock Sales (Credit) xxxxx.xx. Posting Category: IN80. Stock Inventory (Debit) xxxxx.xx. Stock COGS (Credit) xxxxx.xx. The system uses the class code and the document type to find the AAI.
Include in Tax 1	Enter a code that indicates whether the monetary value of this order line is subject to applicable taxes and which taxes to apply. Values are: Y: The line is subject to applicable taxes. N: The line is not subject to applicable taxes. 3–8: Yes, the line is subject to applicable taxes at the rate indicated by the group number (3–8). The system uses group numbers for value-added tax.
Sales Journal Col (sales journal column)	Enter a value to indicate which of the four columns on this line receives the sales value. Values are: 1: Column 1 receives the sales value (if any). 2: Column 2 receives the sales value (if any). 3: Column 3 receives the sales value (if any). 4: Column 4 receives the sales value (if any).
G/L Interface (general ledger interface)	Select to reflect the monetary amount or unit value of any activity that contains this order line type in the general ledger.
A/R Interface (accounts receivable interface)	Select to reflect the monetary amount or unit value of any activity that contains this order line type in JD Edwards EnterpriseOne Accounts Receivable.
A/P Interface (accounts payable interface)	Select to reflect the monetary amount or unit value of any activity that contains this order line type in JD Edwards EnterpriseOne Accounts Payable.
S/WM Interface (sales/warehouse management interface)	Select to display this order line on the second document in a series of four documents that relate to this order. For example, you might need to include receiving information in a purchase order that provides instructions about the desired disposition of goods. Although this information is vital to the proper handling of the order, it should not appear on the purchase order that is delivered to the supplier.
Text Line	Select to indicate that the information with this order line type contains only text information.
Reverse Sign	Select to reverse the sign of the quantity in the line. Use this code to enable easy entry of credit memos.
Apply Freight	Select to perform freight calculations during processing. If you do not select this option, the system does not perform freight calculations during processing.
Apply Retainage	Select to include the item's values in the calculation of an accounts payable retainage. Use this option only if the interface between JD Edwards EnterpriseOne Procurement and JD Edwards EnterpriseOne Accounts Payable is active.
Generate Workorder	Select to generate an internal work order automatically for this order detail line.
Include in Cash Discount	Select to include the extended monetary amount of the transaction in the cash discount or payment terms discount calculation.
Include Sales/COGS for Gross Profit (include sales/cost of goods sold for gross profit)	Select to include sales and cost of goods sold in gross profit calculations.
Voucher Match Variance Account	Select to indicate that a variance that is generated during voucher match should be booked to the account. Clear to book any variance to the expense account for the order detail line. Note. This option is used in conjunction with an inventory interface of A or B in JD Edwards EnterpriseOne Procurement only.
Edit Item Master for Non-Stock Item	Select to validate the sales order line item against the Item Master table. Use this in conjunction with the nonstock inventory interface only.
Protect Price on Sales Order	Select to indicate that this order line appears on the first document in a series of four documents that relate to this order.
Generate Purchase Order	Select to generate a purchase order. Use this with the D and N Inventory Interface.
Call Materials Issue	Select to activate the materials issue function when performing the receipts into stock function. You use this option only for JD Edwards EnterpriseOne Procurement and when you are using JD Edwards EnterpriseOne Engineer to Order from Oracle.
Procurement Receipt Required	Select to require receipts for purchase orders lines. If you select this option, the purchase order line must be received before the voucher match process. If you clear this option, you can match purchase order lines without requiring a receipt.

Setting Up Order Activity Rules

This section provides an overview of order activity rules, lists prerequisites, and discusses how to set up order activity rules.

Understanding Order Activity Rules

To advance an order line through the order process, you must create order activity rules. The system uses order activity rules to determine the sequence of steps for processing order information.

The system processes an order line based on the order activity rules that you set up for the order type and line type combination. For example, you could set up the order activity rules for stock line types in sales orders as:

Enter order
Print pick slip
Confirm shipment

For stock line types on purchase orders, you could set up the order activity rules as:

Enter order
Approve order
Print

You must assign a status code for every step in the order process. A status code is a number that the system uses to identify the current status of an order line. You must also identify next status codes that determine the next step to which the system advances the order. You must arrange status codes in ascending numerical order for the system to establish the sequence of steps.

You can change the progression of steps or include alternate steps in the order activity rules. For example, you can set up order activity rules for nonstock items in sales orders so that the system bypasses the step to print pick slips and advances the order line to shipment confirmation.

You can specify at which point in the order process the system writes records to the general ledger for sales and purchasing.

In order processing, you can use the order activity rules to:

Locate the status of an order.
Select orders for batch processing.
Prepare reports that are based on the current status of an order.

Prerequisites

Before you complete the tasks in this section:

Verify that you have set up status codes in UDC table 40/AT.
Verify that you have set up order types in UDC table 00/DT.
Verify that you have set up order line types.

See Setting Up Order Line Types.

Forms Used to Set Up Order Activity Rules

Form Name	FormID	Navigation	Usage
Work With Order Activity Rules	W40204B	Sales Order Management Setup (G4241), Order Activity Rules	Review and select order activity rule records.
Order Activities Rules - Revisions	W40204A	Click Add on the Work With Order Activity Rules form.	Set up order activity rules. Add and revise order activity rule records.

Form Name

FormID

Navigation

Usage

Work With Order Activity Rules

W40204B

Sales Order Management Setup (G4241), Order Activity Rules

Review and select order activity rule records.

Order Activities Rules - Revisions

W40204A

Click Add on the Work With Order Activity Rules form.

Set up order activity rules.

Add and revise order activity rule records.

Setting Up Order Activity Rules

Access the Order Activity Rules - Revisions form.

Order Type

Enter a UDC (00/DT) to identify the type of document. This code also indicates the origin of the transaction. Document type codes are reserved for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.)

These are defined document types and should not be changed:

P: Accounts Payable documents.

R: Accounts Receivable documents.

T: Payroll documents.

I: Inventory documents.

O: Purchase Order Processing documents.

J: General Accounting/Joint Interest Billing documents.

S: Sales Order Processing documents.

Order Type Next Number

Enter a code to indicate which next number series to use when creating order numbers for this order type. Ten available Next Number series are available.

This field addresses:

Purchase requisitions that carry order numbers that are different from bid requests and purchase orders.

Blanket sales orders that are numbered in a different number range from standard sales orders.

Other 1

(Optional) Enter a number to indicate a status that can be performed as the next step in the order process. Although this is not the preferred or expected next step, this field is an allowable override. The system does not allow you to initiate an order line step or status that is not defined as either the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often referred to in processing options as override next status codes.

Ledger Y/N (ledger yes/no)

Enter a value to write a record to the S.O Ledger Detail File table (F42199). Values are:

Y: Write a record for selected fields to the history table

N: Do not write a record to the history table

Short Item Number Identifier	Enter a symbol to identify the eight-character short item number when you do not want to use it as the primary number. Leave this field blank if you want to use this item number as the primary number. That is, you use it most often to enter or review information. If this is not the primary number, you must enter a special symbol to identify it. Use a symbol that is not significant for any other purposes of entry, such as /, , or &. Do not use a period or a comma as a symbol. When you enter this item number on any other form, you must include this symbol as the first character. Note.* Only one of the fields for item number symbols (SYM1, SYM2, SYM3, or SYM6) can be blank to identify it as the primary number. All others must include a unique symbol.
Symbol Customer/Supplier	Enter a character that identifies the customer's or supplier's number in the system. When you enter a number preceded by this character, the system recognizes the number as the customer's or supplier's number. The system then uses the cross-reference table to match the number to the item number. You must complete this field if you want the system to perform cross-referencing.
Commitment Method	Specify the method that the system uses to commit lot items from inventory. Values are: 1: Normal commit method. The system commits inventory from the primary location and then from secondary locations. 2: Commit method by lot number. The system commits inventory by lot number, starting with the lowest lot number and committing orders to available lots. 3: Commit method by lot expiration date. The system commits inventory from the locations with the earliest expiration date first. The system considers only locations with expiration dates that are greater than or equal to the sales order or parts list requested date.
Number of Days in Year	Enter the number of days in a year that the company is open for business. This field is required. You must specify a number from 252 to 365. The JD Edwards EnterpriseOne Procurement system uses this number to calculate the Economic Order Quantity (EOQ).
Purchasing	Enter a UDC (40/CM) that indicates the cost method that the system uses to determine the cost of the item for purchase orders. Cost methods 01–19 are reserved.
Sales/Inventory Costing Method	Enter a UDC (40/CM) that indicates the cost method that the system uses to calculate the cost of goods sold for the item. Cost methods 01–19 are reserved.
Interface G/L (Y/N) (interface general ledger (yes/no))	Select to indicate that inventory transactions that are processed through this branch/plant create general ledger entries.
Write Units to Journal Entries (Y/N) (write units to journal entries (yes/no))	Specify whether the system moves units to the general ledger after the system records a journal entry from these programs: P31111 (Work Order Inventory Issues) P31112 (Work Order Completions) P31802 (Work Order Journal Entries) P4112 (Inventory Issues) P4113 (Inventory Transfers) P4114 (Inventory Adjustments) P4116 (Item Re-Classification) P41413 (Cycle Count Update) P41610 (Tag Update) R42800 (Sales Update) P4312 (Receipts) P4314 (Voucher Match) P415021 (Update Operational Reconciliation) P415101 (General Stock Movements) P41514 (Bulk Manufacturing Gains/Losses) R49700 (Cycle Billing) P49510 (Bulk Load Confirmation - XT49799) P49515 (Bulk Load Confirm Batch - XT49799) P49530 (Package Load Confirm - XT49799) P49572 (Upload Gantry Data - XT49799) P49710 (Bulk Delivery Confirm - XT49799) P49711 (Bulk Delivery Confirm Milk Run - XT49799) P49715 (Bulk Disposition - XT49799) P49720 (Package Delivery Confirm - XT49799) P49731 (Mass Confirm Batch - XT49799)
Location Control (Y/N) (location control (yes/no))	Select to indicate that the system uses only locations in the Location Master table (F4100). You use location control to use only locations that are in the F4100 table. When the Warehouse Control option is selected, the Location Control option must also be selected. Clear the option and the system does not restrict locations to those in the F4100 table. The system uses all locations that conform to the location format that are defined on the Branch Location Definition form.
Warehouse Control (Y/N) (warehouse control (yes/no))	Specify whether the system creates warehouse transactions for the branch/plant.
Quality Control (Y/N) (quality control (yes/no))	Specify whether to activate the JD Edwards EnterpriseOne Quality Management system from Oracle (system 37) for the branch/plant.
Use Product Cost Detail (Y/N) (use product cost detail (yes/no))	Specify whether distribution programs use total cost or detailed product costs.
Foreign Depot	Specify whether another company owns the branch/plant. The Bulk and Packed Load Confirmation programs use this code to determine whether the depot from which product is being loaded is a foreign depot. If it is a foreign depot, you must enter a valid borrow agreement during load confirmation.
Inventory Lot Creation (Y/N) (inventory lot creation (yes/no))	Specify whether the inventory transaction programs can create new lot or serial numbers in the system. If you leave this option cleared, the system will not allow the inventory transaction programs to create new lot numbers in the system. If you select this option, the system allows the inventory transaction programs to create new lot numbers in the system.
Current Inventory Period	Enter 1 to 14 to identify the current accounting period. The system uses this number to generate error messages, such as PBCO (posted before cut off) and PACO (posted after cut off).
Purchase Order Issue Cost	Enter the amount that JD Edwards EnterpriseOne Procurement uses to calculate the EOQ. This cost should be the estimate of the cost of materials, labor, and overhead that you incur when you issue a single purchase order. The default value is 00. This example illustrates how the system calculates EOQ using the Purchase Order Issue Cost method: S: Purchase Order Issue Cost = 15.0 I: Inventory Carrying Cost = .09 (9 percent) Y: Annual Sales in Units = 3,000 C: Unit cost of Item = 10.0 EOQ = the square root of ((2S/I) × (Y/C)) The square root of [(2)(15) ÷ 0.09] × 3,000 ÷ 10.0 = 316.23
Inventory Carrying Cost (%) (inventory carrying cost (percent))	Enter the percentage of inventory investment that JD Edwards EnterpriseOne Procurement uses to calculate EOQ. The default value is .00. Enter the percentage as a decimal value. This example illustrates how the system calculates EOQ using the Inventory Carrying Cost Percentage: S: Purchase Order Issue Cost = 15.0 I: Inventory Carrying Cost = .09 (9 percent) Y: Annual Sales in Units = 3,000 C: Unit Cost of Item = 10.0 EOQ = Square root of ((2S/I) × (Y/C)) = the square root of (2(15) ÷ .09)) × (3000 ÷ 10) = 316.23 Note. Access field help for the Economic Order Quantity field for more information about the EOQ formula.
General Ledger Explanation	Enter a code that the JD Edwards EnterpriseOne Inventory Management system uses to select the default description that appears on the second line of a journal entry in the general ledger. Values are: 1: Item master description (default value). 2: Primary item number.

Unit of Measure Conversion by Branch	Select to display the item-specific conversion table when you add an item to a specific branch/plant. Clear this option and the system displays the item-specific conversion table for all branch/plants from the Item Master table.
Update Average Cost On-Line	Select to calculate a new average cost immediately after any transaction occurs that affects the average cost of an item. Clear to indicate that all processes that affect average cost create transactions to the Average Cost Work File table (F41051). The system calculates a new average cost when you run the Average Cost Update program (R41811).
ECS Control (energy and chemical system control)	Select to use the JD Edwards EnterpriseOne Bulk Stock Inventory system.
Internet Enable PPAT Messages (internet enable people places and things messages)	Select to send any email messages that are generated by distribution programs.
Scientific Rounding	Select to perform scientific rounding. Currently, this feature is enabled only for Quality Management Test Results.
Use Customer Set	Select to use the customer set feature.
Ship Ascending Date Rule	Select to apply the ship ascending date rule by customer and by item during the sales order entry, pick slip/commitment processing, and ship confirmation processes. When the system applies the Ship Ascending Date rule, the system sorts shipping customers' lots in ascending order by expiration date, sell by date, or best before date.
Allow Duplicate Lots	Enter a value to determine whether the system assigns the same lot to multiple items. Values are: 1: The system does not allow duplicate lots. The lot is restricted to one item and one branch/plant. 2: The system allows duplicate lots. You can create a lot that contains multiple items and branch/plants. 3: The system does not allow duplicate lots. The lot is restricted to one item, but can contain quantities in multiple branch/plants.
Sales Price Retrieval UOM (sales price retrieval unit of measure)	Enter a code that specifies the unit of measure for retrieving base prices and price adjustments for sales order processing, service and warranty management, and ship and debit processing. The system enables users to define base prices in the Item Base Price File table (F4106) and price adjustments in the Price Adjustment Detail table (F4072) in various units of measure. If the base price or price adjustments are not found in the specified unit of measure, the system uses the primary unit of measure for the item.
Purchase Price Retrieval UOM (purchase price retrieval unit of measure)	Enter a code that represents the unit of measure for the purchase base price during purchase order processing. If you specify the unit of measure for transaction or pricing and the system does not find a record in that unit of measure, the system repeats the process using the primary unit of measure of the item.
Sales Price Based On Date	Enter a code that determines how the system updates the price effective date in the Sales Order Header File table (F4201) and Sales Order Detail File table (F4211). In JD Edwards EnterpriseOne Sales Order Management, the system uses the price effective date to retrieve the base price from the F4106 table and price adjustments from the F4072 table.
Purchase Rebate Category Code	Enter a number that determines which category code the system uses in the criteria for inclusion comparison.
Preference Schedule	Enter a UDC (40/AS) that identifies the advanced preference schedule that the system uses when resolving preferences. The advanced preference schedule determines which preferences the system resolves when using the advanced preference functionality. You cannot maintain preference schedules directly through UDCs, but you can maintain preference schedules by using the Price Adjustment Schedule program (P4070).
Pref Retrieval UOM (preference retrieval unit of measure)	Enter a code that specifies the unit of measure that the system uses for retrieving advanced preference adjustments during sales order processing. The system enables you to define the advanced preference adjustments in the F4072 table in various units of measure. If you specify the unit of measure for transaction or pricing and the system does not locate a record in that unit of measure, the system repeats the process using the primary unit of measure of the item.

Order Type	Enter a UDC (00/DT) to identify the type of document. This code also indicates the origin of the transaction. Document type codes are reserved for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) These are defined document types and should not be changed: P: Accounts Payable documents. R: Accounts Receivable documents. T: Payroll documents. I: Inventory documents. O: Purchase Order Processing documents. J: General Accounting/Joint Interest Billing documents. S: Sales Order Processing documents.
Order Type Next Number	Enter a code to indicate which next number series to use when creating order numbers for this order type. Ten available Next Number series are available. This field addresses: Purchase requisitions that carry order numbers that are different from bid requests and purchase orders. Blanket sales orders that are numbered in a different number range from standard sales orders.
Other 1	(Optional) Enter a number to indicate a status that can be performed as the next step in the order process. Although this is not the preferred or expected next step, this field is an allowable override. The system does not allow you to initiate an order line step or status that is not defined as either the expected next status or an allowed status. Other allowed status codes let you bypass processing steps. These codes are often referred to in processing options as override next status codes.
Ledger Y/N (ledger yes/no)	Enter a value to write a record to the S.O Ledger Detail File table (F42199). Values are: Y: Write a record for selected fields to the history table N: Do not write a record to the history table