Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

U8 final purchase order cannot be revoked and deleted

Shulou Source: shulou.com Published: 2022-06-03 07:51:56 11月23日 Update

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

Tags: Order purchase status order number statement final name method flag problem reviewer and will update enter Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB Microsoft Redmi MySQL Shulou Technology