Victoria Yudin

April 2009 - Posts

• 0 Comments 1,723 Views

  SQL view with all posted Receivables transactions 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... Read More... Published: Friday, April 24, 2009, 03:26 AM Tags: Receivables, SQL code, Dynamics GP, GP Reports, GP SQL scripts, Crystal Reports, SmartList Builder

• 0 Comments 2,267 Views

  How to use a SQL view in SmartList Builder 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... Read More... Published: Monday, April 20, 2009, 09:43 AM Tags: Payables, SQL code, Dynamics GP, GP Reports, GP SQL scripts, GP SQL view, SmartList Builder

• 0 Comments 1,892 Views

  Where did my transaction go? 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... Read More... Published: Saturday, April 11, 2009, 04:57 AM Tags: Payables, General Ledger, Dynamics GP, Sales Order Processing