SAP Knowledge Base Article - Public

3263929 - Not possible to upload supplier invoice with additional cost debit item via excel template

Symptom

Errors when uploading supplier invoice with Additional Cost Debit Item via Microsoft Excel:

  • Sum of percentages should be 100%.
  • It is not possible to distribute the costs. Add one or more items among which you distribute costs, or increase the quantity and amount of the existing items (must not be zero).
  • Purchase document locked/Product differs from product of purchase document

Environment

SAP Business ByDesign

Reproducing the Issue

  1. In the Supplier Invoice Microsoft Excel template, you select 'Distribute Additional Costs (1)' as Yes.
  2. You find there is no column for you to enter reference invoice ID and item to distribute.
  3. Then you enter the reference purchase order ID and item ID in field 'Purchase Order ID (1)' and 'Purchase Order Item ID (1)' respectively.
  4. After saving data into the system, you have the invoice created with errors:
    • Sum of percentages should be 100%.
    • It is not possible to distribute the costs. Add one or more items among which you distribute costs, or increase the quantity and amount of the existing items (must not be zero).
    • Purchase document locked/Product differs from product of purchase document

Cause

The upload of Additional Debit Invoices will only do 'uploading to system'.

There's a separate action required here, which is to select 'Distribute among other invoice or credit memos'.

You must then select the reference document and trigger the distribute action in the system manually.

Resolution

This is current system behavior.

See Also

2532815 - Distribute Cost Among Invoices and Credit Memo Items

Keywords

Additional cost debit item, Microsoft Excel, Excel template, Sum of percentages should be 100%, It is not possible to distribute the costs, Purchase document locked, Product differs from product of purchase document, 百分比总和应为 100%, 采购单据的供应商与发票的不同, 无法分摊成本, 附加成本借记项目 , KBA , SRD-SRM-SI , Supplier Invoicing , Problem

Product

SAP Business ByDesign all versions