select gl.ccus_id 客户编码, gl.cexch_name 币种, gl.cbegind_c 金额期初方向,
(case when gl.cbegind_c = '借' then SUM(ISNULL(gl.mb, 0)) + SUM(ISNULL(ap.iAmount_f,0)) - SUM(ISNULL(dts.iQuantity * dts.iTaxUnitPrice, 0)) else sum(isnull(-gl.mb, 0)) + SUM(ISNULL(ap.iAmount_f,0)) - SUM(ISNULL(dts.iQuantity * dts.iTaxUnitPrice, 0)) end ) 期初余额,
gl.iyear 年, gl.iYPeriod 年月
from GL_accass gl --辅助总账
left join Ap_CloseBill ap on ap.cDwCode = gl.ccus_id and LEFT(ap.dVouchDate, 6) = gl.iYPeriod --收付款
left join DispatchList dt on dt.cCusCode = gl.ccus_id and LEFT(dt.dDate, 6) = gl.iYPeriod --发退货主表
left join DispatchLists dts on dts.DLID = dt.DLID --发退货子表
where ap.cDigest = '收货款' and gl.iyear = '2015'
group by
gl.ccus_id, gl.ccus_id, gl.cexch_name, gl.cbegind_c, gl.iyear , gl.iYPeriod
消息 245,级别 16,状态 1,第 1 行
在将 varchar 值 '11 21 ' 转换成数据类型 int 时失败。
求高手解决问题。谢谢。