Symptom
You have created a Supplier Invoice XYZ (XYZ represents the Supplier Invoice ID) for a Purchase Order followed by several Inbound Deliveries and a Return to Supplier.
When you change the quantity of an item in the Supplier invoice, you get the following errors:
- 'Item ABC: The sum of credit amounts is greater than the sum of debit amounts for the preceding supplier invoice item'.
- 'Item ABC: The sum of the credit quantities is greater than the sum of the debit quantities for the preceding supplier invoice item'.
(ABC represents the Supplier Invoice Item ID.)
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the Supply Invoicing work center.
-
Go to the Invoices and Credit Memos view.
-
Find XYZ.
- Select Edit.
-
Go to the Items Tab.
- For Item ABC, reduce the quantity.
The following error messages appear:
- 'Item ABC: The sum of credit amounts is greater than the sum of debit amounts for the preceding supplier invoice item'.
- 'Item ABC: The sum of the credit quantities is greater than the sum of the debit quantities for the preceding supplier invoice item'.
Cause
The errors are raised because the system can no longer match the Cost Distribution credit items to the respective debit items.
In the Cost Distribution tab for Item ABC, item ABC.A is a credit memo item representing the Outbound Delivery in the document flow (ABC.A represents the credit memo Cost Distribution Item ID). The system created it to refund the company after the goods have been returned to the Supplier.
Outbound Delivery DEF follows Inbound Delivery GHI in the document flow (DEF represents the Outbound Delivery ID, GHI represents the Inbound Delivery ID).
When you change the quantity of Item ABC in the invoice, the quantity of item ABC.C for the Inbound Delivery GHI is reduced in Cost Distribution (ABC.C represents the invoice item Cost Distribution Item ID.) This is done because the system automatically picks the last document created to remove from the cost assignment.
However, as the Outbound Delivery DEF follows the Inbound Delivery GHI, when the quantity of item ABC.C is reduced, the system can no longer match the costs correctly and assign the credit from the Outbound Delivery to the respective Inbound Delivery.
Resolution
To solve this issue, you can manually change back the quantity of ABC.C to its original value and reduce the quantity of any other item by the desired reduction value.
Once it is done, click Check and the errors will disappear.
Keywords
The sum of credit amounts is greater than the sum of debit amounts for the preceding supplier invoice item. The sum of the credit quantities is greater than the sum of the debit quantities for the preceding supplier invoice item. , KBA , supplier invoice , cost distribution , credit amount , credit quantity , debit quantity , debit amount , AP-SIP-SIV , Supplier Invoice , Problem
SAP Knowledge Base Article - Public