Edit Report:Expired Customer Licenses
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Expired Customer Licenses
-- PLACE HOLDER REPORT DESCRIPTION
-- PLACE HOLDER REPORT FILTERS AND DRILL DOWN
--
select debtorno as `Customer Number`, name as `Customer Name`, address1 as `Address`,
address3 as `City`, address4 as `State`, address5 as `Zip`, licExpDate as `Expiration Date` from debtorsmaster
where licExpDate <= NOW();