check_ap_ar_for_vendor_customer_without_id
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: 2024/09/25 06:21 by 127.0.0.1