Edit Report:Epres shipping report
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Epres shipping report
-- PLACE HOLDER REPORT DESCRIPTION
-- select date range
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- }
SELECT
d.transno AS 'Invoice Number',
d. order_ as 'pick slip',
d.debtorno,
d.branchcode,
sa.deliverto AS 'Salon Name',
d.salesperson,
sa.ordcreatedate AS ordercreated,
sh.shippername,
s.userid as 'invoiced_by',
UPPER(pickedby) AS picked_by,
UPPER( packedby ) AS packed_by,
sum( s.qty * - 1 ) AS items_on_invoice,
d.ovamount as total,
t.trackingnumber,
t.url
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_
inner join trackinginfo t on d.transno = t.transno
join shippers sh on sa.shipvia= sh.shipper_id
WHERE
s.loccode = '00'
AND trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND d.debtorno = '31151'
group by d.transno