on 01-15-2016 10:08 AM
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
Hi Bastien,
what does the END rule look like in detail?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.