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