Understanding General Purpose Accounts

The AAIs for GLGx define account ranges for the different categories in your chart of accounts. For example, the account range for assets (GLG2) might begin with object account 1000, the account range for liabilities (GLG3) might begin with object account 2000, and so on. AAI items GLGx are used primarily for financial reporting.

This table shows the setup considerations for AAI item GLG1:

AAI Item

Description

Company

Business Unit

Object

Subsidiary

Sequence Number

GLG1

General Purpose Accounts

00000

Not used

Required

Optional

1.010

You set up AAI items GLGx for company 00000 only. (The system assumes that your account structure is consistent across all companies.) The exception is AAI item GLG4, which you must set up for each company because it defines the retained earnings account.

This table shows the setup considerations for AAI items GLGx:

AAI

Setup Considerations

GLG2

The beginning account range for assets. Enter the object account only.

GLG3

The beginning account range for liabilities and equities. Enter the object account only.

You can use this AAI item to reverse the sign on financial reports.

GLG4

The account number for retained earnings. Enter the business unit and object account. If the business unit is the same as the company number for all companies, enter only the object account for company 00000. Otherwise, set up GLG4 for each company and specify the business unit and object account.

The GLG4 account number must be greater than the account number for GLG1 and less than the account number for GLG4.

GLG5

The ending account number for year-to-date income and loss. Enter the object account only.

This account number should indicate the last balance sheet account, which must be a nonposting account. The system uses this AAI item in the balance sheet to ensure that assets are equal to liabilities plus equity (a calculated figure).

GLG6

The beginning account range for revenue. Enter the object account only.

The system uses this AAI item for automatic sign reversal on reports and to calculate the percentage of revenue on some reports and the retained earnings for the general ledger annual close.

GLG7

The ending account range for revenue. Enter the object account and, if applicable, the subsidiary.

The system uses this AAI item for automatic sign reversal and to calculate the percentage of revenue on some reports.

GLG8

The beginning account range for cost of goods. Enter the object account only. You can use this AAI item to reverse the sign of expense accounts on some financial reports.

GLG9

The ending account range for cost of goods. Enter the object account and, if applicable, the subsidiary.

GLG11

The beginning account range for other income. Enter the object account only.

You can use this item to reverse the sign of income accounts on some financial reports.

Note: Do not leave the beginning range for GLG11 (other income) blank. If you do not want to enter an account, enter the same account number as the beginning range for GLG13 (other expenses).

If you do not want to enter an account number for the beginning range, enter the same account number as the beginning range for GLG12 (ending profit and loss accounts).

GLG12

The account for ending profit and loss (income statement), which is used to calculate retained earnings for the general ledger annual close. This is the last account that appears on an income statement. Any accounts that are greater than this account number do not appear on an income statement nor are the accounts closed to the retained earnings account.

Enter the object account and, if applicable, the subsidiary. If you do not enter an object account, the system uses account 999999.

Revenues (GLG6) + Expenses (GLG12) = Retained Earnings (GLG4)

GLG13

The beginning account range for other expenses. Enter the object account only.

You can use this AAI item to reverse the sign of other expense accounts on some financial reports.

Note: If you do not want to enter an account number for the beginning range, enter the same account number as the beginning range for GLG12 (ending profit and loss accounts).