SAP Knowledge Base Article - Public

2745111 - Error: 'The sum of the credit quantities is greater than the sum of the debit quantities for the preceding supplier invoice item' while Creating Supplier Invoice with Reduced Quantity

Symptom

After changing the quantity of the Supplier Invoice to a reduced amount, system displays following errors:

The sum of the credit quantities is greater than the sum of the debit quantities for the preceding supplier invoice item
Item ABC: The sum of credit amounts is greater than the sum of debit amounts for the preceding supplier invoice item.
Item ABC: Credit amount greater than invoiced delivery amount
Item ABC: Credit quantity greater than invoiced delivery quantity

(ABC represents the Item ID)

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Supplier Invoicing Work Center.
  2. Go to the Invoices and Credit Memos View.
  3. Search and select the respective Purchase Order.
  4. Click New Invoice.
  5. Change the Quantity to a reduced amount.
  6. System displays the errors:

The sum of the credit quantities is greater than the sum of the debit quantities for the preceding supplier invoice item
Item ABC: The sum of credit amounts is greater than the sum of debit amounts for the preceding supplier invoice item.
Item ABC: Credit amount greater than invoiced delivery amount
Item ABC: Credit quantity greater than invoiced delivery quantity

Cause

The error happens for a Purchase Order followed by several Inbound Deliveries (or Goods Receipt) and a Return to Supplier (or Goods Return).

They are raised because the system can no longer match the Cost Distribution credit items to the respective debit items.

Whenever the invoice is created, the system proposes all the Inbound Deliveries (or Goods Receipts) including the Return to Supplier (or Goods Return).
Now when the Cost Distribution item referring to the Return to Supplier (or Goods Return) is present then the Inbound Delivery (or Goods Receipt) corresponding to the return should not be zero.

So, when the return has value greater than zero but the Inbound Delivery (or Goods Receipt) corresponding to the return has zero value. The reason behind this is the system tries to find these Inbound Deliveries (or Goods Receipts) for the returns in order to calculate the net effective quantity (sum of Inbound Delivery (or Goods Receipt)).

Resolution

To resolve this issue, it's necessary to adjust the amount of the Return to Supplier (or Goods Return) in the respective Inbound Delivery (or Goods Receipt), in the Cost Distribution tab. As following:

  1. Go to the Supplier Invoicing Work Center.
  2. Go to the Invoices and Credit Memos View.
  3. Search and select the respective Purchase Order.
  4. Click New Invoice.
  5. Change the Quantity to a reduced amount.
  6. Go to the Items Tab.
  7. Select the Item.
  8. Go to the Cost Distribution Sub-tab.
  9. Adjust the amount of the Inbound Delivery (or Goods Receipt) according to the linked Return to Supplier (or Goods Return).

Once this adjustment is completed, you should be able to post the Supplier Invoice with reduced quantity.

Keywords

cost distribution, credit amount, credit quantity, debit amount, debit quantity, supplier invoice , KBA , cost distribution , credit amount , credit quantity , debit amount , debit quantity , supplier invoice , AP-SIP-SIV , Supplier Invoice , How To

Product

SAP Business ByDesign all versions