Sage 100

Anyone encounter issues where Sage 100 ERP v4.4 1099 totals don't agree to detail? I have a customer where a brief sampling of their 1099 data appears to show that there is no detail to support the 2013 totals. I don't think there's a way to rebuild this - so in the past I've told people to run check history reports and/or refer to the Trial Balance. I don't' think there's a nicer report which shows the 1099 totals -- is there? My experience with 1099 type issues is they're tough to track down though on the later versions with framework I've not run into many at all (could also be that people don't check them that closely). I'm working hard to not be pushed into the ""help me reconcile my 1099 and accounting records"" role with end users. Any thoughts on how you've corrected issues when the end user has an inaccurate 1099?

The payment history report in accounts payable has a checkbox to print only 1099 vendors - that is what I typically recommend

*sorted by vendor helps tremendously though :)

I have been using this as well - much easier to reconcile.

Just to make sure I'm not overlooking anything - there's no rebuild utility correct?

I wrote a crystal report using the AP_Vendor and AP_Vendor1099Payments files

No rebuild that I'm aware of - if there are a large number of vendors then using a crystal, then export to excel and import into the 1099 table might be the workaround A rebuild tool would be useful!

I have a client that handles four legal entities in one MAS company. So every year I have to compute the 1099 payments by legal entity. A bit involved using excel queries and pivot tables but I usually can do it in about two hours now.

Thanks- mostly what I thought. Good tips on the reports!

@JeffSchwenk - you KNOW you want me to write you a Crosstab Crystal report to do that...

Oh, what a tantalizing thought @BethBowers

I might take you up on it ONLY if you promise to use Access PTQ's to pull the data....