Budget and Cash Checking Exceptions/Warnings Report (KKR058)
- 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Budget and Cash Checking Exceptions/Warnings Report (KKR058)
- Updated on 29 May 2024
- 2 Minutes to read
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
The Budget Execution and Management business process addresses how the Budget Check process within Florida PALM validates the source transaction to available appropriations/cash and ChartField values. The budget/cash configuration of Florida PALM will determine how transactions pass/fail Budget/Cash Check.
All transactions that fail Budget/Cash Check will produce exceptions/warnings and are included in this Budget and Cash Checking Exceptions/Warnings Report. DFS and Agency roles assigned to retrieve the Budget and Cash Checking Exceptions/Warnings Report will use this report to address all exceptions/warnings noted. These roles will work within source modules and engage DFS and Agency staff as appropriate to review and resolve the exceptions/warnings.
The report will show details of exceptions/warnings logged by the budget/cash checking processes along with the ChartField values. The exceptions/warnings details for different source transactions will be displayed in the report, along with aging details. Override information will also be reflected in the Budget and Cash Checking Exceptions/Warnings Report.
Report Navigation: Main Menu > Florida PALM > Reports > KK > Budget/Cash Checking Report
Click below to view the sample report layout.
Business Roles
The following business roles have access to this report:
- DFS KK Budget Maintainer
- DFS KK Budget Processor
- Agency KK Budget Processor
- Additional roles to be added
Business Process Models
This report can be found in the following business processes:
- 10.3.1 Perform Month-End Close
- 20.1.1 Enterprise Post Appropriations
- 20.1.2 Manage Agency Allotments
- 20.1.3 Enterprise Budget Ledger Reconciliation
- 20.1.4 Agency Estimated Revenue
- 30.2.1 Create and Maintain Encumbrances
- 30.2.2 Monitor Encumbrances
- 30.2.3 Establish Enterprise Encumbrances
- 30.3.1 Process Vouchers
- 30.3.3 Review and Approve Vouchers
- 30.4.1 Process Pay Cycle
- 30.5.1 Record Manual Payments
- 60.1.4 AR Period Close
- 60.2.1 Direct Journal Deposits
- 60.2.3 Returned Items
- Additional BPMs to be added
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
|---|---|
Scroll Area | N/A |
Scroll Area | N/A |
Business Unit | Required |
Source Module | Optional |
Budget Period | Optional |
Process Instance | Optional |
Ledger Group | Optional |
Exception/Warning | Optional |
Transaction Date From/To | Optional |
Include Budget Override | Optional |
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD Mapping |
|---|---|
Business Unit | PS_KK_EXCPTN_TBL.BUSINESS_UNIT |
Organization | PS_KK_EXCPTN_TBL. DEPTID |
Account | PS_KK_EXCPTN_TBL.ACCOUNT |
Fund | PS_KK_EXCPTN_TBL.FUND_CODE |
Budget Entity | PS_KK_EXCPTN_TBL.BUDGET_REF |
Category | PS_KK_EXCPTN_TBL.PRODUCT |
State Program | PS_KK_EXCPTN_TBL.CHARTFIELD2 |
Grant | PS_KK_EXCPTN_TBL.PROGRAM_CODE |
Contract | PS_KK_EXCPTN_TBL.CHARTFIELD1 |
OA1 | PS_KK_EXCPTN_TBL.CLASS_FLD |
OA2 | PS_KK_EXCPTN_TBL.CHARTFIELD3 |
PC Business Unit | PS_KK_EXCPTN_TBL.BUSINESS_UNIT_PC |
Project | PS_KK_EXCPTN_TBL.PROJECT_ID |
Activity | PS_KK_EXCPTN_TBL.ACTIVITY_ID |
PC Source Type | PS_KK_EXCPTN_TBL.RESOURCE_TYPE |
PC Category | PS_KK_EXCPTN_TBL.RESOURCE_CATEGORY |
PC Subcategory | PS_KK_EXCPTN_TBL.RESOURCE_SUB_CAT |
Budget Period | PS_KK_EXCPTN_TBL.BUDGET_PERIOD |
Ledger Group | PS_KK_EXCPTN_TBL.LEDGER_GROUP |
Transaction ID | Fetch details by joining PS_KK_SOURCE_HDR and PS_KK_EXCPTN_TBL records |
Transaction Date | PS_KK_EXCPTN_TBL.KK_TRAN_DT |
Transaction Line | PS_KK_EXCPTN_TBL.KK_TRAN_LN |
Source Transaction | PS_KK_EXCPTN_TBL.KK_SOURCE_TRAN |
E/W | PS_KK_EXCPTN_TBL.EXCPTN_TYPE |
Exception Message | Fetch details by joining PSXLATITEM and PS_KK_EXCPTN_TBL records and get the Translate Long Name of the EXCPTN_TYPE field. |
Exception Aging | TBD |
Override | Fetch details by joining PS_KK_EXCPTN_TBL AND PS_OVERRIDE_TBL (Left Outer Join if needed) and fetch this field KK_BD_OVER_FLAG |
Override NAME | Fetch details by joining PS_KK_EXCPTN_TBL AND PS_OVERRIDE_TBL (Left Outer Join if needed) and fetch this field KK_BD_OVER_OPRID |
Override DATE | Fetch details by joining PS_KK_EXCPTN_TBL AND PS_OVERRIDE_TBL (Left Outer Join if needed) and fetch this field KK_BD_OVER_DTTM |
Version History
Date | Revision Description |
|---|---|
02/01/2024 | Original Version |
Was this article helpful?
