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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Fixed asset automatic ...
Microsoft Dynamics AX (Archived)

Fixed asset automatic depreciation adjustment in sales journal

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Matloob Profile Picture
    Matloob 781 on at

    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

  • Community Member Profile Picture
    Community Member on at

    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.

  • Suggested answer
    Matloob Profile Picture
    Matloob 781 on at

    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

  • Matloob Profile Picture
    Matloob 781 on at

    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
  • Community Member Profile Picture
    Community Member on at

    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

    HI Violaine,

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

  • Community Member Profile Picture
    Community Member on at

    MS FIX 115031912535403

  • Community Member Profile Picture
    Community Member on at

    Could you please confirm the hotfix number?

    Thanks,

    Marton

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
TAHER_El_Mehdi Profile Picture

TAHER_El_Mehdi 3

#2
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#2
Mea_ Profile Picture

Mea_ 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans