Costing Discrepancy
Hello,
We are getting some discrepancy between PHYSICAL_INV and CM_ONHAND_VW. The later shows positive on hand qtys while PHYSICAL_INV has 0 qty. When we query TRANSACTION_INV, CM_RECEIPT and CM_DEPLETE, we see the the sum of depletions is little short to negate the stock.As if some depletions never happened.
Question is, how can PHYSICAL_INV show 0 qty if the stock is not fully depleted? Or, could there be transactions that may not be recorded in TRANSACTION_INV?
Any thoughts are welcome!
Regards,
Nabarun
0