Everything Dynamics GP #11

Ryan Sandness reminds us that Demo Reports for Management Reporter are available. If you haven’t already, you should go get the ones for Microsoft Dynamics GP.

Now you can subscribe to Everything Dynamics GP via email

GP

• IMPORTANT FYI for US Installs : Having the module 'Payment Document Management' installed could cause Performance Issues in Purchasing and Sales in US installs of Microsoft Dynamics GP (Cheryl W. [MSFT] )
• Automating the start and stop of Microsoft Dynamics GP logs with the Support Debugging Tool - Part 2 (Mariano Gomez) – Completes  this awesome walk-through.
• How to enter a refund for customer in Microsoft Dynamics GP? | Dynamics GP Help (Rubal) – discusses in detail, the various options related to customer refunds. 
• Not Privileged To Run this Report Error in Payables Select Checks | (Ian Grieve) – writes about giving security permissions for the send remittance preview report
• You receive a "Fee Amount cannot be less than the amount that has been recognized" error message when you change a project fee in Microsoft Great Plains (New KB)
• Microsoft recognized by Gartner as a Leader and Visionary in 2011 Magic Quadrant for Sales Force Automation (Kevin Machayya)

Events

• GPUG Academy Course 80199A: Project Managing Dynamics Implementations with Sure Step (Aug 2011)
• GPUG Meeting: Mark Your Calendars – Sept 21, Portland, ME

Reporting

• International Financial Reporting Standards - Are You Ready? (Frank Hamelly) – has an excellent post about the move to IFRS, and the changes you need to be aware of. Another reason to move to GP 2010 if you have not already.

Dynamics GP Videos of the Day

• www.GPwindow.com Your Window into Microsoft Dynamics GP Resources (Belinda Allen) – Belinda plays around with GPWindow.
• Adding the Developer tab in Microsoft Word after installing the Microsoft Dynamics GP Add-in‬‏ – YouTube - This video will cover how to add the Developer tab in Word 2007 and Word 2010 after installing the Microsoft Dynamics GP Add-in for Microsoft Word.
• Dynamics blogger Video channel on You tube - Janakiram M.P has started his Youtube Channel and begins with a couple of Dynamics GP 2010 Auto Login and Excel And Dynamics GP Export Solutions in Smart list

Other Interesting Stuff

• Social Media Positioning Nominations | DynamicsWorld 
• Governments Embracing Cloud Models - Viewpoints - Site Home - MSDN Blogs
• Microsoft® Visual Studio® LightSwitch™ 2011 is Available Today - Jason Zander's WebLog - Site Home - MSDN Blogs
• Microsoft Download Center - Cloud Computing and Your Privacy

 

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)

Everything Dynamics GP #10

You want a DexSQL Log for just a specific window or set of operations  in Dynamics GP ?  Mariano Gomez has a fantastic article about it - Automating the start and stop of Microsoft Dynamics GP logs with the Support Debugging Tool - Part 1

Now you can subscribe to Everything Dynamics GP via email

GP

• Going Vertical with Dynamics GP - Mad Mark, the GP Road Warrior – Mark Polino talks about his experience with using GP in the media industry, and Sivakumar Venkataraman points to DynamicsADvantage for Broadcast, Advertising, Publishing integrates with Microsoft Dynamics GP in the comments.
• Feature Explained: Allow Account Entry (Ian Grieve) – explains why it is useful to turn this off for certain accounts, and how.
• Upgrade Details for Dynamics GP - Sivakumar Venkataraman (… and no I am not typing it - I now have his name in my quick clipboard) has the links for GP Upgrades. You can also find all Dynamics GP upgrade related information at GPWindow.com - Dynamics GP- SUPPORT (TECHNICAL) > Upgrades 
• Analytical Accounting: Dimension Code Macro (Janakiram M.P)
• Reconcile to GL Oddity (Christina Phillips) – shares a possible issue after voiding a check  on the fly.
• Microsoft Dynamics GP Payables Management Check Stub (Belinda Allen) -  on why credits and returns; along with the invoices they are applied to, show up on computer checks

Support Debugging Tool

