Appropriations Budget Ledger Balances Reconciliation Report (KKR022)
-
Print
-
DarkLight
-
PDF
Appropriations Budget Ledger Balances Reconciliation Report (KKR022)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
The Appropriations Budget Ledger Balances Reconciliation Report is an Enterprise report available only to DFS and EOG/OPB. This report displays details of differences in budgetary ledger balances for LAS/PBS and Florida PALM for same budgetary COA combination to run on-demand and will be run nightly.
Report Navigation: Main Menu > Florida PALM > Reports > KK > Appr Budget Ledger Rec Report
See the sample layout report below.
Business Roles
The following business roles have access to this report:
- DFS KK Budget Processor
- DFS KK Budget Maintainer
- KK Reporter
- State Batch Scheduler
Business Process Models
This report can be found in the following business processes:
Selection Criteria
No input parameters are required for the custom Appropriations Budget Ledger Balances Reconciliation Report execution. The report fetches details for all budget periods for the current fiscal year (fiscal year derived from current date).
Report Layout
The layout of the report is listed below.
Data Field | Florida PALM RECORD.FIELD mapping |
Business Unit | Custom record.Business Unit |
Balance Type | Custom record.Ledger |
Fund | Custom record.Fund |
Budget Entity | Custom record.Budget Entity |
Category | Custom record.Category |
Budget Period | Custom record. Budget Period |
Ledger Balance Amount LAS/PBS | Custom record.LAS/PBS Balance Amount |
Ledger Balance Amount Florida PALM | Custom record.Florida PALM Budget Ledger Balance Below criteria are used to fetch Florida PALM ledger balance in custom record by KKI002 Interface:
Balances are fetched from PS_LEDGER_KK record where LEDGER = C_APPR_B including the Business Unit + COA string (Fund, Budget Entity, Category) + Budget Period combination. Multiply the resulted amount by -1.
Balances are fetched from PS_KK_BUDGET_LN record where LEDGER = C_RES_B and JOURNAL_CLASS = MANDATORY including the Business Unit + COA string (Fund, Budget Entity, Category) + Budget Period combination. Multiply the resulted amount by -1.
Balances are fetched from PS_KK_BUDGET_LN record where LEDGER = C_RES_B and JOURNAL_CLASS = UNBUDGETED including the Business Unit + COA string (Fund, Budget Entity, Category) + Budget Period combination. Multiply the resulted amount by -1.
Balances are fetched from PS_LEDGER_KK record where LEDGER = C_REL_B including the Business Unit + COA string (Fund, Budget Entity, Category) + Budget Period combination. Multiply the resulted amount by -1. |
Difference | Custom record.Difference Amount Formula: LAS/PBS balance – Florida PALM balance |
Reason Code Message | Custom record.Reason code message 1 – Amounts Not Equal 2 – No EOG Balance 3 – No PALM Balance 4 – Invalid Chartfield Value |
Version History
Date | Revision Description |
12/01/2023 | Original Version |
Was this article helpful?
