“The Rebel Alliance Needs You!” or “Vote To Resurrect Multi-Dimensional Analysis”

Microsoft Dynamics GPThere was a recent discussion about Multi-Dimensional Analysis (MDA) and Analytical Accounting (AA) between a group of Microsoft MVPs for Microsoft Dynamics GP; this group involved people from at least three continents and resulted in a fairly unanimous opinion that Multi-Dimensional Analysis was a useful module.

More useful in many ways than Analytical Accounting which was intended to replace it. The problem being that while MDA was fairly simple and easy to use, AA was fairly complex and clunky. While the reporting options for AA are more comprehensive than MDA, they are still not up to the standard of much of Dynamics GP itself.

To this end a suggestion has been logged on Microsoft Connect which we would appreciate you voting on. Suggestions on MS Connect with a lot of votes stand a good chance of being included in a later version of Microsoft Dynamics GP.

Please visit and vote on this suggestion.

Rebel AllianceSource Unknown

Implementing Fastpath’s Config AD: First Login With Single Sign-On

FastpathIn this series of posts I’m going to take a look at the Config AD product from Fastpath which adds single sign-on to the Dynamics GP desktop client; you can find my series index here.

Once a user has been created or associated, the first time that user logs into GP they will need to link the GP and Windows passwords. When Dynamics GP is started, the user ID will default in; enter the password (if the user was created from Config AD the password will be set to the Config AD Options) and click OK:

Welcome to Microsoft Dynamics GP

Continue reading “Implementing Fastpath’s Config AD: First Login With Single Sign-On”

Implementing Fastpath’s Config AD: Install Single Sign-On

FastpathIn this series of posts I’m going to take a look at the Config AD product from Fastpath which adds single sign-on to the Dynamics GP desktop client; you can find my series index here.

The point of Fastpath’s Config AD is to make life easier by removing the number of usernames and passwords a user needs to be entered to access Dynamics GP. In the previous posts in this series I have associated an exiting AD user with an existing Dynamics GP user and then created a new GP user from an AD one.

For the user to benefit from this integration we need to install some code into Dynamics GP. This is done by installing the Fastpath Single Sign-On. In the FPSSO folder double click the setup.exe. On the security warning click on Run:

Open File - Security Warning

Continue reading “Implementing Fastpath’s Config AD: Install Single Sign-On”

Implementing Fastpath’s Config AD: Create GP User For AD User

FastpathIn this series of posts I’m going to take a look at the Config AD product from Fastpath which adds single sign-on to the Dynamics GP desktop client; you can find my series index here.

In the last post, I took a look at associating an AD user with an existing Dynamics GP user; in this one I’ll be taking a look at creating a new Dynamics GP user from an AD one.

To do this, create an AD User in Active Directory Users and Groups and then right click and select Create Dynamics User. This will launch the Config AD logon with the first window show being ther Connect To Database one:

Connect To Database

Continue reading “Implementing Fastpath’s Config AD: Create GP User For AD User”

MDGP 2013 R2 Feature of the Day: Email By Document Type

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The thirty-sixth Feature of the Day covered is Email by Document Type. This new functionality gives the end-user the flexibility to send emails based on the actual type of the document; for example they may want to send quotes to a different email address that the actual invoice. This now can be accomplished using a simple interface.

The Customer Maintenance email tab (Microsoft Dynamics GP menu » Cards » Sales » Debtor (or Customer if in the US) » Email tab) has been updated with a new Email Address column containing an ellipsis button:

Customer Maintenance

Continue reading “MDGP 2013 R2 Feature of the Day: Email By Document Type”

MDGP 2013 R2 Feature of the Day: Print Remaining Documents

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The thirty-fifth Feature of the Day covered is Print Remaining Documents. Users will now have the ability to email and print batches or statements in one step rather than having to handle those that will be emailed or printed separately.

In the PM, RM, SOP and POP Batch windows the UI will not change; the user will simply mark both options to Print and Send Documents in E-mail.

The Print Receivables Statements form will see the introduction of a new option for use hen emailing statements:

GP windows

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

