Notifications
Announcements
Hello Team,Could you provide me a link to the specification which GP tables in the database includes the following Account Receivables Documents:- Invoices- Credit Memos- Adjustments- Payments - Sales Orders- Contacts- GL Accounts- Payment MethodsAs an example, if GP stores invoices in a few tables, how to join these tables, and by what key?Or if you have the list of the tables for these documents, could you provide them please?
Good day,
See attached links
victoriayudin.com/.../
You will get the table names, e.g., invoices - SOP Number - is also in the Inventory transaction tables.
Are you familiar with SQL?
Regards
Rosemary
Hi Andrew,
This site might prove to be very useful when it comes to search for Tables & Fields in GP:
gptables.azurecurve.co.uk/
Courtesy of Ian Grieve in the UK.
HTH
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Abhilash Warrier 791 Super User 2025 Season 2
André Arnaud de Cal... 428 Super User 2025 Season 2
Martin Dráb 333 Most Valuable Professional