Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
Def - Statistical Account
Def - Statistical Account
nopaneltrue
 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.0305.12 21 and newer

Table of Contents
typeflat

...

Toolbar IconsDescription
Delete
Insert excerpt
Delete - LV 3.0
Delete - LV 3.0
nopaneltrue
Column Filter Show/Hide

Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue

Excel
Insert excerpt
Excel - LV 3.0
Excel - LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Group By Show/Hide
Insert excerpt
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global 3.0
Help - Global 3.0
nopaneltrue
New
Insert excerpt
New - In line add
New - In line add
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
Save
Insert excerpt
Save - LV (Multi Line) 3.0
Save - LV (Multi Line) 3.0
nopaneltrue
Saved Column Layouts
Insert excerpt
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescription
Checkbox
Insert excerpt
Checkbox
Checkbox
nopaneltrue
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

...