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