Fixed Asset Depreciation for 4-4-5 Calendar

(0) Share

Report

Posted on by ZvikaR

168

I am trying to set up fixed asset depreciation in a company that uses 4-4-5 fiscal calendar (each quarter has 3 fiscal periods, 4 weeks, 4 week, and 5 weeks, and so forth)
I am using AX 2013 R3.

I set up the depreciation profile for Straight Line Service Life, and frequency of Fiscal Calendar/Fiscal Period.

when I go to depreciate the asset, AX correctly recognizes the fiscal calendar, and the creates depreciation proposal line correctly on the last day of each fiscal period as the posting date.

However, I expected AX to depreciate more (5/13) on the 5 week periods, and depreciate less (4/13) on the 4 week periods. Instead, all my depreciation amounts are exactly 1/12 from the annual depreciation amount.

How can I get AX to take into account the period length when proposing depreciation amount?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

G-Squared 244 on at

Like (0)

Report

I have a similar need. How did this issue get resolved? Did you try a different calendar and 52 periods per year rather than 12 periods per year for depreciation?

Was this reply helpful? Yes No
Suggested answer

ZvikaR 168 on at

Like (0)

Report

the best solution I could find so far is create a different calendar with 52 weeks, post the depreciation with "summary" setting so it totals either 4 weeks or 5 weeks depending on the period.

That's a bit manual since it forces the user to manually enter the period end date exactly.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Have you tried using a manual Depreciation method like below? Set your intervals as a percentage (4/52, 4/52, 5/52, etc.) it might work for you.

Was this reply helpful? Yes No
ZvikaR 168 on at

Like (0)

Report

yes, I looked at manual, but since the % is 5/52 and 4/52 it would mean I would get uneven amounts due to rounding.

I am considering it as a last resort.

Was this reply helpful? Yes No