Archive | April, 2009

SQL view with all posted Receivables transactions

April 24, 2009 by Victoria Yudin 30 Comments

Below is code to create a SQL view that returns all the posted Receivables transactions in Dynamics GP. I have had an abbreviated version of this view on my GP Reports page for a while, but I cleaned it up a bit and gave it some more friendly column names. I also added values for the commonly used […]

Continue reading →
Dynamics GP, GP Reports code, GP SQL scripts, Receivables SQL code
, , ,

How to use a SQL view in SmartList Builder

April 20, 2009 by Victoria Yudin 43 Comments

Something I have been asked more than a few times is how to use a SQL view in SmartList Builder to create a new SmartList.  I am going to walk through this step by step using Dynamics GP 10.0 SP 3 and SQL Server 2005 SP 3:   STEP 1  –  create SQL view To start […]

Continue reading →
Dynamics GP, GP SQL scripts, SmartList Builder
, , , , ,

Where did my transaction go?

April 11, 2009 by Victoria Yudin 7 Comments

This is a common question, especially with new users of Dynamics GP, and I was recently reminded of it by a post in the Microsoft Dynamics GP Newsgroup. While every transaction type will be slightly different, there is a basic lesson that is important for all GP users: beware of the Delete button. Most GP actions are updated automatically […]

Continue reading →
Dynamics GP
, , ,