SQL Script To Insert Creditor Bank Details From CSV

Microsoft Dynamics GPIntegration Manager is a very good tool, but it doesn’t allow the import of all record types into Microsoft Dynamics GP. One of the main types of record I need to import when implementing a new client is the Creditor (Vendor to the American readers) EFT details.

While the EFT data is stored in one table and can therefore be imported using Table Import, I find that configuring Table Import for each client is a bit of a annoyance, so I developed a SQL Script a while ago which I figured I might as well post here for easy access.

As always when using SQL to update tables in Microsoft Dynamics GP, make sure you have a good backup of the database before you begin and check the imported data afterwards. Read on for the script…

Continue reading

MDGP 2015 Feature of the Day: Employee Paystubs

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The seventeenth Feature of the Day is Employee Paystubs. In Microsoft Dynamics GP2015 employees can now view or print their own paystubs.

With Employee Self Service Paystubs, the user can see their pay stubs and then can view the detail or print them to a printer.

Navigation on the Employee Time Management home page part opens the Paystubs navigation list. The employee can select one or more paystub and print them all at the same time.

Employee Paystubs Navigation List

Continue reading

MDGP 2015 Feature of the Day: Direct Deposit and Workflow

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The sixteenth Feature of the Day is Direct Deposit and Workflow. Another option for Employee Self Service in Microsoft Dynamics GP2015 is Employee Direct Deposit.

The Employee Direct Deposit window allows an employee to view and edit their direct deposit information. They can start or stop direct deposit, add or remove accounts and edit the direct deposit distribution.

With workflow for Employee Direct Deposit, the direct deposit changes can be routed to the appropriate people for verification before updating the employees data.

Employee Direct Deposit

The roles targeted by this feature are:

  • All Employees

Click to show/hide MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day: Employee W4 and Workflow

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The fifteenth Feature of the Day is Employee W4 and Workflow. A new Employee Self Service feature in Microsoft Dynamics GP 2015 lets a user view and update their own W4 information.

With Employee W4, the user can see their current W4 settings, view historical W4’s, make changes, and submit the changes to workflow. From the Employee Time Management home page part the user can choose update my W4.

In the Employee Withholding Certificate window the employee can manage their information and once submitted to workflow, the change will be routed automatically prior to updating the employee’s record.

W4 - Employee

The roles targeted by this feature are:

  • All Employees

Click to show/hide MDGP 2015 Feature of the Day Series Index

Integration Manager – The RPC Server Is Unavailable

Microsoft Dynamics GPDuring a recent implementation I was importing a file of 30,000 items into Microsoft Dynamics GP using Integration Manager when, part way through the integration, the following error started being produced:

9057:  ITEM-NUMBER-1 Insert Failed 6. Seconds 
    DOC 9057 ERROR: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) - The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
9058:  ITEM-NUMBER-2 Insert Failed 0. Seconds 
    DOC 9058 ERROR: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) - The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
9059:  ITEM-NUMBER-3 Insert Failed 0. Seconds 
    DOC 9059 ERROR: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) - The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)

Continue reading

Error 800AC351 While Saving Microsoft Dynamics GP

Microsoft Dynamics GPI was working onsite with a client during an upgrade of Microsoft Dynamics GP from version 10 to 2013 recently, and after doing some work on a client we started receiving an error when trying to log out..

The error we received was the following:

Microsoft Dynamics GP - Unknown error 0 - 800AC351 occurred saving the project fileMicrosoft Dynamics GP – Unknown error 0 – 800AC351 occurred saving the project file

After a little testing to see if we could easily determine the problem, I did a quick online search and came up with this post from Vaidy Mohan which was the same error, but for a different VBA project.

The steps I tried and found to be successful were slightly shorter and easier than those Vaidy needed:

  1. Launch GP and open the Visual Basic Editor
  2. Opened modified report in the Microsoft Dynamics GP VBA project
  3. Added and removed a space from the end of one line
  4. Compiled the entire project to check for errors
  5. Save VBA project
  6. Log off from GP

To verify the problem was resolved we closed and reopened Dynamics GP and didn’t see the error when closing it again.

MDGP 2015 Feature of the Day: Employee Profile, Skills & Training

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The thirteenth Feature of the Day is Employee Profile, Skills & Training.

In Microsoft Dynamics GP 2015 as part of the Employee Self Service functionality managers can see and/or edit their team members data including Address/Phone Number, Dependants, Emergency Contacts and Position History in the new Employee Profile window.

The Employee Skills & Training window also allows managers to view and edit the Education and Tests for their team members. Managers can also view the Skills and Training for each employee.

Manager submitted tasks will still flow through workflow for approval or notification.

Employee Skills & Training

The roles targeted by this feature are:

  • HR and Payroll Team Managers

Click to show/hide MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day: Employee Self Service Functionality

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The twelfth Feature of the Day is Employee Self Service Functionality. The new Employee Profile window in Microsoft Dynamics GP 2015 is an extension of the Employee Self Service functionality allows employees to view and/or update their personal information including Address/Phone Numbers, Emergency Contacts, Dependants, and Position History.

Employees maintain their Education and Tests in the Employee Skills and Training window and view their Skills and Training History.

Workflow functionality is integrated so employees can submit changes and managers can approve changes from a Navigation List or from an email notification.

Employee Profile

Continue reading

MDGP 2015 Feature of the Day: Employee Benefits

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The eleventh Feature of the Day is Employee Benefits. Employee Benefits is part of the new Employee Self Service functionality being introduced in Microsoft Dynamics GP 2015.

The new Benefits View window allows employees to view their benefits, employee contributions and employer contributions. An option for All or Active allows employees to view what they are assigned as well as all benefits available.

Benefit View

The roles targeted by this feature are:

  • Self Service Users

Click to show/hide MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day: .NET Interop

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series of posts on the new features of, the soon to be released, Microsoft Dynamics GP 2015. As I have done for the last two releases, I intend to shadow these posts and add my own opinions on these new feature; the series index is here.

The tenth Feature of the Day is .NET Interop. The new Service Based Architecture enables Microsoft Dynamics GP and ISV products to expose and consume services. Services are the backbone of the cloud and this feature supports new and exciting scenarios around cloud based interaction.

Developers can now directly reference .NET assemblies and their objects in sanScript in order to leverage capability offered in the .NET Framework. This includes the ability to call out to services or use objects as a means of data handling and processing.

Script Editor.NET objects can be instantiated, have their properties set or methods called within sanScript

The roles targeted by this feature are:

  • Developers
  • ISVs

Click to show/hide MDGP 2015 Feature of the Day Series Index