Edit Report:Chatters + TG's Monthly Redken Sales (Warehouse Only)
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Chatters + TG's Monthly Redken Sales (Warehouse Only)
-- Select date range. Enter 03 for Chatters, 04 for Tommy Gun's. Enter RK in 'supplierno' field
-- ^Monthly Reports
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "first day of last month", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "salesperson",
-- display: "SalesPerson No",
-- type: "text",
-- }
-- VARIABLE: {
-- name: "supplierno",
-- display: "Supplier Code",
-- type: "text",
-- }
-- ROLLUP: {
-- columns: {
-- "Chatters Total": "Total: {{sum}}",
-- "Tommy Guns Total": "Total: {{sum}}",
-- }
-- }
SELECT
debtorno,
branchcode,
brname,
salesmanname,
salesperson,
CAST(
SUM( CASE WHEN salesperson = '03' THEN ( discountedlinetotal * - 1 ) ELSE 0 END ) AS DECIMAL ( 10, 2 )) AS 'Chatters Total',
CAST(
SUM( CASE WHEN salesperson = '04' THEN ( discountedlinetotal * - 1 ) ELSE 0 END ) AS DECIMAL ( 10, 2 )) AS 'Tommy Guns Total'
FROM
stocktrans
WHERE
trandate BETWEEN '{{ range.start }}' AND '{{ range.end }}'
AND supplierno like '{{ supplierno }}%'
AND salesperson IN ('03','04')
AND loccode = '00'
GROUP BY
debtorno,
branchcode,
brname
ORDER BY
debtorno,
branchcode ASC