Distribute Planned depreciation for future assets based on purchase date

[Former Member]

Hi

Following is my CAPEX model which has the following dimensions.

1.Asset (AST01,AST02 - Property with purchase date 2015.04 for AST01 & 2015.07 for AST02)

2.Account (600600, Asset_Qty, Asset_DepRate, Asset_Price)

3.Category (101)

4.Entity (Cost Center 1010)

5.Time (2015.01......2015.12 & 2015.ANL)

6.Currency (LC)

Following are the input forms as below

1. Depreciation rate maintained as 20% for AST01 & AST02 against the time dimension 2015.ANL

2. Price maintained as 25000 for AST01 & 50000 for AST02 against the time dimension 2015.ANL

3. Quantity maintained as 1 each for AST01 & AST02 against the time dimension 2015.ANL

4. Execute a script logic as below to get planned depreciation amount for the year. The value calculated correctly as 5000 & 10000 for 2015.

*XDIM_MEMBERSET CATEGORY=101

[ACCOUNT].[#600610]=[ACCOUNT].[A_RATE]*[ACCOUNT].[A_QTY]*[ACCOUNT].[A_DR].

5. Execute a allocation script logic to spread across 12 months. This is happening perfect.

*XDIM_MEMBERSET ACCOUNT=600610

*XDIM_MEMBERSET CATEGORY=101

*RUNALLOCATION

*FACTOR=1/12

*DIM TIME WHAT=2015.ANL; WHERE=BAS(2015.TOTAL)

*ENDALLOCATION

REQUIREMENT:

The above are well when the assets are procured on Jan 2015, but in case the assets are planned for procurement as above say AST01 2015.04 and AST02 2015.07, how can i calculate the planned depreciation amount based on the procurement month. I have given a purchase month property in the asset dimension but not able to proceed from here on.

I request the experts to suggest for a solution.

Thanks

Saravanan

[Former Member]

Hi Vadim

Thanks for the reply, let me try to get it done as per your suggestion.

Saravanan

[former_member186338]

Hi Saravanan,

Write a custom logic badi! Trying to achieve your requirements with script logic is a waste of time...

Vadim