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:

1. Stay in the Order tab

In the Order Number field:

2. Enter the order number
3. Click the Order Number
   • The Order Management window will open for that order

In the Order Management window:

4. Review & Determine the missing transaction in the various Order Management tabs

5. Complete the missing transaction

Completing the Missing Transaction

Complete the missing transaction in the system as you managed the physical product.

Canceled Orders

Unsourcing the Product

For all canceled orders, you must Unsource the Product.

Managing the Unsourced Product

To manage the unsourced product, Complete a Pool to Stock transfer, Pool to Garbage transfer, or Supplier Return.

Shipped Orders

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.