Finance | Project Operations, Human Resources, ...

GP Account Receivable Document tables

(0) Share

Report

Posted on by Andrew1986

443

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?

All responses (2)

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: GP Account Receivable Document tables

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
Rosemary 2 on at

Like (0)

Report

RE: GP Account Receivable Document tables

Good day,

See attached links

victoriayudin.com/.../

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