Hello Dynamics GP Community!
We have occasionally had reports of issues with the Navigation Lists in Dynamics GP that meant to return information about workflow tasks. These issues can range from incorrect columns being used (e.g. the legacy "Workflow Approval Status" versus the current "Workflow Status") or invalid filter criteria that don't allow valid information to be returned.
Generally when we run into such errors the solution is to rebuild the Navigation List by removing and inserting the appropriate records into the relevant tables on a case-by-case basis. In order to simplify this process we wanted to get the rebuild scripts published for our community to use.
If you look at the contents of this compressed file you will see that the scripts are broken down into series folders that correspond to where the Navigation Lists are found. Within each folder you'll find one SQL script for each main Navigation List that has workflow data. Each script will rebuild one or more specific Navigation Lists. For example, when you execute the Vendors.sql script in the Purchasing folder against the DYNAMICS database it will remove everything under the Vendors Navigation List, then rebuild the base Vendors list as well as the Vendors Not Submitted and Vendors Pending Approval views. If you have any custom views in a list they would be removed as well, so you would need to manually rebuild those.
As with any direct change to a SQL table it's always considered best practice to have good backups of your Dynamics GP databases before running these scripts.
We hope this information helps address any issues you may run into with these Navigation Lists!
