March 24, 2010 
5 Comments
Ron Wilson, who you may have seen posting on various Dynamics GP forums and newsgroups, has recently started a blog called Real Life Dynamics User. Ron has been busy posting tips and tricks, sharing his experiences with Dynamics GP and posting useful SQL scripts and views. Keep up the great work, Ron!
For the Office Space fans out there, please note that Ron’s database is named TSP, not TPS. 🙂
[…] I am amazed at the number of people who are visiting my site. It all started with Victoria Yudin’s post the other day, and now Developing For Dynamics GP, DynamicAccounting.net, and even Twitter […]
LikeLike
[…] I am amazed at the number of people who are visiting my site. It all started with Victoria Yudin’s post the other day, and now Developing For Dynamics GP, DynamicAccounting.net, and even Twitter […]
LikeLike
[…] Victoria Yudin has found another great Dynamics GP blog. So please welcome Ron Wilson and his blog to the […]
LikeLike
Dynamics GP 2013 Implementation
Dynamics GP 2010 Implementation
Using credit cards to pay vendors in Dynamics GP
SQL view for Payables GL distributions in Dynamics GP
SQL view for all posted GL transactions in Dynamics GP
Sales Transaction Entry GL distributions in Dynamics GP
SQL view to show AP apply information in GP
SQL view for Payables payment apply detail in GP
Year end close in Dynamics GP
Granting access to a new SmartList in Dynamics GP
SQL view with all SOP line items in Dynamics GP
SQL view for unposted checks in Dynamics GP
SQL view for rolling 12 months of sales by item by site in Dynamics GP
Dynamics GP sales amounts and quantities for rolling 12 months
Updating Dynamics GP data directly in SQL
Did you know you can change Void dates on Payables transactions?
Refreshable Excel report for monthly actuals vs. budgets in Dynamics GP
SQL code to show top X percent of vendor data
Discount from Packt Publishing
Refreshable Excel report for historical GL trial balance in Dynamics GP
Refreshable Excel report for monthly GL budget in Dynamics GP
Victoria Yudin: Hi Stephanie,
I just tested setting it up in my G...
Stephanie Crawley: Yep, works like a dream when i do that. Our worka...
Victoria Yudin: Hi Stephanie,
Very strange. Are you able to run i...
Stephanie Crawley: Victoria,
I did run the grant script. The weirde...
Victoria Yudin: Hi Stephanie,
Did you make sure to give DYNGRP pe...
Stephanie Crawley: Victoria, thank you so much for the quick response...
Victoria Yudin: Hi Stephanie,
In SmartList Builder you first have...
Stephanie Crawley: I created this view to use in Builder. The view i...
Lenny: Thank you so much for sharing all this info, espec...
Victoria Yudin: Hi Denise,
There is nowhere in AP you can see thi...
 | Victoria Yudin on SQL view with security resourc… |
 | Stephanie Crawley on SQL view with security resourc… |
| Victoria Yudin on SQL view with security resourc… |
| Stephanie Crawley on SQL view with security resourc… |
| Victoria Yudin on SQL view with security resourc… |
Victoria Yudin 
Hi Victoria and Ron
I have added Ron’s blog to the Blog Links and Microsoft Dynamics GP Blog page on the Developing for Dynamics GP blog.
http://blogs.msdn.com/developingfordynamicsgp/pages/microsoft-dynamics-gp-blogs.aspx
David
LikeLike
Thanks for this Victoria! I do hope that what I write will be useful to others.
As useful as those TPS reports are, we are starting to go away from them and have started using SSRS reports :).
Ron
LikeLike