• “rsItemNotFound” error when clicking on any Navigation List in GP 2010 R2 (SP2) (Japheth Nolt) – Makes good use of the support debugging tool to resolve a complicated problem.
• Defaulting "Include Totals and Deposits" in Sales Transfer Entry with the Support Debugging Tool (Mariano Gomez) – shows in very simple steps on how to enable a checkbox in a GP Window, to avoid errors.
• Support Debugging Tool Build 15 update released - Developing for Dynamics GP - (David Musgrave) – has an update.
• SQL Where Clause to XML Export Window – Support Debugging Tool Build 15 | Dynamics GP Help (Rubal) .

If you are just getting started with Support Debugging tool, check out all the articles and links at  GPWindow.com - Dynamics GP- TOOLS FOR GP > SUPPORT DEBUGGING TOOL, especially the support debugging tool portal page.

Events

• Virtual Town Hall Meeting (QandA) With Microsoft's Mark Albrecht  (Pam Misialek) – Meeting with Mark Albrecht, Microsoft's Director of US ISV Strategy

Other Interesting Stuff

• Get Your New Consultants Ramped and Ready with Tips on the World of Consulting Kevin Machayya –New seminars for Microsoft Partners
• Consultant Tools Series: Macbook Air -- with Windows! (Steve Endow) – shares his experience on using Windows on Macbook Air. I’ve been tempted, but thanks Steve – knowing I will have to relearn my keyboard shortcuts, just made up my mind. 
• History Reimagined using Microsoft Office Videos (David Musgrave)
• Nobody's Going to Help You, and That's Awesome 

Dynamics GP Videos of the Day

• Microsoft Dynamics GP Adding a GL account Number – Belinda has information about adding a GL Account, and a special “Belinda Trick” to make the entry quicker!
• Keeping Report Writer in Synch with Word Templates – Video - Dave Dusek  points out when and why its important to keep the report writer fields in Sync with the content controls on the word template

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)

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)

Everything Dynamics GP #8

Thomas Friedman thinks the next generation might be inventing their jobs, rather than finding them. The Startup of You.

Now you can subscribe to Everything Dynamics GP via email

GP

• Reconciling unchanged bank statements (Mariano Gomez) – Mariano tackles an interesting Bank Rec problem
• Microsoft Dynamics GP Error- Unable to open customizations dictionary | Dynamics GP Help - (Rubal) – digs into all the possible options to resolve this issue.
• Could Not Add Separator Item (Ian Grieve) – troubleshoots an error message on login related to the Menu Master table.
• Feature Explained: Payables Select Checks Enhancements (Ian Grieve)
• Zero Dollar Checks and Mekorma MICR (Christina Phillips)
• How to reset your Report Manager password. (Tudor Coleman)
• Inventory year-end closing procedures in Inventory Control in Microsoft Dynamics GP (from Customersource)

ISV News

• Demand Management, Inc. Wins Microsoft Dynamics ISV of the Year for the U.S. – MarketWatch

Database

• T-SQL IntelliSense enhancements in SSMS –Denali - SQL Server Manageability Team Blog - Site Home - MSDN Blogs – This is awesome, I have personally used Red-Gate’s SQL IntelliSense tools, but this looks very promising!
• Partial name matching in SQL Server 2011 “Denali” - SQL Treeo - SQLServerCentral.com
• Linchi Shea : Performance impact: stored procedures, SQL batches, and CPU usage

Other Interesting Stuff

• The Guide to Creating Quality Technical Screencasts (Scott Hanselman) – Most people in our GP Video of the day seem to be following the tips.
• SandHill.com | Opinion : Making a Successful Software Licensing and Entitlement Management Project a Reality

Dynamics GP Videos of the Day

• Using Analytical Accounting to Analyze Your Data- Dynamics GP‬‏ – YouTube (Charles Allen)

 

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)

Everything Dynamics GP #7

Friday. "If You're Not Making Mistakes, then You're Not Doing Anything."

You can subscribe to Everything Dynamics GP via email

GP

• Integrating external data into Dynamics GP 2010 | Dynamics GP ( example when integrating Dynamics GP with restaurant Point of Sale system (POS) and the restaurant’s Back of the House system (BOH)”
• “rsItemNotFound” error when clicking on any Navigation List in GP 2010 R2 (SP2) (Japheth Nolt)
• Weekly Review: Calculate Tax in the GL (Mark Polino) – How to enable the “Tax Entry” button in the GL Transaction entry window.
• Receivables HATB With Aging By Payment Terms (using Document Date) (Sivakumar Venkataraman)
• Receivables HATB With Aging By Payment Terms (using GL Posting Date)(Sivakumar Venkataraman)
• Receivables HATB With Aging By Due Date (using Document Date) (Sivakumar Venkataraman)
• Reporting Tools Setup in GP 2010 R2 | dynamicsgpinsights.com (Christina Phillips ) 
• How to Use and Troubleshoot Report Writer in Microsoft Dynamics GP (Partnersource)

GP Add On Software

• OpenMind: Dynamics GP to CRM Template 5.1 – Scribe’s new release is out
• Microsoft Dynamics GP (GreatPlains) Integration | db Sync 

GP Partners/Sales

• 2win Class Prices to Increase as of October 1, 2011 - Attend Classes Now to Save Money! (Kevin Machayya)
• Customer Videos that support the Dynamics GP Story (Errol Schoenfish)
• Microsoft Case Study: Microsoft Dynamics GP - Gregory Greenfield & Associates, Ltd.

SQL

• SQL Server Denali Feature Watch - FORMAT(), as in, "OMG we finally get .Net like Number/Date/Time formatting in our TSQL" Or "Saying goodbye to my old friend, Convert(103)..." - Greg's Cool [Insert Clever Name] of the Day Another example -  SQL Server – "Denali" – String Formatting using FORMAT() | SQLServerPedia
• In SQL server, How to see the standby file path when we restore the database in standby mode: - Harsh's Blog - Site Home - MSDN Blogs
• SQL Script for Generating Insert Statements From Table Data

Other Interesting Stuff

• Introduction to the Sharepoint Integration with Azure – CodeProject
• The question of Sharepoint and the Microsoft BI Strategy | SQLServerPedia 
• 36 Resources To Help You Teach Kids Programming
• Build Your Next Game with the Windows Azure Toolkit for Social Games - Windows Azure - Site Home - MSDN Blogs
• What, Turn Down a Job?

Dynamics GP Videos of the Day

• Microsoft Dynamics GP Checkbook Balance Review (Belinda Allen)

 

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)

Everything Dynamics GP #6

As some of your requested, now you can subscribe to Everything Dynamics GP via email. Enjoy!

GP

• Shrinking and Expanding Microsoft Dynamics® GP’s Chart of Accounts Structure – Part 2 (Gloria Braunschweig) – How to keep the COA simple.
• Receivables HATB With Aging By Due Date (using GL Posting Date) (Sivakumar Venkataraman). He had posted Receivables HATB by GL Posting Date earlier.
• Compare SAP/Oracle applications to Microsoft Dynamics GP
• Getting Started with PartnerSource – New Online Video Tutorials (Kevin Machayya) – Worth checking out if you need help finding stuff at Partnersource
• How to Setup the Word Template Functionality in Microsoft Dynamics GP 2010 – At Customersource/Partnersource
• Microsoft Dynamics Gp In Europe | (Ian Stewart)
• Archive Microsoft Dynamics GP data with Company Data Archive (CDA) - 10% off
• Risk Management: How to Mitigate Risk During an Audited Upgrade with Microsoft Dynamics GP - Part 2 | MSDynamicsWorld.com (Gloria Braunschweig)

Cloud/Hosting

• Less Time, More Value—the Promise of Microsoft Dynamics ERP RapidStart Services - Inside Microsoft Dynamics AX - Site Home - MSDN Blogs – This article covers Dynamics AX , but this should be coming to GP soon. This looks awesome ! Check out this screenshot

Database

• Less Than Dot - Blog - TRY_CONVERT in SQL Server Denali CTP3 – A nice new SQL Function
• SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 20 of 31 « Journey to SQLAuthority

GP Jobs

• Microsoft Dynamics GP Consultant at Pinnacle Group of Indiana in South Bend, Indiana Area - Job | LinkedIn
• Job: MS Dynamics GP (ERP) Technical Application Specialist - L.A.! | Bullhorn Reach
• Find Jobs - Dynamics GP Systems Analyst - Edmonton, CAN - $85K - $95K Jobs in Edmonton, Alberta - Nigel Frank International
• Dynamics GP Consultant – $80-$110k – South Florida
• Job: Microsoft Dynamics GP Consultant/GL Consultant DELAWARE | Bullhorn Reach