MDGP 2013 R2 Feature of the Day: SmartList Designer Go To's
MDGP 2013 R2 Feature of the Day: Identity Management – Login
MDGP 2013 R2 Feature of the Day: Purchase Requisitions
MDGP 2013 R2 Feature of the Day: Copy And Paste To General Ledger Transaction Entry
MDGP 2013 R2 Feature of the Day: Workflow
MDGP 2013 R2 Feature of the Day: Workflow Types
MDGP 2013 R2 Feature of the Day: Workflow User Delegation
MDGP 2013 R2 Feature of the Day: Default Fixed Asset ID From The Asset Class
MDGP 2013 R2 Feature of the Day: Identity Management – Scalability Groups
MDGP 2013 R2 Feature of the Day: Workflow Calendar
MDGP 2013 R2 Feature of the Day: Reprint Outstanding Transaction in Bank Reconciliation
MDGP 2013 R2 Feature of the Day: Requisition Management Integration Points
MDGP 2013 R2 Feature of the Day: Default Sort Order for Checks
MDGP 2013 R2 Feature of the Day: Document Attach – Scan
MDGP 2013 R2 Feature of the Day: Workflow History
MDGP 2013 R2 Feature of the Day: Workflow Email Notifications
MDGP 2013 R2 Feature of the Day: Azure Backups
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements – Analysis and Assignment
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements – Sales Script and Additional Information
MDGP 2013 R2 Feature of the Day: Dashboards
MDGP 2013 R2 Feature of the Day: Management Reporter Web Viewer
MDGP 2013 R2 Feature of the Day: Take Company Offline
MDGP 2013 R2 Feature of the Day: Encumbrance SQL Reporting Services Reports
MDGP 2013 R2 Feature of the Day: Email Or Print Any Report In Word Format
MDGP 2013 R2 Feature of the Day: Reverse Year End Close
MDGP 2013 R2 Feature of the Day: Document Attachment On Payables Transactions
MDGP 2013 R2 Feature of the Day: Roll Down Segment Changes
MDGP 2013 R2 Feature of the Day: Assign An Item To Multiple Sites
MDGP 2013 R2 Feature of the Day: Replace OLE Note With Document Attachment
MDGP 2013 R2 Feature of the Day: OLE Notes Migration Utility
MDGP 2013 R2 Feature of the Day: Purchase Order Prepayment Additions
MDGP 2013 R2 Feature of the Day: Print Remaining Documents
MDGP 2013 R2 Feature of the Day: Email By Document Type

MDGP 2013 R2 Feature of the Day: Purchase Order Prepayment Additions

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The thirty-fourth Feature of the Day covered is Purchase Order Prepayment Additions. In Microsoft Dynamics GP2013 R2 the Purchase Order Prepayments functionality has been extended:

  1. Enter a prepayment for a project accounting purchase order
  2. Include analytical accounting transaction dimension codes
  3. View PO number on Payables Payments Zoom
  4. Prepayments paid and applied will be included in the PO document amount on the Cash Flow Calendar

As mentioned above, the Project Accounting version of Purchase Order Entry has been updated to allow Prepayments to be entered:

Payables Payments Zoom

This feature is targeted at the following roles:

  1. Purchasing Agent
  2. Purchasing Manager

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

MDGP 2013 R2 Feature of the Day: SmartList Designer Go To's
MDGP 2013 R2 Feature of the Day: Identity Management – Login
MDGP 2013 R2 Feature of the Day: Purchase Requisitions
MDGP 2013 R2 Feature of the Day: Copy And Paste To General Ledger Transaction Entry
MDGP 2013 R2 Feature of the Day: Workflow
MDGP 2013 R2 Feature of the Day: Workflow Types
MDGP 2013 R2 Feature of the Day: Workflow User Delegation
MDGP 2013 R2 Feature of the Day: Default Fixed Asset ID From The Asset Class
MDGP 2013 R2 Feature of the Day: Identity Management – Scalability Groups
MDGP 2013 R2 Feature of the Day: Workflow Calendar
MDGP 2013 R2 Feature of the Day: Reprint Outstanding Transaction in Bank Reconciliation
MDGP 2013 R2 Feature of the Day: Requisition Management Integration Points
MDGP 2013 R2 Feature of the Day: Default Sort Order for Checks
MDGP 2013 R2 Feature of the Day: Document Attach – Scan
MDGP 2013 R2 Feature of the Day: Workflow History
MDGP 2013 R2 Feature of the Day: Workflow Email Notifications
MDGP 2013 R2 Feature of the Day: Azure Backups
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements – Analysis and Assignment
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements – Sales Script and Additional Information
MDGP 2013 R2 Feature of the Day: Dashboards
MDGP 2013 R2 Feature of the Day: Management Reporter Web Viewer
MDGP 2013 R2 Feature of the Day: Take Company Offline
MDGP 2013 R2 Feature of the Day: Encumbrance SQL Reporting Services Reports
MDGP 2013 R2 Feature of the Day: Email Or Print Any Report In Word Format
MDGP 2013 R2 Feature of the Day: Reverse Year End Close
MDGP 2013 R2 Feature of the Day: Document Attachment On Payables Transactions
MDGP 2013 R2 Feature of the Day: Roll Down Segment Changes
MDGP 2013 R2 Feature of the Day: Assign An Item To Multiple Sites
MDGP 2013 R2 Feature of the Day: Replace OLE Note With Document Attachment
MDGP 2013 R2 Feature of the Day: OLE Notes Migration Utility
MDGP 2013 R2 Feature of the Day: Purchase Order Prepayment Additions
MDGP 2013 R2 Feature of the Day: Print Remaining Documents
MDGP 2013 R2 Feature of the Day: Email By Document Type

MDGP 2013 R2 Feature of the Day: OLE Notes Migration Utility

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog started a series of Microsoft Dynamics GP 2013 R2 Feature of the day posts the other day. As they did with the Microsoft Dynamics GP 2013 Feature of the Day posts they are doing them as short posts containing a PowerPoint slide show. I am translating these from the PowerPoints into posts; you can find my series index here.

