SQL 更新U9C的请购单终止后不能转PO的问题

SQL 更新U9C的请购单终止后不能转PO的问题

SELECT  Cancel_Canceled,Cancel_CancelDate,Cancel_CancelUser,Cancel_CancelReason,* from  PR_PR WHERE docno in ('PR2504100002');--更新生产订单作废
UPDATE PR_PR 
SET Cancel_Canceled = 0, -- 1=关闭,0=打开
Cancel_CancelDate = NULL, -- 关闭时间
Cancel_CancelUser = '', -- 关闭人
Cancel_CancelReason = '' -- 关闭原因
WHEREdocno IN ( 'PR2504100002' );