INVENTORY ABBREVIATIONS

Use this subtask to establish inventory abbreviations and assign them to project/account/ organization combinations. Inventory abbreviations contain the account information necessary to post inventory transactions to the General Ledger and allocate any appropriate burden costs to inventory.

Once inventory is assigned to an inventory abbreviation, changes to the account numbers are not allowed.

Inventory Project

The project ID, abbreviation, and description for the inventory project display in these fields.

Table Window

Inventory Abbrev

Enter an inventory abbreviation code containing up to six alphanumeric characters.

Inventory Abbrev Name

Enter an inventory abbreviation name containing up to 25 alphanumeric characters for this code.

Acct Type

Enter, or use to select, the account type for this inventory abbreviation. This account type illustrates how material in this inventory abbreviation is handled in the company's financial statements: A (company-owned Asset), E (Expensed), or G (Government-furnished materials).

For A account types, items stored in a company's inventory are treated as asset items on the General Ledger. All accounts entered for an asset inventory abbreviation must have an account type of A (Asset). You cannot issue to an asset inventory abbreviation.

For E account types, inventory is expensed on the income statement when it is assigned or charged to that inventory abbreviation, and shows up as cost to that inventory abbreviation's project. All accounts entered for these inventory abbreviations must be labor or non-labor expense accounts.

Use G account types to track inventory parts, but not have them affect the General Ledger. The material is assigned to a project but does not show up on any company financial statement. GFM Inventory Abbreviations do not have any accounts/organizations tied to them.

Inv Type

Enter the inventory type for this abbreviation. The acceptable values are R (Raw materials) or F (Finished goods). Raw materials can only have purchased parts assigned to them and do not require work-in-process accounts and organizations. Finished goods can have all types of inventory parts assigned to them and WIP accounts and organizations can be entered.

Active

Enter Y (Yes) to indicate that this inventory abbreviation is active. Enter O (Out) to indicate that inventory can only be moved out of this inventory abbreviation. If you enter N (No), this inventory abbreviation is not active, and inventory transactions (other than adjustments) are not allowed. If you change the Active status of an inventory abbreviation line from Y (Yes) or O (Out) to N (No), the system displays the following warning:

Changing the status will freeze all activity of current inventory and prevent some transactions. It is recommended that you review Inventory and all Reservations, Requisitions, Open Purchase Orders, Open Manufacturing Orders and Open Sales Orders for this abbreviation before changing this status.

Material Account

Enter, or use to select, the account ID to which to charge material costs. This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation. Purchase order and purchase requisition costs are generally allocated to this cost element account.

Material Organization

Enter, or use to select, the organization ID to which to charge material costs. This account/organization combination must exist and be valid for the assigned inventory project.

Direct Labor Account

Enter, or use to select, the account ID to which to charge labor costs on manufacturing orders. This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation.

Direct Labor Organization

Enter, or use to select, the organization ID to which to charge labor costs. This account/organization combination must exist and be valid for the assigned inventory project.  

Subcontract Account

Enter, or use to select, the account ID to which to charge subcontract costs. This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation. Subcontract Purchase Order costs are placed in this cost element (account).

Subcontract Organization

Enter, or use to select, the organization ID to which to charge subcontract costs. This account/organization combination must exist and be valid for the assigned inventory project.

Misc Cost 1 Account

Enter, or use to select, the account ID to which to charge miscellaneous 1 (typically labor) costs. This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation.

Misc Cost 1 Organization

Enter, or use to select, the organization ID to which to charge miscellaneous 1 costs. This account/organization combination must exist and be valid for the assigned inventory project.

Misc Cost 2 Account

Enter, or use to select, the account ID to which to charge miscellaneous 2 (typically labor) costs. This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation.

Misc Cost 2 Organization

Enter, or use to select, the organization ID to which to charge miscellaneous 2 costs. This account/organization combination must exist and be valid for the assigned inventory project.

Default RM Inv Abbrev

Enter, or use to select, the default Raw Material (RM) inventory abbreviation where raw materials are generally pulled from for orders to this inventory abbreviation. This abbreviation is used by MRP and MPS to determine the inventory abbreviations for planned orders. This is required for inventory abbreviations with an Inv Type of F (Finished goods) that are not assigned to a project where the Project Planning Option field on the Inventory Projects (Materials » Inventory » Inventory Projects) screen is not set to No MRP Planning.

Default Subassembly Inv Abbrev

Enter, or use to select, the default inventory abbreviation to be used by MRP and MPS to make parts required for this inventory abbreviation. This is required for inventory abbreviations with an Inv Type of F (Finished goods) that are not assigned to a project where the Project Planning Option field on the Inventory Projects (Materials » Inventory » Inventory Projects) screen is not set to No MRP Planning.

Apply Burden on MO Issue

