FX Restatement BCP 10 MS

[Former Member]

Hi,

We recently upgrader to BPC 10 from BPC7.5 and have a problem with some accounts that does not convert into other currencies when running the package FX Restatement. In BPC7.5 we had a few non-financial accounts that was converted into other currencies from LC by factor of 1. In our account-dim we had the property Rate-type empty and it worked fine. Now, in BPC10 it does not work for those accounts but works fine for all the other accounts?

We also tried to fill in a Rate-type value which we haven't used before, but we have values in the Rate model and it still doesn't work?

Any ideas, are we missing something?

How does the SPRUNCONVERSION work?

We dont get any error message when running the package, it just doesnt include the non-financial accounts.

Thanks,

Fredrik

[Former Member · Accepted solution]

Hi Fredrik,

Assuming that you have maintained all required properties in the all models (Finance, Rate). For currency conversion Rate type property is important. In rate type property you have to maintain valid member from Rate account(account that has been used in rate model) of the rate model. Normally we use "AVG","END","CLO","AVGFLOW","HISTBEQ". AVG  normally used for P&L account and "CLO" or "END" used for balance sheet account. and then we configure the rules. For do currency conversion of P&L account we create separate rule and for balance sheet conversion we create other rule.

Basically we do currency conversion based on the rate type so rate type property will decide the source account for conversion. means for P&L account we maintain AVG and in rule we select AVG means all account who has rate type = "AVG" will be source account for that rule.

so similarly you create another rule for those account for which you have maintained another rate type.

But ensure that rate type property should be a valid member of account(rate model account).

for each account type maintain separate rule.

Hope cleared all doubts.

[Former Member · Accepted solution]

Thanks alot!

I knew there was something I missed to adjust, the rules.

Best Regards

Fredrik