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

• Beth Hodge: In case this helps anyone the fields are PM30200.V...
• Shelby Williams: You saved me a significant amount of work tonight!...
• Victoria Yudin: Hi Chris, Glad to have been able to help! I don't...
• Chris Jackman: Hi Victoria, I just want to say thank you for all...
• Victoria Yudin: Good luck Kory. Let me know if I can help with any...
• Kory Taylor: Thank you Victoria, unfortunately we already tried...
• Victoria Yudin: Hi Kory, Thanks for your kind words. One thing y...
• Kory Taylor: Hello Victoria, Just want to take a minute and sa...
• Victoria Yudin: Hi Steven, Have you looked at the TX30000 table? ...
• Steven Blanc: Hi Victoria, I am trying to build a tax report an...