Warning

Error while accessing the database Reference 'Division' not supported (forward reference in item list) select count(*), sum(Inward), sum(Outward), sum(Closing) from (SELECT id, mid, (SELECT DocNo FROM prmast WHERE id=i.mid) AS DocNo, ItemName, (SELECT EntDate FROM prmast WHERE id=i.mid) AS vDate, (SELECT Division FROM prmast WHERE id=i.mid) AS Division, Description, UOM, 0 AS Opening, Qty AS Inward, if((SELECT VehicleNo FROM prmast WHERE id=i.mid) >'',Qty,0) AS Outward, if((SELECT VehicleNo FROM prmast WHERE id=i.mid) >'',0,0+Qty) AS Closing, UnitCost, Amount, Party, (SELECT VehicleNo FROM prmast WHERE id=i.mid) AS VehicleNo FROM prtrans i WHERE ItemName='' UNION ALL SELECT id, mid, (SELECT DocNo FROM issmast WHERE id=t.mid) AS DocNo, ItemName, (SELECT EntDate FROM issmast WHERE id=t.mid) AS vDate, (SELECT Division FROM issmast WHERE id=t.mid) AS Division, Description, UOM, 0 AS Opening, 0 AS Inward, Qty AS Outward, 0-Qty AS Closing, UnitCost, Amount, Party, (SELECT VehicleNo FROM issmast WHERE id=t.mid) AS VehicleNo FROM isstrans t WHERE ItemName='' ) nm_sel_esp