用友U8 V18供应商调价单异常.

U8 V18供应商调价单异常,更新成未审核状态,U8里面删除单据.重新导入提示重复.SQL删除供应商存活调价历史表,删除重复供应商存货价格表记录

Select cverifier,cCurrentAuditor,iverifystate,cAuditTime,* from PU_PriceJustMain where ddate = '2026-05-01' and ccode = '0000001586'
--取消审核状态
update PU_PriceJustMain set cverifier = null,cAuditTime= null, iverifystate = '0'where ddate = '2026-05-01' and ccode = '0000001586'
--删除供应商存活调价历史表
delete from PUPriceJust where ccode = '0000001586'
--删除重复供应商存货价格表记录
delete from Ven_Inv_Price where dEnableDate = '2026-05-01' and dDisableDate = '2026-05-16' and cInvCode in ('1060100047')