Memorial Day

In honor of the Memorial Day holiday here in the United States, all my normal Dynamics GP related posts have moved to tomorrow.

Take the day off an remember someone who gave their life for your freedom.

SQL Mail to be deprecated in Microsoft SQL Server 2008 R2

Mariano Gomez has coverage of the news that SQL Mail is to be deprecated in Microsoft SQL Server 2008 R2.

Microsoft Virtual Convergence 2010

Virtual Convergence 2010 is up now at http://vepexp.microsoft.com/convergence2010. It’s really slick looking.If you want to relive the moment, it looks the initial 50 Tips and 50 More Tips are up. You get  audio, PowerPoint slides and the live demos. You don’t actually get videos of my brilliant delivery. You’ll just have to imagine how good I looked.

The links to the full presentations with notes are up at DynamicAccounting.net on the right.

Make sure to watch David and Mariano’s sessions as well. They rocked!

Interview with Andy Vabulas

Amy Walsh has more of her interview with I.B.I.S. founder Andy Vabulas up now at DynamicsCare.

Weekly Review: Inventory Fix for Right Value, Wrong U of M

As a reminder to new readers, Weekly Reviews are former Weekly Dynaimc tips that I want to make sure that you don't miss, just because you weren't with us back in 2007.

While cleaning out our year end inventory, we found an item with a wrong unit of measure, but a correct value. We didn't have 3 million feet of bubble wrap on hand, but if we could have gotten that for $1,100 it would be a steal. So the value is right, the quantity is wrong and I'm staring at this trying to figure out how to adjust the quantity without affecting the GL (because $1,100 is the right value) and without screwing up anything else.

Then it hit me, write the whole thing off. Bring the count and the GL value to 0 and then write the whole thing back on at the correct unit of measure and the same value.

It worked perfectly. No SQL adjustments, no inventory transactions that didn't post to the GL to explain to the auditors. Last cost is correct. FIFO layers are correct.

Originally Posted by Mark at 1/19/2007 05:18:00 PM

The Closer

I had lunch with Shane and Gianmarco from Reporting-Central.com yesterday. This is what is was like:

If you haven’t looked at The Closer for balancing subledgers and the GL, now is the time to do it before being #48 on the 100 Most Influential list goes to Shane’s head.

Dynamics GP Reporting Series

If you’ve missed previous posts on this, Mohammad R. Daoud is pumping out a ton of great SQL code related to reporting in his Dynamics GP Reporting Series set of posts. Make sure to take a look.

Field Level Security in Dynamics GP 2010

With the addition of Field Level Security to the Business Essentials level of Business Ready Licensing for GP 2010, everyone is buzzing about the ways it can be used. Check out Field Level Security in Dynamics GP 2010 from Jivtesh. He has links to Frank’s great article in there as well.

Microsoft Announces the Availability of Management Reporter for Microsoft Dynamics ERP

Management Reporter is loose. They may have ship each copy with a crow bar to pry FRx out of user’s hands but after a while the better platform of MR will start winning people over, especially if the conversion of reports is a seamless as I’ve heard from early adopter.

Excluding Inactive Vendors/Customers from Lookups

Jivtesh has a nice look at options for Excluding Inactive Vendors/Customers from Lookups in GP 10 and GP 2010.

Jordanian “5% Vendors Service Tax” in Microsoft Dynamics GP

Mohammad Daoud looks at How to Handle Jordanian “5% Vendors Service Tax” in Microsoft Dynamics GP. The solution isn’t 100% complete yet but I love to see creative uses of existing functionality to solve new issues.

Dynamics GP 2010 Excel Based Table Reference

My Excel based table references for Dynamics GP 9 and Dynamics GP 10 have been downloaded more than 3,000 times so some of you like them. Now I’m happy to announce the availability of the Excel based table reference for Dynamics GP 2010.

This version is in the Excel 2007 and up XLSX format since most people upgrading to the latest version of Dynamics GP will be moving to newer versions of Microsoft Office. There are viewers and converters available if you are on an earlier version of Excel. If you desperate want an XLS version send me an email and I’ll send you one.

As before, this tool shows all of the tables in Dynamics GP based on their Module and Series. This versions gets a few enhancements. Specifically, each of the lists already has filter handles, better identification is provided for modules in the core Dynamics dictionary and modules in the Dynamics dictionary get their own tab in addition to having a tab for each series.

Some people really get this tool and some don’t. Yes, all of this information is available in Dynamics GP | Tools | Resource Descriptions. Yes, it’s all available in the SDK and the Support Debugging Tool. But there are time when I’m writing reports or code and I don’t want to take the time to open Dynamics GP just to find a table name. There also times when I’m not sure what table I need and the search functions in Excel are a huge help.

I have to give a big thanks to David Musgrave. New features in the Support Debugging Tool made compiling this file significantly faster. It’s still time consuming but it’s hours not days.

Enjoy!

What’s New in GP 2010 – Payroll

Fellow GP blogger Amy Walsh point us to a new Microsoft snack, this time taking a bit out of Payroll in What’s New in GP 2010 – Payroll.

Top Questions last Week from Inside Microsoft Dynamics GP

The folks at Inside Microsoft Dynamics GP have compiled their Top Questions this Week into a new pot. In the post they tackle the delay in customer reg keys, FRx currency translation, new suite licensing, Convergence presentations (don’t forget, mine are up at DynamicAccounting.net with full notes) and French Canadian and Latin America Spanish version availability.

Announcing Report Writer Function RW_ConvertToWordsAndNumbersParse

At the Developing for Dynamics GP blog, David Musgrave is thrilled to announce a new Report Writer function in GP 2010, RW_ConvertToWordsAndNumbersParse, that resolves the 80 character computed string limitation in check amounts in words.Feel free to now write large check amounts to David without worrying that the amount in words won’t print completely.

Microsoft Dynamics Top 100 Most Influential People for 2010

The folks at DynamicsWorld.co.uk have put out their new list of the Microsoft Dynamics Top 100 Most Influential People. I’m honored to have made the list again, this time at  #28. I don’t buy that I’m that influential but it’s still a fun number.

I’m more thrilled to see that I.B.I.S. founder, CEO and Eagle award winner Andy Vabulas is on this year’s list at #42. Andy deserves to be higher on this list than I am, I’m just louder, younger and maybe better looking, but not more influential. Andy throws better parties too.

Lots of other people you will recognize made the list as well, congrats to Mariano Gomez, Mohammad Daoud, Victoria Yudin, Andy Hafer (of GPUG fame), Errol Schoenfish, David Musgrave and Richard Whaley.

Smartlist: Exports slowly to Excel - Part 2

Previously Patrick showed us how to seriously speed up SmarList exports in GP 10 and 2010. This week he does the same for older versions of GP with a free CNK file. Make sure to check out Smartlist: Exports slowly to Excel - Part 2 at Developing for Dynamics GP.

Non-Inventory Items and GL

Real Life Dynamics User takes a look at Non Inventory Items and GL in Dynamics GP.

Weekly Dynamic: Control Account Management for Receivables

One of my favorite unknown features for Dynamics GP is Control Account Management for Purchasing. This allows companies to process AP centrally and then roll down the AP balance at month end to the appropriate departments. A reversing entry then puts everything back into AP.

This is a great feature for companies who want a complete balance sheet for their departments but prefer the efficiency of centralized AP. What about AR? After all, AP is only part of the equation. Well, Dynamics GP 2010 adds this feature for AR as well.

With the addition of AR, the feature moves out of Purchasing and into the Financial Area Page. Setup is still under Setup and users select Payables or Receivables when setting up the appropriate roll out accounts. Processing the split at month end has moved from Routines to Transactions on the Financial Area Page.



I’m thrilled to see this addition. This has always been a surprisingly complete feature. Now, if it only supported intercompany…hint, hint.

Slashdot Gets it Wrong – No Security Hole

I’m starting to get questions on a recent article about Dynamics GP that got picked up by Slashdot. The actual article is at http://www.christopherkois.com/?p=448. Here is the Google cache if the site is down from the Slashdot effect http://webcache.googleusercontent.com/search?q=cache:http://www.christopherkois.com/%3Fp%3D448&hl=en&client=firefox-a&hs=lR&sa=G&rls=org.mozilla:en-US:official&strip=1.

In the article the author claims that Dynamics GP use weak encryption and the system is easily broken. The problem with this article is that much of it is ether flat out wrong or wildly overblown. The author appears to have confused the System password in Dynamics GP with the System Administrator and jumped to a number of conclusions because of it. It’s also clear that he doesn’t understand the function of the System password in Dynamics GP. As the article claims, the System password is not heavily encrypted and this has been commented on by a number of folks. I don’t even use the word encrypted when referring to it, I use the term masked.

The same scenario does NOT apply to the encryption of user logins between GP and SQL. As noted by David Musgrave and referenced in the article, the algorithm was even enhanced for v10 as part of Microsoft’s Trustworthy Computing Initiative.  It’s clear to me that the author confused a number of articles and didn’t really understand how they related to Dynamics GP security. (Although David Musgrave’s was really straightforward and well written.)

To set the record straight, here is what you need to know:

1) The System password is an OPTIONAL component of GP security. It is recommended, but it is not a primary layer of defense. If security access isn’t granted to a resource through the application, knowing the system password won’t help you.

2) SQL access is required to use the method described to figure out the System password. The article falsely claims that a basic GP user can get access to the Dynamics DB via SQL. That is simply wrong. A GP login cannot be used to access SQL server directly for any of the supported versions of GP. It can’t be done with their GP password and it can be done with the substitution cipher shown on the website. In some older versions of GP this was an option. It’s not even an option today. The only exception is of course the sa password which is fundamentally a SQL password and designed to work that way.

If you are giving users direct access to SQL you have bigger issues than them getting the system password.

3) A number of people including myself have shown how to reset the system password. It’s even in my upcoming book so it’s not a big secret as the author contends. As I’ve said, it’s an optional component designed as second layer of defense.

I’ve responded on Slashdot and on the author’s post. The author moderates comments and hopefully he is big enough to put my comment through. In case it doesn’t happen or it takes a long time I’ve decided to clarify things with this post.

Feel free to email questions about this to me. Nothing like dealing with someone spreading  fear, uncertainty and doubt with false statements to get me worked up on a Friday afternoon.

Update: The author has posted updates clarifying some of these points. Sadly it’s unlikely that Slashdot will pick up the corrections.

Update 2: ComputerWorld picked this up and corrected themselves very quickly. Perhaps now that the original post has been corrected this can die. Kudos to them for the fast correction.

More Updates: Inside Microsoft Dynamics GP has responded as have Mariano Gomez and Steve Endow.

Deep Dive into Management Reporter

Dynamics GP Land points us to a Deep Dive online partner course on Management Reporter.

Fast Close and Decisions 2010 Update

We had a great session on closing the books faster using Dynamics GP at Decisions 2010 today. Thank you to everyone involved. The MSDynamicsWorld team was fantastic. Despite my best efforts to crash the question system with volume it held up just fine and we got some great questions out of that. Jivtesh provided an review of the session on his blog at http://www.jivtesh.com/2010/05/mark-polinos-fast-close-for-dynamics-gp.html

This was a lot of fun to do and I’m looking forward to more opportunities to do virtual conferences.

One of the questions afterward led me to realize that I misspoke so I would like to correct that here.

If you create and assign a Task in GP to another user, you can’t see that task later by default. However, there are some options to still make this process work fine for month end. The options are:

1) Assign the task to <Any User> and add the individual’s name that you want to complete the task to the beginning of the task description. All users can see these tasks and GP records who actually competed the task and when.

2) Assign the task to a specific user and use SmartList Builder, Excel Report Builder, SSRS, Crystal Reports, Excel or other reporting tool to build a report from the Dynamics..SY01403 table in Dynamics GP. This table holds all the tasks by user making it easy to build into a report.

3) Assign the task to a specific user and create a custom report using Report Writer in Dynamics GP pointed to the syUserTasks (Dynamics..sy01403). The advantage to this method is that no additional products are necessary and the custom report is easy to export and import. The down side of course is that you have to use Report Writer.

Dual Personality: Inventory Transfer Entry

Over at Dynamics GP Land, Christina Phillips takes a look at Project Inventory Transfers.

 

How to See the Dynamics GP Items You Didn't Sell

Matt Landis has SQL code up now in this post How to See the Dynamics GP Items You Didn't Sell that shows slow moving items in Dynamics GP.

An Interview with Andy Vabulas

Over at DynamicsCare, Amy Walsh is starting a series of interviews with Andy Vabulas. Andy is a the founder and owner of I.B.I.S., Inc. and geniune big dog in the Dynamics world. This year he won the Eagle award from MS for his contributions to the Dynamics community. Catch the start of Amy’s interview series at An Interview with Andy.

Blogging Decisions 2010

Jivtesh is blogging his experience from the GP track of Decisions 2010 at http://www.jivtesh.com/. It’s not too late to get in on tomorrow’s sessions.

Boolean Logic to the Rescue

In a rich, deep post, MVP Leslie Vail explores Boolean Logic.  This has lots of applications with GP data so if you don’t understand it make sure that you read Leslie’s post.

Does anyone in Antarctica want to learn about Dynamics GP 2010?

From Inside Microsoft Dynamics GP I see that GP 2010 has had launch events on 6 of the 7 continents. Now they are asking Does anyone in Antarctica want to learn about Dynamics GP 2010?

I’m more of a sand and sun person I’m willing to present 50 tips in Antarctica!

Organize Your QuickLinks Section

Leslie Vail credits Landon Russell for a great tip to Organize Your QuickLinks Section. I”m left scratching my head wondering why I didn’t think of that. We used to do the same thing with palettes. Doh! Great job Landon and thanks for pointing this out Leslie.

Microsoft Dynamics GP 2010 What's New eLearning Now Available

From Inside Microsoft Dynamics GP I see that there are a number of new elearning videos available for Dynamics GP 2010.

 

SQL Script to delete stranded activity for a specific user

veeyeskay is back a SQL Script to delete stranded activity for a specific user.

See How Real-life Users Like Ron Wilson Utilize the Community

From the Microsoft Dynamics ERP Community Team Blog, check out this video to See How Real-life Users Like Ron Wilson Utilize the Community.

SQL Script to Reconcile GL vs. AA Balances

New from veeyeskay is a SQL Script to Reconcile GL vs. AA Balances.

Posting Levels in Dynamics GP

Veeyeskay has a nice look at Posting Levels in Dynamics GP.

Weekly Dynamic: Slow JE Lookups Fixed in GP 2010

I’ve had this great tip in the original 50 tips for 2 years now. Tip #10 demonstrated how to get fast journal entry lookups when correcting or copying a journal entry. All it required was adding a non-clustered index to the open and history GL tables. Well I see now that in GP 2010  this has been corrected and I can pull this tip out of the rotation. Thanks for the fix Microsoft. It’s nice to have these concrete examples of fixes.This week’s Weekly Dynamic is don’t apply this fix after upgrading to GP 2010 because it’s already there!

Why the Phaseout of the Microsoft Dynamics Public Newsgroups Is a Good Thing

Rock star blogger Mariano Gomez looks at Why the Phaseout of the Microsoft Dynamics Public Newsgroups Is a Good Thing  in his latest installment for MSDynamicsWorld.com.

GP 2010 + Office 2010 + Sharepoint

In light of the GP 2010 and Office 2010 launches, Inside Microsoft Dynamics GP take a look at Microsoft Dynamics GP Combined with Microsoft Office and SharePoint.

Dynamics GP 2010 web services and Business Portal 5 installation

In Touch with Dynamics (GP) takes a look at some issues they’ve had with Dynamics GP 2010 web services and Business Portal 5 installations along with information on how to fix the issues.

Weekly Review: Account Description Quirk

With version 9.0, Dynamics GP added the ability to auto populate the account description based on the account segments. In 9.0 and subsequent versions, when you enter a segment it can't find, GP asks if you want to create that segment. If you click yes, you go to segment creation. If you click no, you get to add the description manually. There is also a box marked, Do Not Display This Message Again.


If you check this box there's not an easy way to get it back if you change your mind. The change is made for the logged in user for all companies that user has access to.

The solution is a SQL Script. Execute this script in query analyzer for each company that a user has access to. Substitute the appropriate user id for myUserID.

delete from SY01401

where USERID = 'myUserID'

and coDefaultType = 13

This will bring back the box and put you back in charge of account descriptions.

Posted by Mark at 11/27/2006 09:01:00 AM

READ THIS RIGHT NOW: Smartlist: Exports slowly to Excel - Part 1

I don’t yell often so stop what you are doing and go to Developing for Dynamics GP to read Patrick Roth’s article on how to dramatically speed up SmartList exports to Excel for GP 10 and GP 2010. The post is: Smartlist: Exports slowly to Excel - Part 1
Patrick details a Dex.ini switch for GP 10 and GP 2010 that significantly speeds up SmartList exports to Excel. On a run of the mill laptop running GP 2010 I loaded a SmartList with 22,229 records. It took 1 minute, 15 seconds to load the window and a mere 27 seconds to send that data to Excel. All of us will be adding this to our list of Dex.ini switches. You should too, right now.

SQL view with security and SmartList details in GP

Victoria Yudin has an updated SQL view with security and SmartList details in GP available at her website.

Support Debugging Tool Build 13 released

David Musgrave didn’t waste any time getting a new build of the Support Debugging Tool out. This one fixed the issue with the GP 2010 RTM but that’s not all. It also adds improved window coloring by company, a new email override for the automatic debugger mode and a host of other enhancements. You can get the Support Debugging Tool from your partner and you can find out more about what’s new from David’s post Developing for Dynamics GP : Support Debugging Tool Build 13 released.

Dynamics GP 10 Microsoft Excel and Excel Reports Snack

Fellow I.B.I.S. employee and blogger Amy Walsh points us to a new “Snack” video from Microsoft looking at Dynamics GP 10 Microsoft Excel and Excel Reports.

"Real Time" Dynamics GP Integrations

Steve Endow has great look at what "Real Time" Dynamics GP Integrations really means.

Support Debugging Tool version error on GP 2010 RTM

I was one of a number of folks who found this little error when we rushed to installed the Support Debugging Tool on the RTM version of Dynamics GP 2010.  It’s nice to see a permanent fix coming but the workaround described in Developing for Dynamics GP : Support Debugging Tool version error on GP 2010 RTM works just fine.

 

Microsoft Dynamics GP 2010 Update Path

Mariano Gomez has a nice look at the Microsoft Dynamics GP 2010 Update Path. Make sure you take a look as you think about upgrading.

Objective Measures: Client Satisfaction

Executive blogger Dwight Specht is back looking at how to measure Client Satisfaction in a Dynamics practice. (I’m still not sure why we practice this, at some point we should do Dynamics for real).

If your clients hug you when you walk into their offices or have a large tub of Diet Mt. Dew on ice for you, it’s pretty easy to determine their level of client satisfaction. If that doesn’t happen, you have to figure it out. Dwight’s post tells you how to figure it out.

SureStep gets an Exam

Dynamics GP Partners now have a new exam that they have to pass. WAQAS BUTT has full coverage in the post: Microsoft Dynamics GP Blog: Managing Microsoft Dynamics Implementations Certification Exam MB5-858.

Essentially this is the Sure Step implementation exam. Microsoft is pushing this to help partners provide a consistent implementation methodology when implementing Dynamics GP.

Microsoft Responds to the Evolution of Communities

The Microsoft Newsgroups are going away to be replaced by web based forums. This change has been in the works for several years. I’m sure that plenty of people will get all worked up about. I won’t. My preference is to follow newsgroups and forums via RSS and that’s hard to do for newsgroups. It’s only because of Google that it’s possible.

Frankly, I’ll be happy to have fewer, more concentrated places to provide support to GP users. The fragmentation meant that folks often posted in more than one place making it tough to really provide complete answers.

If you want more information on the change, check out Developing for Dynamics GP : Microsoft Responds to the Evolution of Communities.

Management Reporter for Dynamics GP Available for Download

For everyone all worked up over not getting registration keys for Dynamics GP 2010 yet here is a shiny distraction to play with while you wait: Management Reporter for Dynamics GP Available for Download.

Looking for Dynamics GP 2010 Registration Keys?

Apparently nobody was quite ready for demand for GP 2010. Did I say demand? You people are pushy! While GP 2010 was released as expected, new registration keys are taking a little while and folks are all worked up about it. The GP team is on top of the issue and keys are going out. More info is available at: Inside Microsoft Dynamics GP : Looking for Dynamics GP 2010 Registration Keys?

In the meantime, relax, have a milkshake.

Best of the Best: Top Ten Tips for Microsoft Dynamics

The good folks at  MSDynamicsWorld.com gave me an opportunity to pick my 10 favorite tips from the 100 I presented at Convergence. The article covering that is titled Best of the Best: Top Ten Tips for Microsoft Dynamics GP and its up now at MSDynamicsWorld.com.

Add a comment and tell me your favorite tips for Dynamics GP.

Convergence 2010 Wrap Up

