changing closed PO

Point-Of-Sale Software - - MS Point Of Sale software discussed here 

Yahoo!   Google   Windows Live   del.icio.us   digg   Netscape

Subject Author Date changing closed PO Harry 02-05-2006  RE: changing closed PO Rob 02-05-2006  RE: changing closed PO Harry 02-06-2006
Posted by Harry on February 5, 2006, 6:27 pm Please log in for more thread options I would like to change the order of my closed PO numbers. Is it possible to change closed purchase order numbers using a Query? Posted by Rob on February 5, 2006, 9:22 pm Please log in for more thread options 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: > I would like to change the order of my closed PO numbers. Is it possible to > change closed purchase order numbers using a Query? Posted by Harry on February 6, 2006, 9:38 am Please log in for more thread options Great news. i will test it today. Thank you! "Rob" wrote: > 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: > > > I would like to change the order of my closed PO numbers. Is it possible to > > change closed purchase order numbers using a Query? Similar Threads Posted Changing closing totals on closed batches March 31, 2006, 4:08 pm MSPSO - Changing closed PO and effect on Qucikbooks December 27, 2006, 11:25 pm delete queued closed batches from post closed batches command? August 9, 2005, 10:36 am Deleting a Closed PO February 26, 2007, 10:48 am Edit qty rec in closed po August 9, 2007, 11:44 am Day of the month on which accounts will be closed October 25, 2005, 6:27 pm Closed Batch - No Z-report October 25, 2005, 7:12 am deleting closed batches March 15, 2006, 3:41 pm Re-settle closed batch September 27, 2006, 5:08 pm Port is Closed for VPN Connection June 21, 2007, 2:02 am