Symptom
When creating credit memo for supplier invoice, there is an exception saying: The average net price for 1 UoM is greater than the price of purchase order XXX. Rounding differences are possible.
Environment
SAP Business ByDesign
Reproducing the Issue
For better illustration, using specific figures in the below example:
- Create a Purchase Order XXX. The ordered quantity is 63 ea (600 EUR/ea), and the total net amount is 37,800 EUR.
- Create a Supplier Invoice YYY. The invoiced quantity is 63 ea, and the total invoiced net amount is 37,800 EUR.
- Create a Credit Memo ZZZ. The quantity is 1 ea, the total gross price is 283 EUR, and the net amount is 268.25 EUR (tax excluded).
- Click Check button in Credit Memo ZZZ, there is an exception: "The average net price 605,35 EUR for 1 ea is greater than the price 600,00 EUR of purchase order XXX. Rounding differences are possible".
Cause
As per the system design, the average net price is calculated as below:
- Actual value = Total net amount of Supplier Invoice - Total net amount of Credit Memo
- Actual quantity = Total invoiced quantity - Total credit memo quantity
- Average net price = (Actual value / Actual quantity ) * price unit
In the above example:
- Actual value = 37,800 EUR - 268.25 EUR
- Actual quantity = 63 ea - 1 ea
- Average net price = (37,800 EUR - 268.25 EUR)/ (63 ea - 1 ea) = 605.35 EUR
Resolution
To keep the value in credit memo, accept price variance. Otherwise, maintain the same gross price as the one in supplier invoice.
Keywords
Credit Memo; Average Price; Rounding Difference; Supplier Invoice; Purchase Order , KBA , SRD-SRM-SI , Supplier Invoicing , AP-SIP , Supplier Invoice Processing , AP-SIP-SIV , Supplier Invoice , Problem