Hands On With Microsoft Dynamics GP 2018 R2 New Features: New Sort Options in Sales Order Processing Item Inquiry Window

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The twentieth new feature is New Sort Options in Sales Order Processing Item Inquiry Window. The Sales Order Processing Item Inquiry window has a new Sort By option available; this lets users quickly find the information they are looking for because now they can sort, either ascending or descending, by the following fields:

  • Document Number
  • Document Type
  • Item Number
  • Document Date
  • Customer ID
Sales Order Processing Item Inquiry

This feature builds on the new sort options introduced to Payables and Receivables, by making the aame options available in the Sales Order Processing Item Inquiry window. This is a good addition as users are often asking the ability to sort by date; I hope to see it introduced in additional windows in future versions.

Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

Hands On With Microsoft Dynamics GP 2018 R2 New Features: Mass Update Master Records from Navigation List

Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

The nineteeth new feature is Mass Update Master Records from Navigation List. This feature today is the ability to mass update a group of master records from the Navigation Lists; you can now inactivate and reactive multiple records at the same time for the following master record types:

  • Accounts
  • Checkbooks
  • Customers
  • Vendors
  • Items
  • Employees
  • In addition, the vendor navigation list allows you to mass update the temporary status; a visual indicator quickly lets you know the status of these records:

    Vendors navigation list

    With one caveat I like this new feature. Since they were introduced in Microsoft Dynamics GP 10, clients have been making more and more use of navigation lists; more interactivity can only be a good thing and the indicators make it easy to see the status of creditors.

    My caveat, is the presence of the option to toggle Temporary status. This is used by almost no clients and is very risky as temporary creditors can be deleted, regardless of history.

    Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Letter Writing Assistant in Web Client

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The eighteenth new feature is Letter Writing Assistant in Web Client. This feature adds one of the few remaining areas that wasn’t previously accessible to the web client.

    The Letter Writing Assistant is available via SmartList; for example, run a Vendors SmartList and the click on the Word button and click Prepare a Creditor Letter:

    SmartList prepare a Creditor Letter

    Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Letter Writing Assistant in Web Client”

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: SmartList Designer Favourites in Navigation List

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The seventeenth new feature is SmartList Designer Favourites in Navigation List. This feature will see favourites created for SmartList Designer SmartList objects added to the SmartList Favorites navigation list.

    As an example, I have created a Vendor EFT SmartList object in SmartList Designer and saved a couple of favourites:

    SmartList - Vendor EFT

    Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: SmartList Designer Favourites in Navigation List”

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Option To Not Display Inactive Checkbooks in Lookup

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The sixteenth new feature is Option To Not Display Inactive Checkbooks in Lookup. This feature allows users to hide inactive checkbooks when performing a lookup.

    When doing a lookup on Checkbook ID, click the blue bar above the list and select Exclude Inactive Checkbooks:

    Checkbooks

    Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Option To Not Display Inactive Checkbooks in Lookup”

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Checkbook ID Defaults on Check Batch

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The fifteenth new feature is Checkbook ID Defaults on Check Batch. This feature means that when you create a new EFT payment batch in Payables Management, the Checkbook ID field will be automatically populated from Payables Management Setup:

    Payables Batch Entry

    Again, this is a small feature, but will save users time selecting the chequebook when creating a payment batch. It never really made sense that the chequebook would default in on a cheque batch, but not on an EFT one. This has now been remedied so both types of payment batch work the same way.

    Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Duplicate Check Numbers Option Extended

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The fourteenth new feature is Duplicate Check Numbers Option Extended.

    This feature sees the Checkbook Maintenance (Financial area page » Cards » Chechbook) option to allow or not allow Duplicate Check Numbers extended to other windows. This means that if this option is not marked, duplicate checks are not allowed in these three windows. Previously, this option only applied to Payables checkbooks but now it includes:

    • Bank Transaction Entry
    • Payroll Manual Checks
    • Miscellaneous Checks
    Checkbook  Maintenance

    Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Duplicate Check Numbers Option Extended”

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Email Customer Statements

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The thirteenth new feature is Email Customer Statements. This feature of the day allows a single statement to be emailed to a customer direct from the Customer Maintenance window (Sales area page » Cards » Customer) using the Email button on the action pane:

    Customer Maintenance

    Continue reading “Hands On With Microsoft Dynamics GP 2018 R2 New Features: Email Customer Statements”

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Increase Dynamics GP Password Maximum Length

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The eleventh new feature is Increase Dynamics GP Password Maximum Length. This feature sees the maximum length of user passwords increased from 15 to 21 characters:

    User Setup

    Any increase in the maximum length of passwords is to be welcomed, but, seeing as this change required a database schema change to increase the SQL field length from 15 to 21, I am a little surprised that the new length is only 21 characters.

    Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index

    Hands On With Microsoft Dynamics GP 2018 R2 New Features: Exclude Items on HITB Report With Zero Quantity or Value

    Microsoft Dynamics GPThis post is part of the Hands On With Microsoft Dynamics GP 2018 R2 New Features series in which I am going hands on with the new features introduced in Microsoft Dynamics GP 2018 R2 (which was released on the 2nd October). I reblogged the new features as Microsoft announced them along with some commentary of how I thought they would be received by both my clients and I. In this series, I will be hands on with them giving feedback of how well they work in reality.

    The tenth new feature is Exclude Items on HITB Report With Zero Quantity or Value. This feature adds two new options to the Historical Inventory Trial Balance (HITB) report. 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 unmarked to exclude the items with either zero value or quantity:

    Inventory Activity Report Options

    When I first read this feature of the day announcement, I thought it would be a good addition. However, now that I’ve been hands on with it, I’m not so sure. Initially, I’d misremembered what the HITB showed; it is basically a report which shows movement of stock. The report I was thinking of, is the Stock Status report and it already allows you to filter out zero quantities or values.

    Having played around on Fabrikam, I can’t actually see how excluding items would be useful from the HITB report; when running a Trial Balance, you’d want to see all transactions.

    Click to show/hide the Hands On With Microsoft Dynamics GP 2018 R2 New Features Series Index