Working With National Transfer Exceptions

The National Transfer Exceptions app allows users to exclude selected national temporary differences from being transferred to regional calculations. This functionality eliminates the need to manually reverse temporary differences in regions where they are not applicable.

The National Transfer Exceptions app can be used to:

• Import accounts from a file to update Transfer Exceptions.
• Manage accounts to exclude selected national temporary differences from being transferred to regional calculations.
• Export accounts to a file for import into another system.

Importing National Transfer Exceptions

The import option in the National Transfer Exceptions Accounts dialog allows you to update National Transfer Exceptions accounts in the database from a .csv file.

To import National Transfer Exceptions:

1. Click on National Transfer Exceptions. A prompt appears.
2. Under Option, select Import.
3. In the File field, click Browse and select the appropriate .csv file to import.
4. In the Root Hierarchy field, select the hierarchy to which you want to import the accounts.
5. Click OK. A table will be displayed showing the summary of all actions performed by the import.

Note: If there are any issues with the file, a table will be displayed indicating the issues. No changes will be made.

.csv file example

where:

Managing National Transfer Exceptions

The Manage option in the National Transfer Exceptions dialog allows you to select the account for which you want to manage transfer exceptions.

To manage a National Transfer Exceptions:

1. Click on National Transfer Exceptions. A prompt appears.
2. Under Option, select Manage.
3. In the Accounts field, select the account for which you want to update the exceptions.
4. Click OK.

National Transfer Exceptions Screen

The National Transfer Exceptions screen is used to define region-level exclusions for national temporary differences. The screen contains the following components:

Toolbar Options

Click Apply to save changes made to Transfer Exceptions.

Click Refresh to refresh the list of accounts.

Click Symbols to change the selected account and refresh the list of accounts.

In either case, if there are any unapplied changes, you will be prompted to apply or discard any changes that have not yet been applied.

• Choose Apply Changes to apply any changes made and then refresh the list of accounts. If there are any errors, the refresh will not be performed.
• Choose Discard Changes to discard any changes made and then refresh the list of accounts.
• Click Cancel to return to the table without refreshing the list of accounts.

Click Print Preview to display a printable view of the current grid.

Click Export to Excel to export the displayed data to Microsoft Excel.

Click Search to filter accounts within the hierarchy. For more information, refer to Searching Tables.

1. Account

   It displays temporary difference accounts under TempT##+99 in a hierarchical structure. Parent accounts can be expanded or collapsed to show or hide their related child accounts.

2. Description

   It displays the account description for reference purposes. This field is read-only and cannot be edited.

3. Transfer Exceptions

   It is used to assign regional exclusions.

   • Selecting a cell allows you to choose MSP_Regions (to exclude from all regions) or one or more specific regions.
   • If MSP_Regions is selected, all other region selections are ignored, and the temporary difference will not be transferred to any region.

Exporting National Transfer Exceptions

The Export option in the National Transfer Exceptions dialog allows you to export National Transfer accounts and their associated settings from the database to a .csv file.

To export National Transfer Exceptions:

1. Click on National Transfer Exceptions. A prompt appears.
2. Under Option, select Export.
3. In the File field, specify the .csv file to which you want to export the data.

   Note: If the selected file does not exist, it will be created during the export process.

4. Select symbols to export.
5. Click OK. A confirmation dialog will appear.
6. Click View File to open and review the exported file.