web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    Transactions in the FA module only impact the GL via batch creation through the GL Posting Routine in FA.  After you've imported your assets, go ahead and run depreciation on the assets through your desired ending period.  Then run the GL Posting Routine.  Delete any batch(es) created by this process.

    This will create the asset and depreciation balances in your FA subledger but not affect the GL.

  • L Vail Profile Picture
    L Vail 65,271 on at

    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

  • Mary Friedel Profile Picture
    Mary Friedel 285 on at
    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?
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    "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
    thank you so much, Frank!
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    You're quite welcome :)

  • Mary Friedel Profile Picture
    Mary Friedel 285 on at
    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 !
  • Mary Friedel Profile Picture
    Mary Friedel 285 on at
    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?
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

    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
    thanks!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans