Resend Inter Store Transfers to Stores

From EnablerWiki

Created: 17 January 2011. Last Reviewed: 17 January 2011

Occasionally you make have the situation where a inter store transfer created in Enabler is not available to receive at the receiving store. This can occur for a variety of reasons including, the products in the store transfer are not available in the receiving store, etc.

Often all that is required is for the transfer records to be resent to the stores using a script as shown below. In this script, you replace 999805085233 with the Transfer number and run the script which will change the Modified Date for these records to the current date and time.

The EEE Exporter uses the ModDate field on the StoreTransferHeader and StoreTransferLineTbl tables to determine which records to export to stores, so changing this date will ensure that the records get exported again to stores.

Refer the comments in the script below for further information.

declare @tfr varchar(12)

-- On the following line, put in the correct PO Number

set @tfr='999805085233'

use eee

-- The following 2 lines show the header and details for the above transfer number.

select * from storetransferheader where substring(transfernumber,1,12)=@tfr

select * from storetransferlinetbl where substring(transfernumber,1,12)=@tfr

-- Remove the "--" from the following 2 lines to update the transfer for re-exporting to stores.

--update storetransferheader set ModDate = current_timestamp where substring(ponumber,1,12)=@tfr

--update storetransferlinetbl set ModDate = current_timestamp where substring(ponumber,1,12)=@tfr

-