Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Fixed Asset Cost Basis...

Fixed Asset Cost Basis Change and Depreciation for Multiple Books

(0) Share

Report

Posted on by Community Member

We have been tasked with having multiple fixed asset books within GP. Two of those books are GAAP and Tax. It is common process for us to update the cost basis of an asset as we are adding costs to make the asset ready for the customer. Today we have a macro that runs to update the value of the asset as well as change the date to the current month we are closing. Then we recalculate based on the new cost.

We will now have to make sure that the cost basis matches on both of the books (there will be 3 in total). Is there a way (either through a better way or an add-on) that we can update a mass amount of assets at once in all of the books and also do the recalculation? Today our macro runs overnight and then if it crashes we have to start over. It is very time consuming (we have over 30,000 assets).

Thanks for your help!

Tori

*This post is locked for comments

All responses (2)

Answers (0)

Mike Bufano 1,482 on at

Like (0)

Report

RE: Fixed Asset Cost Basis Change and Depreciation for Multiple Books

How many assets are in your overnight macro? Is it all your assets?

Why does your cost basis change so often?
Heather Roggeveen 9,144 on at

Like (0)

Report

RE: Fixed Asset Cost Basis Change and Depreciation for Multiple Books

Hi Tori

I would have said a macro - but I see the issue with so many. I don't know of another way in the interface. I would be interested to know if you find out a better way.

Good luck.

Heather