User Tools

Site Tools


check_ap_ar_for_vendor_customer_without_id

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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