Schedule of Allotment Balance Report (KKR008)

Print
Share
Dark

Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Report Description

The Schedule of Allotment Balances Report allows users with security access to run a report to reflect recorded Allotments, Encumbrance, expenditures, and associated remaining balances for designated time periods grouped by designated ChartField and ChartField combinations.

Report Navigation: Main Menu > Florida PALM > Reports> KK > Schedule of Allotment Balances Report

See the sample layout report below.

Sample Report Layout coming soon!

Business Roles

The following business roles have access to this report:

KK Reporter

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:

Selection Criteria Layout coming soon!

Report Layout

The layout of the report is listed below. Description of data fields can be found in the .

Data Field	Florida PALM RECORD.FIELD mapping
Report Header
Business Unit	Run Control Page value
Date From	Run Control Page value
Date To	Run Control Page value
Organization	Run Control Page value
Account	Run Control Page value
Fund	Run Control Page value
Budget Entity	Run Control Page value
Category	Run Control Page value
State Program	Run Control Page value
Grant	Run Control Page value
Contract	Run Control Page value
OA1	Run Control Page value
OA2	Run Control Page value
PC Business Unit	Run Control Page value
Project	Run Control Page value
Activity	Run Control Page value
PC Source Type	Run Control Page value
Report Sub-Header Section
Business Unit	Run Control Page value
Organization	Run Control Page value
Fund	Run Control Page value
Budget Entity	Run Control Page value
Report Detail
Organization	KK_ACTIVITY_LOG.DEPTID
Account	KK_ACTIVITY_LOG.ACCOUNT
Account Description	Account ChartField description
Fund	KK_ACTIVITY_LOG.FUND_CODE
Budget Entity	KK_ACTIVITY_LOG.BUDGET_REF
Category	KK_ACTIVITY_LOG.PRODUCT
State Program	KK_ACTIVITY_LOG.CHARTFIELD2
Grant	KK_ACTIVITY_LOG.PROGRAM_CODE
Contract	KK_ACTIVITY_LOG.CHARTFIELD1
OA1	KK_ACTIVITY_LOG.CLASS_FLD
OA2	KK_ACTIVITY_LOG.CHARTFIELD3
PC Business Unit	KK_ACTIVITY_LOG.BUSINESS_UNIT_PC
Project	KK_ACTIVITY_LOG.PROJECT_ID
Activity	KK_ACTIVITY_LOG.ACTIVITY_ID
PC Source Type	KK_ACTIVITY_LOG.RESOURCE_TYPE
Allotments	Sum of Budget balance from KK_ACTIVITY_LOG for allotment detail Budget ledger for provided date range on the run control page. KK_TRAN_DT Between Date From and Date To Multiply calculated balance by -1.
Expenditures (MTD)	Sum of Expense balance from KK_ACTIVITY_LOG for allotment detail Expense ledger for provided date range on the run control page. KK_TRAN_DT Between Date From and Date To
Expenditures (YTD)	Sum of Expense balance YTD from KK_ACTIVITY_LOG for allotment detail Expense ledger. KK_TRAN_DT Between ‘07/01/20XX’ and Date To. Where XX is a fiscal year derived from ‘To Date’ value.
Encumbrances	Sum of Encumbrance balance from KK_ACTIVITY_LOG for allotment detail Encumbrance ledger for provided date range on the run control page. KK_TRAN_DT Between Date From and Date To.
Allotment Balances	(Allotment - Expenditures (YTD) – Encumbrance) * -1

Version History

Date	Revision Description
12/01/2023	Original Version

Was this article helpful?

What's Next

Spend Plan Report (KKR010)

Table of contents

Report Description
Business Roles
Business Process Models
Selection Criteria
Report Layout
Version History