SAP Knowledge Base Article - Public

2949941 - Import from Microsoft Excel Button Missing Under Invoice Entry

Symptom

The Import from Microsoft Excel button is missing in the Invoice Entry view of the Supplier Invoicing work center, which is preventing the upload of supplier invoices using the Excel template.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Supplier Invoicing Work Center.
  2. Go to the Invoice Entry View. 
  3. Select New and Import from Microsoft Excel button missing.

Cause

You have not specified your question ' Do you want to use a Microsoft Excel® template to upload supplier invoices?'. This option enables your company to efficiently upload a large volume of supplier invoices using Excel®.

Resolution

Please follow below steps to scope the question.

  1. Go to the Business Configuration Work Center.
  2. Navigate to the Implementation Project view.
  3. Select your implementation project.
  4. Click Edit Project Scope.
  5. Click Next till the Scoping step of the project.
  6. Ensure the scoping element Purchasing > Supplier Invoicing> Supplier Invoices and Credit Memos is marked.
  7. Click Next to the Quesitons Step of the project.
  8. Expand the scoping element Purchasing > Supplier Invoicing> Supplier Invoices and Credit Memos.
  9. Select the question 'Do you want to use a Microsoft Excel® template to upload supplier invoices?'.
  10. Click Next.
  11. Click Accept Preselected Answers.
  12. Click Finish.

Keywords

Import from Microsoft excel, button missing; Supplier Invoice excel upload, Add in, Excel , KBA , import from microsoft excel , siv upload via excel , supplier invoice excel upload , AP-SIP-SIR , Supplier Invoice Request , How To

Product

SAP Business ByDesign all versions