Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

Fixed asset automatic depreciation adjustment in sales journal

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello, 

I have an issue with the setup of the depreciation adjustment account in FA module.

When we do a FA sales, in the middle of the month, AX calculate the depreciation adjustment and create a new line the journal during the posting: with credit = FA account and Offset account = expense account for depreciation. But the offset account in the journal is posted with the amount in the credit instead of in the debit. 

Does anyone have this issue? 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed asset automatic depreciation adjustment in sales journal

    Could you please confirm the hotfix number?

    Thanks,

    Marton

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed asset automatic depreciation adjustment in sales journal

    MS FIX 115031912535403

  • Matloob Profile Picture
    Matloob 781 on at
    RE: Fixed asset automatic depreciation adjustment in sales journal

    HI Violaine,

    Thanks for an update, can you please also share hotfix number you have applied for this ?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed asset automatic depreciation adjustment in sales journal

    Hello,

    Thank you for your help. But we have raise the issue to Microsoft. There is a MSFIX to fix the issue.

  • Matloob Profile Picture
    Matloob 781 on at
    RE: Fixed asset automatic depreciation adjustment in sales journal

    Source of the posting profile column did not paste correctly in my last answer, please check the following;

    Ledger account Currency Amount Source of the posting profile
    801100-001--- USD 80,000,000.00 FA posting profile- Disposal  sale (offset account)
    801100-001--- USD -80,000,000.00 FA posting profile- Disposal  sale (main account)
    801100-001--- USD 1,554,432.06 FA Posting profile - Disposal tab from upper left-Net book value (main account)
    801100-001--- USD -1,554,432.06 FA Posting profile - Disposal tab from upper left-Net book value (offset account)
    801100-001--- USD 2,000,000.00 FA Posting profile - Disposal tab from upper left-Acquisition prior years (offset account)
    801100-001--- USD -239,999.96 FA Posting profile - Disposal tab from upper left-Depreciation prior years (offset account)
    180200-001- USD 239,999.96 FA Posting profile - Disposal tab from upper left-Depreciation prior years (main account)
    180200-001- USD 64,768.02 FA Posting profile - Disposal tab from upper left-Depreciation adjustment this year (main account)
    180200-001- USD 140,799.96 FA Posting profile - Disposal tab from upper left-Depreciation adjustment this year (main account)
    607200-001--- USD -64,768.02 FA posting profile- Depreciation adjustment (offset account)
    607200-001--- USD -140,799.96 FA posting profile- Depreciation adjustment (offset account)
    180100-001- USD -2,000,000.00 FA Posting profile - Disposal tab from upper left-Acquisition prior years (main account)
    Disposal sale amount        80,000,000.00
    Net book value at the time of disposal          1,554,432.06
    Acquisition prior years (Original acquisition)          2,000,000.00
    Depreciation prior years              239,999.96
    Automatic depreciation adjustment (posted at the time of disposal) 64,768.02
    Automatic depreciation adjustment (posted at the time of disposal)              140,799.96
  • Suggested answer
    Matloob Profile Picture
    Matloob 781 on at
    RE: Fixed asset automatic depreciation adjustment in sales journal

    Please check GL accounts you have defined in FA posting profiles in depreciation adjustment of FA posting profile ?

    If you have multiple posting layers, only check voucher for one layer, in my example i have taken current layer transaction.

    I have tested your scenario in standard environment with contosso data set, have a look at my workings and also check the source from where system is pulling GL accounts to post, compare it with your environment.

    Date Year closed Ledger account Currency Amount Source of the posting profile Posting layer
    11-11-14 No 801100-001--- USD 80,000,000.00 FA posting profile- Disposal  sale (offset account) Current
    11-11-14 No 801100-001--- USD -80,000,000.00 FA posting profile- Disposal  sale (main account) Current
    11-11-14 No 801100-001--- USD 1,554,432.06 FA Posting profile - Disposal tab from upper left-Net book value (main account) Current
    11-11-14 No 801100-001--- USD -1,554,432.06 FA Posting profile - Disposal tab from upper left-Net book value (offset account) Current
    11-11-14 No 801100-001--- USD 2,000,000.00 FA Posting profile - Disposal tab from upper left-Acquisition prior years (offset account) Current
    11-11-14 No 801100-001--- USD -239,999.96 FA Posting profile - Disposal tab from upper left-Depreciation prior years (offset account) Current
    11-11-14 No 180200-001- USD 239,999.96 FA Posting profile - Disposal tab from upper left-Depreciation prior years (main account) Current
    11-11-14 No 180200-001- USD 64,768.02 FA Posting profile - Disposal tab from upper left-Depreciation adjustment this year (main account) Current
    11-11-14 No 180200-001- USD 140,799.96 FA Posting profile - Disposal tab from upper left-Depreciation adjustment this year (main account) Current
    11-11-14 No 607200-001--- USD -64,768.02 FA posting profile- Depreciation adjustment (offset account) Current
    11-11-14 No 607200-001--- USD -140,799.96 FA posting profile- Depreciation adjustment (offset account) Current
    11-11-14 No 180100-001- USD -2,000,000.00 FA Posting profile - Disposal tab from upper left-Acquisition prior years (main account) Current
    Disposal sale amount        80,000,000.00
    Net book value at the time of disposal          1,554,432.06
    Acquisition prior years (Original acquisition)          2,000,000.00
    Depreciation prior years              239,999.96
    Automatic depreciation adjustment (posted at the time of disposal) 64,768.02
    Automatic depreciation adjustment (posted at the time of disposal)              140,799.96

    Regards

    Mohammad Matloob

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Fixed asset automatic depreciation adjustment in sales journal

    Hi,

    So I have a FA acquired in a previous years, all depreciation done until the last period (for example 30/10). In November, the 10/11, I want to sale the FA. So I do a fixed assets journal with disposal-sale transaction type and put the sale price.

    When I post the journal, AX calculate automatically a depreciation adjustment for the 10 days of November (parameter Automatically create depreciation adjustment amounts with disposal ticked). In the journal view, the credit = FA account and the debit = depreciation (expense type) account and that is OK

    But in the voucher, the accounting has been reversed.

  • Matloob Profile Picture
    Matloob 781 on at
    RE: Fixed asset automatic depreciation adjustment in sales journal

    Hi Violaine,

    Please explain in little bit more detail, are you posting FA disposal journal or depreciation journal where you are getting one extra line created by the system ?

    Regards

    Mohammad Matloob

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans