From the Microsoft Dynamics GP Blogs: eConnect mystery; Receipt entry; Account structure; SQL Server backup tips

A selection of the latest insight from the Dynamics GP blogs:

• Dynamics GP GPConnNet ReturnCode 131074: One Possible Cause;
• Improve Receipt Entry with National Accounts for Receivables Management in Dynamics GP!;
• Reshuffling your Account Structure;
• Learning Dynamics GP SQL Server Backup

Dynamics GP GPConnNet ReturnCode 131074: One Possible Cause

On the Dynamics GP Land blog, Steve Endow tells us that recently a customer contacted him to say that an eConnect integration suddenly stopped working.

The customer had been using the integration for a few years without issue, but suddenly, it returned an error of "ExecuteNonQuery requires an open and available connection."

The error message is pretty straightforward - the integration was failing to get a connection to SQL Server, but we didn't know why.

It seemed the only change the client made was resetting the password for the GP user who was using the integration. Then recently while he working on a different eConnect integration, he saw the same problem. GPConnNet wasn't returning an open connection.

Ultimately, Endow discovered what had happened. You can read about it here.

Improve Receipt Entry with National Accounts for Receivables Management in Dynamics GP!

On the Encore blog, Oxana Pisareva explains users can take advantage of the National Accounts functionality in Dynamics GP to associate multiple customers that belong to one organization by linking a parent customer to related child customers in the National Accounts ...