How to get rid of the blank page at the end of a Crystal report

January 12, 2009 by Victoria Yudin 50 Comments

Here is a tip from the Flexible Solutions GP Reports newsletter: Often when creating a Crystal report for something that needs a new page for each group (like Invoices or Purchase Orders) we use the New Page After option for the Group Footer in Crystal’s Section Expert.  This works great, however it prints a blank […]

Continue reading →
Crystal Reports, GP Reports code
,

SQL view to show customer pricing

January 7, 2009 by Victoria Yudin 18 Comments

Here is a view to show customer specific item pricing in Dynamics GP when using standard pricing.  This will work either with SmartList Builder or Crystal Reports as I have made sure not to put any spaces in the names.  If you are using SmartList Builder this means you may want to go down the […]

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

Using credit cards to pay vendors in Dynamics GP

January 4, 2009 by Victoria Yudin 187 Comments

There are a number of different ways to record paying vendors with credit cards in GP.  This is a topic that comes up periodically in newsgroups and I would like to share what I have personally found to be the most straightforward and comprehensive way.  This is a long one but at least there will be […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, GP 8.0, GP 9.0
,

Dynamics GP MVP award

January 1, 2009 by Victoria Yudin 13 Comments

  I just got the news that I have been presented with the 2009 Microsoft® Most Valuable Professional Award for Dynamics GP for another year.  This is a great honor for me, as I believe I am the only person who has received the Dynamics GP MVP award each consecutive year since 2005.  If you’d like to […]

Continue reading →
Dynamics GP, Microsoft
,

Payables Return transactions in Dynamics GP

December 30, 2008 by Victoria Yudin 51 Comments

There is a little known, but very useful transaction type in the Payables module called Return.  Every few weeks or so I see a question in the newsgroups or a call comes in from a customer where the answer is to use the Payables Return transaction.  A typical scenario where a Return is needed goes something […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, GP 8.0, GP 9.0

New page with resources

December 22, 2008 by Victoria Yudin 2 Comments

I have published a new page called Resources that has links to information I am either frequently looking up or I am being asked for routinely.  Stuff like Dynamics GP system requirements, printer compatibility lists, how to translate a build number in GP, FRx or SQL Server to a specific service pack, when support for various versions […]

Continue reading →
Dynamics GP, FRx, SQL Server
, , , ,

Reporting on Extender data in Dynamics GP

December 15, 2008 by Victoria Yudin 24 Comments

Dynamics GP Extender is one of those modules that has so much in it, most people don’t use even half of it.  One of the most underused features is Extender Views.  Anyone that has worked on reports using data entered into Extender windows will tell you that getting data directly out of Extender tables is a challenge.  All […]

Continue reading →
Dynamics GP, Extender
,

Sales Transaction Entry GL distributions in Dynamics GP

December 8, 2008 by Victoria Yudin 108 Comments

The topic of General Ledger distributions for Sales Order Processing transactions has been known to cause a fair amount of confusion for Dynamics GP users.  I would like to address some of the typical questions we receive on this. Please click on the screen shots to see them larger/clearer.  Just to set the stage, I am talking about the […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, GP 8.0, GP 9.0
, ,

How to show only invoices on the payables check stub in GP

December 3, 2008 by Victoria Yudin 9 Comments

Here is a question that is brought up frequently by Dynamics GP users – how do we only show invoices that we are paying with this AP check on our check stub?  By default GP will show you everything applied, including credit memos and even non-check payments made between the current check and the last one.  There are 2 […]

Continue reading →
Dynamics GP
,

Useful SQL Scripts series from Developing for Dynamics GP

December 1, 2008 by Victoria Yudin 0 Comments

The Developing for Dynamics GP blog has started a new Useful SQL Scripts series.  This is brought to us by David Musgrave and a very impressive team of Microsoft Dynamics GP support engineers.  Many of these engineers have helped us tremendously over the years and I am looking forward to new additions for this series. Important note – the links will […]

Continue reading →
Dynamics GP, GP SQL scripts

SQL view for Payables GL distributions in Dynamics GP

November 28, 2008 by Victoria Yudin 174 Comments

Here is a view that will return the General Ledger distributions for all posted or unposted payables transactions.  Unposted is also called ‘work’ and posted includes any open or historical transactions.  If you’re going to use this with SmartList Buidler, make sure to include the section at the end to grant permissions to DYNGRP. Disclaimer: I […]

Continue reading →
Dynamics GP, GL SQL code, GP Reports code, GP SQL scripts, Payables SQL code
, , , ,

Dynamics GP Fixed Assets table information

November 20, 2008 by Victoria Yudin 1 Comment

I have posted up a new page with Dynamics GP Fixed Assets table information.  This is part of my ongoing library of Dynamics GP reporting information.  A directory of all the information I’ve posted up so far is on the main GP Reports page.

Continue reading →
Dynamics GP
, ,

Dynamics GP Integration Manager – vote for product suggestions

November 17, 2008 by Victoria Yudin 0 Comments

Beth Gardner, Support Escalation Engineer for Microsoft Dynamics GP, is looking for votes on product suggestions for Integration Manager.  GP users ask us all the time how to get their suggestions implemented – this is the way. Microsoft does look at what customers are saying and the way to get the functionality you want included into future versions is to […]

Continue reading →
Dynamics GP
,

MDA is here to stay

November 12, 2008 by Victoria Yudin 0 Comments

Thanks to Mark Polino at DynamicAccounting.net for alerting me to Microsoft’s announcement that Multidimensional Analysis (MDA) will continue to be sold and supported for Dynamics GP.  Mark’s post has a link to the official announcement, however if you do not have access to Microsoft Dynamics PartnerSource you won’t be able to get to it.  The basic gist […]

Continue reading →
Dynamics GP

SQL view for Crystal Reports to show open AP invoices from multiple companies in GP

November 10, 2008 by Victoria Yudin 0 Comments

In my experience Crystal Reports really doesn’t like it when you have spaces in your field names. I’ve gotten a request for a ‘Crystal’ version of the Multicompany Open AP view I posted up a few days ago, so here it is. Please follow the in-line directions in green to change the generic company names […]

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

SQL view to show open AP invoices from multiple companies in GP

November 8, 2008 by Victoria Yudin 0 Comments

If you have multiple companies in GP and want to create a quick view to show a combined list of all the open AP invoices, you can use the example below.  I am not doing anything fancy here, just hard coding the company names and database ID’s.  In my experience this is a set list for most […]

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

Adding Extender Data to SmartLists

November 3, 2008 by Victoria Yudin 35 Comments

This has been a very popular question for support lately: “I have created an Extender window, how do I add data from it to my SmartLists?”  Extender includes the ability to add fields to both existing SmartLists or ones created in SmartList Builder.  Below is an example using GP 9.0.  [Click on any of the […]

Continue reading →
Dynamics GP, Extender, SmartList Builder
, , ,

When does my SQL Server support end?

October 29, 2008 by Victoria Yudin 15 Comments

Did you know that mainstream support for SQL 2012 ended in July of 2017? Here is a list of the SQL versions and the relevant release and support end dates:   SQL Server Version Release Date End of Mainstream Support End of Extended Support Link SQL 7 Mar 01 1999 Dec 31 2005 Jan 11 […]

Continue reading →
SQL Server
, ,
Newer Entries
Older Entries