Update Project and Contract Numbers is a Distibution feature added to Microsoft Dynamics GP in the October 2021 release.

We have added a new window called the Project Code Modifier which will enable you to modify Project Numbers, Project IDs, Contract Numbers, Contract IDs, and Cost Categories.  With this new feature you can change fields listed above for existing Contracts, Projects, and Cost Categories in Microsoft Dynamics GP to a new value.
To access this window, go to the Microsoft Dynamics GP menu, point to Tools, point to Utilities, point to Project, and click on Project Code Modifier.  In this window you can use the Code Type drop down to select the code that you would like to modify, then use the Old Code lookup to select and existing code and enter the New Code value that you want to change it to.

Project Code Modifier-1

A new Code Modification report will print when the process completes that will document which SQL tables were updated during the process for your reference.

Project Code Modifier-2

  • This feature does not combine existing records into one record, it modifies existing records to have a new number or id that does not already exist in the system.
  • If you have customizations or 3rd party products, you want to be very careful with this feature to make sure all data for those other product tables are updated as expected.  As long as they used the exact same column names as the Microsoft Dynamics GP tables that are being updated, this should work without issue.  If you are unsure of compatibility or which areas and tables to check for your customization or 3rd party product please reach out to them for clarification.

Are you interested in Microsoft Dynamics GP? Contact us first. CAL Business Solutions 860-485-0910 or support@calszone.com

By CAL Business Solutions, Connecticut Microsoft Dynamics GP Partner, www.calszone.com

Read the original post at: https://community.dynamics.com/blogs/post/?postid=8559a76f-a354-43b5-adbc-f98eafab57bc