GP Year-End Update Product Releases

By Bryan Wilton, President

Information on GP year-end update product releases has started to become more solid now as we get close to mid-November. The dates as we know them now are as follows:

  • GP 2013 – this week
  • GP 2015 – will follow soon after the 2013 year-end update is released
  • GP 2016/R2 – expected around 12/1. Remember 2016 will not have a separate year end update and an R2 update; they will be combined into one so you will only have to apply one update to get both the year end update and version R2 if you are on GP 2016. Another benefit of upgrading to 2016/R2: GP will now print a W2 with lines.
  • GP 2010 and earlier – there will be no year-end or other updates….time to upgrade! Contact Lori Ritzer if you would like to get your upgrade scheduled before year end.
  • Canadian Payroll – should be available around middle of December. If you also have US payroll, you can wait until the Canadian payroll year end is released and apply both at the same time from one file.

Most have probably heard about the new overtime rules the DOL signed into law this past year? Those rules become law on December 1, 2016 and it looks like the Overtime Rate Manager in Dynamics GP will handle the calculations for you. This module is free but let us know if you need any help getting it setup and configured. Side note on this module — there are 3 payroll features which are part of the core GP system, called Core Payroll Extensions. They do require a separate install so lots of payroll users tend to miss these modules. The 3 modules included with GP are:

  • Overtime Rate Manager
  • Deductions in Arrears
  • Payroll Integration to Payables

Let us know if you have any questions about these 3 payroll modules.

Now, back to payroll updates. Just a reminder the 2016 form changes are as follows:

  • W2 – no form changes
  • W3 – no form changes
  • 1099-Int – small change
  • 1099-MIsc – small change
  • 1096 – does have a change as a result of the Int/Misc form changes
  • Electronic Filing W2 (EFW2) – no change but is now due by January 31st.

And there is a law change (Path Act) to Fixed Asset depreciation limits so if you are running the Fixed Asset module for tax calculations, you’ll want to make sure to apply the year end update.

Finally, if you would like to attend one of our year end closing classes, ($195) all are being held online this year. Register now


Information on Payables 2016 Year End

By Bryan Wilton, President 

Payables 2016 year-end information continues to trickle in, but more frequently now. There are changes to the 1099-INT form used to report interest income. This form is less popular in the 1099 family, but if you are required to issue one, you’ll need the 2016 year-end update applied to properly print the 2016 form.

The same is true with the 1096 Transmittal (summary) form used to submit your 1099 forms. The 2016 layout has changed slightly as well, but will print correctly after applying the 2016 year-end update.

Although there is no new functionality in the 2016 year-end update around how the payables module is closed out, there are several new enhancements to allow you to view and edit 1099 data (if you’re on GP 2013 or later).

For more information on the year-end processing for Dynamics GP, plan to attend our year-end close out class which shows you how to successfully close out your system for the year and make ready the new year for processing. Watch for an email soon where you can register for the class.

Dynamics GP Year-End Updates

We are beginning to think about year-end now that October is here! Hard to believe the year is almost over. A few things have trickled in from Microsoft regarding GP year end updates:

As of now we know the following details:

  • Seems to be no apparent W-2 or W-3 form changes
  • No EFW2 (Electronic Filing) changes, however the new deadline for submitting W2’s is now January 31, not February or March like it has been for decades.
  • Looks to be a few form 1096 form changes
  • Payables 1099-Int and 1099 Misc. changes (small change, still under review more detail later)
  • And ACA information is not yet in final form for 2016. Remember if you are using Dynamics GP for your ACA reporting, Microsoft does NOT supply the ACA electronic file. You will need either Greenshades or Integrity Data to file the 1095 data electronically. Of course the November election results could alter ACA reporting for future years.

Management Reporter and Professional Services Tools Library Fiscal Year Change

Written by Lorna Link, GP Product Manager

An interesting find from Brian Bell, GP Implementation Consultant – A client just reset their GP fiscal year end from 3/31 to 12/31 and found that Management Reporter doesn’t follow the same rules as GP.

