Understanding Budgets

Budget data can be synchronized between Primavera P6 and PeopleSoft.

Importing Budget Data From Primavera P6 to PeopleSoft

When importing budget data from Primavera P6 to PeopleSoft:

  • The Primavera P6 data that is used to create the budget in PeopleSoft comes from the Summary Planned Cost amounts at the WBS level. It does not come from the Primavera P6 project budget.

  • The Project Costing Third-Party Loader application engine process is used to import budget data.

  • Summary Planned Cost data from Primavera P6 is imported into PeopleSoft at the WBS level, not at the activity level.

  • If the WBS level selected on the synchronization template is less than the level that is held in Primavera P6, then the roll-up of the budget data must occur in Primavera P6 prior to the synchronization process.

    Therefore, you should run the Summarize Projects process in Primavera P6 prior to importing this budget data. If you do not run the Summarize Project process in Primavera P6, then budget amounts are not created or updated during the import to PeopleSoft process.

  • Each time budget data is imported to PeopleSoft, a new version is created during the synchronization process in PeopleSoft.

    • The new version of the budget is created with an inactive status. To make this new budget active, you must review, activate, and finalize the new version of the budget in PeopleSoft.

    • The new version of the budget is transferred at the WBS level and at the project level. The total budget and the WBS level budgets are updated.

  • If the WBS to which a budget has been assigned does not exist in the PeopleSoft system, the system will abort the synchronization process for that budget item and create a message in the synchronization log. The system continues synchronizing the remaining budget items.

Exporting Budget Data From PeopleSoft to Primavera P6

When exporting budget data from PeopleSoft to Primavera P6:

  • Budget data is extracted from the Project Costing transaction table (PROJ_RESOURCE).

    If you are using Project Costing budgeting, you must finalize your budget before exporting the budget to Primavera P6.

  • The budget amount that is exported is the Total Budget amount, which is calculated, or aggregated, in PeopleSoft at the WBS (summary activity) level and the project header level.

  • When exported from PeopleSoft, the Total Budget amount is formatted into two fields within the outbound message; Original Budget and Current Budget.

    For a project or WBS object instance, the same budget amount value is written to the Original Budget and Current Budget fields. Primavera P6 determines how these amounts are recorded or updated to the corresponding structure in Primavera P6.