Inventory Value and 'Transaction Summaries' Enquery Form
The product release and version is R12.1.3. Cost Type is Average.
We have a specific problem. In 'Transaction Summaries' enquiry form, for some of the Items Net-Quantity is ZERO, whereas the NET-Value is > Zeros. After checking / investigation, it is found that STOCK Received into Stores, was issued before it was cost updated. In some cases stock was issued before new Average Cost could be calculated, consequently Cost-Variance was there.
Now how to correct / adjust this extra cost, so as the value in Inventory Organization matches to its Physical / Actual value ==> (Quantity * Unit-Cost).
In fact, we are looking for a direct or over-all solution. Otherwise, one of the the solutions, which is to adjust / update Item-wise Average Unit Cost or Adjust-Cost is known.