Shulou(Shulou.com)06/03 Report--

Question name: final purchase order cannot be revoked and deleted

Solution:

1. Execute the following statement:

Update po_pomain set cstate=0,cverifier=null where cpoid=' purchase order number'(clear the auditor flag in the main table of the order and change the status to 'input')

2. Execute the following statement:

Update PO_Pomain setiverifystateex=0 where cPOID=' purchase order number'/ * Update Review status is unsubmitted * /

3. Delete the order

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.