In Part 1 of a 2-part series, UG Expert & Microsoft MVP, Kelly Gustafson shares how to properly set up 1099 Vendors in Dynamics 365 F&O. As this is th…
As the new year begins, many organizations are tasked with organizing, assigning, and completing end-of-year tasks to work through the year end close.…
In this Community Summit North America 2022 News Desk, Thomas Ajspur, CEO, Enavate, describe the company's unwavering passion and commitment to suppor…
In this News Desk interview, Laura Pfohl, VP, Delivery and Client Engagement, explains her role in assisting clients with their journey in modernizati…
In this Community Summit North America 2022 moment, Mr. Ron Summers, President, Tiguana LLC, demonstrates how to export various tables into the Azure …
Corey Bakhtiari, Global Director of Programs and Product Development, Argano, defines compliance within the context of Dynamics 365 Finance and Operat…
During this session, we will demonstrate how to electronically sign PO PDF documents without downloading, printing, scanning, and sending to the appro…
Have you ever had a question you wanted to ask a Microsoft Most Valuable Professional (MVP) but didn't have the opportunity? Now you do! Join this ses…
John Brennan, Manager of Managed Services, sa.global, describes the importance of soft skills in IT. Specifically, Brennan discusses the importance of…
Corey Bakhtiary, Director of Programs and Product Development, Argano, highlights the three key principles in securing the Microsoft ecosystem: protec…
This probably sounds like a very common scenario that you have run into:
A company hires a contractor or freelancer to work for them - it could be a management consultant, someone who paints the exterior of the office building, or a landscaping professional - in any case, these individuals need to be set up as a 1099 Vendor in your ERP system.
When creating a 1099 Vendor in Microsoft Dynamics 365 F&O, navigate to Accounts payable > Vendors > All vendors.
💡QUICK TIP: The Vendor list can also be reached by navigating to Procurement and sourcing > Vendors > All vendors.
Now, from the All vendors list page, click the New button which will start a new Vendor record.
If the 1099 Vendor is an individual, you can set the Vendor type as Person instead of Organization. The organization is the default, so this field will have to be selected manually. By doing this, it allows you to filter by Vendor type and enter first and last names instead of one field for a Vendor name.
A Vendor record for Vendor type Person
The only required fields for a Vendor are Name, Group, and Currency. You may notice that the First, Middle, and Last name fields are all showing as required. Once one of them has content, the others will no longer show as required.
Other beneficial fields to have populated on the Vendor record include:
Addresses
Contact information
Terms of payment
Method of payment
Any relevant Financial dimension information
Anything beyond these fields and the fields specific to the 1099 in the next section are additional and while they provide value, are not necessarily required.
Tax 1099 Fields on a Vendor
As you scroll through the FastTabs on a Vendor record, there is a FastTab called Tax 1099. This is where all the 1099 information lives for a contractor.
The Tax 1099 FastTab provides additional information for Vendors that act as Contractors
In the first section called Tax 1099 options, there are three flags.
Report 1099
W-9 received
Check for W-9
The Report 1099 flag, when set to Yes, will show all transactions for that Vendor in 1099 reports.
W-9 Received is a check that allows users to filter on Vendors where a 1099 has not been received.
Check for W-9 will alert users to check for a W-9, but only if the parameter Check for W-9 form is selected in Accounts payable parameters.
Check for W-9 form is selected in Accounts payable parameters
Once that parameter is enabled, and the Check for W-9 field is selected on the Vendor record, an alert will let the user know to ask the vendor for a W-9 at invoicing.
Alert that says, “A W-9 form is missing for this vendor invoice account: US-103. You may still post the invoice, or you may hold it while you wait for a W-9 form for the vendor.”
Other fields on the Tax 1099 FastTab on the Vendor include:
FATCA filing requirement
Federal tax ID – the tax ID
Tax ID type – dropdown of applicable tax ID types
Employer Identification Number
Social Security Number
Individual Taxpayer Identification Number
Adopted Tax Payer Identification Number
1099 Box – dropdown of applicable 1099 form types
Foreign entity indicator – when the organization is owned outside of the US
Second TIN – selected when notified of a second Taxpayer Identification Number
Name to use on the 1099 – dropdown including records:
Vendor name
Doing business as (DBA)
DBA – To be completed when Name to use on the 1099 is selected as “Doing business as”
Name control – IRS required
CUSIP – Committee on Uniform Securities Identification Procedures
CUSIP ID – Unique number assigned to stocks and registered bonds
CUSIP details
Nominee details
Investor type – Selection between the following:
None
Owner
Nominee/broker
Coming Up
Creating a 1099 Vendor is fairly straightforward, and if executed properly, will keep an organization in compliance with tax laws and regulations surrounding payments for contractors.
In the Part 2, I will specifically review the reports available for 1099 reporting and additional information on creating 1099 payments.
Login
Report
There was a problem reporting this post.
Block Member?
Please confirm you want to block this member.
You will no longer be able to:
See blocked member's posts
Mention this member in posts
Invite this member to groups
Message this member
Add this member as a connection
Please note:
This action will also remove this member from your connections and send a report to the site admin.
Please allow a few minutes for this process to complete.
Here you will find a wealth of information created for people that are on a mission to redefine business models with cloud techinologies, AI, automation, low code / no code applications, data, security & more to compete in the Acceleration Economy!