Title
PBET - Line items for Overall Budget Vs. Commitments/Actuals

Purpose
This report is used to display overall budget versus commitment/actualline items for period-based encumbrance/actual tracking.

Integration
The report can display the original document on the drilldown of ancommitment/actual line item or a budget line item (in case of MixedView). The user can also drilldown to this report from a line of thetotals report(PBET - Totals for Overall Budget Vs. Commitments/Actuals).

Prerequisites

• FM must be active.


• Period-Based Encumbrance Tracking (PBET)must be active.


• Encumbrances/Actuals must have been posted against the budget/release.

Features
The report lists the overall distributable budget/releases and showshow it evolves with the encumbrances/actuals posted on it. The lineitems are sorted by account assignment and posting date/CPU date.
Each line item is categorized based on the value type and the amountvalues are assigned to different columns in the list with respect tovalue types. The columns and their respective value types are listed:


• Payments: Payments, Payment transfers, Profit transfers, Down payments
and Actual CO postings.

• Invoices: Invoices and Parked Documents.


• Budget: Cash budget, Cash release, Cash budget commitments and Cash
release commitments.

• Open Items: All other value types.

Using the amount values of these columns, the values for the columns'Budget - Payments', 'Budget - Invoices' and 'Available budget' arecalculated. The formula depends on the report view selected by theuser.
Unmixed View:
This view shows evolution of total budget/release per accountassignment by displaying the encumbrance/actual line items posted onit.
The total distributable budget/release, 'Total Budget' is calculatedper account assignment .

• Formula for the first line item:

'Budget - Payments' = 'Total Budget' - 'Payments'.
'Budget - Invoices' = 'Total Budget' - 'Payments' - 'Invoices'.
'Available Budget' = 'Total Budget' - 'Payments' - 'Invoices'
- 'Open Items'.

• Formula for all the other items:

'Budget - Payments' = Previous 'Budget - Payments' - 'Payments'.
'Budget - Invoices' = Previous 'Budget - Invoices' - 'Payments'
- 'Invoices'.
'Available Budget' = Previous 'Available Budget' - 'Payments'
- 'Invoices' - 'Open Items'.
Mixed View:
This view displays the evolution of the budget/release by displayingboth the budget/release and the encumbrance/actual line items posted onit.
The value of Previous 'Budget - Payments', Previous 'Budget - Invoices'and Previous 'Available Budget' is zero for the first line item.

• Formula for all the line items:

'Budget - Payments' = 'Budget' + Previous 'Budget - Payments'
- 'Payments'.
'Budget - Invoices' = 'Budget' + Previous 'Budget - Invoices'
- 'Payments' - 'Invoices'.
'Available Budget' = 'Budget' + Previous 'Available Budget'
- 'Payments' - 'Invoices' - 'Open Items'.
INCLUDE FIFM_EPSELECT_FMF OBJECT DOKU ID TX

Selection


• FM Area


• Fund


• Funds Center and related information


• Funds Center and related information


• Report currency related information


• Budget or Release


• Payment Budget or Commitment Budget


• Mix budget and actuals

INCLUDE FIFM_ALVLINK OBJECT DOKU ID TX
Limitations
The user cannot sort the list because the evolution of the budget isbased on dates.
The report can be executed only for an account assignment combinationwhich has a budget assigned to it. When it is executed for an accountassignment which has no budget, the system displays that no records arefound. In this case, the report has to be started at a funds center orcommitment item higher up in the hierarchy. This is because a documentcan be posted on an account assignment combination which has no budgetthough the budget is expended from a funds center/commitment item whichis at a higher level in the hierarchy.
When the user executes the report for releases when the availabilitycontrol is based on the budget and vice versa, the values displayed bythe report may not be right.
The 'Mixed View' of the report may display negative interim values foravailable budget. Though the interim values might not reflectavailability control, the end result (ie. the subtotal lines) alwaysdoes .