Skip to main content

Accounting Inventory Transactions: Export & Import CSV files for sales and purchase invoices

Information on exporting billing data and generating invoice listings in Excel

Updated over a month ago

This guide explains how to export and import transactions in the UBS Inventory & Billing System. You will learn how to export transaction files to CSV format and import them back into the system. Follow the steps carefully to ensure accurate data transfer.

Export CSV Files

  1. Go to Periodic, Export / Import, Export to CSV File.

  2. You will need to export both ARTRAN & ICTRAN using the below option:

    1. COPY ARTRAN.DBF TO ARTRAN9.CSV

    2. COPY ICTRAN.DBF TO ICTRAN9.CSSV

  3. After you click on the OK button.

  4. Select the transaction that you want to export and click the OK button to export the transaction.

Import CSV Files

  1. Go to Periodic, Export / Import, Import from CSV File

  2. Select [IMPORT FROM ARTRAN9.CSV/ICTRAN9.CSV] option

    1. Ensure that you have ICTRAN9.CSV and ARTRAN9.CSV to do the import

  3. Click on the OK button to import the transaction.

Did this answer your question?