SQLAP-97150: You cannot cancel this invoice because the cancellation would reduce the quantity or amount billed on one or more purchase orders to be less than zero

SQLAP-97150: You cannot cancel this invoice because the cancellation would reduce the quantity or amount billed on one or more purchase orders to be less than zero.

In this post , We will be discuss about this issue,  SQLAP-97150: You cannot cancel this invoice because the cancellation would reduce the quantity or amount billed on one or more purchase orders to be less than zero. This issue comes when we trying to cancel the AP invoice , which is PO or PO Receipt matched in Payables. Here below i will share the complete detail about this.

Cause of the Issue :

If the Invoice Is PO and Receipt Matched then is the Cause :-

System has already created the RTV Invoice for Invoiced Quantity 10 for this supplier against Receipt 34456 . In this case , System cannot cancel the Main Invoice 'TEST INV02’ which is already matched with the same receipt because it will convert the final billed quantity for that Line into Negative as below.

Receipt 34456 Line No 2 Received Quantity =12

Receipt 34456 Line No 2 matched with Invoice ‘TEST INV02’  for Invoice Quantity =12

Now RTV happened for the Receipt 34456 Line No 2 for quantity = -12

RTV Invoice created for Receipt 20169 Line No 2 for Invoiced Quantity = -12.

So Now In Actual the Total Billed Quantity remained for Receipt Line # 2 = 0  (12-12)

But If we will cancel the Main Invoice  ‘TEST INV02’ which matched for Invoice Quantity =12 Then Billing Quantity will become for Receipt Line 2 is  : 0-12= -12.

If Invoice is Only PO Matched :-

This Standard Invoice is matched with Purchase order Test PO for PO Line Quantity 10 and the Credit memo is already created for the same Purchase order for the same Quantity 10. So now , system will not allow to cancel this Standard Invoice because it will be reduce the PO Invoiced Quantity to -10. 

Solution for this Issue :- 

Step1:- Need to run the Matching Detail Report for the PO or Receipt number , to find out the complete action happened against this invoice.

Step2:- If Invoice is PO matched Only then , We need to cancel the credit Memo first and then we can cancel the standard invoice.

If Invoice is PO and PO receipt Matched and RTV invoice created , then we need to cancel the RTV Invoice credit Memo first and then we can cancel the standard invoice.