Open Forum

Expand all | Collapse all

GP Fixed Asset Module to Sage Fixed Asset System

  • 1.  GP Fixed Asset Module to Sage Fixed Asset System

    Posted Mar 18, 2020 03:02 PM

    In the next few weeks, we are going to be moving from using the Dynamics GP fixed asset module to tracking our fixed assets in the Sage Fixed Asset System. We are in the middle of planning and creating a template for exporting data out of Dynamics GP and importing the information into the Sage Fixed Asset System.

    I'm wondering if anyone has had experiencing doing this going from Dynamics GP to Sage for the fixed asset software. Any tips, tricks or insight would be helpful for us as we planned out this transition. In particular, how data was extracted out of Dynamics GP and imported into Sage.

    For a bit of background: We currently have over 2,000 fixed assets in Dynamics GP. For each of the assets, there are five books setup (Internal - GAAP, Federal, Federal AMT, State, and State AMT).

    Thanks for your help and time!

    Brittany Malueg
    Milk Source LLC
    Kaukauna WI
    Academy - Online Interactive Learning from Experts

  • 2.  RE: GP Fixed Asset Module to Sage Fixed Asset System

    Posted Mar 19, 2020 10:31 AM
    I'd be interested in hearing more about your process, as we're looking at doing the exact opposite: consolidating our Sage into GP.

    Unfortunately, we never used GP for fixed assets so I can't give you any tips on transitioning.

    Blair Christensen
    Database Administrator
    Oppenheimer Companies, Inc.
    Boise Idaho GPUG Chapter Leader

    Academy - Online Interactive Learning from Experts

  • 3.  RE: GP Fixed Asset Module to Sage Fixed Asset System

    Posted Mar 19, 2020 10:44 AM
    This is an interesting question and I'd like to hear the arguments of both sides, why you would switch from one ERP system for the FA only..
    The benefits of having everything in GP is obvious, with the financials integration and everything else, and I know for the fact that the FA module in GP is not the most strong and flexible tool, as I had to implement it in our previous company.. I must confess that our company might not have been using asset depreciation's the proper way (because of internal accounting rules), but I recall that it was a little clunky for us.
    It was nonetheless doing the job and we could integrate the POP with FA so when new assets were received, they could be created directly in the system.
    Would love to hear what are the benefits of using Sage as a separate tool for managing FA's..

    Beat Bucher
    Business Analyst, Dynamics GP SME
    Montreal QC/Canada
    Montreal QC GPUG Chapter Leader
    MBS MVP (2015-2018)
    All-Star 2013

    Academy - Online Interactive Learning from Experts

  • 4.  RE: GP Fixed Asset Module to Sage Fixed Asset System

    Posted Mar 19, 2020 05:41 PM

    Hi @Brittany Malueg
    We went the opposite way (from Sage to GP) & from what I recall...

    The book setups are drastically different between the 2 systems (GP has many more options that factor into the depreciation calculation). I have my opinions on which one makes more sense but the point is that they're different.

    I'd recommend spending extra time on the conversions from the book setups in GP to the depreciation mode setups in Sage
    -------- (ie.) Mid-Month 1st, Striaight-Line Cutover, 5 years = {X} Depreciation Option in Sage).

    I'd suggest importing what you think is correct into Sage & then running project in both systems to see how they compare.

    At the end of our conversion, the depreciation numbers really never tied out but they were close enough to just live with.


    Other notes

    - Reconcile all books (Cost, AD, YTD)

    - Run depreciation projections and compare for all books

    - Clean-up your asset listings in GP BEFORE migrating to Sage

    - Make sure your asset listing in GP actually ties to the G/L before you move over to Sage. We had tons of "Off the books" adjustments that accountants were making that no one was aware of until we didn't tie in the new system.

    - Consider if you can eliminate books before the migration

    - If you're cutting over mid-year, consider what you're going to do w/ YTD retirements transfers, etc. (we decided to hack together our year 1 report instead of bring all of those transactions over into GP).

    Happy to provide any insights / kick ideas around, just let me know. Good luck!

    Kyle Malone, CPA
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger -
    Chapter Leader - Louisiana (New Orleans)
    Solugence | Find the software that FITS your business + integrates with GP. Find Software Smarter.

    Academy - Online Interactive Learning from Experts

  • 5.  RE: GP Fixed Asset Module to Sage Fixed Asset System

    Posted Mar 20, 2020 12:33 AM
    I can understand the move toward another (or any ) fixed asset system, particularly one that is a best-in-class system for that purpose. GP is bordering on insane or genius, requiring you to employ a Nobel laurate in mathematics or a criminally insane person to predict depreciation in even the simplest scenarios.   God forbid a user make a mistake that needs reversing or use a 4-4-5  calendar or 13th period.

    I am sorry that I am not much help here but I would love to attend a Summit session you lead on the topic when you are finished.  I may even buy the book.

    Jeff Frye
    Systems Analyst
    Hunt Brothers Pizza, LLC
    Nashville TN

    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role