Export and import mappings by taxonomy account

Taxonomy accounts are mapped to chart of accounts.

The taxonomy account mappings can be exported and imported. For example, exported from a test environment and imported in a production environment.

To export taxonomy account mappings:

  1. In LN, navigate to Financials > Master Data > General Ledger > Structure to start the Taxonomies (tfgld1170m000) session.
  2. Go to the details of a taxonomy with status Draft, select a taxonomy account with sublevel 0 (zero), and click the Ledger Mapping button.
  3. To export mappings for all taxonomy accounts in one go, select Sort by > Taxonomy, Ledger Accounts in the Views menu.
  4. Select all records (CTRL+A) and click the Quick Export button in the menu.
  5. The warning Max export limit reached. Only the first xxx rows have been exported may be displayed. If that is the case, repeat the process to export remaining records.

    Tip: you can reduce the number of records to export, by excluding mappings to the account starting with 9997 in the quick filter bar. After import, mappings to account 9997 can be restored by using Assign not yet Assigned Ledger Accounts in the Actions menu of the taxonomy account session.

To import taxonomy account mappings:

  1. In LN, navigate to Financials > Master Data > General Ledger > Structure to start the Taxonomies (tfgld1170m000) session.
  2. Go to the details of a taxonomy with status Draft, select a taxonomy account with sublevel 0 (zero), and click the Ledger Mapping button.
  3. To import mappings for all taxonomy accounts in one go, select Sort by > Taxonomy, Ledger Accounts in the Views menu.
  4. Select Import in the Actions menu and select the upload file, which is the file that contains the exported mapping.

    Important: select Import Records in the Overview Session.

  5. Repeat the import if multiple files were exported.

    If you excluded mappings to the account starting with 9997 during export, restore this mapping. Select taxonomy account 9997 and use option Assign not yet Assigned Ledger Accounts in the Actions menu of the taxonomy account session.

Note: The procedure to import mappings differs from importing taxonomies and taxonomy accounts, which must be executed in advance and is described in the Infor LN Analytics for Birst Administration Guide.