T+13.0 中途启用货位后问题

BC008存货现存量查询时有184个，查询货位总账时只有启用货位之后的-20个，货位补录也没有此存货的信息。

问题回复：

请您务必做好数据备份，这个是将这个存货所在的仓库良品仓的货位补录记录清除掉，重新进行补录。 

DECLARE @warehouseTemp TABLE (Id int) INSERT INTO @warehouseTemp (Id) SELECT id FROM AA_Warehouse WHERE WHERE code IN ('CS02') AND name IN ('良品仓') --清除补录多货位 

if exists(select*from sys.objects where name ='ST_MultiLocationDetail_225258' ) BEGIN DROP TABLE ST_MultiLocationDetail_225258 END SELECT * into ST_MultiLocationDetail_225258 FROM ST_MultiLocationDetail WHERE idPositionInitDetailDTO IN (SELECT id FROM ST_PositionInitDetail WHERE idPositionInitDTO IN ( SELECT id FROM dbo.ST_PositionInit WHERE idwarehouse IN (SELECT id FROM @warehouseTemp))) DELETE ST_MultiLocationDetail WHERE idPositionInitDetailDTO IN (SELECT id FROM ST_PositionInitDetail WHERE idPositionInitDTO IN ( SELECT id FROM dbo.ST_PositionInit WHERE idwarehouse IN (SELECT id FROM @warehouseTemp))) --清除补录明细 

if exists(select*from sys.objects where name ='ST_PositionInitDetail_225258' ) BEGIN DROP TABLE ST_PositionInitDetail_225258 END SELECT * INTO ST_PositionInitDetail_225258 FROM ST_PositionInitDetail WHERE idPositionInitDTO IN ( SELECT id FROM dbo.ST_PositionInit WHERE idwarehouse IN (SELECT id FROM @warehouseTemp)) DELETE ST_PositionInitDetail WHERE idPositionInitDTO IN ( SELECT id FROM dbo.ST_PositionInit WHERE idwarehouse IN (SELECT id FROM @warehouseTemp)) --清除补录表头 

if exists(select*from sys.objects where name ='ST_PositionInit_225258' ) BEGIN DROP TABLE ST_PositionInit_225258 END SELECT * INTO ST_PositionInit_225258 FROM ST_PositionInit WHERE idwarehouse IN (SELECT id FROM @warehouseTemp) DELETE dbo.ST_PositionInit WHERE idwarehouse IN (SELECT id FROM @warehouseTemp) --货位总账 

if exists(select*from sys.objects where name ='ST_LocationAccount_225258' ) BEGIN DROP TABLE ST_LocationAccount_225258 END SELECT * INTO ST_LocationAccount_225258 FROM ST_LocationAccount WHERE idwarehouse IN (SELECT id FROM @warehouseTemp) DELETE dbo.ST_LocationAccount WHERE idwarehouse IN (SELECT id FROM @warehouseTemp) --重整货位现存量量 

EXEC SCM_SP_RebuildLocationAccount EXEC SCM_SP_RebuildCurrentStock