Customer shipping addresses in Dynamics GP

Need to see a list of all the shipping addresses for your Dynamics GP customers? You can use the view below which pulls out the ship to address and the associated tax schedule, shipping method , salesperson, etc.

To see other SQL views for Dynamics GP receivables data, take a look at the Receivables SQL Views page. For other Dynamics GP views and reporting reporting information, check out the GP Reports page.

~~~~~

CREATE VIEW view_Customer_Ship_To_Addresses
AS

/********************************************************************
view_Customer_Ship_To_Addresses
Created on Feb. 18, 2011 by Victoria Yudin - Flexible Solutions, Inc.
For updates visit http://victoriayudin.com/gp-reports/
********************************************************************/

SELECT 	M.CUSTNMBR Customer_ID,
	M.CUSTNAME Customer_Name,
	M.CUSTCLAS Class_ID,
	M.CPRCSTNM Parent_ID,
	M.PRSTADCD Ship_To_Address_ID,
	A.CNTCPRSN Contact,
	A.ADDRESS1 Address_1,
	A.ADDRESS2 Address_2,
	A.ADDRESS3 Address_3,
	A.CITY City,
	A.[STATE] [State],
	A.ZIP Zip,
	A.COUNTRY Country,
	A.PHONE1 Phone_1,
	A.PHONE2 Phone_2,
	A.PHONE3 Phone_3,
	A.FAX Fax,
	A.UPSZONE UPS_Zone,
	A.SHIPMTHD Shipping_Method,
	A.TAXSCHID Tax_Schedule_ID,
	A.LOCNCODE Site_ID,
	A.SLPRSNID Salesperson_ID,
	A.SALSTERR Territory_ID,
	A.USERDEF1 [User-Defined_1],
	A.USERDEF2 [User-Defined_2],
	A.MODIFDT Modified_Date,
	A.CREATDDT Created_Date

FROM RM00101 M  --customer master

INNER JOIN RM00102 A  --addresses
	ON M.CUSTNMBR = A.CUSTNMBR
	AND M.PRSTADCD = A.ADRSCODE

/** the following will grant permissions to this view to DYNGRP,
leave this section off if you do not want to grant permissions **/

GO
GRANT SELECT ON view_Customer_Ship_To_Addresses to DYNGRP

~~~~~

Disclaimer: I tested this on limited data, if you find an issue or have a suggestion for improvement, please let me know and I will post the update here for everyone