Import

The Import list is the central location for all your import tasks. From this page, you can manage existing imports and create new imports.

Depending on user permissions, you can access Import under General ledger, Receivables, Payables, Treasury, and Fixed Assets.

Import reminders:

  • Import supports both .CSV files and .TXT files.

  • Header records are required for all imports in web view.

Tip: To run or delete an import, select the ellipses menu next to the import in the list.

To run or delete an import, select the ellipses menu next to the import in the list.

  1. From the import list page, select Add.

  2. On the Basics tab, select the type of import. An import type determines the field categories available for an import.

    For example, to include credit memos in an Accounts Payable import, select Credit memo from the list on the Import records page; to include account codes in a General Ledger import, select Account code from the list.

  3. Enter a description for the import.

  4. Determine if others can run or modify this import by marking the checkboxes.

  5. On the Parameters tab, select Import or Update. Use update when you simply want to update existing record records in your database.

  6. Mark Validate data only to validate the import file before actually adding records. After you validate the import file and you are ready to run the import, unmark Validate data only.

  7. Mark Create new table entries to import table entries not currently present in the program. We recommend that you do not add table entries when importing. It may result in duplicate entries, some with misspellings and incorrect formatting, such as Dr., Dr, DR.

  8. When updating records, you can select to Import records not found as new records. This option is not available when Import is selected.

  9. When importing records, you can select Use duplicate criteria for new records. This option is not available when Update is selected.

  10. In the Import table entries with field, select Long description or Short description as the default format to use when importing fields containing table entries. The selected format is used by default only when you do not specify a format in the import file.

  11. Attach the import file.

  12. In the Match records in the import file with existing records by field, select the record ID contained in the import file. This field is used for linking imported records with records already saved in the database.

  13. Select the Fields tab. Mapping fields is the process of matching fields contained in an import file to their Financial Edge NXT equivalents. It is very important to map fields correctly to prevent creating exceptions and to ensure information imports into the correct fields on records.

    Tip: You do not have to map all fields in your import file. If a field is not required, you can run an import without mapping the field.

  14. Select Save.