1099 Vendor Names

  • 1099 Vendor Names

    Posted by DSC Communities on January 17, 2017 at 3:50 pm
    • Cari Emery

      Member

      January 17, 2017 at 3:50 PM

      The name being printed on the 1099s is picking up the Vendor Check Name, but I want it to pick up the Vendor Name.  Is there any way in the set-up to change this?  I could not find any reference about selecting which vendor name to print.

      Thanks!

      ——————————
      Cari Emery
      Accounting Manager
      Holthouse Carlin & Van Trigt LLP
      Los Angeles CA
      ——————————

    • Thomas Hill

      Member

      January 18, 2017 at 10:23 AM

      I am interested in finding out this as well.  

      ——————————
      Thomas Hill
      Accounts Payable – Expense Processing
      M&A Technology, Inc.
      Carrollton TX
      ——————————
      ——————————————-

    • Windi Epperson

      Member

      January 18, 2017 at 10:40 AM

      Hi Cari,
      You would have to modify the 1099 Form report in report writer to pull in the Vendor Name instead of check name.  That said, we’ve had several customers who have used the Address1 line for an additional company name.  So for example, the Vendor Check Name is John Doe and in the Address1 they enter dba John’s Plumbing.  Then put the address line in Address2.  What you get on the 1099 is:

      John Doe
      dba John’s Plumbing
      123 Any Street

      Hope that helps,
      Windi

      ——————————
      Windi Epperson
      President/GP Senior Consultant
      Advanced Integrators, Inc.
      Norman OK
      405-946-1774 Ext 102
      ——————————
      ——————————————-

    • Cari Emery

      Member

      January 18, 2017 at 10:53 AM

      Thank you Windi.  I’m very disappointed that GP is so inflexible with such an obvious area that should have a choice of which vendor name to use.  I had thought of doing your suggested work-around, but wasn’t sure that the IRS would be satisfied with that.
      I don’t know how to change reports in Report Writer so I would need to hire that out, which will probably not happen either.

      Best Regards,
      Cari

      ——————————
      Cari Emery
      Accounting Manager
      Holthouse Carlin & Van Trigt LLP
      Los Angeles CA
      ——————————
      ——————————————-

    • Jeff Martin

      Member

      January 18, 2017 at 11:58 AM

      Hi Cari,

      We also struggled with the vendor name used on the 1099s and chose to use the Address1 method that Windi suggested. We have been using this for several years but have had some vendors that do not like the change to the check name.  So we edit the check name and address 1 fields before processing 1099s in order to conform to the IRS preferred format and then change them back when we are done.

      Modifying the 1099 form report as Windi mentioned is a fairly easy solution but is not practical if you are not already using modified reports, especially if you don’t have someone in your organization who is familiar with Report Writer. There are a couple of things to be aware of if you decide to go this way in future or if there is someone else following this thread.  The 1099 print process uses the temporary file PM_1099_TEMP which only includes the Vendor Check Name.  So if you decide to modify the report you will need to add a table relationship on PM_1099_TEMP to the PM Vendor Master File in order to add the Vendor Name.  You will also need to add a restriction PM_1099_TEMP.VendorID = PM_Vendor_MSTR.VendorID to properly join the records. 

      ——————————
      Jeff Martin
      Director of IT
      DeRosa Corporation
      Wauwatosa WI
      ——————————
      ——————————————-

    • Don Pugh

      Member

      January 19, 2017 at 1:54 AM

      Let’s think for a minute what the purpose of the 1099 is for.  The goal is for the IRS to be able to match the 1099 filing to the tax payer tax id to make sure they have included it on their tax return.  Alas, whether we want this or not, this is the rule we are stuck with.   Part of this IRS validation is matching the name on the 1099 with the tax id.  This should also who the check should have been written to.  So if the check is written to Joe Smith, and his tax id is 222-33-4444, then this is how the 1099 should be created.  The fact that he has a DBA as Joe’s Auto Maintenance is interesting, but not relevant to 1099 filing.  If he wants the check written to Joe’s Auto Maintenance then he should get a tax id for that, and file a tax return for that.  So GP is doing exactly what the IRS wants.  I would question a vendor who wants something different.

      Another observation:  For many years the IRS never checked if the 1099 tax id and name matched.  This basically they just ignored this information.  Starting maybe four or five years ago, they started doing matching on some of these, and bounced them back to the filers. With today’s automation, the IRS is doing far more matching and bouncing many more mismatched items.

      Don

      ——————————
      Don Pugh
      GP Consultant
      Sandon Associates
      Woodside CA
      ——————————
      ——————————————-

    • Burgen Havens

      Member

      May 3, 2017 at 1:48 PM

      Windi,
      I recently received an error from the IRS that we had used a business name on a 1099 for a Sole Proprietor instead of the owner name (which would match the TIN/SSN we have on file.) How exactly are you setting the the Vendor Card? Is this how it should look?

      Thanks for the feedback
      Burgen

      ——————————
      Burgen Havens
      Rancho Santa Fe Fire Protection District
      Rancho Santa Fe CA
      ——————————
      ——————————————-

    • Laura Mitchell

      Member

      January 18, 2017 at 11:41 AM

      We have to issue 1099’s for a few of our vendors with a name that is different from the vendor name and check name.   I  temporarily change the vendor name so that I can print the 1099’s with the correct information.   Then I change the name back after I’m done printing the 1099’s.  These are vendors that have a business name but not a federal ID#.   The 1099’s are issued using the business owner’s name and social security number.    I always check with our AP person before I change the vendor name.  I don’t want to interfere with anything that she might have in the works.  

      ——————————
      Laura Mitchell
      Entek Corporation
      Longview WA
      ——————————
      ——————————————-

    • Leslie Vail

      Member

      January 26, 2017 at 11:10 PM

      I also have clients that need to change the 1099 name because the business is a sole proprietorship and we need the name attached to the social security number. A couple of releases ago, Dynamics GP added a fourth default address ID that you could use to specify which address you wanted to use on the 1099. Unfortunately, the vendor name was not one of the fields you could change. We created a separate address ID named ‘1099’ and used the vendor contact field to store the alternate vendor name.
      We needed to create a relationship for the temp table and the PM Vendor Master and the PM Vendor Address Master. I put a restriction on the report such that it only recognized the ‘1099’ address ID in the PM address master.
      Back in Report Writer I created a calculated field, if the address id on the customer maintenance card was ‘1099’ the name from the Vendor contact field on the ‘1099’ address card was used to put on the 1099, otherwise it was the vendor check name from the address id designated on the vendor maintenance card.
      Of course you’ll need to modify the Report layout to put the calculated field in place of the Vendor Check Name field.
      Kind regards,
      Leslie

      ——————————
      Leslie Vail
      Accounting Systems Consulting, Inc.
      Dallas TX
      ——————————
      ——————————————-

    • Chris Hadden, CPP

      Member

      January 20, 2017 at 9:44 AM

      Cari,
      There have been a lot of great suggestions on how to accommodate this directly within GP.
      If this is a big pain point for you, you may want to consider checking out an ISV or 3rd party to assist with your 1099 filing. 
      I cannot speak for all options, but I know within Greenshades you can choose which fields to pull from when populating 1099s (Vendor name, check name, user defined, etc). I’m not certain, but there may be other ISVs that offer this feature as well. 

      If you’d like more info on the 1099 process through Greenshades, feel free to send me an email and I’ll put in touch with an Account Manager. Chadden@greenshades.com 

      Best of luck!

      ——————————
      Chris Hadden, CPP
      Technical Sales Manager
      Greenshades Software
      Jacksonville FL
      ——————————
      ——————————————-

    DSC Communities replied 7 years, 5 months ago 1 Member · 0 Replies
  • 0 Replies

Sorry, there were no replies found.

The discussion ‘1099 Vendor Names’ is closed to new replies.

Start of Discussion
0 of 0 replies June 2018
Now

Welcome to our new site!

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!