K3wise 清除记账标记和勾稽状态

 

--清除发票记账标志

update ICPurchase set FPosted=null,FPosterID=null,FVchInterID=0 from  ICPurchase where FBillNo='10083839'

 

--清除库存单据记账标志

update icstockbill set FPosted=null,FPosterID=null,FVchInterID=0 from  icstockbill where FBillNo='10083839'

 

--清除库存单据勾稽标志和勾稽状态

update icstockbill set FHookStatus=0,FHookInterID=0 from  icstockbill where FBillNo ='10083839'

--清除库存单据勾稽数量和开票数量

update t2 set t2.FAllHookQty=0,t2.FAuxQtyInvoice=0,t2.FQtyInvoice=0 from icstockbill t1
inner join icstockbillentry t2 on t1.FInterid=t2.Finterid
where FBillNo ='10083839'