Category: GP (Great Plains)

MDGP 2015 Feature of the Day: Fixed Assets Year-End Closing Report

Ian Grieve2 minute read1 Comment

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 eighteenth Feature of the Day is Fixed Assets Year End Report. Microsoft Dynamics GP 2015 Fixed Asset Management has a new, optional, report in the Fixed Assets year-end closing routine.

Now, in a single step, you can close your year and print a status report of all the assets that are being affected by the close.

On the report you’ll see the year to date depreciation, cost basis, accumulated depreciation, net book and more:

Fixed Assets Year-End Closing Report

The roles targeted by this feature are:

  • Bookkeeper
  • Certified Accountant
  • Accounting Manager

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

MDGP 2015 Feature of the Day
General Ledger Batch Approval
Payables Management Batch Approval
Receivables Management Batch Approval
Vendor Approval
Project Employee Expense Report
Organizational Accounts User Authentication
Invoicing in the Web Client
Service Based Architecture
Service Based Architecture Deployment
Service Based Architecture Deployment
.NET Interop
Employee Benefits
Employee Self Service Functionality
Employee Profile, Skills & Training
HRP Workflow Pending Approval Navigation List
Employee W4 and Workflow
Direct Deposit and Workflow
Employee Paystubs
Fixed Assets Year-End Closing Report
Canadian Payroll Web Client
Create Refreshable Excel Reports In SmartList Designer
Payment Terms – Transaction Calculation
Payment Terms – Discount Date Calculation
Copy Home Page and Area Page
Management Reporter Integration
Management Reporter Integration Setup
Management Reporter in Business Analyzer
Business Analyzer Cross Platform
Void Intercompany Journal Entries
Edit Email on Historical Transactions
Intercompany Journal Entry Inquiry
Project Employee Expense Report Entry
Management Reporter Data Integration
Employee Self Service Purchase Requisitions
Existing Purchase Order Warning
PrintFriendlyLinkedin

SQL Script To Insert Creditor Bank Details From CSV

Ian Grieve2 minute read0 comment

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 “SQL Script To Insert Creditor Bank Details From CSV”

PrintFriendlyLinkedin

MDGP 2015 Feature of the Day: Employee Paystubs

Ian Grieve2 minute read0 comment

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: Employee Paystubs”

PrintFriendlyLinkedin

MDGP 2015 Feature of the Day: Direct Deposit and Workflow

Ian Grieve2 minute read0 comment

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 the MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day
General Ledger Batch Approval
Payables Management Batch Approval
Receivables Management Batch Approval
Vendor Approval
Project Employee Expense Report
Organizational Accounts User Authentication
Invoicing in the Web Client
Service Based Architecture
Service Based Architecture Deployment
Service Based Architecture Deployment
.NET Interop
Employee Benefits
Employee Self Service Functionality
Employee Profile, Skills & Training
HRP Workflow Pending Approval Navigation List
Employee W4 and Workflow
Direct Deposit and Workflow
Employee Paystubs
Fixed Assets Year-End Closing Report
Canadian Payroll Web Client
Create Refreshable Excel Reports In SmartList Designer
Payment Terms – Transaction Calculation
Payment Terms – Discount Date Calculation
Copy Home Page and Area Page
Management Reporter Integration
Management Reporter Integration Setup
Management Reporter in Business Analyzer
Business Analyzer Cross Platform
Void Intercompany Journal Entries
Edit Email on Historical Transactions
Intercompany Journal Entry Inquiry
Project Employee Expense Report Entry
Management Reporter Data Integration
Employee Self Service Purchase Requisitions
Existing Purchase Order Warning
PrintFriendlyLinkedin

MDGP 2015 Feature of the Day: Employee W4 and Workflow

Ian Grieve2 minute read0 comment

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 the MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day
General Ledger Batch Approval
Payables Management Batch Approval
Receivables Management Batch Approval
Vendor Approval
Project Employee Expense Report
Organizational Accounts User Authentication
Invoicing in the Web Client
Service Based Architecture
Service Based Architecture Deployment
Service Based Architecture Deployment
.NET Interop
Employee Benefits
Employee Self Service Functionality
Employee Profile, Skills & Training
HRP Workflow Pending Approval Navigation List
Employee W4 and Workflow
Direct Deposit and Workflow
Employee Paystubs
Fixed Assets Year-End Closing Report
Canadian Payroll Web Client
Create Refreshable Excel Reports In SmartList Designer
Payment Terms – Transaction Calculation
Payment Terms – Discount Date Calculation
Copy Home Page and Area Page
Management Reporter Integration
Management Reporter Integration Setup
Management Reporter in Business Analyzer
Business Analyzer Cross Platform
Void Intercompany Journal Entries
Edit Email on Historical Transactions
Intercompany Journal Entry Inquiry
Project Employee Expense Report Entry
Management Reporter Data Integration
Employee Self Service Purchase Requisitions
Existing Purchase Order Warning
PrintFriendlyLinkedin

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

Ian Grieve2 minute read0 comment

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 the MDGP 2015 Feature of the Day Series Index

MDGP 2015 Feature of the Day
General Ledger Batch Approval
Payables Management Batch Approval
Receivables Management Batch Approval
Vendor Approval
Project Employee Expense Report
Organizational Accounts User Authentication
Invoicing in the Web Client
Service Based Architecture
Service Based Architecture Deployment
Service Based Architecture Deployment
.NET Interop
Employee Benefits
Employee Self Service Functionality
Employee Profile, Skills & Training
HRP Workflow Pending Approval Navigation List
Employee W4 and Workflow
Direct Deposit and Workflow
Employee Paystubs
Fixed Assets Year-End Closing Report
Canadian Payroll Web Client
Create Refreshable Excel Reports In SmartList Designer
Payment Terms – Transaction Calculation
Payment Terms – Discount Date Calculation
Copy Home Page and Area Page
Management Reporter Integration
Management Reporter Integration Setup
Management Reporter in Business Analyzer
Business Analyzer Cross Platform
Void Intercompany Journal Entries
Edit Email on Historical Transactions
Intercompany Journal Entry Inquiry
Project Employee Expense Report Entry
Management Reporter Data Integration
Employee Self Service Purchase Requisitions
Existing Purchase Order Warning
PrintFriendlyLinkedin

Integration Manager – The RPC Server Is Unavailable

Ian Grieve2 minute read0 comment

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 “Integration Manager – The RPC Server Is Unavailable”

PrintFriendlyLinkedin

Error 800AC351 While Saving Microsoft Dynamics GP

Ian Grieve2 minute read2 Comments

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.

PrintFriendlyLinkedin

Upgrading Management Reporter 2012: Post Upgrade Connection Problem

Ian Grieve2 minute read3 Comments

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.

PrintFriendlyLinkedin

Upgrading Management Reporter 2012: Upgrading the Clients

Ian Grieve1 minute read2 Comments

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 Clients”

PrintFriendlyLinkedin