Help on Script logic

26 Views

Hi,

I have two applications capex and finance and copy data from capex to finance .

Dimensions in finance : Account, Costctr,BU ,category ,RptCurrency, Time , DataSrc, ptype , did .

Dimensions in capex : Account, costctr,BU ,category ,RptCurrency, Time , DataSrcoth, Asset,Capvalue .

Asset & capvalue is a user-defined dimension in capex .

I want to copy the GL accounts in accounts dimension with property acctype = "AST" and finalvalue ( one member in capvalue dimension ) and datasrc = "input" from capex to to finance application.

I tried using the following script logic :

*DESTINATION_APP=finance

*SKIP_DIM=ASSET

*ADD_DIM ptype=NON_ptype

*ADD_DIM did=NON_did

*CLEAR_DESTINATION

*DESTINATION ACCOUNT="finalvalue"

*WHEN ACCOUNT

*IS "finalvalue"

*REC(EXPRESSION=%VALUE%,ACCOUNT="finalvalue",DATASRC="INPUT")

*ENDWHEN

*COMMIT

The above logic is not working .

Any inputs/suggestions on this will be helpful.

Thanks & Regards,

PSR