SAP Knowledge Base Article - Public

1972897 - Cannot Post Supplier Invoice Due to Exception "'The item net amount is greater than the open XYZ of goods and services receipt ABC"

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

  1. Go to the work center Supplier Invoicing.
  2. Go to the view Invoices and Credit Memos.
  3. Select the invoice and choose Edit.
  4. 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.

  1. Go to the work center Supplier Invoicing.
  2. Go to the view Invoices and Credit Memos.
  3. Select the invoice and choose Edit.
  4. Choose View All, go to the tab General.
  5. Go to the sub-tab Exchange Rates.
  6. Enter the Unit Currency (Invoice Currency).
  7. Enter the Quoted Currency (Delivery Currency).
  8. 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.
  9. 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

Product

SAP Business ByDesign all versions