For the guys working with manufacturing in Dynamics GP Check this out.
This white paper provides information about the Manufacturing Checkdata stored procedure in Microsoft Dynamic GP. This paper describes the functionality as well as how to run the procedure. The reported errors are listed along with information about each error. (35 pp.)
The Checkdata script is designed to evaluate various manufacturing tables and report back any inconsistencies discovered. The script is informational only and does not make changes to any manufacturing table. The Checkdata script can be run on any version of Microsoft Dynamics GP.
For complete details, download it https://mbs.microsoft.com/partnersource/deployment/documentation/whitepapers/manufacturing_checkdata_white_paper.htm?printpage=false