Weird Duplicate PO Issue

Microsoft Dynamics GPThis is going to be a more wordy post than usual as I have no screenshots of the issue or resolution.

When I returned to the office on Wednesday after being away at reIMAGINE for a few days and then being on holiday in Kentucky, I was asked for assistance by Jason on our service desk.

A client had logged an issue with a PO; lets say the PO Number was PO34791 for the sake of argument (I don’t actually recall what it was).

When the PO Documents Enquiry (Inquiry) window was used, the PO looked fine; the creditor (vendor) was the correct one and all other values were okay and the PO showed as received.

However, the PO was also showing in PO Entry with a different creditor id.

Jason showed me two SQL queries;

  • The first, was a select on POP10100 WHERE PONUMBER = ‘PO34791’ and showed the correct PO.
  • The second, was a select on POP10100 WHERE VENDORID = ‘1ST001’ AND DOCAMNT = ‘791.50’ and this showed the other PO which the PO Entry window was loading. This query could be run for any information unique to the PO and it would return this PO instead of the correct one; ibncluding the PONUMBER field in the select would cause it to return nothing.

All very unusual.

I ran another query against POP10100 WHERE PONUMBER LIKE ‘PO34791%’ and this returned two lines of information both showing a PONUMBER field of PO34791.

in SQL Server Management Studio I dragged the values from the recordset into the query window to compare them; one was shorter than the other. The cause was that one of them (the one for the Vendor ID 1st001) contained a control character which is why it appeared shorter.

We’re not sure what the user had done, but the second, incorrect, PO was entered with a PO Number containing a control character; they’d been able to successfully enter the PO, but GP was then becoming confused about which one should be loaded when the user typed, or did a lookup, for PO34791.

We copied the live company into test and deleted the second PO (for vendor 1st001) from all tables (it had lines and tax and so on) and then verified the data with a Check Links and Reconcile and asked the user to double check.

This process would then be repeated on live with the PO being re-keyed (it was only a single line).

My MVP Renewed for 2016 And Jen Kuntz Awarded

Microsoft MVPWhile in America on vacation following reIMAGINE 2016, I received the notification email that I had been awarded the Microsoft Most Valuable Professional award for the fourth year running. It’s very nice to receive the award as it shows I am still contributing in a meaningful way to the Dynamics GP community.

There was another new MVP for Dynamics GP added to the roster this month as well; Jen Kuntz.

Jen has been a great contributor to the Dynamics GP community for a while now and I’m delighted to see that this has been officially recognised by Microsoft with her MVP award.

Microsoft Dynamics GP Core Installation and Configuration Credential Acquired

Association of Dynamics ProfessionalsI mentioned a few posts back that I had sat some exams for the Association of Dynamics Professionals. Well, I passed the Core Financials Setup and Functionality one, and also sat an exam for the Microsoft Dynamics GP Core Installation and Configuration credential.

I heard back yesterday that the Credentialing Council of the Association of Dynamics Professionals (DynamicsPro) has determined that I have met all requirements of the Microsoft Dynamics GP Core Installation and Configuration credential.

GP Core Financials Setup & Functionality

For those not in the know, the Association of Dynamics Professionals (DynamicsPro) is an independent, not-for-profit membership organization devoted to the global Microsoft Dynamics community of partners, customers and Microsoft.

Their mission is to ​establish and maintain professional competency standards and assessments​ for the betterment of the entire community.

I believe I am one of a very small handful of people in the UK to have this credential; nice to have them both too.

Microsoft Dynamics GP Core Financials Setup & Functionality Credential Acquired

Association of Dynamics ProfessionalsI mentioned a few posts back that I had sat some exams for the Association of Dynamics Professionals.

Well, I heard back yesterday that the Credentialing Council of the Association of Dynamics Professionals (DynamicsPro) has determined that I have met all requirements of the Microsoft Dynamics GP Core Financials Setup & Functionality credential.

GP Core Financials Setup & Functionality

For those not in the know, the Association of Dynamics Professionals (DynamicsPro) is an independent, not-for-profit membership organization devoted to the global Microsoft Dynamics community of partners, customers and Microsoft.

Their mission is to ​establish and maintain professional competency standards and assessments​ for the betterment of the entire community.

I believe I am one of a very small handful of people in the UK to have this credential.

A Diary of reIMAGINE 2016: Part 21 – Travel From Fargo to My Vacation

reIMAGINE2016Everything on this one started well as the flight from Chicago departed approximately on time, but went horribly wrong from there.x

I got up at 0330 in order to finish getting ready and had a taxi booked for 0400 which arrived on-time. I was at the airport with plenty of time to spare, especially seeing as American Airlines didn’t open the desk until about 0500 (so much for being at the airport in plenty of time).

The plane did depart on time, but because of bad weather, the plane took a dog-leg route due south and we arrived at Chicago 25 minutes late. American Airlines had made the ridiculous decision that Fargo to Louisville via Chicago only requires a 30 minute layover.

This meant I missed the connecting flight, as we arrived at 0815 and doors to the plane closed at 0810, from Chicago to Louisville KY.

I was on standby for a 1215 flight, but told if I can’t get on this the next flight was after 1300 and is not a direct flight. So, instead of a 70 minute plane ride to Louisville KY, I would be on a 3 hour flight to Charlotte and then another 3 hour flight to Louisville, and I had the horrible suspicion that Charlotte might be another really short layover meaning potential to miss the flight.

If I did end up onl the Charlotte flight, I would arrive at Louisville airport at 2100 (or later) instead of the 1030 I should have arrived; if I made the standby then I’d be there at about 1330 instead of 1030.

Well, I did not make the 1215 flight. However, I was given tickets for a 1510 direct flight from Chicago to Louisville.

So this meant I had a four hour wait to see if I’d be on that flight and then another three hour to wait for the flight I was given a ticket for and, as it turned out, that plane has at least two empty seats.

The waiting at the airport, did mean that I had the time to write all of these blog posts.

This huge amount of waiting is what American Airlines describes as “taking great care of me” and which I describe as doing the absolute bare minimum possible.

I initially thought this would get me to Louisville K in time for my booked tour with Kentucky Peerless, but I had not factored in the fact KY is on Eastern Time and Chicago on Central Time, so I arrived at 1730, which was the time the tour was booked to start and not the 1630 I thought I was going to arrive.

So, with the huge delays, it means that the first day of my vacation was a wasted day, thanks entirely to American Airlines.

This is the last post in the series; I am counting everything after this point as being vacation and not suitable for this blog.

Click to show/hide the A Diary of reIMAGINE 2016 Series Index

A Diary of reIMAGINE 2016: Part 20 – Post Conference Exams

reIMAGINE2016After volunteering to join the committee creating exam questions, I felt it necessary to take the existing examinations from the Association of Dynamics Professionals. So, my afternoon was taken up by sitting the Implementation exam and then after a ten minute break, the Financials exam.

I’ll find out in a few days, or a week or so, how well I did.

After the exams, I went back to the hotel for food and prepare for my departure early the next morning (taxi booked for 0400; flight departing at 0600).

Click to show/hide the A Diary of reIMAGINE 2016 Series Index

A Diary of reIMAGINE 2016: Part 19 – Conference Day 3/Leveraging GP Power Tools

reIMAGINE2016The final session I attended was Leveraging GP Power Tools which was a joint session between David Musgrave and Mariano Gomez; Mariano did the introductions to each section, with David then doing the demonstration.

I’m not as familiar with the GP Power Tools as I should be; I wasn’t that familiar with it’s predecessor, the Support Debugging Tool.

This session was aimed mainly at the deveoper tools, but the guys did have time to cover tools in other parts of the program.

GP Power Tools is sold by David via Mekorma, which is where Mariano works, with three modules being available for purchase separately but any one module and you get a System module included.

Unfortunately, I was unable to say goodbye to the guys as their session ended at 1230 and I was scheduled to take some Association of Dynamics Professionals examinations at 1300 back at the Hilton Garden Inn.

When I am back from vacation, I am going to have to get the latest verson of the GP Power Tools and spend some time going through them as, from what I saw, there are features from which not only Perfect Image, but also our customers, would benefit.

While I was at the conference, I did have an email exchange with one of PI’s Development Consultants where I advised that they would probably find the GP Power Tools useful.

Click to show/hide the A Diary of reIMAGINE 2016 Series Index

A Diary of reIMAGINE 2016: Part 18 – Conference Day 3/Troubleshooting Workflow

reIMAGINE2016The second session was on Troubleshooting Workflow and was run by current Microsoftie, Dan Peltier. Dan’s name is one which has shown up a few times when we have logged calls so it was good to meet him.

Dan’s session was spoilt a little bit by virtual machine issues which meant he lost his pre-created examples just before the session started. He did get through everything on the agenda. I’ll be honest on this one; I know workflow well enough (having implemented workflow a few times for clients and written a book about it; which I am currently updating for Dynamics GP 2016) that I half expected not to learn anything new, and if I am honest that was the case.

That said, some of Dan’s explanations were clearer (especially around the and/or clauses of step conditions) than the ones which I have given in the past and which I had included in the first edition of my Workflow 2.0 book; I will need to roll some of these into the second edition of the Microsoft Dynamics GP Workflow 2.0 book which I am currently writing (hoping to publish by end of October.

Click to show/hide the A Diary of reIMAGINE 2016 Series Index

A Diary of reIMAGINE 2016: Part 17 – Conference Day 3/Tips for Creating Integrations Session

reIMAGINE2016The third and final day of the conference was quite a short day with only three sessoins in the morning.

The first of the sessions I attended was Tips for Creating Integrations which was run by a former Microsoftie who now works at eOne. The session did have general tips on what you should be thinking about and asking when creating integrations, but was, as you would expect for a session run by a partner, focused on using their tools. In this case, the tool was SmartConnect.

As a partner of eOne already, SmartConnect was already on my list to take a look at (we currently mainly do SmartList Builder although we also have clients with Extender and SmartView), it was a very interesting session showing how data could be integrated into Dynamics GP from other sources such as Dynamics CRM or a web site and also how the Excel add-in can be used to extract data, and then update Dynamics GP once the user edits the data in Excel.

Much to think about.

Click to show/hide the A Diary of reIMAGINE 2016 Series Index

A Diary of reIMAGINE 2016: Part 16 – Conference Day 2/Keynote and Sponsor Barcrawl

reIMAGINE2016After the Custom Workflow Creation session, there was time to catch the shuttle back to the hotel for a quick change of clothes and then catch another shuttle to Downtown Fargo for the conference keynote and then a sponsor pubcrawl (or barcrawl for the Americans).

The keynote was followed by Mark J. Lindquist (a motivational speaker, singer and actor amongst other things). I was expecting this to be absolutely cringe-worthy, but Mark was an entertaining speaker who got quite a few laughs from the audience (I am willing to admit I may have smiled occasionally).

After this, there were five partners who had events at bars around the downtown area (none more than five minute walk from the remainder).

I bounced through a few of them and ended up at the Pickled Parrot for a while with Njevity (they have two MVPs), before catching the 2300 shuttle back to the hotel. While day three was a short day, I was aware I had a very early start on Thursday).

Click to show/hide the A Diary of reIMAGINE 2016 Series Index