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
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
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
This page might help you to understand the PA table structure:
gptables.azurecurve.co.uk/.../
Hope this helps,
B@
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,558 Super User 2024 Season 2
Martin Dráb 228,647 Most Valuable Professional
nmaenpaa 101,148