Other Interesting Stuff

• New book: Windows Sysinternals Administrator’s Reference - Microsoft Press - Site Home - MSDN Blogs – If you have ever been involved in troubleshooting on Windows you have probably used these tools. If you have not – I highly recommend checking them out!
• The Office Show: Office 365 - Part Two | The Office Blog | Channel 9
• San Jose in the Cloud (Jack Boyer) – talks about Intacct and compares it with GP
• Neowin.net - Microsoft opens up new Garage offices – This is a great idea! Hopefully it will lead to many more utilities and apps coming out of Microsoft.
• Harry Potter Ends But Dynamics GP Is Still Going Strong! | ERP Software Blog – Funny!

Dynamics GP Videos of the Day

• Microsoft Dynamics GP: 2010 R2 Demo Video‬‏ – YouTube 

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)

Everything Dynamics GP #5

Lots of cloud related news today. I am still envious that AX is getting that launch ahead of GP.

Also, good news for Microsoft fans – independent surveys point out that - Windows Phone 7 Users Happier Than Android, RIM Users. I have been thinking of getting  a Windows 7 phone myself to replace my Droid, any suggestions ?

Now you can subscribe to Everything Dynamics GP via email

GP

• Comparing Microsoft Dynamics GP to NetSuite
• Recurring Payables Batches (Lindsay Walsh)
• Advanced Apply for AR Cash Receipts within Dynamics GP (Add On Software)
• How to Use and Troubleshoot Report Writer in Microsoft Dynamics GP – At Customersource
• MR Notes from Mickey MR Different segment labels prevents consolidation reports from working , Missing Fonts causes Management Reporter to crash, MR Different segment labels prevents consolidation reports from working and MR Number Row Number Format Mask Overriden

Cloud/Hosting

• RoseASP Offers iPhone Access to Dynamics -  I saw the app in the app store last month, good to see them promoting this.
• Why is the Cloud so important to software developers? - Education - Site Home - MSDN Blogs (Ray Fleming)  - “A small Coffs Harbour company was sandwiched between two global giants - Desire2Learn (6 million users) and Cornelsen Publishers (3,000 employees and a turnover of 450 million Euro). They’re a small regional Australian business that’s competing against the world’s biggest and best.”
• Microsoft Dynamics ERP Countdown to the Cloud Training & Offer (Kevin Machayya ) - Cloud Leadership Video Series
• Cloud Feed » Blog Archive » Daily Cloud Feed - Jul 18, 2011 – For more cloud info and news

Other Interesting Stuff

• How To Do Everything Wrong – wrong wrong wrong wrong wrong …. !
• Richard Branson on the Art of Delegation 
• GeekAtSea - The Adventures of a Seattle Wantrepreneur: The heart has reasons that Reason knows nothing of. – Geeks and Romance

Dynamics GP Videos of the Day

•  Microsoft Dynamics GP Professional Service Tools Library / Combine GL Accounts (Belinda Smith) combining 2 GL accounts into 1 GL account. I use the Professional Service Tools Library (PSTL) to do it.
• Debugging Word Templates in Microsoft Dynamics GP 2010 – Video (Dave Dusek) – Also in HD

Jivtesh (Dynamics GP MVP)

Have any GP related questions ? Feel free to email me at Jivtesh AT gmail.com

www.jivtesh.com

Everything Dynamics GP #4

It’s a Tuesday that feels like a Monday.

GP

• Unit Accounts and Beginning Balances in Dynamics GP (Charles Allen)
• Populate Rounding Account On Multicurrency Payables Transactions Created Via eConnect (Aaron Berquist)
• Sales Orders Import: Location ID does not exist (Janakiram M.P, who is on a roll, drinking a lot of Red Bulls)
• Integration Manager crashes (Janakiram M.P)
• Weekly Dynamic: Negative SOP Line Distributions (Mark Polino)
• Streamline User security with Dynamics GP 2010 Security Enhancements (Gilchrist Scott)
• Error 'Microsoft Internet Explorer has encountered a problem and needs to close.' attempting to open views within FRx Forecaster

