SQL Scripts for Microsoft Dynamics GP: Sales Transactions (Work) Against a Specific Site

Views (3)

Ian Grieve

22,784

Like(0)

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 was created for a client who was closing some sites and wanted to get a list of all Work status sales transactions against a specific site.

/*
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).
*/
DECLARE @LOCNCODE VARCHAR(10) = 'Z%'
SELECT

	SOP101.CUSTNMBR

	,SOP101.CUSTNAME

	,SOP102.SOPNUMBE, SOP102.LNITMSEQ, SOP102.LOCNCODE, SOP102.ITEMNMBR

FROM

	SOP10200 AS SOP102 -- Sales Transaction Amounts Work (SOP10200)
INNER JOIN

	SOP10100 AS SOP101 -- Sales Transaction Work (SOP10100)
		ON SOP101.SOPNUMBE = SOP102.SOPNUMBE

WHERE

	SOP102.LOCNCODE LIKE @LOCNCODE

ORDER BY

	SOP101.CUSTNAME,SOP102.SOPNUMBE