Solved

GP 2010 - 1099 Amounts Not showing

Posted on 2013-12-26
10
513 Views
Last Modified: 2014-01-01
we have 6 vendors that are set up as 1099 vendors (all set up the same as other 1099 vendors) and they are showing paid 1099 amounts in 2013 (Transaction by Vendor) but they are not showing up in the 1099 SmartList with the other 1099 Vendors.  there has not been any voids.  I have had the AP supervisor look as well and the SmartList is showing a $0.00 amount..  Thanks!
0
Comment
Question by:pstre
  • 5
  • 5
10 Comments
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39740725
Which SmartList and what column are you looking at? What select criteria are you using?

Also, do they show up if you print the 1099 Edit List? To do that:
Go to GP | Tools | Routines | Purchasing | Print 1099
Make sure year is 2013 and the 1099 Type is correct (whatever is on the vendors)
Click the print button in the top right hand corner
0
 

Author Comment

by:pstre
ID: 39740877
Victoria, I am using your SQL view (Vendor Yearly Totals) and that is where I pulled the class ID 1099 Misc.  I found 6 vendors in this view that were not in the "1099 Vendor" SmartList.
These 6 vendors are set up as 1099 vendors yet the 1099 amount is showing as "0" in the smartList and in the purchasing routine for 1099's. These six vendors are also in the class 1099 Misc.
0
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39741291
So the vendors are in the class "1099 Misc", but when you open the Vendor Maintenance window for them and click on the Options button, the Tax Type is selected as Not a 1099 Vendor? Do you know if they should actually be getting a 1099? It's possible that when the vendor was created originally they were put in the "1099 Misc" class by mistake...or they used to be a 1099 vendor, but are not anymore.

If you determine that these should be 1099 vendors, you can use the Update 1099 Information utility (GP | Tools | Utilities | Purchasing | Update 1099 Information) to update the amounts for the vendor.
0
 

Author Comment

by:pstre
ID: 39741642
No, the tax type for these 6 vendors is "misceallaneous" which is what we use for all of our 1099 vendors.  They are 1099 vendors and should be 1099 vendors but yet they are not pulling in the 1099 Smartlist.  If I had not used your SQL view to compare, I would have never known about these  6 vendors.  I can use the utility to update the amounts; however, it concerns me that these 6 are not showing up.
0
 

Author Comment

by:pstre
ID: 39741647
I ran the utility but there was nothing to change. Everying was already correct.  I ran it anyway and still the 1099 amount is $0.00 but document amount is $13,899.
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39741662
Can you post a screenshot of the settings for your "1099 SmartList"? This is not necessarily the same for everyone.

Also, if you go Inquiry | Purchasing |  Vendor 1099 Details, bring up the vendor and choose Year under Display - what does it show?
0
 

Author Comment

by:pstre
ID: 39741860
Attached is the screenshot.  The first part shows the 6 vendors found in the SQL view but not in the 1099 smartlist.  Also, these vendors have amounts paid in Transaction by vendor.

when I went to Vendor 1099 details, these 6 vendors show $0.00.  I pulled other 1099 vendors and they have an amount
1099-issue.docx
0
 
LVL 18

Accepted Solution

by:
Victoria Yudin earned 500 total points
ID: 39741896
Thanks. So your '1099 SmartList' is something that you're pulling together based on 'custom' criteria. For what it's worth, I typically do not trust any out-of-the-box 'YTD' numbers in SmartLists - the only way they will be accurate is if you are able to post everything for one year and do the year end close for the subledger prior to posting any transaction for the next year. In most companies that is not realistic.

Without talking to the people that are entering your payables transactions and seeing if they remember anything different about these vendors, I do not believe you will ever be able to find out 'what happened'. That is something I get asked all the time and there is just not enough data stored in GP to answer something like this. This is why you do reconciliations / verifications / etc.  To find that stuff that was missed and correct it. :-)

I would recommend using the Update 1099 Utility to fix these.
0
 

Author Comment

by:pstre
ID: 39742190
But if they are already showing as 1099 vendors in the utility, how do I fix it?
0
 
LVL 18

Expert Comment

by:Victoria Yudin
ID: 39742343
I would pick "vendor and 1099 transactions" under the Update, select one vendor at a time and run the utility - see if that accomplishes what you want.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now