MDGP October 2019 Release Feature of the Day: Reprint Pay Statements

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

The eleventh Feature of the Day is Reprint Pay Statements. Another Payroll feature has been added, whereby you can reprint an entire group of pay statements as duplicates. This is added to the Payroll Reprint Journals report options.

Select Reprint Payroll posting journals –> Reprint Pay Statements. You select an audit trail code on the report option and the duplicate pay statements will print for all the payments made in that check run.

Reprint Payroll Posting Journal Report Options

Continue reading “MDGP October 2019 Release Feature of the Day: Reprint Pay Statements”

MDGP October 2019 Release Feature of the Day: Payroll Option to exclude Additional Withholding Amount

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

The tenth Feature of the Day is Payroll Option to exclude Additional Withholding Amount. With this change, when you build the check file, you have the option to include or exclude the additional withholding for Federal, State and Local tax amounts.

By default, any existing build check default ID will have these settings automatically marked. However, you can unmark the settings and save them with the build check default ID and they will be remembered in the future when you select that default ID.

Now, you can do special check runs without having to manually update employees who have setup additional withholding amounts.

Build Payroll Checks

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”

Microsoft Dynamics GP 2018 U.S. Year End Update Released (Includes Critical VAT Daybook Fixes)

Microsoft Dynamics GPDon’t be fooled by the name; the Microsoft Dynamics GP 2018 U.S. Year End Update includes other fixes, some of which are critical to clients running the Vat Daybook module.

This fix has all the usual stuff for the Payroll (US) module which you can read about here.

The other good stuff in this version is:

  • System
  • VAT Daybook
    • Purchasing tax amounts from GL entries are subtracting from boxes 2 and 7, instead of adding to boxes 4 and 7 on the VAT Summary.
    • Sales returns and credit memos are not deducting total taxable amount from box 6 on VAT return, and voids from box 1 and box 6.
    • Purchasing returns & credit memo’s, voids are not deducting total taxable amount from box 7 on VAT return, and invoices not updating box 4.

The Microsoft Dynamics GP hot fix is available from: Customer Source lock or PartnerSource lock.

The VAT Daybook fixes have also been rolled back into Microsoft Dynamics GP 2016 (but no earlier): Customer Source lock or PartnerSource lock.

MDGP 2018 R2 Feature of the Day: Mass Update Master Records from 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 twenty-second Feature of the Day is mass update of master records from navigation lists.

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

Since navigation lists were introduced in Dynamics GP 10, they have grown increasingly common in usage, in particular new clients; there are some navigation lists which rarely see use, but ones for master records and transactions seem to be used a lot. There have been a few enhancements to ists over time, and I welcome even more being introduced, so it is good to see this feature.

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

MDGP 2018 R2 Feature of the Day: New Totals Print on the Payroll Check Register report for FICA

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 seventeenth Feature of the Day is new totals print on the Payroll Check Register report for FICA.

This feature adds totals to the print of the Payroll Check Register report for FICA. A new Total FICA Owed, Total Employee FICA owed, and totals for both FICA Medicare and FICA Social Security all print on the payroll check register report:

Payroll Check Register report for FICA

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

MDGP 2018 R2 Feature of the Day: shared maximum benefit and deduction code in Payroll.

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 sixteenth Feature of the Day is shared maximum benefit and deduction code in Payroll..

Thsi feature is a shared maximum benefit and deduction code in Payroll. A new Ded/Ben Shared Limit Setup window allows you to setup a calendar year maximum for multiple benefit and deduction codes. When the check run is processed, it will look at the year-to-date amount and compare it to the calendar year max in this new window.

Ded/Ben Shared Limit Setup

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

MDGP 2018 R2 Feature of the Day: Start Date and End Date for Each Pay Code

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 fifteenth Feature of the Day is a new Start Date and End Date for each pay code.

This feature adds a new Start Date and End Date for each pay code in the Employee Pay Code Maintenance window. This is used when building the check run as to whether to include the selected pay codes; so if the check run is before the start date or after the end date, that pay code will not be included.

Employee Pay Code Maintenance

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

MDGP 2018 R2 Feature of the Day: Duplicate Check Numbers Option Extended

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 fourteenth Feature of the Day 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
Chequebook Maintenance

I don’t recall this ever coming up before, so I actually thought the Bank Transaction Entry and Miscellaneous Checks window already did this. That said, we don’t have that many clients using the standard Bank Rec window and none would use the Miscellaneous Checks window as virtually all payments in the UK are via EFT.

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

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”