Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Wrong Depreciation

(0) ShareShare
ReportReport
Posted on by 5,201

hi,

i run the depreciation for fixex asset for december 2014 after i closed the year . now the huge value is coming for december 2014.  i need your support to revert it back  

*This post is locked for comments

  • Verified answer
    Refeesh Ali Profile Picture
    5,201 on at
    RE: Wrong Depreciation

    i resolved the issue for 10000 items using the below steps

    > change period from 2015 to 2014 (Tools=>setup=>fixed asset =>book)

    >Revise the December depreciation using "depreciate with one asset" by macros.

    change Gp date to november 30 and use the same  date for reversing.

    >calculated 2014 YTD depreciation and applied that amount in Asset Book using macros

    >run the depreciate all asset for december (Routines=>Fixed asset=>depreciate)

    >Run GL Posting entries (Routines=>Fixed asset=>GL posting)

    > change period from 2014 to 2015 (Routines=>Fixed asset=>Year end)

    >run the depreciate all asset for January(Routines=>Fixed asset=>depreciate)

    >Run GL Posting entries (Routines=>Fixed asset=>GL posting)

    if anybody needed the macros. please let me know. thanks for support

  • Suggested answer
    Refeesh Ali Profile Picture
    5,201 on at
    RE: Wrong Depreciation

    i resolved the issue for 10000 items using the below steps

    > change period from 2015 to 2014 (Tools=>setup=>fixed asset =>book)

    >Revise the December depreciation using "depreciate with one asset" by macros.

    change Gp date to november 30 and use the same  date for reversing.

    >calculated 2014 YTD depreciation and applied that amount in Asset Book using macros

    >run the depreciate all asset for december (Routines=>Fixed asset=>depreciate)

    >Run GL Posting entries (Routines=>Fixed asset=>GL posting)

    > change period from 2014 to 2015 (Routines=>Fixed asset=>Year end)

    >run the depreciate all asset for January(Routines=>Fixed asset=>depreciate)

    >Run GL Posting entries (Routines=>Fixed asset=>GL posting)

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Wrong Depreciation

    Refeesh, there just too many variables to be able to work through this issue with you on the Forum.  You need to have someone knowledgeable who can at the very least remote in to your system to look at the setups and the depreciation details.

  • Refeesh Ali Profile Picture
    5,201 on at
    RE: Wrong Depreciation

    Please somebody help me. Very urgent for me.

  • Refeesh Ali Profile Picture
    5,201 on at
    RE: Wrong Depreciation

    when it is running again december after backout the old transaction the whole year amount is calculating, please advice is there any setup changes

  • Refeesh Ali Profile Picture
    5,201 on at
    RE: Wrong Depreciation

    hi

    actually it was backed out and worked fine using depreciate one asset. but when i am rerunning the same for December again the data is double, yesterday when i test it was good but today i am not getting result. do you have any idea

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Wrong Depreciation

    Do you mean you're running the Post to GL Routine and no batch is created?  I saw your post on the other thread about wanting the script to reverse depreciation.  You'll need to get that through your GP Partner.  If you don't have one and have access to Customer Source, you could enter a support case to Microsoft and request the script.

  • Refeesh Ali Profile Picture
    5,201 on at
    RE: Wrong Depreciation

    I am Trying the first method to reverse depreciation one asset at a time, its fine working in the module side. But no GL entry is getting posted. Please help me

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    46,527 Super User 2025 Season 1 on at
    RE: Wrong Depreciation

    Refeesh, after you restore from backup, let's try something else.  I just ran across an old blog post by Mark Polino stating you can get a script from Microsoft support that will reverse depreciation - mpolino.com/.../weekly-review-undo-depreciation.  That would be the preferred method to reverse the depreciation for you.

  • Refeesh Ali Profile Picture
    5,201 on at
    RE: Wrong Depreciation

    delete FA00902 where DEPRTODATE = ’12/31/2014' is it okay or any other table shall I remove

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans