收料通知/请检单序时薄查询单据时显示空白
金蝶云社区-nctime
nctime
0人赞赏了该文章 632次浏览 未经作者许可,禁止转载编辑于2017年01月13日 23:44:37

收料通知/请检单序时薄查询单据时显示空白,双击却能显示单据内容


用SQL跟踪器发现报错了,报错语句:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
select top 40
v1.FBillNo+'['+t15.FNumber+']' AS FBillNoItemNumber,
v1.FBillNo+'['+CONVERT(VARCHAR(255),u1.FEntryID)+']' AS FBillNoEntryID,
v1.FTranType AS FTranType,
v1.FCheckerID AS FCheckerID,
v1.FInterID AS FInterID,
u1.FEntryID AS FEntryID,
v1.Fdate AS Fdate,
t4.FName AS FSupplyIDName,
v1.FBillNo AS FBillNo,
t103.FName AS FBizType,
t_SWW.FName AS FWWType,
case when v1.FCheckerID>0 then 'Y' when v1.FCheckerID<0 then 'Y' else '' end AS FCheck,
case when v1.FStatus=3 then 'Y' else '' end AS FClose,
t10.FName AS FDeptIDName,
t11.FName AS FEmpIDName,
t13.FName AS FCurrencyIDName,
t15.Fname AS FItemName,
t15.Fmodel AS FItemModel,
t18.FName AS FUnitIDName,
u1.Fauxqty AS Fauxqty,
u1.Fauxprice AS Fauxprice,
u1.Famount AS Famount,
t19.FName AS FBaseUnitID,
left('Y',v1.FChildren) AS FReStatus,
case when v1.FCancellation=1 then 'Y' else '' end AS FCancellation,
t15.FQtyDecimal AS FQtyDecimal,
t15.FPriceDecimal AS FPriceDecimal,
t15.FNumber AS FFullNumber,
Case WHEN t15.FOrderUnitID=0 THEN '' Else t500.FName end AS FCUUnitName,
Case When v1.FCurrencyID is Null Or v1.FCurrencyID='' then (Select FScale From t_Currency Where FCurrencyID=1) else t503.FScale end AS FAmountDecimal,
t505.FName AS FSecUnitName,
u1.FSecCoefficient AS FSecCoefficient,
u1.FSecQty AS FSecQty,
t171.FName AS FCheckMethod,
u1.FAuxQtyPass AS FAuxQtyPass,
v1.FPrintCount AS FPrintCount from POInstock v1 INNER JOIN POInstockEntry u1 ON v1.FInterID = u1.FInterID AND u1.FInterID <>0
LEFT OUTER JOIN t_Supplier t4 ON v1.FSupplyID = t4.FItemID AND t4.FItemID <>0
LEFT OUTER JOIN t_Department t10 ON v1.FDeptID = t10.FItemID AND t10.FItemID <>0
LEFT OUTER JOIN t_Emp t11 ON v1.FEmpID = t11.FItemID AND t11.FItemID <>0
INNER JOIN t_Currency t13 ON v1.FCurrencyID = t13.FCurrencyID AND t13.FCurrencyID <>0
INNER JOIN t_ICItem t15 ON u1.FItemID = t15.FItemID AND t15.FItemID <>0
INNER JOIN t_MeasureUnit t18 ON u1.FUnitID = t18.FItemID AND t18.FItemID <>0
LEFT OUTER JOIN t_MeasureUnit t19 ON t15.FUnitID = t19.FMeasureUnitID AND t19.FMeasureUnitID <>0
LEFT OUTER JOIN t_MeasureUnit t500 ON t15.FOrderUnitID = t500.FItemID AND t500.FItemID <>0
LEFT OUTER JOIN t_Currency t503 ON v1.FCurrencyID = t503.FCurrencyID AND t503.FCurrencyID <>0
LEFT OUTER JOIN t_MeasureUnit t505 ON t15.FSecUnitID = t505.FItemID AND t505.FItemID <>0
LEFT OUTER JOIN t_Submessage t103 ON v1.FBizType = t103.FInterID AND t103.FInterID<>0
LEFT OUTER JOIN t_Submessage t_SWW ON v1.FWWType = t_SWW.FInterID AND t_SWW.FInterID<>0
LEFT OUTER JOIN t_SubMessage t171 ON u1.FCheckMethod = t171.FInterID AND t171.FInterID<>0
where (v1.FInterID=10480 and u1.FEntryID=1) or (v1.FInterID=10480 and u1.FEntryID=2) or (v1.FInterID=10480 and u1.FEntryID=3) or (v1.FInterID=10480 and u1.FEntryID=4) order by v1.FInterID,u1.FEntryID