Sage 100

4.4.06 AP Payment History Report if the Print 1099 Vendors only is checked, some checks and reversals are missing from the report. If this box is not checked then all payments appear. All Payment Types is checked. The vendors were updated about a month ago with 1099 info, so most all of the invoices have N for Form1099 in AP_InvoiceHistory. Thanks for any suggestions!

Not sure what you are asking for? Just because the vendor master was updated a month ago doesn't do anything to the history files. IF you want to correct the history table, dump the header information into Excel, determine which invoices are 1099, then reimport to flip the flag to designate as a 1099 invoice.

I don't want to correct history table just for the Payment History Report to print the correct amounts if the 1099 vendor only box is checked. They are trying to use this report to obtain all payments to the 1099 vendors so they can update the 1099 history and print 1099's.

I just had this problem also. I looked at the files in DFDM and couldn't see why one invoice wouldn't show on the report when Print 1099 Vendors only was checked. Still haven't figured it out.

Which tabel are you looking in? Have you looked at the Check history detail report? Just a guess on my part.

I looked at Check History Header/Detail, Invoice History and Transaction Payment History and did not see any differences between the invoices in any of the files.

Ditto Lisa. I also looked at Open Invoice and didn't see anything there either.

I know there is an issue with invoices that are NOT 1099 being included if the they were paid on a check WITH 1099 invoices. Kind of opposite of your problem however. It IS looking at the check history files, BTW.