Symptom
You cannot post a supplier invoice due to the exception: The item net amount is greater than the open XYZ of goods and services receipt ABC. (where ABC and XYZ aare amounts) Rounding differences are possible. The exception is of type Other Exceptions with status To Be Processed. Furthermore it is not possible to accept the exception via Actions -> Accept.
In the sub-tab Cost Distribution for the items, you notice that the Net Amounts differ from the Reference Net Amounts of the deliveries
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the work center Supplier Invoicing.
- Go to the view Invoices and Credit Memos.
- Select the invoice and choose Edit.
- Press Check. You get the error: The item net amount is greater than the open XYZ of goods and services receipt ABC.
Cause
Deliveries and invoices have different currencies. An issue occurred during the currency conversion. Furthermore, in the intercompany case, invoice item amount is not allowed to exceed delivery item amount and such error cannot be accepted.
Resolution
Scenario 1:
Enter the exchange rate manually on the invoice as per the exchange rate valid at the time of the transaction.
- Go to the work center Supplier Invoicing.
- Go to the view Invoices and Credit Memos.
- Select the invoice and choose Edit.
- Choose View All, go to the tab General.
- Go to the sub-tab Exchange Rates.
- Enter the Unit Currency (Invoice Currency).
- Enter the Quoted Currency (Delivery Currency).
- Enter the Exchange Rate that was there at the time of creation of the goods receipt as per the rate maintained in the work center General Ledger.
- The amounts will be recalculated, the exception will become Obsolete and the invoice will get the status Ready for Posting.
Scenario 2:
If in case after follwing scenario one steps you still get same error , you will have to reduce the exchange rate you maintained in invoice a bit to ensure that Supplier invoice amount is little less or exactly equal to the goods receipt amount
Here is the example of once such case which wil help you understand the issue better.
Whenever the Supplier invoice is created it would take the actual values from receipts if it exists. Since receipt in this case is in INR and invoice currency is in EUR, system would convert INR to EUR to calculate the net amount as 6.41 EUR after roundoff (ie., 500 INR / 78.03 = 6.407 EUR). later when you click on check button /save or post the Invoice then invoice will always check whether the total receipts amount matches the invoiced amount. In this case, the invooce amount would be 6.41 EUR * 78.03 = 500.17 INR.
Since there is a difference 0.17 INR, system is raising an exception.
however if you change the exchange rate to say for example without decimal that is 78 or 78.0001 then you will see that invoice status changes to ready for posting as the amount calculation is 6.41 EUR*78= 499.98
See Also
[Enter your See Also here...]
Keywords
KBA , gbp , usd , mxn , aud , cad , eur , AP-SIP , Supplier Invoice Processing , How To