Dynamic Code Blocks

AI

Technology Adoption Lifecycle & "Crossing the Chasm" with AI in 2024

How come customers and product are at a disconnect?

Security

Security expert, Steve Endow on keeping Email addresses themselves secure

Keep blogs updated and your readers will love you more, get more visits too.

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.

SQL Server

SSMS Activity Monitor Pausing and Processor Time greyed out disabled

Fix to SSMS Activity Monitor pausing.

SQL Server

Add QR code to Reporting Services(SSRS) report for free without using the Global Assembly Cache (GAC)

SQL Server

SSRS scheduling error creating a report schedule (timeout or low disk)

Fix to timeout or low disk error when scheduling reports

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

Find async methods that are not named Aync

Using regular expression search to find missed async suffixes to async methods in Visual Studio

TalkMobile SIM with Vodafone Mobile WiFi R219h access point

Go into mobile broadband Go into connection Set to custom type APN field enter: talkmobile.co.uk then click save The status screen will show "Connecting" then "Connected"

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

.NET Development

UPS API download OpenAPI json file

Download json files location for UPS OpenAPI

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

Impossible to delete Thumbs.db on network folder

"thumbs.db" is a hidden file used by the windows explorer, to cache the directory information in order to make windows explorer display folders more quickly. It regularly "gets in the way" when trying to remove a directory, with the operating system thinking it is locked

Next purchase order number jumping or wrong

Dynamics GP next PO number is wrong When a user types a purchase order number, that has not been used before, into the purchase order entry screen of Microsoft Dynamics GP, then exit the screen. GP will attempt to put that incorrect number back into the next number field in

ERP HEADtoHEAD by Lumenia

Choosing a new ERP solution for a company may be one of the larger investments a company will make, both financially and through investment of time and resources. Lumenia Consulting run an annual event, HEADtoHEAD™ that I was able to attended. At the event, a selection of big name ERP

Migrating from BlogEngine.NET to Ghost

Outdated and time to change I've been running by Blog using BlogEngine for well over a decade. It is no longer supported and is suffering with various security issues and lack of support for modern consumption of content, like mobile. It was time to move on a long

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