Edit Report:POS Open Credits
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- POS Open Credits
--
--
-- ignore
select transno, d.debtorno, d.branchcode, brname, braddress1, braddress3, braddress4, braddress5 , d.alloc , ovamount , ovgst , ovfreight ,
CAST(ovamount + ovgst + ovfreight as decimal(10,2)) as total
from
debtortrans d
join custbranch on custbranch.debtorno = d.debtorno and custbranch.branchcode = d.branchcode
where settled = 0 and type = 11
and store_location = 1
having cast(d.alloc as decimal(10,2)) <> CAST(ovamount + ovgst + ovfreight as decimal(10,2))