Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Export or other access...
Finance | Project Operations, Human Resources, ...
Answered

Export or other access to old Dynamics GP 9.0 system

(1) ShareShare
ReportReport
Posted on by Jason__B 5

We have an old Dynamics GP system from a company that we purchased.  It is Dynamics GP 9.0 on Windows Server 2008 32 bit/SQL 2008 R2.  We use a different system for our primary accounting system.  Accounting needs access to this system maybe once a year.  We need to get this off of Win/SQL 2008 but we don't have maintenance, and aren't interested in doing upgrades since it is used so rarely.  Are there any companies/products that export the data into PDFs or Excel or something similar to be accessed without having to have GP installed?

Categories:
Microsoft Dynamics GP
  • Jason__B Profile Picture
    Jason__B 5 on at
    RE: Export or other access to old Dynamics GP 9.0 system

    Thanks for the great feedback everyone!

  • Verified answer
    Justin Sutton Profile Picture
    Justin Sutton on at
    RE: Export or other access to old Dynamics GP 9.0 system

    Hello Jason,

    Richard, as usual, is correct.

    There are other options like SSRS, Refreshable Excel Reports, or simple SQL Views.

    It basically comes down to what kind of data you need to get every year, and how much data it is.

    My usual recommendation for gathering data is to use Excel Reports to pull in SQL view data. This is usually the best way for most users to get data.

    I actually am in the middle of writing an article to go more in depth on this, but in the meantime there is a good article outlining how to connect to SQL database in Azure. The steps are mostly similar when connecting to a normal SQL Server. 

    https://docs.microsoft.com/en-us/azure/azure-sql/database/connect-excel

    Keep an eye on the Support and Services blog if you want to see what I release sometime this month:

    https://community.dynamics.com/gp/b/dynamicsgp

  • Suggested answer
    Almas Mahfooz Profile Picture
    Almas Mahfooz 11,004 User Group Leader on at
    RE: Export or other access to old Dynamics GP 9.0 system

    Yes very easily as Richard mentioned.

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Export or other access to old Dynamics GP 9.0 system

    The data is sitting in an MS SQL database. You can use anyone of the current ETL tools to extract the data. You will need to have a knowledge of the underlying databases. Let us know what data you need and we can point you to the proper tables.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans