Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Fixed asset migration ...
Microsoft Dynamics GP (Archived)

Fixed asset migration question

(0) ShareShare
ReportReport
Posted on by Mary Friedel 285
Hello, In my live environment I have balances in fixed asset expenses, depreciation expense, and accumulated depreciation accounts. These same assets are entered into the module in a test environment My question is when I move over the same fixed assets from the test environment to the live, wouldn't the GL in the live environment be affected? For example, if in the live environment I have the cost of a computer and the depreciation booked on the GL. In the test environment, I have the same computer on a card and ready for depreciation. How I can I transfer the fixed assets from the test environment to the live company while impacting the GL correctly? It would seem that if I'm adding the same asset already booked in the GL but using the FA module, it would in effect double the cost basis, depr, acc. depr balances? thank you

*This post is locked for comments

  • Mary Friedel Profile Picture
    Mary Friedel 285 on at
    Re: Re: Re: Re: Re: Re: Fixed asset migration question
    delete
  • Mary Friedel Profile Picture
    Mary Friedel 285 on at
    Re: Re: Re: Re: Re: Fixed asset migration question
    thanks!
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    Re: Re: Re: Re: Fixed asset migration question

    Correct, you delete the FATRXxxxxxxxx batch(es) in Transactions>Financial>Batches.

    To clear the depreciation data, you go Tools>Utilities>Fixed Assets>Clear Data and clear the 'Fixed Assets Financial Master' and 'Fixed Assets Financial Work' tables.  After you've cleared the data, run Reconcile on the Year.  Go Tools>Utilities>Fixed Assets>Reconcile and choose the appropriate year to reconcile.  This process resets summary financial information to reflect the changes resulting from the data you've cleared.

  • Mary Friedel Profile Picture
    Mary Friedel 285 on at
    Re: Re: Re: Fixed asset migration question
    I'd like to re-run depreciation again in the test environment. Under Tools > Utilities> Clear data, it gives you several files you can "remove" Which one of these files can I clear to clean the DEPR slate? Or should I not be messing with this function?
  • Mary Friedel Profile Picture
    Mary Friedel 285 on at
    Re: Re: Fixed asset migration question
    Hi Frank, I just ran depreciation and did the GL posting in our test environment. Where do I go to delete the batches created by GL posting? Transactions>Financial>Batches, correct? We're almost at the point where we can start migration to the live environment. Do you have any suggestions or common red flags? thanks !
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    Re: Re: Re: Re: Re: Fixed asset migration question

    You're quite welcome :)

  • Mary Friedel Profile Picture
    Mary Friedel 285 on at
    Re: Re: Re: Re: Fixed asset migration question
    thank you so much, Frank!
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,317 Super User 2025 Season 1 on at
    Re: Re: Re: Fixed asset migration question

    "My question is, because I've made manual changes to the book card, will these changes be reflected in the subledger balance once I transfer into the live environment?"

    Yes.  When making changes in the FA cards - General or Book - you're making changes to the subledger records.

  • Mary Friedel Profile Picture
    Mary Friedel 285 on at
    Re: Re: Fixed asset migration question
    Hello, Thank you for your valuable insights! Our GL balances relating to fixed assets were all calculated outside of the module. I'm going through the painstaking process of tieing everything back to the GL. I've encountered a few errors so we're going to have to make an adjustment. Do you recommend making the adjustment after everything is transfered into the live environment or before the transfer? I also have another question. A few of our assets were accelerated based on rental leases. To reflect this changes, I had to manually go into the asset book cards and change YTD/LTD depreciation and then change the original life(15yrs) to the accelerated value. The place in service date is 10/1/2009 and the depreciated date was manually changed to 12/31/2009 to reflect the changes. When I project depreciation for Jan '10 the rate is correct and ties to the GL. My question is, because I've made manual changes to the book card, will these changes be reflected in the subledger balance once I transfer into the live environment?
  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Fixed asset migration question

    Mfriedel,

    Have you tested depreciation in your test environment to be sure the numbers generated will tie to your GL after you follow Frank's suggestion? You may need to make some slight adjustments if the GL balances were calculated outside of 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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans