With the release of Microsoft Dynamics GP 2018 R2, users can specify whether a Monthly or Bi-Monthly recurring batch should end on the last day of the month in Payables, Receivables, and Inventory Management. When marked, it will automatically set the posting date to the last day of the month. So if the batch is posted at the end of April, the next posting date would be set to May 31. This is great because before (and without the box checked) it would default the posting date to May 30.  

In prior versions of Microsoft Dynamics GP, the next posting date associated with a Monthly batch frequency defaults to 30 days from the previous posting date.

Similarly, the next posting date associated with a Bi-Monthly batch frequency defaults to 60 days from the previous posting date.

Important Note: The first time a user enters transactions associated with a batch marked to 'Use the last day of the month': The 'Document Date' associated with those transactions will default to be the 'GP User Date' (lower left hand corner of Microsoft Dynamics GP). As such, if users want the 'Document Date' to match the 'Posting Date' they will need to update the 'Document Date' field appropriately in the Transaction Entry window. For every recurrence after the first posting: Microsoft Dynamics GP will automatically update the transaction 'Document Dates' to match the 'Posting Date' associated with the recurring batch.

The 'Use last day of the month' checkbox was added underneath the Frequency field in the Payables Batch Entry window. To open the Payables Batch Entry window: on the Microsoft Dynamics GP menu, point to Transactions, highlight Purchasing, and click on Batches.

Note: If the Use Last day of the month is grey in the Payables Batch entry window, verify you have the latest build of Mekorma installed.

The Use last day of the month check box was added underneath the Frequency field in the Receivables Batch Entry window. To open the Receivables Batch Entry window: on the Microsoft Dynamics GP menu, point to Transactions, highlight Sales, and click on Receivables Batches.

The 'Use last day of the month' checkbox was added underneath the Frequency field in the Inventory Batch Entry window. To open the Inventory Batch Entry window: on the Microsoft Dynamics GP menu, point to Transactions, highlight Inventory, and click on Batches.

Note:

  • The 'Use last day of the month' option is available only when Monthly or Bi-Monthly Frequency is selected.
  • When the 'Use last day of the month' option is marked for a Monthly recurring batch, the Posting Date will be the last day of each month (EOM).
  • When the 'Use last day of the month' option is marked for a Bi-Monthly recurring batch, the Posting Date will be the last day of every other month (EOM).
  • If the field 'Use last day of the month' is disabled when you choose Monthly or Bi-Monthly Frequency, verify your posting setup.  Choose Microsoft Dynamics GP, select Tools, choose Setup, then select Posting, and Posting.  Select a Series and Origin.  If your Posting Date From field is set to Transaction, then the 'Use last day of the month' field is disabled.

Enjoy!!

For more detailed documentation on this new feature and others with the Release of Microsoft Dynamics GP 2018 R2, please check out our Microsoft Dynamics GP 2018 R2 New Feature Blog Series.


Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP