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
- In the Supplier Invoice Microsoft Excel template, you select 'Distribute Additional Costs (1)' as Yes.
- You find there is no column for you to enter reference invoice ID and item to distribute.
- Then you enter the reference purchase order ID and item ID in field 'Purchase Order ID (1)' and 'Purchase Order Item ID (1)' respectively.
- 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