Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Removing Old GP Data
Microsoft Dynamics GP (Archived)

Removing Old GP Data

(0) ShareShare
ReportReport
Posted on by Jeff Garrison 2,485

Another question.

What is the best way to purge data?  I'm trying to remove all data prior to 2005 (standard 7 year retention) without screwing up any financials.

I guess what I'm looking for is some help on what exactly I need to do to remove the data without messing up the Financials (step by step guidance would be ideal).  I have never gone through and done this myself and the company does not want to spend the amount of money that partners are asking for to do this.

I know there are products out there that can archive data, but they also want $$$.

Thanks in advance.

Jeff

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Removing Old GP Data

    yes sir.  this was very helpful.  thank you frank.

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,220 Super User 2024 Season 2 on at
    Re: Removing Old GP Data

    Rick and Jeff:

    Yes, removing historical transactions means deleting the transactions from the tables.  However, you can delete historical transactions from the Purchasing and Sales modules, for example, and it won't affect your financial reporting because financial reporting data is pulled from the GL tables.  As long as you leave the GL history in place, you can still run financial reports on those historical years.

    Historical transactions means different things in different modules.  In Financial, it means transactions in a closed fiscal year.  In Sales, it means fully paid sales and receivables invoices.  In Purchasing, it means closed and/or cancelled POs and fully paid vendor invoices.

    Also, in the Sales module, fully paid documents don't move to history until you run the Paid Transaction Removal Routine.  In the Purchasing module, fully paid documents transfer to history automatically.

    Hope this helps,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Removing Old GP Data

    Just don't run any reconcile utilites for the periods deleted.   For example if you remove GL history for 2005, your summary balances for 2005 will remain.   However, if you run reconcile then the summary balances for 2005 will go to 0.    

  • Jeff Garrison Profile Picture
    Jeff Garrison 2,485 on at
    Re: Removing Old GP Data

    Frank -

    For clarification, by removing Transaction History, Distribuitons, etc., it will not impact the Financials correct?  The current Financials are not impacted by deleting the prior history?

    Rick - I believe the answer to your question is Yes, they are removed from the tables.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Removing Old GP Data

    frank,

    please clarify for me.  from a user perspective, what exactly does 'remove historical transactions' mean?  in other words, will the historical transx no longer be available on inquiry screens and reports?  is this literally deleting data from the tables/system?

    thanks!

  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,220 Super User 2024 Season 2 on at
    Re: Removing Old GP Data

    Jeff,

    Each of the modules in GP has a Utility for removing historical transactions.  For instance, for Purchasing, navigate to Purchasing>>Utilities>>Remove Transaction History, Distributions, Period History, etc.  Click on the Help button at the bottom of each window.  Help should provide you the necessary instructions you need to safely perform the processes.  If you have any further questions after reading the Help files, let us know. And always make sure you back up your database(s) before trying this at home!!

    Good luck,

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

Product updates

Dynamics 365 release plans