Skip to Content
0
Former Member
May 31, 2011 at 01:22 PM

Script Logic

40 Views

Hello Gurus,

I am relatively new to BPC and am trying to create a script logic file to calculate the depreciation amount. The related dimensions are u2018Accountu2019 and u2018AssetClassu2019. The members are Equipment1 (for the asset) and Depreciation (for the Depreciation Account).

During the depreciation calculation, I want the system to u2018readu2019 and u2018getu2019 the value of the u2018Lifeu2019 of the asset from the dimension u2018AssetClassu2019 and use that in the *REC () statement. I understand that the NW version does not support the GET() statement, so I tried the following logic. However, the value of the depreciation calculated by the system from the logic below returns all zeroes. Could you please take a look at the logic and let me know what is wrong with it?

*XDIM_MEMBERSET CATEGORY = BUDGET

*XDIM_MEMBERSET ENTITY = STORE1

*XDIM_MEMBERSET RPTCURRENCY = LC

*WHEN ACCOUNT.GROUP

*IS ASSETS

*REC(EXPRESSION=(%VALUE%/[ASSETCLASS].[EQUIPMENT].LIFE),ACCOUNT=Depreciation)

*ENDWHEN

*COMMIT

Any guidance is greatly appreciated.