AP Year End - Distribution Breakdown for Open Invoices

This query returns a breakdown of all distributions for open invoices as of the end of the year. It is useful for determining acrual entries required by companies filing taxes on a cash basis.

select i.vend_id "Vendor" ,v.name "Name",i.invoice_date "Inv Dt",i.invoice_no "Invoice NO",i.gross_amount "Inv Amt",i.invoice_bal "Inv Bal",dt.Description "Description",exp_gl "Dist GL" , a.description "Act Name",   (I.INVOICE_BAL/I.GROSS_AMOUNT)*DIST_AMT "Open Dist"
from appinv_aging(:YE,:YE,0) i
inner join aptinvdt dt on (dt.session_no=I.AP_session_no) and (dt.trans_no=I.AP_trans_no)
inner join aptvend v on v.vend_id=i.vend_id
inner join gltacct a on a.gl_account=dt.exp_gl

Formatting:

Vendor,Name: Break and Group 1

Invoice Date, Invoice No, Inv Amt, Inv Amt: Break and Group 2

Formatting the date as mm/dd/yy and setting field widths down from default improve printing.