We use cookies to improve your experience on our website.

Andosi Blog

Exploring Great Design

A few days ago I created a simple example to create a vendor in Dynamics GP using eConnect. I received a few requests to show a sample integration to create new customers. Creating new customers in Dynamics GP via eConnect is a common request and usually proceeds the creation of other receivables documents.
The sample below creates a new customer using the eConnect .NET assembly and in-memory serialization.
To run the following code on your machine:

  1. Install the latest version of the eConnect 11 SDK.
  2. Create a new Console Application in Microsoft Visual Studio.
Add references to these dynamic link
Read more

Developing several integrations between Microsoft Dynamics GP 2010 and various third-party systems the last few weeks reminded me to update my previous article on In Memory Serialization for eConnect 10.
Microsoft Dynamics GP 2010 uses eConnect version 11 which includes significant updates. Notably, the COM+ component has been changed to a WCF service.
In this example, I am creating a new vendor record in Dynamics GP using the same in memory serialization technique. Why write a file to disk unnecessarily?
To run the following code on your machine:

  1. Install the latest version of the eConnect 11 SDK.
  2. Create a
Read more

Recently I was asked to look into an error a client was receiving while standing up a new Citrix server installation for their Dynamics GP 9 clients:
 

NOTE: If you are recieving this error while attempting to upgrade from Dynamics GP 9 to Dynamics GP 10, see this article.
 
When we hit the debug button to look at the underlying VBA code, we saw this line:
 

Based on the line of VBA code above, I knew that a connection to a database was needed, and the RetrieveGlobals9.dll was not installed on the new Citrix server. You
Read more

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
Read more

An article I posted sometime ago with a SQL Script that would reconcile SOP Batch Totals has really developed legs recently.  It's been downloaded several times a week for several months.  As a result, I felt some enhancement was in order.
To that end, I've compiled the same logic, with few exceptions, into an assembly you can download here.  Copy this to your Addins folder and then you can perform this same function from the Sales Batch Entry Additional Menu without having to run a SQL script or access the Reconcile Receivable Amounts Window in GP.

One exception to

Read more

The other day I was working on a SharePoint project that required the deployment of a Content Type, a List Template, a couple of List Instances and a couple of Feature Receivers. Things were coming along well until I started to reorganize the project. I dragged the List Instances into the List Template folder and renamed several folders to better represent their purposes. When I went to deploy, I got the error: "Error occurred in deployment step 'Activate Features': Invalid file name".

 
I looked around the .spdata files, checked the Feature file and double-checked them all again. Everything looked
Read more

The Dynamics GP Blogster: Microsoft Dynamics GP 2010 R2 is hot off the press...: "Microsoft has made GP 2010 R2 available prior to the original launch date of May 1, 2011. The product can be downloaded from CustomerSource ..."

This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.
Read more

Today I started a new project that had a requirement to create a new form in Microsoft Dynamics GP 9 to track additional item attributes.

 
On a clean install of Windows 7 32-bit, Office 2010, and Microsoft Dynamics GP 9, I received the file not found VBA6.dll error as soon as I'd made my first VBA modification:
 

 
I tried a few fixes including downloading and registering a new copy of the VBA6.DLL, but the error persisted.
 
Then I found a post by Beth Gardner describing the same problem. The resolution involved both a registry edit and
Read more

I discovered a problem in the way Dynamics GP Evergreen Contract Lines calculated revenue when 1) billing annually and 2) entering a quantity > 1 on the Contract Line.  Quite simply, it just didn't calculate the Total Amount on the Contact Line or the Invoice Amounts accurately.  This client is running GP 2010.

This was discovered late in the implementation finally being logged as a bug by Microsoft Support just days before data conversion was to be completed for the cutover to production.  Yikes!!  I was in quite a pinch without a good Plan B just days before go live.

Read more

Check out the Dynamics Community blog post on the voting for the most influential people in Microsoft Dynamics.  They did a great job of highlighting the Dynamics GP contingent to make it easy for you to vote.  They've moved me to Poll 5.

This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.

Read more

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

Read more

I recently received a request to lock down the Sales Transaction Entry Line Drop Ship checkbox when a line had been fulfilled.  This purpose was to prevent users from mistakenly marking a fulfilled line as Drop Shipped which automatically removes all of the Serial Numbers from the line.

 
To do this just add the Sales Transaction Entry window to Visual Basic.  Then add the Quantity Fulfilled field and Drop Ship checkbox to your project.  Copy the code below and paste it behind the SalesTransactionEntryDetail(Grid):
 
Private Sub Grid_AfterLineGotFocus()
    DropShipLock
End Sub
 
Private Sub QtyFulfilled_AfterUserChanged()
    DropShipLock
End
Read more

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,

Read more

Straight out of Tech Conference in Fargo this week, thanks to Dave Musgrave http://blogs.msdn.com/b/developingfordynamicsgp/archive/2011/03/04/microsoft-dynamics-gp-technical-conference-2011-day-1-morning.aspx, 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
Read more

Are you ready to renew your focus on business productivity? Then join us at our exclusive Microsoft Dynamics CRM 2011 launch event in Nashville where we will be exploring the power of the most highly anticipated CRM release in years.
This in-person event, hosted by Straight Arrow Consulting, Inc. CEO Tom Karpowich, will include a live demonstration from a true CRM expert - Ben Vollmer, as he shares with you ways he has helped other companies boost sales, improve marketing performance and enhance customer service through better use of their CRM technology. Ben is known for his impressive

Read more

I was recently tasked with creating a SharePoint interface to Microsoft Dynamics GP Item Maintenance. As the client's business had grown, inconsistencies in theirItem Master became apparent. When new items were needed, a similar existing item was copied and the details updated to match the new item. If there were no similar items, a new item was created.
The problem was, many of the existing items were not properly categorized. There were people in the organization who knew bits of information about items, but nobody had all the information to correctly set up an item. Setting up an item properly required

Read more

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 http://www.softwareadvice.com/articles/enterprise/can-microsoft-dynamics-erp-make-it-to-the-cloud-microsoft-executive-interview-1022211/.

This blog has been relocated from http://mbsguru.blogspot.com/ with authorization.

Read more

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 http://www.microsoft.com/dynamics/convergence/atlanta11/registration.aspx 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 http://mbsguru.blogspot.com/ with authorization.

Read more

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

Read more

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
Read more