You can’t delete an item because another user is editing this item message pops up. This is due to a lock in the SY_ResourceActivity table (DYNAMICS..SY00801). Check the table for the item number in RSRCID field, you can list all the records locked in the system with

Document attach open documents When using document attach in Dynamics GP from Version 2016, it is not possible to attach a document if that document is open in another application. If a user has a document open and then attempts to attach it, the error is: The document is in

Payment run failed after GP upgrade On upgrading to GP: Version 18.4.1361 (2021) everything worked great except for making EFT payments. On printing the EFT payments, the following error popped up. A unique document number could not be found. Please check setup. Although it could be clicked through

Application folder for Dynamics GP moved The default installation package location moved for the Dynamics GP application to C:\Program Files (x86)\Microsoft Dynamics\GP for releases after GP2018. Previously it was in C:\Program Files (x86)\Microsoft Dynamics\GP2018, where the GP2018 was replaced with the version of GP.

SyCompanyImages Interesting issue with upgrading Microsoft Dynamics GP. The upgrade stopped at the above step Microsoft Dynamics GP Utilities install/upgrade failed syCompanyImages Turns out this was linked to deleting companies from this instance of GP, and the delete leaving orphaned records in the DYNAMICS..SyCompanyImages table. The syComanyImages table

After moving to from Office 13 to 365 the following error appears when users export from Dynamics GP smart lists to Excel. We found a problem with some content in 202222-1232S9.XISX. Do you want us to try to recover as much as we can? If you trust the source

After upgrading a Dynamics GP system from GP2015 => GP2016 => GP(18.4) the following error occurred on opening some enquiry windows in GP; A get/change operation on table ‘syWindowDefaults’ cannot find the table. Invalid object name ‘SY01407’ The above window is used for the “The Default Inquiry Sort options

After installing the Shipping Notification Tool on Dynamics GP 18.4 the error “Focus trigger registration failed: taUpdateCosts” is shown after launching Dynamics GP. I guess some Dexterity changes were made to the forms that the tool is plugging into, causing the Dex trigger to fail like this. Luckily Harry

Deploy Dynamics GP locally using Visual Studio hot key I demonstrated this technique in one of the sessions I presented on GP development at the 2016 Tampa GPUG conference, but never got around to writing about it. Often when developing Dynamics GP Addins, you may wish to deploy the current

When attempting to send a document that utilises word templates, even using PDF format, the following error may occur, due to a tightening in security with in the Microsoft Office product, “Word experienced an error trying to open the file”. Information about this issue can be found here: Word Templates

8th July 2020 and the UK government have announced that temporary reduction of VAT rate from 20% to 5% for hospitality sector (on food, accommodation and attractions), from 15th July until 12 January 2021. This gives you only one week to get advice from your ERP support on how to

If Dynamics GP will not let a SOP module, transaction process hold be removed in the user interface, it may be due to formatting of time stamps. Check no integrating applications have created that hold incorrectly. The issue is that GP is real fussy about formats of timestamps, one place

About the Dynamics GP Notes table Notes are held within the SY03900 company table in Dynamics GP. Every note in that notes table has a NOTEINDX, which is used by other tables in GP to reference that note. This makes the notes system extensible, when new modules/addins are created

I had to rebuild the quantity on purchase order of the inventory site qtys table today (On Order in Item Enquiry). Wrote this SQL script that works for our install with our settings, but you should verify your install does not have other modules or modifications that may make this

In previous blog posts we have talked about the way that other applications can drill down into parts of GP by using an direct approach via a pluggable protocol handler that is installed when GP is installed. Sometimes this does not work, to debug if the protocol handler has an

If you are using Dynamics GP with Visual Studio 2017 –>  , you will find that the project templates for Dynamics GP do not show up in the new project or new item menus. I wrote a solution to this in the form of a Visual Studio extension, but it seems that

I’ve never written this up before, but is a useful technique I use to allow the deployment of GP from the current project active build directory to the application addins folder. Note that in this example PowerShell script, it will empty the addins folder before deploy. This may not