check_ap_ar_for_vendor_customer_without_id
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
| — | check_ap_ar_for_vendor_customer_without_id [2016/08/21 19:34] (current) – created sweitmann | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | SELECT invnumber, transdate, amount FROM ar WHERE customer_id NOT IN (SELECT id FROM customer) | ||
| + | SELECT invnumber, transdate, amount FROM ap WHERE vendor_id NOT IN (SELECT id FROM vendor) | ||
check_ap_ar_for_vendor_customer_without_id.txt · Last modified: 2016/08/21 19:34 by sweitmann