Edit Report:All Invoices For a Customer
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- All Invoices For a Customer
-- This is a drilldown report that lists all invoices for a given customer
-- VARIABLE: { name: "debtorno", display: "Customer Id" }
SELECT
*
FROM
invdata
WHERE
debtorno = "{{ debtorno }}"