web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Fixed Asset Calendar

(0) ShareShare
ReportReport
Posted on by

Hi everyone,

Our company is starting a new dynamics ax 2012R3 implementation. Since a lot of assets (fixed asset) were originally acquired long time ago (say since 1996-now), we uploaded the assets with acquisition date = original purchase date. the problem is when we try to post the acquisition (and/or the depreciation), ax says that the current calendar period (eg. 1996) is not open. we already create 2 fiscal calendar, one for Ledger (only 2014 periods) and one for Fixed Asset (open from 1996 to 2014). The value models are pointing to the Fixed Asset Calendar, buat everytime we try to post acquisition/depreciation with date before 2014, ax says error because the ledger calendar (not the fixed asset calendar) period is not open.

so the question is how to post transaction for assets with date prior to 2014 ?

thanks ! 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,075 Super User 2025 Season 2 on at

    Hi Chris,

    The next procedure is the one I usually follow:

    First of all you need to have the fixed assets in the system. Perhaps you can import these with help of the Data Import/Export Framework. Also you can use this tool to import jounals which will be described below.

    You need to decide the conversion date. If the conversion date is at the beginning of a fiscal year the procedure is easier than when you do the conversion during a fiscal year. The assest of last year and before will always be done in the two steps below:

    1 Acquision value assets last year and before

    You can post the acquisition value of the assets by using a fixed asset memo on the end of the old fiscal year. Think about the offset ledger account. We mostly use a special account for opening balances. E.g. when you start using AX per 1-1-2015, the date for this journal will be 12/31/2014.

    2 Depreciation value assets last year and before

    Then you can post the depreciation value in a new fixed asset memo at the end of the old fiscal year. Think about the offset ledger account. This will be on the same date as the acquition journal.

    If you have a conversion during the year and completed the previous steps, you can do the next steps:

    3 Acquision value assets current year

    You can post the acquisition value of the assets by using a fixed asset memo on the real historical date or the date before the conversion.

    4 Depreciation value assets current year

    Then you can post the depreciation value in a new fixed asset memo on the real historical date or the date before the conversion. This memo will also contain the older assest with the value of depreciation in the currrent fiscal year.

    In these steps think about the offset ledger account again. You can either use the normal offset account or the opening account.

    After you completed these steps print some reports and check all values. Normally you will have your net-book value and all assets know what values are for acquisition and depreciation both for this year and older years

    But the last thing you have to do is check all value models of your assets. When posting the acquisition and depreciation memo's the fields like depreciation start date en remaining periods for depreciation are affected!! Set the correct values.

    The remaining periods will determine the future depreciations.

  • Community Member Profile Picture
    on at

    Hi Andre,

    thank you for the FAST response, your post is very helpful and informative !

    my question now is since, lets say, we start using AX per 1/1/2015, and as your suggestion to post all previous year asset's acquisition (and depreciation as well) per 12/31/2014,  it means that we need to have period 12/31/2014 on fiscal calendar open, am i right ? since we set the fiscal calendar only for 1/1/2015 onwards.

    thanks !

  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,075 Super User 2025 Season 2 on at

    Hi Chris,

    Yes you need to have the period for 12/31/2014 open then. The advantage is that the last depreciation date is filled with this date.

    Note that you need to run the 'Opening balances' job to have the amounts transferred to the opening balance for 2015.

  • Community Member Profile Picture
    on at

    Hi Andre,

    your answer fits my question perfectly.

    in summary, my mistake is to take the historical date of asset transaction to acquisition and depreciation posting date resulting in an error while ax is trying to find open period for that dates.

    so the work around is to post the previous years transaction as date 12/31/2014 (open the period first) and then transfer the balances to curent year 1/1/2015 via Opening Balances job.

    problem solved.

    thank you Andre :)

  • Community Member Profile Picture
    on at

    Hi Andre,

    Sorry for reopening the case after long time.

    We have a similar situation to upload the FA balances where assets acquired in 2000 is also there. 

    Asset Group Asset ID Service Date Original Cost Closing Bal. Closing Depr. NBV. OP NBV. CL
    BUILDING BL00001-1 01-Sep-2000 1980404.193 1950904.193 1065213.816 934462.982 885690.377

    The above assets life is 30 years.

    We started LIVE entries on 01/10/2016. The closing balance and closing depreciation is as on 30/09/2016. 

    1. As per you earlier blog, should I upload only the closing balance and closing depreciation as on 30/09/2016 only? Then how can I show the original cost and the original purchase dates?

    2. Should I upload the original cost and closing depreciation as on 30/09/2016?

    Still I am unclear, kindly advise.

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans