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) sweitmann created |
||
---|---|---|---|
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) |