Tag Archives: Dynamics GP

Voiding a partially applied Payables transaction in Dynamics GP

October 11, 2012 by Victoria Yudin 20 Comments

Periodically I get calls or see questions online about how to void a partially applied Payables transaction in Dynamics GP. This is one area where the Payables module differs drastically from the Receivables module and you have to jump through some hoops to actually accomplish this. The issue is that when you go to void […]

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

Big announcement for Microsoft Dynamics GP’s Extender module

October 8, 2012 by Victoria Yudin 23 Comments

Last week, while searching for something on Microsoft’s PartnerSource, I came across an announcement that Microsoft is discontinuing sales of the Extender module and that both sales and support of Extender will revert back to eOne Solutions, the original developer of Extender, starting February 1, 2013. Please note that eOne has always sold a more […]

Continue reading →
Dynamics GP, Extender, Microsoft
, ,

Using Lookups in GP Reports Viewer to make parameter selection more user friendly

May 31, 2012 by Victoria Yudin 3 Comments

One of the critical elements in reporting is parameter selection. During report creation it is essential to make sure that the proper parameters are added to the report to correctly filter on the data the users want to see. However, it doesn’t just stop there. To ensure user friendly reports it is also very important […]

Continue reading →
Dynamics GP, GP Reports Viewer
,

Finding resources

May 12, 2012 by Victoria Yudin 5 Comments

Almost on a daily basis I find myself looking for things like system requirements, end of support dates, build numbers and downloads for the various products that I work with. Even though search engines have greatly improved over the last few years, I still often struggle to find this information. While I consider myself to […]

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

Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer

February 29, 2012 by Victoria Yudin 11 Comments

 Background / The Problem For many companies a long awaited new feature introduced with Dynamics GP 2010 was the ability to email SOP (Sales Order Processing) invoices directly from GP. Many of our customers have started to offer emailing of invoices to their customers and are seeing an increased number of requests for emailed invoices. However, […]

Continue reading →
Crystal Reports, Dynamics GP, GP 2010, GP Reports Viewer, SOP SQL code
, , ,

SQL view for customer yearly totals in Dynamics GP

January 9, 2012 by Victoria Yudin 35 Comments

As a follow up to my SQL view for vendor yearly totals, here is something similar for customers. I have combined sales less credits/returns in one column, please take a look at the notes above the code (on lines 5 through 16 below) to see more details about the logic I am using. The code […]

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

SQL view for vendor yearly totals in Dynamics GP

January 4, 2012 by Victoria Yudin 20 Comments

There has been a lot of talk lately about the year end close Payables and Receivables. I feel like I have spent the last week or two justifying my reasoning for not needing to perform the year end close for Payables and Receivables to many of my customers and blog readers. (For more on this, […]

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

Decisions Fall 2011 – GP Day is today

December 6, 2011 by Victoria Yudin 3 Comments

Come talk to us about new features in GP Reports Viewer at MSDynamicsWorld’s Decisions Fall 2011 today. I will be there all day along with our senior developer and SRS expert Mickie Stamm.

Continue reading →
Dynamics GP, Events
,

Protect your investment in Microsoft Dynamics GP

November 7, 2011 by Victoria Yudin 3 Comments

MSDynamicsWorld.com has just published my new article called Protect Your Investment: Five Things You Must Document in a Microsoft Dynamics GP Solution. For more of my articles on MSDynamicsWorld, take a look at my profile page. And while you’re there, don’t forget to register for Decisions Fall 2011.

Continue reading →
Dynamics GP
, ,

SQL view for SOP email setup in GP 2010

October 24, 2011 by Victoria Yudin 9 Comments

I am starting to work with emailing SOP documents using Dynamics GP 2010 and new functionality that we are going to be releasing in an upcoming build of GP Reports Viewer. It’s pretty cool stuff, however, as I am working with customers to set this up, we’re finding that out-of-the box GP does not have any […]

Continue reading →
Dynamics GP, GP 2010, GP Reports Viewer, System/Setup SQL code
, , ,

Microsoft Dynamics GP 2010 Implementation – now on Kindle!

June 23, 2011 by Victoria Yudin 3 Comments

Yes, you read that right – my Microsoft Dynamics GP 2010 Implementation book is now on Kindle! I have been thinking about getting a Kindle for a while, and have admired the few I have seen owned by friends and family, but there was no compelling enough reason for me to get one. Until now, […]

Continue reading →
Dynamics GP
,

Sign up for Decisions Spring 2011

May 24, 2011 by Victoria Yudin 3 Comments

MSDynamicsWorld.com is putting on another virtual show in a few weeks called Decisions Spring 2011. My company, Flexible Solutions, has been a sponsor at the last few Decisions events and they just keep getting better. All the Dynamics products have their own day, Dynamics GP day is June 15. You can read all about the exciting […]

Continue reading →
Dynamics GP, Events, GP Reports Viewer
,

Dynamics Month at Packt Publishing

May 16, 2011 by Victoria Yudin 1 Comment

May is Dynamics Month over at Packt Publishing, the publisher for my Dynamics GP 2010 Implementation book, Mark Polino’s Dynamics GP 2010 Cookbook and a newly published Dynamics GP 2010 Reporting book. Now, I personally believe that every month is Dynamics month ;-), but if you’ve been waiting to get your Dynamics books, now is […]

Continue reading →
Dynamics GP
,

Customer shipping addresses in Dynamics GP

February 18, 2011 by Victoria Yudin 14 Comments

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 […]

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

Yearly Fixed Assets depreciation totals in Dynamics GP

February 15, 2011 by Victoria Yudin 13 Comments

Around this time of year we get a lot of questions about closing the year for the Dynamics GP Fixed Assets module, since you cannot run January depreciation until you close the prior year. And right after we start getting requests for reports of prior year depreciation. Here is a view that shows year to date, last year […]

Continue reading →
Dynamics GP, Fixed Assets SQL code, GP Reports code, GP SQL scripts
, , , ,

Dynamics GP inventory by location with dates and sites

January 29, 2011 by Victoria Yudin 13 Comments

In response to a request from a reader, I have created a new version of the Inventory with Dates script to show the same information by Site ID. I also added a Quantity on Order column. You can see more Dynamics GP Inventory scripts here. Or visit my GP Reports page for links to additional GP […]

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

Change GP fiscal period names using SQL Server

January 27, 2011 by Victoria Yudin 15 Comments

Every time I create a new fiscal year in Dynamics GP or show customers how to do it, I get a little frustrated that I have to manually rename all the periods. Some users may not care that instead of January GP displays Period 1, but I don’t think that is very user friendly. So, for more years […]

Continue reading →
Dynamics GP, GP 10.0, GP 2010, GP 2013, GP 8.0, GP 9.0, GP SQL scripts, System/Setup SQL code
,

How much training and for whom?

December 22, 2010 by Victoria Yudin 2 Comments

MSDynamicsWorld.com has just published a follow up to my last article about user training, called “Plan your Microsoft Dynamics GP Training: How Much and For Whom?” This article is an excerpt from my book,  Microsoft Dynamics GP 2010 Implementation, and discusses some ideas to keep in mind as you plan user training for a Dynamics GP implementation.

Continue reading →
Dynamics GP
, , ,
Newer Entries
Older Entries