We have 2 old pick lists that are stuck. The pick numbers show up in Explore-Pick Lists (show as status = pending) but when I type the pick list numbers no records are found.

Question

We have 2 old pick lists that are stuck. 
 The pick numbers show up in Explore-Pick Lists (ship status = pending and there is a shipment number) but when I type the pick list numbers to reprint pick list, cancel pick list or confirm picks the pick numbers show no records found. 
 We use Sage 500 ERP 2013 October 2013 Update (Version 7.50.4.0) 
 The sales order shows the lines grayed out but will not let me close or cancel the line. 
 At this point we'd like to just close out the sales order. 
 Know anyway to force a sales order to close?

Jen Pitt · Answer

You will have to cancel the pick in order to close the sales order. If you're savvy with SQL you can do something like this: 
 
select * from tsopicklist where PickListNo like '%####' --enter the pick list number here 
select * from tsoShipLine where PickListKey = 147 -- enter the PickListKey (from previous query)-- To VERIFY should be the pick list number 
 
--then you can update the picking complete flag to 1 (below) which will allow you to use the Reprint Pick List task in the front end to cancel the pick and close the sales order. 
 
begin tran 
update tsoShipLine 
set PickingComplete = 1 
 where PickListKey = XXX 
--commit or rollback 
 
IF this doesn't work, then you can contact Sage for a script.

Sage 500

We have 2 old pick lists that are stuck. The pick numbers show up in Explore-Pick Lists (show as status = pending) but when I type the pick list numbers no records are found.

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING