- 22 Jul 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Trial Balance Report (GLR099)
- Updated on 22 Jul 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Report Description
A report of summarized balances (debits and credits) pulled from Actuals Ledger by ChartField String based on a particular fiscal year, the selected accounting period range and other parameters selected.
Report Navigation: Main Menu > Florida PALM > Reports > GL > Trial Balance Report
Click below to view the sample report layout.
Business Roles
The following business roles have access to this report:
- GL Reconciliation Processor
- Additional roles to be added
Business Process Models
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
---|---|
Business Unit | Defaulted to Specific. User can select specific BU’s. Business Unit should be defaulted from user’s user preference. Required |
Fiscal Year | Defaulted to Blank. User can select specific Fiscal Year. Optional |
Period | Defaulted to Blank. User can select specific Period. Optional |
Adjustment Period | Defaulted to Blank. User can select specific Adjustment Period, 998 will be the only period available at Financials Wave. Optional |
Organization | Defaulted to Blank. User can select specific or range of Organization values. Optional |
Account | “Include CF” and “Descr” checked by default. User can select specific or range of Account values. Required |
Fund | “Include CF” and “Descr” checked by default. User can select specific or range of Fund values. Required |
Budget Entity | Defaulted to Blank. User can select specific or range of Budget Entity values. Optional |
Category | Defaulted to Blank. User can select specific or range of Category values. Optional |
State Program | Defaulted to Blank. User can select specific or range of State Program values. Optional |
Grant | Defaulted to Blank. User can select specific or range of Grant values. Optional |
Contract | Defaulted to Blank. User can select specific or range of Contract values. Optional |
Other Accumulator 1 | Defaulted to Blank. User can select specific or range of Other Accumulator 1 values. Optional |
Other Accumulator 2 | Defaulted to Blank. User can select specific or range of Other Accumulator 2 values. Optional |
Project | Defaulted to Blank. User can select specific or range of Project values. Optional |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD Mapping |
---|---|
Report Header Detail | Displays on 1st page only |
Business Unit and Description | Run Control Page Value |
Fiscal Year | Run Control Page Value |
Period | Run Control Page Value |
Adjustment Period | Run Control Page Value |
Business Unit and Description | Report Dataset |
Lines Details | |
Fund | PS_LEDGER.FUND_CODE |
Fund Description | PS_GL_FUND_CODE_TBL.DESCR |
Account | PS_LEDGER.ACCOUNT |
Account Description | PS_GL_ACCOUNT_TBL.DESCR |
ChartField selected by user on run control page | |
YTD Beginning Balance | |
Current Month Activity | |
Adjustments | |
Ending Balance |
Version History
Date | Revision Description |
---|---|
03/12/2024 | Original Version |
07/22/2024 | Updated layout |