Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc.

Query to write Custom Invoice And Payment Report that matches with GL Liability Account Balance, GL Prepayment Account Balance, Expense Accounts etc. select aipa.check_number, aipa.check_id, aia.payment_method_code, aia.payment_status_flag, aipa.status_lookup_code, aipa.reversal_flag, aia.wfapproval_status, haout.name, asup.vendor_name, asup.vendor_id, aia.invoice_num, aia.invoice_id, […]