Import Creditor accounts

Parent Previous Next

This option will allow you to import data for creditor (supplier) records from a valid file format into an existing Set of Books. To be able to import the data for creditor (supplier) records, you need to have created a valid XML Database file, Lotus Spreadsheet file on your system in Setup → Export.

To import Creditor (supplier) accounts:

1.On the Setup ribbon, select Import. The Import Data into TurboCASH screen is displayed:

2.Select Debtors/Creditors as the Data Type to Import, if not already displayed.

3.Select one of the following file types in which the data to import, is saved on your system:

a)Comma Separated Value (*.CSV)

b)XML Database File (*.XML)

c)Lotus Spreadsheet File (*.WK1)

4.Click on the button to locate the data file. The following screen is displayed:

5.Click on the button to locate the data file.

6.Click on the button. The following screen is displayed:

7.Click on the Import button. The Import Check screen is displayed:

8.You may use the record buttons to add, delete or change the creditor (supplier) accounts records on the ImportCheck screen. You may then click on the All or OK buttons to import the creditor (supplier) accounts.

9.Once the import process is finished an information message "Data file import completed!" will be displayed. Click on the OK button.  

10.Go to the Reports ribbon and select Reports → Creditors  → Listing menu to check that the creditor (supplier) accounts are correct.

11.If you need to edit the debtor creditor (supplier) accounts, go to the Action ribbon and select Creditor.

Created with the Personal Edition of HelpNDoc: Full-featured Documentation generator