MDGP 2018 RTM Feature of the Day: One Payment Per Vendor/Invoice Setting on Vendor Card

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my won commentary.

The series index for this series of posts is here.

This delayed Feature of the Day (I think I missed the official post when it was posted) is One Payment Per Vendor/Invoice Setting on the Vendor Card which allows the user to decide, on a per vendor basis, if one payment should be produced per vendor or invoice:

Vendor Maintenance Options

Continue reading “MDGP 2018 RTM Feature of the Day: One Payment Per Vendor/Invoice Setting on Vendor Card”

MDGP 2018 RTM Feature of the Day: Save Select Payment Settings

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The eleventh Feature of the Day is Save Select Payment Settings.

A new Payment Batch ID field has been added to the Build Payment Batch (formerly Select Cheques (or Checks)) window (Purchasing area page >> Transactions >> Build Payment Batch):

Build Payment Batch

This option allows you to save the entered restrictions for easy recall at a later date. I have mixed feelings on this one; my initial impressions was that this feature would be really useful, but when I thought more I can;t see many of my users making much use of this functionality.

Most of them only build a batch based on due date and there is no benefit saving the due date as the selection is for a specific date only.

If you do more complex batch building, such as using Vendor Class, Payment Priority, or a combination of restrictions, then this new option could save you a little time on every payment batch created.

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

MDGP 2018 RTM Feature of the Day: Rename Payment Run Windows

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 RTM; as the most recent versions have been, these posts are in the form of PowerPoint slides; I am reposting them here so they can be read more easily as well as adding my own commentary.

The series index for this series of posts is here.

The ninth Feature of the Day is a feature requested by Mariano Gomez and that is to rename the payment run windows.

So instead of them being named Check or Cheque, depending on the installed language pack, they will now be named Payment:

Purchasing menu

The windows which have been renamed are:

  • Select Payables Checks -> Build Payments Batch
  • Edit Payables Check Batch -> Edit Payment Batch
  • Edit Payables Check -> Edit Vendor Payment
  • Print Payables Checks -> Print Payment Documents
  • Post Payables Checks -> Post Payment Documents

In the UK, virtually no-one uses cheques anymore; payments are made by BACS which is a form of EFT. Renaming these windows

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

Hands On With Microsoft Dynamics GP 2016 R2: Link Credit Card Invoices To Original Invoice

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 eighth Feature of the Day, which I am “hands on” with in this post, was Link Credit Card Invoices To Original Invoice.

To test this feature, I entered, posted and paid an invoice for Attractive Telephone Co. for $1,000:

Payables Transaction Inquiry - Vendor

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Link Credit Card Invoices To Original Invoice”

MS Connect Suggestion To Rename Five Microsoft Dynamics GP Payables Windows

Microsoft Dynamics GPMariano, Microsoft Dynamics GP MVP and Dynamics GP Blogster has logged a suggestion for improving Microsoft Dynamics GP on the MS Connect site.

The windows are:

  1. Select Payables Checks -> Build Payments Batch
  2. Edit Payables Check Batch -> Edit Payment Batch
  3. Edit Payables Check -> Edit Vendor Payment
  4. Print Payables Checks -> Print Payment Documents
  5. Post Payables Checks -> Post Payment Documents

Mariano has more details on his blog including screenshots of the windows in question.

Renaming these windows would be a good idea as the current names are misleading and cause confusion for new users of the system. From a partner perspective, it also looks quite bad when demoing Dynamics GP to a prospect; especially when considering that in the UK, virtually no-one uses printed cheques anymore, but instead make payments using EFT.

Please take a look at the suggestion and cast your vote.

I have two hopes; that Microsoft do make this change and that they also change it in the UK language pack.

MDGP 2016 R1 Feature of the Day: Payables Credit Card Payment Run

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:

Payables Credit Card Payment Run

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.

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

SQL View For Computer Cheques At Work Status To Check Email Enabled

Microsoft Dynamics GPWhile onsite with a client recently, I was asked if it was possible to view the payments in a computer checks batch and whether the creditors (vendors) were enabled for emailed remittances.

Out of the box no, but SmartList Designer can be used to do this. I created a new SQL view to get payments at a status of work and, in SmartList Designer, combined it with the remittance enabled view and vendor email addresses view I have previously posted.

I could have used the table in GP, but I find using views in SmartList Designer easier so created the view.

CREATE VIEW uv_AZRCRV_PaymentRunWORK AS

SELECT
	PM103.BACHNUMB AS 'Batch Number'
	,PM103.VENDORID AS 'Creditor ID'
	,PM2.VENDNAME AS 'Creditor Name'
	,PM2.VADDCDPR AS 'Primary Address'
	,PM2.VADCDTRO AS 'Remit To Address'
	,PM103.DOCDATE AS 'Document Date'
FROM
	PM00200 AS PM2
INNER JOIN
	PM10300 AS PM103 ON PM103.VENDORID = PM2.VENDORID
GO

GRANT SELECT ON uv_AZRCRV_PaymentRunWORK TO DYNGRP
GO

All of these views could have been created natively in SmartList Builder, but by creating them as views I can reuse them in SmartList Designer or any other reporting tool.

EFT File Format Import/Export Error

Microsoft Dynamics GPI’ve recently been creating an HSBC Standard 18 BACs file format for a client in Microsoft Dynamics GP 2010 R2.

Unfortunately, once I released it to their system, they reported an error with the import where the Creditor’s Cheque Name wasn’t being output on the resulting file.

I did some testing and it turns out to be a bug in the export function of the EFT File Format (Cards ¯ Financial ¯ EFT File Format) window in Microsoft Dynamics GP 2010 R2; I have subsequently tested on GP 2010 SP3 and GP 2013 and the import/export works fine. I realised something odd was going on when I looked at the template in the EFT File Format window (Cards ¯ Financial ¯ EFT File Format) and saw that while the Series was defined as Purchasing in the header, the scrolling window for the Data Field only had Receivables Management tables and fields available to it and not the Payables Management tables and fields I would expect;

EFT File Format

Continue reading “EFT File Format Import/Export Error”

MDGP 2013 Feature of the Day: Computer Prepayments

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The eighty sixth feature they’ve announced is Computer Prepayments.

This feature allows a user or multiple users to process a Purchase Order Prepayment using a computer check or EFT (Electronic Funds Transfer). The process is managed from the creation of the purchase order with the prepayment through the consumption of the prepayment when the vendor invoice is posted.

When raising a purchase order, there is now a field for entering the Prepayment amount (which can be printed on the PO);

Purchase Order Entry

Continue reading “MDGP 2013 Feature of the Day: Computer Prepayments”

MDGP 2013 Feature of the Day: Reprint Payables Management Remittance

Microsoft Dynamics GPMicrosoft are posting the Microsoft Dynamics GP 2013 Feature of the Day series on the Inside Microsoft Dynamics GP Blog.

The fifty eighth feature they’ve announced is Reprint Payables Management Remittance.

Now, in Microsoft Dynamics GP 2013, you can reprint the vendor check stub or remittance form after you’ve processed the payment. You can see invoices that were paid, credits that were applied and other information that displays on the check stub or remittance.

Re-create Check Stub is available on the Payables Payments Zoom window;

Payables Payments Zoom

Check Remittance

This new feature is targeted at the following roles:

  • Accounts Payable
  • Bookkeeper
  • Certified Accountant
  • Accounting Manager