Defining Order Line Types
Access the Line Type Constants Revisions form.
- Inv. Interface (inventory interface)
Enter a code that identifies the type of interface to the JD Edwards EnterpriseOne Inventory Management system. Values are:
Y: The monetary amount or unit value of any activity containing this line type will be reflected in inventory. The system also edits the item that you enter to ensure that it is a valid item. Y is the default.
A: The system recognizes the number that you enter as a general ledger account number. The system uses this code in purchasing only. Budget checking is fully functional when you use this interface code.
B: The system performs edits on a nonstock item with a general ledger interface.
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. Budget checking is fully functional when you use this interface code.
C: The system edits inventory interface activity against the F4101 table, tracks purchase order quantities, and also tracks against the general ledger. Budget checking is fully functional when you use this interface code.
D: The item in this line is an inventory item that will not affect availability or quantities. This inventory interface should be used only for direct ship orders.
N: The item is not an inventory item.
To verify whether the item exists in the F4101 table, use an inventory interface value of N and the check box Edit Item Master for Non-Stock Item.
- G/L Offset (general ledger offset)
Enter a code from UDC 41/9 that identifies the G/L offset that the system uses when it searches for the account to which it posts the transaction. If you do not want to specify a class code, you can enter **** (four asterisks) in this field. You can use AAIs to predefine classes of automatic offset accounts for the JD Edwards EnterpriseOne Inventory Management, JD Edwards EnterpriseOne Procurement Management, and JD Edwards EnterpriseOne Sales Order Management systems from Oracle.
You might assign G/L class codes like this:
IN20 Direct Ship Orders
IN60 Transfer Orders
IN80 Stock Sales
The system can generate accounting entries based upon a single transaction. For example, a single sale of a stock item can trigger the generation of accounting entries similar to these:
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 the 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: The line is subject to applicable taxes at the rate indicated by the group number (3-8). The system uses group numbers for VAT (value-added tax).
- Sales Journal Col (sales journal column)
Enter the column of the Sales Journal report in which the sales value is printed. 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 instruct the system to reflect the monetary amount or unit value of any activity containing this order line type in the general ledger.
- A/R Interface (accounts receivable interface)
Select to instruct the system to reflect the monetary amount or unit value of any activity containing this order line type in the JD Edwards EnterpriseOne Accounts Receivable system from Oracle.
- A/P Interface (accounts payable interface)
Select to instruct the system to reflect the monetary or unit value of any activity containing this order line type in the JD Edwards EnterpriseOne Accounts Payable system.
- S/WM Interface (service and warranty management interface)
Select to have this order line appear 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 specify that the line is text only.
- Reverse Sign
Select to instruct the system to reverse the sign of the quantity in the line. This code is used to enable easy entry of credit memos.
- Apply Freight
Select to instruct the system to calculate freight charges for the line.
- Apply Retainage
Select to instruct the system to include the item's values in the calculation of an accounts payable retainage. Select this option only if the interface between the JD Edwards EnterpriseOne Procurement system and the JD Edwards EnterpriseOne Accounts Payable system is active.
- Generate Workorder
Select to have the system automatically generate an internal work order for this order detail line.
- Include in Cash Discount
Select to have the system 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 have the system include sales and cost of goods sold in gross profit calculations.
- Voucher Match Variance Account
Select to specify that a variance that is generated during voucher match is booked to the variance account. This option is used only with an inventory interface of A or B in the JD Edwards EnterpriseOne Procurement system.
- Edit Item Master for Non-Stock Item
Select to indicate whether the system validates the sales order and purchase order line's item against the Item Master table. Select this option only when using nonstock inventory interface.
- 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.
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.
- Generate Purchase Order
Select to specify whether the system generates a purchase order for the line. Generally, this option is used with the D and N inventory interface.
- Call Materials Issue
Select to specify whether the system activates the materials issue function when performing the receipts into stock function.
You use this option only for the JD Edwards EnterpriseOne Procurement system and when you are using the JD Edwards EnterpriseOne Engineer to Order system from Oracle.
- Procurement Receipt Required
Select to indicate whether purchase order lines require a receipt. If you select this option, the purchase order line must be received before the voucher match process.
- Expense At Voucher
Select to specify whether the system performs expense during voucher match.
When you receive noninventory purchase order lines that have this option selected, no journal entries will be created except for landed cost journal entries. Receipt and tax amounts will be expensed during voucher match. Any variances between receipt and voucher amount will be booked to the variance account or to the expense account based on the value of the Voucher Match Variance Account option in the Line Type Constants program (P40205). Commitments will be relieved when you post the voucher match batch.
This option can be set only when:
The Inv. Interface value is either A or B.
The A/P Interface option is selected.
The A/P interface is a code that indicates that the system reflects the monetary or unit value of any activity containing this order type in the JD Edwards EnterpriseOne Accounts Payable system.
The Expense At Voucher option is not related to the Procurement Receipt Required check box. If the Expense At Voucher option is selected and if the user does a receipt, receipts will not create any journal entries. Expensing will be done during voucher. If the receipt process is bypassed, then the standard two-way match process will occur.
- Non-Billable Retainage
Select to specify whether the system uses a nonbillable expense AAI (financial AAI PCNBRT) for retainage processing during voucher match. This option can be selected for an inventory interface A or B only. For three-way voucher match, both the Non-Billable Retainage and Expense at Voucher options should be selected to use a nonbillable expense AAI.
- Procurement Allow Service Units
Select to specify whether the system allows the entry of service quantity and service unit of measure (UOM).
This field is a field by itself and has no relation to unit cost to calculate the extended cost. If service quantity is used, the Quantity Ordered field in the JD Edwards EnterpriseOne Procurement system cannot be used.