Dynamics GP–Clicking “on order” in inventory enquiry shows blank empty with no purchase orders

Seen this from three users recently. The issue is that the user clicks the on order hyperlink text in item enquiry to see the purchase orders in Purchase Order Processing Item Enquiry, but nothing is shown in the window.

Purchase Order Processing Item Enquiry

Notice at the bottom it says processing. I assume that this window is trying to populate on another thread to keep it responsive and that thread is never returning the results?

Going to the GP process monitor in this example showed that it was clogged up with a posting process that was not budging.

Process Monitor

Once the user was cleared down, previous transaction level posting error dealt with and looked again, everything was working as expected.

I also have seen where doing this same thing but from a link I provide in another window, that calls the same enquiry window causes it to work. Weird! I can only think there might be two different methods being called, one with background and the other not? When I call it in my code I’m getting the foreground, when GP does it, it uses the background?

I’m guessing at all this, but thought it worth documenting the findings so far, I will come back to update this post if I find any root causes.

Visual Studio 2017 & Dynamics GP Addin Project Templates “install”

Now we have Visual Studio 2017 and again it is awesome! Drop what you are doing and start developing with it right now!

If you are a .NET Dynamics GP Addin developer you will find that the project templates are not available for Visual Studio 2017, at the time of writing this. See in the screen shot, only goes up to VS2015.


I wrote a post on how to install them into Visual studio 2015 a while back, when the previous version of GP did not support that VS2015, but that method cannot be used anymore for Visual Studio 2017. This is because of a new method of discovery that Visual Studio uses for project templates. This has been implemented by Microsoft for Visual Studio 2017, using manifest files to point to the project templates. I’m guessing this is part of making Visual Studio more quick and to perhaps work with marketplace better.

You will also notice that the install directory for Visual Studio has moved into a Visual Studio subdirectory, I guess that makes things tidy & makes sitting different versions together easier? My location for Enterprise project directories is now:
C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\Common7\IDE\ProjectTemplates

below you can see the .vstman manifest files that point to the templates.


The directory structure of the templates has changed a little too, having a 1033 or similar folder holding them and a another manifest file, “Windows.VSTDIR” above each of those folders.

To make things simple I have added a Visual Studio Extension into the Visual Studio Marketplace that addresses this problem, see here for details.

Finding build version number in Dynamics 365 for Financials

Use the search feature to locate the window by typing “information” into the search box:

Search for Dynamics 365 Financials about window

You need to open the “System information” window that holds the version number for Dynamics 365 for Financials.

System Information Window Dynamics 365 for Financials

The system information window clearly identifies the build number of Dynamics 365 for Financials currently running your tenant instance.


Hope this helped, if so leave a message, motivates me to blog more!

D365 Financials in the UK with VAT (Tax) registration lookup feature

The month of May 2017 has brought Microsoft Dynamics 365 Financials to the UK market, in preview. Maybe Microsoft saw my blog post from 2013 about enabling VAT lookup in Dynamics GP and applied the same method to NAV and now to D365F.


VAT Numbers

If we are registered for sales tax in the UK (or Europe) then a VAT registration number is issued, a number that our tax affairs then applied against. Other companies must be given that VAT number when trading with you. Each country has a different format for the VAT number, Gov.UK list them out here, EU country codes, VAT numbers and VAT in other languages.

When supplied with a VAT number from a customer, it is a good idea and your duty to check that the VAT number is valid. Luckily there is a webservice published by the EU for doing this, VIES. In that blog post of mine (and in production since then), I harness this webservice in Dynamics GP to validate VAT numbers coming into the system through integrations and also provide a VAT validation screen when changing debtor VAT numbers. D365F now lets us do something similar with the same source webservice.

VAT validation configuration for Dynamics 365 Financials

So where is it and how do we configure it for use?

In D365F go to: Setup & Extensions>> Service Connections>> EU VAT VAlidation Service Setup

In passing, notice how, at the time or writing this has a nice uppercase typo on the menu option for this option, “VAlidation”.

VAT Tax Registration Configuration Dynamics 365 Financials

The URL for the webservice is editable so long as the enabled check box is unchecked (default http://ec.europa.eu/taxation_customs/vies/services/checkVatService). I guess you could publish your own endpoint, so long as it mimicked the real one, or if the service moved it can be edited, or if you have a proxy address enter it here.

Click the Apply Default values button. Note that I think that the Tax Information Exchange System Setup button should really be disabled, it does nothing no matter what combination of clicking I do.

Check the “Enabled” checkbox.

Agree with the dialog that we are passing our customer info (VAT numbers) to VIES.

You are accessing a thrid-party website and service

Finally press the X on the window to exit, your changes will be saved automatically and the Service Connection will show as “Enabled” as shown below.

Service Connections

Let us see it in action

By creating a new customer let's see what enabling that feature has given us. I’m pretending to set up a customer as Amazon, that have a Luxembourg VAT number of "LU 26375245".

Under the Invoicing section of the customer window, use the “show more” link on the right to expand the fields to show everything useful (I don’t like all the "show mores" dotted around D365F). After clicking show more, you get the Tax Registration No. field revealed.

If I set the country on the address to GB and then try to enter the above VAT number it complains with a standard form validation that the country does not match the VAT number country. This is true if the format does not match the appropriate regular expression for that country set in the customer invoice address.


The entered Tax Registration number is not in agreement with teh format specified for the Country/Region Code

To clear the validation I found I had to empty the field, tab off then go back in with the correct value, feels a bit naff. If I change the country to LU and take out the space in the number then on tabbing off the Tax Registration No. field I get the usual two arrows "busy working" icon, a pause whilst the webservice is called, then the following dialog.

The Tax registration number is valid. Do you want to update the name and address?

Selecting Yes fills in the company name of the customer record for us, very nice!

Amazon Customer card with name inserted

If I were to enter an invalid VAT number for a non existent company, we get the following error…

We didn't find a match for this number. Verify that you entered the correct number.


So that is a useful feature tested, a feature that I understand the desktop NAV had and a feature I added to GP some time ago and is now also in D365F!

One last issue to point out is that the webservice does become unavailable on a regular basis- presumably when it gets over loaded or a member state's sub section of the service is down. Just bear that in mind if you encounter issues while testing, might not be you!


Let me know if you found this useful with a comment, motivates me to keep blogging...