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: Print Purchase Requisition

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.

The eighteenth Feature of the Day is actually a set of distinct feature enhancements to the Purchase Order Processing module around the handling of purchase requisitions and orders. I am breaking this down into three separate posts, as the changes are not related beyond being about purchase requisitions and orders.

The final enhancement is the addition of a print button to the Purchase Requisition Entry window which allows the requisition to be printed:

Purchase Requisition report

I’d say I have very mixed feelings on this one, but, to be entirely honest, my feelings are actually very much on the negative side. One of the reasons for using requisitions is to have approval workflows. With a requisition needing to be approved before being purchased, there is no way for a PO to be emailed or printed; I realise this print option doesn’t print a PO, but it does print the requisition. This opens the system to potential abuse.

This can be limited through the creation or modification of security tasks which do not give access to this window; or the report could be customised to be in a format which could not be presented as if it was a PO.

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

MDGP 2018 RTM Feature of the Day: Make PO Number Visible to Requisition Originator

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.

The eighteenth Feature of the Day is actually a set of distinct feature enhancements to the Purchase Order Processing module around the handling of purchase requisitions and orders. I am breaking this down into three separate posts, as the changes are not related beyond being about purchase requisitions and orders.

The second of the changes, is making the purchase order number easily visible to the requisition originator.

The PO number has been made available in two places. The first of them is on the Dynamics GP home page. The Procurement panel has been updated too have a new PO Number in the Requisition List:

Home page

Continue reading “MDGP 2018 RTM Feature of the Day: Make PO Number Visible to Requisition Originator”

MDGP 2018 RTM Feature of the Day: On PO Generation Show Purchase Order Transactions Navigation List

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.

The eighteenth Feature of the Day is actually a set of distinct feature enhancements to the Purchase Order Processing module around the handling of purchase requisitions and orders. I am breaking this down into three separate posts, as the changes are not related beyond being about purchase requisitions and orders.

The first of the three features is a new option to the Purchase Requisition Entry window on the generation of a purchase order which will pop up the Purchase Order Transactions navigation list and show the generated orders:

Purchase Order Transactions Navigation List

From the screenshots supplied by Microsoft, it isn’t apparent how the option works, but this is potentially very useful, in that it will allow the originator to convert the requisition to an order and then, from the navigation list, be able to email or print the purchase order.

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

MDGP 2018 RTM Feature of the Day: Display Hold Status

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 fourteenth Feature of the Day is Display Hold Status. The Sales Transaction Entry and Sales Transaction Enquiry/Inquiry windows have been updated to have a hold status icon displayed next to the Type/Type ID field:

Sales Transaction Entry

Continue reading “MDGP 2018 RTM Feature of the Day: Display Hold Status”

MDGP 2018 RTM Feature of the Day: Sorting

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 tenth Feature of the Day is Sorting. This feature adds sorting options to five windows in Purchasing, Sales and Bank Reconciliation:

I like this feature a lot. Clients have been asking about being able to reorder the enquiry windows for a long time; it’s nice that I’ll soon be able to tell them that they can now sort the data.

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

MDGP 2018 RTM Feature of the Day: DocAttach Available on More 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.

The series index for this series of posts is here.

The first Feature of the Day is Document Attachment available on more windows.

Five additional windows now have Doc Attach available via a button on the action pane:

It is nice to see Fixed Assets getting some Doc Attach functionality; quite a few clients have documentation or images relating to their assets, so this offers a good way to keep these with the asset.
Continue reading “MDGP 2018 RTM Feature of the Day: DocAttach Available on More Windows”

MS Connect Suggestion: On Purchase Stop Summarising PR Lines

Microsoft Dynamics GPThis suggestion came about from an issue raised by a client while I was working with them to implement Purchase Order Processing with Workflow for approvals of purchase requisitions (PRs).

The issue encountered, is that when multiple lines for the same product at the same cost are added to the PR, approved and converted to PO, these lines are consolidated. This results in loss of information as only one item description or comments are pulled through to the PO.

To illustrate this, I created the following example.

First, create a PR with at least two lines. I have used the 2-A3284A product and changed the description on both rows:

Purchase Requisition Entry

Continue reading “MS Connect Suggestion: On Purchase Stop Summarising PR Lines”

Cancelling a PO Line Created From a Purchase Requisition

Microsoft Dynamics GPCancelling a purchase order line which came from a purchase requisition should, one would think, be a simple task. However, prior to Microsoft Dynamics GP 2016 R2, this was not necessarily the case.

This recently came back to mind when a client, who has recently implemented Purchase Order Processing with Workflow approvals on the requisitions (PO Entry window has been customised to lock a lot of the fields) raised an issue with me about not being able to cancel a line on the PO. After writing and demoing the functionality of Dynamics GP 2016 R2 a few times recently, it took a few minutes to identify a workaround for them as the client was running Dynamics GP 2015 R2 (14.00.1016).

The problem, is that you cannot cancel the link to the requisition in the same way you would a Sales commitment. If you try to cancel by entering a Qty Canceled, you get this error:

Microsoft Dynamics GP - The quantity can't be changed because the remaining quantity doesn't satisfy the commitments for this line item

Microsoft Dynamics GP

The purchase order commitment can't be deleted; an attached sales line item is in use or is in history. Line items that weren't in use or in history are no longer committed to a purchase order.

Continue reading “Cancelling a PO Line Created From a Purchase Requisition”

Microsoft Dynamics GP July Hotfix – 2017 Mid Year Tax Update Now Available

Microsoft Dynamics GPThe Dynamics GP Support and Services Blog blog announced the availability of the Microsoft Dynamics GP July Hotfix – 2017 Mid Year Tax Update towards the end of June.

This hotfix is available for Microsoft Dynamics GP 2013 R2, 2015 r2 and 2016 R2.

While all of them have updates for the US and Canadian Payroll systems, there were three changes in the 2016 version which caught my eye:

  • Financials

    • You may not be able to view any document attachment for any OPEN Payables Document.
    • Invoice Receipt Date field added for UK installs, click here for details.
  • System

    • Scan functionality may not function with document attach

The fixes to Document Attachment are good to see, but the Invoice Receipt Date was especially interesting as it results from new legislation which came into effect on April 1st for businesses of a certain size in the UK with a duty to report on their payment practices, policies and performance. This new requirement was introduced to protect smaller businesses that suffer from late payments, which can adversely affect their cash flow and jeopardize their ability to trade.

The new Invoice Receipt Date field is available on Payables Transaction Entry (Purchasing >> Transactions >> Transaction Entry), Receivings Transaction Entry (Purchasing >> Transactions >> Receivings Transaction Entry) and Purchasing Invoice Entry (Purchasing >> Transactions >> Enter/Match Invoice).

The Doc Attach changes only effect 2016, but the new field is available in 2013, 2015 and 2016.