Import master file of Debtor and Creditor via excel file on Delphi

Created by Cheng Kah Poh, Modified on Fri, 11 Sep, 2020 at 8:39 AM by Cheng Kah Poh

1st - Require Open Office

I will attach both Creditors and Debtors for importing, inside the format will have 2 examples.


Debtor and Creditor Master File

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 .


Step 2 - Save As dBase .


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 – Choose Creditor or Debtor > From table choose dbase format .


Step 8 - Control Account >Choose Trade Creditros.



Step 9 – Please Check on Require , If YES which is Compulsory to have which is yellow box in excel.To point dbase field same as Master Field .
Master Field Company Code , the From Field choose CompanyCode to match with it.
Same to Others Field.


Step 10 – After finish Match From Field Click Import .

Result as Below :

 


Full documentation please click  VIEW to display in PDF format. 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article