Deleting Closed PO's

[aneuron]

Hello,

We have RMS Manager 2.0 and are trying to delete a closed PO. Is there any
way to do this? we are access the PO's by Inventory -> Purchase Orders ->
closed orders.

Thanks,

Brad

 

[root]

Database |Configuration | Options Tab | Purchase order options | [x] Allow
edit of closed PO's

see if that works.

 

[Kaibin]

execute the following SQL statements individually and in successive order:

delete PurchaseOrder where status=2
delete PurchaseOrderEntry where PurchaseOrderID not in (select ID from
PurchaseOrder)
delete PurchaseOrderEntryDetail where PurchaseOrderEntryID not in (select
PurchaseOrderEntryID from PurchaseOrderEntry)