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 [...]
Read more
Tag Archives: Dynamics GP
Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer
February 29, 2012
1 Comment
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, [...]
Read more SQL view for customer yearly totals in Dynamics GP
January 9, 2012
8 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 [...]
Read more SQL view for vendor yearly totals in Dynamics GP
January 4, 2012
6 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, [...]
Read more Decisions Fall 2011 – GP Day is today
December 6, 2011
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.
Read more Protect your investment in Microsoft Dynamics GP
November 7, 2011
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.
Read more SQL view for SOP email setup in GP 2010
October 24, 2011
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 [...]
Read more Microsoft Dynamics GP 2010 Implementation – now on Kindle!
June 23, 2011
1 Comment
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 Sign up for Decisions Spring 2011
May 24, 2011
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 [...]
Read more Dynamics Month at Packt Publishing
May 16, 2011
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 [...]
Read more Customer shipping addresses in Dynamics GP
February 18, 2011
1 Comment
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 Yearly Fixed Assets depreciation totals in Dynamics GP
February 15, 2011
6 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 [...]
Read more Dynamics GP inventory by location with dates
January 29, 2011
10 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 [...]
Read moreMy Book
-
SQL view for Payables GL distributions in Dynamics GP
-
Using credit cards to pay vendors in Dynamics GP
-
Year end close in Dynamics GP
-
SQL view for Payables payment apply detail in GP
-
SQL view for all posted GL transactions in Dynamics GP
-
SQL view to show AP apply information in GP
-
SQL view with all SOP line items in Dynamics GP
-
Granting access to a new SmartList in Dynamics GP
-
Sales Transaction Entry GL distributions in Dynamics GP
- Dynamics GP Trial Balance in Excel using FRx
-
Finding resources
-
SQL view for sales quantities by customer by item by year
-
Emailing SOP invoices in GP 2010 made easy with GP Reports Viewer
-
Microsoft Dynamics Mayhem
-
SQL view for current Receivables aging in Dynamics GP
-
SQL view for sales quantities by item by year
-
SQL view for customer yearly totals in Dynamics GP
-
SQL view for vendor yearly totals in Dynamics GP
-
Happy New Year – 2012
-
SQL view to show monthly totals for Dynamics GP Vendors
-
Victoria Yudin: Hi Khan, GP does not store information about who ...
- Dynamics Confessor Blogspot - GP Technical Blogs - Microsoft Dynamics Community: [...] each module. If you are creating reports, or...
-
I Khan: Hi Victoria, I created a SmartList using Segment ...
-
-
kyle: Victoria, you have some great AP payment/apply sql...
-
-
-
Bill Schulz: Victoria - Your site is awesome. Thanks for thi...
-
Debbie: Thanks Victoria! I ran the query and had no resul...
-