The thirty-third Feature of the Day covered is OLE Notes Migration Utility. The ability to attach documents to record level notes has been available in Microsoft Dynamics GP for a long time. The record notes were always stored as OLE attachments until now; in Microsoft Dynamics GP, the OLE Notes have been replaced with the Document Attachment functionality which stores the notes directly in the Microsoft SQL Server Database.

To facilitate this, a Migration Utility, which runs as a separate application, can be obtained from PartnerSource/CustomerSource. The utility will allow existing users to migrate the files that have already been attached to Notes using the existing OLE functionality into the new Document Attach functionality:

OLE Notes Migration Utility

I’ve never liked the OLE Attachment available in record level notes; if one client had a different path defined in the ini file and the user opened and saved a window the attachments then they would get corrupted. Using Document Attachment functionality removes this risk of data corruption and provides functionality which is much more robust.

This feature is targeted at the following roles:

  1. Administrators
  2. System Implementers

Click to show/hide the Microsoft Dynamics GP 2013 R2 Feature of the Day Series Index

MDGP 2013 R2 Feature of the Day: SmartList Designer Go To's
MDGP 2013 R2 Feature of the Day: Identity Management – Login
MDGP 2013 R2 Feature of the Day: Purchase Requisitions
MDGP 2013 R2 Feature of the Day: Copy And Paste To General Ledger Transaction Entry
MDGP 2013 R2 Feature of the Day: Workflow
MDGP 2013 R2 Feature of the Day: Workflow Types
MDGP 2013 R2 Feature of the Day: Workflow User Delegation
MDGP 2013 R2 Feature of the Day: Default Fixed Asset ID From The Asset Class
MDGP 2013 R2 Feature of the Day: Identity Management – Scalability Groups
MDGP 2013 R2 Feature of the Day: Workflow Calendar
MDGP 2013 R2 Feature of the Day: Reprint Outstanding Transaction in Bank Reconciliation
MDGP 2013 R2 Feature of the Day: Requisition Management Integration Points
MDGP 2013 R2 Feature of the Day: Default Sort Order for Checks
MDGP 2013 R2 Feature of the Day: Document Attach – Scan
MDGP 2013 R2 Feature of the Day: Workflow History
MDGP 2013 R2 Feature of the Day: Workflow Email Notifications
MDGP 2013 R2 Feature of the Day: Azure Backups
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements – Analysis and Assignment
MDGP 2013 R2 Feature of the Day: Suggested Item Enhancements – Sales Script and Additional Information
MDGP 2013 R2 Feature of the Day: Dashboards
MDGP 2013 R2 Feature of the Day: Management Reporter Web Viewer
MDGP 2013 R2 Feature of the Day: Take Company Offline
MDGP 2013 R2 Feature of the Day: Encumbrance SQL Reporting Services Reports
MDGP 2013 R2 Feature of the Day: Email Or Print Any Report In Word Format
MDGP 2013 R2 Feature of the Day: Reverse Year End Close
MDGP 2013 R2 Feature of the Day: Document Attachment On Payables Transactions
MDGP 2013 R2 Feature of the Day: Roll Down Segment Changes
MDGP 2013 R2 Feature of the Day: Assign An Item To Multiple Sites
MDGP 2013 R2 Feature of the Day: Replace OLE Note With Document Attachment
MDGP 2013 R2 Feature of the Day: OLE Notes Migration Utility
MDGP 2013 R2 Feature of the Day: Purchase Order Prepayment Additions
MDGP 2013 R2 Feature of the Day: Print Remaining Documents
MDGP 2013 R2 Feature of the Day: Email By Document Type

Implementing Fastpath’s Config AD: Associate AD User With GP User

FastpathIn this series of posts I’m going to take a look at the Config AD product from Fastpath which adds single sign-on to the Dynamics GP desktop client; you can find my series index here.

Over the last couple of posts, Config AD has been installed and configured and it is time to get started linking AD users to Dynamcis GP ones. This can be done in one of two ways:

  1. Associate AD users to existing Dynamics GP users
  2. Create new Dynamics GP users from the AD users

In this post I’m going to associate my iang AD user with my ian.grieve Dynamics GP user; in the next post I’ll take a look at creating a new GP user from an AD one.

To assign a user, open Active Directories Users and Groups, right click on a user, which in this post is my iang one, and then click on Configure Dynamics User.

Before the Config AD window itself opens, you’ll be prompted to supply the database connection details. Ensure the correct Server and authentication method is selected: if using SQL Server Authentication enter the login and password:

Connect To Database

Continue reading “Implementing Fastpath’s Config AD: Associate AD User With GP User”

Implementing Fastpath’s Config AD: Configuration

FastpathIn this series of posts I’m going to take a look at the Config AD product from Fastpath which adds single sign-on to the Dynamics GP desktop client; you can find my series index here.

With Config AD installed on the domain controller, we now need to configure it to connect to the required Microsoft Dynamics GP installation. To do this open the Active Directory Users and Groups, right click on a user and then click on Configure Dynamics User:

Active Directory Users and Groups

Continue reading “Implementing Fastpath’s Config AD: Configuration”