Accounting flat file

If your ERP-system can receive a flat csv file, choose the integration plugin AccountingCsvExporter in menu Auotpilot - Tab Integrations.

1. Click on the plus sign, choose the plugin. Give it a name in tab Overview.

2. Fill in the format settings.

    Type in the delimiter you want to have in the file.

    Fill in the file suffix (csv or txt or leave blank, then no file suffix).

    Interface, export date and Journal Entry number will build up the file name if you leave the File name field blank.

    For example TS (stands for Treasury Systems).

    Fill in if you want to have separate file names for realized, unrealized and reverse of unrealized files.

    The file name with below parameters will be TS_YYMMDDXXXX_REAL.csv. The XXXX is a unique Journal Entry number.

    Click on button Apply for save the parameters.

3. Mappings

    Add the different fields you need in your file by clicking on the plus sign.

    In the Expression you can choose from different menus to select which kind of values you will add, for example in                   Accounting Value you find the account number.  

    You need to adjust the format for Amounts and Dates.

    You can add many more fields than in this example.

    Note; A consultant can help you with the different Expressions.

4. In History tab you will see the result of exporting the accounting files.

5. In Advanced tab you see the folder the files will be exported to in Azure.