Posts Tagged ‘insufficient inventory transactions with status Purchased’

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 ofPurchase 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:

  • Purchase Order: Image
  • PO Line:               Image
  • Inventory transaction:  Image

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.