Create View View_ItemBalance As 
SELECT TOP (100) PERCENT a.ID, c.TrsDate, a.TrsNo, c.BillType, c.BillNo, a.InQty, a.OutQty, a.ItemCode, a.UnitMeasure, c.TrsOutlet,
(SELECT SUM(COALESCE (B.InQty, 0)- COALESCE (B.OutQty, 0)) AS Expr1
FROM Vstk_trs_BillDetails AS B LEFT OUTER JOIN Vstk_trs_Bills AS d ON B.TrsNo = d.TrsNo
WHERE (CAST(YEAR(d.TrsDate) AS Varchar(4)) + CASE WHEN CAST(Month(D .TrsDate) AS Varchar(2)) IN (10, 11, 12) THEN CAST(Month(D .TrsDate) AS Varchar(2)) ELSE '0' + CAST(Month(D .TrsDate) AS Varchar(2)) END + CASE WHEN CAST(Day(D .TrsDate) AS Varchar(4)) IN (1, 2, 3, 4, 5, 6, 7, 8, 9) THEN '0' + CAST(Day(D .TrsDate) AS Varchar(2)) ELSE CAST(Day(D .TrsDate) AS Varchar(2)) END + CAST(a.ID AS Varchar(100)) 
<= CAST(YEAR(c.TrsDate) AS Varchar(4)) + CASE WHEN CAST(Month(C.TrsDate) AS Varchar(2)) IN (10, 11, 12) THEN CAST(Month(C.TrsDate) AS Varchar(2)) ELSE '0' + CAST(Month(C.TrsDate) AS Varchar(2)) END + CASE WHEN CAST(Day(C.TrsDate) AS Varchar(4)) IN (1, 2, 3, 4, 5, 6, 7, 8, 9) THEN '0' + CAST(Day(C.TrsDate) AS Varchar(2)) ELSE CAST(Day(C.TrsDate) AS Varchar(2)) END + CAST(B.ID AS Varchar(100)))
AND (B.ItemCode = a.ItemCode) AND (d.TrsOutlet = c.TrsOutlet)) AS balance
FROM Vstk_trs_BillDetails AS a LEFT OUTER JOIN Vstk_trs_Bills AS c ON a.TrsNo = c.TrsNo
WHERE (a.InQty <> 0) AND (c.BillType IN ('PUR', 'PRT', 'GRN', 'GIN', 'CSP', 'DO', 'INV', 'CSH', 'SIN', 'SRN', 'ADI', 'ADO', 'STI', 'STO', 'PRO', 'FNG', 'USG', 'WST', 'MRC', 'MRT')) 
OR (c.BillType IN ('PUR', 'PRT', 'GRN', 'GIN', 'DO', 'INV', 'CSH', 'SIN', 'SRN', 'ADI', 'ADO', 'STI', 'STO', 'PRO', 'FNG', 'USG', 'WST', 'MRC', 'MRT')) 
AND (a.OutQty <> 0)