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.

SUGGESTED

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?

  • 0
    SUGGESTED
    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.