Database

• SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 16 of 31 and SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 17 of 31 and SQL SERVER – Interview Questions and Answers – Frequently Asked Questions – Day 18 of 31 (Pinal Dave)

Other Interesting Stuff

• Microsoft Dynamics July 2011 News & Highlights (Kevin Machayya)
• The Difference Between Success and Not Failing, Ethereal Mind
• What having a daughter taught me about business - Part I, Time Producer

Dynamics GP Video of the Day

• Extended Pricing in Dynamics GP‬‏ – YouTube (Steve Chapman)

Everything Dynamics GP #3

Lets begin today with one of my favorite comics - XKCD – ‘Cancer Causes Cell Phones!’ http://xkcd.com/925/

GP

• Import Kits, Import Inventory BOM FAQs and Import Inventory BOM (Janakiram M.P) – Great tips about importing Inventory data into GP 
• A Classic Post - Paying Vendors with CC (Victoria Yudin)
• SQL Script for Vendor EFT Information (Sivakumar Venkataraman) shares a SQL view that returns the details of the EFT Information for the various vendors setup in the company
• Jack Boyer's ERP Blog: Dynamics GP for Dummies
• Closing The Month Faster with Dynamics SL and GP (Jack Boyer) – Bullet points from Steven Bragg’s book  “Accounting Best Practices”

GP Reporting

• Microsoft Dynamics GP 2010 Guides: Analytics and Reporting 
• SSRS: The deployment has exceeded the maximum request length allowed by the target server (Mariano Gomez)

GP 3rd Party Software News

• Binary Stream GP 2010 R2 Release Update
• SmartPost on the Shelf 

GP Events

• Management Reporter - Join me at MR Focus 2011! (Jill Carter)
• Dynamics GP Events you do NOT want to miss – Get them into the Budget Now: | Dynamics GP Tips & Information Blog
• WPC Wrap Up (Steve Chapman)

Other Interesting Stuff

• Switching to a New Dynamics NAV (Navision) Service Provider - Confessions of a Dynamics NAV Consultant | Confessions of a Dynamics NAV Consultant – Nice tips by (Alex Chow), apply to GP as well.
• A Non-Designer's Guide to Creating Awesome Diagrams for Slides [Presentations]
• Windows 7 Application Compatibility Screencast (Jennifer Marsman)
• 33 Lessons for Software Industry Novices, TPH

Dynamics GP Video of the Day

