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

MDGP 2015 Feature of the Day: HRP Workflow Pending Approval Navigation List

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 fourteenth Feature of the Day is HR/Payroll Workflow Pending Approval Navigation List. In Microsoft Dynamics GP 2015 approvers have one place to view and approve employee self service changes. This is a one-stop-shop for managers to see all of their assigned tasks including Payroll Timecards, Employee Profile, Employee Skills, Payroll W4, and Payroll Direct Deposit.

The HRP Workflow Pending Approval Navigation List allows you to approve/complete multiple tasks by checking the box and selecting the action to complete. The preview pane displays task details and there is a Go To option to view the assigned task.

HRP Workflow Pending Approval

The roles targeted by this feature are:

  • HR and Payroll Team Managers

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.

Upgrading Management Reporter 2012: Post Upgrade Connection Problem

Microsoft Dynamics GPIn this short series of posts, I’m going to take a look at upgrading an installation of Management Reporter 2012 to the latest Rollup. The series index can be found here.

Over the last three posts I covered the upgrade of the Management Reporter server and client components. If the components and database has been upgraded as covered in the posts then you should not see the error message shown below:

Management Reporter – Can’t connect to the Management Reporter server. Do you want to specify a different server address?Management Reporter – Can’t connect to the Management Reporter server. Do you want to specify a different server address?

This error is one seen at a client who had done the upgrade on the server and the majority of clients. But one user who had been on holiday that day hadn’t had their PC updated and wasn’t aware it had been done. So when they tried logging into Management Reporter they logged the issue.

A short client upgrade later and they were up and running without further problems.

Upgrading Management Reporter 2012
Upgrade the Server Components
Upgrading the Database
Upgrading the Clients
Post Upgrade Connection Problem

Upgrading Management Reporter 2012: Upgrading the Clients

Microsoft Dynamics GPIn this short series of posts, I’m going to take a look at upgrading an installation of Management Reporter 2012 to the latest Rollup. The series index can be found here.

With the server fully upgraded we now need to upgrade all of the clients. To do this start the same setup.exe as used to upgrade the server components and select Management Reporter Client:

Management Reporter Setup

Continue reading

Upgrading Management Reporter 2012: Upgrading the Database

Microsoft Dynamics GPIn this short series of posts, I’m going to take a look at upgrading an installation of Management Reporter 2012 to the latest Rollup. The series index can be found here.

In the previous post I covered the upgrade of the server components; in this one I’m going to finish the upgrade of the server which requires that the database also be upgraded.

To do this run the Configuration Console from the Windows Start screen; you’ll see a Task List in the bottom right corner of the window showing thre items:

Management Reporter 2012 Configuration Console

Continue reading