“rsItemNotFound” error when clicking on any Navigation List in GP 2010 R2 (SP2)

After a recent upgrade from GP 9.0 to GP 2010 R2 I ran into an interesting problem. The client is running on SQL Standard 2005 SP4 and I was aware that the Charts and KPI’s in GP were not going to work since they are only supported with SQL 2008 or above. See an excerpt from the upgrade documentation below:

During my tests after the upgrade, I selected the Customer Navigation List and I was confronted with this error message:

rsItemNotFound400The item '/xxxxxx/Sales/Charts And KPIs' cannot be found.http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsItemNotFound&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.5057.00Microsoft SQL Server Reporting Services9.00.5057.00127OsIndependent1033ReportingServicesLibraryThe item '/xxxxxx/Sales/Charts And KPIs' cannot be found.

The first thing my mind jumped to were the new Business Analyzer panes in GP 2010 R2. How could I turn them off? The BA pane is looking for the Charts and KPI’s on the SQL Reporting services server and they of course are missing since they are not supported on SQL 2005.

Solution:

I discovered that I could hide the BA pane and the error message would then not show up. Once you click past all the error messages, the navigation list will load. You can then click the List Name settings dropdown >> Show/Hide >> and uncheck Business Analyzer.

This is great but what if I have many users and I want to hide the BA pane for every user? Using the Manual Logging feature in the Support Debugging Tool (written by David Musgrave from Microsoft, a must have if you’re a GP admin, available only on Partnersource, ask your partner to get it for you), I was able to determine which table holds this setting for the Navigation Lists. Below is a SQL script that will hide the BA pane for every Navigation List.

UPDATE DYNAMICS..SY07225 SET FactBoxVisible = 0

The above SQL code is great but there’s one problem. Every time a user clicks on a Navigation List that they’ve never clicked on before, a record will get inserted into the table and of course the BA pane will be visible by default. To overcome this problem, I used the above mentioned Support Debugging Tool to create a table trigger. When GP reads data from the List View Options table (DYNAMICS..SY07225), this trigger catches that read and changes the data that is getting returned to hide the BA pane. You can download the trigger here. Download the SDT_HideBAinNavigationList.xml.dbg.xml file. In Support Debugging Tool (I am using build 15, not sure if this file is compatible with earlier versions of SDT), select Options >> Configuration Export/Import and import the downloaded file. This will create an Automatic Debugger Mode trigger which you will need to enable for all users. Since this is not an SDT tutorial, please check out the Debugger pdf on the SDT page for instructions on how to use the Automatic Debugger Mode and the other features of the tool.

PS. This was a quick and dirty debugging job. I did NOT thoroughly test every bit of code in this example. Use at your own risk.

Of course, I gotta say, you really shouldn’t be on SQL 2005 because you’re missing out of all the new features. I should go tell the customer this…

History of Microsoft Dynamics GP (aka Great Plains)

Came across this short history of Dynamics GP and thought it was interesting:
http://www.mbsadvisor.com/great_plains/history.htm

My Review of the Microsoft Dynamics GP 2010 Cookbook: Tips You Can Use Now!

I just finished going through Mark Polino's "Microsoft Dynamics GP 2010 Cookbook" and I can say that this is not just another manual that says "click on the obvious menu, then click next...then click next..." (or maybe I should say this is as far from the built in GP help as one can get? ;-) This is a book full of tips that come from the field on how to solve real world problems that are sure to be encountered by Dynamics GP users.

But beware: This book is not a complete 1,2,3 on how to use or implement GP. (and not meant to be) Rather it is immediately useable tidbits that address common issues that can and will come up when using Dynamics GP. (just as the subtitle mentions very accurately notes) If you have had the good experience of sitting in any of Mark's "GP 50 Tips" sessions at Microsoft Convergence (he started a whole new genre of Convergence training session that has been spreading like wildfire ;-) you will know exactly the format of this book: fast tips that provide immediate solutions to real world problems.

I would guess that even the most savvy GP user will take away at least 5 very valuable tips from the GP Cookbook that will make the part of your life spent inside GP easier and more productive. (For most of us it will be a lot more. ;-)

