Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

GP 2010 - 1099 Amounts Not showing

Posted on 2013-12-26
10
Medium Priority
?
528 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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…
For cloud, the “train has left the station” and in the Microsoft ERP & CRM world, that means the next generation of enterprise software from Microsoft is here: Dynamics 365 is Microsoft’s new integrated business solution that unifies CRM and ERP fun…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

660 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