Skip to content

SQL View – GP Notes

June 17, 2010

The following view just pulls the raw table data out of the SY03900 (notes) table and gives it a friendly name.  It just helps me when I can’t remember what table the notes are stored in :).

You can name the view whatever you want by changing the [tspvGPNotes] below.  Also the USE [TSP] tells the script to only execute on my database named TSP.  You will need to modify the [TSP] to be whatever your database name is.

USE [TSP]
GO
/****** Object:  View [dbo].[tspvGPNotes]    Script Date: 06/17/2010 15:11:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[tspvGPNotes1]
AS
SELECT * FROM sy03900

Advertisements

From → Dynamics GP

2 Comments
  1. You may want this one as well. To link back customer details to any notes they have. You can also do the same with vendors in replacing RM0010 with PM00200

    select a.*, b.txtfield from rm00101 a
    left outer join sy03900 b on a.noteindx = b.noteindx
    order by a.custnmbr

    Cheers.

    R.

  2. Ron Wilson permalink

    Thanks Rockfield. I am modifying my view for Customers and will post it today adding the Notes field. Great thinking.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: