Page 1 of 3112345678910...202530...Last »

#GPUGSummit – Getting There – Part 2 of 2

David Meego - Click for blog homepageGPUGSummit_Logo

Day two of the Road Trip had us heading out from our overnight stop in Chico, California and finishing the drive to Reno, Nevada.

Below is the map of the route for the second day:


Now, I know that Australia has some funny place names, but it seems that the United States has its share too. During the drive we passed the turn off for a town called Rough and Ready in Nevada County (which is still in California).

Rough and Ready Highway

We decided to pull off the highway in a town called Grass Valley so we could find some lunch. We ended up at the Holbrooke Hotel, where we had a very nice meal. I really appreciated that the waitress made a special effort to ensure that there were no flavour enhancers in the food. She also helped identify that Ranch Dressing (both bottled and packet mix versions) usually contains one or more flavour enhancers*. Shame as I like the taste, but can not longer risk eating it.

The Holbrooke Hotel in Grass Valley

Before we left Grass Valley, Craig decided he wanted to get a coffee for the road and dropped in to a small corner store called Cousin Jack Pasties.

Cousin Jack Pasties, Grass Valley, California

This small shop is not remarkable, what is remarkable is what we found on the shelf in the store. I did not expect to find Vegemite in a small store a small town in the remote northern California.

Vegemite and Marmite – Australian and English yeast extract spreads

Once we were back on the road we were treated to some great scenery again.

Driving through the pine trees

Another fantastic view over the wilderness

We are getting closer now, Reno is on the road signs

Wide straight roads – a nice change from yesterday

Still driving through the mountains

Crossing the state border into Nevada

Arriving in Reno, Nevada

Finally, we came over a crest and Reno, Nevada appeared in the distance. With a little bit of help from GPS on the phone we arrived at the Peppermill Resort Spa Casino on South Virginia Street where I would be staying for the conference.

Approaching the Peppermill Resort

The two day road trip was over and I had survived. Thanks Craig. :)

Now to get ready for GPUG Summit 2015.


* Common Flavour Enhancers which can cause headaches, nausea, irritable bowel, asthma attacks and more include:

  • 621 – Mono Sodium Glutamate (MSG),
  • 627 – Disodium Guanylate,
  • 631 – Disodium Inosinate,
  • 635 – Disodium Ribonucleotide

This article was originally posted on

Filed under: Conference, Dynamics, GP, GPUG, Microsoft Tagged: Conference, GPUG Summit 2015

Follow this link:
#GPUGSummit – Getting There – Part 2 of 2

October 30, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 47

Excel Copy/Paste feature not working on General Entry modified window

If you have grown used to the relatively new Excel Copy/Paste feature in the General Ledger Transaction Entry, you are probably enjoying the benefits of collecting journalized spreadsheets from around the company and simply integrating these into Microsoft Dynamics GP without too much effort.

Excel Copy/Paste in GL Transaction Entry window

The fact is, not having to run an integration from another tool for something apparently very simple, always seems to be the way to go.

Recently, however, I ran into a situation where this window had been customized with Modifier (but the same can be said for a third party alternate version of window) by a customer. The customer reorganized a few fields within the window and added a couple others with Modifier to address some specific business needs. As it turned out, the Excel Copy/Paste functionality no longer worked, even though the target fields remained the same. Reverting security to the original window rendered the feature usable once more.

If you must modify this window _and_ still require the Excel Copy/Paste feature, you will need to create an additional user with access to the original (core) window. This is very similar to what’s required for Integration Manager to function when a window has been modified with Modifier or changed by a third party product.

Well, now you know! Happy copy/pasting!

Until next post!

Mariano Gomez, MVP

See more here:
Excel Copy/Paste feature not working on General Entry modified window

October 23, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 44

Dexterity Training in Mexico – Part 3 of 3

David Meego - Click for blog homepageNow it was Sunday and Mariano Arias and José Ramírez had planned another day of sightseeing.

They wanted to make sure I got to see lots of Mexico while I was in the country and once the Dexterity training started, there would be very limited time.

The day started a little later, which was good after such a busy day yesterday. José and I walked from the hotel to the park in front of Chapultepec Castle where we met Mariano. We then walked through the park and up to the castle which is situated on a hill.

Chapultepec Castle from below

The castle is the only royal castle in North America that was actually used as the residence of a sovereign: the Mexican Emperor Maximilian I, and his consort Empress Carlota, lived there during the Second Mexican Empire.

Chapultepec Castle Grounds

It is now the National History Museum and contains lots of artefacts and information about the turbulent history of Mexico.

Upper Gardens of Chapultepec Castle

Just a quick side note, if you saw Baz Luhrmann’s movie version of William Shakespeare’s Romeo and Juliet you might recognise this beautiful building as the Capulet Mansion.

