SQL Scripts for Microsoft Dynamics GP: Change Location on Word Status Purchase Order Lines From CSV

This script updates the location on work status purchase order lines from a CSV file. I vaguely recall this script and after running it we ran the reconcile process against both Purchase Ordering and Inventory Control.

As with any script, before running on production test the script to make sure it works and have a good backup of the database.

/*
Created by Ian Grieve of azurecurve | Ramblings of an IT Professional (http://www.azurecurve.co.uk)
This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
*/
CREATE TABLE #SiteXRef

	(PONUMBER VARCHAR(100)

	,ITEMNMBR VARCHAR(100)

	,LOCNCODE VARCHAR(100)

	)

GO
BULK

	INSERT #SiteXRef

FROM

	'C:\TEMP\StockCodes.csv'

WITH

	(

		FIELDTERMINATOR = ',',

		ROWTERMINATOR = '\n'

	)

GO
UPDATE

	POP

SET

	POP.LOCNCODE = SiteXRef.LOCNCODE

FROM

	POP10110 POP

INNER JOIN

	#SiteXRef As SiteXRef ON SiteXRef.PONUMBER = POP.PONUMBER AND SiteXRef.ITEMNMBR = POP.ITEMNMBR

GO
DROP TABLE #SiteXRef

GO

Read original post SQL Scripts for Microsoft Dynamics GP: Change Location on Word Status Purchase Order Lines From CSV at azurecurve|Ramblings of an IT Professional