Fixed Assets Depreciation Split among different financial dimensions AX2009/AX2012

(0) Share

Report

Posted on by Fjorela

339

Dear all,

I am facing a request from the customer to split depreciation monthly expense among different financial dimensions combinations (they are allocating the monthly depreciation for some assets up to 60 different financial dimensions combinations). I have considered associating multiple value models (which means multiple acquisitions per fixed asset) but the challenge is that the allocation ratio is not fixed, but changing over time. Do you have any suggestion on how to proceed with such a request? (Customer has currently AX2009 but will change to AX2012 this year.)

Many thanks in advance

Fjorela

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (2)

Chandra Wijaya Seti... 1,145 on at

Like (0)

Report

Have you tried to use ledger allocation function instead

Regarding ratio is it based on other amount ?

Was this reply helpful? Yes No
Fjorela 339 on at

Like (0)

Report

Hi Chandra,

I thought about it but the allocation is not specific to ledger accounts but to specific assets..

The ratio is a % that changes once a year.

Thank you

Fjorela

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Fjorela,

Can you share some more details about the allocation that needs to be made?

Probably with a simplified example?

Best regards,

Ludwig

Was this reply helpful? Yes No
Fjorela 339 on at

Like (0)

Report

Hi Ludwig,

so the request is that the monthly depreciation should be split to n financial dimensions combinations. Please see screenshot below (with only to dimensions, but they have more dimensions):

Many thanks

Fjorela

Was this reply helpful? Yes No
Verified answer

Chandra Wijaya Seti... 1,145 on at

Like (0)

Report

Understand but i believe you can put criteria on allocation source to say range of ledger account and dimension as your source allocation.

Then create "dummy_source_allocation" dimension to flag the asset.

Then in the value model assign the dimension "dummy_source_allocation"

Reporting wise then you can extract from financial statement/management reporter etc as usual.

Was this reply helpful? Yes No
Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

Hi Fjorela,

I would not trying to do that with the allocation rules because there might be a lot of maintenance involved with that.

What you can do alternatively is

(a) Post all of your depreciations to a single financial dimension and then prepare the allocation postings in an excel template that you upload and post. That should be something that can be realized quickly.

(b) You can alternatively make use of the cost Accounting module where you can also upload allocation keys that you use for making those allocations. Yet, the disadvantage of doing that is that you will see the allocations only in the cost Accounting module and not in GL.

Best regards,

Ludwig

Was this reply helpful? Yes No
Fjorela 339 on at

Like (0)

Report

Thanks Chandra,

I like this idea :)

Have a nice day!

Fjorela

Was this reply helpful? Yes No
Fjorela 339 on at

Like (0)

Report

Hi Ludwig,

thanks a lot for your suggestions. Option A is also a good idea. I also excluded option B because of the fact that the postings are not done in GL.

Best regards

Fjorela

Was this reply helpful? Yes No