Integrating Budget Data with Planning and Budgeting

PeopleSoft Project Costing integrates with PeopleSoft Planning and Budgeting for Enterprise Performance Management (EPM), which is an application specifically designed for preparing budgets and providing the sophisticated processing necessary to perform the budgeting calculations and forecasting required to produce a truly viable budget.

Page Name

Definition Name

Usage

Send to Budgeting Page

PC_TO_BD

Send project information to PeopleSoft Planning and Budgeting to update budgeting data and to aid in forecasting future budgets by using the Project Costing to Budgeting Application Engine process (PC_PC_BD_B).

Retrieve from Budgeting Page

PC_BD_TO_PC

Import budgets prepared in PeopleSoft Planning and Budgeting into PeopleSoft Project Costing using the Budgeting to Project Costing Application Engine process (PC_BD_TO_PC).

Transaction List Page

PROJECT_EXPRESSG

View budget transactions in Project Costing.

See also, PeopleSoft EPM Planning and Budgeting, “Integrating with Other Applications”, Using Data from PeopleSoft Project Costing, Processing Project Costing Data

Use the Send to Budgeting page (PC_TO_BD) to send project transaction information to PeopleSoft Planning and Budgeting to update budgeting data and to aid in forecasting future budgets by using the Project Costing to Budgeting Application Engine process (PC_PC_BD_B).

Navigation:

Project Costing > Budgeting > Send PC Budgets to Budgeting

This example illustrates the fields and controls on the Send to Budgeting page. You can find definitions for the fields and controls later on this page.

 Send to Budgeting page

Field or Control

Description

Option

Select an option to send all or specific transactions to PeopleSoft Planning and Budgeting.

Scenario

Select a scenario, which is a PeopleSoft ChartField used to identify different assumptions or types of budget information.

After the historical data is in the Project Based Ledger table (LEDGER_PROJ) and is copied to the PeopleSoft Warehouse, PeopleSoft EPM Planning and Budgeting users can use it to build a budgeting model and prepare budget data. When the budget is complete, a PeopleSoft Planning and Budgeting user moves the data back into the Project Based Ledger table by using the Import Budgeting Data page.

After a budget is sent back to the Project Based Ledger table, it is ready for transfer to Project Costing.

Use the Retrieve from Budgeting page (PC_BD_TO_PC) to import budgets prepared in PeopleSoft Planning and Budgeting into PeopleSoft Project Costing using the Budgeting to Project Costing Application Engine process (PC_BD_TO_PC).

Navigation:

Project Costing > Budgeting > Retrieve From Budgeting > Retrieve From Budgeting

This example illustrates the fields and controls on the Retrieve from Budgeting page. You can find definitions for the fields and controls later on this page.

 Retrieve from Budgeting page

After a budget is generated in PeopleSoft Planning and Budgeting, and the budget information is placed in the Project Based Ledger table, you can import it into the Project Transaction table using the Retrieve from Budgeting Application Engine process (PC_BD_TO_PC). The Retrieve from Budgeting process copies the information from the Project Based Ledger table to the Project Transaction table.

If you plan to create multiple budget scenarios for your projects in PeopleSoft Planning and Budgeting, you should create multiple budget analysis types in Project Costing and adjust the Retrieve from Budgeting process so that individual scenarios are mapped to different analysis types. This action is necessary if you want to track multiple scenarios in Project Costing. If your Application Engine process maps all scenarios to the same analysis type, then each subsequent scenario will add additional resource transactions of the same analysis type.

If a budget row does not contain an analysis type from the Project Based Ledger table, the integration process assigns the first analysis type from the analysis group that is specified on the Project Costing Definition page for the project.

Note: This PeopleSoft application delivers sample data that contains analysis types BD1 (Total Cost Budget - Scenario 1) through BD9 (Total Cost Budget - Scenario 1) to facilitate multiple budget scenarios.

See also, PeopleSoft EPM Planning and Budgeting, “Integrating with Other Applications”, Using Data from PeopleSoft Project Costing, Processing Project Costing Data

Use the Transaction List page (PROJECT_EXPRESSG) to view budget transactions in Project Costing.

Navigation:

Project Costing > Transaction Definitions > Transaction List > Transaction List

You can create a special analysis group that retrieves only transactions with budget-related analysis types.