Add an additional name field to the vendor maintenance window that represents the DBA information for vendors that need to report their 1099's this way. Then program the 1099 report to be smart enough to format the 1099's correctly depending on whether there is a value in the DBA name field or not.

I have dealt with DBA 1099 reporting a number of ways over many years for many clients (e.g. modifying the 1099 report to pull in the Address 3 or contact, or creating a conditional report that prints one thing if one address ID is detected and another thing if another is detected. There are probably many other workarounds as well, however simply adding a field to track this scenario seems to me to be a simple fix that would save a lot of people a lot of time and effort modifying their 1099 reports and/or updating their vendor addresses in ways that otherwise don't make a ton of sense.

Under Review
Ideas Administrator

Hi Michael, 

Thank you for your suggestion. We will consider this for a future release. 

Jodi Christianse
PM. Microsoft



Michael!! It's implemented in the 2020 Oct release! You should win a prize for having the most suggestions implemented in a release!

Category: Financials - Accounts Payable


I agree, although I'd prefer it the other way - I find that I want the d/b/a name to be the Vendor Name (as this is the name that usually appears on invoices, etc. and the name I'll be searching for) and then have another field for the 1099 Name. Then have the report pull the 1099 name onto the report. Or perhaps have the Vendor Name default into the 1099 Name, with the ability to change it. Then the 1099 Report itself could always look in that field.

Category: Financials - Accounts Payable