Microsoft Dynamics GP

Currency values that wouldn't convert in collection management main window

A mystery solved with why collections management was displaying different values between users.

Multiple rows in IV10200 for one receipt line - inventory cost layers in Dynamics GP

Explaining how inventory cost layers work for multi-currency purchasing transactions in Dynamics GP

Microsoft Dynamics GP

Open operation on table WDC_Field_Security_Tag_TEMP failed - Dynamics GP

Solutions to solve Open operation on table WDC_Field_Security_Tag_TEMP failed

Microsoft Dynamics GP

Knights of GP

Pull on your leathers and fire up the engine — the Knights of GP are riding out to keep Dynamics GP alive beyond Microsoft’s 2031 cutoff, uniting customers, partners, and ISVs to fund updates and support that keep GP running strong long after its official sunset.

Microsoft Dynamics GP

Dynamics GP RMA_Status

RMA_Status Codes uncovered for Dynamics GP

Microsoft Dynamics GP

Memory bloat in Dynamics GP AddIn

MacroManager in GP Addin holds onto DexUIForms

Microsoft Dynamics GP

Adding a field from a custom table to Dynamics GP report and word template using C#

Extending GP reports using calculated fields and RW functions lets you return custom data (e.g. from SQL or an API) without alternate reports. Use caching to avoid per-line queries for better performance. Word templates need remapping to include new fields.

Microsoft Dynamics GP

"RMA Line is edited by user" locked RMA record in Dynamics GP

Post an RMA receipt in GP’s RMA Receiving window, GP locks the RMA Entry/Edit, even after logout. Only the same user clearing it via RMA Entry can unlock it. This bottlenecks separated warehouse/service workflows.

Microsoft Dynamics GP

Handling SOP Document Number Chaos: A Dynamic SQL Solution

When the sales document numbering in Dynamics GP went off track, I used dynamic SQL and eConnect to renumber 20 orders across 120 tables. This post details the problem, solution, and includes a helpful SQL script for correcting document numbers efficiently.

Microsoft Dynamics GP

Negative invoice Quantity on converting sales order to invoice Dynamics GP

Solving why the sales order created a negative invoice quantity in Dynamics GP.

Microsoft Dynamics GP

Finally Dynamics GP add-in development with Visual Studio 2022

You must use version VS 2022 17.9.0 Preview 2 or newer to edit Windows or Dynamics GP forms in the forms designer of Visual Studio.

econnect

eConnect Error 9370- You are passing a Currency ID in the header and you did not pass the same one to the line

Problem updating sales order with blank lines in Dynamics GP using eConnect Existing blank empty lines on Dynamics GP sales orders cause a problem when updating orders using eConnect. Bank rows are ones where there is no item in the item number field. If no item number is entered, the

Microsoft Dynamics GP

SQL filtered index are incompatible with Dynamics GP

Microsoft Dynamics GP

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 tldr; To edit windows/dynamics gp forms in 32 bit mode for Dynamics GP Add-ins using Visual Studio 2022, you must use the following version or newer: VS 2022 17.

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.