I had a request from a blog reader for a view that shows sales of items by year. This seemed like pretty useful code to create, so I put the following view together. I am making a few assumptions (listed in the view comments), and am hard coding years from 2005 through 2011. You can easily change the years or [...]
Read more
Management Reporter versions
July 4, 2011
6 Comments
I am starting to do some work with Management Reporter, so I thought it would be useful to have a list of the versions for various service pack levels. What I have so far is only for version 2.0 and it may not be complete. If anyone has other versions, please let me know and I [...]
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
Getting the name of a month from the month number in SQL Server
May 23, 2011
15 Comments
I was creating a SmartList for a customer recently and was using the GL11110 and GL11111 views in GP for monthly summaries of P&L accounts, but wanted to show the month names instead of period ID’s to make it a bit more user-friendly. I could have linked to the fiscal period setup table to get the period names, but [...]
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
SQL view for all GL transactions in Dynamics GP
April 27, 2011
1 Comment
I have been asked a few times now to add unposted General Ledger transactions to my Posted GL Transactions view. Here it is. This view also excludes voided transactions and introduces new columns for transaction status and source doc. To see more information about GL tables in Dynamics GP, visit my GL Tables page. For more Dynamics [...]
Read more
SQL view for last sale date of item
March 31, 2011
11 Comments
An interesting question came up in response to my last SQL view showing the last sale by customer and item. How do you show the latest sale of an item and who the customer was for that particular sale? This is a bit more difficult, as you have to make two passes through the data, first [...]
Read more
SQL view for last sale by customer and item
March 29, 2011
7 Comments
When was the last time a particular customer bought a particular item? Here is a little view that will tell you. For other Dynamics GP views and reporting tips, take a look at my GP Reports page. Or check out the SOP Tables page for more details about reporting on SOP data. ~~~~~ CREATE VIEW view_Last_Sale_By_Customer_Item AS /******************************************************************* [...]
Read more
Vote for the top 100 most influential Microsoft Dynamics people
March 17, 2011
8 Comments
DynamicsWorld is once again holding their annual vote for the top 100 most influential Microsoft Dynamics people. If you’ve been inspired or helped by anyone you can show your appreciation by voting for them. The main voting page has a list of all the nominees and a bunch of links to the polls, but it’s a [...]
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
Mark Polino interviews…me!
February 14, 2011
1 Comment
Mark Polino, one of the original Dynamics GP bloggers, a fellow Microsoft Dynamics GP MVP and book author, just published an interview with me about my book, Implementing Dynamics GP 2010. This was the first book interview I did and I was a little nervous, but Mark is a very good listener and knows just how [...]
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 ...
-
