Skip to Content
0
Former Member
Dec 08, 2009 at 07:42 PM

New Reporting Currency won't Convert

35 Views

Hey Experts!

We're running BPC v 5.1.502 for Microsoft SQL.

I've recently setup the Currency Conversion features with BPC. I was able to successfully convert LC Values to both USD and EUR. These 2 Currencies were already setup as Reporting currencies by somebody else, probably years ago.

Now, I then tried to add the CAD currency to the conversion process, but for some reason when the "FX Restatement" Task is run, the system only converts the USD and EUR values. It seems to ignore the CAD currency.

I've validated the following:

I have rates existing for the CAD currency in the tblFactRate table.

For the CAD record in my InputCurrency Dimension, I have "Y" in the reporting field and have defined the same Group that is used by USD and EUR.

In my Groups Dimension, I've ensured that CAD is available, has a "Y" in the Reporting Column an dhas a Currency_Type = 'R'

Everything is set correctly on the Rate, RateEntity, RateSrc, and RptCurrency Dimensions as well.

What else am I missing? Why will the first two rates calculate, but not the 3rd?

Any help is appreciated.

Thanks!

Sean