The purpose of the Statistical Accounts List View is to add and maintain all the Statistical Accounts. From here, users can add new Statistical Accounts and edit properties of existing accounts. Statistical Accounts with history cannot be deleted, they can only be inactivated. Statistical Accounts are used on the Financial Reports.

Software Version: 2021.05.21 and newer

Page Header

Toolbar IconsDescription
Delete
Column Filter Show/Hide

Excel
Favorites
Group By Show/Hide
Help
New
Quick Column Filter
Save
Saved Layouts
FieldsDescription
Checkbox
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. Special characters are not allowed, if one is entered the message "Account [Account] contains invalid characters" will be displayed on Save.  This field is not editable after the initial Save. 

Database Field: ERPx_GLAccount.AccountNumber

Account Description

The name associated with the Statistical 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 field is always editable. 

Database Field: ERPx_GLAccount.Description

Clear Balances on Year End Close

A single-select Yes/No lookup to identify whether the balances in the Statistical Account carry over on a year end close. This defaults to 'No' and is required. This field is always editable.

  • A value of 'No' means that when the 'Year End Close' is run, the ending balance from the closed year becomes the beginning balance for the new year. 
  • A value of 'Yes' means that when the 'Year End Close' is run, the new year starts with a beginning balance of 0.00
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 Manual Journal Entry transactions or the Journal Line Inquiry. If set to 'No' then the record can be freely used in these places. This value is always editable. 

Database Field: ERPx_GLAccount.IsInactive 

Typical Balance

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

This lookup contains options of: Positive and Negative.

Database Field: ERPx_GLAccount.GLTypicalBalanceEN

Related Topics



Page Definitions



Technical Details