Day: April 14, 2016

MDGP 2016 R1 Feature of the Day: Budget Import Exception Report

This feature of the day is the production of an exception report during the Budget import. This is going to be a very popular one:

The main features of are:

• When importing a budget from Excel, an exception report will print displaying accounts that aren’t setup in Dynamics GP

The Budget Wizard is a good tool, but it has always been problematic to identify accounts on the budget upload which didn’t exist. This new feature will make importing budgets far easier now any missing accounts are highlighted.

I have a couple of customers who might be tempted to upgrade just to get this one feature (including one who just upgrade to Dynamics GP 2015 R2.

MDGP 2016 R1 Feature of the Day: Payroll Posting Accounts

Again a US and Canadian only feature of the day; the use of Payroll posting accounts has been made easier:

The main features of are:

• See all posting accounts in a navigation list
• Easily filter and sort accounts with navigation list functionality
• Export and Import payroll posting accounts using Microsoft Excel

MDGP 2016 R1 Feature of the Day: Prepayments on Purchase Orders

Again this feature of the day is building on one introduced in a recent version. Prepayments were introduced in Microsoft Dynamics GP 2013 R2, but all the clients I spoke to about it said that it wasn’t useful as the prepayment could only cover the subtotal.

This feature of the day allows the prepayment amount to cover taxes, freight and miscellaneous:

The main features of are:

• Prepayment amount on purchase orders can now include Taxes, Freight and Miscellaneous
• Entire PO amount can be included in the prepayment

This update to prepayments finally makes them usable. I’ll need to remember the clients I have previously discussed it with and let them know of the new functionality.

This feature of the day is for the US and Canada only; the ability to exclude inactive pay codes from lookups:

The main features of are:

• Option to exclude inactive pay codes from the pay codes lookup
• Works for Employee Pay Codes Lookup and the Pay Codes lookup window

Payroll in Dynamics GP is US and Canada only so I have no commentary to add to this feature.

This feature of the day puzzles me somewhat as I would swear this was a feature introduced within the last couple of versions. It is the export of numbers as numbers from a SmartList:

As I mentioned in the introductory paragraph, this is a feature I believe was already introduced, but upon further reflection this may be a slightly different new feature.

The previous feature I am thinking of (but can’t find a specific announcement) exported the numbers to five decimal places and without a currency symbol. The example given in the screenshot, above, has a currency symbol and is to two decimal places.

This feature of the day adds a third transaction type to the payment process to allow a payment run to be made by credit card instead of cheque or EFT:

The main features of are:

Option for a computer check batch to be paid by credit card
• The credit card payment will create an invoice for the credit card vendor
• A remittance form will print to show the invoices paid

I’ve just been doing an upgrade of a client to Microsoft Dynamics GP and had a discussion around the payment of invoices by credit card. When they upgrade again this feature will, I’m fairly sure, be quite popular with the payments team (unfortunately their next upgrade is probably a year or so away.

I already have my first upgrade to Microsoft Dynamics GP 2016 R1 booked in, so I will have to have a chat with them and see if they process many payments on credit card.

There are quite a few of the new features in Microsoft Dynamics GP 2016 R1 which are building on features introduced since GP 2013.

This feature adds the ability to use the Document Attachment feature, introduced in Dynamics GP 2013 R1 on the PTE Employee Expenses window and Employee Expense Entry windows:

The main features of are:

• Use the Document Attachment feature in PTE Employee Expenses and Employee Expense Entry
• Header and line attachments such as receipts can now be added to an employee expense
• Attachments will flow from PTE to Project Accounting to Payables

I love the Document Attachment feature as it makes it so easy to store documents in Dynamics GP without having to maintain a network share so it is nice to see it being rolled out to the action pane on more windows.

Microsoft Dynamics GP 2013 R2 saw the introduction of the purchase requisitions and they are being enhanced further with integration with Project Accounting:

The main features of are:

• Project Number and Cost Category ID fields available in Purchase Requisition Entry window
• Requisitions with project and cost category can still go through workflow process
• Project and cost category will flow to Purchase Order