Chart of Accounts Import

Modified on Fri, 26 Oct 2018 12:46 by Freddy Donovan — Categorized as: General Ledger, Import- Export Manager

Table of Contents [Hide/Show]

General Information¶

Default Menu Location Transaction >> Importers/Exporters >> Accounting >> Chart of Accounts Import

Screen Name IMPORTGL

Function Imports the Chart of Accounts for the General Ledger.

Chart of Accounts Import Screen

Contact your Implementation Consultant for a copy of the most current Chart of Accounts Import template file in XLS format.

File Name/Browse: Use the Browse button to locate and select the completed Chart of Accounts import template file (in XLS format)

Map Fields: Fields must be mapped prior to importing. If no changes have been made to the column headings, the mapping screen should show all green, and you can click OK to continue. If any of the Input Field Name columns on the left are red, single-click on the line on the left column, and then double-click the desired mapped field in the right column to complete the mapping. Repeat for any red lines on the left that should be mapped. If there are additional columns in the source file that should NOT be mapped, they can be left unmapped (displayed in red). Mandatory fields will require that they be mapped before clicking OK.

Fields/Filters¶

Required fields are indicated with *

*Active - Enter Y to mark the GL account active. Enter N to import an inactive account. If this field is left blank, the GL account will not import.

*GLAcct - GL account number. GL Account must match the GL Mask formatting established in CID Maintenance, or it will cause a validation error during import.

GLDesc - GL description. Maximum 110 characters.

GLSDesc - GL short description. Maximum 25 characters. The short description is available for use on custom reports.

GLType - GL account type code, as defined in the GL Types and Ranges screen.

PostJE - Enter Y to set the GL account Allow Manual Posting field. Enter N to disallow use of this account in Manual Journal Entry.