to link AP INVOICE HISTORY to a General ledger Detail Report...tables names?

Good morning!

I need a hero to save me today.

I need to give the assets for the 2008 year to the CPA.

I need to generate a query in Excell but I do not know what table or fields to pull so it gives me GL Account Number, description, Date, Journal Comments, Beginning Balance, DEbit, Credit,  Net Change,  Ending balance, Invoice number, invoice date, invoice amount, invoice balance, check number (if it has one).

The information on the invoice history window with its three tabs will be a start (don't know the name of that table, I just know that it comes from the AP invoice history) still, I need the GL account # credit, debit, and everything else I mentioned.

Any hero to save my day?

  • 0

    Run a stock report to get things like Beginning / Ending balance.

    Link GL_DetailPosting to GL_Account for detailed posting information.  Use this link to GL_Account to translate AccountKey into an Account.

    AP data is not necessarily something you can link directly to the GL query.  AP_InvoiceHistory*** tables are where to look though.  Payment details will be in AP_CheckHistory*** tables.