Tag Archives: Dynamics GP
calculator

SQL view for customer yearly totals in Dynamics GP

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

Read more
briefcase invoice

SQL view for vendor yearly totals in Dynamics GP

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, [...]

Read more
fall_decisions_02

Decisions Fall 2011 – GP Day is today

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.

Read more
orange pen

Protect your investment in Microsoft Dynamics GP

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.

Read more
3d small people - email

SQL view for SOP email setup in GP 2010

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

Read more
Dynamics GP 2010 Implementation

Microsoft Dynamics GP 2010 Implementation – now on Kindle!

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, [...]

Read more
Decisions Spring 2011

Sign up for Decisions Spring 2011

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

Read more
Dynamics GP 2010 Implementation

Dynamics Month at Packt Publishing

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

Read more
boxes

Customer shipping addresses in Dynamics GP

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

Read more
briefcase invoice

Yearly Fixed Assets depreciation totals in Dynamics GP

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

Read more
boxes

Dynamics GP inventory by location with dates

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

Read more
wrenchguy

Change GP fiscal period names using SQL Server

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

Read more
lecture

How much training and for whom?

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.

Read more
Follow

Get every new post delivered to your Inbox.

Join 405 other followers