Using this facility, you may also export certain data for the creditor (supplier / vendor) accounts in an open Set of Books to XML Database format, or any available format on your system. 

All the information regarding each account as entered in the Creditors (Default ribbon) menu (includes specific data for creditor accounts), will be exported in the selected file format. 

To export Creditors (Supplier) accounts: 

  1. On the Setup ribbon, select Export. The "Export Data to File" screen will be displayed.
  2. Click on the Creditors button. The screen will change to display the options for the Creditors: 
  3. Select and / or enter the following: 
    1. Export to - The installation directory in which TurboCASH5.2 is installed, will be displayed. You may click on the Browse icon to select a folder on the Browse for Folder screen. You may then select any available folder, or drive, on your system into which you wish to export the data.
    2. File type - Select to export the file in the XML Database (*XML), Comma Separated Variable (*CSV), Lotus Spreadsheet File (*WK1), MS Excel Spreadsheet (*XLS), or any other format available on your system from the list.
    3. Export files name - Enter the File name. You need to select this file at a later stage when you wish to import the file, or analyse the data in a spreadsheet.
    4. Log file - Enter the Log file name.
    5. Range - From ... To - The Creditors lookup will be automatically initiated. Select any range of accounts to include in the export file. 
    6. Increment Export - Leave this option blank.
  1. Click on the Export button. TurboCASH5.2 will create the export file, and save it in the specified directory.

The information for the Creditors, which will be exported, is: 

  • Account code. 
  • Description or name. 
  • Contact persons. 
  • Postal and Delivery addresses. 
  • Two Telephone numbers and Fax number. 
  • E-mail addresses. 
  • Credit limits. 
  • Charge amounts. 
  • Discount. 
  • Disabled account indicator. 
  • Remittance advise messages. 
  • Open item creditor indicator. 
  • Reporting groups 1 and 2. 
  • The last date a transaction was entered for the creditor accounts, will also be included into the selected export file.