Everything Dynamics GP #9

“No problem can withstand the assault of sustained thinking.”—Voltaire

Now you can subscribe to Everything Dynamics GP via email

GP

• Using Microsoft Access to Create Reports for Dynamics GP (Charles Allen) – This is great, a word of advice – If you are on SQL 2008, you need to be on Access 2010 as well(that is supported). I recently saw a case where a customer using Access 2007 had issues running these reports after they had upgraded to SQL 2008
• Zero Dollar Checks and Dynamics GP—Why? (Christina Phillips)
• Microsoft Business Intelligence Gets Thumbs-up from Gartner (ERP Software Blog)
• Microsoft Dynamics GP and Office 365 - Better Together Video (CustomerSource)
• Feature Explained: Remember User & Password | azurecurve  and Feature Explained: Payables Select Checks Enhancements - In case you missed these, Ian Grieve has a nice recap with screenshots.
• Exporting Data to a Text File from GP - Steve Priest  uses Dexterity and SQL Triggers to export data our of from Dynamics GP
• Weekly Dynamic: Fix Bonus Depreciation (Mark Polino)

Reports

• Payables HATB With Aging By Due Date (using GL Posting Date) – After creating the awesome Receivables HATB Scripts Sivakumar Venkataraman is back with the Payables HATB SQL Scripts
• Payables HATB With Aging By Due Date (using Document Date)
• Payables HATB With Aging By Payment Terms (using GL Posting Date)
• Payables HATB With Aging By Payment Terms (using Document Date) 

Events

• From GPUG : Dynamics GP users - are you signed up for Summit 2011 in Vegas? Early Bird registration ends this week!  GPUG Summit 2011 

GP ISVs

• M-Files Cloud Vault Brings Easy Document Management Based on Windows Azure to Microsoft Dynamics GP – This looks very interesting !
• “Hybrid” Cloud Approach Enables Firms to Leverage the Cloud While Maintaining Existing On-Premise Systems | M-Files Easy Document Management

Database

• Lookup functions in SSRS 2008 R2 - I - Juggling With SQL - SQLServerCentral.com 
• PowerPivot Denali – Upgrading from SQL Server 2008 R2 and KPIs | SQLServerPedia

Other Interesting Stuff

• What I’ve learned about creating product videos 
• The Art of Readable Code - OFPS - O'Reilly Media
• Sharing your Visual Studio Projects cleanly with CleanProject - Greg's Cool [Insert Clever Name] of the Day
• Cloud Feed » Blog Archive » Daily Cloud Feed - Jul 24, 2011
• Guest Post: Good Programmers Make Bad Designers | Caffeinated Coder 

Dynamics GP Videos of the Day

• Microsoft Dynamics GP Quick Journal (Belinda Allen) - Quick Journals are used to Enter Transactions that are entered on a regular basis. What makes them “quick” is that once setup, only the amounts needs to be entered on new entries. See how I setup a Quick Journal and watch me enter and post one!

Jivtesh (Dynamics GP MVP) 
Have any GP related questions ? Feel free to email me at Jivtesh AT gmail.com
Blog : www.jivtesh.com
GP Help Website : www.gpwindow.com (Over 10,000 Dynamics GP Resources)