外购入库单经检查确定没有生成过发票,也没有进行钩稽发票,数据库清理钩稽标记及钩稽数量、金额
UPDATE T1 SET
T1.FAllHookAmount=0,T1.FAllHookQTY=0
FROM ICStockBillEntry T1 INNER JOIN ICStockBill T2 ON T1.FInterID=T2.FInterID where t2.FBillNo='WGRK-2305-00355'
UPDATE T2 SET
T2.FHookStatus=0
FROM ICStockBillEntry T1 INNER JOIN ICStockBill T2 ON T1.FInterID=T2.FInterID where t2.FBillNo='WGRK-2305-00355'