Avatar of FMCA-IT

asked on 

GP AP Invoicing Question

Hi all,

I'm trying to create a query in Great Plains for AP Invoices.  I need the results to include the "normal" vendor info(at least the vendorid, but name, etc), the invoice info(like number, entry date,amount, etc), and the G/L accounts to credit and debit.

I have located a few tables that contain some of the data:

pm00200 - Vendor info
pm00300 - Vendor address
pm00400 - Seems to be invoice stuff or at least part of it.
pm30200 - Seems to be paid invoice stuff(i think).

But I don't see anything that necessarily links them together(trxsorce?) and also gets me the Expense and Payable G/L accounts to credit and debit.

Any ideas?

Thank you
Microsoft DynamicsMicrosoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon