Andosi Blog - the Art of Great Design

Record Lock Trace v 2.0

I've updated the Lock Trace Utility for Dynamics GP with 2 new features.
The first enhancement will replace the standard "This batch is being edited by another user" prompt when attempting to post or delete a SOP Batch with the name of the user that has the batch locked with an activity record in SY00800.

The second enhancement will clear all records that are locked by users that are not actively logged in to GP.  This will be executed when attempting to access a transaction locked by a user that is not actively logged in.  After, the record will be available and the following prompt will be presented.
The basic delete statements executed by this feature are listed below:
delete tempdb.dbo.dex_lock where session_id not in (select SQLSESID from dynamics.dbo.activity)
delete tempdb.dbo.dex_session where session_id not in (select SQLSESID from dynamics.dbo.activity)
delete DYNAMICS.dbo.SY00800 where userid not
Read more

Dynamics World List of Influential People

I'm not really sure how, and no I did not nominate myself, but I made it into the top 260 nominees for Dynamics World's Microsoft Dynamics Most Influential People.  Thanks to who ever did nominate me.  You can view the list of nominees here.

Several of my old friends are on the list; Mark Polino, Ross Carlson, Dwight Specht, Troy Ensor, Bob McAdam, and Shane Hall to a name a few.  Plus some of my new friends like Mariano and Dave Musgrave will surely be moving up the list this year.  People like Andy Hafer really deserve the recognition for their contributions to the community as do all of the Dynamics MVPs that we all hear from so often.  Many of those who run the popular VAR and ISV organizations are on the list as well.

You can vote for those that you think deserve recognition for their contributions

Read more

GP Password Expired mid-day... while I was posting a Batch

I was recently talking shop with another consultant that has a customer who's Dynamics GP password was valid when they logged in but expired after causing a batch posting interruption.  Has this ever happened to you?

He submitted a support request to Microsoft to explain this issue and seek out a resolution.  The response he received was:

As for ways to overcome the password becoming invalid mid-day, there are two options:

1. Keep the password synchronized (time-wise) with the windows password and use the windows password reminder as a GP password reminder
2. Use the GP Password Expiration Notification utility, freely available from the blog link below

Microsoft recommended the GP Password Expiration Notification utility with qualification, of course, that it is not something Microsoft created or provides support for.  Even so, it's nice to see that this utility is serving the community well by helping to solve and prevent common

Read more

Dynamics GP 2010 R2 Feature List

Straight out of Tech Conference in Fargo this week, thanks to Dave Musgrave, I came across this graphic that lists some of the exciting new features coming out with Dynamics GP 2010 R2:

Dave goes on to explain that not only is Dynamics GP not being laid to rest as some have speculated since Microsoft begin investing in Dynamics AX nearly a decade ago but rather in a future release they are planning to include a web based client for Dynamics GP.  That's a great improvement that I think we can all look forward to but first let's look at what's coming now:
  • Field Service Series customers should be looking forward to some of the FSS enhancements on deck:
    • The Contract Line Hold feature is well overdue.  I've had several clients that need this functionality.
    • Tech Stock Replenishment will be a much welcomed addition.  I'm actively working
Read more

Microsoft Dynamics ERP Push to the Cloud

The Software Advice Blog has a interview clip up with Guy Weismantel, Microsoft's Director of ERP Marketing, in which he discusses their strategy for moving Dynamics ERP to the cloud.

He makes a good point; many ERP components are already delivered as cloud based services and we continue to move in that direction.  A complete, cloud based ERP won't be suitable for every Dynamics ERP customer but will prove to be a very good for many.

Check out the clip at

This blog has been relocated from with authorization.

Register Now to Save - Convergence 2011 in Atlanta!

The Early Registration Deadline for Convergence 2011 expires on February 21 and hotels are filling up.  That's just 5 days away!

Register now at to save $300 off the regular price that kicks in on the 21st.

Register 3+ people and receive another $100 off for the the 3rd + Attendee.  Straight Arrow took advantage of this one with many of us invading Atlanta this year.  Hope to see you there!

This blog has been relocated from with authorization.

Updated: Lock Trace Utility for Dynamics GP - PO Support

I received a request to extend the Lock Trace functionality to support locked Purchase Orders.  It was a very simple change so I went ahead and implemented that functionality.  You can download this new version here if you're interested in knowing who has a Purchase Order locked when you attempt to access it.

I started working on another feature for this utility but didn't want to hold back this new feature while working on that.  I created a product page here where I'll document release notes as this utility evolves.

Keep the feedback coming.  I have several other ideas for this utility and would like to hear yours.

This blog has been relocated from with authorization.

Record Lock Trace Addon for Dynamics GP

Natively, Dynamics GP doesn't always do a good job of enabling users to resolve common issues on their own.  A classic example of this is the prompt displayed when attempting to access a record that is locked by another user.  By default, as a user you are presented with the very generic message:
This is the message presented when attempting to access a document that is locked by another user in Sales Transaction Entry.  Now, you can download the free Record Lock Tracing addon for Dynamics GP (Tested on v10 and GP2010) that will replace this generic message with a message that includes the specific user that has the record locked:
This has already solved some headaches for some of my clients eliminating the need to contact their internal IT department in order to determine which user has a record locked.  This is particularly useful during periods with
Read more

Dynamics GP Custom Links - Shipment Tracking

I was recently reminded how useful Custom Links are in Dynamics GP.  This feature is very powerful for streamlining your processes but often goes underutilized.
You can access the Custom Link Setup window in the Company section of the Administration page in Dynamics GP 2010 or at Tools>>Setup>>Company>>Custom Link.  Here is a quick example of how you might leverage Custom Links to streamline your processes in Dynamics GP to drill back directly to shipment tracking information from Sales User-Defined Field Entry:
To setup this up for Federal Express, add a new Custom Link for your FedEx Shipping Method as follows:

You could setup a Tracking Number Custom Link for all Shipping Methods but each carrier has a unique page for tracking shipments.  After setting up the Custom Link, in Sales User-Defined Field Entry, for documents with the Shipping Method for which you setup the Custom Link assigned; when clicking
Read more

Microsoft is finding success in the Enterprise Software Market

ERP Software Blog has a nice post up describing how Microsoft is finding success in the Enterprise Software space due in part to their shift to Azure cloud capabilities.

The Microsoft Dynamics stack isn't just for small and medium sized business.  We're seeing GP fit better and better in the enterprise space.  Don't rule it out when considering your next ERP.

This blog has been relocated from with authorization.

5 Reasons to Re-Implement your Dynamics ERP

Are you frustrated with your Dynamics ERP system and starting to consider other options?  Maybe you feel like you have outgrown your Dynamics ERP system and need to move on to something like SAP.  Maybe it's just time to take a fresh look at your ERP strategy to take it to the next level.
Over the past few years we have completed several re-implementations of Dynamics GP for our clients while several others are considering the same in favor or moving on to something else.  Here are some reasons why they are choosing to re-implement.
1. Enable new revenue streams and growth strategies:
After completing a Dynamics GP implementation for a client in the early 2000s they recently changed their distribution strategy to include direct sale retail stores and have expanded the number of customer service centers.  During the initial implementation, neither was part of their strategy or a design

Read more

Happy Holidays!

Happy Holidays everyone!

2010 has been great year for all of us at MBS Guru and Straight Arrow Consulting.  We recently wrapped up an integrated Dynamics CRM/GP implementation further evolving our Equipment Rentals Solution for Dynamics GP, are still working to help a client open a new Retail Store with an integrated Dynamics RMS solution, and are excited about all of the great projects, clients, and new products we are working with in 2011.

Check back for more posts from me, Bryan, and others after the first of the year.  As usual, we hope to grow to be more active in the community next year and expect to introduce a new MBS Guru contributor with a core competency around SharePoint soon.  We have a lot going on and are excited to share.



This blog has been relocated from with authorization.

Read more

Register today for the 2011 Microsoft Dynamics GP Tech Conference

The 2011 Microsoft Dynamics GP Technical Conference is open for registration.  This Partner event is in Fargo again this year; March 1-3.  They haven't posted the agenda, speakers, or sessions just yet but I'm sure we'll see Dave, Mariano, and some other familiar faces with some new information for us.


This blog has been relocated from with authorization.

Really???? Dynamics GP Report Writer is the Best Report Writer in the World?

Wow!  I never thought I'd have an opportunity to jump between Polino and Musgrave in a squabble but I just can't resist any longer.  Maybe they'll break out the sumo suits at Tech Conference this year and they can settle this debate once and for all.

I think Dave is just trying to get a rise out of Mark but I'll chime in anyway.  Like most, I lean towards the school of thought that Dynamics GP RW should NOT even be up for consideration as a the best in the world.  BUT, that's not to say it can't be great.

You can pretty much do anything you want with GP Report Writer as along as you have 1) intimate knowledge of the inner workings of GP and 2) know how to customize reports using VBA.  Dave demonstrates some of the advanced capabilities in his latest post on how Dynamics GP

Read more

Support Debugging Tool Build 14 released

The latest build of the Support Debugging Tool has been released by THE David Musgrave.  Check out the fixes, enhancements, and new features here

Ask your partner to download it for you now.

Thanks Dave.  Keep it coming!


This blog has been relocated from with authorization.

Business Process Improvement with Conditional Process Holds in Dynamics GP Sales Order Processing

I was presented with a business process problem by a client related to managing Credit Limit overrides in Dynamics GP Sales Transaction Entry.  This company does not supply Order Entry users with the Credit Limit override password.  It's the Credit Manager's responsibility to decide whether or not to allow that override.
This client has been working for some time to generally route information to the right person that needs to make the decision and eliminate waste in their business processes.  During the normal course of business when users are presented with the "Please enter the credit limit override password:" prompt the Credit Manager is called to the user's workstation to make the decision on the fly.


This is a very inefficient process.  What a great opportunity for improvement!
To resolve this issue and get the information to the person responsible for making the decision while maintaining the system controls required we got creative

Read more

Dexterity isn't going anywhere... anytime soon.

The topic of whether to execute a project by developing in Dexterity came up in a requirements discussion I had this week after The Dynamics GP Blogster and then Mark Polino opined on the subject.  I have spent some time thinking about this myself as we're also working on plans for 2011.  I don't think Dexterity is going anywhere as long as GP is around although it will continue to get depreciated over time.

When Microsoft purchased GP and consolidated ERP solutions under the Dynamics brand all the buzz was about both consolidating those solutions into 1 best of breed solution and/or replacing Dexterity with (insert your favorite .Net language here).  I don't even remember how long ago that was.  We're not really any closer to realizing either vision even though it's clear that .Net is the future for GP.

With the introduction of the Visual Studio Toolkit we're

Read more

  • This email address is being protected from spambots. You need JavaScript enabled to view it.
  • (813) 792-1939
  • Privacy Policy