cancel
Showing results for 
Search instead for 
Did you mean: 

BPC 7.5.112 MS - currency translation

wissler_bastien
Participant
0 Kudos

Hi,

For ICM application, I have the following script

*RUN_STORED_PROCEDURE=SPRUNCONVERSION_V4([ICM],[%CATEGORY_SET%],[ALL],[GLOBAL],[%SCOPETABLE%],[%LOGTABLE%])

I have the following business rules for currency

Account rate type : AVG  ; Formula : [AVG] , Apply to periodic : Yes

I indicated for the rates application the rate AVG

For ICM application, I executed the run package  FX Restatement

The log of this package is

SpRunConversion 1.07.27

INFO 002 : No subtables in your Appset

003 : No datasrc in your Appset, Are you Sure? Just to be sure

9240 rows calculated

66 Rows updated

For thr balance sheet items, tthere is a currency translation for all items

For P&L items , there is not currency translation

Question : have an idea of this problem?

Nb : for the prior closing, no problem for the currency translation.

Thanks

Bastien

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Bastien,

what does the END rule look like in detail?

wissler_bastien
Participant
0 Kudos

Hi Arnold,

The END rule is similar of AVR rule.

For column 'Formula' instead 'AVG' there is 'END'


Regards

Bastien

former_member187113
Participant
0 Kudos

Hi Bastien,

I've never used the "Apply to Periodic" much. Just out of interest, what happens if you rerun the translation without it checked?

Kind Regards

Nick

wissler_bastien
Participant
0 Kudos

Hi Nick,

I tested the currency translation without 'apply to periodic" and I have the same problem : for only the PL account , no currency translation (from LC to EUR)

Kind regards

Bastien

former_member187113
Participant
0 Kudos

Hi Bastien,

So all accounts in your ICM account dimension have the RateType property as AVG? Just checking.

Ta

Nick

wissler_bastien
Participant
0 Kudos

Hi Nick,

No, only the PL account have the rate type property as AVG

Nb : the Balanced sheet accounts the rate type property as END

Bastien

former_member187113
Participant
0 Kudos

Hi Bastien,

Makes sense. (That's pretty standard).

Any chance of you sending me a screengrab or your currency rules, please?

Ta

Nick

wissler_bastien
Participant
0 Kudos
wissler_bastien
Participant
0 Kudos
wissler_bastien
Participant
0 Kudos

I tested the following scenario:

I  changed for one PL account the rate type  property from AVG to END and the currency translation is OK

I dont understand why the currency translation doesn't work with the rate type AVG

Nb : with rate application, I input the AVG

former_member187113
Participant
0 Kudos

Hi Bastien,

It looks like you've covered your bases. I normally run SQL queries in the database to make sure I have not made a mistake (in terms of having the rates).

A suggestion might be to copy just your income statement to a future period (or separate category), input some exchange rates, and see what the Stored Procedure comes returns when you run it.

There is a log file that it creates in the SQL database.

Regards

Nick

wissler_bastien
Participant
0 Kudos

Hi Nick,

Thank you for your answer.

But for now, I no longer work on this mission and so I can not test copy

Regards

Bastien

former_member186498
Active Contributor
0 Kudos

Hi Bastien,

I don't know ICM application but verify that in your flow dimension (type S = SubTables) contains the properties Flow_Type, Is_Input and SUBTABLES_ORIG and if the values inside are correct.

Did you receive an FX error or other error codes?

Regards

     Roberto

wissler_bastien
Participant
0 Kudos

Hi Roberto,

For ICM application, there is not dimension with the type S

According to package , i think that its only information :  INFO 002 : No subtables in your Appset

I dont receive the FX error, only the following message

INFO 002 : No subtables in your Appset

003 : No datasrc in your Appset, Are you Sure? Just to be sure

9240 rows calculated

66 Rows updated

Bastien