Tribridge Connections

A Technology, Cloud Solutions & Industry Expertise Blog

Preparing for Year End in Microsoft Dynamics SL

Published: December 02, 2016
Paulette St George is a Senior Technical Support Consultant at Tribridge. Read More

This blog is part of our Customer Care series, where our experts address technical implementation and service questions across the Tribridge product portfolio to assure that customers have the support they need to optimize their solution most effectively and efficiently.

We are now officially in the Holiday season which means the end of this year is near. Many, if not all of you, are making preparations for the close of the fiscal and calendar year.  

Today, I’ll provide guidance on procedurally closing the year in Microsoft SL, as well as information regarding software updates that may need to be applied to your system.

Closing a Month vs. the Year

When you close the year, SL is doing much more than when it closes a month. Closing the year sets the current year and period to the first period for all modules as they are closed. In GL, it will also establish the beginning balances for the asset and liability accounts, set zero beginning balances for all income and expense accounts, as well as use the previous year’s net income closing to update the retained earnings account.

Many of the exact same functions will be performed in all other sub modules like AR and AP for Customer and Vendor Balances/History as well. One exception though is that the Project Controller module has its own closing screen. It is separate from the Closing screen in GL, but it too performs VERY similar functions for project balances.

Important to note, you do not have to close the accounting period for all modules at the same time. You can close some modules while leaving others open for remaining activity. For example, you can close the AR module and begin a new period while holding the AP module open for the previous year. The exception to this is the General Ledger, which cannot be closed ahead of the other modules.  

Lastly, you will want to be aware of your Hard Close Settings in GL Setup (or other 3rd Party ISV Hard Close solutions) and how to work with and around them once the year is closed. It’s important to know these settings so you can post data accordingly.

Here are some key steps to help you plan and complete your year end close:

  • Make a backup of the database that can be restored, if needed.
  • Complete the posting and closing procedures for all modules just like you would for each month including: verification that all module batches and transactions are released and posted, making a point to look for “stale” batches and address them as needed; if allocations are leveraged, ensure that batches have been generated and posted; run the GL Trial Balance and Detail General Ledger reports to verify accuracy of account balances as well as balancing to sub modules; print and review financial statements.
  • After verifying the accuracy of your reports and adjustments, the year-end closing process is ready to be run.
  • After completing the year-end closing process, you can back up the database again. As well, you will want to ensure your beginning balances rolled forward and P&L accounts reset to 0 for the new fiscal year; signifying that the close process completed correctly.

2016 Year End and Tax Updates

As of mid-November, it was advised that there will be no published 2016 year end updates for Microsoft Dynamics SL. If there is a change and Microsoft creates a last minute release, you can find the latest information via Microsoft CustomerSource. We will also update this blog accordingly.

You can still expect to get:

  • The Quarterly PR Tax schedule/rates/settings for 2017

The following versions of SL are covered for year end updates:

  • Microsoft Dynamics SL 2011 FP1, SP2, & SP3

  • Microsoft Dynamics SL 2015, CU1 & CU2

(Note: there is a hotfix that is required for SL 2015 CU1 to accommodate correct functionality of FED9 settings. Customer Care can assist in getting this installation scheduled. More information here.)

Additional Resources

Check lists provided by Microsoft for closing SL Modules:

Information from Microsoft on project series closing errors, resolutions and troubleshooting:

Main Stream Support for SL 2011 ended July 2016, consider upgrading today.

All Support for SL 7.0 ends October 2017, check out the new features in SL 2015.

As always, please reach out to us for help preparing for year end in Microsoft SL. Tribridge will host a webinar on December 13th for our customers: 411 on Dynamics SL Year-End Close. Register today for guidance on best practices for closing projects, orders and financials as you transition into 2017.  Also, you will want to check out our recent blog, 6 Common Questions with Closing the 1099 Year in Microsoft Dynamics SL, for additional year end help. 

Share Your Thoughts With Us

Load more comments
Thank you for the comment! Your comment must be approved first