Symptom
Exception encountered: "Item net amount exceeds open XYZ of goods and services receipt ABC." Variance potentially attributable to rounding differences.
Exception Type: Other Exceptions
Status: To Be Processed
Resolution Attempt: Accept action via Actions -> Accept not feasible.
Additional Findings: In the Cost Distribution sub-tab, discrepancies noted between Net Amounts and Reference Net Amounts of the deliveries.
Environment
SAP Business ByDesign
Reproducing the Issue
-
1. Go to the Supplier Invoicing work center.
2. Open the Invoices and Credit Memos view.
3. Choose the relevant invoice and select Edit.
4. Click on Check.
Error Message:
"The item net amount exceeds 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 the error persists after following the specified steps, adjust the exchange rate maintained in the invoice. Ensure the Supplier invoice amount is slightly less than or exactly equal to the goods receipt amount.
The following case exemplifies the issue for clarity.
Whenever a supplier invoice is created, the actual values from receipts are used if they exist. In this case, the receipt is in INR, and the invoice currency is in EUR. The system converts INR to EUR to calculate the net amount as 6.41 EUR after rounding (500 INR / 78.03 = 6.407 EUR). Subsequently, when the check button is clicked, or the invoice is saved or posted, the system verifies whether the total receipt amount matches the invoiced amount. In this scenario, the invoice amount would be 6.41 EUR * 78.03 = 500.17 INR.
Since there is a difference 0.17 INR, system is raising an exception.
Adjusting the exchange rate, for example, to a whole number such as 78 or a value like 78.0001, results in the invoice status changing to 'Ready for Posting,' as the amount calculation becomes 6.41 EUR * 78 = 499.98.
Keywords
Cannot post Supplier Invoice, Exchange rate, Unit Currency, Quoted Currency , KBA , gbp , usd , mxn , aud , cad , eur , AP-SIP , Supplier Invoice Processing , How To