SQL Scripts for Microsoft Dynamics GP: Update Mfg Cost Accounts from Mfg Item Class Setup

This script updates the manufacturing cost accounts on the items using the accounts on the linked classes; this script was created for a client where it was found that classes had been updated and the items still had the wrong codes.

/*
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

	[IC COST Item Master']
SET

	ICIVCLIXI = ['IC COST Item Class Setup'].ICIVCLIXI

	,ICIVCLABOHIXI = ['IC COST Item Class Setup'].ICIVCLABOHIXI

	,ICIVCOGSLABOHVARIX_I = ['IC COST Item Class Setup'].ICIVCOGSLABOHVARIX_I

	,ICIVCCIXI = ['IC COST Item Class Setup'].ICIVCCIXI

	,ICIVCMACHOHIXI = ['IC COST Item Class Setup'].ICIVCMACHOHIXI

	,ICIVCOGSMACHOHVARIX_I = ['IC COST Item Class Setup'].ICIVCOGSMACHOHVARIX_I

	,ICIVCMIXI = ['IC COST Item Class Setup'].ICIVCMIXI

	,ICIVCMATOHIXI = ['IC COST Item Class Setup'].ICIVCMATOHIXI

	,ICIVCOGSMATOHVARIX_I = ['IC COST Item Class Setup'].ICIVCOGSMATOHVARIX_I

	,ICIVCOIXI = ['IC COST Item Class Setup'].ICIVCOIXI

	,ICIVMFIXI = ['IC COST Item Class Setup'].ICIVMFIXI

	,ICIVMUIXI = ['IC COST Item Class Setup'].ICIVMUIXI

	,ICIVMATUSAGEVAROHIX_I = ['IC COST Item Class Setup'].ICIVMATUSAGEVAROHIX_I

	,ICIVMATUSAGEVAROHVARIX_I = ['IC COST Item Class Setup'].ICIVMATUSAGEVAROHVARIX_I

	,ICIVMVIXI = ['IC COST Item Class Setup'].ICIVMVIXI

	,ICIVPVIXI = ['IC COST Item Class Setup'].ICIVPVIXI

	,ICIVROIXI = ['IC COST Item Class Setup'].ICIVROIXI

	,ICIVSCIXI = ['IC COST Item Class Setup'].ICIVSCIXI

	,ICIVLVIXI = ['IC COST Item Class Setup'].ICIVLVIXI

	,ICIVUPPV_I = ['IC COST Item Class Setup'].ICIVUPPV_I

	,ICIVLABVAROHIX_I = ['IC COST Item Class Setup'].ICIVLABVAROHIX_I

	,ICIVLABVAROHVARIX_I = ['IC COST Item Class Setup'].ICIVLABVAROHVARIX_I

	,ICIVMEVIXI = ['IC COST Item Class Setup'].ICIVMEVIXI

	,ICIVMACHEFFVAROHIX_I = ['IC COST Item Class Setup'].ICIVMACHEFFVAROHIX_I

	,ICIVMACHEFFVAROHVARIX_I = ['IC COST Item Class Setup'].ICIVMACHEFFVAROHVARIX_I

	,ICIVOVIXI = ['IC COST Item Class Setup'].ICIVOVIXI

	,ICIVWLIXI = ['IC COST Item Class Setup'].ICIVWLIXI

	,ICIVWLOHIXI = ['IC COST Item Class Setup'].ICIVWLOHIXI

	,ICIVWIPLABOHVARIX_I = ['IC COST Item Class Setup'].ICIVWIPLABOHVARIX_I

	,ICIVWCIXI = ['IC COST Item Class Setup'].ICIVWCIXI

	,ICIVWMACHOHIXI = ['IC COST Item Class Setup'].ICIVWMACHOHIXI

	,ICIVWIPMACHOHVARIX_I = ['IC COST Item Class Setup'].ICIVWIPMACHOHVARIX_I

	,ICIVWMIXI = ['IC COST Item Class Setup'].ICIVWMIXI

	,ICIVWMATOHIXI = ['IC COST Item Class Setup'].ICIVWMATOHIXI

	,ICIVWIPMATOHVARIX_I = ['IC COST Item Class Setup'].ICIVWIPMATOHVARIX_I

	,ICIVWOIXI = ['IC COST Item Class Setup'].ICIVWOIXI

	,ICIVILIXI = ['IC COST Item Class Setup'].ICIVILIXI

	,ICIVILABOHIXI = ['IC COST Item Class Setup'].ICIVILABOHIXI

	,ICIVINVLABOHVARIX_I = ['IC COST Item Class Setup'].ICIVINVLABOHVARIX_I

	,ICIVIMXI = ['IC COST Item Class Setup'].ICIVIMXI

	,ICIVIMACHOHIXI = ['IC COST Item Class Setup'].ICIVIMACHOHIXI

	,ICIVINVMACHOHVARIX_I = ['IC COST Item Class Setup'].ICIVINVMACHOHVARIX_I

	,ICIVIMATOHIXI = ['IC COST Item Class Setup'].ICIVIMATOHIXI

	,ICIVINVMATOHVARIX_I = ['IC COST Item Class Setup'].ICIVINVMATOHVARIX_I

FROM

	CT00102 AS [IC COST Item Master'] --CT00102
INNER JOIN

	CT40401 AS ['IC COST Item Class Setup'] --CT40401
		ON

			['IC COST Item Class Setup'].ITMCLSCD = [IC COST Item Master'].ITMCLSCD

GO

Read original post SQL Scripts for Microsoft Dynamics GP: Update Mfg Cost Accounts from Mfg Item Class Setup at azurecurve|Ramblings of an IT Professional