TM1 Forum

I have a 2 step process to record depreciation.
Step 1 ['Depreciation_','Plan'] = N: calcuates depreciation & it's fed.
Step 2 ['Depreciation Dollar','Plan'] -> the amount is pulled from step 1 & it is sent to a coa attribute(depreciation GL accounts). The amount is posted but it's not fed properly.

Any advice why my feeder statement is not correct. Thank you.

SKIPCHECK;
##Step 1##
['Depreciation_','Plan'] = N:
IF(dimix('year', !year) > dimix('year', '2014') & attrs('coa', !coa, 'DEPRECIATE') @= 'Y' & ['Dollar','Plan'] <> 0 & ['Depreciation Years','Plan','M0'] <> 0,
(['Dollar','Plan'] / ['Depreciation Years','Plan','M0'])/2,stet);

##Step 2##
['Depreciation Dollar','Plan'] = DB('CAP_INPUT',!campus,!loc,attrs('coa',!coa,'Contra_Depreciation'),!cap_line_items,!cap_type,'Plan',!year,!months,'Depreciation_');

feeders;
['Dollar','Plan'] => ['Depreciation_','Plan'];
['Depreciation_','Plan'] => ['Depreciation Dollar','Plan'];

RLReyes wrote:Any advice why my feeder statement is not correct.

Maybe because you haven't told TM1 which account the depreciation amounts are posted to in the feeder???? This is the problem with "moving" or "allocating" amounts based on an attribute. How do you feed only those accounts that should have received the allocation? This is an example of a case where you need to write a conditional feeder, where you compare the dimension element in the account dimension with the account attribute from Cap Ex cube and feed if they match and don't if there is no match.

tomok wrote:This is an example of a case where you need to write a conditional feeder.

Thanks Tomok...I got it to work using a conditional feeder.