#GPPT Fixed Issue with Integration Manager Standard Adapters failing

David Meego - Click for blog homepageThis article is an informational post to help anyone who might have come across this issue with Integration Manager and is searching online for a solution.

The issue is Integration Manager only imports a few transactions before failing when using the Standard Adapters for some integrations.

One possible cause for this issue was fixed many months ago in GP Power Tools code, but as not all sites keep up to date with their software, it might still be occurring. A recent support case for this issue is the reason for publishing this article.

Continue reading

Working with Dates in Integration Manager VBScript

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Today I worked with my colleague Rob on an Integration Manager for Microsoft Dynamics GP issue.

We had a customer who was importing some General Ledger journals into their system and wished for the journals to be set up as reversing journals with the Reversing Date set up as the first date of the next month. The plan was to use the following script to manipulate the Transaction Date to create the Reversing Date.
Continue reading

Integration Manager Customer Address Update does not generate an error and does not update

Dawn Langlie - Click for blog homepageThis is a reposting of an article Dawn Langlie originally wrote on my Developing for Dynamics GP blog.

I worked on a Integration Manager 2010 case recently for a Customer update integration.  We ran across an issue when the customer you are updating has the Send Email Statement box marked in the Customer Maintenance Option window.  I also had the previous Customer’s address getting updated with the information from the Customer that had the Send Email Statements marked.

Continue reading

Fixed Asset Integration error: “String was not recognized as a valid DateTime”

Dawn Langlie - Click for blog homepageThis is a reposting of an article Dawn Langlie originally wrote on my Developing for Dynamics GP blog.

I recently had a support case, running a Fixed Asset integration with Integration Manager, where we received the following error:

DOC 1 ERROR: System.FormatException: String was not recognized as a valid DateTime.

at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.DateTime.Parse(String s, IFormatProvider provider)
at System.Convert.ToDateTime(String value, IFormatProvider provider)
at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider)
at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType)

Continue reading

Copying Record Notes and OLE Attachments between Companies

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Following on from last week’s post on OLE Attachments and Record Notes, I can now get to the reason for the interest in notes and OLE attachments.

The partner was trying to copy master records for Vendors from one company to a new company.  They wanted to use SmartList to export the Vendor data out of the source company and then use Integration Manager to bring the data into the target company.  The problem was how to handle the record notes that may be attached and how to handle the OLE attachments if they existed.

Continue reading

Using Integration Manager with Analytical Accounting

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

When you use Integration Manager on a system with Analytical Accounting (AA) installed, integrations often fail because Analytical Accounting will open windows which are unhandled by Integration Manager. However, there are time when you still want to use Integration Manager to import transactions where the Analytical Accounting information is left blank. This post provides three methods of how to make Integration Manager work when Analytical Accounting is installed.

Continue reading

Where are Dynamics GP’s Business Rules Defined and Enforced?

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

In a recent forum post, the question of where the business logic for Dynamics GP resides was raised.  This is an excellent question which, sadly, does not have a simple answer.

Continue reading

Why does Microsoft Dynamics GP encrypt passwords?

David Meego - Click for blog homepageThis is a reposting of an article I originally wrote on my Developing for Dynamics GP blog.

Why doesn’t the password I use for Microsoft Dynamics GP work for me to access the data in SQL from <insert application name here>?

Why does my password sometimes fail to work from one workstation when it works from another?

Why does the password policy feature only allow one failed attempt before locking me out?

Why is the User ID case sensitive on Microsoft Dynamics GP v10.00?

What is the Password field in the SY_Users_MSTR (SY01400) table used for?

Can I use my Windows or Active Directory Login to access Microsoft Dynamics GP?

I hope to answer all these questions and more by explaining the password encryption that is used by Microsoft Dynamics GP for all users except ‘sa’.

Continue reading