Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Importing Fixed Assets already recorded in general ledger

Posted on by Microsoft Employee

Background:

My company has a holding company setup only to hold the fixed assets of the company. In previous years, the fixed assets were tracked in excel, and a manual JE was performed at the end of each year to record depreciation/amortization on the holding company's GL. I am getting ready to switch the company over to using the Fixed Asset Management module so we no longer need to track the fixed assets via excel and manually record the depreciation/amortization. Please note that I have thoroughly read through the Microsoft GP Fixed Assets Management manual, read through multiple community discussions on this module, and have a TEST company within GP that I have successfully uploaded the fixed asset data into already. 

Question 1:

I want to import all of the fixed asset data (including Cost Basis and LTD Depreciation Amount) into GP (in order to have a full list of the assets) but NOT into the GL (as the assets and related depreciation/amortization were already manually recorded for prior years). However, going forward (let's assume beginning on 7/1/17), I want to be able to depreciate those assets (as well as add any new assets entered through the Purchasing module beginning on 7/1/17) via the "Depreciate" and "GL Posting" Fixed Assets Routines. Is there an easy way to do this?

My initial thoughts were to import everything with the "Post to General Ledger" option UNCHECKED in the Book Setup option and then re-CHECK the "Post to General Ledger" option after everything imported, but that does not seem to work. I then thought about adding all the old assets to a different Book ID with the Post to General LEdger option UNCHECKED, while all the new assets get assigned to a different Book ID with the Post to General Ledger option CHECKED...but I still need the old assets to continue to depreciate.

Any help would be much appreciated! Thanks in advance,

Josh Ruf, CPA

Controller

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Importing Fixed Assets already recorded in general ledger

    Josh,

    I believe you could simply delete the batch that the GL/FA interface transaction creates and you should be good to go. I do not think you have a Post To/Through option for transactions originating in the Fixed Assets module.

    Kind regards,

    Leslie

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans