Dynamics 365 Financials Uppercase in computer records–please no! From time to time you encounter systems where the company style is to capitalise names in the system. I know of users who might as well glue the caps-lock on! If faced with the, we have always done it this way problem, fight it. Excuses come out like its for
Microsoft Dynamics GP 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. Notice at the bottom it says processing. I assume that this
Microsoft Dynamics GP 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
Dynamics 365 Financials Finding build version number in Dynamics 365 for Financials How to find version of Microsoft Business Central Use the search feature to locate the window by typing “information” into the search box: You need to open the “System information” window that holds the version number for Dynamics 365 for Financials. The system information window clearly identifies the build number
Dynamics 365 Financials D365 Financials in the UK with VAT (Tax) registration lookup feature Business Central VAT registration lookup 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
Microsoft Dynamics GP Bad Power Value from searching on master number in sales transaction smartlist–Dynamics GP Searching on the Master Number field in the normal Sales Transactions smart list in Dynamics GP can cause an error to occur. In the following screenshot you can see the search, nothing odd there? However on executing the search the following error occurs: Unhandled script exception: Bad power value EXCEPTION_
Microsoft Dynamics GP Could not load file or assembly Microsoft.Dexterity.Bridge.dll or one of its dependencies – Dynamics GP When developing Dynamics GP addins, the above error can occur for a number of reasons. It generally means what it says, the referenced assembly is looking for a resource it can’t find on the available search locations. If this is encountered whist developing a Dynamics GP addin while attempting
Microsoft Dynamics GP Fabrikam Day 12th April 2017 Around the world people are posting photos of local landmarks and a #FabrikamDay banner, just for fun and to celebrate a sense of community around our product, Microsoft Dynamics GP. Here is my contribution in front of The Angel of the North The date is a random date that was
Microsoft Dynamics GP VST Controls®™ for Dynamics GP Visual Studio Tools development I’m so glad the day has finally arrived where I can talk about this innovation, I think this is one of the coolest things in .NET development with Dynamics GP for some time. I have been restless to give it a go since I was first told about it.
Microsoft Dynamics GP Screwed Allocations in Dynamics GP Dynamics GP SOP Entry causing dodgy site allocations This is purely and observational post of a phenomenon we see in GP from time to time. The telesales team perform data entry in the SOP screens at a lightening pace, tabbing through windows, hammering information into the screens very quickly while
Microsoft Dynamics GP Dynamics GP Stored procedure [smFormatStringsForExecs] You’ve seen it often enough in GP stored procedures, but what is it doing? EXEC @iStatus = smFormatStringsForExecs @I_vInputString = @I_charEndCustomer, @O_cOutputString = @cEndCustomer OUTPUT, @O_iErrorState = @O_iErrorState OUTPUT The above code snippet is the common code pattern it appears in. I had always assumed, until today that
Microsoft Dynamics GP Dynamics GP eConnect and handling exceptions under Web API Beware when using eConnect with ASP.NET Web API. … as exceptions raised by eConnect will not be of type eConnect.Exception thus using our normal typical catch block, such as: catch(eConnectException ex) will not work, because all eConnectExceptions will actually cause the following exception to be raised/returned: System.
Microsoft Dynamics GP Exporting from SmartList Dynamics GP “returned 29” Are you experiencing a dialog box with the following text on attempting to export a Smartlist to Excel? “RUN APPLICATION ERROR” "C:\Users\user\AppData\Local\Temp\7\somefilename.xlsx returned 29" This seems to be an error passed back from Excel regarding permissions issues, or lack of
Microsoft Dynamics GP FP: Couldn’t close table! Dynamics GP Error Solution I talked before in a previous blog post about the “syContentPageXMLCache cannot find table” error. This and its cousin the “FP: Couldn’t close table!” error are caused when something disrupts Dynamics GP’s long lived open SQL connections between the client and server. This might be due to networking
Create ASP.NET virtual directories in IIS Express using windows credentials to another server (website project) I had this problem to solve and thought I’d document my solution here, as I didn’t find anything appropriate documented when I tried searching the search engines. Website Project vs Website Application Project There are two broad ways ASP.NET websites can be setup as applications. * Web site
Convert ASP.NET “Website Project” from IIS to IIS Express I had this problem to solve and thought I’d document my solution here, as I didn’t find anything appropriate documented when I tried searching the search engines. Website Project vs Website Application Project There are two broad ways ASP.NET websites can be setup as applications. * Web site
Microsoft Dynamics GP What do you call that window GP? Steve Endow mentioned on twitter the other day about the naming of objects in GP when programming. The inconstancies are astounding, I have to agree, you can spend half an hour trying to determine if the object named something almost like what you want is actually the object you want
Microsoft Dynamics GP Installing Dynamics GP Intrastat Module If you are looking for the Intrastat module, it is part of the Main GP install, I think fromGP2013 when more of the product extras were bundled in - but certainly from GP 2015. When running the GP installer the various features that can be installed are offered in the
Microsoft Dynamics GP SQL to extract contiguous ranges for maintenance tasks in Dynamics GP From time to time I find some SQL that really makes me smile and sit back and stare at it with awe. Today is one of those days, let me show you… Many of the maintenance windows in Dynamics GP ask for ranges of numbers to be entered. They consist
Microsoft Dynamics GP Error: This document contains one or more posting holds, Dynamics GP Edit List If you are experiencing this on SOP Sales Invoice posting edit lists, then maybe you are using drop ship items. Also perhaps you have the Shipping Notification Tool installed? There is no posting hold as such on the document, the posting hold mechanism is being hijacked by the shipping tool
Microsoft Dynamics GP Empty Matched To Shipment in Purchasing Invoice Entry of Dynamics GP About from time to time on Euro transactions we get a yellow triangle and empty “Matched to Shipment” field in the Purchasing Invoice Entry window of GP. The problem is always the same, the fields * CURNCYID * CURRNIDX * XCHGRATE * RATECALC Are all either default or missing for the item row in
Microsoft Dynamics GP OLE Notes Migration It was time to get our old OLE notes migrated. GP has stopped using OLE notes containers for attachments to notes in the system, mostly due to the need to work with the web browser hosting of GP. I didn’t want to import the attachments back into the new
SQL Server SSMS SQL Hazard Let me point out a hazard using SSMS, when developing a SQL delete query, especially more complex ones that take time to build up. I also think about some of the ways I work and how they minimise the chances of damage to data. Let us say we are developing
Microsoft Dynamics GP Disable Enhanced Intrastat Dynamics GP I have fallen out of friends with the GP Intrastat module, it has caused me problems with side effects in different parts of GP over the years. After another such incident, I decided it had to go, but I found it was not so obvious how to switch it off…
Microsoft Dynamics GP Writing off stock from Qty In Service from Dynamics GP using SQL I have 9,791 items with QTY in service >0 that I want to "adjust" out of stock. All these items have been financially accounted for, written off over the years, the IV account manually cleared by journal each month. However the items have been left in
