Edit Report:Consignment Inventory Report
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Consignment Inventory Report
-- Tires Consigned at Customer Locations
-- ^inventory
--
-- VARIABLE: {
-- name: "debtorno",
-- display: "Customer Number",
-- type: "text",
-- }
--
-- ROLLUP: {
-- columns: {
-- "Total Value": "Total: {{sum}}"
-- }
-- }
select debtorstock.debtorno as `Customer Number`, name as `Customer Name`, debtorstock.stockid as `Item Number`, description as `Description`,
qty as `Qty Consigned`, materialcost as`Consigned Cost`, round(materialcost * qty,2) as `Total Value`
from debtorstock inner join stockmaster on debtorstock.stockid = stockmaster.stockid
inner join debtorsmaster on debtorstock.debtorno = debtorsmaster.debtorno
where debtorstock.debtorno like '%{{debtorno}}%' order by debtorstock.debtorno asc