Inventory Abbreviations Subtask

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, modifications to the account numbers are not allowed.

Table Window

Field Description
Inventory Abbrev Code

Enter an inventory abbreviation code.

Name

Enter an inventory abbreviation name.

Acct Type

This account type illustrates how material in this inventory abbreviation is handled in the company's financial statements. Select the account type for this inventory abbreviation from the drop-down list. The available options are:

  • Expensed: For this account type, 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.
  • Asset: For this account type, 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 Asset. You cannot issue to an asset inventory abbreviation.
  • Furnished Mat: Use Furnished Material 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. FM Inventory Abbreviations do not have any accounts/organizations tied to them.
Furnished Material Type Select the Furnished Material Type this inventory abbreviation stores. This drop-down list is active if you selected Furnished Material as the Account Type. The following are the options:
  • Customer: This value is a system default.
  • Government: This value is a system default.
  • Repair: This value is user defined.
Note: This field is added in Costpoint 8.2.12. If you are in Costpoint Cloud, you can choose to opt-in to this feature. The ability to opt-in is temporary and will be removed when the feature becomes automatically enabled for all users as part of the release. See the Manage Opt-In Features topic for more information.
Inv Type

Select the inventory type for this abbreviation from the drop-down list. The available options are:

  • Raw Materials: Raw materials can only have purchased parts assigned to them and do not require work-in-process accounts and organizations.
  • Finished Goods: Finished goods can have all types of inventory parts assigned to them and WIP accounts and organizations can be entered.
Active

Select an option from the drop-down list. The available options are:

  • Active: This option indicates that this inventory abbreviation is active.
  • Inactive: This option indicates that this inventory abbreviation is not active, and inventory transactions (other than adjustments) are not allowed.
  • Outgoing Only: This option indicates that the inventory can only be moved out of this inventory abbreviation.
Note: If you change the status of an inventory from Active to Outgoing Only or Inactive,Costpoint will display a warning that will say that changing of 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 modifying this status.
Default RM Inv Abbrev

Enter, or click 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 Finished Goods that are not assigned to a project where the Project Planning Option field on the Inventory/Material Planning tab is not set to No MRP Planning.

Default Subassembly Inv Abbrev

Enter, or click 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 Finished Goods that are not assigned to a project where the Project Planning Option field on the Inventory/Material Planning tab is not set to No MRP Planning.

Apply Burden on MO Issue If this check box is not selected, the MO issues from this Raw Material Abbrev should only be made to a Finished Goods Abbrev with a WIP Material Account that is not in the Burden Pool.
Use Separate WIP Accounts

Select this check box to require the use of separate WIP accounts/organizations for burdening the selected inventory abbreviation. This setting can be modified for expense finished goods inventory abbreviations only and loads from the Configure Inventory Accounts screen. This check box also determines how autofill loads WIP vs. non-WIP accounts/orgs. The check box is always selected for asset, finished goods inventory abbreviations and always cleared for raw materials inventory abbreviations. It cannot be modified, even for expense finished goods inventory abbreviations, if the Move Burden Costs When Issuing/Transferring Inventory from Expense Projects check box is not selected on the Configure Inventory Accounts screen.

Post Project WIP Variance

Select this check box to post asset variance for this inventory abbreviation. This should only be selected for asset account type inventory abbreviation even if the project is not common inventory.

Material Account

Enter, or click 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 click 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 click 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 click 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 click 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 click 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 click 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 click 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 click 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 click 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.

WIP Material Account

Enter, or click 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 check box is selected.

WIP Material Organization

Enter, or click 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 check box is selected.

WIP Dir Labor Account

Enter, or click 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 check box is selected.

WIP Dir Labor Organization

Enter, or click 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 check box is selected.

WIP Subcontract Account

Enter, or click 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 check box is selected.

WIP Subcontract Organization

Enter, or click 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 check box is selected.

WIP Misc 1 Account

Enter, or click 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 check box is selected.

WIP Misc 1 Organization

Enter, or click 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 check box is selected.

WIP Misc 2 Account

Enter, or click 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 check box is selected.

WIP Misc 2 Organization

Enter, or click 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 check box 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 select Raw Materials 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 (Raw Materials do not have WIP). If you select 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 select 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 Inv Type of  Finished Goods, 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.