GL Accounts List View

The purpose of the GL Accounts List View is to add and maintain all the General Ledger Accounts. From here, users can add new GL Accounts, edit properties of existing accounts, or remove unused accounts. GL Accounts are used to support transactions and other master files.

 This record view also contains columns for each Attribute that is set up for the 'GL Accounts' attribute type. Because these are user defined, they are not included in the default view but can be added a saved column layout. GL Accounts attributes are not included in the help documentation.

Software Version: 2023.08.11 and newer

Page Header

Toolbar Icons

Description

Toolbar Icons

Description

Column Filter Show/Hide

Delete

Click to see list of database tables and fields audited during the delete.

Excel

Favorites

Group By Show/Hide

Help

New

Quick Column Filter

Save

Saved Layouts

Fields

Description

Account

The unique identifier of the GL Account record. This defaults to blank but is required for all records, must be unique and must be <= 75 characters. If not assigned, the record is not saved. If assigned, the Account must contain the correct number of segments and each segment must be the correct length as specified in the GL Account Format page. This field is editable if integration is set to None, otherwise it is disabled after the initial Save. 

Linked Database Field: ERPx_GLAccount.AccountNumber

Account Alias

Used to specify and alias for a GL Account. This is often used to store a cross reference field to another system. This is not required and does not need to be unique, but if entered it must be <= 25 characters. This is always editable. 

Linked Database Field: ERPx_GLAccount.HostSystemLink

Account Class

A single-select lookup to assign the Class the GL Account belongs to. This is only used for reporting and does not control any other behavior in NorthScope. This defaults to blank and is required. If not assigned, the message "Account Class is required." will be displayed on Save. This is always editable. If either the 'Posting Type' or 'Category' are updated, this value will be cleared and must be re-selected.

Linked Database Fields: ERPx_GLAccountClass.ClassName, ERPx_GLAccount.AccountClassSK 

This lookup contains a list of all 'Active' Account Classes that match the selected 'Category'.

Account Description

The name associated with the GL Account. This is required for all records, does not need to be unique, and must be <= 75 characters. If not assigned, the message "Account Description is required." will be displayed on Save. This is always editable. 

Linked Database Field: ERPx_GLAccount.Description

Category

Identifies the Category associated with the GL Account. This is a single-select lookup that is required. This defaults as blank and is always editable. If the 'Posting Type' is updated, this value will be cleared and must be re-selected.
Linked Database Field: ERPx_GLAccountClass.GLAccountClassCategoryEN

This lookup contains the values in the GLAccountClassCategory Enumeration Class and is dependent on the 'Posting Type' that is selected.

Control Account Type

A single-select lookup to identify GL Accounts that balance to a subsidiary journal. The Control Account Type identifies which subsidiary the account balances to and some GL Account look-ups are limited to only accounts within a specified Control Account Type. This defaults to blank and is not required. This is always editable.

Linked Database Field: ERPx_GLAccount.GLControlAccountTypeEN

This lookup contains all the values in the GLControlAcctType Enumeration Class. 

Inactive

A Yes/No field used to identify if the GL Account is Inactive. If set to 'Yes' then the GL Account will not be included in look-ups for transactions or other master files. If set to 'No' then the record can be freely used. This value is always editable but users will not be able to inactivate a GL Account that has a current balance, the message "You cannot inactivate a GL Account with a balance." will be displayed on Save. 

Linked Database Field: ERPx_GLAccount.IsInactive 

Posting Type

A single-select lookup to identify whether the Account belongs on the Balance Sheet or Income Statement. This defaults to blank and is required. This field is always editable but if changed, the values in ‘Account Class’ and ‘Category’ will be cleared and must be re-selected.

Balance Sheet Accounts roll over and Income Statement Accounts are closed to Retained Earnings when a Year-End is run.

Linked Database Field: ERPx_GLAccount.GLAccountPostingTypeEN 

This lookup contains all the values in the GLAccountPostingType Enumeration Class. 

Typical Balance

A single-select standard lookup to select whether the Account typically carries a Debit or Credit balance. This defaults to Debit, is required, and is always editable.

Linked Database Field: ERPx_GLAccount.GLTypicalBalanceEN

This lookup contains all the values in the GLTypicalBalance Enumeration Class. 

Use In AP

A Yes/No lookup to identify whether or not the 'GL Account' will be included in the Purchase Account lookup for AP Invoices and Credit Memo transactions. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for AP transactions and a value of "No" means that it will not. 

 This is also evaluated for imported records that come through the Inbound Integration tables. 

Linked Database Field: ERPx_GLAccount.UseInAP

Use In GL

A Yes/No lookup to identify whether or not the 'GL Account' will be included in manual journal entry 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for journal entries and a value of "No" means that it will not. 

 This is also evaluated for imported records that come through the Inbound Integration tables. 

Linked Database Field:ERPx_GLAccount.UseInGL 

Use In IM

A Yes/No lookup to identify whether or not the 'GL Account' will be included in Inventory transaction 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for Inventory transaction line items and a value of "No" means that it will not.

Linked Database Field: ERPx_GLAccount.UseInIM 

Use In SO

A Yes/No lookup to identify whether or not the 'GL Account' will be included in Sales Transaction 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account' look-ups for Sales transaction line items and a value of "No" means that it will not.

Linked Database Field: ERPx_GLAccount.UseInSO

Use In SP

A Yes/No lookup to identify whether or not the 'GL Account' will be included in Sales Program 'GL Account' look-ups. This defaults to "Yes" but can be changed at anytime. A value of "Yes" means that the 'GL Account', if Active, will be included in 'GL Account" look-ups for Sales Program transactions look-ups and a value of "No" means that it will not.

Linked Database Field: ERPx_GLAccount.UseInSP

 

Related Topics





Page Definitions





Technical Details