Edit Report:NO Input
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- NO Input
-- PLACE HOLDER REPORT DESCRIPTION
-- PLACE HOLDER REPORT FILTERS AND DRILL DOWN
select debtorno, brname, transno,discountedlinetotal from stocktrans where trandate >= DATE(NOW()) - INTERVAL 7 DAY group by debtorno