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
Tag Archives: Dynamics GP
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
1 Comment
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
4 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
4 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
8 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 more Change GP fiscal period names using SQL Server
January 27, 2011
8 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 [...]
Read more How much training and for whom?
December 22, 2010
0 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.
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 to show AP apply information in GP
-
SQL view with all SOP line items in Dynamics GP
-
SQL view for all posted GL transactions 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
-
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
-
Decisions Fall 2011 – GP Day is today
-
Protect your investment in Microsoft Dynamics GP
-
SQL view for SOP email setup in GP 2010
-
Holiday status poll
- Interesting Findings & Knowledge Sharing » GL Trial Balance in FRx: [...] is an easier way using FRx. Victoria Yudin...
-
Victoria Yudin: Hi Kelly, I have not seen this happen before, ...
-
Kelly: Hi Victoria, I am using GP 10 and have noticed ...
- GL Trial Balance in FRx - gp2themax - GP Technical Blogs - Microsoft Dynamics Community: [...] is an easier way using FRx. Victoria Y...
-
-
chris: Hi Ms. Victoria, Our fiscal year is about to en...
-
-
Mike: Hi victoria, your site is very helpful! I recent...
-
Steve Kobzos: Victoria, I didn't reblog your script, but had ...
-
