销售出库单源单选择销售订单时,软件卡死
金蝶云社区-kishi
kishi
0人赞赏了该文章 605次浏览 未经作者许可,禁止转载编辑于2016年07月19日 17:31:05

做红字销售出库单,在没有选购货单位的情况下,直接点开选单号,点过滤中,录入订单单号查询条件,时间改为全部,点确定,金蝶就会死机

选单是的过滤界面如下设置

做SQL查询跟踪发现以下语句执行超过10分钟依然没有结果,请问该问题应该怎么解决
Select top 20000 (u1.FQty-u1.FAllHookQTY) as FHookQTY,v1.FTranType as FTranType,v1.FInterID as FInterID,u1.FEntryID as FEntryID,u1.Fauxqty as Fauxqty,u1.Famount as Famount,
t14.FQtyDecimal as FQtyDecimal,t14.FPriceDecimal as FPriceDecimal,u1.FConsignAmount as FConsignAmount,u1.FSecQty as FSecQty
from ICStockBill v1 INNER JOIN ICStockBillEntry u1 ON v1.FInterID = u1.FInterID AND u1.FInterID <>0
INNER JOIN t_Organization t4 ON v1.FSupplyID = t4.FItemID AND t4.FItemID <>0
INNER JOIN t_Stock t8 ON u1.FDCStockID = t8.FItemID AND t8.FItemID <>0
INNER JOIN t_ICItem t14 ON u1.FItemID = t14.FItemID AND t14.FItemID <>0
INNER JOIN t_MeasureUnit t17 ON u1.FUnitID = t17.FItemID AND t17.FItemID <>0
INNER JOIN t_MeasureUnit t30 ON t14.FUnitID = t30.FItemID AND t30.FItemID <>0
LEFT OUTER JOIN ICVoucherTpl t16 ON v1.FPlanVchTplID = t16.FInterID AND t16.FInterID <>0
LEFT OUTER JOIN ICVoucherTpl t13 ON v1.FActualVchTplID = t13.FInterID AND t13.FInterID <>0
LEFT OUTER JOIN t_Department t105 ON v1.FDeptID = t105.FItemID AND t105.FItemID <>0
LEFT OUTER JOIN t_Emp t106 ON v1.FEmpID = t106.FItemID AND t106.FItemID <>0
LEFT OUTER JOIN t_MeasureUnit t500 ON t14.FStoreUnitID = t500.FItemID AND t500.FItemID <>0
LEFT OUTER JOIN t_Currency t503 ON v1.FCurrencyID = t503.FCurrencyID AND t503.FCurrencyID <>0
LEFT OUTER JOIN ZPStockBill t523 ON v1.FInterID = t523.FRelateBillInterID AND t523.FRelateBillInterID <>0
LEFT OUTER JOIN t_MeasureUnit t552 ON t14.FSecUnitID = t552.FItemID AND t552.FItemID <>0
LEFT OUTER JOIN t_Organization t44 ON v1.FConsignee = t44.FItemID AND t44.FItemID<>0
where 1=1 AND (
ISNULL(u1.FOrderBillNo,'') = '1606610987'
) AND (v1.FTranType=21 AND ((v1.FROB = 1 AND v1.FStatus in(1, 2) AND u1.FQty>u1.FCommitQty AND (t14.FWthDrwChkMde = 352
OR (SELECT FVALUE FROM t_SystemProfile WHERE FCategory = 'IC' AND FKey = 'AllowNoCheckForCheckItem')=1))) AND ((v1.FCheckerID>0)))