Below is a list of commonly used tables and their values. Yeah I know it’s a long list, but if you have ever been working on that one report or looking for that one piece of information, you know that the manufacturing module is very big and very complex, hence all of the common used tables.
There are a few of the tables I have included, which are only required to correct issues. A few examples are bomlev1 and bomlev2; these tables are used for rolling costs. If you have large Bills of Materials and you roll your costs often, the Dex Row ID’s in these tables can get too large. When this happens all processing on cost rolls stops leaving you with an extremely vague message. Dropping and rebuilding these two tables with their associated stored procedures is the only way to correct the issue. A pain, I know, but in my prior life this was a once or twice a year occurrence and 9 times out of 10 you were left searching for the tables.
I have also included the values for some of the more common fields in these tables. If you are writing reports or troubleshooting issues, these values are usually not included in the GP table reference or in some instances, they are just wrong.
Next time I will cover how information moves through these tables during the common transactions, and how to investigate and correct some of the more common issues when working with the manufacturing module within Dynamics GP. Have fun and always remember make frequent backups and do all of your investigation work in a test company. If you have any questions please feel free to reach out to us by filling out the contact form below.