The last of the evaluations are due in today and I doubt that they will change much in terms of how the sessions are ranked after Convergence. When you’re at a 150 or so evaluations it takes a lot to move the numbers. So how did we do?

There are 2 overall measures of a session that get tracked. One is based on the Overall Satisfaction question scored on a 4 point scale and one is based on the  Presenter Effectiveness question based on a 5 point scale.

Overall Satisfaction

For the Dynamics GP track in Overall Satisfaction, Mariano and David’s session on the Support Debugging Tool comes in at number 1, my 50 More Tips is number 2, Mariano and David’s repeat is 3 and my original 50 Tips came in at 4. All of these sessions had more than 75 evaluations and most of them were over 150 evaluations. The minimum number of evaluation is 10. 150+ very positive evaluations is incredibly cool. The separation between #1 and #4 in the the GP track was 11/100ths of a point.

These are crazy high numbers of people who enjoyed the sessions. In all of my sessions more than 50% of the people who attended filled out an evaluation. Mariano and David had similar numbers. The fact that we finished this way shows the value of MVP’s and the closeness of bloggers to the community. We eat, sleep and breathe this stuff and the passion comes through. David and Mariano rocked.

Overall Satisfaction across all sessions is tied right now between Tips for Outlook 2010 and 50 Tips for SL. Apparently the 50 Tips in 50 Minutes concept is a hit across the products. I’ll have to do something creative next year to stand out.

Presenter Effectiveness

If you though that Overall Satisfaction looked good, we killed at Presenter Effectiveness. 50 More Tips in 50 Minutes is ranked  #1 for Presenter Effectiveness across all Convergence Concurrent Sessions and David and Mariano’s Support Debugging Tool session is ranked #2 across all Concurrent Sessions.

If you still can’t get enough tips for Dynamics GP after Convergence:

1) Sign up and attended Decisions 2010. This free, virtual conference is right around the corner on May 19 and 20, 2010. You can attend from your desk. I’ll be doing a session on closing the books faster at month end with Dynamics GP. MVP’s Mariano Gomez and Frank Hamelly are doing sessions as well. You don’t want to miss this.

2) Order the book. My upcoming book on Dynamics GP is now available for preorder. If you liked the 50 tips, you’ll love the book.

To everyone who attended one of my sessions, thank you for attending and thank you for the feedback. I’ve already got some ideas of how to improve things for next year.

Microsoft Dynamics GP 2010 Technical Web Seminars

David Musgrave and Mariano Gomez take their show off Broadway and on to the small screen (unless of course you have a monster monitor). Mariano and David have recorded versions of their blowout presentations on Dynamics GP development and support. The webinars are now available on PartnerSource so if you didn’t make it to Fargo for the deep dive or Convergence for the slim and sexy version make sure that you catch the webinars.

C">Microsoft Dynamics GP 2010: Customizing the Microsoft Dynamics GP 2010 Client with Visual Studio Tools, Dexterity and Modifier with VBA

Microsoft Dynamics GP 2010: Troubleshooting Your Developed Solution

 

 

Attachments and OLE DB

Andy Nifong looks at problems with attachments to notes in Dynamics GP along with some solutions.

Dynamics GP Land: Goodbye, VB

Steve Endow says Goodbye to VB over at Dynamics GP Land. Don’t worry Steve, there is still VBScript to play with in Integration Manager, no C# there!

 

Weekly Dynamic: Identifying Intercompany Transactions

