News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum GP Account Receivable ...

Microsoft Dynamics GP forum

Suggested answer

GP Account Receivable Document tables

(0) Share

Report

Report

Posted on by Andrew1986

423

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:

Development / Customization / SDK

Administration and Setup

Web Services and Workflow

Install and Upgrade

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,009 Super User 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 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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 288,584 Super User

#2

Martin Dráb 225,864 Super User

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans