Resend PO's to Stores

From EnablerWiki

Created: 20 July 2009. Last Reviewed: 20 July 2009

Occasionally you make have the situation where a purchase order created in EEE is not available to receipt against in Enabler. This can occur for a variety of reasons including, the supplier code is not available in the store, the products in the PO are not available in the store, etc.

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

The EEE Exporter uses the InsertionDate field on the StorePOTransaction table to determine which records to export to stores, so changing this date will ensure that the records get exported again to stores.

declare @po varchar(6)

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

set @po='ZZZZZZ'

use eee

select * from storepotransaction where substring(ponumber,1,6) = @po and type = 'O'

update storepotransaction set InsertionDate = current_timestamp where substring(ponumber,1,6)= @po and type = 'O'

-