Edit Report:BALANCES
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- BALANCES
-- PLACE HOLDER REPORT DESCRIPTION
-- PLACE HOLDER REPORT FILTERS AND DRILL DOWN
-- VARIABLE: {
-- name: "range",
-- display: "Report Range",
-- type: "daterange",
-- default: { start: "yesterday", end: "yesterday" }
-- }
-- VARIABLE: {
-- name: "salesperson",
-- display: "SalesPerson Number",
-- type: "text",
-- }
-- FILTER: {
-- column: "DEBTORNO",
-- filter: "drilldown",
-- params: {
-- macros: { "debtorno": { column: "DEBTORNO" } },
-- report: "drilldown/customer-invoices.sql"
-- }
-- }
-- ignore
{% set months = ['01','02','03','04','05','06','07','08','09','10','11','12'] %}
{% set monthnames = ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun' , 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec'] %}
{% for month in months %}
{% set loopi = loop.index - 1%}
(select sum(ovamount + ovgst + ovfreight + ovdiscount) as 'BAL-FWD{{ monthnames[loopi] }}' from debtortrans where debtorno = '7939' and trandate < '2020-{{ month }}-01')
{%endfor%}