Select this check box to burden issues from this inventory abbreviation when issued to an MO. This flag only applies when the Burden Raw Materials at Issue option is selected in the Burden Options subtask of the Inventory Accounts (Materials » Inventory » Inventory Controls) screen.

Use Separate WIP Accounts

Set this flag to require the use of separate WIP accounts/orgs for burdening the selected inventory abbreviation. This setting can be changed for expense finished goods inventory abbreviations only and defaults from the Burden Options subtask of the Inventory Accounts (Materials » Inventory » Inventory Controls) screen. This flag also determines how autofill loads WIP vs. non-WIP accounts/orgs. The flag is always selected for asset, finished goods inventory abbreviations and always cleared for raw materials inventory abbreviations. It cannot be changed, even for expense finished goods inventory abbreviations, if the Move Burden Costs when Issuing/Transferring Inventory from Expense Projects check box is not selected in the Burden Options subtask of the Inventory Accounts (Materials » Inventory » Inventory Controls) screen.

WIP Material Account

Enter, or use to select, the account ID to which to charge Work-In-Process (WIP) material costs. This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation. This field is required if the Use Separate WIP Accounts option is selected.

WIP Material Organization

Enter, or use to select, the organization ID to which to charge WIP material costs. This account/org combination is typically part of a burden pool. This must be a valid account/organization combination and valid for this project. This field is required if the Use Separate WIP Accounts option is selected.

WIP Dir Labor Account

Enter, or use to select, the account ID to which to charge WIP direct labor costs. This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation. This field is required if the Use Separate WIP Accounts option is selected.

WIP Dir Labor Organization

Enter, or use to select, the organization ID to which to charge WIP direct labor costs. This account/org combination is typically part of a burden pool. This must be a valid account/organization combination and valid for this project. This field is required if the Use Separate WIP Accounts option is selected.

WIP Subcontract Account

Enter, or use to select, the account ID to which to charge WIP subcontract costs. This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation. This field is required if the Use Separate WIP Accounts option is selected.

WIP Subcontract Organization

Enter, or use to select, the organization ID to which to charge WIP subcontract costs. This account/org combination is typically part of a burden pool. This must be a valid account/organization combination and valid for this project. This field is required if the Use Separate WIP Accounts option is selected.

WIP Misc 1 Account

Enter, or use to select, the account ID to which to charge WIP miscellaneous 1 costs (typically labor). This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation. This field is required if the Use Separate WIP Accounts option is selected.

WIP Misc 1 Organization

Enter, or use to select, the organization ID to which to charge WIP Miscellaneous 1 costs. This account/org combination is typically part of a burden pool. This must be a valid account/organization combination and valid for this project. This field is required if the Use Separate WIP Accounts option is selected.

WIP Misc 2 Account

Enter, or use to select, the account ID to which to charge WIP miscellaneous 2 costs (typically labor). This must be a valid account for this project, a detail account, active, and the account type must match the account type for this inventory abbreviation. This field is required if the Use Separate WIP Accounts option is selected.

WIP Misc 2 Organization

Enter, or use to select, the organization ID to which to charge WIP miscellaneous 2 costs. This account/org combination is typically part of a burden pool. This must be a valid account/organization combination and also valid for this project. This field is required if the Use Separate WIP Accounts option is selected.

Update Open Billing Detail for MO/PO Issues

Select this check box if you want an issue to a manufacturing order or an issue to a purchase order with this inventory abbreviation to update the Open Billing Detail. These costs can then be billed to customers in the same manner as an issue to a project/account/organization combination.

Autofill

If you selected R (Raw Material) in the Inv Type field, fill in the Material Account and Material Organization fields and then click the Autofill button to fill in the rest of the previously blank non-WIP account/organization fields (R inventory does not have WIP). If you selected F (Finished Goods) in the Inv Type field and the Use Separate WIP Accounts check box is cleared, all the previously blank account and organization fields in the table are loaded, including those with WIP information. If you selected F (Finished Goods) in the Inv Type field and the Use Separate WIP Accounts check box is checked, all the previously blank non-WIP account and organization fields in the table are loaded.  If an inventory abbreviation has an  F (Finished Goods) Inv Type, the Use Separate WIP Accounts check box is cleared and all direct cost accounts and organizations are filled in, when you click the Autofill button with the cursor positioned on a WIP account or organization field, the direct cost accounts and organizations load into the corresponding, previously blank, WIP accounts and organizations for all five cost elements, even if the values have already loaded. For example, the Material Account and Material Organization load in the WIP Material Account and WIP Material Organization, respectively; the Direct Labor Account and Direct Labor Organization load into the WIP Dir Labor Account and WIP Dir Labor Organization, respectively.

Table Information

Changes made on this screen update the INVT_ABBRV_CD table.