Share via

(FRA) Setup to export financial data

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

You must create definition groups to export data. Definition groups define the tables and formats that are used to export data.

Note

This topic has been updated to include information about features that were added or changed in Microsoft Dynamics AX 2012 R3, AX 2012 R2 with hotfix KB2922493, and AX 2012 with hotfix KB2922493. The first section below applies to AX 2012 R2 and AX 2012 without these hotfixes. The second section includes information about the updated functionality.

Set up to export financial data in AX 2012 and AX 2012 R2

Create data export definition groups

Use the Data export definition groups form to create definition groups.

  1. Click General ledger > Periodic > Data export > Data export definition groups.

  2. Create a definition group.

  3. In the Definition group and Name fields, enter an identification code and name for the data export definition group.

Create data export tables

Use the Data export tables form to define the data export table and file name for a definition group.

  1. Click General ledger > Periodic > Data export > Data export definition groups.

  2. In the Data export definition groups form, select a definition group, and then click Data export tables to open the Data export tables form.

  3. Click New or press CTRL+N to create a record, and then in the Data export table and File name fields, enter a data export table name and a file name.

Create data export fields

Use the Data export fields form to create data export fields and assign the tables and fields to extract the data from. The information from the fields is exported for a report.

  1. Click General ledger > Periodic > Data export > Data export definition groups. Select or create a definition group, and then click Data export tables.

  2. In the Data export tables form, select or create a table record, and then click Data export fields to open the Data export fields form.

  3. Select the tables in the All tables list, and then click > to move the selected tables to the Selected tables list.

  4. Select the tables in the Tables related to the selected tables list, and then click > to move the selected tables to the Selected tables list, if required.

  5. Click Next > to define the data export fields.

  6. Press CTRL+N to create a data export field.

  7. In the Data export field and Description fields, enter a field name and a description.

  8. In the Table field, select a table.

  9. In the Field field, select a field.

  10. Select the Primary key check box to use the field as a primary key, if required.

  11. Repeat steps 6 through 10 to add additional data export fields.

  12. Click Finish.

  13. In the Data export tables form, in the Data export field for period field, select a date field. The value in this field is evaluated when the transactions are included in the range of dates to be exported.

Set up to export financial data in AX 2012 R3, AX 2012 R2 with hotfix KB2922493, and AX 2012 with hotfix KB2922493

Create data export definition groups

Use the Data export definition groups form to create definition groups.

  1. Click General ledger > Periodic > Data export > Data export definition groups.

  2. Create a definition group.

  3. In the Definition group and Name fields, enter an identification code and name for the data export definition group.

Create data export tables

Use the Data export tables form to define the data export table and file name for a definition group. You can use a predefined query to create a data export table that is used to export financial transaction data from Microsoft Dynamics AX as a text file. When you use a predefined query for a data export table, the filtering details and sorting orders that are specified in the query are used to export the financial transaction data.

  1. Click General ledger > Periodic > Data export > Data export definition groups.

  2. In the Data export definition groups form, select a definition group, and then click Data export tables to open the Data export tables form.

  3. Click New or press CTRL+N to create a record, and then in the Data export table and File name fields, enter a data export table name and a file name.

    –or–

    In AX 2012 R3: Click Query to use a predefined query to create a data export table.

Create data export fields

Use the Data export fields form to create data export fields and assign the tables and fields to extract the data from. The information from the fields is exported for a report. You can use predefined methods for the data transformation when you export data from the tables and fields.

  1. Click General ledger > Periodic > Data export > Data export definition groups. Select or create a definition group, and then click Data export tables.

  2. In the Data export tables form, select or create a table record, and then click Data export fields to open the Data export fields form.

  3. Select the tables in the All tables list, and then click > to move the selected tables to the Selected tables list.

  4. Select the tables in the Tables related to the selected tables list, and then click > to move the selected tables to the Selected tables list, if required.

  5. Click Next > to define the data export fields.

  6. Press CTRL+N to create a data export field.

  7. In the Data export field and Description fields, enter a field name and a description.

  8. In the Table field, select a table.

  9. In the Field field, select a field.

    –or–

    In AX 2012 R3: In the Method field, select a method to use a predefined data transformation. Use the following table to decide which method to use.

    Method name

    Description

    deAbsoluteAccountingCurrencyAmount_FR

    Use this method to export the absolute amount in the accounting currency.

    deDirection_FR

    Use this method to export the direction of accounting. This method displays D for debit amounts and C for credit amounts.

    deLedgerAccount_FR

    Use this method to export the main account for an entry.

    deLedgerAccountName_FR

    Use this method to export the main account name for an entry.

    deEmptyValue_FR

    Use this method to export an empty value.

    deJournalCode_FR

    Use this method to export the first five characters of the value in the SubledgerVoucher field.

    deJournalLib_FR

    Use this method to export the value in the JournalCategory field. If the JournalCategory field is blank, then this method exports the value in the Type field from the related TransactionLog record.

    dePieceNum_FR

    Use this method to export the value in the DocumentNumber field. If the DocumentNumber field is blank, then this method exports the value in the SubledgerVoucher field.

    dePieceDate_FR

    Use this method to export the value in the DocumentDate field. If the DocumentDate field is blank, then this method exports the value in the AccountingDate field.

    deEcritureLib_FR

    Use this method to export the value in the Text field. If the Text field is blank, then this method exports the value in the Txt field from the related TransactionLog record.

  10. Select the Primary key check box to use the field as a primary key, if required.

  11. Repeat steps 6 through 10 to add additional data export fields.

  12. Click Finish.

  13. In the Data export tables form, in the Data export field for period field, select a date field. The value in this field is evaluated when the transactions are included in the range of dates to be exported.

See also

(FRA) Export financial transaction data to an archive file

(DEU, FRA) Data export tables (form)