Hands On With Microsoft Dynamics GP 2016 R2: POP To FA Link Includes Taxes

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

The thirteenth Feature of the Day I am going “hands on” with is POP to FA Link to Include Taxes.

This feature will be popular with some of our clients who deal with non-recoeverable VAT (VAT is a UK sales tax charged at a standard rate of 20%) as non-rec VAT means they would need to depreciate the gross value of the asset including VAT where in previous versions the asset would be created net and need to be amended.

To use this feature, the Include Tax in Acquisition Cost checkbox on the Fixed Assets Company Setup window (Financial >> Setup >> Fixed Assets >> Company) under the Purchasing Options:

Fixed Assets Company 	Setup

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: POP To FA Link Includes Taxes”

Hands On With Microsoft Dynamics GP 2016 R2: Display Tax Percent for Historical Sales Transactions

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components and also look at the new functionality introduced; the index for this series can be found here.

In this post, I’m going “hands on” with the sixth of the Microsoft Dynamics GP 2016 R2 Feature of the Day posts, Display Tax Percent for Historical Sales Transactions.

To test this feature, I created a new Tax Detail in Tax Detail Maintenance (Administration >> Setup >> Company >> Tax Details) for a Sales series Standard Rated UK VAT at 20% and created a related Tax Schedule:

Tax Detail Maintenance

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Display Tax Percent for Historical Sales Transactions”

Management Reporter Error: “The operation could not be completed due to a problem in the data provider framework”

Microsoft Dynamics GPA bit like Integration Manager, Management Reporter often presents highly generic meaningless error messages to users. The error message below was provided to me by a client a while ago (but I have just stumbled across the screenshots again), which I was then able to reproduce just be ruunning the report:

Management Reporter: The operation could not be completed due to a problem in the data provider framework

Management Reporter

The operation could not be completed due to a problem in the data provider framework.

Continue reading “Management Reporter Error: “The operation could not be completed due to a problem in the data provider framework””

Setting Bank Account In ABR To Extract Automatically In Reconcile Bank Transactions

Microsoft Dynamics GPConfiguring Nolan’s Advanced Bank Reconciliation (ABR) to automatically extract transactions when reconciling a bank account is not complicated, but I keep on forgetting where the option is located. That gets a little embarrassing when you tell a client, “yes, you can do that” and then have to spend five minutes looking for the option.

So by writing it down here, I am hoping to be able to commit it to memory.

this option is per bank account and is located on the Bank Account Setup window (Financial >> Setup >> Advanced Bank Reconciliation >> Bank Setup).

Click the Options menu and then select Extract options:

Bank Account Setup

Continue reading “Setting Bank Account In ABR To Extract Automatically In Reconcile Bank Transactions”

Copy Fiscal Calendar To All Companies

Microsoft Dynamics GPIn the last post I mentioned that I create scripts when implementing Microsoft Dynamics GP and then make them available to clients when they would be of benefit. The last script I posted, allowed calendars to ve copied from one database to another. Afetr writing that scirpt I then adapted it by wrapping a cursor around it which allowed a source database to be defined and the calendar copied to all other databases.

The original script is still useful as it allows a targeted copying of calendars from a source to a destination database, but the new allows calendars to be quickly replicated across all companies if they share the same financial year.

The script has two parameters (highlighted) at the top which need to be set:

  • Year
  • SourceDatabase
  • Continue reading “Copy Fiscal Calendar To All Companies”

    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

    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 2013 R2 Feature of the Day: Roll Down Segment Changes

    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 twenty-ninth Feature of the Day covered is Roll Down Segment Changes. This feature means that if the Account Segment description is changed then the change can be rolled down to accounts containing the segment.

    A warning message will be displayed to prompt the user to confirm the change should be rolled down or not:

    Microsoft Dynamics GP: Do you want to roll down account segment description to account that contain this segment?

    This is my least favourite feature so far; the Account Description length generally isn’t long enough so users tend to do their own descriptions rather than accepting the defaults. I can see people accidentally clicking yes on the warning prompt without meaning to do so. I’ll see how things go, but a switch to disable this function might be nice.

    This feature is targeted at the following roles:

    1. Accounting Manager
    2. Accounts Payable
    3. Bookkeeper

    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

    Cashbook Bank Management – Value Exists In The PM_Key_MSTR Table

    Microsoft Dynamics GPA client had an odd error with the Cashbook Bank Management module the other day when trying to enter a deposit; the following was printed on the exception report when trying to post the transaction:

    Value exists in the PM_Key_MSTR table

    I did some digging around and found that the Next Voucher Number field in Payables Management Setup – Options (Microsoft Dynamics GP menu » Tools » Setup » Purchasing » Payables Setup) was blank.

    I set a new value in the Next Voucher Number field and the deposit could be posted without problem.