Symptom
You would like to know how to add any Extension Field to the Microsoft Excel Template, as you have noticed that when opening the Supplier Invoice Excel Template, some of the fields are not displaying as expected or when updating an already maintained fields in the Excel template, the values are not getting retrieved by the system for newly created entries.
Environment
SAP Business ByDesign
Reproducing the Issue
- Open the Excel Template.
- See that the expected field is not available.
Cause
Not all fields are available in the Standard Excel Template, the change need to be done by Partner. If you already added the field and is still not being displayed, the extended field could be mapped incorrectly in XML.
Resolution
Please contact your partners to go through the details given in the document attached to resolve this issue.
Restructure the excel mapping for extension field and try updating the same.
See Also
For more information on how to add an Extension Field in the Excel, please check the following Blog post:
How to Add Extension Field in Supplier Invoice Upload Excel Template?
Keywords
Add Extension Fields to Excel, Extension Field, Excel Add-in, Microsoft Excel , KBA , how to add extension fields , extension field , add extension fields to excel , add field to excel , SRD-MD-PRD-PRD , Product , AP-POP-PO , Purchase Order , How To
Product
Attachments
Adding ext fields to excel.pdf |
How to add the extension field in Excel.docx |