How to: Resolve discrepancies between the physical inventory count and the WIP valuation report.
Environment: Comsense Enterprise
In this article:
Understanding Discrepancies Between Physical Inventory & the WIP Valuation Report
A discrepancy between physical inventory and the WIP Valuation report occurs when you physically move/manage a product but do not complete the transaction in Comsense. People often only find discrepancies during the physical WIP count. To resolve a discrepancy, you must determine and complete the missing transaction in the system. The protocols to resolve a discrepancy are applicable to all scenarios but the exact procedures may vary for the order or product.
Finding a Discrepancy
Complete a physical count of the WIP inventory in your warehouse and Mark any discrepancies on the WIP count sheet.
Determining the Missing Transaction
It is best to review and determine the order with the missing transaction in WIP Valuation window. The WIP Valuation window displays the valuation values by order number and each order number opens to the project or sales order in the Order Management window.
Accessing WIP Valuation
Enterprise > Inventory/Purchasing > WIP Valuation
In the Select Divisions window, Select the applicable division(s) Using the Selection Tool and Click OK.
The WIP Valuation window will populate.
Reviewing the Order with a Discrepancy
In the WIP Valuation window:
- Stay in the Order tab
In the Order Number field:
- Enter the order number
- Click the Order Number
- The Order Management window will open for that order
In the Order Management window:
- Review & Determine the missing transaction in the various Order Management tabs
- Complete the missing transaction
Completing the Missing Transaction
Complete the missing transaction in the system as you managed the physical product.
Unsourcing the Product
For all canceled orders, you must Unsource the Product.
Managing the Unsourced Product
In some cases, you may have physically shipped an order without completing the shipment in the system. For any missed orders, Ship the Product to the Customer.