ALTER PROCEDURE dbo.rpt_TSCD_BC06_1_Excel_BanViet
	@p_Fromdate varchar(10) = null,
	@p_Todate varchar(10) = null,
	@p_Branch_ID varchar(15) = null,
	@p_BRANCH_LOGIN VARCHAR(15) = NULL,
	@P_LEVEL VARCHAR(10) = 'ALL'
AS
BEGIN
	DECLARE @tmp table(BRANCH_ID varchar(15))
	insert into @tmp  SELECT BRANCH_ID  FROM [dbo].[CM_BRANCH_GETCHILDID](@p_Branch_ID)
	DECLARE @TEMP_RETURN TABLE (NAME NVARCHAR(1000),TK_3012 decimal(18,0),TK_3013 DECIMAL(18,0),TK_3014 DECIMAL(18,0),TK_3015 DECIMAL(18,0),TK_3019 DECIMAL(18,0),TK_3021 DECIMAL(18,0),TK_3024 DECIMAL(18,0),TK_3029 DECIMAL(18,0),TOTAL_AMT DECIMAL(18,0),DESCR NVARCHAR(100),IS_COLOR VARCHAR(1))
	--DECLARE @TEMP TABLE (MANHOM VARCHAR(15),NHOMTS NVARCHAR(1000),NGUYENGIA_DK decimal(18,0),PS_TANG_NG DECIMAL(18,0),PS_GIAM_NG DECIMAL(18,0),TK_3015 DECIMAL(18,0),TK_3019 DECIMAL(18,0),TK_3021 DECIMAL(18,0))
	DECLARE @TEMP TABLE (MANHOM VARCHAR(15),NHOMTS NVARCHAR(1000),NGUYENGIA_DK decimal(18,0), KH_LUY_KE_DAU_KY DECIMAL(18,0),NGUYENGIA_TANG DECIMAL (18,0),TANGTS_MUA DECIMAL(18,0),TANG_DC DECIMAL (18,0),TANG_KHAC DECIMAL(18,0), NGUYENGIA_GIAM DECIMAL(18,0),
	GIAM_TL DECIMAL(18,0),GIAM_DC DECIMAL(18,0),GIAM_KHAC DECIMAL(18,0),KH_LUY_KE_TANG_TRONG_KY DECIMAL(18,0),KH_LUY_KE_GIAM_TRONG_KY DECIMAL(18,0), NGUYENGIA_CL_CK DECIMAL(18,0),KH_GIAM_DO_TL DECIMAL(18,0), SUM_VNM DECIMAL(18,0), SUM_CHO_TL DECIMAL(18,0), SUM_HET_KH DECIMAL(18,0), SUM_GTCL_VNM DECIMAL(18,0))
	INSERT INTO @TEMP
	SELECT	
			--row_number() over(order by A.GROUP_ID) AS STT,
			[dbo].[FN_GET_GROUPCODE](A.GROUP_ID,'1')  MANHOM, 
			[dbo].[FN_GET_GROUPNAME](A.GROUP_ID,'1')  NHOM_TS, 
			SUM(ISNULL(NGUYEN_GIA_DK.NGUYEN_GIA_DAU_KI,0)) NGUYEN_GIA_DAU_KY ,
			SUM(ISNULL(KH_LK_DK.KHAU_HAO_LK_DAUKI,0))KH_LUY_KE_DAU_KY,
			 SUM(ISNULL(NG_PS_TANG.NG_PS_TANG_TRONG_KI,0)) NGUYEN_GIA_PS_TANG_TRONG_KY, 
			 SUM(ISNULL(PS_TANG_MUA_TSCD.TANG_MUA_TSCD,0)) TANG_TK_MUA_SAM_TSCD_TRONG_KY	,
			 0 TANG_DC,	
			SUM(ISNULL(PS_UPD_NG_CR.SUM_TANG_NGUYEN_GIA_KHAC,0)) TANG_KHAC_TRONG_KY,
			SUM(ISNULL(NG_PS_GIAM.NG_PS_GIAM_TRONG_KI,0)) NGUYEN_GIA_PS_GIAM_TRONG_KY, 
			SUM(ISNULL(PS_LIQ_NG_DR.SUM_LIQ,0)) NGUYEN_GIA_PS_GIAM_TL ,
			 0 GIAM_DC ,
			 SUM(ISNULL(PS_GIAM_TAISAN_KHAC.SUM_GIAM_NGUYEN_GIA_KHAC,0)) GIAM_KHAC, 
			SUM(ISNULL(PS_FROM_KH.KH_LK_TANG_TK,0)) KH_LUY_KE_TANG_TRONG_KY ,
			SUM(ISNULL(PS_TO_KH.KH_LK_GIAM_TK,0)) KH_LUY_KE_GIAM_TRONG_KY, --KH luy ke giam trong ky
			SUM(ISNULL(NG_CK.SUM_CK_NG,0)) - SUM(ISNULL(KH_CK.KHAU_HAO_CUOI_KI,0)) AS NGUYENGIA_CL_CK,
			SUM(ISNULL(KH_DO_TL.KH_LK_GIAM_THANH_LY,0)) KH_GIAM_DO_TL,
			SUM(ISNULL(NG_CK_VNM.SUM_CK_NG_VNM,0))SUM_VNM,
			SUM(ISNULL(NG_CK_CTL.SUM_CK_NG_CTL,0)) SUM_CHO_TL,
			SUM(ISNULL(NG_CK_KHX.SUM_CK_NG_KHX,0)) SUM_HET_KH,
			SUM( ISNULL(NG_CK_VNM.SUM_CK_NG_VNM,0)- ISNULL(KH_CK_VNM.KHAU_HAO_CUOI_KI_VNM,0)) SUM_GTCL_VNM
	FROM ASS_GROUP A
	-- NGUYÊN GIÁ ĐẦU KÌ < FROME_DATE
	LEFT JOIN
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'D' THEN -AV.ASSET_AMT ELSE AV.ASSET_AMT END) NGUYEN_GIA_DAU_KI
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
		WHERE (AV.TRN_DT < CONVERT(date, @p_FromDate, 103))
		GROUP BY AM.GROUP_ID	
	) NGUYEN_GIA_DK ON NGUYEN_GIA_DK.GROUP_ID = A.GROUP_ID 
	-- CÔNG THỨC TÍNH NGUYÊN GIÁ Ở CUỐI KÌ = TODATE()
	LEFT JOIN
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'D' THEN -AV.ASSET_AMT ELSE AV.ASSET_AMT END) SUM_CK_NG
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID		
		WHERE (AV.TRN_DT <= CONVERT(date, @p_Todate, 103))
		GROUP BY AM.GROUP_ID	
	) NG_CK ON NG_CK.GROUP_ID = A.GROUP_ID 
	--  NGUYÊN GIÁ CUỐI KÌ ĐỐI VỚI TÀI SẢN VNM
	LEFT JOIN
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'D' THEN -AV.ASSET_AMT ELSE AV.ASSET_AMT END) SUM_CK_NG_VNM
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID		
		WHERE (AV.TRN_DT <= CONVERT(date, @p_Todate, 103))
		AND AM.AMORT_STATUS='VNM'
		GROUP BY AM.GROUP_ID	
	) NG_CK_VNM ON NG_CK_VNM.GROUP_ID = A.GROUP_ID 
	--  NGUYÊN GIÁ CUỐI KÌ ĐỐI VỚI TÀI SẢN KHX
	LEFT JOIN
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'D' THEN -AV.ASSET_AMT ELSE AV.ASSET_AMT END) SUM_CK_NG_KHX
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
		WHERE (AV.TRN_DT <= CONVERT(date, @p_Todate, 103))
		AND AM.AMORT_STATUS='KHX'
		GROUP BY AM.GROUP_ID	
	) NG_CK_KHX ON NG_CK_KHX.GROUP_ID = A.GROUP_ID 
	--  NGUYÊN GIÁ CUỐI KÌ ĐỐI VỚI TÀI SẢN CHỜ THANH LÝ
	LEFT JOIN
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'D' THEN -AV.ASSET_AMT ELSE AV.ASSET_AMT END) SUM_CK_NG_CTL
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID	
		WHERE (AV.TRN_DT <= CONVERT(date, @p_Todate, 103))
    AND AM.AMORT_STATUS <> 'VNM' AND AM.AMORT_STATUS <> 'KHX'
		GROUP BY AM.GROUP_ID	
	) NG_CK_CTL ON NG_CK_CTL.GROUP_ID = A.GROUP_ID 
	--- CÔNG THỨC TÍNH KHẤU HAO LŨY KẾ TẠI THỜI ĐIỂM HIỆN TẠI
	LEFT JOIN
	( 
		SELECT AM.GROUP_ID, SUM(CASE WHEN AMD.CRDR = 'C' THEN AMD.AMORT_AMT ELSE -AMD.AMORT_AMT END) SUM_CK_KH
		FROM ASS_AMORT_DT AMD
		INNER JOIN ASS_MASTER AM ON AMD.ASSET_ID = AM.ASSET_ID
		GROUP BY AM.GROUP_ID	
	) CK_KH ON CK_KH.GROUP_ID = A.GROUP_ID
	--- CÔNG THỨC TÍNH NGUYÊN GIÁ PHÁT SINH TĂNG TRONG KỲ TỪ FROMDATE DATE ĐẾN GETDATE()
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'C' THEN AV.ASSET_AMT ELSE 0 END) NG_PS_TANG_TRONG_KI
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
			
		WHERE AV.TRN_DT >= CONVERT(date, @p_FromDate, 103)  AND AV.TRN_DT <= CONVERT(date, @p_Todate, 103)
		GROUP BY AM.GROUP_ID	
	) NG_PS_TANG ON NG_PS_TANG.GROUP_ID = A.GROUP_ID
	--- CÔNG THỨC TÍNH NGUYÊN GIÁ PHÁT SINH GIẢM TRONG KỲ TỪ FROMDATE DATE ĐẾN GETDATE()
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'D' THEN AV.ASSET_AMT ELSE 0 END) NG_PS_GIAM_TRONG_KI
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
			
		WHERE AV.TRN_DT >= CONVERT(date, @p_FromDate, 103)  AND AV.TRN_DT <= CONVERT(date, @p_Todate, 103)
		 
		GROUP BY AM.GROUP_ID	
	) NG_PS_GIAM ON NG_PS_GIAM.GROUP_ID = A.GROUP_ID
	-- CÔNG THỨC TÍNH KHẤU HAO ĐẦU KỲ
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AMD.CRDR = 'C' THEN AMD.AMORT_AMT ELSE -AMD.AMORT_AMT END) KHAU_HAO_LK_DAUKI
		FROM ASS_AMORT_DT AMD
		INNER JOIN ASS_MASTER AM ON AMD.ASSET_ID = AM.ASSET_ID
		LEFT JOIN --LAY DON VI CU NHAT
		(
			SELECT A.ASSET_ID, A.BRANCH_ID, A.DEPT_ID, A.EMP_ID		
			FROM ASS_LOCATION_HIST A		
			INNER JOIN
			(
				SELECT MAX(B.LOCHIST_ID) AS LOCHIST_ID, B.ASSET_ID
				FROM ASS_LOCATION_HIST B 
				WHERE B.USE_START_DT <= CONVERT(DATE,@p_Fromdate,103)
				GROUP BY B.ASSET_ID
			) AS TRN ON TRN.LOCHIST_ID = A.LOCHIST_ID		
		) AS TRN ON TRN.ASSET_ID = AM.ASSET_ID		
		WHERE AMD.AMORT_DT < CONVERT(date, @p_FromDate, 103) AND AMD.EXECUTED='1'
		 
		GROUP BY AM.GROUP_ID	
	) KH_LK_DK ON KH_LK_DK.GROUP_ID = A.GROUP_ID
	-- CÔNG THỨC TÍNH KHẤU HAO CUỐI KÌ
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AMD.CRDR = 'C' THEN AMD.AMORT_AMT ELSE -AMD.AMORT_AMT END) KHAU_HAO_CUOI_KI
		FROM ASS_AMORT_DT AMD
		INNER JOIN ASS_MASTER AM ON AMD.ASSET_ID = AM.ASSET_ID
			
		WHERE AMD.AMORT_DT <= CONVERT(date, @p_Todate, 103) AND AMD.EXECUTED='1'
		 
		GROUP BY AM.GROUP_ID	
	) KH_CK ON KH_CK.GROUP_ID = A.GROUP_ID
	-- CÔNG THỨC TÍNH KHẤU HAO CUỐI KÌ ĐỐI VỚI TÀI SẢN VỪA NHẬP MỚI
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AMD.CRDR = 'C' THEN AMD.AMORT_AMT ELSE -AMD.AMORT_AMT END) KHAU_HAO_CUOI_KI_VNM
		FROM ASS_AMORT_DT AMD
		INNER JOIN ASS_MASTER AM ON AMD.ASSET_ID = AM.ASSET_ID
			
		WHERE AMD.AMORT_DT <= CONVERT(date, @p_Todate, 103) AND AMD.EXECUTED='1' AND AM.AMORT_STATUS ='VNM'
		 
		GROUP BY AM.GROUP_ID	
	) KH_CK_VNM ON KH_CK_VNM.GROUP_ID = A.GROUP_ID
	-- CÔNG THỨC TÍNH PHÁT SINH GIẢM NGUYÊN GIÁ TỪ NGÀY ĐẾN HIỆN TẠI
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'D' THEN AV.ASSET_AMT ELSE 0 END) SUM_FROM
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
			
		WHERE AV.TRN_DT >= CONVERT(date, @p_FromDate, 103) 
		 
		GROUP BY AM.GROUP_ID	
	) PS_FROM_NG_DR ON PS_FROM_NG_DR.GROUP_ID = A.GROUP_ID	
	-- CÔNG THỨC TÍNH PHÁT SINH TĂNG NGUYÊN GIÁ ĐẾN HIỆN TẠI
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'C' THEN AV.ASSET_AMT ELSE 0 END) SUM_TO
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
			
		WHERE AV.TRN_DT >= CONVERT(date, @p_ToDate, 103) 
		 
		GROUP BY AM.GROUP_ID	
	) PS_TO_NG_CR ON PS_TO_NG_CR.GROUP_ID = A.GROUP_ID	
	-- NGUYÊN GIÁ PHÁT SINH GIẢM  >= FROME DATE
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(CASE WHEN AV.CRDR = 'D' THEN AV.ASSET_AMT ELSE 0 END) SUM_TO
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
			
		WHERE AV.TRN_DT >= CONVERT(date, @p_ToDate, 103) 
		 
		GROUP BY AM.GROUP_ID	
	) PS_TO_NG_DR ON PS_TO_NG_DR.GROUP_ID = A.GROUP_ID
	-- GIẢM NGUYÊN GIÁ PHÁT SINH TRONG KÌ VÌ LÝ DO THANH LÝ TS
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(AV.ASSET_AMT) SUM_LIQ
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
			
		WHERE AV.TRN_DT >= CONVERT(date, @p_FromDate, 103) 
			AND AV.TRN_DT <= CONVERT(date, @p_ToDate, 103) 
			AND AV.CRDR='D'
			AND AV.TRN_TYPE = 'ASS_LIQ'
			 
		GROUP BY AM.GROUP_ID	
	) PS_LIQ_NG_DR ON PS_LIQ_NG_DR.GROUP_ID = A.GROUP_ID
	-- GIẢM NGUYÊN GIÁ VÌ LÝ DO KHÁC - Ở ĐÂY LÀ KHÁC ĐIỀU CHUYỂN, THANH LÝ
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(AV.ASSET_AMT) SUM_GIAM_NGUYEN_GIA_KHAC
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
			
		WHERE AV.TRN_DT >= CONVERT(date, @p_FromDate, 103) 
			AND AV.TRN_DT <= CONVERT(date, @p_ToDate, 103) 
			AND AV.CRDR='D'
			AND AV.TRN_TYPE NOT IN ('ASS_TRANSFER','ASS_LIQ')
			 
		GROUP BY AM.GROUP_ID	
	) PS_GIAM_TAISAN_KHAC ON PS_LIQ_NG_DR.GROUP_ID = A.GROUP_ID
	-- NGUYÊN GIÁ PHÁT SINH TĂNG DO ĐIỀU CHỈNH GIÁ TÀI SẢN, VÀ MỘT SỐ LÝ DO KHÁC NHẬP MỚI, KHÁC THANH LÝ
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(AV.ASSET_AMT) SUM_TANG_NGUYEN_GIA_KHAC
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
			
		WHERE AV.TRN_DT >= CONVERT(date, @p_FromDate, 103) 
			AND AV.TRN_DT <= CONVERT(date, @p_ToDate, 103) 
			AND AV.CRDR='C'
			AND AV.TRN_TYPE NOT IN ('ASS_ADDNEW','ASS_LIQ')
			 
		GROUP BY AM.GROUP_ID	
	) PS_UPD_NG_CR ON PS_UPD_NG_CR.GROUP_ID = A.GROUP_ID	
	-- NGUYÊN GIÁ PHÁT SINH TĂNG DO NHẬP MỚI TÀI SẢN
	LEFT JOIN 
	(
		SELECT AM.GROUP_ID, SUM(AV.ASSET_AMT) TANG_MUA_TSCD
		FROM ASS_VALUES AV
		INNER JOIN ASS_MASTER AM ON AV.ASSET_ID = AM.ASSET_ID
			
		WHERE AV.TRN_DT >= CONVERT(date, @p_FromDate, 103) 
			AND AV.TRN_DT <= CONVERT(date, @p_ToDate, 103) 
			AND AV.CRDR='C'
			AND AV.TRN_TYPE = 'ASS_ADDNEW'
			 
		GROUP BY AM.GROUP_ID	
	) PS_TANG_MUA_TSCD ON PS_TANG_MUA_TSCD.GROUP_ID = A.GROUP_ID
	--- KHẤU HAO LŨY KẾ TĂNG TRONG KỲ				
	LEFT JOIN
	(
		SELECT AM.GROUP_ID, SUM(AMD.AMORT_AMT) KH_LK_TANG_TK
		FROM ASS_AMORT_DT AMD
		INNER JOIN ASS_MASTER AM ON AM.ASSET_ID = AMD.ASSET_ID
			
		WHERE AMD.AMORT_DT >= CONVERT(date, @p_FromDate, 103) AND AMD.EXECUTED='1'
		AND  AMD.AMORT_DT <= CONVERT(date, @p_Todate, 103)
		AND AMD.CRDR ='C'
		 
		GROUP BY AM.GROUP_ID
	) PS_FROM_KH ON PS_FROM_KH.GROUP_ID = A.GROUP_ID
	-- KHẤU HAO LŨY KẾ GIẢM TRONG KỲ
	LEFT JOIN
	(
		SELECT AM.GROUP_ID, SUM(AMD.AMORT_AMT) KH_LK_GIAM_TK
		FROM ASS_AMORT_DT AMD
		INNER JOIN ASS_MASTER AM ON AM.ASSET_ID = AMD.ASSET_ID
			
		WHERE AMD.AMORT_DT >= CONVERT(date, @p_FromDate, 103) AND AMD.EXECUTED='1'
		AND  AMD.AMORT_DT <= CONVERT(date, @p_Todate, 103)
		AND AMD.CRDR ='D'
		 
		GROUP BY AM.GROUP_ID
	) PS_TO_KH ON PS_TO_KH.GROUP_ID = A.GROUP_ID
	-- GIẢM KHẤU HAO DO THANH LÝ TÀI SẢN THANH LY TSCD - CCLD
		LEFT JOIN
	(
		SELECT AM.GROUP_ID, SUM(AMD.AMORT_AMT) KH_LK_GIAM_THANH_LY
		FROM ASS_AMORT_DT AMD
		INNER JOIN ASS_MASTER AM ON AM.ASSET_ID = AMD.ASSET_ID
			
		WHERE AMD.AMORT_DT >= CONVERT(date, @p_FromDate, 103) AND AMD.EXECUTED='1'
		AND  AMD.AMORT_DT <= CONVERT(date, @p_Todate, 103)
		AND AMD.CRDR ='D' AND TRN_DESC ='THANH LY TSCD - CCLD'
		 
		GROUP BY AM.GROUP_ID
	) KH_DO_TL ON KH_DO_TL.GROUP_ID = A.GROUP_ID
	LEFT JOIN
	(
			SELECT AM.GROUP_ID, SUM(AM.BUY_PRICE) SUM_BUY_PRICE
			FROM ASS_ADDNEW AD 
			
			INNER JOIN ASS_PAYMENT_DT ASP ON ASP.REF_MASTER_ID = AD.PO_ID AND ASP.REF_DETAIL_ID = AD.PD_ID 
			INNER JOIN ASS_PAYMENT_MASTER ASM ON  ASP.PAY_ID = ASM.PAY_ID AND ASM.PAY_TYPE='PO_PAYMENT'
			INNER JOIN ASS_TRANSACTIONS AT ON AT.TRN_ID = AD.ADDNEW_ID
			INNER JOIN ASS_MASTER AM ON AM.ASSET_ID = AT.ASSET_ID
			LEFT JOIN --LAY DON VI CU NHAT
			(
			SELECT A.ASSET_ID, A.BRANCH_ID, A.DEPT_ID, A.EMP_ID		
			FROM ASS_LOCATION_HIST A		
			INNER JOIN
			(
				SELECT MAX(B.LOCHIST_ID) AS LOCHIST_ID, B.ASSET_ID
				FROM ASS_LOCATION_HIST B 
				WHERE B.USE_START_DT <= CONVERT(DATE,@p_Todate,103)
				GROUP BY B.ASSET_ID
			) AS TRN ON TRN.LOCHIST_ID = A.LOCHIST_ID		
		) AS TRN ON TRN.ASSET_ID = AM.ASSET_ID		
			INNER JOIN
			(
				SELECT *
				FROM ASS_VALUES 
				WHERE TRN_TYPE IN ('ASS_ADDNEW','ASS_USE')
			) AV ON AV.ASSET_ID = AM.ASSET_ID
			WHERE AD.AUTH_STATUS='A' AND AD.RECORD_STATUS='1' AND ASM.ACC='VN012333122'
				AND AV.TRN_DT >= CONVERT(date, @p_FromDate, 103) 
				AND AV.TRN_DT <= CONVERT(date, @p_ToDate, 103) 
				
			GROUP BY AM.GROUP_ID
				
	) T3210 ON T3210.GROUP_ID = A.GROUP_ID
	WHERE A.TYPE_ID = 'TSCD'
	AND A.IS_LEAF = 'Y'
	GROUP BY [dbo].[FN_GET_GROUPCODE](A.GROUP_ID,'1'),[dbo].[FN_GET_GROUPNAME](A.GROUP_ID,'1')

	INSERT INTO @TEMP_RETURN VALUES ((N'Vào ngày '+ CONVERT(NVARCHAR(10), @p_Fromdate)),(SELECT NGUYENGIA_DK FROM @TEMP WHERE MANHOM ='12'),(SELECT NGUYENGIA_DK FROM @TEMP WHERE MANHOM ='13'),(SELECT NGUYENGIA_DK FROM @TEMP WHERE MANHOM ='14'),(SELECT NGUYENGIA_DK FROM @TEMP WHERE MANHOM ='15'),(SELECT NGUYENGIA_DK FROM @TEMP WHERE MANHOM ='19'),
	(SELECT NGUYENGIA_DK FROM @TEMP WHERE MANHOM ='21'),(SELECT NGUYENGIA_DK FROM @TEMP WHERE MANHOM ='24'),(SELECT NGUYENGIA_DK FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(NGUYENGIA_DK) FROM @TEMP) ,N'Lấy số trên cân đối năm (1)','Y')
	
	-- TỔNG TĂNG NGUYÊN GIÁ TRONG KỲ

	INSERT INTO @TEMP_RETURN VALUES (N'Tăng trong kì',(SELECT NGUYENGIA_TANG FROM @TEMP WHERE MANHOM ='12'),(SELECT NGUYENGIA_TANG FROM @TEMP WHERE MANHOM ='13'),(SELECT NGUYENGIA_TANG FROM @TEMP WHERE MANHOM ='14'),(SELECT NGUYENGIA_TANG FROM @TEMP WHERE MANHOM ='15'),(SELECT NGUYENGIA_TANG FROM @TEMP WHERE MANHOM ='19'),
	(SELECT NGUYENGIA_TANG FROM @TEMP WHERE MANHOM ='21'),(SELECT NGUYENGIA_TANG FROM @TEMP WHERE MANHOM ='24'),(SELECT NGUYENGIA_TANG FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(NGUYENGIA_TANG) FROM @TEMP),N'Tổng cộng (2)','B')

	-- TRONG ĐÓ

	INSERT INTO @TEMP_RETURN VALUES (N'Trong đó',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B')

	-- TĂNG GIÁ TRỊ DO MUA THÊM TSCD TRONG KÌ

	INSERT INTO @TEMP_RETURN VALUES ((N'  Mua trong kì'),(SELECT TANGTS_MUA FROM @TEMP WHERE MANHOM ='12'),(SELECT TANGTS_MUA FROM @TEMP WHERE MANHOM ='13'),(SELECT TANGTS_MUA FROM @TEMP WHERE MANHOM ='14'),(SELECT TANGTS_MUA FROM @TEMP WHERE MANHOM ='15'),(SELECT TANGTS_MUA FROM @TEMP WHERE MANHOM ='19'),
	(SELECT TANGTS_MUA FROM @TEMP WHERE MANHOM ='21'),(SELECT TANGTS_MUA FROM @TEMP WHERE MANHOM ='24'),(SELECT TANGTS_MUA FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(TANGTS_MUA) FROM @TEMP),N'Phát sinh do mua mới','')

	--TĂNG VÌ CÔNG TRÌNH XÂY DỰNG HOÀN THÀNH
	
	INSERT INTO @TEMP_RETURN VALUES (N'  XDCB hoàn thành',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'Không ghi','')

	-- TĂNG VÌ ĐÁNH GIÁ LẠI GIÁ TRỊ TÀI SẢN

	INSERT INTO @TEMP_RETURN VALUES (N'  Đánh giá lại',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'Không ghi','')

	-- TĂNG VÌ ĐIỀU CHUYỂN NỘI BỘ

	INSERT INTO @TEMP_RETURN VALUES ((N'  Điều chuyển nội bộ'),(SELECT TANG_DC FROM @TEMP WHERE MANHOM ='12'),(SELECT TANG_DC FROM @TEMP WHERE MANHOM ='13'),(SELECT TANG_DC FROM @TEMP WHERE MANHOM ='14'),(SELECT TANG_DC FROM @TEMP WHERE MANHOM ='15'),(SELECT TANG_DC FROM @TEMP WHERE MANHOM ='19'),
	(SELECT TANG_DC FROM @TEMP WHERE MANHOM ='21'),(SELECT TANG_DC FROM @TEMP WHERE MANHOM ='24'),(SELECT TANG_DC FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(TANG_DC) FROM @TEMP),N'Phát sinh do điều chuyển','')

	-- TĂNG VÌ NGUYÊN NHÂN KHÁC
	
	INSERT INTO @TEMP_RETURN VALUES ((N'  Nguyên nhân khác'),(SELECT TANG_KHAC FROM @TEMP WHERE MANHOM ='12'),(SELECT TANG_KHAC FROM @TEMP WHERE MANHOM ='13'),(SELECT TANG_KHAC FROM @TEMP WHERE MANHOM ='14'),(SELECT TANG_KHAC FROM @TEMP WHERE MANHOM ='15'),(SELECT TANG_KHAC FROM @TEMP WHERE MANHOM ='19'),
	(SELECT TANG_KHAC FROM @TEMP WHERE MANHOM ='21'),(SELECT TANG_KHAC FROM @TEMP WHERE MANHOM ='24'),(SELECT TANG_KHAC FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(TANG_KHAC) FROM @TEMP),N'Phát sinh do chuyển nhóm, điều chỉnh','')
	
	 -- TỔNG GIÁ TRỊ GIẢM TRONG KỲ
	
     INSERT INTO @TEMP_RETURN VALUES (N'Giảm trong kì',(SELECT NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='12'),(SELECT NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='13'),(SELECT NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='14'),(SELECT NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='15'),(SELECT NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='19'),
	(SELECT NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='21'),(SELECT NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='24'),(SELECT NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(NGUYENGIA_GIAM) FROM @TEMP),N'Tổng cộng (3)','B')
	
	--TRONG ĐÓ

	INSERT INTO @TEMP_RETURN VALUES (N'Trong đó',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B')
	
	--THANH LÝ, NHƯỢNG BÁN

	 INSERT INTO @TEMP_RETURN VALUES (N'  Thanh lý nhượng bán',(SELECT GIAM_TL FROM @TEMP WHERE MANHOM ='12'),(SELECT GIAM_TL FROM @TEMP WHERE MANHOM ='13'),(SELECT GIAM_TL FROM @TEMP WHERE MANHOM ='14'),(SELECT GIAM_TL FROM @TEMP WHERE MANHOM ='15'),(SELECT GIAM_TL FROM @TEMP WHERE MANHOM ='19'),
	(SELECT GIAM_TL FROM @TEMP WHERE MANHOM ='21'),(SELECT GIAM_TL FROM @TEMP WHERE MANHOM ='24'),(SELECT GIAM_TL FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(GIAM_TL) FROM @TEMP),N'Phát sinh do thanh lý','')
	
	-- ĐIỀU CHUYỂN NỘI BỘ

	 INSERT INTO @TEMP_RETURN VALUES (N'  Điều chuyển nội bộ',(SELECT GIAM_DC FROM @TEMP WHERE MANHOM ='12'),(SELECT GIAM_DC FROM @TEMP WHERE MANHOM ='13'),(SELECT GIAM_DC FROM @TEMP WHERE MANHOM ='14'),(SELECT GIAM_DC FROM @TEMP WHERE MANHOM ='15'),(SELECT GIAM_DC FROM @TEMP WHERE MANHOM ='19'),
	(SELECT GIAM_DC FROM @TEMP WHERE MANHOM ='21'),(SELECT GIAM_DC FROM @TEMP WHERE MANHOM ='24'),(SELECT GIAM_DC FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(GIAM_DC) FROM @TEMP),N'Phát sinh do điều chuyển','')
	
	-- NGUYÊN NHÂN KHÁC

	 INSERT INTO @TEMP_RETURN VALUES (N'  Nguyên nhân khác',(SELECT GIAM_KHAC FROM @TEMP WHERE MANHOM ='12'),(SELECT GIAM_KHAC FROM @TEMP WHERE MANHOM ='13'),(SELECT GIAM_KHAC FROM @TEMP WHERE MANHOM ='14'),(SELECT GIAM_KHAC FROM @TEMP WHERE MANHOM ='15'),(SELECT GIAM_KHAC FROM @TEMP WHERE MANHOM ='19'),
	(SELECT GIAM_KHAC FROM @TEMP WHERE MANHOM ='21'),(SELECT GIAM_KHAC FROM @TEMP WHERE MANHOM ='24'),(SELECT GIAM_KHAC FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(GIAM_KHAC) FROM @TEMP),N'Phát sinh chuyển nhóm, điều chỉnh','')

	-- VÀO NGÀY CUỐI KÌ

	INSERT INTO @TEMP_RETURN VALUES ((N'Vào ngày '+ CONVERT(NVARCHAR(10), @p_Todate)),(SELECT NGUYENGIA_DK +NGUYENGIA_TANG -NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='12'),(SELECT NGUYENGIA_DK +NGUYENGIA_TANG -NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='13'),(SELECT NGUYENGIA_DK +NGUYENGIA_TANG -NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='14'),(SELECT NGUYENGIA_DK +NGUYENGIA_TANG -NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='15'),(SELECT NGUYENGIA_DK +NGUYENGIA_TANG -NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='19'),
	(SELECT NGUYENGIA_DK +NGUYENGIA_TANG -NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='21'),(SELECT NGUYENGIA_DK +NGUYENGIA_TANG -NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='24'),(SELECT NGUYENGIA_DK +NGUYENGIA_TANG -NGUYENGIA_GIAM FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(NGUYENGIA_DK +NGUYENGIA_TANG -NGUYENGIA_GIAM) FROM @TEMP),N'(4) = (1) + (2) - (3)','Y')
	
	-- 	TRONG ĐÓ

	INSERT INTO @TEMP_RETURN VALUES (N'Trong đó',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'Nếu có','B')

	-- CHƯA SỬ DỤNG

	INSERT INTO @TEMP_RETURN VALUES (N'  Chưa sử dụng',(SELECT ISNULL(SUM_VNM,0) FROM @TEMP WHERE MANHOM ='12'),(SELECT ISNULL(SUM_VNM,0) FROM @TEMP WHERE MANHOM ='13'),(SELECT ISNULL(SUM_VNM,0) FROM @TEMP WHERE MANHOM ='14'),(SELECT ISNULL(SUM_VNM,0) FROM @TEMP WHERE MANHOM ='15'),(SELECT ISNULL(SUM_VNM,0) FROM @TEMP WHERE MANHOM ='19'),
	(SELECT ISNULL(SUM_VNM,0) FROM @TEMP WHERE MANHOM ='21'),(SELECT ISNULL(SUM_VNM,0) FROM @TEMP WHERE MANHOM ='24'),(SELECT ISNULL(SUM_VNM,0) FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(ISNULL(SUM_VNM,0)) FROM @TEMP),N'Nếu có','')

	-- HẾT KHẤU HAO

	INSERT INTO @TEMP_RETURN VALUES (N'  Hết khấu hao',(SELECT ISNULL(SUM_HET_KH,0) FROM @TEMP WHERE MANHOM ='12'),(SELECT ISNULL(SUM_HET_KH,0) FROM @TEMP WHERE MANHOM ='13'),(SELECT ISNULL(SUM_HET_KH,0) FROM @TEMP WHERE MANHOM ='14'),(SELECT ISNULL(SUM_HET_KH,0) FROM @TEMP WHERE MANHOM ='15'),(SELECT ISNULL(SUM_HET_KH,0) FROM @TEMP WHERE MANHOM ='19'),
	(SELECT ISNULL(SUM_HET_KH,0) FROM @TEMP WHERE MANHOM ='21'),(SELECT ISNULL(SUM_HET_KH,0) FROM @TEMP WHERE MANHOM ='24'),(SELECT ISNULL(SUM_HET_KH,0) FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(ISNULL(SUM_HET_KH,0)) FROM @TEMP),N'Nếu có','')

	-- CHỜ THANH LÝ

	INSERT INTO @TEMP_RETURN VALUES (N'  Chờ thanh lý',(SELECT ISNULL(SUM_CHO_TL,0) FROM @TEMP WHERE MANHOM ='12'),(SELECT ISNULL(SUM_CHO_TL,0) FROM @TEMP WHERE MANHOM ='13'),(SELECT ISNULL(SUM_CHO_TL,0) FROM @TEMP WHERE MANHOM ='14'),(SELECT ISNULL(SUM_CHO_TL,0) FROM @TEMP WHERE MANHOM ='15'),(SELECT ISNULL(SUM_CHO_TL,0) FROM @TEMP WHERE MANHOM ='19'),
	(SELECT ISNULL(SUM_CHO_TL,0) FROM @TEMP WHERE MANHOM ='21'),(SELECT ISNULL(SUM_CHO_TL,0) FROM @TEMP WHERE MANHOM ='24'),(SELECT ISNULL(SUM_CHO_TL,0) FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(ISNULL(SUM_CHO_TL,0)) FROM @TEMP),N'Nếu có','')

	--KHẤU HAO LŨY KẾ

	INSERT INTO @TEMP_RETURN VALUES (N'Khấu hao lũy kế',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'','B')

	--KHẤU HAO ĐẦU KỲ

	INSERT INTO @TEMP_RETURN VALUES ((N'Vào ngày '+ CONVERT(NVARCHAR(10), @p_Fromdate)),(SELECT KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='12'),(SELECT KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='13'),(SELECT KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='14'),(SELECT KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='15'),(SELECT KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='19'),
	(SELECT KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='21'),(SELECT KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='24'),(SELECT KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(KH_LUY_KE_DAU_KY) FROM @TEMP),N'Lấy số trên cân đối năm (5)','Y')

	-- KHẤU TAO TĂNG TRONG KỲ - TỔNG

	
	INSERT INTO @TEMP_RETURN VALUES ((N'Tăng trong kỳ'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='12'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='13'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='14'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='15'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='19'),
	(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='21'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='24'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(KH_LUY_KE_TANG_TRONG_KY) FROM @TEMP),N'Tổng cộng (6)','B')
	
	-- TRONG ĐÓ

	INSERT INTO @TEMP_RETURN VALUES (N'Trong đó',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B')

	-- CHI PHÍ KHẤU HAO TRONG KỲ - TỔNG
	
	INSERT INTO @TEMP_RETURN VALUES ((N'  Chi phí khấu hao trong kỳ'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='12'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='13'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='14'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='15'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='19'),
	(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='21'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='24'),(SELECT KH_LUY_KE_TANG_TRONG_KY FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(KH_LUY_KE_TANG_TRONG_KY) FROM @TEMP),N'Sổ trích khấu hao trong năm','')

    -- KHẤU HAO TĂNG ĐIỀU CHUYỂN NỘI BỘ

	INSERT INTO @TEMP_RETURN VALUES (N'  Điều chuyển nội bộ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'Phát sinh do điều chuyển nội bộ','')
	
	-- KHẤU HAO TĂNG - NGUYÊN NHÂN KHÁC

	INSERT INTO @TEMP_RETURN VALUES (N'  Nguyên nhân khác',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'Phát sinh do chuyển nhóm, điều chỉnh','')

	-- KHẤU HAO GIẢM - TRONG KỲ - TỔNG

	
	INSERT INTO @TEMP_RETURN VALUES ((N'Giảm trong kỳ'),(SELECT KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='12'),(SELECT KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='13'),(SELECT KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='14'),(SELECT KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='15'),(SELECT KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='19'),
	(SELECT KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='21'),(SELECT KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='24'),(SELECT KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(KH_LUY_KE_GIAM_TRONG_KY) FROM @TEMP),N'Tổng cộng (7)','B')

	-- TRONG ĐÓ

	INSERT INTO @TEMP_RETURN VALUES (N'Trong đó',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B')
	
	-- KHẤU HAO GIẢM - THANH LÝ, NHƯỢNG BÁN

	INSERT INTO @TEMP_RETURN VALUES (N'  Thanh lý, nhượng bán',(SELECT KH_GIAM_DO_TL FROM @TEMP WHERE MANHOM ='12'),(SELECT KH_GIAM_DO_TL FROM @TEMP WHERE MANHOM ='13'),(SELECT KH_GIAM_DO_TL FROM @TEMP WHERE MANHOM ='14'),(SELECT KH_GIAM_DO_TL FROM @TEMP WHERE MANHOM ='15'),(SELECT KH_GIAM_DO_TL FROM @TEMP WHERE MANHOM ='19'),
	(SELECT KH_GIAM_DO_TL FROM @TEMP WHERE MANHOM ='21'),(SELECT KH_GIAM_DO_TL FROM @TEMP WHERE MANHOM ='24'),(SELECT KH_GIAM_DO_TL FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(KH_GIAM_DO_TL) FROM @TEMP),N'Phát sinh do thanh lý','')

	-- KHẤU HAO GIẢM - ĐIỀU CHUYỂN NỘI BỘ

	INSERT INTO @TEMP_RETURN VALUES (N'  Điều chuyển nội bộ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'Phát sinh do điều chuyển','')

	-- KHẤU HAO GIẢM - NGUYÊN NHÂN KHÁC

	INSERT INTO @TEMP_RETURN VALUES (N'  Nguyên nhân khác',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'Phát sinh do chuyển nhóm, điều chỉnh','')

    -- CÒN LẠI ĐẾN NGÀY

	INSERT INTO @TEMP_RETURN VALUES ((N'Vào ngày ' + CONVERT(NVARCHAR(10),@p_Todate)),(SELECT KH_LUY_KE_DAU_KY +KH_LUY_KE_TANG_TRONG_KY - KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='12'),(SELECT KH_LUY_KE_DAU_KY +KH_LUY_KE_TANG_TRONG_KY - KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='13'),(SELECT KH_LUY_KE_DAU_KY +KH_LUY_KE_TANG_TRONG_KY - KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='14'),(SELECT KH_LUY_KE_DAU_KY +KH_LUY_KE_TANG_TRONG_KY - KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='15'),(SELECT KH_LUY_KE_DAU_KY +KH_LUY_KE_TANG_TRONG_KY - KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='19'),
	(SELECT KH_LUY_KE_DAU_KY +KH_LUY_KE_TANG_TRONG_KY - KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='21'),(SELECT KH_LUY_KE_DAU_KY +KH_LUY_KE_TANG_TRONG_KY - KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='24'),(SELECT KH_LUY_KE_DAU_KY +KH_LUY_KE_TANG_TRONG_KY - KH_LUY_KE_GIAM_TRONG_KY FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(KH_LUY_KE_DAU_KY +KH_LUY_KE_TANG_TRONG_KY - KH_LUY_KE_GIAM_TRONG_KY) FROM @TEMP),N'(8) = (5) + (6) - (7)','Y')
	
	-- GIÁ TRỊ CÒN LẠI

	INSERT INTO @TEMP_RETURN VALUES (N'Giá trị còn lại',0,0,0,0,0,0,0,0,0,NULL,'B')

	-- VÀO NGÀY FROM_DATE
	 
	 INSERT INTO @TEMP_RETURN VALUES ((N'Vào ngày ' + CONVERT(NVARCHAR(10),@p_Fromdate)),(SELECT NGUYENGIA_DK -KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='12'),(SELECT NGUYENGIA_DK -KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='13'),(SELECT NGUYENGIA_DK -KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='14'),(SELECT NGUYENGIA_DK -KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='15'),(SELECT NGUYENGIA_DK -KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='19'),
	(SELECT NGUYENGIA_DK -KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='21'),(SELECT NGUYENGIA_DK -KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='24'),(SELECT NGUYENGIA_DK -KH_LUY_KE_DAU_KY FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(NGUYENGIA_DK -KH_LUY_KE_DAU_KY) FROM @TEMP),N'(9) = (1) - (5)','Y')

	-- VÀO NGÀY TO_DATE
	 
	 INSERT INTO @TEMP_RETURN VALUES ((N'Vào ngày ' + CONVERT(NVARCHAR(10),@p_Todate)),(SELECT NGUYENGIA_CL_CK FROM @TEMP WHERE MANHOM ='12'),(SELECT NGUYENGIA_CL_CK FROM @TEMP WHERE MANHOM ='13'),(SELECT NGUYENGIA_CL_CK FROM @TEMP WHERE MANHOM ='14'),(SELECT NGUYENGIA_CL_CK FROM @TEMP WHERE MANHOM ='15'),(SELECT NGUYENGIA_CL_CK FROM @TEMP WHERE MANHOM ='19'),
	(SELECT NGUYENGIA_CL_CK FROM @TEMP WHERE MANHOM ='21'),(SELECT NGUYENGIA_CL_CK FROM @TEMP WHERE MANHOM ='24'),(SELECT NGUYENGIA_CL_CK FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(NGUYENGIA_CL_CK) FROM @TEMP),N'(10) = (4) - (8)','Y')

	-- TRONG ĐÓ

	INSERT INTO @TEMP_RETURN VALUES (N'Trong đó',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'B')
	
	-- KHẤU HAO GIẢM - THANH LÝ, NHƯỢNG BÁN

	INSERT INTO @TEMP_RETURN VALUES (N'  Đem đi cầm cố, thế chấp',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'Nếu có','')

	-- KHẤU HAO GIẢM - ĐIỀU CHUYỂN NỘI BỘ

	INSERT INTO @TEMP_RETURN VALUES (N'  Chưa sửa dụng',(SELECT SUM_GTCL_VNM FROM @TEMP WHERE MANHOM ='12'),(SELECT SUM_GTCL_VNM FROM @TEMP WHERE MANHOM ='13'),(SELECT SUM_GTCL_VNM FROM @TEMP WHERE MANHOM ='14'),(SELECT SUM_GTCL_VNM FROM @TEMP WHERE MANHOM ='15'),(SELECT SUM_GTCL_VNM FROM @TEMP WHERE MANHOM ='19'),
	(SELECT SUM_GTCL_VNM FROM @TEMP WHERE MANHOM ='21'),(SELECT SUM_GTCL_VNM FROM @TEMP WHERE MANHOM ='24'),(SELECT SUM_GTCL_VNM FROM @TEMP WHERE MANHOM ='29'),(SELECT SUM(SUM_GTCL_VNM) FROM @TEMP),N'Nếu có','')

	-- KHẤU HAO GIẢM - NGUYÊN NHÂN KHÁC

	INSERT INTO @TEMP_RETURN VALUES (N'  Chờ thanh lý',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,N'Nếu có','')
	-- LAY DATA TRA VE

	SELECT * FROM @TEMP_RETURN
END