Trial Balance Report (GLR099)

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 Header Detail

Displays on 1^st page only

Business Unit

Run Control Page Value

Fiscal Year

Run Control Page Value

Period

Run Control Page Value

Adjustment Period

Run Control Page Value

Report Details - Report Header

Display per page

Business Unit and Description

Report Dataset

Fund and Description

Report Dataset

Lines Details

Account

PS_LEDGER.ACCOUNT

Account Description

ChartField

Selected by user on run control page

ChartField Description 

Selected by user on run control page

YTD Beginning Balance

POSTED_TOTAL_AMT field amount from ‘PS_LEDGER’ record where BUSINESS_UNIT, LEDGER and FISCAL_YEAR equals to value provided on run control page and ACCOUNTING_PERIOD from 0 through prior month provided on run control page.

Example: 

If the report is run for September (Period 3), Beg Bal = Period 0 + Jul + Aug.

Note: If Period 0 is selected on the run control page, only data for period 0 of the specified Fiscal Year should be shown in the YTD Beginning Balance column.

Note: If Fiscal Year and Period is blank on run control page then report should print data for current fiscal year and accounting period derived from system date.

Current Month Activity

Sum of amounts from POSTED_TOTAL_AMT from ‘PS_LEDGER’ record where BUSINESS_UNIT, LEDGER and FISCAL_YEAR equals to value provided on run control page and ACCOUNTING_PERIOD value should be equal to value provided on run control page.

Example: 

If the report is run for September (Period 3), Current Month Activity = Period 3 activity.

Note: If Fiscal Year and Period is blank on run control page then report should print data for current fiscal year and accounting period derived from system date.

Adjustments

Sum of amounts from POSTED_TOTAL_AMT from ‘PS_LEDGER’ record where BUSINESS_UNIT, LEDGER, FISCAL_YEAR, ACCOUNTING_PERIOD, and ADJUSTMENT PERIOD should be equal to values provided on run control page.

Ending Balance

Calculate ending balance as follows: YTD Beginning Balance + Current Month Activity + Adjustments.

03/12/2024

Original Version