Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Remove Project Accounting History?

(0) ShareShare
ReportReport
Posted on by 18

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
    28,058 Moderator 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

Quick Links

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Featured topics

Product updates

Dynamics 365 release plans