Skip to Content
0
Jul 31, 2009 at 02:19 PM

Moving Net Income to Balance Sheet with Business Rule

27 Views

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