Symptom
The Excel upload functionality for Supplier Invoice creation is limited to 19 Invoices at a time.
Environment
SAP Business ByDesign 2411
Reproducing the Issue
- Navigate to the Supplier Invoicing work center.
- Go to the Invoice Entry view.
- Click on New and select the option Import from Microsoft Excel.
- The Excel template opens, enter the relevant details, log in to the system from Excel and save the data.
- The system processes the upload and displays the Invoice document IDs created.
Cause
The system is designed to create only 19 invoices when the default Excel upload template is used. Even though extra lines are added manually and saved, the system does not upload these lines as it considers them as read-only.
Resolution
The default Excel upload template allows the creation of only 19 Invoices, which can be entered in the template (template contains 25 lines in total in the excel).
Extra lines added manually into this excel template and saved will not be uploaded as they are considered read-only. System creates the Invoice for first 19 lines and the rest will be left blank. Go with manual invoice creation, if the requirement is more than 19.
Post this as a new requirement in the customer influence forum.
Influence forum: https://influence.sap.com/sap/ino/#/campaign/886
See Also
2056236 - Line Items per Purchase Order Limited to 30 During Excel Upload
Keywords
Limitation in excel upload , 19 invoices, supplier invoice upload , KBA , SRD-SRM-SI , Supplier Invoicing , Known Error
SAP Knowledge Base Article - Public