Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Remove Project Accounting History?

(0) ShareShare
ReportReport
Posted on by 2,990

Hi,

My client has twelve years of project accounting history and wants to remove some.

In the Project - Utilities menu I only see the remove cost and billing history. What is the process to remove project history?

Thanks,

Linda

*This post is locked for comments

  • Suggested answer
    Beat Bucher  GP Geek  GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at
    RE: Remove Project Accounting History?

    Hi Linda,

    Your question is over 6 months old, so I guess by this time you probably figured it out..

    I've been working with PA in GP for almost 10 years and that was one of the things that frustrated me. Though there are sets of historical tables like in the other GP modules (SOP, POP), the process of moving data from work/open to history is less clear-cut IMHO. Some detail records are moved to history tables like Timesheets and Expenses, some data always remains in setup tables (like contracts, projects and cost categories).

    One way of deleting contract data is by using this form : Project > Utilities > Mass Contract Delete

    Or use the PA Clear form in the maintenance : Microsoft Dynamics GP menu > Maintenance > PA Clear Data

    As an example, the following tables are holding the historical data for Employee TS transactions, so when you select the "PA Timesheet Transactions History" to clean up, it will wipe out data from 3 tables that are assigned to TS history

    ScreenCap-2019_2D00_11_2D00_04_5F00_094814.png

    This page might help you to understand the PA table structure:

    gptables.azurecurve.co.uk/.../

    Hope this helps,

    B@

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans