Quantity invoiced is larger than quantity received on a PO

Question

It looks like we have a big mess here. I was cleaning up the purchases clearing report and ran across the issue below. How can this be unraveled? We have already paid the invoice. We are not going to get another 5 items. As for as the cost paid for these items, they are correct. The amount on the clearing report is $20.68. 
 Any ideas as to how to correct this? 
 25 @ $5.17 ordered quantity (will never receive the remaining 5) 
 20 @ $5.17 quantity received 
 25 @ $4.136 quantity invoiced (25 x 4.136 = $103.40 and 20 x 5.17 = $103.40) 
 
 Thank you!

Helium · Accepted Answer

I think you go into Receipt of Invoice and create an invoice for negative 25 at $4.136 ea. Then do another entry in Receipt of Invoice for positive 20 at $5.17 each. 
 
Then you can apply these two invoices to each other in Manual Check Entry.

Beevet · Answer

And after that, change the PO ordered amount to 20 also to close the PO.

TomTarget · Answer

Assuming that you really received only 20. (The inventory quantity is good).

Just do another receipt of INVOICE -5 with a 0 cost and update. That will create a $0 invoice.

Then change the PO ordered amount to 20 as per Beevet.

Sage 100

Quantity invoiced is larger than quantity received on a PO

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING