Dave Musgrave hits Blackjack with 21 Reasons why every workstation should have the Support Debugging Tool installed.
Only 21 Dave?
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP
31 August 2011
ZDNet picks up on Dynamics GP MVP's Kinect and Dynamics GP demo - Inside Microsoft Dynamics GP
Jivtesh’s Kinect video is going viral when ZDNet picks up on Dynamics GP MVP's Kinect and Dynamics GP demo.
Quick Comparison Report Testing Tip - Blog - Kuntz Consulting
Kuntz Consulting gives us a Quick Comparison Report Testing Tip especially with upgrades.
Integration Manager Error: Source Document ‘GJ’ Does Not Exist | azurecurve
Over at azurecurve, Ian Grieve looks at an Integration Manager Error: Source Document ‘GJ’ Does Not Exist
30 August 2011
Dynamics Partners Push Vertical-Specific Badge -- Redmond Channel Partner
Discrete manufacturing is spelled. I.B.I.S. Checkout Dynamics Partners Push Vertical-Specific Badge from Redmond Channel Partners for more.
Registration for iSight 2011 Open!! | I.B.I.S. Inc.
Registration for iSight 2011 is now open. If you’re an I.B.I.S. client this is the place to be for information on Dynamics GP and the absolute first look at the Best of 50 Tips in 50 Minutes for Microsoft Dynamics GP.
Bug month! Issues with Project Accounting employee vendors & EFT - Kuntz Consulting
Kuntz Consulting hunts down some Issues with Project Accounting employee vendors & EFT.
Public Service Announcement: Don't Trust Hard Drives - Developing for Dynamics GP
Dave Musgrave reminds us: Don't Trust Hard Drives.
I’m not quite sure how to emphasis recovery plans any more than I do but I suspect that this topic will show up in the Worst Mistakes You can Make with GP presentation coming to the GPUG Summit.
Don’t be a Dynamics GP Zombie
My new post is at the Microsoft Dynamics Community site. It’s about zombies of course.
Microsoft Connect
Last week I had the privilege to participate in a super-secret, cross my heart, pinkie promise, non-disclosure, I can tell you but then I’ll have to kill you, MVP’s only look at how the upcoming version of Microsoft Dynamics GP is progressing.
The product is code named “Polino” because they’re sticking in all the stuff I’ve asked for over the years. I’m just kidding about the code name. I can’t reveal that either.
I am serious about all of the cool stuff going into the next version. It’s clear that the product team is using Microsoft Connect (the site, not Kinect the Xbox motion sensor thingy) to figure out what users want and need in future releases. If you are not using Microsoft Connect start now and make your voice heard.
[Slightly off topic. I heard a suggestion recently that a muffin shop should name a muffin for a week after a good customer. They’d bring in all their friends just to see their name on the menu board. Next week, new muffin name. Maybe GP should code name features after users who suggested or championed a feature. Then when It’s introduced it would be:
“We’d like to announce that we’ve decided to open up Analysis Cubes by removing the encryption and making the code available for changes. We’ve code named this change, ‘Dwight Specht’ because he just wouldn’t shut up about it.”
Anybody think that would lead to a few more product suggestions?']
For the record opening up the cubes has already been done. Throwing out features that are already complete prevents me from accidently revealing something I shouldn't.
The product is code named “Polino” because they’re sticking in all the stuff I’ve asked for over the years. I’m just kidding about the code name. I can’t reveal that either.
I am serious about all of the cool stuff going into the next version. It’s clear that the product team is using Microsoft Connect (the site, not Kinect the Xbox motion sensor thingy) to figure out what users want and need in future releases. If you are not using Microsoft Connect start now and make your voice heard.
[Slightly off topic. I heard a suggestion recently that a muffin shop should name a muffin for a week after a good customer. They’d bring in all their friends just to see their name on the menu board. Next week, new muffin name. Maybe GP should code name features after users who suggested or championed a feature. Then when It’s introduced it would be:
“We’d like to announce that we’ve decided to open up Analysis Cubes by removing the encryption and making the code available for changes. We’ve code named this change, ‘Dwight Specht’ because he just wouldn’t shut up about it.”
Anybody think that would lead to a few more product suggestions?']
For the record opening up the cubes has already been done. Throwing out features that are already complete prevents me from accidently revealing something I shouldn't.
29 August 2011
New Microsoft Dynamics GP Short Story: Collections, Month End Close, and...Muscle? | MSDynamicsWorld.com
MSDynamicsWorld liked Wiseguy and was kind enough to write a review that is up now at New Microsoft Dynamics GP Short Story: Collections, Month End Close, and...Muscle?
Mohammad R. Daoud: Inventory Reset Utility– HITB Did not match Staging Report and actual GL Journals!
Mohammad Daoud continues his POP and Inventory work with a look at the Inventory Reset Utility– HITB Did not match Staging Report and actual GL Journals!
Mohammad R. Daoud: PO Receiving Hangs During Posting
Mohammad Daoud is back with a look at PO Receiving Hangs During Posting
Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue | azurecurve
azurecure has some great upgrade advice when Installing Microsoft Dynamics GP 2010 R2 – Database Compatibility Issue
Weekly Dynamic: Voiding Credit Memos
Let’s say that you let AP checks automatically apply credit memos and a credit memo is a applied to a wrong invoice. Maybe it should have been on hold, it’s being disputed, whatever.
Voiding the check won’t unapply the credit memo application. Frankly if you had painstakingly applied a bunch of credit memos by hand and then had to void them because of a check printing error you’d be pretty upset that they had been unapplied.
So how to you unapply this credit memo since it completely paid off the invoice? You simply void the credit memo the same way that you would void a check, with Void Historical Transactions under Purchasing.
To make it even easier, change “All” selection in the upper right to “Credit Memo”. You’ll have to re-enter and reapply the credit memo but it’s still a pretty easy fix.
26 August 2011
Friday Feedback
I dropped a new tale showcasing the power of Dynamics GP earlier this week and I’m seeing a large number of downloads thanks to some help from Reporting Central.
If you’ve downloaded the story, I’d love to hear what you think. Leave a comment letting me know if you liked it, hated it, whatever. If you haven’t downloaded it yet, hit up the the Reporting Central website for a free download code.
Wiseguy is a new twist on a classic mob tale. Want to be mobster Joey is stunned to learn that his mob family has gone legit due to the power of Microsoft Dynamics GP. With the help of Jersey girl Isabella, Joey must learn to collect cash using Dynamics GP instead of a baseball bat.
25 August 2011
About Dynamics, Development and Life: Using Gestures with Business Analyzer for Dynamics GP
I really like playing XBOX with Microsoft Kinect. Fruit Ninja’s using Kinect gestures is just a blast. Well now Jivtesh is looking at Using Gestures with Business Analyzer for Dynamics GP. We call pivot tables slicing and dicing, sheesh.
A Better Way to Show Discounts on Quotes in Microsoft Dynamic GP and SL | MSDynamicsWorld.com
Jack Boyer looks at A Better Way to Show Discounts on Quotes in Microsoft Dynamic GP and SL via MSDynamicsWorld.com
Weekly Review: Speed Up Collections Window Population
If you have a large number of AR transactions it can take a long time top populate the Collections Main Transactions Inquiry window when trying to make notes in Collections Management. If you have experience with GP you might think that adding an index to table would speed this up, alas its not that simple. There is actually a procedure that pulls thins information in and it's very slow.
The solution is to run the Paid Transaction Removal routine in AR (run it first in Project Accounting if using PA). Paid transaction removal is something of a misnomer, it doesn't delete transactions but it does remove them from the open table and put them in history. This dramatically speeds up population of the invoices even with a large amount of transactions because GP doesn't have to sort through all the paid transactions. Until Microsoft improves the procedure this is your best option.
Originally Posted by Mark on 9/7/2009
In Touch with Dynamics (GP): Emailing POs using new GP2010 word templates
In Touch with Dynamics (GP) looks at upgrade issues around Emailing POs using new GP2010 word templates.
I would add that Office needs to be the 32 bit version to email Word templates.
I would add that Office needs to be the 32 bit version to email Word templates.
Mohammad R. Daoud: Vendor Notifications on EFT Bank Transfer
Mohammad Daoud was kind enough to build some SQL for Vendor Notifications on EFT Bank Transfer.
Do We Need an App Store for Microsoft Dynamics GP? | MSDynamicsWorld.com
Do We Need an App Store for Microsoft Dynamics GP? I think we need something like it. Find out why in my new MSDynamicsWorld piece.
24 August 2011
GPUG Bloggers Corner
GPUG has added a new blogger’s corner and I’m humbled to have both DynamicAccounting.net and My GP Search included in their list. Make sure to checkout the whole list at the GPUG Bloggers Corner.
Beware of Black Market, Voodoo ERP Systems | 360° ERP Blog
Panorama Consulting warns us to Beware of Black Market, Voodoo ERP Systems.
No these aren’t ERP systems sold in a back alley by a guy in a trench coat. These are system cobbled together, often with pieces of perfectly good ERP systems, that no longer resemble the living.
Don’t let your ERP system go down this route.
Mohammad R. Daoud: Inventory Reset - Average Item receipt QTY on hand does not equal IV QTY on hand.
Mohammad Daoud ran up against an odd inventory scenario that reconcile wouldn’t fix so he built his own fix in Inventory Reset - Average Item receipt QTY on hand does not equal IV QTY on hand.
His script has been added to the giant pile of SQL Scripts.
The eOne Dynamics GP and CRM Blog: Reason's to Upgrade from Integration Manger
eOne looks at Reason's to Upgrade from Integration Manger. I’ve got quite a few more but these will do for now.
New Dynamics Website
A couple of folks have pointed out the new Microsoft Dynamics site. Check it out.
[H.T. to David Musgrave and others]
Updating the Home Page Metrics in GP 2010 R2 | Dynamics GP Help
Rubal looks at Updating the Home Page Metrics in GP 2010 R2 in her new post.
![clip_image002[4]](http://dynamicsgphelp.com/wp-content/uploads/2011/08/clip_image0024.png "clip_image002[4]")
New Dynamics GP Fiction: Wiseguy
Who wants a new story around Microsoft Dynamics GP? You do? Ok, here you go:
Wiseguy is a new twist on a classic mob tale. Want to be mobster Joey is stunned to learn that his mob family has gone legit due to the power of Microsoft Dynamics GP. With the help of Jersey girl Isabella, Joey must learn to collect cash using Dynamics GP instead of a baseball bat.
For Wiseguy, I’ve partnered with the folks at Reporting Central, home of the The Closer and The ValidatorGP to give you a opportunity to download a free version. All you have to do is hit up the Reporting Central website for a free download code.
Of course, you’re welcome to drop 99 cents a copy if you prefer.
23 August 2011
The eOne Dynamics GP and CRM Blog: Our Customers stopped spending
Over at eOne, Martin digs into what to do when Our Customers stopped spending.
Payroll Manual Check – Fields to Watch | Dynamics GP Insights
Christina Phillips tells us the Fields to Watch when generating a Manual Payroll check.
If you feel the need to generate test checks off of your production environment, I’ll happy to supply my personal information for you to test with. You’ll need to test actually mailing the check of course and direct deposit too.
Just remember, I’m here for you.
Feature Explained: Date Effective Tax Rates | azurecurve
Ian Grieve explains the new Date Effective Tax Rates feature in Dynamics GP.
Microsoft Dynamics GP Consultant Certification Changes
In addition to all of the partner certifications changes, Microsoft has quietly made some changes to the way that certifications work for consultants. So, I figured a quick recap was in order for everyone.
The newest certifications are:
Microsoft Certified IT Professional
- Applications
- Installation and Configuration
Candidates are required to pass one to two core exams and two to three elective exams, depending on the product and knowledge area selected.
This is the more stringent of the two certifications and there are two variations. It replaces the Microsoft Certified Business Management Solutions Professional certification (as best I can tell. MCBMSP is still listed in Partnersource but the links take you to the MCITP site).
The big change is that the Report Writer, Field Service and Modifier with VBA exams have been retired. Since the latest exams for these areas are for version 9.0, users who passed them previously can apply them toward these certifications but the exam is no longer open to new candidates. I find this strange since Report Writer and VBA haven’t changed appreciably since 9.0 so a version 9.0 competency should still be relevant. I think MS should at least update the version number on the test and keep offering it.
Microsoft Certified Technology Specialist
Candidates are required to pass one certification exam to become a Technology Specialist.
This is not a difficult certification to achieve. We’ve got folks straight out of college achieving this in 30 days.
Notes for You
- The whole certification site is woefully out of date still showing GP 10 in most of the overview sections. GP 2010 specific certifications are available for:
- Financials
- Inventory and Order Processing
- Project Accounting
- Installation and Configuration
- There is no Management Reporter exam, you’re stuck with the FRx certification
- The “Dynamics GP Certified Master” certification is long retired. The requirements never measured up to say a SQL Server Certified Master. I still see occasionally see people using this and what it tells me is that their certifications aren’t up to date.
- An MVP is not a certification. It’s a recognition award and it is reviewed and potentially renewed annually.
“With the MVP Award, we thank these inspiring individuals for representing the voice of thousands in the community through the powerful and independent feedback they give us, and for helping our customers maximize the potential of their software.”
22 August 2011
SQL Script – Orders Needing Purchase « Real Life Dynamics User
Real Life Dynamics User gives us a new SQL Script with details on Orders Needing Purchase « Real Life Dynamics User.
When It’s Time to Upgrade an Outdated, Customized Microsoft Dynamics GP System…Who You Gonna Call? | MSDynamicsWorld.com
New at MSDynamicsWorld.com, Mariano busts a few ghosts looking at When It’s Time to Upgrade an Outdated, Customized Microsoft Dynamics GP System…Who You Gonna Call?.
Microsoft Dynamics GP: One Key To Rule Them All | azurecurve
azurecure extols the virtues of Microsoft Dynamics GP help in One Key To Rule Them All .
The Creation of the Support Debugging Tool - Developing for Dynamics GP
Speaking of the Support Debugging Tool, David Musgrave takes a look at The Creation of the Support Debugging Tool.
I still maintain that there were alien’s involved and that all of David’s hard work built on their core technology but hey, what do I know.
Support Debugging Tool Customization #6 – Removing Voided Documents from Customer Statement | Interesting Findings & Knowledge Sharing
Sivakumar continues to use the Support Debugging Tool in interesting ways. This time he’s Removing Voided Documents from Customer Statement.
Weekly Dynamic: Dealing with Leading Zeros in Excel
When working with Dynamics GP it’s common to need to import information from other systems. Typically this is an extract from some other system into a comma separated values (CSV) file. Then an integration tool like Integration Manager is used to import the file into Dynamics GP.
The most common problems with this process happen when the source properly includes leading zeros. So a vendor ID for example might be 0001234. What happens is that a user opens the CSV to validate the information or adjust the file using Microsoft Excel. When the file is opened in Excel, the leading zeros get removed and users end up with a vendor ID like 1234.
So assuming that the source file does include the leading zeros, how does someone ensure that the leading zeros stay intact when working with the file in Excel?
- Rename CSV file so it has a TXT extension. This tells Excel to trigger the Excel Import Wizard.
- Within Excel, open the TXT file. You may need to use the the ‘Files of Type’ drop-down list at the bottom of the dialog box, indicate that you want to open Text Files (*.prn; *.txt; *.csv). .
- Excel starts the Text Import Wizard, displaying the Step 1 of 3 dialog box.
- Check Delimited and Next to move to step 2.
- Select Comma as the delimiter and click next to move to step 3.
- At the bottom of the dialog box, click on the field that has leading zeros. The entire column should now be selected.
- In the Column Data Format area, make sure the Text radio button is selected.
- Repeat steps 6 and 7 for any other fields that have leading zeros.
- Click on Finish. Your file is imported, with leading zeros still intact.
While there may be other ways to trigger the Excel Import Wizard this one works every time.
18 August 2011
Dynamics GP Land: Sherlock Holmes I Am Not- Finding Missing Deductions and Benefits
I’m liking Christina’s mystery themed posts like her new one Sherlock Holmes I Am Not- Finding Missing Deductions and Benefits.
However, if we get to Murder on the Dynamics GP Express I’m outta here!
WAQAS BUTT - Microsoft Dynamics ERP'S Blog: Dynamics GP Project Accounting Error - The Project Is Being edited By another User
Waqas Butt reminds us how to resolve The Project Is Being edited By another User in Project Accounting.
Dynamics GP Land: Payroll 941 Mystery Solved (or The Case of Missing Table)
Christina Phillips plays detective (don’t we all) in Payroll 941 Mystery Solved (or The Case of Missing Table)
Weekly Review: Speed Up the Receivables Aging Process
The Receivables Aging process in GP can take some time if you have a lot of outstanding AR. There is an easy way to speed it up though. When running the receivables aging process (Sales on Navigation Bar, Pick Aging under Routines) select the No Report option. This means that the aging code can run without having to compile all that data into a report.
Let's face, if you have a large number of outstanding receivables, you don't want to work off a monster aging report anyway. You'll re-run it and limit the results to be better aligned with your collection efforts. So save some time and turn off the report.
Posted by Mark at 8/31/2009 09:00:00 AM
17 August 2011
Microsoft Forecaster - What's the future? - Dynamics Corporate Performance Management
What’s the future of Forecaster? Find out here in Microsoft Forecaster - What's the future? from Dynamics Corporate Performance Management
Reporting Ledgers and Fixed Asset Depreciations | Interesting Findings & Knowledge Sharing
Sivakumar gives us a nice look at Reporting Ledgers and Fixed Asset Depreciations.
This is going to be an important piece of the IFRS puzzle going forward.
Dynamics GP Developer Insights: The Evolution of the Silverlight PushButton - Developing for Dynamics GP
Microsoft Software Developer Engineer Kurt Larson digs into The Evolution of the Silverlight PushButton and how it’s being used in the upcoming GP “12” web client.
16 August 2011
Dynamics GP Developer Insights: Introduction - Developing for Dynamics GP - Site Home - MSDN Blogs
Welcome Brian Roney from the GP developer team and his new post Dynamics GP Developer Insights: Introduction. They’ve got new videos coming looking at developing around the GP web client so pay attention!
Excel Report Builder - bug in SQL views created - Blog - Kuntz Consulting
Kuntz Consulting seems to have found a bug in SQL views created in some older versions of the Excel Export.
Creating Budgets That Span Multiple Periods | Dynamics GP Insights
New from Dynamics GP Insights, Cindy Boersma shows us to Create Budgets That Span Multiple Periods
15 August 2011
Screen Output Magnification Defaults | Interesting Findings & Knowledge Sharing
Sivakumar reminds us how to set the Screen Output Magnification Defaults.
DynamicsBlogger: ISV participation in Microsoft Dynamics Community
Janakiram M.P. looks at ISV participation in Microsoft Dynamics Community. I have a couple of thoughts on this as well but I was saving them for an MSDynamicsWorld column so you’ll have to wait a little bit.
ERP and the Cloud | Dynamics GP
Funny thing. After spending time at WPC, Technology Management Concepts agrees with me about hybrid ERP and the Cloud.
SQL view for sales by item by year | Victoria Yudin
Victoria Yudin adds a new SQL view for sales by item by year
Weekly Dynamic: Financial Batch Notes
I’ve never encouraged users to add notes to batches. Adding them to transactions is terrific. It’s a great way to remember why you did something, but batches, not so much.
Over the years I’d forgotten why I didn’t recommend batch notes beyond some vague sense that I’ve never seen anyone use batch notes later on. Then my colleague Amy Walsh asked if it was possible to add batch notes from posted financial batches to a report. After a little work, we both realized that it can’t be done.
Notes are retained on the batch for unposted financial batches but at posting the batch really goes away. The batch name is noted as part of the individual transaction lines but the rest of the batch specifics, including comments and notes, don’t survive posting.No notes for you.
So now I’ve got an even better reason to recommend transaction notes.
12 August 2011
Will GPA ever die?
Evidently Doug Pitcher was cleaning out the attic and found some old stuff. Great Plains Accounting for DOS anyone?
Friday Fun: 7 People Not to be at a Conference
When you go to the GPUG Summit 2011 in Vegas try not to be one of the 7 People Not to be at a Conference
11 August 2011
DynamicsBlogger: Multicurrency Support in Project Accounting
Janakiram M.P. has a great new post with lots of information on Multicurrency Support in Project Accounting
Read this!
MBS Guru: Reconciling SOP Batches from WITHIN Dynamics GP
From Michael Johnson comes an update to his code for Reconciling SOP Batches from WITHIN Dynamics GP
DynamicsBlogger: Integration Manager hangs in GP2010–IV Resolved
Janakiram M.P. has the final word on Integration Manager hangs in GP2010–IV Resolved
Integration Manager hangs in GP 2010
There are a pile of new posts around Integration Manager hanging in GP 2010.
Using Extender to Create SQL Views | Dynamics GP Insights
Charles Allen covers Using Extender to Create SQL Views in a great new post.
The Roots of Microsoft Dynamics GP: Where Have All the Accountants Gone? | MSDynamicsWorld.com
You can tell that I’m back from vacation because my new article is up at MSDynamicsWorld.com. I’ve been disturbed by a somewhat frightening lack of accounting skills when working with, um, ACCOUNTING software so I decided to tackle that in The Roots of Microsoft Dynamics GP: Where Have All the Accountants Gone?
Check it out!
Weekly Review: Prevent the Sale of Discontinued Items
In Dynamics GP users can discontinue items in Inventory. Discontinued items can still be sold but not bought. This gives companies the options to work through obsolete inventory. But sometimes companies don't want to be able to sell discontinued items. There could be safety issues or contractual reasons behind this. The typical solution is to write off discontinued items removing the balance from being available for sale. This has it's pitfalls too. Another solution is to turn off the ability to sell discontinued items. The switch for this is located at Tools->Setup->Sales->Sales Order Processing, Options. Uncheck Allow Sales of Discontinued Items in the bottom grid area.
This is a system wide switch so if you only want to prevent the sale of certain discontinued items you'll need to continue to zero out the inventory for those items. But if you want to prevent the sale of discontinued items across the board, now you've got an easy way to do it.
Originally Posted by Mark at 8/17/2009 09:00:00 AM
10 August 2011
Management Reporter – Advanced Reporting Scenarios and Features - Dynamics Corporate Performance Management
From Dynamics Corporate Performance Management comes a look at some Management Reporter – Advanced Reporting Scenarios and Features
Quick Tip: Best Practice for Dexterity Version and Build Numbers - Developing for Dynamics GP - Site Home - MSDN Blogs
David Musgrave has some great Dex development advice in Quick Tip: Best Practice for Dexterity Version and Build Numbers
Dynamics GP Land: Reporting Puzzle (2 of 2)- Report Options and Report Groups
In reporting puzzle 2, Christina Phillips finds inconsistencies in Report Options and Report Groups.
This is just obscure enough to make me sit up and take notice. We found some unrelated obscure things recently. Maybe it’s something in the air.
Security Window Enhancements in Dynamics GP 2010 | Interesting Findings & Knowledge Sharing
Sivakumar takes a break from Support Debugging Tool customizations to bring us Security Window Enhancements in Dynamics GP 2010.
Dynamics GP Land: Reporting Puzzle (1 of 2)- Dynamics GP SQL Financial Trial Balances
In the first of two reporting puzzles, Christina Phillips looks at fun with SSRS and Financial Trial Balances.
“Three words. Account. Level. Security.” I almost spit my drink across the room when I read that. It would have been a waste of perfectly good Diet Mountain Dew.
Subscribe to:
Posts (Atom)