Announcements
No record found.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 509 Super User 2026 Season 1
Giorgio Bonacorsi 375
Adis 268 Super User 2026 Season 1