Schedule of Allotment Balance Report (KKR008)
  • Dark
    Light
  • PDF

Schedule of Allotment Balance Report (KKR008)

  • Dark
    Light
  • PDF

Article summary

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:

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?

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.