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
- posted
15 years ago
Deleting Closed PO's
Loading thread data ...
- Vote on answer
- posted
15 years ago
Database |Configuration | Options Tab | Purchase order options | [x] Allow edit of closed PO's
see if that works.
- Vote on answer
- posted
15 years ago
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)