In ShipWorks Enterprise select all open orders by clicking "CTRL + A"


Then click the "Delete" button on the ShipWorks Enterprise toolbar to delete all of the selected orders


To force all of the open orders in Counterpoint to be re-downloaded to ShipWorks Enterprise the PS_DOC_HDR.RS_UTC_DT value most be advanced past the current RS_UTC_DT. These open orders will then be included in the next ShipWorks download process.


Execute the following SQL Script on the Counterpoint SQL Database

**************************************************************************************************************************************************


--THE FOLLOWING CURSOR WILL UPDATE THE RS UTC DATE FOR ALL OPEN TRANSACTIONS BY INCREMENTING THE RC UTC DATE BY 200MS FOR EACH TRANSACTION

DECLARE my_cursor CURSOR FOR
       SELECT DOC_ID
       FROM PS_DOC_HDR

DECLARE @DOC_ID T_DOC_ID, @SEQ_NO T_INT, @CURR_UTC_DATE T_DT
SET @CURR_UTC_DATE = GETUTCDATE()
SET @SEQ_NO = 1
OPEN my_cursor
FETCH NEXT FROM my_cursor INTO @DOC_ID
WHILE(@@FETCH_STATUS=0)
BEGIN
       UPDATE PS_DOC_HDR
       SET RS_UTC_DT = DATEADD(MS, @SEQ_NO * 200, @CURR_UTC_DATE)
       WHERE DOC_ID = @DOC_ID

       SET @SEQ_NO = @SEQ_NO + 1

FETCH NEXT FROM my_cursor INTO @DOC_ID
END
CLOSE my_cursor
DEALLOCATE my_cursor

SELECT RS_UTC_DT, * FROM PS_DOC_HDR