63
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 Methods
As 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?
Hi Andrew,
This site might prove to be very useful when it comes to search for Tables & Fields in GP:
Courtesy of Ian Grieve in the UK.
HTH
Good day,
See attached links
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
#1
André Arnaud de Cal...
291,861
Super User 2024 Season 2
#2
Martin Dráb
230,540
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
