Multiple currency planning and budgeting?

[Former Member]

Hi all

We are having a requirement of planning and budgeting in same WBS with multiple currencies and also seeing reports in different currencies on single screen.

Now has anybody explored this area and has anything to suggest.

Thanks in anticipation

Raman

[Former Member · Accepted solution]

Set Planning and Budget Currency as "Transaction Currrency" respectively in Planning & Budget Profile to do Planning and Budget in other than Controlling Area currency or Object Currency.

To see report in multiple currency u have go for cutomized report development.

[Former Member · Accepted solution]

Thanks Venkat

I think I need to elaborate a little more perhaps.

i wish to plan on one wbs both in INR and USD because i need to pay my vendor for same job in two currencies. Now the user wants to do planning in both currencies and similarly in reports he wishes to see planned values in both currencies against same wbs.

Same thing appplies to budgeting.

I hope I will get some clue on this if possible.

Regards

Raman

[Former Member · Accepted solution]

Hi Raman

The following is the literature from SAP on the subject. You may find it useful.

Planning and Budgeting in Any Currency

Use

International groups often use one uniform company code currency (group currency) in CO. However, it may be necessary to plan and budget in the respective local currency as the majority of costs will be incurred in the local currency. The local currency is usually the corresponding company code currency.

Previously only budgeting of jobs (orders and projects) was possible in the local currency.

From Release 4.70, you can also budget investement programs in the local currency. In addition, it is possible to plan investment programs, appropriation requests and jobs directly in the local currency.

As was previously the case for orders and projects, plan and budget values for investment programs and appropriation requests are also saved in both the controlling area and local currencies defined in the master record of each object. If you change or re-specify the exchanged rates used, it is now possible to recalculate the values in the local currency using the values in the controlling area currency, and vice-versa.

In reporting for IM, it is even possible to calculate evaluations in any report currency (plan, budget and assigned values). If the values are available in the specified report currency, they are issued unchanged. If they are not available, they are converted from the controlling area currency into the report currency.

Effects on Existing Data

Before Release 4.70, the plan values for appropriation requirements, were only saved in the controlling area currency. This was also the case if a local object currency was specified in the master record for the appropriation requirement. From Release 4.70, the plan values for appropriation requirements are always saved in the controlling area and local currencies. Therefore, you must adjust appropriation requests that were created in an earlier release and use a local currency that varies from the local object currency. The easiest way to do this is to use the program RAIMCRC2 to recalculate the plan values in the local object currency for appropriation requests whose plan values are in the controlling area currency (transaction IMCRC2, menu path: Financial Accounting -> Investment Management -> Appropriation Requests -> Tools -> Recalculate Currency Plan for Appropriation Requests). Before you run the program, select the relevant option in the Process Control section of the initial screen.

Effects on Customizing

Adjustment of Planning and Budget Profiles

To enable the planning of investment programs, appropriation requests and jobs in a transaction currency different to the controlling area currency, you must adjust the relevant planning profiles.

To enable the budgeting of investment programs in a transaction currency different to the controlling area currency, you must adjust the relevant budget profiles.

In the planning currency (or budgeting currency) section of the planning (or budget) profile, you must define the transaction currency in which planning (or budgeting) is to be executed:

Only in the controlling area currency (default),

Only in the object currency

(= local currency defined in object master record ) or

In a transaction currency chosen at the start of planning/budgeting

(this option is not possible for appropriation requests).

In the planning or budget profiles, you must also define the exchange rate types to be used for the conversion of total values that are not dependent on the fiscal year.

To adjust the planning profiles, use the process steps:

Maintain Planning Profiles (investment programs)

Maintain Planning Profile for Cost Planning (appropiation requests)

To adjust the budgeting profiles, use the process steps:

Define Budget Profiles for Investment Programs (investment programs)

Exchange Rate Types

In the fiscal-year-dependent data of the CO planning versions, you must also define the exchange rate types to be used for conversion of plan values that are not dependent on the fiscal year.

For conversion of fiscal-year-dependent budget values and fiscal-year-dependent plan values of appropriation request variants not yet assigned to a plan version, each exchange rate type is taken from the fiscal-year-dependent data of the CO planning versions 0.

As the plan or budget values are stored in the transaction, controlling area, and local currencies, the exchange rates used must enable the conversion of the transaction currency into the controlling area and local currencies. Where necessary, the exchange rates used must be extended.

To enter the exchange rate types, use the process step:

Define Versions (investment programs)

Change Planning or Budget Currency

If you always planned or budgeted existing investment programs/measures in the controlling area currency, it is not subsequently possible to change the planning or budget currency to the object currency in the planning or budget profiles. This conversion is not prevented in Customizing, but leads to an error when you next plan or budget existing investment programs/measures. Alternatively, you can convert the planning or budget currency into the transaction currency in the planning or budget profiles, and set the object currency indicator as default.

A similar restriction does not exist for appropriation requests. You can change the planning currency in the planning profile at any time.

Use the process step under "Adjust the Planning and Budgeting Profiles".

Detailed Planning

When you call up detailed planning from structure-based cost planning or revenue planning, the standard SAP planning profiles are used, to which the standard SAP planning layouts are assigned. These planning profiles cannot be changed in the planning transactions. Import the standard SAP planning layouts 1-401-IM, 1-402-IM, 1-403-IM, 1-701-IM, 1-702-IM and 1-703-IM using the transaction OKBF from client 000 in your client.

To execute the import, choose the process step:

Import Standard Planning Layouts.

Reporting Currency for IM Reporting

In IM reporting, if you want to be able to specify a reporting currency that is different to the controlling area and object currencies used in the investment program items or subordinate appropriation requests and measures, another exchange rate type is required for the due conversion of plan, budget, or values into the reporting currency. You define this exchange rate type in Customizing for the program type for the investment program to be reported ( Group Reporting).

To enter additional reporting currencies, use the process step:

Define Program Types (investment programs)

you may also refer the following link in SAP help on the subject

[http://help.sap.com/saphelp_47x200/helpdata/en/86/98853478616434e10000009b38f83b/frameset.htm]

Venu

[Former Member]

Hello

Planning in multiple currencies is possible if you use CJR2 transaction and create a new planning profile for the new currency. Then against a cost element you can do planning for the new currency.

Now for budgeting I am afraid you do not have any other choice than planning in any one currency and using the exchange rate type to factor the conversion to the other currency.

I know you might have unique business requirements but a simpler and straightforward way of doing this is by creating 2 sub level WBS elements and doing the cost planning & budgeting for either in the currency of your choice. To know which is planned in which currency you can maintain a record in the project text or description.

Regards

Renjith

[Former Member]

Thanks Venu and Renjith

Rewarded as well

Raman

[Former Member]

This message was moderated.