645
FYI....this download can be found with Service Packs & Product Releases. In prior years, it has been with Tax & Regulatory Updates. 2011 is there but not 2012.
*This post is locked for comments
It is part of SQL server and usually installed on the file server but may not be installed on the workstation.
What is Management Studio?
Yes, the vendor name from the vendor tab defaulted to the 1099 tab when the vendor was set as a 1099 vendor.
Ver 8 and 2011 are the same version.
If you run this statement in Management studio against the system database, then you can preview the actual 1099 forms (and W2 forms) on the screen and review. Otherwise, you could select from the vendor table in Management Studio to pull all of the vendor data and then manipulate and sort the data in Excel.
UPDATE RptControl SET DocPrompt = '' WHERE ReportNbr = '02741'
UPDATE RptControl SET DocPrompt = '' WHERE ReportNbr = '03740'
Hello Elaine,
Thanks for your reply.
We are using version 2011 SP1. Is this what you refer to as Version 8? I do see the fields for TIN Name and Recipient Name 2 in the 1099 Tab.
And the TIN Name defaults from the Vendor Name only when 1099 Vendor = Yes. Is this correct?
Therefore if this is so, it seems that I should review the TIN Name and Recipient Name 2 of all "yes" 1099 vendors in order to designate the correct last word using the @ symbol and to remove extraneous words and special characters. Is there a method or report that would you would suggest that would be most efficient?
Thanks!
Janet
The TIN name and Recipient Name 2 were fields added in ver 8. They are not available in version 7.
From the Help in ver 8.....
TIN Name
Indicates the name associated with the taxpayer identification number (TIN) specified for the vendor in Tax ID Nbr. The last word should be a full word. Extraneous words, titles (i.e. Mr., Mrs., Dr.), and special characters (i.e. a period, an apostrophe) should not be used.
For example, Joseph Smith, a sole proprietor, owns American Interiors which is defined as a vendor. You would enter Joseph Smith in TIN Name and DBA American Interiors in Recipient Name 2.
Recipient Name 2
Indicates additional names related to the vendor but not associated with the taxpayer identification number specified for the vendor in Tax ID Nbr. The last word should be a full word. Extraneous words, titles (i.e. Mr., Mrs., Dr.), and special characters (i.e. a period, an apostrophe) should not be used.
For example, Joseph Smith, a sole proprietor, owns American Interiors which is defined as a vendor. You would enter Joseph Smith in TIN Name and DBA American Interiors in Recipient Name 2.
*************************************************************
The TIN name defaults from the vendor name on the Vendor tab in Vendor Maintenance. You can overwrite it on the 1099 tab and you can Add a Recipient Name if you want. If you are using verions 8, verify that the vendor name is populated in the TIN Name for a couple of vendors to be sure that is populated when you upgraded. It is for me. And, a Recipient Name 2 is not a required field.
Janet,
I am transferring this to the financial team. They can give you a better answer on this.
Blaine,
I'm reading the document that I downloaded with the Year End update. In Step 6, it indicates that I should review the TIN Name and the Recipient Name 2 on the 1099 info Tab in Vendor Maintenance. I can't imagine doing that for every vendor in my database. Can you elaborate.
Thanks,
Janet
Good to know. Thanks
In the future all Year-End Updates will be found under Service Packs, and all Tax Updates will be found under Tax Updates.
#1
André Arnaud de Cal...
293,099
Super User 2025 Season 1
#2
Martin Dráb
231,884
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
