The purpose of this The purpose of this inquiry is to display a list view of all New, Approved, Ready to Post, and Posted journal entry lines. From this page, users may view the corresponding journal entry record view or the source transaction record view . This inquiry can be accessed from either the Inquiries page, or the GL Account Balances List View, or from the GL Account Balances By Period Inquiry. Beginning Balance Row. Also, info about grouped by GL Account.
Software Version: 2020.xx.xx and newer
...
| Filter Items | Description |
|---|
| Account Class | | Insert excerpt |
|---|
| Inq - GL Account Class |
|---|
| Inq - GL Account Class |
|---|
| nopanel | true |
|---|
|
This is a multi-select standard lookup that is not required to return results. It defaults as blank.
| Insert excerpt |
|---|
| Def - GL Account Class |
|---|
| Def - GL Account Class |
|---|
| nopanel | true |
|---|
|
The lookup contains a list of all GL Account Classes. |
| Category | | Insert excerpt |
|---|
| Inq - GL Category |
|---|
| Inq - GL Category |
|---|
| nopanel | true |
|---|
|
This is a multi-select standard lookup that is not required to return results. It defaults as blank.
| Insert excerpt |
|---|
| Def - General Ledger Account Category |
|---|
| Def - General Ledger Account Category |
|---|
| nopanel | true |
|---|
|
This lookup contains the values in the GLAccountClassCategory Enumeration Class. |
| Control Account Type | | Insert excerpt |
|---|
| Inq - GL Control Account Type |
|---|
| Inq - GL Control Account Type |
|---|
| nopanel | true |
|---|
|
This is a multi-select standard lookup that is not required to return results. It defaults as blank.
| Insert excerpt |
|---|
| Def - Control Account |
|---|
| Def - Control Account |
|---|
| nopanel | true |
|---|
|
This lookup contains the values in the GLControlAcctType Enumeration Class. |
| Fiscal Period | | Insert excerpt |
|---|
| Inq - Fiscal Period |
|---|
| Inq - Fiscal Period |
|---|
| nopanel | true |
|---|
|
This is a multi-select standard lookup that is not required to return results. If the inquiry is opened from the Inquiries page or the GL Account Balances List View, it defaults as blank. If the inquiry is opened from the GL Account Balances by Period Inquiry, it defaults with the selected Fiscal Period.
| Insert excerpt |
|---|
| Def - Fiscal Period |
|---|
| Def - Fiscal Period |
|---|
| nopanel | true |
|---|
|
The lookup contains a list of all Fiscal Periods. |
| Fiscal Year | | Insert excerpt |
|---|
| Inq - Fiscal Year |
|---|
| Inq - Fiscal Year |
|---|
| nopanel | true |
|---|
|
This is a multi-select standard lookup that is not required to return results. If the inquiry is opened from the Inquiries page, it defaults as the current year. If the inquiry is opened from the GL Account Balances List View, it defaults as blank. If the inquiry is opened from the GL Account Balances by Period Inquiry, it defaults from the selected Fiscal Year.
| Insert excerpt |
|---|
| Def - Fiscal Year |
|---|
| Def - Fiscal Year |
|---|
| nopanel | true |
|---|
|
The lookup contains a list of all Fiscal Years. |
| GL Account | | Insert excerpt |
|---|
| Inq - GL Account |
|---|
| Inq - GL Account |
|---|
| nopanel | true |
|---|
|
This is a multi-select standard lookup that is not required to return results. If the inquiry is opened from the Inquiries page, it defaults as blank. If the inquiry is opened from the GL Account Balances List View or the GL Account Balances by Period Inquiry, it defaults with the selected GL Account.
| Insert excerpt |
|---|
| Def - GL Account Description |
|---|
| Def - GL Account Description |
|---|
| nopanel | true |
|---|
|
The lookup contains a list of all GL Accounts. |
| GL Date | | Insert excerpt |
|---|
| Inq - GL Date Range |
|---|
| Inq - GL Date Range |
|---|
| nopanel | true |
|---|
|
This is a date range editor that is not required to return results. It defaults as blank.
| Insert excerpt |
|---|
| GL Date |
|---|
| GL Date |
|---|
| nopanel | true |
|---|
|
|
| Search | | Insert excerpt |
|---|
| Search - Search Options |
|---|
| Search - Search Options |
|---|
| nopanel | true |
|---|
|
- Account (search a single account "1000" or a range of accounts "1000:2000” to return all GL Accounts between "1000" and "2000")
- Account Description
|
| Saved Search Options | | Insert excerpt |
|---|
| Search Options for Framework 3.0 - Global |
|---|
| Search Options for Framework 3.0 - Global |
|---|
| nopanel | true |
|---|
|
|
Page Detail
| Toolbar Icons | Description |
|---|
| Column Filter Show/Hide | | Insert excerpt |
|---|
| Column Filter Show/Hide - Global |
|---|
| Column Filter Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Excel | | Insert excerpt |
|---|
| Excel - LV 3.0 |
|---|
| Excel - LV 3.0 |
|---|
| nopanel | true |
|---|
|
|
| Favorites | | Insert excerpt |
|---|
| Favorites Add/Remove - Global |
|---|
| Favorites Add/Remove - Global |
|---|
| nopanel | true |
|---|
|
|
| Group By Show/Hide | | Insert excerpt |
|---|
| Group By Show/Hide - Global |
|---|
| Group By Show/Hide - Global |
|---|
| nopanel | true |
|---|
|
|
| Help | | Insert excerpt |
|---|
| Help - Global 3.0 |
|---|
| Help - Global 3.0 |
|---|
| nopanel | true |
|---|
|
|
| More Actions | | Insert excerpt |
|---|
| More Actions - Global 3.0 |
|---|
| More Actions - Global 3.0 |
|---|
| nopanel | true |
|---|
|
- Reverse/Correct: Opens the Reverse/Correct page and allows the user to either Reverse or Reverse & Correct a journal entry.
|
| Quick Filter | | Insert excerpt |
|---|
| Quick Filter |
|---|
| Quick Filter |
|---|
| nopanel | true |
|---|
|
|
| Refresh | | Insert excerpt |
|---|
| Refresh - Global 3.0 |
|---|
| Refresh - Global 3.0 |
|---|
| nopanel | true |
|---|
|
|
| View | | Insert excerpt |
|---|
| View - Inquiry Grid 3.0 |
|---|
| View - Inquiry Grid 3.0 |
|---|
| nopanel | true |
|---|
|
- Journal: Opens the Journal Entry Record View for the selected journal line in a new tab
- Source Transaction: Opens the source transaction (i.e. Payment, Fish Ticket, Transfer, etc.) for the selected journal line in a new tab
|
| Saved Column Layouts | | Insert excerpt |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| Column Layouts for Framework 3.0 - Global |
|---|
| nopanel | true |
|---|
|
|
| Fields | Description |
| Account Description | |
ID IDhis field is not editable once it has been Saved TThis can be edited from the 'Account Description' field on the GL Accounts List View.
|
ID| Description | | Def - GL Account |
|---|
|
|
ID
Database Field: ERPx_GLAccount. |
AccountNumber Description Description DescriptionThis can be edited from the 'Account Description' field on the GL Accounts List View This field is not editable once it has been Saved.
|
Description Description
Database Field: ERPx_GLAccount. |
DescriptionBeginning | 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.
The Balance column represents the GL Account balance after the Journal Line and is calculated as [Prev Balance + Net Change]. |
| Comment |
|
| Created |
|
| Created By |
|
| Credit | Identifies the total amount from all posted transactions that negatively affect the GL balance 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 amount from all posted transactions that positively affect the GL balance 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. |
| Distributed To |
|
| Distributed Type |
|
| Fiscal Period | Identifies the Period on a Fiscal Calendar. This can be edited from the 'Period Name' field on the Fiscal Periods master file.
| Insert excerpt |
|---|
| Def - Fiscal Period |
|---|
| Def - Fiscal Period |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_MFFiscalPeriod.PeriodName
|
| Fiscal Year | Identifies the Year on a Fiscal Calendar. This is a system assigned value and cannot be edited. | Insert excerpt |
|---|
| Def - Fiscal Year |
|---|
| Def - Fiscal |
|---|
|
|
Year| nopanel | true |
|---|
Database Field: ERPx_MFFiscalYear.FiscalYear 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.
Database Field: ERPx_MFFiscalYear.FiscalYear |
| Functional Area |
|
| Host JE |
|
| Journal Date |
|
| Journal ID |
|
| Journal Type |
|
| Last Updated |
|
| Last User |
|
| Line Comment |
|
| Master Number |
|
| 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 | | Note |
|
| Posted |
|
| Posted By |
|
| Reference |
|
| 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.
| Insert excerpt |
|---|
| Def - General Ledger Account Segment |
|---|
| Def - General Ledger Account Segment |
|---|
| nopanel | true |
|---|
|
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.
| Insert excerpt |
|---|
| Def - General Ledger Account Segment |
|---|
| Def - General Ledger Account Segment |
|---|
| nopanel | true |
|---|
|
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.
| Insert excerpt |
|---|
| Def - General Ledger Account Segment |
|---|
| Def - General Ledger Account Segment |
|---|
| nopanel | true |
|---|
|
Database Field: ERPx_GLAccountSegmentNumber.Number, ERPx_GLAccountFormat.SegmentSK |
| Source Trans Date |
|
| Source Trans Detail |
|
| Source Trans Type |
|
| Status |
|
Related Topics
User Guide: Fiscal Periods
...