Understanding Integration with PeopleSoft Inventory

You can integrate fulfilled demand from Inventory to Project Costing. Fulfilled demand is placed through inventory costing on the Inventory Accounting Distribution table (CM_ACCTG_LINE) where it can be picked up by PeopleSoft Project Costing and brought in as a transaction. Rows in the Inventory Accounting Distribution table are eligible for integration if they:

  • Contain values for the required project-related ChartFields.

  • Have a PC Distribution Status status of N (not distributed).

The Inventory to Project Costing Application Engine process (PC_IN_TO_PC) updates the PC Distribution Status to D (distributed) and copies the transactions to the Project Transaction table. If you use PeopleSoft Maintenance Management, the process also imports the work order business unit, work order ID, task ID, work order resource type, and work order resource line into the Project Transaction table.

Fulfilled demand is brought into PeopleSoft Project Costing as transactions with the analysis type that is specified in the Inventory field (PC_AN_TYPE_IN) on the Installation Options - Project Costing Integration page. The Inventory field delivered default value is ACT.