Rollforward Balance Sheet Account Script Logic

[Former Member]

Hello-

I am attempting to write a script that will take the latest value out of the "actual" category for account bs280. The total for this account should be rollforward to every month in the working plan to account 160700. Here is my script, I am getting the error "unknown dimension name in keyword" on line 35.

*SELECT(%WP2%,"[ID]","TIME","[WP]='Y'")

*SELECT(%LTP2%,"[ID]","TIME","[LTP]='Y'")

*LOOKUP FINANCE  

*DIM DATASRC = <ALL>

*DIM MEASURES = PERIODIC

*DIM FLOW = <ALL>

*DIM CATEGORY = ACTUAL

*DIM COMPANY = <ALL>

*DIM CCENTER = <ALL>  

*DIM TPARTNER = <ALL>  

*DIM PCPARTNER = <ALL>  

*DIM TIME = %CURRMO% 

*DIM PPE1:ACCOUNT = BS280

*ENDLOOKUP

*XDIM_MEMBERSET PCENTER = BAS(F2000)

*XDIM_MEMBERSET ACCOUNT = BAS(FIXEDASSETS_NET)

*XDIM_MEMBERSET CATEGORY = WORKINGPLAN

*XDIM_MEMBERSET MEASURES = PERIODIC

*XDIM_MEMBERSET CCENTER = <ALL>

*XDIM_MEMBERSET DATASRC = INPUT, SYNCCAPEX, ECC, BCF

*XDIM_MEMBERSET PCPARTNER = <ALL>

*XDIM_MEMBERSET TPARTNER = <ALL>

*XDIM_MEMBERSET TIME = %WP2%

*FOR %T%=%WP2%

  *WHEN ACCOUNT

  *IS 160700

  *REC(FACTOR=1*LOOKUP(PPE1),TMVL(1,%T%))

  *ENDWHEN

  *COMMIT

*NEXT

[former_member186338]

HI Tom,

Incorrect syntax in this line:

  *REC(FACTOR=1*LOOKUP(PPE1),TMVL(1,%T%))

Please read  help about REC statement

Vadim

P.S. Not sure about the script idea in general - no detailed info provided