1st - Require Open Office

Stock Items Template

The yellow color box which is compulsory column to fill.

After fill in everything Save it, open the excel file with Open Office and Save as dBase .


STEP AS BELOW:

Step 1 – After fill in info, open the excel format with Open Office .


Then Press Save.


Step 3 – Open QnE Business Solution > File > Utilities > Import and Export > Import Master Data From other Database .


Step 4 - After Click Import Master Data From other Database ,Below screen will pop-out .Note: For Safety , please do import after Backup .If already Backup then Click No .


Step 5 – After Click No .Below Screen will pop out > Select Dbase .


Step 6 - After Select DBase > Click Browse


Step 7 - Look For Stock/Service Item Tab 1st then drop down from Table, Select Stock Item.



Step 8 - User can press Posting Account 3dot button, to select the posting account.


Step 9 - Select Field accordingly



Step 10 - After Finish Select Require field



Press import.


Result