My GL data upload import failed.

Error Message:  No Data for Mandatory Field

Root Cause

Import file contains new accounts that the system doesn't recognize

Solution:

1)  Open the error message to determine which rows in the import file contain new accounts.

2)  Enter the FS Caption, Account type, and Is P&L values for these new accounts

3)  Re-import the file.

Error Message:  Invalid Value

Root Cause

Import file is configured incorrectly (This could be because one or more of the columns may contain incorrect information)

1. Check that B-CCY Balance and R-CCY Balance columns are in "Number" format

2. Check that Period End Date Values are in correct date format

2. Check that tab name is labeled "DATA"

3. Check that non-template extra columns are removed

4. Delete all blank rows and columns (to eliminate hidden formatting)

5. Reload in ART

Error Message: Input Reconciliation Period and DataImport Reconciliation Period do not match

Root Cause

Upload attempt is being done in the wrong period.

Solution

Check the period on the ART screen against the Period End Date column in the upload file to ensure that the period end date in ART matches that in the upload file.

Error Message: Mandatory Field Not Present

Root Cause

Mandatory field(s) needed for import aren't included in the template

Solution:

Download a new template from ART.  Compare the new template to the one being used for import as there may have been changes.  If necessary, copy and paste data into new import template.  Re-import.

Error Message: Invalid value for Is P&L or invalid combination of FS Caption, Account Type and Is P&L

Root Cause

GL Upload file contains different information for FS Caption and/or Asset Type and/or Is P&L designations than what is already assigned in ART.

Solution

When loading GL balances for existing accounts, remove content in FS Caption, Asset Type and Is P&L columns for those accounts as they are already configured in ART.

Error Message:  Data Length Exceeded

Root Cause

GL Upload file contains an excessive number of characters in a given field

Solution

When loading GL account numbers, the maximum number of characters is 20

Error Message:  Account data mismatch with existing values

Root Cause

An existing value known to ART (such as the FS Caption) has a different value in the import template.

Solution

Remove values in the FS Caption, Account Type and Is P&L fields when importing account balances.  ART will let you know if there are new accounts that need to have these fields filled in.