GP 2010 - 1099 Amounts Not showing

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:

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.

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.

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.

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.

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?

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

But if they are already showing as 1099 vendors in the utility, how do I fix it?

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.