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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Depreciation
Microsoft Dynamics AX (Archived)

Depreciation

(0) ShareShare
ReportReport
Posted on by lally 8

Hi All ,

When it comes to FA opening balances , we need to populate the

FA Acquisition value ,

Accumulated depreciation

FA depreciation .

When it comes to FA Acquisition value , using FA journal, transaction type acquisition and offset it to error account / Opening balance account . This way basically i can upload the Acquisition

The same i can do for Depreciation also.

But i am not clear about the FA Accumulated depreciation .

Could any one explain in detail about the Opening of FA Accumulated depreciation value in AX 2012 ?

*This post is locked for comments

I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,072 Super User 2026 Season 1 on at

    Hi Lally,

    Usually I post the cumulated depreciation value in the asset journal.

    Note that it will change the Asset book values for remaining periods. So after the import of acquisition and depreciation you should review and correct the Asset book settings.

    Also check if you get correct values when you create a new depreciation journal after the import. You can run a depreciation proposal or use a report with these details.

  • lally Profile Picture
    lally 8 on at

    Thank you for the reply.

    [quote user="Andre Arnaud de Calavon"]Usually I post the cumulated depreciation value in the asset journal.[/quote]

    Still i am not clear about above sentence , because which transaction type i need to select in the FA journal ?

    What should the account type and account No ?

    What should be the offset account type and offset account number ?

    because as you know Accumulated deprecation amount should not post the FA acqusition account .

    Could explain in detail about this ?

    Thanks in advance.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,072 Super User 2026 Season 1 on at

    Hi Lally,

    I always dicussed these choices with the customer. Cumulative deprecation was usually posted with the transaction type depreciation. If the former system could provide information on revaluations or other posting types, it was possible to add it into the cumulative depreciation, or create new lines per transaction type.

    The account type and account no seems to be obvious. Asset and the asset numbers :-)

    The offset account should be discussed with the accountant.

  • lally Profile Picture
    lally 8 on at

    Thank for the reply Andre , now i am clear about the populating of Accumulated depreciation .

    [quote user="Andre Arnaud de Calavon"]Note that it will change the Asset book values for remaining periods. So after the import of acquisition and depreciation you should review and correct the Asset book settings.[/quote]

    But you mentioned in the above sentence that some field values would change , Could be mention those field names which i need to look in ?

    Thanks in advance.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,072 Super User 2026 Season 1 on at

    Hi Lally.

    You have to check at least the next listed fields: Acquisition date, Acquisition price, Depreciation run date, Date when depreciation was last run (awful field name), Depreciation periods remaining.

  • lally Profile Picture
    lally 8 on at

    Thank you Andre for the reply.

    Sorry to continue this post , but this would be last question in this post .

    Could please tell me the Fixed asset master data import , what are all the table needs to be consider ?

    How to populate the Depreciation run date and Date when depreciation was last run (awful field name), Depreciation periods remaining during upload of FA for Go-live ?

    Please share your experience.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,072 Super User 2026 Season 1 on at

    Hi Lally,

    For having a fixed asset master the tables AssetTable and AssetBook are the most important tables. We have had no requirements until now to use depreciation books, but this one might be needed depending on the business and fiscal requirements. The depreciation books was introduced as an US localization.

    Normally I use 4 steps in converting assets:

    1) Import Asset and Asset book

    2) Import and post acquisition values

    3) Import and post cumulative depreciation and other possible amount with other posting types (mostly only the depreciation).

    4) Import asset book values again to correct the touched fields by executing step 2 and 3. If the asset conversion is within a staging table you can write a job to correct the values.

  • lally Profile Picture
    lally 8 on at

    Thank you Andre for the reply,

    I could able to import the FA data using Using DIEF - Asset entity

    But when it comes to Asset Entity in DIEF is missing  some important fields  to upload the FA data .

    a) FA Name field

    b) Depreciation start date.

    Could you share me the whether these fields are available or not in the Asset Entity ? When i try to generate the file , at that time the above mentioned fields are not available.

    Thanks in advance.

  • Community Member Profile Picture
    Community Member on at

    If you have applied CU7, the DIEF allows you to create custom entities.  I have not worked with it, but maybe that would help you out (the fields the out-of-box Asset entity does not have).

    We didn't have CU7 yet, so I created my own FA import since the out-of-box DIEF entity version we had didn't do the job.   For example:

    1) There is no Expected Scrap Value in the DIEF entity, even though the entity does have fields for Value Model.

    2) Default Dimension for Value Model is not setup in the DIEF.  In the DIEF entity for Assets, in the Map Staging To Target form, there is a Target.AssetBook_DefaultDimension field but no lines map into it, and there is no DefaultDimension field in the staging table.

    3) DepreciationConvention is not in the FA template for AX, so isn't imported.  In the AX client, DepreciationConvention is defaulted from Asset Group.  However, during the DIEF import, it is not defaulted based on the Asset Group.

    FYI: I could send you my code and you could see what it does.  I would also answer any questions you have about it.  There is the typical proviso that the code is 'as is' and if you use it, you would be using it at your own risk.  But it's pretty straightforward (defaults values based on Asset Group, etc., then overwrites them if values were specified in the import source), so you should be able to see exactly what it would be doing.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,072 Super User 2026 Season 1 on at

    Hi Lallly,

    Within DIXF (new official abbreviation) for CU7 the Name is included. I do miss the depreciation start date as well, but you can add these in the staging table and map them by regenerating the mapping or link them manual.

    A bit weird is that the Name is visible within the Mapping details, but not within the Mapping visualisation.

    @Rick,

    The scrap value and the default dimensions are still missing in this release. II had to deal with other issues as well in the initial release of DMF.

    When you enable Run business validations and run business logic in insert or update methods in the entity structure you can have DIXF use the standard business logic in AX. Per field you can select to enable the validate field and/or modified field from the Mapping details.

    To have the table methods insert etc really executed, in the processing group you have to enable running the business logic as well.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Basit Profile Picture

Basit 1

#1
GL-01081504-0 Profile Picture

GL-01081504-0 1

#1
Roya Profile Picture

Roya 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans