Issue with group currency conversion

[Former Member]

SAP BPC 10.0 NW SP9

Hi All,

We  have a strange issue in group currency conversion.

The below issue with group currency conversion only exists for specific set of entities 4006 taken in below example is not generating correct figures for consolidation group B_XXXX. However, it works fine for other entity 4007.

Issue 1 - First, when it is run for 2006.JAN, it generates the correct numbers in NO_GRP as well as B_STAT. Next time if it is run again for 2006.JAN, it clears out values in USD and NOK under No_GRP and makes them 0 as seen from below screenshot. But this happens only for 4006 while 4007 works fine.

Issue 2 – If we run the currency conversion only once, it is aggregating the values from January and Feb while writing to Feb. Similarly, it is aggregating the values from Feb and Mar while writing to Mar. And, this issue is also with 4006 and works fine for 4007. As can be seen from below screenshot, apart from the figure of 1400 in Feb, system is picking up 500 from Jan and then writing 1900 to Feb.

Further, there is another consolidation group for which this works perfectly fine for both these entities. The ownership structure is quite big for each of these two consolidation groups, so if there is any specific thing required, please let me know and I will share details.

curr conversion rule is set with periodic flag as Y and this being YTD storage model, it is expected to work fine which it is for most of the cases.

Script -

//Translation for Groups specified at run-time

*RUN_PROGRAM CURR_CONVERSION

CATEGORY = %CATEGORY_SET%

GROUP  = %CONSLEVEL_SET%

TID_RA = %TIME_SET%

RATEENTITY = GLOBAL

*ENDRUN_PROGRAM

Any thoughts on where I should explore more?

Regards,

Ashish

[Former Member · Accepted solution]

Hi Ashish,

Are those reports showing YTD or periodic data? What kind of account are we seeing, balance sheet or profit and loss?

BR,

Arnold

[Former Member · Accepted solution]

Hi Arnold,

Thanks for your reply. Report was displaying YTD data, so it had nothing to do with whether periodic numbers were getting added and being displayed as YTD. All numbers were YTD. The account was a PnL account with ratetype as AVG and AVG BR was set with periodic flag as Y.

Anyway, this issue was with one of the consol group within the consolidation group which was giving incorrect results. Property 'STORE_GROUP_CURR' was set as Y at the parent consolidation group but was blank for the newly added group within that parent group. After maintaining this as Y for all sub-groups, issue was fixed.

I can understand this should have written 0 values at No_GRP but the fact that it was accumulating YTD numbers is something I still can't comprehend. And that too only for few of the entities and not all!

Regards,

Ashish