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?