委外加工入库审核未成功解决办法
---委外加工审核未成功的问题解决办法,
---可能原因是表 ICShop_ItemConsume 中FinterID的最大值问题，由于中间有表删除，一些流水号丢失，所以更新下最大值
lect top 1 *from ICShop_ItemConsume order by FInterID desc
lect*from ICMaxNum where FTableName like'ICShop_ItemConsume'--- 保证最大值一致,如不是则更新
update ICMaxNum t FMaxNum = (lect max(finterid) from ICShop_ItemConsume) where FTableName like 'ICShop_ItemConsume'
以下代码为其中一列报错中抓取的过程
怎样写借条--Declare @FSouceTrantype as int
Declare@WIPDeductMode as Decimal(28,10)--在制品扣减方式
Declare@bWriteMethod as Int--是否按标准数量
Declare@dRate as Decimal(28,10)--换算率
Declare@FWIPQty as Decimal(28,10)--在制品数量
干炒黄豆窍门Declare@FICMOInterID as int
queenstown
Declare@#Data797A90FE46DE4D3DB0887B4794F98159table(FOrderInterID int,FOrderEntryID
简画
INT,FItemID INT,FStockQty Decimal(28,10),FSecStockQty DECIMAL(28,10))
Inrt into@#Data797A90FE46DE4D3DB0887B4794F98159
SELECT FOrderInterID,FOrderEntryID,FItemID,SUM(ISNULL(u2.FQty,0))as
FStockQty,SUM(ISNULL(u2.FSecQty,0))AS FSecStockQty FROM ICStockBillEntry u2 WHERE u2.FICMoInterID= 0 AND u2.FOrderInterID>0 AND u2.FInterID= 213494
GROUP BY FOrderInterID,FOrderEntryID,FItemID
IF (lect count(*)from@#Data797A90FE46DE4D3DB0887B4794F98159)>0
UPDATE u1SET
u1.FStockQty=ISNULL(u1.FStockQty,0)+m2.FStockQty,阳历和阴历怎么区分
u1.FAuxStockQty=ISNULL(u1.FAuxStockQty,0)+
m2.FStockQty/cast(t2.FCoEfficient as float),
u1.FSecStockQty=ISNULL(u1.FSecStockQty,0)+m2.FSecStockQty
FROM ICSubContractEntry u1INNER JOIN@#Data797A90FE46DE4D3DB0887B4794F98159m2on
u1.FInterID=m2.FOrderInterID AND u1.FEntryID=m2.FOrderEntryID AND u1.FItemID=m2.FItemID INNER JOIN t_MeasureUnit t2ON u1.FUnitID=t2.FMeasureUnitID
UPDATE u1SET
u1.FBCommitQty=ISNULL(u1.FBCommitQty,0)+m2.FBackQty,
u1.FAuxBCommitQty=(ISNULL(u1.FBCommitQty,0)+m2.FBackQty)/cast(t2.FCoEfficient as float), u1.FSecBCommitQty=ISNULL(u1.FSecBCommitQty,0)+m2.FSecBackQty
FROM ICSubContractEntry u1INNER JOIN
(SELECT FOrderInterID,FOrderEntryID,FItemID,SUM(ISNULL(u2.FQty,0))AS FBackQty,
SUM(ISNULL(u2.FAuxQty,0))AS FAuxBackQty,SUM(ISNULL(u2.FSecQty,0))AS FSecBackQty FROM ICStockBillEntry u2
500短篇超污多肉推荐WHERE u2.FICMoInterID= 0 AND u2.FOrderInterID>0 AND u2.FSourceTranType= 73 AND u2.FQty< 0 AND u2.FInterID= 213494
GROUP BY FOrderInterID,FOrderEntryID,FItemID)m2
ON u1.FInterID=m2.FOrderInterID AND u1.FEntryID=m2.FOrderEntryID AND
u1.FItemID=m2.FItemID
INNER JOIN t_MeasureUnit t2ON u1.FUnitID=t2.FMeasureUnitID
Declare@#ICSTOCK797A90FE46DE4D3DB0887B4794F98159table (FICMOInterID int,FPPBOMEntryID int,FItemID int,FStockQty decimal(28,10))
Inrt into@#ICSTOCK797A90FE46DE4D3DB0887B4794F98159SELECT
u2.FICMOInterID,u2.FPPBOMEntryID,u2.FItemID,SUM(ISNULL(u2.FQty,0))AS FStockQty FROM ICStockBillEntry u2
WHERE u2.FOrderInterID>0 AND FICMOInterID> 0 and u2.FPPBOMEntryID>0 and u2.FInterID= 213494
GROUP BY u2.FICMOInterID,u2.FPPBOMEntryID,u2.FItemID
IF (lect count(*)from@#ICSTOCK797A90FE46DE4D3DB0887B4794F98159)>0
UPDATE u1SET
u1.FStockQty=ISNULL(u1.FStockQty,0)+ISNULL(m2.FStockQty,0),
u1.FAuxStockQty=ISNULL(u1.FAuxStockQty,0)+ISNULL(ROUND(
ISNULL(cast(m2.FStockQty as float),0)/cast(t2.FCoEfficient as float),t1.FQtyDecimal),0) FROM PPBOMEntry u1INNER JOIN@#ICSTOCK797A90FE46DE4D3DB0887B4794F98159 m2
ON u1.FItemID=m2.FItemID AND u1.FEntryID=m2.FPPBOMEntryID AND u1.FInterID=m2.FICMOinterID INNER JOIN t_ICItem t1ON m2.FItemID=t1.FItemID
INNER JOIN t_MeasureUnit t2ON u1.FUnitID=t2.FMeasureUnitID
WHERE u1.FMaterielType IN(372,373,374)--联副产品等级品件
SET NOCOUNT ON
DECLARE@DeductPoint AS INT,@DeductMode AS INT
SET@DeductMode=0
SET@DeductPoint=0
--构建临时表记录源单信息，如入库单、任务单汇报单
CREATE TABLE#SourceBill(
FInterID INT--源单内码
,FEntryID INT DEFAULT-1--源单分录
,FItemID INT--物料
,FICMOInterID INT--任务单或委外订单的内码
job可数吗
,FICMOEntryID INT DEFAULT 0--委外订单的分录
,FMOCoefficient DECIMAL(23,10)DEFAULT 1--任务单单位的换算率
,FPPBOMEntryID INT DEFAULT 0--投料单的分录
,FSourceInterID INT DEFAULT 0--源单内码（蓝字推红字）
,FSourceEntryID INT DEFAULT 0--源单分录（蓝字推红字）
,FSourceTranType INT DEFAULT 0--源单类型（蓝字推红字）
,FQty DECIMAL(23,10)--本次入库数量，如果是等级品需要换算成产成品
什么什么不什么成语,FROB INT DEFAULT 1--红蓝字标记
,FBillNO NVARCHAR(255)--源单编号
,FTranType INT DEFAULT-1--源单类型
,FItemConsumeBillNO NVARCHAR(255)DEFAULT''--材料耗用编号
,FDeleted INT DEFAULT 0--删除单据
)
CREATE TABLE#ItemConsume(
FInterID INT DEFAULT-1
,FEntryID INT DEFAULT-1
