Solved

GP 2010 - 1099 Amounts Not showing

Posted on 2013-12-26
10
510 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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 18

Expert Comment

by:Victoria Yudin
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
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…
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…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

743 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

17 Experts available now in Live!

Get 1:1 Help Now