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.
...
| Filter Items | Description | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Account Class |
The lookup contains a list of all GL Account Classes. | ||||||||||||||||||
| 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 |
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.
The lookup contains a list of all Fiscal Years. | ||||||||||||||||||
| GL Account |
The lookup contains a list of all GL Accounts. | ||||||||||||||||||
| GL Date | Used to select one or more Posting Types. This is a multi-select standard lookup The lookup contains a list of all GL Accounts. | Posting Type | This is a date range editor that is not required to return results. It defaults as blank.
| ||||||||||||||||
| Search |
| ||||||||||||||||||
| Saved Search Options |
|
...
| Toolbar Icons | Description | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Column Filter Show/Hide |
| ||||||||||||||||
| Excel |
| ||||||||||||||||
| Favorites |
| ||||||||||||||||
| Group By Show/Hide |
| ||||||||||||||||
| Help |
| ||||||||||||||||
| More Actions |
| ||||||||||||||||
| Quick Filter |
| ||||||||||||||||
| Refresh |
| ||||||||||||||||
| View |
| ||||||||||||||||
| Saved Column Layouts |
| ||||||||||||||||
| Fields | Description | ||||||||||||||||
| Account |
Database Field: ERPx_GLAccount.AccountNumber | ||||||||||||||||
| Account Description |
Database Field: ERPx_GLAccount.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. | ||||||||||||||||
| 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. | ||||||||||||||||
| Fiscal Period | Identifies the Period on a Fiscal Calendar. This can be edited 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
...