Deleting Closed PO's


A

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
 
Ad

Advertisements

R

root

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

see if that works.
 
Ad

Advertisements

K

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top