SAP Knowledge Base Article - Public

2552344 - Cannot Distribute Cost Among Other Invoices and Credit Memos When Import Supplier Invoices From Microsoft Excel

Symptom

When importing supplier invoices from Microsoft Excel, you find there is no field in the template to distribute cost among other invoices and credit memos.

Environment

SAP Business ByDesign

Reproducing the Issue

When you create a new supplier invoice without purchase order manually, you can distribute cost among other invoices and credit memos by following steps.

  1. Go to Supplier Invoicing work center.
  2. Create a new suplier invoice without purchase order.
  3. In the supplier invoice view, go to Item tab, Basic Data.
  4. Select Type as Additional Cost Debit Item.
  5. Go to Cost Distribution.
  6. Click Distribute among other invoices or credit memos, you will be able to select an invoice to distribut cost.

However, when you import supplier invoices from Microsoft Excel, you cannot find a filed in the template to distribute cost among other invoices and credit memos.

  1. Go to Supplier Invoicing work center.
  2. Go to the Invoice Entry view.
  3. Select New and Import from Microsoft Excel.
  4. You can see in the excel template, you can choose item type as Additional Cost Debit Item, but you cannot find a field to distribute cost among other invoices and credit memos.

Cause

Currently,

case 1.It is not supported to distribute cost among other invoices and credit memos when import supplier invoices from Microsoft Excel template.

case 2. It is not supported to distribute cost among other invoices and credit memos when invoice is in status In Approval.

Resolution

case 1..For this kind of supplier invoice, you need to create it manually.

case 2.Ensure supplier invoice is approved fully

Keywords

Import Supplier Invoice, Distribute Cost, Dump while distributing cost , KBA , AP-SIP , Supplier Invoice Processing , How To

Product

SAP Business ByDesign all versions