Microsoft Dynamics GP - Dynamic Code Blocks

Uninstalling abandoned or orphan modules from Dynamics GP

Uninstalling abandoned or orphan modules from Dynamics GP database. Using product id and database object prefixes to identify objects to drop.

Microsoft Dynamics GP

Invalid object name 'WO010032'

Fixing [SQL Server]Invalid object name 'WO010032'. after removing the Dynamics GP Manufacturing Module

econnect

EConnectWebServiceException Invalid object name 'AAG20000'

Having renamed the entire Analytical Accounting database objects in the company database, using a script derived from KB915903 eConnect started immediately creating errors so I went to investigate. Invalid object Name AAG20000 Having opened up the eConnect scripts to see what was going on (taProcessAnalytics, taCreateSOPDistributions, taAnalkyticsDistribution among others), it

econnect

Is Microsoft Dynamics eConnect installed on a machine?

Is Microsoft Dynamics eConnect installed on a machine? How do we quickly check for eConnect installs on a machine?

Microsoft Dynamics GP Featured

An error has occurred in the script on this page Dynamics GP

Fix "An Error has occurred in the script on this page" error

Microsoft Dynamics GP

Dynamics GP Addins and Visual Studio 2022 error adding new form

The designer could not be shown for this file because none of the classes within it can be designed error Trying to use Visual studio 2022 or older and getting the error below from the windows form deisgner? -read on as Microsoft have changed the engine for the forms designer

Microsoft Dynamics GP

An Unknown Error Occurred sending mail in Dynamics GP with Office 365

Attempting to send email from Dynamics GP using multi factor authentication (MFA) results in an error, after selecting a user in the Office authentication window. An Unknown Error Occurred There is no explanation as to what the error actually was. In the case I was investigating some users could email

Microsoft Dynamics GP

Another user is editing this item–Dynamics GP error

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

Microsoft Dynamics GP

Dynamics GP–The Document is in use and could not be deleted, when attaching a document

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

Microsoft Dynamics GP

Dynamics GP Payables - A unique document number could not be found Please check setup

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

Microsoft Dynamics GP

Tasks to think about when migrating SQL server for Dynamics GP to a new server

After performing SQL migration I had this top level list of things I had to think about, so this is just a private list put here of things that you might need to think about when migrating from one SQL server to another. This is for my environment, if you

Microsoft Dynamics GP

Dynamics GP folder path incorrect when using Create Installation Package utility

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.

Microsoft Dynamics GP

Dynamics GP Install/upgrade failed SyCompanyImages

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

Microsoft Dynamics GP

Dynamics GP Smart List Export to Excel found a problem with content, repaired records

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

Microsoft Dynamics GP

Dynamics GP–syWindowDefaults cannot find the table SY01407

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

Microsoft Dynamics GP

Dynamics GP Focus trigger registration failed: taUpdateCosts after installing Shipping Notification Tool 2013 on GP18.4

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

Microsoft Dynamics GP

Deploying Dynamics GP Addin Using Visual Studio Menu Item

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

Microsoft Dynamics GP

Dynamics GP 2015 email–”Word experienced an error trying to open the file error sending email” when using Word Templates

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

Docker

Dynamics GP Web Client is not compatible with Docker due to the Session Central Service not starting

Dynamics GP running in Docker Container Failed Back in 2017 I attended NAVTechDays and after seeing the benefits the Dynamics NAV community were getting from Docker containers with NAV, I could see similar benefits for Dynamics GP and was also seeing interest in some of the conversations going on out

Microsoft Dynamics GP

Dynamics GP VAT rate change and how to deal with it

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

Microsoft Dynamics GP

Dynamics GP will not remove hold or why timestamp format in GP matters

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

Microsoft Dynamics GP

SQL indexed views are incompatible with Dynamics GP

Indexed views with Dynamics GP? – well I’ve been there and I have seen others attempt the same. The Dynamics GP database and application are not really compatible with SQL indexed views. To help out those searching around this subject I thought I should write up our experience. What is

Microsoft Dynamics GP

Find orphan note records in a Dynamics GP company database

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

Microsoft Dynamics GP

Rebuild QTYONORDER of IV00102 Dynamics GP

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

SQL Server

Yes you can - SQL Server Table Compression and Dynamics GP

Today I attended SqlBits in Manchester UK, where there was a session “Performance tuning SQL server on crappy hardware” by Monica Rathbun. Monica has a the fast and punchy presentation style I enjoyed. Although I had already experienced or knew most of what was covered it was still a good