Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

GP 2010 - 1099 Amounts Not showing

Posted on 2013-12-26
10
Medium Priority
?
530 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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

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
 
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 2000 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Viewers will learn the different options available in the Backstage view in Excel 2013.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

886 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