Question on Currency conversion

[Former Member]

The data from source system is coming with Local currency and reporting currency.

For some of the accounts such as goodwill, stock..we don't want the translation to be run again in BPC...

Hence for these accounts I have mentioned the rate type as NOTRANS/HIST. But translation blanks out the historical reporting currency amount.

How to make sure that some of the accout never gets translated, but is maintained as received from source system..

Appreciate inputs..

[Former Member · Accepted solution]

The problem is, is that in multicurrencytrans.lgl BPC will mark the reporting currency as a calculated member.

typically this file is located in the SystemLibrary\Logic Library folder within the webfolder of your appset

i.e:

D:\BPC\Data\Webfolders\ApShell\SystemLibrary\Logic Library\multicurrencytrans.lgl

the second before bottom line reads:

*FOR %CURR%=%REPORTING_CURRENCIES%

[CURRENCYDIM].[#%CURR%]=null

*NEXT

you can comment this out, you may need to reprocess your application before re-running the logic.

//*FOR %CURR%=%REPORTING_CURRENCIES%

// [CURRENCYDIM].[#%CURR%]=null

//*NEXT

Finally you should set the translation rate type of the account to blank or notrans (try both iirc).

If you have an example such as common stock where you have a historic transaction rate that is specific to the transaction - you cannot really use BPC's rate cube to record the historic rate, in this case you can key in or load the translated figure for that account. If in the future you decide to translate that account, you should remember NOT to rerun an FX restatement for historic periods, else you lose your data translated as historic transaction rate.

Regards,

Hiren.

Edited by: Hiren Amin on Oct 2, 2009 11:59 PM

Edited by: Hiren Amin on Oct 3, 2009 12:00 AM

[Former Member]

Hi Doodwala,

Are you using Script logic or business rules to do currency conversion?

If you are using business rules, 1st you have to define a rate type for all the accounts to which you are gone a load data directly, say it as HIST and you have to define a Conversion rule with [as_is] in the formula for this rate type.

And if you are using script logic, make sure your script excludes HIST rate type accounts in calcualtion...

*when Account.ratetype

*is <>"HIST"

//Convert to reporting curr

*endwhen

Regards,

Kranthi

[Former Member]

Hi Doodwala,

Are you using Script logic or business rules to do currency conversion?

If you are using business rules, 1st you have to define a rate type for all the accounts to which you are gone a load data directly, say it as HIST and you have to define a Conversion rule with [as_is] in the formula for this rate type.

And if you are using script logic, make sure your script excludes HIST rate type accounts in calcualtion...

*when Account.ratetype

*is <>"HIST"

//Convert to reporting curr

*endwhen

Regards,

Kranthi

[Former Member]

Hi Doodwala

[Former Member]

Hi Doodwala