path: payables , invoice, entry, invoice , 查看付款（付款金额），查看预付款核销（核销金额）[@more@]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
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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/226700/viewspace-901125/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
报表输入参数级联
请登录后发表评论
登录
全部评论
