Dynamics GP
Dynamics GP
Organizer:
- Organized by
-
-
1099 Vendor Names
-
1099 Vendor Names
-
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
—————————— -
I am interested in finding out this as well.
——————————
Thomas Hill
Accounts Payable – Expense Processing
M&A Technology, Inc.
Carrollton TX
——————————
——————————————- -
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 StreetHope that helps,
Windi——————————
Windi Epperson
President/GP Senior Consultant
Advanced Integrators, Inc.
Norman OK
405-946-1774 Ext 102
——————————
——————————————- -
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
——————————
——————————————- -
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
——————————
——————————————- -
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
——————————
——————————————- -
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
——————————
——————————————- -
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
——————————
——————————————- -
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
——————————
——————————————- -
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
——————————
——————————————-
-
-
0 Replies
Sorry, there were no replies found.
Log in to reply.
