Edit Report:VENDOR SALES ROLLING 12
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- VENDOR SALES ROLLING 12
--
--
-- ignore
{% set today = "now"|date("Y-m-d") %}
{% set month = ("now"|date("m")) %}
{% set date = "now"|date("Y-m-d") %}
{% set year = "now"|date("Y") %}
SELECT
{% set j = month %}
{% for i in 1..13 %}
{% set newDate = date | date_modify("-1 month") %}
-1*SUM(if(tranmnth = '{{ j * 1 }}' and year(trandate)='{{year}}', discountedlinetotal, 0)) AS `sales{{ j * 1 }}{{year}}`
{% if loop.last == false %},{% endif%}
{% set j = j - 1 %}
{% if j < 0 %}
{% set j = 12 %}
{% set year = year - 1 %}
{% endif %}
{% endfor %}
FROM
stocktrans
WHERE
1
AND loccode = 01
LIMIT 1