6 Set Up Order Line Types

This chapter contains these topics:

• Section 6.1, "Setting Up Order Line Types"

6.1 Setting Up Order Line Types

Navigation:

From Localizations - Brazil (G76B), enter 29

From Localization Setup - Brazil (G76B41B), choose 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 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 your 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 with the Inventory Management system. 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 the Inventory Management system.

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

To set up order line types

On Order Line Types

Figure 6-1 Order Line Types screen

Description of ''Figure 6-1 Order Line Types screen''

1. Complete the following fields:

   • Ln Ty

   • Description

   • G/L Interface

   • Inv Interface

   • A/R Interface

   • A/P Interface

   • Rev Sgn

   • Text Y/N

   • Include G/P

   • Include C

   • Include T1

   • AR

   • AF

   • WO

   • E

2. Access the detail area.

   Figure 6-2 Order Line Types screen (Detail area)

   
   Description of ''Figure 6-2 Order Line Types screen (Detail area)''
   
   

3. Complete one or more of the following fields:

   • G/L class

   • Jrnl Col

   • Variance

Field	Explanation
Ln Ty	A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces (General Ledger, Job Cost, Accounts Payable, Accounts Receivable, and Inventory Management). It also specifies the conditions under which a line prints on reports and is included in calculations. Codes include: S Stock item J Job cost N Non-stock item F Freight T Text information M Miscellaneous charges and credits W Work order
Description	The first 30 characters of the description that identifies each defined line type. The system uses this description as the default description for all non-inventory line items you create through order entry.
G/L Interface (Y/N)	A code that indicates whether the system reflects the dollar or unit value of any activity containing this order line type in the general ledger. Valid codes are Y (yes), which is the default, and N (no).
Inventory Interface (Y/N)	A code that identifies the type of interface to the Inventory Management system. Valid codes are: Y The dollar 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 G/L 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 will not affect availability or quantities. N The item is not an inventory item.
A/R Interface (Y/N)	A code that indicates whether the system will reflect the dollar or unit value of any activity containing this order line type in Accounts Receivable. Valid codes are: Y (yes), which is the default N (no)
A/P Interface (Y/N)	A code that indicates whether the system reflects the dollar or unit value of any activity containing this order line type in accounts payable. Valid codes are Y (yes), which is the default, and N (no).
Rev Sgn	A code that indicates whether the system reverses the sign of the quantity in the line. This code is used to allow easy entry of credit memos. Valid codes are: Y Yes N No. This is the default
Txt Y/N	A code that indicates whether this line contains only memo information. Valid codes are: Y Yes N No, which is the default
Include In G/P	A code indicating that the system includes sales and cost of goods sold in gross profit calculations. Valid codes are Y (yes) and N (no, which is the default).
C/D	A code indicating whether the system includes the extended dollar amount of the transaction in the cash discount or payment terms discount calculation. Valid codes are Y (yes) and N (no). N is the default.
T1	A code that indicates whether the monetary value of this order line is subject to applicable taxes and which taxes to apply. Valid values are: Y Yes, the line is subject to applicable taxes. N No, 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 VAT (value added tax).
A R	A code that indicates whether the system includes the item's values in the calculation of an accounts payable retainage. Use this field only if the interface between the Purchasing system and Accounts Payable system is active. Valid codes are: Y Include the item's values in the accounts payable retainage calculation. N Do not include the item's values in the accounts payable retainage calculation. If you leave this field blank, the system automatically enters N.
A F	This is the fiscal year beginning date for Accounts Receivable.
W O	A code indicating whether the system automatically generates an internal work order for this line. Valid codes are Y (yes) and N (no, which is the default).
Exchange Rate Variance	Code that tells the system to which account it should book an exchange rate variance. Valid codes are: Y Tells the system that an exchange rate variance generated during voucher match should be booked to the variance account. N Tells the system that an exchange rate variance should be booked back to the expense account for the order line. Note: This field is used in conjunction with an inventory interface of A or B in the Procurement system only.
G/L Class	A user defined code that identifies the G/L offset that you want the system to use when it searches for the account to which it will post the transaction. If you do not want to specify a class code, you can enter **** (four asterisks) in this field. The table of Automatic Accounting Instructions (AAIs) allows you to predefine classes of automatic offset accounts for the Inventory, Purchasing, and Sales Order Management systems. The system can generate accounting entries based upon a single transaction. As an 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 Stock Inventory (Debit) xxxxx.xx Stock COGS (Credit) xxxxx.xx In Brazil, use this G/L code to identify freight, expenses, and insurance.
Jrnl Col	The Sales Journal report has four columns. The value in this field controls which of the four columns receives the sales value, if any, of this line. Allowed codes are 1, 2, 3, and 4.