IM52 - Budget Translation to use Exchange Rate per Approval Year

[analistia16]

Dear Experts,

Kindly need your advice related to budget distribution from Investment Position to WBS Element.

We just implemented combination of Investment Management and Project System to manage client's CAPEX budgeting requirement. One investment program is defined for each approval year but the budget usage is overall (still consumable in the years after the approval year as long as the budget is still available). Availability check is conducted in object currency, thus any WBS defined in USD will have its budget checked in USD also.

Issues occured when new project for program with approval year 2012 is created in year 2013. When distributing budget from Investment Position to WBS element,  WBS budget was translated to USD using 2013 P rate, thus making the USD amount of distributed budget less than total USD amount in the Investment Position.

After checking, we found out that the translation was following planning exchange rate of the current year of posting, not the approval year of Investment Position.

Is there anyway to override this behavior? Perhaps thru config. or any available user exits?

Thanks in advance,

Regards,

Analistia

[former_member195427]

Hi,

   You are budgeting your projects in which currency? Is it USD?

Check 2 things:

a.Remove the value date in budget profile(OPS9)

b. Check your currency exchange rate settings in OB08.

Regards

[analistia16]

Hi Ankur,

Thank you for your response,

We do budget in CO Area Currency which is not USD, but check budget availability in object currency, which is in this case is USD.

Currently we have defined blank value date in OPS9 and have defined P rate for respective years in OB08.

Now it seems that blank value date is the one causes the system to read P rate of the posting year. What we are expecting is for the system to follow P rate of the approval year when translating budget in WBS element from CO Area Currency to USD.

Any idea?

Thank you,

Regards,

Analistia

[former_member195427]

Hi Analistia

Alright.

Please check the "valid from" field for P in OB08 and maintain the same date in OPS9 .

Execute CJEN followed by CJBN.

Also, please check for the same with FI person.

Regards

Ankur

[analistia16]

Hi Ankur,

In OB08 we have maintained value for P rate respectively for fiscal year 2011, 2012 and 2013.

About OPS9, unfortunately we cannot maintain value date in OPS9 because currently we have a lot of project profiles. If we do it that way, meaning we will need to define same set of project profiles for every fiscal year which seems less efficient.

Any other idea? Or, do you think using exit to override the behavior so that the system will use P rate based on approval year will be possible?

Thanks,

Analistia