SAP Knowledge Base Article - Public

3199474 - Reconciliation account field is not available in supplier invoice excel template

Symptom

Reconciliation account field is not available in supplier invoice excel template

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Supplier Invoicing Work Center.
  2. Go to Invoice Entry View.
  3. Click on New -  Import from Microsoft Excel" button.
  4. In the downloaded excel template, there is no Reconciliation Account field.

Cause

This field is not available in current standard supplier invoice excel template.

Resolution

You could contact ByDesign partner to create extension field in the excel and then try to upload. P

lease refer this attached document and SCN blog how to create extension field in excel template.

SCN blog - https://blogs.sap.com/2014/07/28/how-to-customize-excel-import-template-example-for-marketing-leads/comment-page-1/#comment-387507

This field is currently available in supplier invoice webservice and migration template.

Please kindly check if any one of these options can be a workaround for your request.

If you still want it to be added in excel template as standard field, we sincerely recommend you post the requirement in customer influence forum:  https://influence.sap.com/sap/ino/#/campaign/886

This is our official channel to address all new requirements.

Keywords

Reconciliation Account, Supplier Invoice, Excel, Template, 统驭科目,Webservice,Migration,供应商发票 , KBA , SRD-SRM-SI , Supplier Invoicing , Problem

Product

SAP Business ByDesign all versions