DynDeveloper.com - Your Dynamics GP Questions, Answered

	SOP Scripts
	eConnect
	taSopDeleteDocumentWrapper
	taSopLineDeleteWrapper
	taSOPLineIvcInsert Wrapper
	taSopLineIvcInsertComponent
	taSOPLotAuto - complete procedure
	Functions
	ddf_Address
	ddf_AllHoldsOnASOPDoc
	General
	Getting Email addresses from Dynamics GP
	Move a SOP transaction from open to history
	Posting Sequences
	SOP40200 'Allow' fields query
	sopGetIDNumber
	sopTrxDeleteWork
	Unvoid a SOP document
	Stored Procedures
	dd_SOP10102_UPD
	dd_SOPGetNextDocNumber/ sopGetIDNumber.
	dd_SOPPayment_INS
	dd_SOPRound - Round a SOP Multicurrency document to two decimal places
	dd_SOPTotal
	dd_SOPTotalTaxes
	dd_taSopVoidDocumentWrapper

Archives

Controlling RadGrid column width and visibility with @media

It is almost mandatory these days to design for multiple device widths.

Telerik as it's RapPageLayout... but honestly, it's pretty simple to use @media to control things. For example, make this site wider and narrower and watch the side columns disappear and reappear.

Below we show you this technique for the ASP.NET RadGrid

Trouble with ODBC connections to a Dynamics GP SQL Server

Several times in the past I've been involved in a struggle to connect from a term serv box to the SQL Server box with ODBC, you get the TEST CONNECTION FAILED message and not a lot of help. It takes hours or days to get a resolution and by the end of it I'm tired and I don't blog the result.

The article below is the resolution of one of these struggles. It is likely not the only issue but as GP ages and newer hardware and OSs come along we'll need more hacks to keep it going.

Assistance Needed: Error Accessing SQL Data in GP 2018 After Server Downtime

Can you help me with the error that appears on the screen when entering GP 2018? 'An operation to get or change first in table 'PM_SETP' failed to access SQL data.' The server was turned off for a day, and this error appeared afterward. No work was done on it.

Inquiry on Compatibility between Microsoft Dynamics GP and Office 365 for Account Statements

I appreciate your support and assistance in resolving this issue.

Approximately 20 years ago, we implemented Microsoft Dynamics GP to manage our accounting and financial processes. We started with version GP10, which at that time allowed us to send customer account statements via email using Microsoft Outlook as the email client, specifically with Outlook 2007.

Over time, we migrated our email platform to Office 365, which presented compatibility challenges. To maintain the email functionality from GP10, we dedicated a computer to run Office 2007 exclusively, as the system couldn’t correctly recognize the Outlook configuration file in newer versions.

In 2021, we updated to Microsoft Dynamics GP version 2018, expecting better integration with Office 365. However, compatibility remained limited, so we continued using a machine with Office 2007 to retain the ability to send emails from GP2018 through Outlook.

Inquiry:

We would like to understand the available options to resolve this situation, specifically:

1. Is there an update or configuration that allows GP 2018 to work directly with the Office 365 setup without depending on an older version of Outlook?

2. Is it possible to configure a compatible Outlook version that works with GP 2018 and Office 365 without requiring a dedicated machine with Office 2007?

3. What options or recommendations do you suggest to improve compatibility and reduce reliance on outdated Outlook versions?

We thank you in advance for your support and guidance on this matter. Any suggestions or references to technical documentation would be greatly appreciated.

GP RM20101 and SOP30200/30300 Posting Process

Okay -

I'm looking for another opinion. I'm working with a software company that provides a cloud-based AR Collection solution.

We're having a data synchronization issue which has resulted in differing opinions for root cause.

The synchronization issue can be best described as follows:

1. GP End user posts a SOP Batch of 150 Invoices @ 10am in the morning.

2. The 3rd party has a synchronization that takes RM data and SOP data (typically every 2 hours) from my SQL server to their cloud-based server.

3. When a new Invoice is created in their system (defined as a new Invoice document in the RM20101 table) - it sends an email to our customer with the Invoice.

4. In some cases, (actually a lot of cases) the customer gets an invoice with no line item details (taken from SOP30300 Table).

The third party is trying to tell me that GP data as it comes in to them is not synched - that they are getting RM20101 records with no records in SOP30300 and that somehow the problem is on my end not theirs. Part of the problem for certain is the triggering event for an invoice to send an email is a new invoice record in RM20101 (not SOP30200). having said that - GP posts/inserts records simultaneously.

Anybody has an experience where this type of data synchronization problem occurred?