SQL Scripts for Microsoft Dynamics GP: Update Item Replenishment Method for Manufacturing

Ian Grieve

22,782

Like ( 1 )

Report

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 updates the replenishment method on all item/site combinations:

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

	['Item Quantity Master']
SET

	REPLENISHMENTMETHOD = 1

FROM

	IV00102 AS ['Item Quantity Master'] --Item Quantity Master (IV00102)
INNER JOIN

	IVR10015 AS ['Item Engineering File'] --IVR10015
		ON

			['Item Engineering File'].ITEMNMBR = ['Item Quantity Master'].ITEMNMBR

WHERE

	['Item Quantity Master'].RCRDTYPE = 2

AND

	['Item Engineering File'].MAKEBUYCODE_I = 1

GO

Click to show/hide the SQL Scripts for Microsoft Dynamics GP Series Index

SQL Scripts for Microsoft Dynamics GP
Sales Transactions (Work) Against a Specific Site
Update Site Descriptions From CSV
Select All Primary Keys and Generate ALTER Script
Export Open/History PM Transactions After a Specified Date
Migrate Vendor Emails from Active Docs to Standard Email Fields
Update Inventory Accounts from Item Class
Update Accounts Payable Distribution on Work Status PM Transactions from Posting Account Setup
Update Inventory Distribution on Work Status Purchase Orders from the Item Card
Update Accrued Purchases Distribution on History Receipts from Posting Account Setup
Insert National Accounts from CSV
Import Site Bins From CSV
Update Accounts and Distributions on Work Status Sales Transactions from Item Card, Tax Details or Posting Account Setup
Assign All Items to All Site Bins
SQL Trogger on PO invoice Insert to Change GL posted Date
PO Receipt History View
Update Item Replenishment Method for Manufacturing