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.
