===========================================================
===========================================================
员工预支款SCRIPT
作者: moonsoft(http://moonsoft.itpub.net)发表于: 2007.03.01 18:17
分类: 财务
出处: http://moonsoft.itpub.net/post/15182/265919
---------------------------------------------------------------
path: payables , invoice, entry, invoice , 查看付款（付款金额），查看预付款核销（核销金额）
SELECT sum(aip.amount), sum(aid1.amount), sum(aid2.amount)
FROM po_vendors pv,
ap_invoices_all ai,
ap_invoice_payments_all aip,
ap_invoice_distributions_all aid1,
ap_invoice_distributions_all aid2
WHERE ai.vendor_id = pv.vendor_id
AND ai.invoice_id = aip.invoice_id
AND ai.invoice_id = aid1.invoice_id
AND aid2.prepay_distribution_id = aid1.invoice_distribution_id
AND pv.vendor_name LIKE '%AARON'
group by ai.invoice_num
SELECT sum(aip.amount), sum(aid1.amount), sum(aid2.amount)
FROM po_vendors pv,
ap_invoices_all ai,
ap_invoice_payments_all aip,
ap_invoice_distributions_all aid1,
ap_invoice_distributions_all aid2
WHERE ai.vendor_id = pv.vendor_id
AND ai.invoice_id = aip.invoice_id
AND ai.invoice_id = aid1.invoice_id
AND aid2.prepay_distribution_id = aid1.invoice_distribution_id
AND pv.vendor_name LIKE '%AARON'
group by ai.invoice_num
