Create G/L Account Formats

Use the G/L Account Format Maintenance screen to create a new G/L Account Format.

Aeros ERP allow a G/L account to have up to 5 segments.

Example 1: Company - Division - Department - Account - Sub-Account

Example 2: Company - Division - Department - Account

Notes:

It is recommended that there is never more than one G/L Account Format configured in the system.

This is generally a one-time setup configuration and never modified. Please consult your Implementation Specialist or the Customer Support Department before making any modifications. 

Pre-Requisites

1. None

Navigation

From Master > G/L > G/L Account Format.

1. Click Insert.

2. Enter a Format Name.

3. Segment 1’s specifications are preset to the length of 2, Mix, and Company.

4. Segment 2’s specifications are preset to the length of 3, Mix, and Division.

   1. If the Division length needs to be anything else other than 3, see NOTE at the end of this page.

5. Segment 3 -

   1. Length of Segment 3 - Specify a length for 3rd Segment.

   2. Type of Segment 3 - Select an option: 
      Mix is for alphanumeric (A-Z, 0-9); Numeric only allows 0-9.

   3. Description of Segment 3 - Specify a description for this segment.

6. Complete step #5 for Segment 4 and Segment 5 if desired.
   Note: If you do not wish to use Segment 4 or 5, set the Length of Segment X field to 0.

7. Click Save. 

Open

NOTE:

If the Division # length is only 2 characters, after creating the format, you will need to run the following SQL Statement:

UPDATE GLStructure SET glsseg2length = 2