- Application Services
- Cloud Services
- Your Needs
- Partner Services
Streamline Your Supply Chain
Modernize Your Manufacturing Processes
Better Project Analysis and Scheduling
One Place for All Your Project Activities
Integrated Solutions for Beverage Producers
An ERP for Your Specific Needs
Run Your Business With a Single Solution
Amplify Your Financial Visibility and Profitability
Maximize Efficiencies, Quality and Profitability
Simplify Your CRM Experience
Backbone of your Business’ Operations
Expertise to Streamline Your Transition
Find Hidden Insights in Your Data
The year-end close can be scary, but it doesn't need to be! At Enavate, we’re focused on creating an efficient and streamlined process that reduces the stress and pressure of your workflow. We’re hosting a five-part webinar series covering tips and tricks to help users be more efficient and productive in Microsoft Dynamics GP. For each, we’re putting together a blog that outlines the tips and tricks featured in each session.
In the second session, you’ll learn:
If you’d rather, you can watch the webinar outlining the tips and tricks here:
The key to a successful year-end close is to focus on what each step accomplishes and be prepared for the entire process.
To ensure you’re prepared. and everything runs smoothly during your audit, take the following steps.
Step 1: Run the Received Not Invoiced Report
This is found under Purchasing > Reports > Analysis > Received Not Invoiced Report
Step 2: Compare the total to the Accrued Purchases GL Account Balance.
Step 3 (Optional): Remove completed Purchase Orders.
You can do this by going to Purchasing > Routines > Remove Completed Purchase Orders
This can help your system run quicker if you process many Purchase Orders.
Payable Year-End Close
Closing the Payables Module is not required. Timing is important if you choose to run the year-end close process in the Purchasing module. You can’t POST any Payables transactions into the new year prior to closing the module if you want to depend on any YTD columns in SmartLists. However, you can enter transactions into batches and wait to post until after you’ve run the close process.
NOTE: If you process 1099s in GP, you do NOT need to close the Payables Module to do so. Keep in mind that YTD and LYR columns in 1099 SmartLists may not be accurate if you posted into the new year before closing the old year.
We recommend you use the print 1099 edit lists to check your annual amounts and generate your 1099s.
If you’ve posted AP Transaction into the new year before closing, Enavate can assist you with running SQL scripts to recalculate the YTD balances. Just open a support case via email at Support@Enavate.com or our portal https://enavate.microsoftcrmportals.com/ for assistance.
If you do wish to close the Purchasing Module:
Navigate to Purchasing > Routines > Year-End Close > Close Year
Sales Order Processing (Optional)
Sales > Utilities > Reconcile – Remove Sales Documents
Most of the SOP Transactions move to history automatically. However, some may not, such as orders where only a portion was transferred, and the rest canceled.
Step 1: Run Remove Completed Documents to move these stragglers to history.
Step 2: Choose Print Report Only to see what documents will be affected prior to running the process.
NOTE: A SQL backup is highly recommended before running this process.
Sales Module Year-End Close
Navigate to Sales > Routines > Year-End Close > Close Year
Closing the Sales Module is NOT required. If you choose to close the Sales Module, Year-to-date balances are recalculated on some Inquiry windows and SmartList fields.
Before closing the Inventory Module or posting any Inventory Transactions into the new year, you’ll want to:
Inventory Year-End Close
Closing a year transfers all summarized current-year quantities (cost and sales amounts) to transaction history for the items for which you’ve been keeping a summarized Sales History. The Quantity Sold field for each item is set to zero. These steps also update the amount in each item's Beginning Quantity field to the Quantity on Hand field at each site. You can also choose to update the Item’s Standard Cost by checking that box.
It’s required to close the Fixed Assets Module prior to running depreciation in the first period of your new fiscal year calendar.
Step 1: Enter and post all transactions for the year, including Asset Additions, Changes, Transfers and Retirements.
Step 2: Be sure Depreciation is posted through the last day of the Fiscal Year.
Step 3: Create Fixed Asset GL transactions using the GL posting routine.
When processing GL Posting for Fixed Assets
Step 4: Post GL batch.
To avoid having your GL differ from your FA Module, we recommend using the process button without any restrictions to populate the given section with anything that hasn’t been posted to the GL yet. After you have reviewed the results, you can then use restrictions to isolate entries that you do not want to post to the GL and save them in a separate batch.
Fixed Assets Year-End Close
Perform an SQL Backup before these steps:
Step 1: Navigate to Financial > Routines > Fixed Assets > Year-End
Step 2: Choose a book from the Available Books column then insert the book into the right-hand side of the window.
Step 3: Click on Continue.
Step 4: Print and Save the resulting report.
Before finishing the Year-End process for your General Ledger, ensure the Accounts and Transaction boxes are checked ON under Maintain History.
If you don’t maintain the history, you may not be able to access the fiscal year after it’s closed.
Allow Posting to History should also be checked.
Prior to closing the Financial module, arrange with your IT team to run full SQL backups on all company databases as well as the Microsoft Dynamics database. This is essential to ensure nothing is lost if failure occurs during the year-end Close process.
All users need to be logged out during the backup to make sure all data is captured during the backup. An optional backup is recommended after you close the year.
Check GL Account Posting Types
Account Posting Types determine how balances will roll forward into the new year.
They are found by navigating to Financial > Cards > Accounts
To check posting types you can, create two SmartLists— one for Balance Sheet Accounts and one for P&L Accounts. If all accounts are set to the correct Posting Type, then no results will be returned when you run the SmartLists. Once these SmartLists are created and saved as Favorites, they’ll’ remain in the system until they’e removed.
To learn more about setting up SmartLists, watch our first webinar on GP Tips and Tricks.
Unit accounts will show up with a Balance Sheet Type. Microsoft added a box in the Unit Account Card where you can choose to clear the balance after the year-end Close to avoid bringing a balance over into the new year.
Note: You’ll need to set up your new fiscal year prior to closing the General Ledger. To set up the new fiscal year, navigate to Administration > Company > Fiscal Periods.
Changes to Your GL Account Balances
Understanding what will happen when you finish your year-end Close for the General Ledger is important. All your GL account balances with the balance sheet posting type will roll forward into the new fiscal year, and all your GL account balances with a profit loss posting type will roll into Retained Earnings.
Year-End Closing Options
Navigate to Financial > Routines > Year-End Closing
Here, you’ll see two checkboxes: Remove Unused Segment Numbers and Maintain Inactive Accounts. You don’t need to worry about the first of these options but Maintain Inactive Accounts should be addressed.
Maintain Inactive Accounts
With Budget Amounts
All Inactive Accounts
Close the Year
Financial > Routines > Year-End Closing > Close Year
This can take anywhere from a few minutes to much longer. Remain patient through the process and do not force quit GP or SQL while this is running without contacting support first.
Lastly, print the resulting report to your screen to check to make sure the entry balances. If it does, be sure to print to PDF or to a file as this report cannot be reprinted. If the report does not balance, you will need to do some research to find out why – we can help! Email Support (email@example.com) or open a case from our portal.
Here are some general best practices we recommend that don’t directly relate to year-end close processes.
There are many different approaches to maximizing your GP efforts. You can always speak with your Account Manager about specific needs and develop the best path forward.
Upgrading to the latest version of Microsoft Dynamics GP gives you peace of mind knowing your investment is fully supported by Microsoft. This cost-effective option allows you to leverage the latest out-of-the-box reporting and smart analytics tools to make better decisions. We’ll help you build a path forward to maintain your current solution, enhance or customize your solution as your needs change or build a migration plan at your own pace.
Available to current Enavate Partners only— contact your Account Manager to discuss discounts for adding additional users.
Make your GP investment work for you by leveraging Enavate’s add-on solutions or third-party solutions (ISVs) that make your GP solution even more powerful:
In addition to the above, many third-party solutions can help you save time and money. Contact your Account Manager to learn more about all the available solutions that can enhance your GP effort.
If you’re considering an upgrade, contact your Account Manager or firstname.lastname@example.org for more information.