Exporting transaction and masterfile data
Description

You can export masterfile and transactional data as csv files.

Masterfile data

  • Customer Accounts
  • Supplier Accounts
  • Items
  • Assets
  • Accounts

Transactional Data

  • Customer Adjustments
  • Supplier Adjustments
  • Banking Transactions
  • Journal Entries
Cause
Resolution

Exporting masterfile data

  1. Go to Company then Export Data.
  2. Select what to export.
    • Export each masterfile separately
  3. Select Export Data.

Exporting customer adjustment

  1. Go to Customers then Transactions.
  2. Select Customer Adjustments then Quick Entry Grid.
  3. Select Show Previous Adjustments and select the date range.
  4. Click Refresh then Export Data.

Exporting supplier adjustments

  1. Go to Suppliers then Transactions.
  2. Select Supplier Adjustments then Quick Entry Grid.
  3. Select Show Previous Adjustments and select the date range.
  4. Click Refresh then Export Data.

Exporting banking transactions

  1. Go to Banking then Transactions.
  2. Select Banking then select Reviewed Transactions.
  3. Select the Date Range and click Refresh.
  4. Click Export.

Exporting journal transactions

  1. Go to Accountants Area then Process Journal Entries.
  2. Select Reviewed Journals and choose the date range.
  3. Click Refresh then Export.
Steps to duplicate
Related Solutions