Lower Gardens of Chapultepec Castle

After viewing the castle we walked along the wide avenue which runs from the castle through the city, the Paseo de la Reforma. This took us to the stunning Angel of Independence monument which was created to celebrate the centenary of Mexican Independence. There is a mausoleum at its base which we were able to walk through to pay our respects. It is possible to get to the view platform at the top, just below the golden angel, but that must be organised in advance with the authorities.

Angel of Independence

That completed another day of sightseeing and now it was time to get some rest before the Dexterity training started on Monday.

On Tuesday night, after the training, José decided to take me and a couple of the out of town attendees from the training course to soak up some real Mexican culture…. in the form of Mexican Wrestling. My prior “experience” of Mexican Wrestling was entirely based on the Jack Black movie from 2006, Nacho Libre. This was not the best movie ever, but at least I knew a hint of what to expect.

I had seen Mexican Wrestling masks for sale and I knew that the character portrayed by the wrestlers is probably more important than their technical skills in the ring (which is a boxing type square).

Mexcian Wrestling Masks

To give you a taste of the mayhem and noise that makes up Mexican Wrestling here is a video from the night. There was a lot of acting and some fantastic choreographed sequences in what was a fun night.

Mexican Wresting in Mexico City (direct link)


On Wednesday night we had a change of pace and visited Coyoacán. This is an historic town which has a very strong Spanish heritage. It actually felt like you were walking through the streets of Barcelona (except for the odd Mexican flag).

Drinking Coyotes Fountain in Coyoacán

The fountain and the park in the centre of town depicts two drinking Coyotes, which is what gave the town its name. While there we went to a food hall area where there was a gentleman making pancakes. The difference was that you could ask for him to make anything with the pancake.

Kangaroo Koala
Pancakes in the shape of a Kangaroo and Koala

Check out the video of the pancakes being made:

Fancy Pancakes at Coyoacán in Mexico City (direct link)


On Thursday night (1st October), we visited Tlatelolco in the north of México City. We went to an area called Plaza de las Tres Culturas. The square is flanked by three cultures: Aztec, Spanish and modern Mexico. There are the remains of Aztec temples on one side, with the Catholic church of Santiago de Tlatelolco on another and a modern era housing complex on a third side. The church looks like it was built to match the Aztec temples as it is built from the same stones…. exactly the same stones. Sadly, much of the Aztec ruins where dismantled to built the church.

Catholic church of Santiago de Tlatelolco at night

This area also has significance in modern history as it was the site of a student demonstration in 1968 which ended in a massacre by the authorities which hundreds killed and injured. There is a memorial on the south side of the plaza, to commemorate the 25th Anniversary of the events of 2nd October 1968.

On Friday, we finished the class materials and had time for questions and answers and also to review any topics the attendees wanted.  We also took a photo of the attendees outside the office building.

Attendees from the Dexterity training.
From left: Julian Olave, Alberto Rodriguez, Gilberto Sosa, Marcos Cristales, Mariano Arias*, Karina Zapata, David Musgrave, Deneb Ortega, Jose Ramirez, Mario Rodriguez.
Absent: Horacio Tena

The next day was Saturday morning and time for me to leave Mexico and return to the United States for the next part of my trip. After being dropped off at the airport by a taxi, I caught a flight to San Francisco.

Thanks to everyone who made me feel welcome in Mexico and especially my hosts, Mariano Arias and José Ramírez from Axentit.


* Mariano did not actually do the training, but wanted to be in the photo. :-)

This article was originally posted on

Filed under: Development, Dexterity, Training Tagged: Development, Dexterity, Training

Read More:
Dexterity Training in Mexico – Part 3 of 3

October 12, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 48

#reIMAGINE2015 – Day 2

David Meego - Click for blog homepagereIMAGINE2015_Logo

Tuesday started again with breakfast in the Grand Ballroom at t Hilton Garden Inn. Mariano had some things to deal with so I headed over to the Microsoft Campus for the day’s sessions.

The first session for me was an Expert 1-on-1 Workroom with Leslie Vail. We had about 10 people join us in the room, but there were not many developer related questions. So I let Leslie drive the session and discuss various application level topics.

Later, I sat in on Mariano’s Expert 1-on-1 Workroom with Windi Epperson and relaxed a little as the others discussed a variety of topics, including options for Web Client deployment and Azure clouds vs other cloud services vs hosted services.

Then it was time for lunch in the Microsoft Cafe and Chef Kevin looked after me as he always does when I am in town. He ensured that the food I selected had no Flavour Enhancers (like MSG and its buddies) which have nasty effects on me :-(.

We then left the Microsoft campus and headed back to the Hilton Garden Inn. I had a meeting and so was unable to attend the Rapid Fire Partner Solution session, but the meeting went well.

Then it was time to get on a coach and go “Downtown, things will be great when you’re Downtown” to the Fargo Theatre.

The evening of the Fargo Downtown Experience started with a networking reception at the “Art Deco” Fargo Theatre (built in 1926 and restored in 1999). While the reception was in progress, we had some drinks (& popcorn) and listened to the organist who rose up from below the stage and played a great range of show tunes.



Then, as the organist disappeared back into the ground, it was time for Keynote Speakers. The first speaker was Wayne Morris from Microsoft (who originally hails from Brisbane, Australia). He reiterated Microsofts commitment to Dynamics and the small and medium market.

The rest of the speakers were all from the Fargo region and were introduced by our MC for the night Greg Tehven. We heard from Clint Howitz, CEO of DogIDs, who explained how an idea with one employee working from home has grown into large business with many employees. We also heard from Max Kringen, CEO of TellWell. TellWell is an organisation which helps other businesses with guidance and planning for social media strategies and design.

The final speaker was Mark Lindquist, who is a former United States Air Force Sergeant who now works as an actor, entertainer and motivational speaker. Mark was incredibly dynamic (no pun intended) and challenged everyone to get out of their comfort zones and do something that makes you uncomfortable as once you have done it a few times it will become normal.


To demonstrate he asked the audience to clasp their hands and then open their arms and do “Jazz” hands and then clasp them again. We repeated this three times and then he asked us to notice which thumb was on top. The point is that people always clasp their hands the same way ever since they were babies. Changing the clasp to the other way just feels wrong. Try it right now….. See what I mean?

We then tried the same process with crossing the arms and again one way feels natural and the other feels uncomfortable. Go on try it now…. no one is watching. The moral of the story was to get out of the comfort zone and reIMAGINE what you can do, soon it what was hard or felt wrong will be normal and you can move on to the next challenge.

After the session was over, we noticed that the first challenge for the evening was spelling related. :-) 


After the keynote speakers, many of the attendees started with the “Downtown Experience” which was a sponsored pub crawl with each of the conference sponsors taking over one of the local drinking establishments.

I skipped the pub crawl and instead had dinner with the teams from NexTec and Mekoma as well as some friends. We had a lovely meal at Mezzaluna, which is situated behind the Fargo Theatre (number 14 on the map below).

Mezzaluna Clockwise: Angel Blum, Mark Wiley, David Musgrave, Leslie Vail, Jen Kuntz, Craig Klapman, Corey Clay, Sheila Jefferson-Ross, Mike Davis, Belinda Allen, Mike McDowell, & Elsa Williams.

Note: Mariano was at Mezzaluna, but ended up on another table as we had too many people… more than the original booking number.

After dinner some of the group went and joined the Downtown Experience, while a few of us caught a coach and headed back to the hotel to get some rest.


Stay tuned for Day 3 and the final day of the conference.


This article was originally posted on

Filed under: Conference, Dynamics, GP, Microsoft Tagged: Conference, reIMAGINE 2015

Read the article:
#reIMAGINE2015 – Day 2

October 9, 2015 · WinthropDC · No Comments
Tags: , , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 53

You receive "Exception has been thrown by the target of an invocation" when running some reports in Management Reporter 2012 CU13

In my previous post, I talked about a cryptographic exception I encountered while upgrading Management Reporter 2012 from CU6 to CU9 (on the way to CU13), while attempting to setup the Data Mart database – see You receive “Could’n retrieve the list of available databases: The connection attempt failed” error when updating Management Reporter 2012. The solution turned out to be very simple, but in the scheme of things a bit time consuming to figure out. Once we had upgraded to CU9, it was time to attempt the upgrade to CU13.

The upgrade process

Upgrading to CU13 was pretty straight forward.  However, after the upgrade, the customer attempted to generate a couple of the many reports from Report Designer with the following error being displayed in Web Viewer:

This report can’t be displayed. Make sure that your computer has an internet connection and that Management Reporter is running. If this problem continues, contact your administrator.

Management Reporter 2012 CU13 error when generating report to Web Viewer

When attempting to open the same report from Report Viewer, we obtained the following exception error, with the Report Viewer application crashing after clicking the OK button:

Exception has been thrown by the target of an invocation.


After the errors, we tried copying the columns, row definitions, and trees onto completely new report objects (rows, columns, and trees), respectively, and tried to run the reports once more, obtaining the same results. The customer relies on this report on a daily basis, so it was critical we fix whatever issue was causing these reports to crash.

After some back and forth with Microsoft Support, it was determined that with CU13 the B0 print control in the row is not working and causing the exception:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidCastException: Specified cast is not valid.

Microsoft Support is currently working on getting the issue written up and triaged so as soon as a bug number (or a fix!) is available I will publish more about it.

As it stands, we reverted back to CU9 and upgraded to CU12 which did not display the issue described herein.

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

View the original here:
You receive "Exception has been thrown by the target of an invocation" when running some reports in Management Reporter 2012 CU13

September 1, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 122

"A SQL Server login already exists for . Delete the user and create a new user" error when switching a user ID from web client only to mixed…

I’m completing the deployment of Microsoft Dynamics GP 2013 R2’s Project Accounting and Time Entry approval workflow for a customer in Alabama who is currently deploying web client for extranet access (and timesheet entry) and desktop client for intranet access.

As a result, since time entry employees are remote, we decided to setup these user accounts as web client only. However, the customer wanted to provide an alternative to the web client in case it became unavailable. This meant that these users would needed the ability to access the Microsoft Dynamics GP desktop client via a Terminal Server provisioned (albeit temporarily) to support this goal.

The Problem

To meet this requirement, we needed to adjust the user accounts in Dynamics GP to also support SQL Server authentication (in addition to web client access), by deselecting the Web Client user only check mark and completing the SQL Login credentials information. Upon attempting to save the changes we received the following error:

A SQL Server login already exists for userID. Delete the user and create a new user.

As it so turns out with most application errors, you cannot just follow the instructions literally to fix the problem. In this case, we had more than 85 web client only user accounts created so “Delete the user and create a new user” wasn’t an option and I don’t know why I had a gut instinct this recommendation would not work anyways.

It also turns out that I tested this in Microsoft Dynamics GP 2015 and had no issues switching a user account from Web Client user only to a mixed mode access user account.

NOTE: “mixed mode access” user is a terminology I came up with to identify a Microsoft Dynamics GP user account with access capabilities from both the web client and desktop client.

The Solution

In troubleshooting this problem, the first thing is to focus on the first part of the error message, “A SQL Server login already exists”. If a login already exists on SQL Server, then it should be visible under Management Studio – bear in mind that each Dynamics GP user account was setup as a web client only account to begin with. In principle, there should be no SQL Server security principal for these type of accounts.

Management Studio did not show any account created for the Dynamics GP under the Security folder. So the next logical thing would be to run a statement to check for a SID for the account in question:

SELECT suser_sid(‘TheUserID’);

This statement returned an actual SID number (a long hexadecimal set of characters), confirming at least there was a corresponding SID for the account, even though we could not see the actual account in Management Studio.

Next was to verify then, what account was assigned to that SID. In order to do this, I ran the following SQL statement:

SELECT name FROM sys.server_principals where sid = (SELECT suser_sid(‘TheUserID’));

As it turned out, this statement returned no results. So here’s the conundrum… GP thinks there’s a SQL login for a user account that doesn’t really exists on SQL, but has a SID.

Now, because there wasn’t an actual SQL login for the user ID in question, I went ahead and setup a new SQL login with the user account by running the following statement:

sp_addlogin(‘TheUserID’, ‘somePassword’);

The statement was successful and I could now see the SQL login under the security folder.

The next thing was to then reset the Dynamics GP web client user flag and assign the SQL login to the user account:

UPDATE SY01400 SET WCUser = 0,  SQLLoginID = ‘TheUserID’ WHERE USERID = ‘TheUserID';

Since Microsoft Dynamics GP passwords are encrypted on SQL Server, you will now need to log into Dynamics GP, pull up the user account under the User Maintenance window, and change the password in the SQL login credentials section.

I cannot assess whether this is a bug or not, but suffice to say the same behavior is not present in GP 2015, so I must lean towards it being a bug.

I hope you find these troubleshooting steps useful.

Until next post!

Mariano Gomez, MVP
Intelligent Partnerships, LLC

Continued here:
"A SQL Server login already exists for . Delete the user and create a new user" error when switching a user ID from web client only to mixed…

May 29, 2015 · Mariano Gomez · No Comments
Tags: , , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 516

Upgrade from GP 2010 to GP 2013 R2

3d man with Q & A

Question: How do you upgrade from GP 2010 build 2390 to GP 2013 R2

Answer: The documentation from Microsoft that delineates the upgrade path from GP 2010 to GP 2013 R2 is missing the current build of GP 2010 (as of 3/16/2015). The document from Microsoft can be found here:

The line missing is how to upgrade to GP 2013 R2 from 11.00.2390. The answer is that you have to upgrade to 12.00.1826. The build numbers for both GP 2010 and GP 2013 R2 are achieved after installing the January 2015 Hotfix. Thanks go out to Paul Degneau, at Standard Process, for suggesting this to me.



Original post:
Upgrade from GP 2010 to GP 2013 R2

March 17, 2015 · Leslie Vail · No Comments
Tags: , , , , , , , , ,  · Posted in: Blogs I Follow Total Views: 192