web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Can we move a project ...
Microsoft Dynamics GP (Archived)

Can we move a project to a different PA contract?

(0) ShareShare
ReportReport
Posted on by Lou@ACE 447

We have 2 projects in a contract that do not belong to that contract. They are both closed and contain only historical data and will have no activity. I would like to remove them from that particular contract and have them in new contracts. By leaving them in the current contract, their historical transactions are being pulled into our current reporting. Thoughts on how to do this? Thank you!

*This post is locked for comments

I have the same question (0)
  • Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,061 Moderator on at

    Hi Lou,

    There is no way to achieve this in GP... you need to use your SQL script magic toolbox to do that... There used to be some scripts around which was allowing to rename a contract linked with a project, but I can't find them right now..

    I've built my own SQL scripts that update a bunch of PA tables in GP... but I agree that it's very specific. There are at least a dozen tables that you need to update to reflect the 'move'... it could be way more if you want to change also the historical data (> 20 tables).

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,061 Moderator on at

    Lou,

    I digged a little bit in the community postings and found an old reply from Mark Polino of last year :

    community.dynamics.com/.../weekly-dynamic-changer-scripts-for-project-accounting.aspx

    One thing that I noticed from the Readme.txt that's provided with the scripts, is that this will not allow your to 'merge' records... only rename them... So you'll likely be out of luck with this one. But I'd still try them out on a TEST company for example to see how they would behave..

    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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans