Trevor at 06:52, 20 July 2009

2009-07-20T06:52:31Z

← Older revision		Revision as of 06:52, 20 July 2009
Line 20:		Line 20:
	''use eee''		''use eee''

	''select * from storepotransaction where substring(ponumber,1,6)~~[mailto:%3D@po~~ =@po] and type = 'O'''		''select * from storepotransaction where substring(ponumber,1,6) = @po and type = 'O'''


	''update storepotransaction set InsertionDate = current_timestamp where substring(ponumber,1,6)~~[mailto:%3D@po~~ =@po] and type = 'O'''		''update storepotransaction set InsertionDate = current_timestamp where substring(ponumber,1,6)= @po and type = 'O'''


	-		-

Trevor: New page: 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...

2009-07-20T06:49:55Z

New page: 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...

New page

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)[mailto:%3D@po =@po] and type = 'O'''

''update storepotransaction set InsertionDate = current_timestamp where substring(ponumber,1,6)[mailto:%3D@po =@po] and type = 'O'''

-

Resend PO's to Stores - Revision history

Trevor at 06:52, 20 July 2009

Trevor: New page: 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...