unit cost is zerodue to incorrect sequence of receipt and issue
User received an inventory item of quantity=2, unit_price=30 on 15-Jul-09 and then she entered misc issue for quantity=2 with transaction date as 6-Jul-09.
Now we have the item with zero unit cost and no on-hand quantity. Issue has transaction value as zero and 'Inv valuation' is also zero.
I am not sure why Oracle allowed issue with date 6-Jul-09, as at that time on-hand was zero for the item(item never received until 15-Jul-09).
any idea how we can correct this in the system?
Rgds,
-Kamal