Edit Report:Simple Select
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Simple Select
-- 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",
-- }
-- VARIABLE: {
-- name: "loccode",
-- display: "Location",
-- type: "select",
-- multiple: false,
-- options: [{display: 'Main', value:'01'},{display: 'Somewherelse', value:'30'}],
-- }
-- VARIABLE: {
-- name: "type",
-- display: "Type",
-- type: "select",
-- multiple: false,
-- options: [{display: 'Reciept', value:'12'},{display: 'Credit', value:'1'},{display: 'Invoice', value:'10'}],
-- }
select * from stocktrans where trandate between "{{ range.start }}" AND "{{ range.end }}" and salesperson like '%{{ salesperson }}%' and loccode='{{ loccode }}' and type='{{ type }}'