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:
|
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:
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:
|
Active |
Select an option from the drop-down list. The available options are:
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. |