Microsoft Dynamics GP Why does Dynamics GP use Table Heaps (no clustered indexes)? First we should define what a table heap is. A heap is a table without a clustered index. Data is stored in the heap without specifying an order. Usually data is initially stored in the order in which is the rows are inserted into the table, but the Database Engine
Microsoft Dynamics GP Finding a rogue “dll” causing trouble with “different version of the same dependent assembly” In Dynamics GP development, we have lots of .dll files around arising from support for many version releases of GP. These files litter our projects and sometimes a dll may go astray and cause trouble by ending up in a folder to which it should not belong. This powershell command
Excel changing link paths when opened from UNC vs Mapped Drive Behaviour of links in excel is described in this good document. Description of link management and storage in Excel Looking at an excel cell when document opened via UNC path vs Looking at excel cell when document opened via mapped drive path: =+VLOOKUP(C10,'\\domain.net\folds\USERS\design\
Microsoft Dynamics GP Dynamics GP next sales order number is corrupted as has become the same as the next quote number range This problem happened today, first time for a few years, but it used to happen regularly (every few months). The issue is that the auto populated sales order number in sales transaction entry gets overwritten with the number from the quotation number range. My guess for the circumstances of this
Microsoft Dynamics GP Dynamics GP - Manual Payment does not generate next cheque/check number or document number Manual Payment empty document number, not defaulted When making a manual payment normally, after selecting the payee, the cheque book attached to that payee is queried for its next cheque number, that is then auto populated into the “Document No” field shown. During month end we found all of a
Microsoft Dynamics GP Correct reconcile Dynamics GP SOP batch totals and transaction counts without SQL Sometimes batch totals and transaction counts get corrupted in GP, there can be many reasons behind this. To correct them the check links maintenance routine can be executed for “Sales Work”. This will correct the batch totals but will take a very long time to run and is not the
Microsoft Dynamics GP Dynamics GP - SQL script to revert multiple bins into single bins So you want to turn off multiple binning in Dynamics GP and need to record the multiple bin where the stock is held back into the basic single bin field against each location? This script I just used to do that, it will pick the multiple bin with the most
Dynamics 365 Financials Naming confusion may be compounded by Enterprise and Business names for Dynamics products We almost settle on one set of names for the realigned Dynamics ERP and CRM products when another set of product names seem to be upon us. As Steve Endow points out, the CRM community seem to have claimed the “Dynamics 365” moniker for themselves (just see all the twitter
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
