Moving Net Income to Balance Sheet with Business Rule

[mark_glowczewski2]

Hello,

The system is BPC 7.0 SP3, on SQL 2008

I was wondering if anyone else has had this issue. I created a business rule that moves Net Income Year to Date to the Balance Sheet, and call it through logic.

The problem I am having is that all periods are calculating correctly except for Period 12. The same number that is calculate for Period 11 is posted to Period 12.

The Time Dimension looks correct with it's prior and current and next properties.

Here is the Business Rule setup, all entries you do not see are NULL

Transformation Group Source Source DataSRC Destination Account Destination DataSRC

CEYTD NetIncome TOTALADJ 29210 Input

Reverse Sign YTD Remark

False True CEYTD

Here is the logic I use to call the stored procedure.

*RUN_STORED_PROCEDURE=SPRUNCALCACCOUNT([%App%], [Actual], [USD], [%SCOPETABLE%], [%LOGTABLE%], [CEYTD], [99])

*COMMIT

*RUN_STORED_PROCEDURE=SPRUNCALCACCOUNT([%App%], [Actual], [LC], [%SCOPETABLE%], [%LOGTABLE%], [CEYTD], [99])

*COMMIT

If anyone has experienced this issue before, I would really appreciate some help on how to resolve it.

Thank you,

Mark Glowczewski

[Former Member · Accepted solution]

Hi

why not try the script logic in doing this it will be much more flexible

Thanks

[Former Member]

WHat is your data source? It sounds like there may be an issue with the DS.