Microsoft Dynamics GP Table Reference

GP Table ReferenceThere are a fair number of really good resources out there on Microsoft Dynamics GP, but, unfortunately, some of them disappear through time.

One of the casualties was the GP Table Reference, which closed down a while ago. I’m not sure who was behind the site, but it has been missed.

To that end, I have started building a new site to live alongside this one; the Microsoft Dynamics GP Table Reference. The site is a work in progress, and will likely always be.

At present it has the main Microsoft Dynamics GP products tables along with the tables for Fixed Assets (product 309), Purchase Order Enhancements (product 2277) and Revenue Expense Deferrals (product 1045).

I will be adding products soon and will continue adding them until I have all of the first party products and will then look to start adding some of the more popular/common ISV ones.

I’ll also be adding some further explanations and to the fields, such as the one already added to the LOCNCODE field in Purchase Order Line (POP10110).

I hope people find the site useful; if you do use it and spot any issues, or want anything adding, please get in touch and let me know.

Can ISC Software Solutions help?

ISC Software Solutions are UK and Ireland based experts on Microsoft Dynamics GP. If you'd like to speak to someone about support, consultancy, upgrades, implementation, development, GP Elementz add-ons or portals, or anything else Dynamics GP related, you can use the form below.
Your Name (required):
Your Email (required):
Enquiry message:

What should we write about next?

Your Name (required) -
Your Email (required) -

8 thoughts on “Microsoft Dynamics GP Table Reference

  1. Charmaine Gray says:


    The company I am working at will be going to Dynamics GP in the near future.
    I need to learn the reports piece. I have been looking around and reading about Dynamics GP. From what I have read, I understand that Dynamics will be using SSRS working with Management Reporter. Am I understanding this correct?
    Would you point me to some very good reading material?
    I appreciate any guidance you can give me.
    Thank you,
    Charmaine Gray

    1. Ian Grieve says:

      Hi Charmaine,
      SSRS and Management Reporter are separate reporting tools which do not interact with one another.

      For reporting, the Microsoft Dynamics GP 2013 Reporting – Second Edition book from Packt Publishing is a good starting point; don’t worry about the version of GP, as the content will still apply.


Leave a Reply

Your email address will not be published. Required fields are marked *