Finance | Project Operations, Human Resources, ...

GP Account Receivable Document tables

(0) Share

Report

Posted on by Andrew1986

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?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (2)

Answers (0)

Rosemary 10 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No