IO Import Export Template with e-Invoice columns

Overview:

In version 2024.1.0.8, QNE has enhanced specific required fields in the IO Export/Import feature.

Scenario:

In Sales Invoice, export the template by using IO function. System will include e-Invoice required fields in the template, user can update accordingly.

 There are some required fields that the user should refer QNE code example State, Country, TIN Type, Stock Classification.    

Solution:

1. In Sales Invoice listing, select the transaction > right click > IO > to Excel

2. Save the excel file to a folder

3. Double click the excel file, the e-Invoice fields is already exist. Update the column accordingly for importing purpose.    

 As some of the columns have to follow QNE format because they are stored in table. Example State, Country, TIN Type, Stock Classification and Supplier Self-Billed Type

4. To update customer TIN Type in Sale Invoice, it means ‘DebtorTINType’ in excel 

5. Kindly refer the table or attachment to update code instead of the description in the excel 

Refer to the table, update State ‘Code’ instead of ‘Statename’. E.g. Update ‘ 01 ‘ in the column of ‘DebtorCountryState’ instead of the description as ‘Johor’  Note: you should update as ‘ 01 ’ instead of ‘ 1 ’ 

6. To update Customer Country, it means ‘DebtorCountry’ in the excel 

Update Country Code instead of Country Name in the excel. Refer to attachment – ‘QNE IO Import Table & Code’ for all country codes 

7. To update Stock Classification in the transaction,     

It means ‘Classification’ in the excel 

Update Classification Code instead of description in the excel. Refer to attachment – ‘QNE IO Import Table & Code’ for all Classification codes

8. To import Purchase module transaction, there will be a column namely ‘Self-Billed Type. To update Supplier Self-Billed Type, it means ‘CreditorSelfBillType’ in the excel  

Update ‘CreditorSelfBillType’ instead of description in the excel.

Note: 

 When exporting the template, the Debtor Code is located in column ‘U,’ with e-Invoice required fields listed before it.
 

If you update any value in the Excel file that differ from those in Customer Maintenance, the system will display data from Customer Maintenance in Sales Invoice transaction
 

For example, if you set the Debtor City to "Serdang" in Excel but it is "Seri Kembangan" in Customer Maintenance, the imported Sales Invoice will show "Seri Kembangan."

 In short, whether or not you update the e-Invoice fields in Excel, the system will always follow the values in Customer Maintenance.

If you want the system follow the Excel values instead of Customer Maintenance, move the ‘Debtor’ column to the front (e.g. in Column C) 

For example, if you maintain a customer code as ‘Walk in Customer’ in customer maintenance

For every time you import the excel file you will update customer information, thus please move the ‘Debtor’ column to in front so that system will follow the value from the excel instead of Customer Maintenance

Kindly refer attachment for the PDF file and QNE IO Import Table & Code