• Microsoft Dynamics GP Vision: Creating an RFP - This "vision" demonstration shows how Partners can leverage the power of SharePoint and Microsoft Dynamics GP to deliver rapidly customized solutions and better manage the Request for Proposals (RFP's) that meet specific customer needs.

Everything Dynamics GP #2

How about beginning with a quote for the day - “Fish don't know they're in water.” via http://sivers.org/fish

GP

• Troubleshooting issues caused by customizations (David Musgrave) – David quickly resolves an issue using the Support Debugging Tool's Dictionary control window and Security Profiler window.
• Backing Out and Correcting Journal Entries (Christina Phillips)
• Support Debugging Tool Build 15 released- Desktop Alerts. (Rubal) highlights her favorite feature in the latest build.
• Use Dynamic SQL To Generate a Dynamics GP Login Macro (Aaron Berquist) came up with this trick when he had to login to 150+ GP companies!

GP Reporting

• SmartList Builder and creating Calculated Fields with Extender data (Mariano Gomez) – Great tip when using Extender and Smartlist Builder (left join scenarios)
• Hidden Reporting Tools Rundown (Christina Phillips) – Christina says Letter Writing Assistant, Templates and Export Solutions dont get the attention they deserve in Dynamics GP world.
• FRx Replacement: How to list your existing FRx reports in Excel (Jan Harrigan) – shows how to quickly export the list of FRx reports to Excel.
• Management Reporter Reports Stuck in Queue (Tudor Coleman) – Causes and Fixes

Database

• My biggest recommendation for people learning T-SQL, Rob Farley
• All you need to know about SQL performance, Markus Winand
• What are SQL server audits - a new feature in SQL server 2008, Harsh Chawla

Other Interesting Stuff

• Every Business Problem is an Opportunity for Innovation, Paul Sloane
• Should You Manage Employee Performance Based on Profitability or Productivity? | ERP Software Blog
• View Contents of a Zip File Online with Google Docs (Amit Agarwal)
• Use your Mobile Phone to Scan Business Cards

Dynamics GP Video of the Day

• GPUG (20 Dynamics GP Tips in 20 Minutes) (Mark Polino)

Everything Dynamics GP #1

• Product Vision, Roadmap and Microsoft Dynamics GP 2010 R2 Videos (Pam Misialek )
• Need Sure Step Training? GPUG Can Help. (Pam Misialek) – Pam points to the Project Managing Dynamics Implementations with Sure Step training in August
• Microsoft Dynamics GP 2010 Cookbook Kindle Edition! (Mark Polino) – The most popular GP book ever, is now available on Kindle. I love this book, and I love Kindle – so will have to buy this even though I already have bought the PDF ebook.
• Earn Referral Fees by Submitting Microsoft Dynamics Leads that Result in a Sale! (Kevin Machayya)
• Sharpen the Axe - Enhance your GP Knowledge (Frank Hamelly) – shares his presentation highlighting the learning resources for Dynamics GP
• Securing Word Template Documents in Dynamics GP 2010 when using Word 2010 – Video (Dave Bader)
• Microsoft Introduces Solutions to Help Partners Build New Business With Cloud Computing (Kevin Machayya) – From what I understand looks like ERP RapidStart Services built on Azure will be available for Dynamics AX in September. The RapidStart services will help partners quickly configure and set up consistent and repeatable steps common across the life cycle of an ERP deployment, reducing the initial implementation time so they can focus on delivering profitable value-added services
• How to calculate Aging Buckets based on documents shown on a Receivables Statement (David Musgrave) – Shows how to manipulate multiple single records of data (with a column identifier and amount)  into a single summary record with multiple columns

Software

• Microsoft's upcoming products available for download (Mariano Gomez) – Mariano highlights the latest SQL, Office and IE releases/downloads
• SQL Server codename "Denali" CTP3, including Project "Crescent" is now publically available (Thierry Dhers) – among other things, with this release you can - setup alert rules and be alerted when report data changes occur that match a set of rules. This would work for existing SSRS Reports

Events

• Meet You There! – Pam, Jay and Errol want you to start planning for GPUG Summit in November 7-11 in Vegas
• Day 3 at #WPC11 #WPCLA  and Sir Richard Branson at #WPC11 #WPCLA Day 4 (Doug Pitcher) – Doug is giving his updates from WPC 11

Database

• Microsoft Dynamics GP The Almighty SQL Server Backup (Belinda Allen) – Taking backups in SQL Server 2008 R2  (and directly from GP)
• Announcing: SQL Azure July 2011 Service Release (Steve-Yi)
• Do you use T-SQL debugging? (Jakub Dvorak)

Other Interesting Stuff

• ASP.NET MVC 4 Roadmap (Phil Haack)
• Common Design Patterns Resources (Steve Smith)
• Microsoft to connect Kinect and robots (Mary Jo Foley)
• WP7: Mango to be released in September (or earlier!) (Owen Williams)

Dynamics GP Video of the Day

• Microsoft Dynamics GP FRx Sales Report (Belinda Allen) – on creating an operational report from scratch.

Microsoft Forecaster 7.0 Service Packs Download Links

Microsoft Forecaster 7.0 SP4 has been released – See post by Jill

http://blogs.msdn.com/b/dynamicscpm/archive/2011/06/29/microsoft-forecaster-sp4-is-now-available.aspx

The Forecaster Team is always on top of things, and in the last few years I have noticed that any issue in Forecaster is usually resolved simply by installing the latest service pack. Most Forecaster updates are not very time consuming, and we try and make it a point to install the latest hotfix/service pack as soon as it is available.

The CustomerSource download links for Forecaster 7.0 and Service Packs 1 to 4 are below

 

Microsoft Forecaster 7.0 RTM Download
Version (7.0.1266.7) This is the RTM download for Forecaster 7.0.  

Microsoft Forecaster 7.0 SP1

CRITICAL: Make sure to apply the Critical Add-In for SP1 on the download page for SP1) (Version 7.0.1420.9 with SP1 when the Critical Add-in is install it will be 7.0.1420.10)- November 5, 2007 (Includes Hot Fixes 1-3)

