Edit Report:Shipping Income Report
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Shipping Income Report
--
--
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "groupby",
-- display: "Group By",
-- type: "select",
-- multiple: false,
-- options: [{display: 'Customer', value:'customer'},{display: 'Salesperson', value:'salesperson'}],
-- }
-- ROLLUP: {
-- columns: {
-- "TOTAL": "Total: {{sum}}",
-- }
-- }
-- FILTER: {
-- filter: "class",
-- column: "TOTAL",
-- params: {
-- class: "right"
-- }
-- }
SELECT
salesman.salesmanname as 'SALESMAN',
debtorsmaster.debtorno as 'CUSTOMERNO',
debtorsmaster.name as 'NAME',
CAST( sum(debtortrans.ovfreight) as DECIMAL(10,2)) as 'TOTAL'
FROM
debtortrans
LEFT JOIN debtorsmaster on debtortrans.debtorno = debtorsmaster.debtorno
LEFT JOIN salesman on debtortrans.salesperson = salesman.salesmancode
WHERE
1
and type in (10, 11)
AND trandate between "{{ range.start }}" AND "{{ range.end }}"
{% if groupby == 'customer' %}
GROUP BY debtorsmaster.debtorno
{% endif %}
{% if groupby == 'salesperson' %}
GROUP BY debtortrans.salesperson
{% endif %}
HAVING TOTAL > 0
{% if groupby == 'customer' %}
ORDER BY debtorsmaster.debtorno
{% endif %}
{% if groupby == 'salesperson' %}
ORDER BY salesman.salesmanname
{% endif %}