VBA for Integration Manager to Insert Vendor EFT Bank And Email Addresses

Microsoft Dynamics GPI did a SQL Script back in October 2014 which allowed Vendor EFT Details to be inserted, but, if the client is going to run it themselves, requires the assistance of the IT Department as end users don’t usually have access to SQL Server Management Studio.

For most clients, this hasn’t usually been a problem, but a number of the clients I have worked with recently have had multiple projects on the go at the same time. This has meant that while an IT representative can be available, it isn;t usually very timely and can delay UAT.

As such, I wrote some VBA script for Integration Manager which inserts both the Vendor Email and EFT Details. Continue reading “VBA for Integration Manager to Insert Vendor EFT Bank And Email Addresses”

Integration Manager: “Argument ‘Start’ must be greater than zero”

Microsoft Dynamics GPA client doing some work with Integration Manager 10 recently reported the following error when trying to load the VB Script Editor;

Integration Manager - Argument

Continue reading “Integration Manager: “Argument ‘Start’ must be greater than zero””