Symptom
When uploading the Excel file to a requested Golden Tax Invoice, system reports errors:
error 1:Error in Excel upload template or Number of columns in Excel template.
error 2:Invoice header record for file is missing.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Customer Invoicing work center.
- Go to Golden Tax Invoices view.
- Show Requested Invoices.
- Select an invoice and click Upload button.
- In Attachment screen, click Add- File button, browser a saved Golden Tax Inbound Excel file which generated from Golden Tax software, click Add.
- Click Save button on the Attachment screen.
System shows the errors and you are not able to complete the Golden Tax process for the invoice.
Cause
When saving Golden Tax inbound file, system checks the number of columns in the Excel. For Aisino Shanghai Excel file, the number of columns is 31 and for Beijing file, it is 21.
To check which Golden Tax file type you are using:
- Go to Customer Invoicing work center.
- Select Golden Tax Master Data from Common Tasks view.
- In the table of File Master data, you maintained for example Golden Tax file Type as Aisino Excel File, and Excel Upload Template as Beijing.
In this case, you are using Aisino Beijing file type. When you uploading a file, system checks and detects additional columns in the Excel. These additional columns might be added without putting a column name. You need to remove these columns from the Excel.
Resolution
For Aisino Beijing Excel file type, system requires 21 columns from A to U.
For Aisino Shanghai Excel file type, system requires 31 columns are from A to AE.
You may delete 10 (or more) columns after column U (for Beijing type) or AE (for Shanghai type), and try to upload again.
See Also
You can find the Aisino Excel file template attached.
金税上传模板_Aisino上海.xlsx ==> Aisino Shanghia Excel template
金税上传模板_Aisino北京.xlsx ==> Aisino Beijing Excel template
Keywords
Golden Tax; upload; inbound file; Excel Template; Aisino Excel , KBA , AP-CI-CI-GLO , Cross-Country Extensions , Problem
Product
Attachments
金税上传模板_Aisino上海.xlsx |
金税上传模板_Aisino北京.xlsx |