我BOM子项中有个等级品。在用生产任务单下推生成产品入库时。注：FAuxPrice在入库单中是单价。请问要如何解决

问题解决了吗？怎么解决的？

SET NOCOUNT ON
SELECT 0 AS FF18733BDFCC144979592626132FD0472,
0 AS FAuxBadQty,
CAST(t4.FPlanPrice AS FLOAT) * CAST(t7.FCoefficient AS FLOAT) AS FAuxPlanPrice,
t4.FUnitGroupID as FItemUnitGroupID,t4.FAuxClassID AS FAuxPropCls,
CASE WHEN t4.FProChkMde=352 THEN CASE WHEN (v1.FAuxQty-v1.FAuxCommitQty)>0 then (v1.FAuxQty-v1.FAuxCommitQty) ELSE 0 END ELSE CASE WHEN (v1.FAuxQtyPass-v1.FAuxCommitQty)>0 then (v1.FAuxQtyPass-v1.FAuxCommitQty) ELSE 0 END END AS FAuxQty,
v1.FAuxQtyForItem,CASE WHEN t4.FProChkMde=352 THEN CASE WHEN (v1.FAuxQty-v1.FAuxCommitQty)>0 then (v1.FAuxQty-v1.FAuxCommitQty) ELSE 0 END ELSE CASE WHEN (v1.FAuxQtyPass-v1.FAuxCommitQty)>0 then (v1.FAuxQtyPass-v1.FAuxCommitQty) ELSE 0 END END AS FAuxQtyMust,
v1.FAuxQtyScrap,0 AS FBadQty,t10.FName AS FBaseUnitName,v1.FGMPBatchNo AS FBatchNo,
v1.FBillNO,1058 AS FChkPassItem,(SELECT FName FROM t_SubMessage WHERE FTypeID = 244 AND FInterID = 1058) AS FChkPassItemName,
(SELECT FID FROM t_SubMessage WHERE FTypeID = 244 AND FInterID = 1058) AS FChkPassItemNumber,
CASE WHEN t5.FTypeID NOT IN (501,502,503,504) THEN t8.FSPID ELSE 0 END AS FDCSPID,
CASE WHEN t5.FTypeID NOT IN (501,502,503,504) THEN t8.FName ELSE '' END AS FDCSPIDName,
CASE WHEN t5.FTypeID NOT IN (501,502,503,504) THEN t8.FNumber ELSE '' END AS FDCSPIDNumber,
CASE WHEN t5.FTypeID NOT IN (501,502,503,504) THEN t4.FDefaultLoc ELSE 0 END AS FDCStockID,
CASE WHEN t5.FTypeID NOT IN (501,502,503,504) THEN t5.FName ELSE '' END AS FDCStockIDName,
CASE WHEN t5.FTypeID NOT IN (501,502,503,504) THEN CASE WHEN (SELECT FValue FROM t_Systemprofile WHERE FCategory='IC' AND FKey='UseShortNumber')='0' THEN t5.FNumber else t5.FShortNumber END ELSE '' END AS FDCStockIDNumber,
v1.FBillNO AS FICMOBillNo,v1.FInterID AS FICMOInterID,v1.FInterID,v1.FItemID,t4.FName AS FMatName,
t4.FNumber as FMatNumber ,t4.Fmodel,v1.FMTONo,t4.FName,v1.FNote,t4.FNumber,v1.FPlanMode,
tPlanMode.FName AS FPlanModeName,tPlanMode.FID AS FPlanModeNumber,0 AS FPPBomEntryID,
t4.FPriceDecimal,CASE '0' WHEN '0' THEN CASE WHEN t4.FProChkMde=352 THEN CASE WHEN (v1.FQty-v1.FCommitQty)>0 then (v1.FQty-v1.FCommitQty) else 0 END else CASE WHEN (v1.FQtyPass-v1.FCommitQty)>0 then (v1.FQtyPass-v1.FCommitQty) else 0 END END else CASE WHEN t4.FProChkMde=352 then CASE WHEN (v1.FQty-v1.FCommitQty)>0 then (v1.FQty-v1.FCommitQty) else 0 END ELSE CASE WHEN (not exists (SELECT a.FInterID FROM ICQCBill a where a.Finstockinterid in (select b.Finterid from QMicmockRequest b WHERE b.FICMOInterID=v1.FInterID ))) THEN CASE WHEN (v1.FQty-v1.FCommitQty)>0 then (v1.FQty-v1.FCommitQty) else 0 END ELSE CASE WHEN (v1.FQtyPass-v1.FCommitQty)>0 then (v1.FQtyPass-v1.FCommitQty) else 0 END END END END AS FQty,
t4.FQtyDecimal,v1.FQtyForItem,v1.FQtyScrap,v1.FSampleBreakAuxQty,v1.FSampleBreakQty,
CASE WHEN t4.FSecCoefficient>0 THEN v1.FSampleBreakQty /t4.FSecCoefficient ELSE (CASE WHEN t501.FCoefficient >0 THEN v1.FSampleBreakQty/t501.FCoefficient ELSE 0 END) END AS FSampleBreakSecQty,
0 AS FSecBadQty,Case When t4.FSecCoefficient>0 Then t4.FSecCoefficient Else t501.FCoefficient End AS FSecCoefficient,
(Case When t4.FSecCoefficient>0 Then (CASE '0' WHEN '0' THEN CASE WHEN t4.FProChkMde=352 THEN CASE WHEN (v1.FQty-v1.FCommitQty)>0 then (v1.FQty-v1.FCommitQty) else 0 END else CASE WHEN (v1.FQtyPass-v1.FCommitQty)>0 then (v1.FQtyPass-v1.FCommitQty) else 0 END END else CASE WHEN t4.FProChkMde=352 then CASE WHEN (v1.FQty-v1.FCommitQty)>0 then (v1.FQty-v1.FCommitQty) else 0 END ELSE CASE WHEN (not exists (SELECT a.FInterID FROM ICQCBill a where a.Finstockinterid in (select b.Finterid from QMicmockRequest b WHERE b.FICMOInterID=v1.FInterID ))) THEN CASE WHEN (v1.FQty-v1.FCommitQty)>0 then (v1.FQty-v1.FCommitQty) else 0 END ELSE CASE WHEN (v1.FQtyPass-v1.FCommitQty)>0 then (v1.FQtyPass-v1.FCommitQty) else 0 END END END END)/t4.FSecCoefficient Else Case When t501.FCoefficient>0 Then (CASE '0' WHEN '0' THEN CASE WHEN t4.FProChkMde=352 THEN CASE WHEN (v1.FQty-v1.FCommitQty)>0 then (v1.FQty-v1.FCommitQty) else 0 END else CASE WHEN (v1.FQtyPass-v1.FCommitQty)>0 then (v1.FQtyPass-v1.FCommitQty) else 0 END END else CASE WHEN t4.FProChkMde=352 then CASE WHEN (v1.FQty-v1.FCommitQty)>0 then (v1.FQty-v1.FCommitQty) else 0 END ELSE CASE WHEN (not exists (SELECT a.FInterID FROM ICQCBill a where a.Finstockinterid in (select b.Finterid from QMicmockRequest b WHERE b.FICMOInterID=v1.FInterID ))) THEN CASE WHEN (v1.FQty-v1.FCommitQty)>0 then (v1.FQty-v1.FCommitQty) else 0 END ELSE CASE WHEN (v1.FQtyPass-v1.FCommitQty)>0 then (v1.FQtyPass-v1.FCommitQty) else 0 END END END END)/t501.FCoefficient Else 0 End End) AS FSecQty,
CASE WHEN t4.FSecCoefficient>0 THEN v1.FQtyForItem /t4.FSecCoefficient ELSE (CASE WHEN t501.FCoefficient >0 THEN v1.FQtyForItem/t501.FCoefficient ELSE 0 END) END AS FSecQtyForItem,
CASE WHEN t4.FSecCoefficient>0 THEN v1.FQtyScrap /t4.FSecCoefficient ELSE (CASE WHEN t501.FCoefficient >0 THEN v1.FQtyScrap/t501.FCoefficient ELSE 0 END) END AS FSecQtyScrap,
t501.FName AS FSecUnitName,v1.FSelDiscardStockInAuxQty,v1.FSelDiscardStockInQty,
CASE WHEN t4.FSecCoefficient>0 THEN v1.FSelDiscardStockInQty /t4.FSecCoefficient ELSE (CASE WHEN t501.FCoefficient >0 THEN v1.FSelDiscardStockInQty/t501.FCoefficient ELSE 0 END) END AS FSelDiscardStockInSecQty,
v1.FTranType AS FSelTranTypeID,(SELECT FName FROM v_ICTransType WHERE FID=v1.FTranType) AS FSelTranTypeName,
(SELECT FName FROM v_ICTransType WHERE FID=v1.FTranType) AS FSelTranTypeNumber,
v1.FBillNO AS FSourceBillNo,0 AS FSourceEntryID,v1.FInterID AS FSourceInterID,v1.FTranType AS FSourceTranType,
t4.FTrack,v1.FUnitID,t7.FName AS FUnitName,t7.FNumber AS FUnitNumber,v1.FWorkShop,
t2.FName AS FWorkShopName,t2.FNumber AS FWorkShopNumber
INTO #TempFF18733BDFCC144979592626132FD0472
FROM ICMO v1
LEFT OUTER JOIN t_Department t2 ON v1.FWorkShop=t2.FItemID
INNER JOIN t_ICItem t4 ON v1.FItemID=t4.FItemID
INNER JOIN t_MeasureUnit t7 ON v1.FUnitID=t7.FItemID
LEFT OUTER JOIN t_SubMessage tplanmode ON v1.FPlanMode=tplanmode.FInterID
LEFT OUTER JOIN t_Stock t5 ON t4.FDefaultLoc=t5.FItemID
INNER JOIN t_MeasureUnit t10 ON t4.FUnitID=t10.FItemID
LEFT OUTER JOIN t_MeasureUnit t501 ON t4.FSecUnitID=t501.FItemID
LEFT OUTER JOIN t_stockPlace t8 ON t4.FSPID=t8.FSPID
WHERE (v1.FInterID=37163)
INSERT INTO #TempFF18733BDFCC144979592626132FD0472
(FF18733BDFCC144979592626132FD0472,FAuxPrice,FAuxPlanPrice,FItemUnitGroupID,FAuxPropCls,
FAuxQty,FBaseUnitName,FBatchNo,FBillNO,
FDCSPID,FDCSPIDName,FDCSPIDNumber,FDCStockID,FDCStockIDName,FDCStockIDNumber,FICMOBillNo,
FICMOINterid,FInterID,FItemID,FMatName,FMatNumber,Fmodel,FName,FNote,FNumber,FPPBOMEntryID,FPriceDecimal,
FQty,FQtyDecimal,FSecCoefficient,FSecQty,FSecUnitName,FSelTranTypeID,FSelTranTypeName,FSelTranTypeNumber,
FSourceBillNo,FSourceEntryID,FSourceInterID,FSourceTranType,FTrack,FUnitID,FUnitName,FUnitNumber,
FWorkShop,FWorkShopName,FWorkShopNumber,FPlanMode,FMtoNO,FPlanModeName,FPlanModeNumber,
FChkPassItem,FChkPassItemName,FChkPassItemNumber,
FSelDiscardStockInSecQty,FSelDiscardStockInAuxQty,FSelDiscardStockInQty,FBadQty,FAuxBadQty,FSecBadQty,
FSampleBreakQty,FSampleBreakAuxQty,FSampleBreakSecQty,
FQtyScrap,FAuxQtyScrap,FSecQtyScrap,FAuxQtyMust)
SELECT 1,CAST(t4.FPlanPrice AS FLOAT) * CAST(t7.FCoefficient AS FLOAT) AS FAuxPrice,
t4.FPlanPrice * t7.FCoefficient AS FAuxPlanPrice,t4.FUnitGroupID as FItemUnitGroupID,
t4.FAuxClassID AS FAuxPropCls,
CASE WHEN (u2.FAuxQtyMust - isnull(u2.FAuxQty, 0))<0 THEN 0 ELSE (u2.FAuxQtyMust - isnull(u2.FAuxQty, 0)) END AS FAuxQty,
t10.FName AS FBaseUnitName,u2.FBatchNO as FBatchNo,v1.FBillNO,(CASE WHEN ISNULL(u2.FSPID,0)>0 THEN u2.FSPID ELSE t4.FSPID END) AS FDCSPID,(CASE WHEN ISNULL(u2.FSPID,0)>0 THEN t12.FName ELSE t11.FName END ) AS FDCSPIDName,
(CASE WHEN ISNULL(u2.FSPID,0)>0 THEN t12.FNumber ELSE t11.FNumber END ) AS FDCSPIDNumber,(CASE WHEN ISNULL(u2.FStockID,0)>0 THEN u2.FStockID ELSE t4.FDefaultLoc END) AS FDCStockID,(CASE WHEN ISNULL(u2.FStockID,0)>0 THEN t51.FName ELSE t5.FName END) AS FDCStockIDName, CASE WHEN (SELECT FValue FROM t_Systemprofile WHERE FCategory='IC' AND FKey='UseShortNumber')='0' THEN (CASE WHEN ISNULL(u2.FStockID,0)>0 THEN t51.FNumber ELSE t5.FNumber END) else (CASE WHEN ISNULL(u2.FStockID,0)>0 THEN t51.FShortNumber ELSE t5.FShortNumber END) END AS FDCStockIDNumber, v1.FBillNO AS FICMOBillNo,v1.FInterid as FICMOINterid,v1.FInterID,u2.FItemID,t4.FName AS FMatName,t4.FNumber AS FMatNumber,t4.Fmodel,t4.FName,t4.FNote,t4.FNumber,u2.FENTRYID as FPPBOMEntryID,t4.FPriceDecimal, CASE WHEN (u2.FQtyMust - isnull(u2.FQty, 0))<0 THEN 0 ELSE (u2.FQtyMust - isnull(u2.FQty, 0)) END AS FQty, t4.FQtyDecimal,t4.FSecCoefficient as FSecCoefficient,(Case When t4.FSecCoefficient>0 Then CASE WHEN (u2.FQtyMust - isnull(u2.FQty, 0))<0 THEN 0 ELSE (u2.FQtyMust - isnull(u2.FQty, 0)) END/t4.FSecCoefficient Else 0 End) AS FSecQty, t501.FName AS FSecUnitName,v1.FTranType AS FSelTranTypeID, (SELECT FName FROM v_ICTransType WHERE FID=v1.FTranType) AS FSelTranTypeName,(SELECT FName FROM v_ICTransType WHERE FID=v1.FTranType) AS FSelTranTypeNumber, v1.FBillNO AS FSourceBillNo,u2.FEntryID AS FSourceEntryID,v1.FInterID AS FSourceInterID,v1.FTranType AS FSourceTranType, t4.FTrack,u2.FUnitID,t7.FName AS FUnitName,t7.FShortNumber AS FUnitNumber,v1.FWorkShop,t2.FName AS FWorkShopName, t2.FShortNumber AS FWorkShopNumber,u2.FPlanMode,u2.FMtoNO,tPlanMode.FName AS FPlanModeName,tPlanMode.FID AS FPlanModeNumber ,1058,(SELECT FName FROM t_SubMessage WHERE FTypeID = 244 AND FInterID = 1058),(SELECT FID FROM t_SubMessage WHERE FTypeID = 244 AND FInterID = 1058),0,0,0,0,0,0,0,0,0,0,0,0,CASE WHEN (u2.FAuxQtyMust - isnull(u2.FAuxQty, 0))<0 THEN 0 ELSE (u2.FAuxQtyMust - isnull(u2.FAuxQty, 0)) END AS FAuxQtyMust FROM ICMO v1 left join ppbom v2 on v1.finterid=v2.FICMOinterID left join PPBomEntry u2 on v2.FinterID=u2.FInteriD left join t_Department t2 on v1.FWorkShop=t2.FItemID INNER join t_ICItem t4 on u2.FItemID=t4.FItemID INNER join t_MeasureUnit t10 on t4.FUnitID=t10.FItemID INNER join t_MeasureUnit t7 on u2.FUnitID=t7.FItemID left join t_Stock t5 on t4.FDefaultLoc=t5.FItemID AND t5.FTypeID=500 --取物料上的仓库
LEFT JOIN t_Stock t51 ON u2.FStockID=t51.FItemID AND t51.FTypeID=500--取投料单的仓库
left join t_Supplier t8 on v1.FSupplyID=t8.FItemID left join t_MeasureUnit t501 ON t4.FSecUnitID=t501.FItemID LEFT OUTER JOIN t_stockPlace t11 ON t4.FSPID=t11.FSPID--取物料的仓位
LEFT OUTER JOIN t_stockPlace t12 ON u2.FSPID=t12.FSPID --取投料单的仓位
left join t_submessage tPlanMode on u2.fplanmode=tPlanMode.finterid
where u2.FMaterielType IN (372,373,374) and v2.FICMOinterid in ( select FInterID from ICMO v1 Where (v1.FInterID=37163) )
--代管仓特殊处理,不处:仓库，仓位的携带(业务背景：生产的东西不能代管)
Update t1
Set t1.FDCSPID=0,t1.FDCSPIDName='',t1.FDCSPIDNumber=''
,t1.FDCStockID=0,t1.FDCStockIDName='',t1.FDCStockIDNumber=''
From #TempFF18733BDFCC144979592626132FD0472 t1
Left Join t_Stock t2 ON t1.FDCStockID=t2.FItemID
WHERE ISNULl(t2.FTypeID,0)=503

SELECT * FROM #TempFF18733BDFCC144979592626132FD0472 ORDER BY FICMOInterID,FF18733BDFCC144979592626132FD0472
DROP TABLE #TempFF18733BDFCC144979592626132FD0472

怎 么解决的
哪个版本，没有等级品的任务单入库是否有问题
演示帐套有等级品的情况呢