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
Deleting Closed PO's
Sep 19, 2008
2 Replies
Database |Configuration | Options Tab | Purchase order options | [x] Allow edit of closed PO's
see if that works.
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)
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required