PeopleSoft Cost Management

CMS9010 - On Hand Balance Validation Report

The report includes:

Field or Control	Description
Adjustments	This column includes differences between onhand quantities in PeopleSoft Cost Management and PeopleSoft Inventory. Reasons for these differences include: Inventory transactions from the TRANSACTION_INV table which have not yet been captured into PeopleSoft Cost Management. These uncosted transactions occur when inventory movement that has not yet been processed by the Transaction Costing process. Inventory items that have been picked but not shipped. The item's onhand quantity in PeopleSoft Inventory is updated, but a TRANSACTION_INV row has not been created. Instead, the information resided in the IN_DEMAND table and the DEMAND_PHYS_INV table. These picked but not shipped items must be included in the comparison of PeopleSoft Cost Management and PeopleSoft Inventory onhand quantities since they have already changed inventory quantities, but not the Cost Management quantities.

Field or Control

Description

Adjustments

This column includes differences between onhand quantities in PeopleSoft Cost Management and PeopleSoft Inventory. Reasons for these differences include:

Inventory transactions from the TRANSACTION_INV table which have not yet been captured into PeopleSoft Cost Management. These uncosted transactions occur when inventory movement that has not yet been processed by the Transaction Costing process.
Inventory items that have been picked but not shipped. The item's onhand quantity in PeopleSoft Inventory is updated, but a TRANSACTION_INV row has not been created. Instead, the information resided in the IN_DEMAND table and the DEMAND_PHYS_INV table. These picked but not shipped items must be included in the comparison of PeopleSoft Cost Management and PeopleSoft Inventory onhand quantities since they have already changed inventory quantities, but not the Cost Management quantities.