There is one thing I can't figure out about this book: What is the picture on the cover?

You can get the book here:
http://www.packtpub.com/microsoft-dynamics-gp-2010-cookbook/book
http://www.amazon.com/Microsoft-Dynamics-GP-2010-Cookbook/dp/1849680426

PS-I co-authored a book by Packt publishing just last year and realize we had the same project team leader, Priya. Aparently I didn't totally drive her crazy. ;-)

Didn't Make It to Convergence? Here Is Another GP Training Oppertunity

http://decisions.msdynamicsworld.com/session/conducting-gp-annual-physical-simple-steps-diagnosing-health-your-microsoft-dynamics-gp-syst

A Free, Community Based Dynamics GP Knowledge Base Compiled from Blogs

Looking for a place to get free help about your GP problems? Now there is yet another source of assistance! Checkout Mark Polino's "My GP Search" and tap into the vast knowledge of many GP wisdom giants. ;-)

There is even an Android app for this resource as well.

http://mygpsearch.blogspot.com/p/my-gp-search.html

Dynamics GP Goes Web Based: Microsoft Dynamics GP Web Client Announced

Microsoft announced that a Dynamics GP Web Client is coming. At the GP General Session at Convergence 2011 this drew a lot of wows from users and partners. This product will not be out for another year so there are a lot of unknowns at this point.

My suspicion has been for some time that Microsoft is taking baby steps towards a web ui. Things like the web based components that kept appearing such as Navigation Panes, Navigation List preview pane and most importantly the SQL Reporting BI and reports which render on web engine.

Here are Some questions and the answers I could uncover.
(This was in chats here and there so things could change/be inacurrate etc. Keep in mind.)

Q:What does GP Web client UI look like?
A: In one word: Nice! It looks just like the existing Dynamics GP user interface with the Outlook overall view. It is running inside a browser but had a neat little feature that in the bottom of the window there was a panel that show a preview of all the open windows. Below is the Home screen:

Q: Is the UI snappy?

A: Obviously the demo will show something that works nice (not like,let's say Navigation Lists a year ago ;-) but in the General Session they demo'd editing a Vendor master and then moving to a new record. The navigation and data entry seemed to be snappy.

Q: Did I see "Tabs" on the GP Windows?

A: Yes you did! GP Web client is rendering extra windows supporting the main window as a tab. Wow--very smart. Take a look below and note the tabs on the Vendor Master windows.

Q: What about performance and server loading?

A: One person noted that with Terminal Services a server can handle approximately 15 users. With a GP Web Server they heard a test number of something like 75. So this shows that GP Web server will be considerable more efficient than TS.

Q: What About ISV Modules?

A: All Dexterity based modules will work with the new GP Web Client. It seems like behind the scenes the dexterity windows are being converted/(compiled?) to the web based screens. So this is huge and very well thought about.

Q: Won't some current GP windows not be well suited for Web?

A: Yes, and Microsoft noted that they are "cleaning up" some windows for the web client version to make things more streamlined.

Q: What is it built with?

A: Silverlight. It shows--nice.

With Internet Explorer 9's new "drag to your taskbar" feature which effectively makes any web page act like a windows application, GP Web Client will feal like a win app to most!

This developement is very big for the GP community. This means that GP is heading into the future and will be part of the "cloud" motion of everything. It will also make hosting GP exponentially easier. It will make the huge community of ISV products effectively web enabled.

And once again this demonstrates that Microsoft is fully behind Microsoft Dynamics GP!

Note: for even better screenshot of the web client I suggest going over to David Musgraves' article on this same subject:
http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/04/13/microsoft-convergence-2011-atlanta-day-2.aspx

My Review of Microsoft Dynamics GP Implementation by Victoria Yudin

I took the flying/waiting/travel time to Convergence 2011 to wrap up reading "Microsoft Dynamics GP 2010 Implementation" (using a some speed reading methods ;-). In this book fellow Packt Publishing author and GP consultant, Victoria Yudin, does a good job of walking the non-initiated through what a normal implementation of Dynamics GP should look like.

She also give a lot of practical, real world suggestions for anyone going through the implementation process. There is a lot of infrastructure advice (since we do infrastructure I can say this has a lot of good tips--actually many we recommend as well!): What does "official supported" hardware configurations mean? Lots of little practical tips around what server, SQL versions, getting Windows 2008 Remote App feature working with GP and running GP on Hyper-V. She also discusses some common questions that come up like: "Why don't we just implement on Terminal Server?" and gives a good list of pros and cons.

But the book doesn't stop at infrastructure. What is the best methodology for training? Who should train? What should a implementation time line look like? (with very specific list) Importing considerations and a lot more.

This book is a great read for those who have not implemented GP (or done erp) before as it gives a good overview of the processs. It is an especially good book to loan to those who want to self implement as it guides them away from many of the common pitfuls that will befall them. It was also good from my perspective to look over Victoria's shoulder and see another consultants tips and tricks.

Here you can get the book:
https://www.packtpub.com/microsoft-dynamics-gp-2010-implementation/book

http://www.amazon.com/Microsoft-Dynamics-GP-2010-Implementation/dp/1849680329

NOTE: i was not paid, given a book or in any way compensated for this review. ;-)

Our Dynamics GP Team is Ready to Head to Convergence 2011!

Our team is ready to head to Convergence 2011 in Atlanta, GA! Convergence is the premier Microsoft Dynamics event where we increase our ability to help you, our customer, optimize your business and improve your bottom line. This event serves as the meeting point for the Microsoft Dynamics Customer and Partner business community. We are ready to learn more about GP 2010, host clients/prospects and meet some of our regular vendors. If you want to meet us there you are welcome to drop us a line—we’d be glad to meet you in person.

Visit with one of our team members to find out more about SmartSearch, the new "Google for GP." It takes the pain out of searching for & finding the information you need, giving you results in mere seconds. You can also look here for more information.

Our GP consultants will be out of the office from Monday, April 11 – Wednesday, April 13. If you need support during that time you can call in and we will schedule you to be taken care of ASAP beginning on Thursday the 14th.

Learn About GP and Get 20% GP Purchases at the Same Time

Good convergence website

https://mbs.microsoft.com/partnersource/newsevents/events/convergence/

Learn GP and Get 20% Off New GP Modules!

Microsoft is excited to announce the "Microsoft Dynamics Convergence 2011 Exclusive Attendee Offer" a Microsoft Dynamics promotion exclusively available to you as a Microsoft Dynamics ERP existing customer in the U.S. and Canada, by attending Convergence 2011. Visit the Convergence Website or CustomerSource to find out more!

To take advantage of this offer and for additional details please talk to your Microsoft Dynamics partner. Mention Promo code: NA-HI-11-22

http://www.microsoft.com/dynamics/convergence/atlanta11/about_salesoffer.aspx
Register Today to attend the Convergence 2011 Microsoft Dynamics GP Event!

Google for Dynamics GP: Smart Search

Search for ANYthing in Dynamics GP from one place! Amounts, Sales Order Lines, Vendors, GL transactions or whatever!

This module is totally secure and observes GP User Role security.

And you can add any new search for GP or other data.

This module will be released shortly. Email sales@landiscomputer.com if you need it now! ;-)

Credit Card Processing Capability Built Into Dynamics GP for Free

Microsoft sure isn't sitting still with Dynamics GP. Dynamics GP 2010 saw a large amount of new features. And now new functionality and service are making their way into the product: How about accept credit cards directly from the Sales Order processing recieve payment screen? Yes and at no additional cost. And Microsoft has even negotiated low credit card processing fees if you elect to process through their providers.

If you want to implement this let us know! sales@landiscomputer.com.

Google for Dynamics GP: Easily Search All Your GP Data from One Place

(NOTE: FREE COPY FOR EVERY GP PARTNER DURING CONVERGENCE 2011. SEE BELOW)

Wish you could "Google" your Dynamics GP data? Our new SmartSearch for GP enhancement will allow you type in any unique term and click search and results from all GP modules will be returned in nicely organized tabs. Even though SmartSearch querys quite a bit of data the results are usually returns in seconds.

We have found that user adoption is immediate after demoing this search tool only for a short time!

See our 1 minute video of our SmartSearch product below:



The SmartSearch search engine can easily be extended if a unique search we didn't think of is need by you. We can add the new search or an admin user can.

Security is also an integral part of SmartSearch. For example: Sales users will be able to access sales and inventory without allowing access to payroll and GL information.

SmartSearch: "Google" for Dynamics GP:

Easy to Buy ($1500+maint), Easy To Install & Easy to Use!
Free NFR for all GP Partners that email sales@landiscomputer.com ask for "SmartSearch/Google for GP" during Convergence 2011.

Free Addon Add's Dynamics GP Click-To-Dial Functionality With Most IP Phone Systems

I am a communication enthusiast (I have a blog and wrote a book on Windows phone systems) and also Dynamics GP partner so at Landis Computer we have merged this expertise to enhance your Dynamics GP! We are very shortly releasing our free Dynamics GP Productivity Pack addon for GP and it will now include the ability to click on a phone number  and have your favorite softphone dial the number!

I was a bit surprised to see that Dynamics GP 2010 didn't include this feature considering the great new Communicator integration into GP 2010--but we will solve this little bump in the road by providing a free GP addon that will add this for. Hey, the addon actually does quite a little list of other cool things (click here to see the other features)

We will be releasing the new addon in the next few days. To get on the list to be notified when we release the GP click-to-dial Click Here. (you will also get a link to the current version of the addon.)

To See the New PDF Brochure (including click-to-dial functionality) Click Here.
To Sign Up to Get the New Addon Click Here.

Has Microsoft Marketing Already Entirely Forgotten My Dear Microsoft Small Business Financials?

It appears that the marketing department at Microsoft has already forgotten which product used to go by the acronym "SBF" at Microsoft. Checkout the new offer to upgrade Microsoft Small Business "Framework" data to GP for $1000.

It's hard not to be miffed that my dear product, Microsoft Small Business Financials, is already dead, buried and forgotten by Microsoft! ;-)

Partners can check out this gaffe at:
https://mbs.microsoft.com/Cms/Templates/document/General.aspx?NRMODE=Published&NRNODEGUID=%7bECDA6FD9-01E3-4BE0-98C4-EE2DB9255981%7d&NRORIGINALURL=%2fpartnersource%2fsales%2fpromotions%2fmsdgp2010sbfwmigrate%2ehtm%3fp%3d8&NRCACHEHINT=Guest&p=8

For those of you who don't know it--I was introduced to Dynamics GP through our company supporting a LOT of clients using Microsoft Small Business Financials--so that is why it is so "dear" to my heart. ;-) In fact Landis Computer recieved an award (2 Zunes ;-) for doing more SBF moves than any other partner! ;-)

http://dynamicssmallbusiness.blogspot.com/2009/08/landis-computer-microsoft-dynamics.html

So, if you are still using Microsoft Small Business Financials--call the experts who know small business and can make the move from Microsoft Small Business Frame--ah--rrr Financials...as smooth and fun as possible.

How to Get GP 2010 New Reminder Cues To Render Right on 64bit Workstations

Reminder Cues are a very nice new feature on GP 2010 that gives you a visual cue as to how many items are returned in a Homepage Reminder. I’ve been noticing ever since GP 2010 Beta that on our systems the little stack of papers is Missing! We just installed GP 2010 at our site and Urggghh…they are still missing!

After a little digging I discovered that this is a 64bit workstation issue and there is a “simple” fix: Just install GP 2010 in any directory EXCEPT the default. Microsoft appears to know about it.

Hmmm...we have all Windows 2008 64bit, all Windows 7 Pro 64bit workstations...Office 2010 64bit...and I'm hearing rumblings there are some warnings about 64bit Office too.

Source:
http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/thread/77c93f0c-9fa1-4a30-8a57-dd7ba72a2e22

PS-I just noticed another issue with Cues on Windows XP Pro 32bit: Reminder Cues only seem to appear for "Predefined Reminders" and not for "Custom Reminders". If anyone has anymore to say about this or a solution I'd love to here it.

Get Community Help for GP: The Dynamics GP Forums

https://community.dynamics.com/forums/32.aspx

http://social.microsoft.com/Forums/en-US/partnerdynamicsgp/threads

What Are Requirements for GP 2010?

With the release of GP 2010 there are a lot of people wondering what the server and workstation requirements are. Below is a great web page to give you all the information you need related to the requirements for GP 2010:

http://www.microsoft.com/dynamics/en/us/using/gp-system-requirements.aspx

This page also gives scenario requirements for the SQL server. Very good page.

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

Ever have someone that wants to see GP Items that didn't sell lately?
Here is the SQL statement:


select itemnmbr, itemdesc, Item_Sales_Aggregates.Last_Sold, Item_Sales_Aggregates.Line_Qty from iv00101 left outer join

(

select max(document_date) as Last_Sold,count(document_date) as Line_Qty, item_number from

(select sop10100.docdate as document_date, sop10200.itemnmbr as Item_Number, sop10100.soptype as sop_Type
from sop10100 join sop10200
on sop10100.sopnumbe=sop10200.sopnumbe and sop10100.soptype=sop10200.soptype

union

select sop30200.docdate as document_date, sop30300.itemnmbr as item_number, sop30200.soptype as sop_Type
from sop30200 join sop30300
on sop30200.sopnumbe=sop30300.sopnumbe and sop30200.soptype=sop30300.soptype) as B

where sop_type=3 and document_date between '1/1/2009' and '5/30/2010'
group by item_number

) as Item_Sales_Aggregates

on iv00101.itemnmbr = Item_Sales_Aggregates.item_number

where line_qty is null

Convergence 2010 Recap: The Year of GP

I thoroughly enjoyed being at Convergence 2010 once again this year with our team. GP was up font and central. The GP buzz was great.

I was also glad to get to meet Mark Polino and David Musgrave for the first time in person. Leslie Vail, in the GP Learning Center, was giving value far beyond just getting users launched on GP training. Thanks

On Convergence Dynamics GP Content

• GP Business Intelligence is getting up to speed with 245 BI SRS Reports, 119 Charts/Gauges and 23 built in drill back into GP fields. Cool.


• GP to CRM Integration keeps improving and now supports CRM Online


• CRM improving cost-wise also: GP owners get discount on CRM Online subscription.


• Mark Polino's 50 Tips Session was fast, fun & full. Just getting the deck isn't like being in the session--but it's better than nothing.


• Andrew Brown from eOne says performance on Navigation Lists in GP 2010 has been fixed. Once I test this personally in GP 2010 I will post an entire article about this. This will be very big for Navigation List up-take.


• The GP + Unified Communication (OCS) integration is huge. Chad Sogge said they showed it off to Steve Ballmer (who was impressed) at some Microsoft retreat. I'm a GP and communication dude and this integration has huge potential in several ways in my mind. See my post on it.


• Did you see that GP Sales Order Processing Add-on that allows offline sales entry? .Net but looked just like Dexterity.

Some Random Thots:

• Having wifi in the session rooms would be a great way to make live bloggers happier--and perhaps make speakers feel less listened too? ;-)


• Next year, could someone order nice weather so our customers don't get their flights canceled? ;-)
• For anyone that noticed (and commented) on my MacBook, don't worry--I'm a PC! ;-)

New Dynamics GP Book Coming Out: Microsoft Dynamics GP 2010 Cookbook By Mark Polino

The Dynamics GP 2010 availability is also accompanied by the news of a new GP book by prolific GP blogger and now author, Mark Polino. His new book is due in August and is titled "Microsoft Dynamics GP 2010 CookBook" and published by Packt Publishers.

The book promises to provide "useful recipes for improving the way you use and work with Dynamics GP" and if the tips in it are similar to the very popular "50 Tips" session Mark delivered for the last 2 years at Microsoft Convergence you can count on some very good content.

I've just finished co-authoring a book on a Windows based communication solution for the very same publisher and I know its a lot of work (and not necessarily huge pay ;-) so I would say to Mark, thanks for once again contributing to the GP community!

Get over there and pre-order your copy.