-
Print
-
DarkLight
-
PDF
GR Cash Balance and Activity Report (GLR079)
-
Print
-
DarkLight
-
PDF
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 - |
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 |