Skip to Content
0
Former Member
Mar 08, 2013 at 10:13 PM

Default logic for Net variation

111 Views

I have the following Default script logic for net variation. My understanding of the function is that whenever the data is entered, system should run the default and caculate the net variation. For example my end flow for a BS account relevant for net variation is 1000 and the OB flow is zero, default logic should calculate the net variation which in this case is 1000. But this is not happening. Pl let me know whether my line of thinking is correct and if not what is this suppose to do.

Calculating F15 - net variation as the difference between closing and the sum of other balance sheet flows

//---------------------------------------------------------------------------------------------------------------------------------------------

// Information: [XDIM_MEMBERSET FLOW = <all>] is mandatory in the default logic

*XDIM_MEMBERSET MEASURES = YTD

*XDIM_MEMBERSET ACCOUNT = <all>

*XDIM_MEMBERSET FLOW = <all>

*XDIM_MEMBERSET AUDITID = %AUDITID_LIST%

*WHEN ACCOUNT.GROUP

*IS "BSA"

*WHEN ACCOUNT.ACCTYPE

*IS "AST", "LEQ"

*WHEN FLOW

*IS "F99"

*REC(FACTOR = 1,FLOW = "F15")

*ELSE

*WHEN FLOW.PARENTH1

*IS "END"

*WHEN FLOW

*IS "F15"

// nothing

*ELSE

*REC(FACTOR = -1,FLOW = "F15")

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*ENDWHEN

*COMMIT

Appreciate an answer.