Microsoft Forecaster 7.0 SP2

Version (7.0.1513.10) - June 24, 2008

Microsoft Forecaster 7.0 SP3

Version (7.0.1613.13) - April 22, 2009

--- Hot Fix (Only use with SP3)

Version (7.0.1618.20)   - December 15, 2010

Microsoft Forecaster 7.0 SP4

Version (7.0.1701.50 - June 27, 2011)

 

Microsoft Forecaster Issues Resolved by Forecaster Service Pack 4

193720

No way to remove revenue account from revenue module once data has been associated.
312625
Error displaying capital in detail report when using Allow drilldown to capital detail.

315158

Deleting pay type association from salary grade creates orphaned records
320795
Current users list doesn't work correctly on SQL Server 2005/2008.

321729

The Multi-row tab doesn’t show the lines (rows), if an input set name is longer than 24 characters.
325800
Start Period and End Period can’t be adjusted in HR Master after another field is changed.

344372

Entering capital item into invalid period and deleting causes duplicate/orphan records
362922
Excel Add-in returns no results when the optimization factor is 0.

363919

Single Row Input with 'Suppress Zero Lines on Input' creates difference from Multi-row.
363939
When using Human Resources Annually’ with regular allocations not selected, headcount is not updated for hourly employees.

366414

Reports where lines are the departments show a zero balance
367077
Copy plan wizard for HR Details does not correctly calculate allocation.

368241 System needs to keep deleted employees shaded while changing the “Show Allocation As” option.
368800
Importing HR changes clears existing data in HR master but not in HR input.

370981

Improve CALREV processing performance.
378602
FTE not calculated correctly for employees distributed between multiple departments when specifying different employee options.

381253

Running capital task on input set with historic periods causes results to shift the number of historic periods defined.
383592
When reassigning an employee to a new department, the value in the Increase Period 2 field is not updated in the new department.

390352

Allocation lost when reassigning an employee from two or more departments into one using the reassign window.
403235
Error: “ExpressLink encountered a problem attempting to submit data to Microsoft Forecaster.” This occurs if the user name contains a period. (Ex. Jane.doe)

403641

Decimal values do not appear on the single row tab
404570
Temp tables do not get dropped on SQL Server 2000 when the username is numeric

410614

When prompting for period and using a selection sub-menu in a report, users have to select period twice before the report will display.
415674
If a user defined benefit exceeds 5,000 characters, Forecaster will close unexpectedly when trying to select it.

419972

Enabling Auto-translate causes Forecaster to stop responding when adding employees in HR master.
440395
If many options are created for a user defined benefit, Forecaster may close unexpectedly when trying to select an option in HR input.

453998

The destination account and the contra account can’t be the same when two or more allocations are created and accumulate is used.
465875
When sorting columns in the Multi-row tab, incorrect values can be created if a @LOOKUP calculation is also used.

466855

Enabling Auto-translate causes Forecaster to stop responding when importing employees through HR import.
467705
Forecaster closes unexpectedly.

469946

If an employee from a previous input set salary grade doesn’t exist in a new input set, Forecaster closes expectedly when adding the employee.
470760
Specifying a color for calculated columns doesn’t apply the color.

473830

If Add as FTE is not selected when adding

Good News

Just got the mail from Microsoft this morning - "We are pleased to present you with the 2011 Microsoft MVP Award for Dynamics GP!"

I told Rubal - "I have good news"

She said - "What are you pregnant or something?"

That comment would have been fine, but considering she is the wife, didn't make sense. She says - "Its just the way you said 'I have good news', that's the only correct response"

Next I called up Richard and Belinda - the two people I have learnt most of Dynamics GP from. Belinda, after congratulating me said - "When you said good news, I thought you were going to say a baby is on the way. "

True Story.

I've kept the title of this post "Good News" in order to promote the fact that there is other good news in this world as well.

That being said - thank you to all of you out there who have helped and encouraged me in the last few years especially - Mark, David and Mariano.

I hope I can help people out with GP more in the future.