Edit Report:Orders placed by day
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Orders placed by day
-- Select Date Range
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "today" }
-- }
-- VARIABLE: {
-- name: "debtorno",
-- display: "Customer#",
-- type: "text",
-- }
--
SELECT
sa.ordcreatedate AS 'Date Created',
sa.datepackingslipprinted AS 'Date Printed',
d.inputdate AS 'Date Invoiced',
sa.deliverydate AS 'Estimated Delivery',
d.debtorno AS 'Debtorno',
d.branchcode AS 'Branch Code',
d.transno AS 'Invoice#',
sa.customerref AS 'Reference',
sa.deliverto AS 'Salon Name',
sa.deladd3 as 'City',
d.salesperson AS 'Sales#',
sh.shippername AS 'Shipped Via',
s.userid as 'Invoiced By',
UPPER(pickedby) AS 'Picked By',
UPPER( packedby ) AS 'Packed By',
sum( s.qty * - 1 ) AS '#Items Invoiced',
(select t.trackingnumber from trackinginfo t where t.transno = d.transno) as 'Trackingnumber'
FROM
debtortrans d
INNER JOIN stockmoves s ON s.type = d.type AND s.transno = d.transno
INNER JOIN salesorders sa ON sa.orderno = d.order_
join shippers sh on sa.shipvia= sh.shipper_id
WHERE
d.type = '10'
and s.loccode = '00'
AND d.trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
{% if debtorno != '' %}
and d.debtorno ='{{ debtorno }}'
{%endif %}
GROUP BY
s.transno
order by sa.ordcreatedate asc