Working with Dates in Integration Manager VBScript

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…

3

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

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…

3

Procedure or function ‘aagCreateGLWorkDist’ expects parameter ‘@LedgerID’, which was not supplied

A number of support cases have popped up recently with this error message, it can occur when using eConnect to integrate General Ledger transactions or when using the eConnect Adaptor for General Ledger transactions from Integration Manager. Vaidy Mohan has some details in his post: GL With AA – IM2010 Integration – aagCreateGLWorkDist Error Message. The LedgerID…

0

More Microsoft Dynamics GP 10.0 Service Pack 5 releases

Last month, we released Microsoft Dynamics GP 10.0 Service Pack 5. Since then many other components of the Microsoft Dynamics GP suite have had Service Pack 5 releases. This includes the Dexterity Development Environment build 10.00.0331. Check out the links below:   PartnerSource Feature Pack 1 DVD with SP5: Product Release Downloads for Microsoft Dynamics GP…

2

Microsoft Dynamics GP 10.0 Service Pack 5

Great News. The long awaited Microsoft Dynamics GP 10.0 Service Pack 5 for English Installations is now available!!  [Edit] This Service Pack brings SQL Server 2008 R2 compatibility to Microsoft Dynamics GP 10.0. Please make sure you read all the hot topics and notes BEFORE installing, especially this new FAQ which explains some important changes:…

9

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

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…

0

Copying Record Notes and OLE Attachments between Companies

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…

3

Dexterity and Other Tools for v10.00 SP4 now available

If you have not found it already, the Service Pack 4 update for Dexterity version 10.0 (build 10.00.0324) is now available for download. Please download and use it when developing Dexterity code which is meant to run on a Service Pack 4 system. Note: You will need to uninstall your previous version 10.0 installation of…

3

Using Integration Manager with Analytical Accounting

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…

10

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

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. When Great Plains Dynamics was first developed for the Ctree and Btrieve ISAM (flat file) databases, there was little demand for external integration.  The…

4

Integration Manager for Microsoft Dynamics GP 9.0 Fixed Asset Book integration error.

This post contains information about an error you receive when you use the Fixed Asset Book destination in Integration Manager for Microsoft Dynamics GP.  Integration Manager for Microsoft Dynamics GP 9.0 Fixed Asset Book integration error: DOC 1 ERROR: CORPORATE Book: If Depreciated to Date is later than Place in Service Date, LTD Depreciation must be…

0

Upcoming Microsoft Dynamics GP Workshops

There are two Microsoft Dynamics GP workshops that have been scheduled to take place in Fargo, ND, USA the first week of June.  We will be offering this workshop to both Partners and Deluxe/Premier Customers.  The instructors for these workshops will be Dave Clauson for the Integration Manager workshop and Beth Gardner for eConnect workshop.  Both Dave…


Tools Sessions at Convergence 2009

If you are going to Convergence 2009 in New Orleans between the 10th and 13th of March 2009, make sure you attend the various sessions about the Microsoft Dynamics GP development and customization tools. Below are the details of the sessions:  GP04 Building Personalized Solutions using Modifier with VBA for Microsoft Dynamics GP Beth Gardner Explore…

3

Integration Manager product suggestions, please vote!

In order to get any new features added into our products, we need to have votes cast.  This gives the Program Managers an idea if there really is need for certain features to be added. I have added the following items for Integration Manager.  Please vote on the ones you find important. GP- Add the…

10

Statement of Direction for Microsoft Dynamics GP

You might have seen some other posts around that the updated Statement of Direction for Microsoft Dynamics GP documentation has been posted on PartnerSource and CustomerSource.  Some points of interest for the developer community are listed below: The Microsoft Dynamics GP 10.0 Feature Pack shipped in June 2008 contains the following: Feature Description XML Source Adapter…

7

Why does Microsoft Dynamics GP encrypt passwords?

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?…

44

Developer Toolkit Articles & Links

This is a page to provide links to Developer Toolkit and Integration Manager related articles and materials. The Developer Toolkit contains: Visual Studio Tools for Microsoft Dynamics GP eConnect Web Services Using Visual Basic and Visual C# for its languages.   Knowledge Base (KB) Articles  How to upgrade applications to use the GPConn.dll file or…

2