I would like to change the order of my closed PO numbers. Is it possible to change closed purchase order numbers using a Query?
changing closed PO
Feb 05, 2006
2 Replies
You can update a PO's number by using the SQL Query below: UPDATE PurchaseOrder SET PONumber = 'xxx' WHERE PONumber = 'yyy'
******************************************************** MAKE A BACKUP OF YOUR DATABASE BEFORE DOIN ANY UPDATE QUERIES ********************************************************Or you can edit the PO in SO Manager. Make certain you have 'Allow edit of closed PO's' is selected in Configuration --> Options menu --> Purchase Order options. Now add an item, doesn't matter what item, then press OK. The order will now be in a Partial Status, find the PO, highlight and click Edit. You can now change the PO Number to whatever you want, delete the item that was just added and press OK. It now is back to a Closed status.
Rob
"Harry" wrote:
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required