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.