LOOKUP statement in Script logic

Hi All,

I had a requirement to use a lookup value as ID to post the value in that particular member.

So i looked up the transaction data like 3 and used that in TMVL function TMVL(LOOKUP(ABC), 2012.DEC) to store that value in a particular month.

Validation is successful but while running the logic it throws error since looked up value is not considered as an integer.

My Logic will look like below,

LOOKUP

...

ABC

ENDLOOKUP

*WHEN ACCOUNT

*IS A1000

*REC(EXPRESSION=[ACCOUNT].[A2000],TIME=TMVL(LOOKUP(ABC),2012.DEC)

*ENDWHEN

Is there any work around or any other script logic statements to execute this kind of logic where we need to check the use the transaction data?

Where are we can use Lookup value?

Thanks in advance,

Ramanathan