Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Jayna Friend]

Good morning!

We are currently on GP 2010 (in process of upgrading to GP 2015 – but, that’s another story), and have had an issue with our Fixed Assets doubling the depreciation amount for December. 

History:

• Ran December Depreciation
• Noticed amount was depreciation was doubled on each asset.
• Contacted support vendor and was told there was no way to mass reverse depreciation for all assets in GP 2010.  Support Vendor also reached out to Microsoft to see if there was a script that could be run; but, Microsoft said no because GP 2010 is no longer supported.
• Staff individually reversed almost 8000 assets. 
• Once reversals were done, I tried to depreciate 1 asset, and it still doubled. 

I’ve checked set-up, and it all looks the same.  We’ve made no changes to depreciation method, etc.  I also changed the system date back to 12/31/2017 to see if that would correct the issue, and it still doubled the depreciation.

Does anyone have any suggestions on what else to try?

Thanks!

——————————
Jayna Friend
Director of Finance
Riverview Health
Noblesville IN
——————————

[Shawn Dorward]

By any chance was the depreciation NOT booked for November?

——————————
Shawn Dorward
Implementation Consultant
Microsoft MVP, Business Solutions
Twitter: @ShawnMDorward
InterDyn Artis
Blog: http://www.GPLifeHacks.com
——————————
——————————————-

[Jayna Friend]

No.  It was booked in November, and was correct.

——————————
Jayna Friend
Director of Finance
Riverview Health
Noblesville IN
——————————
——————————————-

[Shawn Dorward]

Ok, thanks – does the book value for depreciated to date match the correct amount (YTD November) or does it need to be recalculated? 

As a tip, you can use the projection function rather than depreciate so you don’t have to manually fix things if it still doubles up.

——————————
Shawn Dorward
Implementation Consultant
Microsoft MVP, Business Solutions
Twitter: @ShawnMDorward
InterDyn Artis
Blog: http://www.GPLifeHacks.com
——————————
——————————————-

[Jayna Friend]

Book value matches YTD November depreciation.  So, we are good there.

Thanks for the tip on using Projection.

——————————
Jayna Friend
Director of Finance
Riverview Health
Noblesville IN
——————————
——————————————-

[Kerry Hataley]

Can you provide a screen shot of the following:
1. An asset/book card of one of the assets that is producing the double amount
2. The FA GL inquiry for that asset (Inquiry>>Fixed Assets>>Financial Detail) with the doubled entry

Thanks

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Jayna Friend]

——————————
Jayna Friend
Director of Finance
Riverview Health
Noblesville IN
——————————
——————————————-

[Shawn Dorward]

Looks like you may just have to trigger the recalculation (mentioned earlier) – the current depreciation amount is wrong, which is why it’s posting ‘double’.

——————————
Shawn Dorward
Implementation Consultant
Microsoft MVP, Business Solutions
Twitter: @ShawnMDorward
InterDyn Artis
Blog: http://www.GPLifeHacks.com
——————————
——————————————-

[Kerry Hataley]

So what I see from the info provided is:

1. The YTD amount is now correct – so where did it go wrong through the year;
2. The LTD is over depreciated by 1 month;

I am with Shawn, you need to post this corrections through, note no Batch for then correction then run the trigger to recalculate the YTD and LTD amount.
ALWAY try in test system first!

Kerry

——————————
Kerry Hataley
CEO & President
Nanook Software, Inc
——————————
——————————————-

[Barbara Gavron]

I typically check 2 things when the FA depreciation is not what I think it should be:

• FA Calendar – the # culprit
• The averaging convention

Do you by any chance have 13 periods set up? This could cause the problem if period 12 ends on 12/31/17 and then period 13 is 12/31/17 only.

Let us know if you find the answer.

 

?

——————————
Barbara Gavron
Atlantic Beach / Jacksonville FL
904-536-0129
——————————
——————————————-