Line Type |
A code that controls how the system treats 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. For example:
S – Stock item
J – Job cost
N – Non-stock item
F – Freight
T – Text information
M – Miscellaneous charges and credits
|
Description - Line Type |
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 - Distribution |
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 - Distribution |
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 you enter to ensure that it is a valid item. Y is the default.
A – The number entered will be recognized as a G/L account number. This code is used in purchasing only.
B – The system edits when using format 4 in purchase order entry. The system retrieves price data from the inventory tables, but does not update to the quantity on the purchase order. This code is valid only when the G/L Interface field is Y (yes). Budget checking is fully functional with this interface type.
D – The item in this line is an inventory item that will not affect availability or quantities.
N – This item is not an inventory item.
|
A/R Interface Y/N - Distribution |
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, and N (no). |
A/P Interface Y/N - Distribution |
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). |
Reverse Sign |
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
|
Text |
A code that indicates whether this line contains only memo information. Valid codes are:
Y – (yes)
N – (no, which is the default)
|
Include Sales/COGS for Gross Profit |
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). |
Include in Cash Discount Calculation |
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. |
Include in Tax 1 |
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).
|
Apply Retainage - Y/N |
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.
|
Apply Freight - Y/N |
A code indicating whether the system should perform freight calculations during processing. Valid codes are:
Y – yes, perform calculations
N – no, do not perform calculations
If you leave this field blank, the system automatically enters Y.
|
Generate Workorder |
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). |
Category - G/L |
A code that identifies the general ledger class 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. G/L categories might be assigned as follows:
IN20 – Direct Ship Orders
IN60 – Transfer Orders
IN80 – Stock Sales
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 Posting Category: IN80
Stock Inventory (Debit) xxxxx.xx
Stock COGS (Credit) xxxxx.xx
Although this field is four characters, only the last two characters of the Category and the last character of the Document Type are used to find the AAI.
|
Column to Include on Sales Journal |
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. |
Record Variance (Y/N) |
Code that tells the system to which account it should book a variance. Valid codes are:
Y – Tells the system that a variance generated during voucher match should be booked to the variance account.
N – Indicates to the system that it should book any variance 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 Purchasing system only.
|