How to Import Master Data for Customers and Suppliers into N3 AI Accounting Using Excel CSV ©

Created by QNE Software Sdn bhd, Modified on Thu, 16 Apr at 4:21 PM by NUR AZREEN

Overview:

This guide will walk you through the process of importing master data for customers and suppliers into the N3 AI Accounting solution using Excel CSV files. By following the steps outlined in this guide, you will learn how to prepare your CSV file, ensure data accuracy, and successfully upload customer and supplier information into the system. This import feature helps streamline your accounting workflow and ensures that all your master data is accurately reflected in N3 AI Accounting, enabling smoother operations and better data management.

Solution:

CLICK HERE TO WATCH: Excel Migration Tutorial in QNE AI Cloud Accounting

Step 1 - User might need to download the Excel CSV template, Expand Company > Expand Tools > Press Data Migration > Then Press Upload CSV Files of Customers/Suppliers.

Step 2 - After Pressing, system will prompt out below screen > Press 'Download Sample'

Note:

Below is Customers Sample Excel CSV, those column header which with Asterisk ( * ) symbol is compulsory field

For Customer's Control Account please fill in account code which have Special Account Debtors Control Account.

For Supplier's Control Account please fill in account code which have Special Account Creditors Control Account.

For Customer's Excel CSV upload Status value need to update correct value as below:

Debtor Status

please input the number:

ACTIVE = 0,

INACTIVE = 1,

PROSPECT = 2,

SUSPENDED = 3

Creditor Status

please input the number:

ACTIVE = 0,

INACTIVE = 1,

SUSPENDED = 2

Step 3 - after complete the excel template, Back to import customer screen > Press Upload CSV

Step 4 - After Press Upload CSV, then below screen will prompt out

Step 5 - Press Click to Upload > Select the completed excel template > press Open.

Step 6 - File Uploaded Successfully appear > then press Import

Step 7 - Press Save Items

Done!

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software

System Scope: QNE AI Cloud Accounting / N3 AI Accounting