New Year, Smarter Work: Get 1 Month Free Copilot | Now $21/User.

February 3, 2022

How-To Process 1099s in Dynamics GP

During the tax season it is important to know how to look up 1099 amounts, correct them if needed, and generate the report. The IRS has changed the 1099s format this year so be sure to use the latest version. For further questions on this update, or to make sure you have updated correctly, contact support@BondConsultingServices.com

To review the 1099 vendor amounts, you can use the Vendor 1099 Information report. The report can be found in the vendor lists window under Reports > General or within the vendor card under Report > Vendor 1099 Information. This report includes all 1099 information for the vendors that been setup using the IRS 1099 Form-box tables.

If you do not want to run a report, another option is the Vendor 1099 Statistics window. To access this window, open the vendor card and under the Navigate menu select History > 1099 Statistics.

Within the Vendor 1099 Statistics window you will have an overview of the 1099 amount totals for the selected vendor.

If you need to correct any 1099 values, you would need to update the vendor ledger entries. Please find the steps below:

  1. Navigate to the vendor list and open the vendor you need to correct.
  2. Select Vendor > Ledger Entries

  1. In the ledger entries, you can scroll over to the right where you can find the IRS 1099 Code and IRS 1099 Amount. Here you can update those values as needed so the report can get updated.

 

Once all is correct, you can run the 1099 report by following the steps below.

  1. In the Global Search enter “Vendor 1099 Nec” and select the option in red below.

(NOTE: There is a new version of 1099 NEC for 2021 that is for three in a page.)

  1. Enter the Calendar Year you are running the report for and then select the destination of the report.

The 1099 report will then generate and you can confirm that it aligns with the preprinted forms that you have. For further inquiries about this procedure or other aspects of Dynamics GP please contact support@BondConsultingServices.com

 

Share On: 

Other articles

Why Distribution Hand-Offs Break (and How Connected Operations Fix Them)

Jennifer Ryan

|

December 18, 2025
Inside distribution companies, most problems don’t come from bad people or broken intentions. They come from gaps in the hand-offs between teams.As a Controller, I used to think our issues…

Unlocking Insights: Power BI Integration with Dynamics 365 Business Central

Joel Trinidad

|

December 16, 2025
As businesses increasingly rely on data to drive decisions, Microsoft continues to enhance the synergy between Dynamics 365 Business Central (BC) and Power BI. With the release of Business Central Version 26, users now…

The Spreadsheet Trap in Distribution: Why You Lose Control Without Realizing It

Jennifer Ryan

|

December 11, 2025
Let me start with a confession: I love a good spreadsheet. They’re flexible. Fast. Familiar. Elegant.But here’s the problem no one talks about: Spreadsheets eventually become the system. And that’s…

How to Connect Power Pages & D365 Customer Engagement for a Seamless Self-Service Experience

Marisa Mini

|

December 4, 2025
Power Pages for Customer Service, Field Service, and Sales PortalsCreating a seamless, modern customer experience starts with reducing the back-and-forth. If your customers (or vendors, partners, applicants, members, etc.) still…

How to Tell if Your Distribution Business Has Outgrown Its Systems

Jennifer Ryan

|

December 1, 2025
As a former Controller inside a fast-moving distribution business, I learned this lesson the hard way: You don’t realize your system is breaking until growth exposes every weakness.It doesn’t happen…

Why Microsoft Killed Social Posting (And Why SMBs Should Care)

Jackie Gant

|

November 25, 2025
When Microsoft quietly pulled the plug on social posting in Dynamics 365 Customer Insights late last year, few in the small to mid-sized business (SMB) space raised an eyebrow. After…