INVENTORY PROJECTS

Use this screen to store inventory against a specific project. The project must already exist in the Project Master table in the Projects folder.

Once this function is set up, you can define what costing method is used to calculate the value of inventory, how costs are rolled up between projects within the same top-level project, how the project inventory is grouped for planning purposes, and whether issues between projects can be performed without a prior project transfer.

Inventory can be stored only if one inventory abbreviation is created for that project. Establish inventory abbreviations before processing inventory transactions for a specific project.

For more inventory project information see special topic Inventory Projects and Abbreviations.

Inventory Project

Enter, or use to select, the project ID or project abbreviation to which inventory is assigned. After you enter the project ID or abbreviation, the project name automatically displays .

Inventory Options

Project Inventory Valuation Method

Select the method for calculating the value of inventory for this project and for use in posting transactions to the General Ledger. The system-defined methods are as follows:

• Average Actual - The inventory value is based on the average cost of each receipt transaction for the given part and inventory abbreviation.  

This is the only inventory valuation option currently supported.

Common Inventory

Select this check box to indicate that the project involves company-owned, non-allocated inventory, which means it is not tied to a specified direct project and can be used across many different projects. If you do not select the check box, this inventory project is tied to a specific project and unavailable for use across other projects. This check box is used primarily by the Process Materials Requirements function (Materials » Production Control). It is not used by Material Requirements Planning (MRP) and Master Production Scheduling (MPS) planning functions.

Req Approval Process Code

Enter, or use to select, a requisition approval process code to load on all requisitions automatically generated for this inventory project. This field populates only if you have selected the Manual option in the Process Assignment group box on the Requisition Settings (Materials » Procurement Planning » Requisition Controls) screen.

Use Standard Costs for Reliefs of Labor, Misc 1 and Misc 2 Elements

Select this check box to use standard costs from the Maintain Project Item Cost (Materials » Product Definition » Product Billing) screen (if available) or from the Maintain Item Cost (Materials » Product Definition » Product Billing) screen, instead of actual costs for MO reliefs when calculating the inventory value of labor, Misc 1 and Misc 2 cost elements. This also applies to partial reliefs, regardless of what costing option is selected. This field defaults from the selection made on the MO Costing Options (Materials » Production Control » Production Controls) screen, and can be changed here. This warning displays when you make a change to this check box:

This change will only affect future MO Relief costs and could cause cost discrepancies in existing Manufacturing Orders.

Issues/Adjustments Options

Use the selections in this group box to determine the control parameter for allowing issues and adjustments between and among projects.

No Issues/Adj Outside Project Allowed

Select this option to prevent issues and adjustments outside of the from project.

Allow Issues/Adj Within Top-Level Project

Select this option to allow issues and adjustments to projects with the same top-level project ID as the from project.

Allow Issues/Adj Within Netting Group Only

Select this option to allow issues and adjustments for projects that are assigned the same netting group.

Allow Inter-Project Issues/Adjustments

Select this option to allow issues and adjustments for the from project to all other projects.

Cost Roll-Up

Select the default method to account for project costs when issues are posted to projects with the same top-level project ID. Projects with asset accounts always roll up to all levels. Non-GFM issues between projects that do not share the same top-level project ID always post.

No Roll-Up

Select this option to have raw material costs remain within the project level assigned. The transaction does not post.

Roll-Up Buy Parts Cost

Select this option to have only purchased part costs roll up (post) to the issue-to project.

Roll-Up All Parts Costs

Select this option to have costs always roll up (post) to the issue-to project.

MO Allocations Across Projects

Not Allowed with Other Projects

Select this option if MOs built to this project cannot be allocated to other projects.

Within Same Top-Level Project

Select this option if MOs built to this project can be allocated only to other projects with the same top-level project.

Within Same Netting Group

Select this option if MOs built to this project can be allocated only to other projects within the same netting group.

Allowed with Other Projects

Select this option if MOs built to this project can be allocated to any other projects.

Material Planning Options

Project Planning Option

Select the Project Planning Option for production control for this inventory project. This option is used by the MRP and MPS processes to determine if (and how) project inventory is planned. Available options are:

MRP is Material Requirements Planning. MPS is Master Production Scheduling

• Project-No CS - MRP/MPS plans inventory for this project separately from other projects for all parts.

• Project-CS - If the part is not a common stock part, MRP/MPS plans inventory for this project separately from other projects. For common stock parts, MRP/MPS plans this project’s inventory with other non-allocated projects Project-No CS - MRP/MPS plans inventory for this project separately from other projects for all parts.

• Top-level Project-No CS - MRP/MPS plans inventory for this project with other projects with the same top-level project (and the same Project Planning Option) for all parts.

• Top-level Project-CS - If the part is not a common stock part, MRP/MPS plans inventory for this project with other projects with the same top-level project (and the same Project Planning Option). For common stock parts, MRP/MPS plans this project's inventory with other non-allocated projects.

• Netting Group-CS - If the part is not a common stock part, MRP/MPS plans inventory for this project with other projects assigned to the same netting group (and the same Project Planning Option). For common stock parts, MRP/MPS plans this project’s inventory with other non-allocated projects.

• Netting Group-No CS - MRP/MPS plans inventory for this project with other projects assigned to the same netting group (and the same Project Planning Option) for all parts.

• All Projects - MRP/MPS plans this project’s inventory with other non-allocated projects (including common stock projects, if the part is a common stock part).

• No MRP Planning - MRP/MPS disregards all supply and demand for this project for planning purposes.

Netting Group

Enter, or use to select, the netting group ID for this inventory project. Establish netting groups in the Netting Groups (Materials » Production Control » Production Controls) screen. This option is available only if the option you selected in the Project Planning Option field requires a netting group.

Planning Warehouse

Enter, or use to select, the planning warehouse for this inventory project. This is used by Costpoint Material Requirements Planning and Master Production Scheduling to determine what warehouse should be assigned for planned orders, if the Plan Warehouses Separately check box is selected in the Corporate Settings subtask of the MRP Settings (Materials » Material Requirements Planning » MRP Controls) screen.

Planner

Enter, or use to select, the ID of the planner responsible for planning this inventory project. Use the options in the Planner Assignment group box in Production Control Settings (Materials » Production Control » Production Controls) to specify how planners should be assigned.

Last MO

Enter the last manufacturing order (MO) ID if MO IDs are auto-assigned by project.

Reorder RM Inv Abbrev

Enter, or use to select, a default raw material (RM) inventory abbreviation to be used on purchase requisitions whenever this inventory project is selected in the Inventory Reorder Report process (Materials » Inventory » Reports) .

Reorder FG Inv Abbrev

Enter, or use to select, a default finished goods (FG) inventory abbreviation to be used on manufacturing orders whenever this inventory project is selected.  This field is not currently used in inventory processing.

Common Stock Inv Abbrev

Enter, or use to select, the inventory abbreviation to be used by Costpoint Material Requirements Planning and Master Production Scheduling for common stock parts required for this project. This inventory abbreviation is only used if a common stock inventory abbreviation has not been assigned to the part in the Planning Part Data (Materials » Product Definition » Part Master) screen.

Inv Abbrev

Click this button to view and assign inventory abbreviations to this project, along with all relevant account and organization information.

Std Cost Accts

This button is currently unavailable.

Accounts

Click this button to open the Project Inventory Accounts subtask.

Table Information

Changes to this screen update the INVT_PROJ table.