Microsoft Dynamics GP

A collection of 250 posts

Microsoft Dynamics GP

Dynamics GP Font Size

Increasing font size for GP users with poor eyesight Today one of my co-workers from the infrastructure team asked me to include a “magic file” into our standard GP deployment. The file is activated via a registry key on the user’s machine and provides them with a bigger

Microsoft Dynamics GP

Microsoft Dynamics GP–United Kingdom, Making Tax Digital (VAT) for business MTD / MTSfb

Update 23rd April 2019 April 2019 Hotfix for Dynamics GP - Making Tax Digital. Microsoft have released a bug fix to the error: You may incorrectly receive an error  in VAT Daybook Obligation period dates do not match with the VAT Daybook Calendar. This occurs when logged in as the user

Microsoft Dynamics GP

Setting multi-line text box control in a Microsoft Dynamics GP add-in to be empty or blank

When working with multi-line text boxes (Text Tool), rather than single line edit boxes, it is easy to introduce a bug to your application. The text box contents can be set with the the example code below: ItemMaint.LocalTxtExtraInfo.Value = result.ExtraInfoDescription …where the value of the right hand

Microsoft Dynamics GP

Dynamics GP basic pricing export to Excel with crosstab SQL

The following SQL table function allows exporting of GP prices into Excel. Assumes max of 6 price breaks, but can be expanded. Usage: SELECT * FROM [Extract_PricesCrosstabTable_Fast] ('GBP','TRADE','%') ORDER BY ITEMNMBR -- ============================================= -- Author: Tim Wappat -- Create date: 2010-08-02 -- Description: Function to

Microsoft Dynamics GP

A coutrecords operation on table ‘[Not Found]’ cannot find the table–Dynamics GP

Symptom: User experiencing this error dialog when using navigation lists, but can happen in other areas of Dynamics GP Cause and solutions: This error is caused by the client machine that is running Dynamics GP loosing network connection at some point during the Dynamics GP session. Dynamics GP holds some

Microsoft Dynamics GP

Silent install of Microsoft Dynamics GP eConnect

I needed to do a silent install of eConnect for Dynamics GP but couldn’t find the documentation on how to do it, I figured it out and document it here for future reference: The eConnect installer is found in the additional products folder of the installer image/disk. \MDGP2016_

Microsoft Dynamics GP

Retail Microsoft Dynamics GP Point of Sale Systems (POS)

What retail point of sale (POS), retail store, till Systems are compatible with and also work well with Microsoft Dynamics GP? On my investigation, the market seems to be sparse with only a few products out there: Compass POS- seems to get the most praise and most mentions Salespad POS

General Technology Interest

Enterprise Microsoft Dynamics consultants and developers should sit up and pay attention to Microsoft Graph, a briefing

If you are involved in business software then Microsoft Graph is a really big deal, so sit up and pay attention! Graph is quickly becoming the all pervasive API for access/control of the Microsoft cloud products and services. This is going to encompass Azure AD, Excel, Outlook, OneDrive, OneNote,

Microsoft Dynamics GP

Service Unavailable (HTTP Error 503) Server Error in ‘/lus’ Application–Dynamics GP

Recently user home pages have been showing a few different error messages under the “connect widget” area of the home page. The connect widget is considered by some as a waste of bandwidth and is disabled for all users, to others it is a useful source feed of news and

Microsoft Dynamics GP

Dynamics GP drill down logging to trace file for diagnosing problems

In a previous posts I’ve looked that protocol handler used to create the drill down features in reports and other applications used with Dynamics GP. Asynchronous pluggable Protocol Handler for Dynamics GP (for drilldown/drillback) Dynamics GP Drill Down Protocol Handler error -in those posts, I investigated the debug

Microsoft Dynamics GP

Dynamics GP, Item description is one hundred character capacity?

A little curiosity of mine is around this finding & why it is so… Fill the item description field of an item in dynamics GP and then paste the text into a notepad application to measure its length. You will find it has a capacity of one hundred characters… Yet

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

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

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

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

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