Understanding How Multiple Currencies Are Processed

During line item budgeting, you can view up to nine historical monetary amounts with the proposed budget and forecast planning types that you define when you setting up the planning model. View these historical and proposed amounts in any target currency. Define your view using the View Definitions page. When you are working with line item budgets, Planning and Budgeting performs online conversion of the ledger data to target currencies using exchange rates by period.

During the staging process, for in-service assets that use currencies that are not defined as entry currencies, the system converts asset values with the exchange rate using the average budget period rate. This is the same methodology that is used by line item budgeting data.

When you use the asset budgeting activity, the entry currencies that are defined by the planning model are available for adding new assets.

When you use the position budgeting activity, only the entry currencies that are defined by the planning model are available for adding positions. A single currency code is associated with a job code when adding a position, and it cannot be changed when entered. When existing positions have currencies that are not defined as an entry currency, they are converted during staging into the planning model using the average exchange rate of the budgeting cycle in the model. Currency codes for existing position and job rows cannot be changed during the edit process.

When you run the Data Staging Application Engine (BP_STG)), the system uses ledger data that you import from your Financial Management Solutions database. Specifically, Planning and Budgeting takes the ledger values from POSTED_TRAN_AMT (posted transaction amount) located in PS_LED_F00 (actual ledger), PS_BP_LED_BUDG_F00 (standard budget ledger), PS_BP_LED_KK_F00 (control budget ledger), or PS_BP_LED_PROJ_F00 (project budget ledger).

During this stage, if the transaction currency of the source data is not defined as an entry currency for the planning model, the data staging converts the transaction amounts to the base currency of the business unit. For line item ledger data and asset data transaction, the conversion is based on the exchange rate as-of date. For position data transaction, the conversion is based on the average rate of the budgeting cycle.

Use the Update Staged Data process and select the Update Exchange Rates function to update exchange rates that changed since the planning model was originally published. When you run this process, the system updates exchange rates and the average period rates for entry-target currency for a planning model and scenario that have already been staged. The update can impact new data entry and target currency viewing.

This process updates the exchange rates and stores them in PS_BP_ACTV_SCEN_RT for use during budgeting. The process takes the effective-dated rates and converts them into average budget period rates used in the model, prorated by number of days.

Planning and Budgeting enables you to define parameters to use the ACE analysis reports to view the results online or to download the results to a Microsoft Excel spreadsheet. Use the Select View Currency field to specify the currency. Available ACE analysis reports for line item budgeting include Version Analysis and Variance Analysis.

Additionally, use the standard delivered SQR reports with Planning and Budgeting. The reporting options enable you to compare line item budget activities within a version, across budget versions, and across budget periods using a defined entry or target currency when a planning model has enabled multicurrency options.

When entering budget selection criteria for the SQR reports, three currency inquiry options are available:

• All Entry in a Single Target

  You select which target currency to view or report all entry budget data.

• One Entry Only

  You select which entry currency code to view or report budget data.

• One Entry in a Single Target

  You first select the entry currency code and then select which target currency to view or report budget data.

Available SQR report options for line item budgeting include Version Analysis, Ledger Type Comparison, Budget Comparison, and Summary of Methods.

When you run the Export to General Ledger or Export to HR application engine process (BP_EXP), the system extracts budget data from the planning model into the general ledger stage table PS_BP_LEDGER_BDEXP for line item data (and one of the following source budget ledgers in EPM — BP_LED_BUDG_F00, BP_LED_PROJ_F00, or BP_LED_KK_F00), and for position-related data PS_BP_JOB_F00, PS_BP_POSITION_D00, and BP_COMP_F00.

For line item ledger data, the system exports budget amounts in the entry currency that is used during the budgeting process and saves them in POSTED_TOTAL_AMT and POSTED_TRAN_AMT. For POSTED_BASE_AMT, the system converts and saves the currency as the business unit base currency.

For data that is exported to human resources, the system exports position budget data amounts in the entry currency used during the budgeting process. For those positions originally converted to an entry currency when the source currency was unavailable, the system converts it to its original source currency.

After you import the budget data into the appropriate ledger tables in the PeopleSoft Financial Management database, you can use the Allocation process (GL_ALLOC) in PeopleSoft General Ledger to create journal entries that post the budget amounts in the POSTED_TOTAL_AMT (posted total amount) field in the base currency. The system may update or create new rows with the budget amounts in POSTED_TRAN_AMT converted to base currency and stored in the POSTED_TOTAL_AMT field.