MDGP 2018 R2 Feature of the Day: Exclude Items on HITB Report With Zero Quantity or Value

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The tenth Feature of the Day is exclude items on HITB report with zero quantity or value

The Historical Inventory Trial Balance (HITB) report has two new options for Dynamics GP 2018 R2; when printing the HITB report you can now decide if you want to include/exclude items with a zero quantity or value. The new options are:

  • Include Items with Zero Quantity
  • Include Items with Zero Value

These items will be excluded on the report if the options are not checked; previously, by default, these items were included. Make sure the checkboxes are unmakred to exclude the items with either zero value or quantity:

Inventory Activity Report Options

This is a good update to the HITB; I have a number of clients with large number of items which will generally have a zero quantity of stock while having other items with stock levels they on which they would want to report. Being able to exclude these will make the report usable.

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

MDGP 2018 R2 Feature of the Day: New SmartList for Deposits on Unposted Sales Transactions Has Been Created

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The ninth Feature of the Day is a new SmartList for deposits on unposted Sales Transactions has been created.

Deposits on Unposted Sales Transactions is a new favorite under Sales Transactions so you can quickly see customers that have put a deposit on a sales transaction but the sales transaction hasn’t been posted; no more searching through the sales records to see the deposits, now you have a new SmartList to view the details:

New SmartList for Deposits on Unposted Sales Transactions Has Been Created

Continue reading “MDGP 2018 R2 Feature of the Day: New SmartList for Deposits on Unposted Sales Transactions Has Been Created”

MDGP 2018 R2 Feature of the Day: Transaction Level Post Through General Ledger

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The seventh Feature of the Day is transaction level post through general ledger. This feature is a new posting option in the Posting Setup window (Administration area page » Setup » Posting » Posting); when Allow Transaction Posting is marked, a new checkbox for Post Through General Ledger Files is now available:

Posting Setup

Continue reading “MDGP 2018 R2 Feature of the Day: Transaction Level Post Through General Ledger”

MDGP 2018 R2 Feature of the Day: Vendor Document Number added to Purchasing All-in-One View

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The eighth Feature of the Day is the Vendor Document Number has been added to the Purchasing All-in-One View.

The All-in-One View is great for viewing related documents but most times the vendor document number is the one known, not the GP document number. So it has been added in the payments and credit documents columns for easy reference:

Purchasing All-in-One View

It has always been possible to filter the Invoice column based on the vendor document number, but this is a nice small addition to the window which will improve data visibility.

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

MDGP 2018 R2 Feature of the Day: Print Invoices in Functional Currency from SOP Navigation List

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The sixth Feature of the Day is print invoices in functional currency from SOP navigation list.

This new feature will allow users to print Sales Order Processing documents from the Sales Transactions navigation list in the functional currency; previously the invoices would print in the priginating currency with no option to change.

The ribbon, which allows printing, has been updated to add a Currency to Print field which allows you to toggle between Originating and Functional. The default remains as Original so that existing behvaiour remains, but this can be toggled each time to Funcational.

I am delighted to see this option introduced as it is a feature I requested back in 2014. The client this request originally came from is starting to plan their upgrade to Microsoft Dynamics GP 2018 R2 as well, so very nicely timed.

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

New GP Resource Added: Microsoft Dynamics GP Books

Microsoft Dynamics GPRather than just leaving the Microsoft Dynamics GP Book Roundup as a post, I have made it a page available from the GP Resources menu.

I will be doing my best to keep this page up to date; if I have missed any books on Microsoft Dynamics GP, please get in touch and let me know so I can add the book.

I accidentally missed the Dynamics GP 2016 Security and Field Audit book by Mark Polino and Andy Snook from the round up post, but have added it to the page.

The new GP books resource page is here.

MDGP 2018 R2 Feature of the Day: Print and E-mail Sales Order Processing Documents

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The fifth Feature of the Day is print and e-mail Sales Order Processing documents.

This new feature add a new option to print and e-mail Sales Order Processing documents at the same time. In the Sales Document Print Options window, you can now select Print Document and Send Document in E-mail at the same time:

Previously, you had to e-mail the documents and then print the remaining but now you can do both at the same time.

On the surface, this sounds like it should be a nice little time saving new feature, but I’m wondering how this ties in with print remaining documents, introduced in Microsoft Dynamics GP 2013 R2. I’ll have to wait until I can get hads on to find out.

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

MDGP 2018 R2 Feature of the Day: Option to Hide Business Analyzer for all Users

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The fourth Feature of the Day is an option to hide Business Analyzer for all users.

Two new options have been introduced in the System Preferences window (Administration area page » Setup » System » System Preferences) which allows administrators to hide Business Analyzer on both the Home Page and on Navigation List pages.

The two new checkboxes for these options are:

  • Display Business Analyzer on Home Page
  • Display Business Analyzer on Navigation List pages

These are global settings to make it easier to turn off the feature if clients are not using Business Analyzer in any of their companies.

Individual users can still choose to turn on Business Analyzer using the customize home page layout options.

System Preferences

There is a definite need to switch off the Business Analyser fact panein navigation lists (I’ve previously created a script to disable it).

Being able to globally switch it off from both the navigation lists and home page is a great addition; I don’t know of any clients who actually use Business Analyzer on either the home page or navigation lists.

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

Microsoft Dynamics GP Book Roundup

Microsoft Dynamics GPThere are a number of books available for Microsoft Dynamics GP which have been written by various people across a umber of years (although a few names crop up repeatedly). I thought it might be useful to list the books which are currently available for each version of Microsoft Dynamics GP; some of the books are only available for older versions of Dynamics GP, but the information within is still mostly relevant.

To avoid any appearence of favouritism, I have listed them in Dynamics GP version and author surname order (when multiple authors, the first listed author’s name is used).

Where there is no version in the name I have made by best guess as to which version it was written against.

Microsoft Dynamics GP 2018

Microsoft Dynamics GP 2016

Continue reading “Microsoft Dynamics GP Book Roundup”

MDGP 2018 R2 Feature of the Day: Display Vendor Hold Status

Microsoft Dynamics GPThe Inside Microsoft Dynamics GP blog has started a series Feature of the Day posts for Microsoft Dynamics GP 2018 R2 on which I am following and adding commentary. The series index for this series of posts is here.

The third Feature of the Day is display vendor hold status.

This is similar to the customer hold status implemented in an earlier version of Dynamics GP in that it provides a visual indicator of the vendor status:

Vendor Inquiry

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