Deleting Closed PO's

Posted by aneuron on September 19, 2008, 3:25 pm

Please log in for more thread options

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 by root on September 20, 2008, 4:14 pm

Please log in for more thread options

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

see if that works.

> 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 by Kaibin on September 22, 2008, 9:40 am

Please log in for more thread options

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)

--
Kaibin
RMS Support Team
Ridge, Inc.
http://www.ridgeinc.com.cn

> 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