check_ap_ar_for_vendor_customer_without_id
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) 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) | ||
check_ap_ar_for_vendor_customer_without_id.txt ยท Last modified: 2016/08/21 19:34 by sweitmann
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3
