Since I have posted a lot of Dynamics GP table information and SQL code, I often get asked the question “what table holds ____ “? Sometimes I just know the answer off the top of my head (yeah, I think that’s scary, too), but once in a while I have to look it up. I have various ways of doing this, sometimes it involves glancing through the list of tables, other times I have used the Support Debugging Tool created by David Musgrave . Now there is another great resource for this provided to us again by David Musgrave. You can read all about it in David’s post on Getting Table and Field Data out of Dexterity Dictionaries , however I thought I would take you through an example of how to use this. This example assumes that you have already installed the Support Debugging Tool - if you have not, that’s your first step. Now to our example (I am using GP 2010 for this, but it should work the same for GP 10.0): Log into GP as ‘sa’.
Continue reading →