I have some tables that have an Incorrect record length error when I insert them in the BOM File Maintenance window. How can I correct that?
• A: Another typical error is ‘Invalid Column Name’. There are several options to solve this: • If the data in the table is unimportant or non-existent, the table and stored procedures can be recreated using the ‘SQL Maintenance’ screen (File | Maintenance | SQL). • Make sure that all users are out of the system and that you have a good backup. • Log in as ‘sa’. • Drop and Recreate both the Table and the Auto Procedure. • If the table is too large or irreplaceable, please contact technical support. • Configurator Errors even when CFG not installed • Q: I don’t have Configurator installed or registered, but after successfully upgrading Manufacturing, I’m getting an error that refers to a ‘CFG’ table when I try to use the Auto-Create Workorders from SOP’ window. • A: This can happen on any HMS build. To solve this, log into Great Plains as ‘sa’ and use the ‘SQL Maintenance’ window to drop and re-create the CFG_SOP_HDR table and auto procedures (Be careful to only get the one table that y
