SAP Knowledge Base Article - Public

1642296 - Credit value greater than invoiced order value or limit

Symptom

You are unable to post Cancellation Invoice due to this error message or below error message.

or

You are unable to post credit memo Invoice due to this error message or below error message.

or

Credit memo value is greater than invoice value. There is a discrepancy between the value of the order item or limit item in the purchase documents.

or

"credit amount greater than invoiced order amount"

"credit Quantity greater than invoiced order Quantity"

"credit amount greater than invoiced delivered amount"

"credit Quantity greater than invoiced delivered Quantity"

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Supplier Invoicing work center.
  2. Select Invoices and Credit Memos view.
  3. Select the invoice which is to be canceled.
  4. Select Cancel Document button.
  5. Select Post button.

Cause

Cause 1:

The supplier invoice is created with currency ABC , But the Purchase order is created with currency PQR.

Here currency in Purchase order and Invoice is different and thus exchange rate is required.

Since Currency Conversion is done according to the posting date of the supplier invoice DD:MM:YYYY (say aa:bb:xxxx).  please consider below two types.

Type 1.

If the posting date in  Invoice and cancellation invoice is same  but exchange rate is In active  on that date and now you have a new exchange rate with same  rate

If Currency Exchange Rate for the currencies PQR and ABC is maintained as XX  valid on  DD:MM:YYYY (say aa:bb:xxxx).

later a new Currency exchange rate is maintained on DD:MM:YYYY (say ee:gg:yyyy) for PQR and ABC as ZZ.

When an invoice is being canceled the whole history of the purchase order is being checked; the invoiced value of the PO is not allowed to be smaller than the value to be canceled.

All values to be compared are being converted to the PO currency (PQR).
The value of the cancellation item is now also converted for the date aa:bb:xxxx but the rate had been changed to ZZ which leads to the error message.

Type 2.

If the posting date in cancellation invoice and  original invoice  are different and there is  difference in  exchange rates on those dates.

Cause  2:

The actual invoice is not linked properly to purchase order, that is its not appearing in the document flow of Purchase order, thus due to this inconsistency error appears in the invoice cancellation document.

Cause 3: The credit amount is greater than original invoice linked to it.

Cause 4: Ensure that original invoice is not paid before posting cancellation invoice

Resolution

Resolution for cause 1:

Type 1:

Change the posting date of the cancellation invoice to DD:MM:YYYY (ex ee:gg:yyyy) or later in cancellation invoice.

Type 2:

Change the exchange rate  to same as what was there on the Posting date of Original invoice

 or

Change  the posting date of cancellation invoice/credit memo same as original invoice

Resolution for cause 2:

 kindly raise case and we shall fix it in back end

Resolution for cause 3:

In the cost distribution tab of cancellation invoice/credit memo you can see the  original invoice linked  to it, ensure that both invoices amounts are matching

Resolution for cause 4:

 Cancel the payment on Original invoice and then try to cancel it.

Keywords

Value greater,  invoice cancellation,Credit amount greater than invoiced order amount or limit,Credit quantity greater than invoiced order quantity, Credit quantity greater than invoiced delivery quantity, Credit amount greater than invoiced delivery amount,Credit value greater than invoiced delivery value , KBA , credit quantity greater than invoiced or , credit value greater than invoiced order , supplier invoice , cancel document , invoice cancellation , cancellation invoice , SRD-FIN-GL , General Ledger , AP-SIP-SIV , Supplier Invoice , How To

Product

SAP Business ByDesign all versions