Issue: We have a PO that has been received a long time ago and this PO has invoice remainder but when posting the invoice we get an error of “Purchase order: PO702022 – Item number: 00112009 – Insufficient inventory transactions with status Purchased.“
Expectation: We are going to post a invoice of the remaining quantity and then PO status should be ‘Invoiced’.
Solution:
As you see above, there is a purchase order line that has invoice remainder 125 for item 00112009. however, if you look at the inventory transaction for this item by using Inventory > Transactions you will find 2 open transactions which Receipt status = ‘Received’ need to be invoiced.
Somehow the data for this PO and item has corrupted and business user want to find a way to close this PO. so what I did is to update the quantity of invoice remainder to match values in the transactions that is 598 (473 + 125) and do post invoice again.