根据客户科目余额+库存金额比对信用额度

SELECT A.客户代码,A.客户名称,A.数量,A.参考金额,B.余额 AS 期末本位币金额,A.参考金额+B.余额 as 存货科目合计,A.信用额度  
FROM (SELECT 客户代码,客户名称,信用额度,SUM(数量) AS 数量,SUM(参考金额) AS 参考金额 from 
(SELECT T4.FNumber 客户代码,T4.F_102 信用额度,T4.FName 客户名称,T1.FQty 数量,T1.FQty * T5.FConsignPrice AS 参考金额
 ,T2.FNumber 物料号,T3.FNumber 仓库代码,T3.FName 仓库名称
 FROM ICInventory T1 join t_ICItem T2 on T1.FItemID=T2.FItemID AND T1.FQty>0 
 join t_Stock T3 ON T1.FStockID=T3.FItemID
 join t_Organization T4 ON T3.F_106=T4.FItemID 
 join (SELECT a.FNumber,a.FSupplyID,a.FConsignPrice,max(a.FEntryID) AS 序号 FROM vwICBill_8 a inner join 
 (SELECT FNumber,FSupplyID,max(Fdate) AS fdate FROM vwICBill_8 GROUP BY FNumber,FSupplyID) b 
 oN a.Fdate=b.fdate and a.FNumber=b.FNumber AND A.FSupplyID=B.FSupplyID GROUP BY 
 a.FNumber,a.FSupplyID,a.FConsignPrice) T5 ON T2.FNumber=T5.FNumber AND T4.FName=T5.FSupplyID
 WHERE T4.FNumber<>'0000') A GROUP BY 客户代码,客