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
- Go to Supplier Invoicing work center.
- Select Invoices and Credit Memos view.
- Select the invoice which is to be canceled.
- Select Cancel Document button.
- 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