GR Cash Balance and Activity Report (GLR079)
  • Dark
    Light
  • PDF

GR Cash Balance and Activity Report (GLR079)

  • Dark
    Light
  • PDF

Article summary

Report Description

GR Cash Balance and Activity Report is generated to display a cash position by GR Fund from the ACTUALS Ledger and associated modules that displays the following: Cash Balance, Pending AP Transactions , AR Unverified deposits, IU, and GL transactions that are not successfully Budget/Cash Checked and Anticipated Cash balance.

Report should consider payments scheduled for date report is run plus all prior dates. The report contains the following components:

  • Report Header
  • Report Sub Header
  • Report Detail

Report Navigation: Main Menu > Florida PALM > Reports > GL > GR Cash Balance & Activity Rpt

Click below to view the sample report layout.

Business Roles

The following business roles have access to this report:

  • DFS GL Cash Processor

Business Process Models

This report can be found in the following business processes:

Selection Criteria

The report data can be filtered by the following selection criteria:

Data Field

Data Field Details

N/A


Report Layout

The layout of the report is listed below. 

Data Field

Florida PALM RECORD.FIELD Mapping

Fund

LEDGER.FUND_CODE

Cash Balance

LEDGER.POSTED_TOTAL_AMT

Pending AP Transactions

PYMNT_VCHR_XREF.(PYMNT_GROSS_AMT-PAID_AMT)

AR Unverified Deposits

For Regular Customer Payments –

ITEM_DST.MONETARY_AMOUNT

For Direct Journal Payments -
PAY_MISC_DST.MONETARY_AMOUNT

Pending IU Transactions

FLP_IU_TRANS_DTL.MONETARY_AMOUNT

Pending GL Journals

JRNL_LN.MONETARY_AMOUNT

Anticipated Cash Balance

N/A

Version History

Date

Revision Description

07/02/2024

Original Version



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.