Trial Balance Report (GLR099)
  • 22 Jul 2024
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Trial Balance Report (GLR099)

  • Dark
    Light
  • PDF

Article summary

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:

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/2024Updated layout

 


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.