The purpose of the GL Account Balance by Period inquiry is to show account balances for each fiscal period. From this page, users may drill down and The purpose of the GL Account Balance by Period inquiry is to show account balances for each fiscal period. From this page, users may drill down and view the Journal Line History Inquiry for a single period. This inquiry can be accessed from either the Inquiries page or from the GL Account Balances List View.
Software Version: 20212023.0504.21 28 and newer
| Table of Contents | ||
|---|---|---|
|
...
| Filter Items | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Account Class |
The lookup contains a list of all GL Account Classes. | ||||||||||||||||
| Auto Hide Filters |
| ||||||||||||||||
| Auto Refresh on Open |
| ||||||||||||||||
| Category |
This lookup contains the values in the GLAccountClassCategory Enumeration Class.
| ||||||||||||||||
| Control Account Type |
This lookup contains the values in the GLControlAcctType Enumeration Class. | ||||||||||||||||
| Fiscal Period |
The lookup contains a list of all Fiscal Periods. | ||||||||||||||||
| Fiscal Year |
The lookup contains a list of all Fiscal Years. | ||||||||||||||||
| GL Account |
The lookup contains a list of all GL Accounts. | ||||||||||||||||
| Posting Type | Used to select one or more Posting Types. This is a multi-select standard lookup that is not required to return results. It defaults as blank. If blank, this parameter is not used but if filled in then the data is limited based on the selection. This lookup contains the values in the GLAccountPostingType Enumeration Class.
| ||||||||||||||||
| Saved Searches |
| ||||||||||||||||
| Search |
|
Please note the use of keywords for searching has not been implemented on this page. For example, to search by a specific Account Description, users may not prepend the search value with the text "Account Description: ". Instead, simply enter "Checking" into the Search text box. Clicking Refresh will return all results where the value "Checking" is stored in any of the searchable fields....
| Toolbar Icons | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| ||||||||||||||||
| Excel |
| ||||||||||||||||
| Favorites |
| ||||||||||||||||
| Group By Show/Hide |
| ||||||||||||||||
| Help |
| ||||||||||||||||
| More Actions |
| ||||||||||||||||
| Quick Column Filter |
| ||||||||||||||||
| Refresh |
| ||||||||||||||||
| Saved Layouts |
| ||||||||||||||||
| Search Options |
| ||||||||||||||||
| Fields | Description | ||||||||||||||||
| Checkbox |
| ||||||||||||||||
| Account |
Database Field: ERPx_GLAccount.AccountNumber | ||||||||||||||||
| Account Description | GL Account Description | ||||||||||||||||
| nopanel | true | ||||||||||||||||
| Insert excerpt | Def - GL Account Description | Def - GL Account Description | |||||||||||||||
| nopanel | true | Beginning Balance | Identifies the beginning balance amount for a Fiscal Period. This field comes from the amounts on journal line entries created from posted transactions. This field should match the 'Period Balance' column on the previous Fiscal Period. This amount cannot be edited, unless the original posted transaction is voided, reversed or corrected. This is a calculated field and not stored in the database
Database Field: ERPx_GLAccount.AccountNumber | Account Description | |||||||||||||
| Insert excerpt | GL Account Description | .Description | |||||||||||||||
| Beginning Balance | Identifies the beginning balance amount for a Fiscal Period. This field comes from the amounts on journal line entries created from posted transactions. This field should match the 'Period Balance' column on the previous Fiscal Period. This amount cannot be edited, unless the original posted transaction is voided, reversed or corrected. This is a calculated field and not stored in the database. | ||||||||||||||||
| Budget - Period | Identifies the budget amount for each combination of Fiscal Year, Period, and GL Account. This is not editable from this page. | ||||||||||||||||
| Budget - YTD | Identifies the cumulative budget amount for each combination of Fiscal Year, Period, and GL Account. This field is calculated differently for each GL Account Posting Type:
| ||||||||||||||||
| Credit | Identifies the total Credit amount from all posted transactions for a Fiscal Period. This field comes from the 'Credit' column on a Journal Entry Record View with a Date that falls within the Fiscal Period. This amount cannot be edited, unless the original posted transaction is voided, reversed or corrected. This is a calculated field and not stored in the database. | ||||||||||||||||
| Debit | Identifies the total Debit amount from all posted transactions for a Fiscal Period. This field comes from the 'Debit' column on a Journal Entry Record View with a Date that falls within the Fiscal Period. This amount cannot be edited, unless the original posted transaction is voided, reversed or corrected. This is a calculated field and not stored in the database. | ||||||||||||||||
| Fiscal Period | Identifies the Period on a Fiscal Calendar. This value is looked up from the 'Period Name' field on the Fiscal Periods master file.
Database Field: ERPx_MFFiscalPeriod.PeriodName | ||||||||||||||||
| Fiscal Year | Identifies the Year on a Fiscal Calendar. This is a system assigned value and cannot be edited.
Database Field: ERPx_MFFiscalYear.FiscalYear | ||||||||||||||||
| Net Change | Identifies the difference between the Debit and Credit columns for a Fiscal Period. It comes from the 'Debit' and 'Credit' columns for the Fiscal Period and is calculated as [Debit] - [Credit]. This field is not stored in the database. | ||||||||||||||||
| Period Balance | Identifies the total balance of the Fiscal Period. It comes from the 'Beginning Balance' and 'Net Change' columns for the Fiscal Period and is calculated as [Beginning Balance] + [Net Change]. This field is not stored in the database. | ||||||||||||||||
| Segment 1 | Identifies the first part (segment) of the GL Account Format. It comes from the 'Number' column on the GL Account Format Record View. This field is never editable.
Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK | ||||||||||||||||
| Segment 2 | Identifies the second part (segment) of the GL Account Format. It comes from the 'Number' column on the GL Account Format Record View. This field is never editable.
Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK | ||||||||||||||||
| Segment 3 | Identifies the third part (segment) of the GL Account Format. It comes from the 'Number' column on the GL Account Format Record View. This field is never editable.
Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK |
Related Topics
...