We used a 9 month stub year GP’s fiscal year label went from 1996 to 1995 for the oldest historical year.  Management Reporter CALCULATES its fiscal year label from the last date of each fiscal year, so it’s using 1996 still as the oldest fiscal year and not using GP’s fiscal year labels at this point.

You can modify the FiscalCalendarView by running the following script against the DDM database:

–Script start

ALTER VIEW [dbo].[FiscalCalendarView] AS SELECT TOP 100000 RANK() OVER(ORDER BY PER.OrganizationId, FY.Id, PER.Starts, PER.Ends) as PeriodSequenceNumber,
RANK() OVER(PARTITION BY, PER.OrganizationId ORDER BY PER.Starts) as PeriodNumber, PER.Id, PER.Starts as PeriodStart, PER.Ends as PeriodEnd, FY.Starts as YearStart, FY.Ends as YearEnd, CAST((SELECT MIN(Years.Name) FROM FiscalYear Years WHERE Years.OrganizationId = FY.OrganizationId) + DENSE_RANK() OVER(PARTITION BY PER.OrganizationId ORDER BY FY.Starts) – 1 AS Int) As FiscalYear, IsHistorical, PER.IsClosed, PER.OrganizationId FROM Period PER INNER JOIN FiscalYear FY ON PER.FiscalYearId = FY.Id AND PER.OrganizationId = FY.OrganizationId ORDER BY PER.Starts GO

–Script end

Note that if you have to re-create the DDM database for any reason, you will need to re-run the script provided above.

Visit our website to learn more about Microsoft Dynamics GP and our full product line.

Contact InterDyn BMI today!

Top 6 General Ledger Enhancements in GP 2013

By Lorna Link, GP Product & Project Manager for InterDyn BMI

There are some really nice General Ledger enhancements that were released with the GP 2013 product! I am especially fond of the change to the GL year-end close process screen and the fact that the batch approval information will now be a stored field after the post!

1. Clear balances of unit accounts during year-end close process

You can mark the Clear Balance During Year-End Close option in the Unit Account Maintenance window to clear the balance for the unit account during the year-end close process. If this option is unmarked, the balance for the account is carried forward to the next year during the year-end close process.


This field marking did not appear to copy with the mass modify functionality with BETA product.

2. Keep inactive accounts with zero balances during the year-end close

In the Year-End Closing window, you can specify how to handle inactive accounts with zero balances during the year-end close process. You have three options:

  • Delete all inactive accounts with zero balances.
  • Keep all inactive accounts with zero balances.
  • Delete inactive accounts with zero balances that have no budget amounts and keep inactive accounts with zero balances that have budget amounts.


3. View status during the year-end close

After you choose the Close Year button in the Year-End Closing window, a status bar appears, displaying the steps that are completed during the year-end process.


4. View net change and period balances for unit accounts at the same time

You can use the Unit Account Maintenance window to view period balances and net change balances for the selected account at the same time.


5. General Ledger batch approval information is stored

You have the ability to track batch approval information for a General Ledger general journal batch in addition to the posting information that is kept. The approval user (APRVLUSERID) and date (APPRVLDT) are now stored in the Year-to-Date Transaction Open (GL20000) and Account Transaction History (GL30000) tables. You can use Smart List Builder, Excel Builder or a Reporting Services report to add those new columns to a report or inquiry.


6. Reconcile subledgers to General Ledger

You can use the Reconcile to GL window to generate a Microsoft Excel spreadsheet that can help you match transactions in General Ledger with the originating transactions in Payables Management, Receivables Management, Inventory and Bank Reconciliation. The reconcile routine will not change data automatically, but helps you identify those transactions which may need to be corrected.


  • The process is now tracking a reconciliation number and stores a path to the reconciliation worksheet.
  • The reconciliation number is not ‘reused’.
  • The setup and resulting summary reconciliation information is stored in the GL40401 and GL4002 tables.

Learn more about Microsoft Dynamics GP 2013. Microsoft Partner, InterDyn BMI holds a Gold Competency in Enterprise Resource Planning.