Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
...
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.0508.3111 and newer
Table of Contents | ||
---|---|---|
|
...
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. 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 |
...