GP 2016 Resources

• Using credit cards to pay vendors in Dynamics GP January 4, 2009
• SQL view for Payables GL distributions in Dynamics GP November 28, 2008
• SQL view for all posted GL transactions in Dynamics GP August 11, 2009
• Sales Transaction Entry GL distributions in Dynamics GP December 8, 2008
• SQL view to show AP apply information in GP October 22, 2008
• SQL view for Payables payment apply detail in GP October 22, 2009
• Year end close in Dynamics GP November 14, 2008
• SQL view with AR apply detail February 15, 2010
• Granting access to a new SmartList in Dynamics GP October 8, 2008
• SQL view with all SOP line items in Dynamics GP May 17, 2009

• SQL view for unposted checks in Dynamics GP August 29, 2017
• SQL view for rolling 12 months of sales by item by site in Dynamics GP April 20, 2017
• Dynamics GP sales amounts and quantities for rolling 12 months March 14, 2017
• Updating Dynamics GP data directly in SQL January 17, 2017
• Did you know you can change Void dates on Payables transactions? September 20, 2016
• Refreshable Excel report for monthly actuals vs. budgets in Dynamics GP May 25, 2016
• SQL code to show top X percent of vendor data March 21, 2016
• Discount from Packt Publishing September 15, 2015
• Refreshable Excel report for historical GL trial balance in Dynamics GP August 13, 2015
• Refreshable Excel report for monthly GL budget in Dynamics GP April 28, 2015

• 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...