Import Master file of Stocks via Excel file on Delphi

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