In Dynamics GP Inquiries and Reports, an asterisk (*) on the end of a transaction number indicates a voided transaction. Most folks figure that out pretty fast. Less commonly known is that a pound sign (#) at the end of a transaction number indicates that this is an intercompany transaction using the standard intercompany functionality in Dynamics GP.

The Case Of The Pesky Window and Security

Christina Phillips takes a look at GP security in her new post titled The Case Of The Pesky Window and Security

Deep Dive Webinars for GP 2010

Christina Phillips has a great post pointing us to Deep Dive Webinars for GP 2010.

Dynamics GP 2010: What’s New in Field Service Call Management

I.B.I.S. colleague Amy Walsh takes a look at a new webinar with information about What’s New in Field Service Call Management for GP 2010

Management Reporter: Viewing Reports and Using Dimensions

Dynamics Corporate Performance Management has a new article up looking at Viewing Reports and Using Dimensions in Management Reporter.

Smart List Tree View Space

Mohammad Daoud looks at Smart List Tree View Space and how to get some back.

Security Smartlists

Waqas Butt has built a set of security SmartLists for GP10 and is offering them to the community for free. I suggest that you jump on this. Grab the SmartLists, download them and import them in into GP.

Convergence 2010 from a Consultant’s Perspective

Wicked smart consultant Michael Johnson takes a look at Convergence from consultant’s perspective. I’ve learned an awful lot of GP stuff from him over the years, you should too.

Real Life Dynamics User Look at Convergence 2010

Real Life Dynamics User blogs about his Convergence perspective.

Management Reporter Clarification

Jan at FRx Buzz clarifies some of the timing around Management Reporter for products other than Dynamics GP.

Dynamics GP 2010 is Loose!

It’s finally out, GP 2010 is available for download at:

PartnerSource Download
CustomerSource Download

Get yours today!

How to Use SQL Views

Real Life Dynamics GP user has a nice look at the basics of how to use SQL Views.

Management Reporter Roadmap

Everyone wants to see the Management Reporter roadmap and FRx Buzz has it.

What’s New in Manufacturing for GP 2010

Fellow I.B.I.S. blogger Amy Walsh shows us what new in Manufacturing for GP 2010 and points us to learning snacks on CustomerSource.

When NOT to move to Management Reporter

FRx Queen Jan Harrigan seems have user her Convergence time wisely learning more about Management Reporter. In a new post, she looks at when it’s NOT appropriate to move to Management Reporter yet.

Displaying Total Order Weight on the SOP Transaction Entry Window

Still catching up, I see that Steve Endow has been busy with a new post on Displaying the Estimated Total Order Weight on the SOP Transaction Entry Window.

Management Reporter Overview

Jan at FRx Buzz has a nice overview of Management Reporter. The things you learn at Convergence…hmmm.

econnect and Multi Bin Inventory

Steve Endow has a look at using econnect to bring in Multi Bin Inventory items.

Think About the End User

Steve Endow has a great post about how sometimes we end up in our own little world and it’s time to step out to where the client lives. I actually see this a lot with clients. They can’t generically explain what they do, they can only explain it in the context of their system. It comes out like “I process the invoice through the NCX10”. What does that mean? We do it to clients too and Steve talks about a recent experience.

Integration Methods for Dynamics GP

Sandip Jadhav has a nice concise look at the various integration methods available for Dynamics GP.

Excel Drill Down Builder

Computeration Dynamics has a great first look at the Drill Down Builder for Excel Reports.

Management Reporter Basics

Jivtesh gives us a basic look at the transition from FRx  to Management Reporter.

Testing Framework for Dynamics GP

Ok I’m digging out from Convergence. Hold on to your hats because the next several days are going to be very full.

Up first is the Dynamics GP Test Framework. This is a set of scripts, samples and utilities for testing Dynamics GP that first debuted at the GP technical conference in Fargo.

Weekly Dynamic: Portable Excel Reports, the Best of Both Worlds Part 2

Last week we looked at how to create a refreshable Excel report using ODBC connections to Dynamics GP. This week we will look at how to make it portable.

• Open the Excel file from last week.
• Pick Data | Properties | Definition
• Click Export Connection File and save the file.

Now the Excel file and the connection file can be sent together to provide a portable Excel file with built in parameters.

Microsoft Dynamics GP 2010 Cookbook

On the heels of Convergence I am thrilled to announce that my new Dynamics GP book, the Microsoft Dynamics GP 2010 Cookbook is available for preorder!

If you have liked any of the the 50 Tips presentations this book is for you. There are more topics like those in the book with greater coverage than even I could stuff into in a presentation. Don’t be put off by the 2010 in the title, I’ve baked in recipes for features still in GP 2010 that are useful all the way back to version 6 along with lots of new 2010 goodies. If you are running Dynamics GP you will get something out of this book. If you implement Dynamics GP you will get more of this and you will have a resource to make to your customers better users of Dynamics GP.
I’m putting the final touches on the book now and it will be available in the August/September time frame but you can get a significant discount if you preorder now.
An awful lot of people commented that the 50 Tips presentations were worth the cost of Convergence, well the book is better and cheaper. Plus you will be better looking by just carrying it around. Publishers react to cash so if you want more books on how to get the most out of Dynamics GP you have to buy some. Why not start with the Microsoft Dynamics GP Cookbook!