用友U8修改货位现存量

由于从其他系统中传递过来的采购入库单未做货位验证，将错误货位写入数据库，导致料号货位错误，做货位调整单提示货位非法，采用如下方法，修改为正确的货位之后，重新写入货位存量表。

SELECT * FROM   dbo.InvPosition   WHERE  cposcode  ='d'

SELECT * FROM   dbo.InvPositionSum   WHERE  cposcode  ='d'

UPDATE   dbo.InvPosition   set cposcode  ='DA00-000'  WHERE  cposcode  ='d'

SELECT * FROM dbo.Position  WHERE cposcode LIKE 'd%'

BEGIN TRAN;

TRUNCATE TABLE InvPositionSum;

--update  set  cbatch='' from   InvPosition p left join  Inventory i on  p.cInvCode=i.cinvcode  where isnull (bInvBatch,0) =0

--select *  into AA_BatchPropertybak2021 from  AA_BatchProperty
--delete from   b from  AA_BatchProperty b  left join  Inventory i  on b.cinvcode =i.cinvcode where bInvBatch=0

INSERT INTO InvPositionSum
(
    iQuantity,
    inum,
    cWhCode,