Get GP Year-End Support

Be Ready for 1099 Payroll, IRS Electronic Filing Changes, and More

If you need help with year-end close in Dynamics GP contact Dexpro today

• Once 1099 changes are known, the Microsoft pages will be updated and communicated through our Dexpro newsletters. 
• U.S Year-End target date: November 17, 2023
• No changes to Payroll for Secure Act 2.0
• Use this blog to help you with the IRS electronic filing changes for this year
• Microsoft Dynamics GP: 1099 Changes to expect -Get ready for Year-end 2023!!
  

Microsoft Dynamics GP Year-End Update

Estimated Release Date November 17th, 2023

 It's time to start planning for Year End! We will communicate new features and enhancements included in the Dynamics GP Year-End Update as we receive updates from Microsoft. Be sure to sign up for our Dexpro newsletters to catch all of the latest Microsoft announcements.

1. Clients printing Payables 1099 forms in Microsoft Dynamics GP. October 18.6 release all Payables 1099 forms (DIV, INT, MISC and NEC) will print with lines. You no longer need to purchase forms at year end!!
2. View 1099 information in a SmartList, ability to verify amounts and base to complete electronic filing. 2023 changes will be released soon.
3. Clients wanting to file electronically, W-2, 1099, etc. Dynamics GP does not file Payables 1099's electronically.
4. IRS FREE 1099 e-filing option- E-file Forms 1099 With IRIS | Internal Revenue Service (irs.gov)
5. There will be no changes to Payroll for Secure Act 2.0. If this is functionality you need in the product for automatically tracking of catch-up contributions for employees.
6. Fixed Assets - luxury auto depreciation changes

IRS Electronic Filing Changes

Microsoft took a survey from several Microsoft Partners to inquire about what solutions they are using to provide electronic 1099 capability for their Dynamics GP customers. Feel free to check the list of options below to find one that is a good fit for you. Hopefully, the links below will provide you with more details about these products to get you started along with contact information so you can reach out to them for additional information on functionality, requirements, cost, or even to request a demo. (NOTE: This list is in no particular order, is provided as suggestions only for you to investigate on your own and are not included under Microsoft Dynamics GP Support. You much reach out to each product for Support. Microsoft Corp does not assume any liability.) 

Microsoft Dynamics GP 3rd party solution - Greenshades:  https://go.greenshades.com/platform/tax-and-compliance/year-end-forms

Additional solutions popular among Dynamics GP users:

1099 Pro:  https://www.1099pro.com/prod1099pro.asp

1099 Etc: https://1099-etc.com/

Tax 1099:  https://www.tax1099.com/integrations/1099-excel-template

eSmart Payroll:  https://www.esmartpayroll.com/excel_form_1099misc.asp

W2 Mate: https://www.realtaxtools.com/1099software/1099software.html

Aatrix - www.aatrix.com

and more.... 

1099 'SQL VIEW' FOR SMARTLIST

Microsoft partners have been asking for a 'SQL View' for 1099 forms so users can view 1099 information in a Smartlist. Linked below is a script provided by Microsoft for a "SQL VIEW" of the 1099 table (PM00204), that will sum 1099 amounts and can be linked to Smartlist Designer, so users can verify 1099 amounts from a Smartlist. This information can be used for verification purposes, as well as a base to make an Excel file if you use any electronic filing options above and need to generate the 1099 data to a file.  Note that the IRS makes changes to the 1099 forms each year, so the below script is written for the '2022' forms.  (Please check back at the end of the year as the script will be updated for the 2023 forms, as soon as the IRS changes are made available.) In the meantime, go ahead and run it, play with it, and test linking it to a Smartlist. 

KB 4014658 --How to create a smartlist designer report using a SQL View

1099 Script for "SQL VIEW": (currently for the 2022 year forms)