MDGP 2015 Feature of the Day: Organizational Accounts User Authentication

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 sixth Feature of the Day is Organizational Accounts User Authentication.

This feature allows users to be authenticated for Microsoft Dynamics GP using organizational account credentials, also known as Azure AD accounts. This allows the user to log into the Microsoft Dynamics GP Web Client using the same credentials that are used for Office 365, Microsoft Dynamics CRM Online, or many other cloud applications:

User Setup

Continue reading “MDGP 2015 Feature of the Day: Organizational Accounts User Authentication”

MDGP 2015 Feature of the Day: Project Employee Expense Report

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 fifth Feature of the Day is Project Employee Expense Report.

Project Accounting employees can create expense reports for any projects to which they are assigned and employees can also be set up to allow delegates to enter expense reports on their behalf.

Workflow approvals and task assignments are defined for expense reports; workflow actions are executed on the documents from the Expense Entry window or from the Navigation lists.

PTE Expenses navigation list

Continue reading “MDGP 2015 Feature of the Day: Project Employee Expense Report”

My MVP Has Been Renewed

Microsoft MVPI received my notification today that I have been awarded the Microsoft® Most Valuable Professional award a second time.

Congratulations! We are pleased to present you with the 2014 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in Dynamics GP technical communities during the past year.

I feel slightly like a fraud as my contributions to the Dynamics Community forums have been almost non-existant recently and blog posts have slowed. However, in large part that was because I was working on my third book which is out and has been published (see links below). So now I plan to get back to new blog posts and contributing to the Community Forum on a more regular basis.

Continue reading “My MVP Has Been Renewed”

Change SQL Server From Windows Authentication To Mixed Mode

Microsoft Dynamics GPA while ago I was setting up SQL Server for a test system, I obviously wasn’t paying enough attention because when I tried to launch Microsoft Dynamics GP Utilities I received the below error:

Microsoft Dynamics GP Utilities: This login failed. Attempt to log in again or contact your system administratorMicrosoft Dynamics GP Utilities: This login failed. Attempt to log in again or contact your system administrator

Continue reading “Change SQL Server From Windows Authentication To Mixed Mode”

MDGP 2015 Feature of the Day: Vendor Approval

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 fourth Feature of the Day is Vendor Approval. This feature is an enhancement to the new Workflow 2.0 module introduced in Microsoft Dynamics GP 2013 R2 which allows users to control the setup and maintenance of vendors.

Vendor Approval allows users to create mandatory workflow processes around the setup and maintenance of vendors. These mandatory processes need to be completed before transactions can be posted. The workflow processes are defined in Workflow Maintenance (Administration area page » Setup » Company » Workflow » Workflow Maintenance):

Workflow Maintenance

The workflow status appears on the window and actions can be taken directly from those windows, from an email or from a Navigation List.

I want to see more details about this feature as I am very much hoping that the workflow has been extended to include the EFT Bank details.

The new Workflow 2.0 is far, far simpler and easier to implement and use.

The roles targeted by this feature are:

  • All

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

MDGP 2015 Feature of the Day: Receivables Management Batch Approval

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 third Feature of the Day is Receivables Management Batch Approval. This feature is an enhancement to the new Workflow 2.0 module introduced in Microsoft Dynamics GP 2013 R2 which allows users to control the processing of Receivables Management batches in a more streamlined fashion.

Receivables Management Batch Approval allows users to create mandatory workflow processes around Receivables transaction batches. These mandatory processes need to be completed before transactions can be posted. The workflow processes are defined in Workflow Maintenance (Administration area page » Setup » Company » Workflow » Workflow Maintenance):

Workflow Maintenance

The workflow status appears on the window and actions can be taken directly from those windows, from an email or from a Navigation List.

The new Workflow 2.0 is far, far simpler and easier to implement and use.

The roles targeted by this feature are:

  • All

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

Add Persistent Mapped Drive For Shared Files

Microsoft Dynamics GPMicrosoft Dynamics GP and related products, such as Integration Manager, have a few files which need to be shared between client machines. This can, and in a lot of cases should, be done using a shared folder accessed via the UNC path (e.g. \\file\Dynamics Central to access the Dynamics Central folder on the server called file).

However, if any of these files need to be accessed by users then using the UNC path isn’t the friendliest of ways. Instead a mapped drive can be used which shows up in Windows Explorer and allows the user to easily access it and each user needs the drive mapped under the same folder.

While mapped drives can be created manually on each client machine this would take while. Instead we can create a batch file which can be run on each machine which will add the mapped drive for us:

net use M: /delete
net use M: "\\file\Dynamics Central" /persistent:YES

The first line deletes any existing M: and the second then creates a persistent (one which will be retained when the PC is rebooted) mapped drive on the drive letter M using the Dynamics Central folder on the server called file.

MDGP 2015 Feature of the Day: Payables Management Batch Approval

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 second Feature of the Day is Payables Management Batch Approval. This feature is an enhancement to the new Workflow 2.0 module introduced in Microsoft Dynamics GP 2013 R2 which allows users to control the processing of Payables Management batches in a more streamlined fashion.

Payables Management Batch Approval allows users to create mandatory workflow processes around all payables batches. These mandatory processes need to be completed before transactions can be posted. The workflow processes are defined in Workflow Maintenance (Administration area page » Setup » Company » Workflow » Workflow Maintenance):

Workflow Maintenance

The workflow status appears on the window and actions can be taken directly from those windows, from an email or from a Navigation List.

I haven’t worked with the old workflow module to configure batch approvals in Payables Management; the old workflow always seemed too complex and flakey to use much, although we do have one client using it for General Ledger batches although the sooner we get them upgraded and off it the better.

The roles targeted by this feature are:

  • All

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

MDGP 2015 Feature of the Day: General Ledger Batch Approval

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 first Feature of the Day is General Ledger Batch Approval. This feature is an enhancement to the new Workflow 2.0 module introduced in Microsoft Dynamics GP 2013 R2 which allows users to control the processing of General Ledger batches in a more streamlined fashion.

General Ledger Batch Approval allows users to create mandatory workflow processes around General, Clearing and Budget transaction batches. These mandatory processes need to be completed before transactions can be posted. The workflow processes are defined in Workflow Maintenance (Administration area page » Setup » Company » Workflow » Workflow Maintenance):

Workflow Maintenance

The workflow status appears on the window and actions can be taken directly from those windows, from an email or from a Navigation List.

I am delighted that this functionality has been introduced. I’ve done extensive work with a client using the old SharePoint based workflow recently and I am very much looking forward to being able to replace it with the new workflow. The old was so complex; Workflow based on top of SharePoint talking to the Web Services. There were so amny points of failure and skills needed to install and configure that it made it very complex, costly and unstable.

The new Workflow 2.0 is far, far simpler and easier to implement and use.

The roles targeted by this feature are:

  • All

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

MDGP 2015 Feature of the Day: Series Index

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 Pam Misialek says, this release will focus on four big rocks with lots of little pebbles thrown in. The four big rocks are:

  • Service Based Architecture
  • Identity Management
  • Azure Procurement
  • Apps on multiple platforms

As I have done for the last two releases I intend to shadow these Feature of the Day posts and add my own opinions on these new features. This post is to serve as the series index.

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