SQL Scripts for Microsoft Dynamics GP: Update Inventory Distribution on Work Status Purchase Orders from the Item Card

This script is part of the SQL Scripts for Microsoft Dynamics GP where I will be posted the scripts I wrote against Microsoft Dynamics GP over the 19 years before I stopped working with Dynamics GP.

This script update the Inventory distribution on purchase orders as a work status to the account on the Item Master (IV00101) table.

/*
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).
*/
UPDATE

	['Purchase Order Line']
SET

	INVINDX = ['Inventory Item Master'].IVIVINDX

FROM

	POP10110 AS ['Purchase Order Line'] --PM10110
INNER JOIN

	IV00101 AS ['Inventory Item Master'] --Item Master (IV00101)
		ON

			['Inventory Item Master'].ITEMNMBR = ['Purchase Order Line'].ITEMNMBR

Read original post SQL Scripts for Microsoft Dynamics GP: Update Inventory Distribution on Work Status Purchase Orders from the Item Card at azurecurve|Ramblings of an IT Professional