Day: January 12, 2023

SQL Scripts for Microsoft Dynamics GP: Update Accounts Payable Distribution on Work Status PM Transactions from Posting Account Setup

Ian Grieve2 minute read0 comment

Microsoft Dynamics GPThis 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 will update the accounts payable distribution on all open purchasing transactions from the Posting Account Master (SY01100) 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
	['PM Distribution Work/Open']
SET
	DSTINDX = ACTINDX
FROM
	PM10100 AS ['PM Distribution Work/Open'] --PM Distribution WORK OPEN (PM10100)
INNER JOIN
	SY01100 AS ['Posting Account Master'] --Posting Account Master (SY01100)
		ON
			['Posting Account Master'].SERIES = 4
		AND
			['Posting Account Master'].PTGACDSC = 'Accounts Payable'
WHERE
	DISTTYPE = 2 -- ACCOUNTS PAYABLE

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

Applying a Word Concordance File to Create an Index

Ian Grieve2 minute read0 comment

Microsoft OfficeWhen working with a large document such as a book, a common requirement is to add an index to the end so that important words or phrases can be indexed for easy lookup. While you can tag words for the index within Microsoft Word a better way to do in bulk is to use a concordance file.

This is basically a separate two column file containing a list of words to index in the first column and how they should be shown in the second:

Word concordance file

Continue reading “Applying a Word Concordance File to Create an Index”