"No records found" message when generating 1099/CPRS forms

Summary

In Sage 300, "No records found" appears when vendor setup or reporting amounts prevent 1099/CPRS form creation. Verify vendor configuration and reporting amounts before generating the forms.

Cause

The message appears when:

  1. One or more vendors aren’t 1099/CPRS vendors.
  2. Vendors are 1099/CPRS vendors, but they already had transactions when you enabled 1099/CPRS reporting.
  3. One or more 1099/CPRS vendors haven't reached the Minimum Amount to Report specified in A/P 1099/CPRS Codes.

Resolution

Correct vendor setup

If vendors aren't 1099/CPRS vendors, update the vendor records to enable 1099/CPRS reporting.

Vendors had transactions before 1099/CPRS setup

  1. Go to A/P Setup, Options, Transactions.
  2. Select Allow Edit of 1099/CPRS Amounts.
  3. Go to A/P Vendors, 1099/CPRS Inquiry.
  4. Enter the 1099/CPRS amounts manually for the vendor.
  5. Reprint the 1099/CPRS form.

Verify reporting thresholds

  1. Open A/P 1099/CPRS Codes.
  2. Review the Minimum Amount to Report value.
  3. Verify that each vendor meets the reporting threshold.
  4. Generate the 1099/CPRS forms again.

Need more help?

Chat now



Solution Properties

Solution ID
222924550020203
Last Modified Date
Thu Aug 27 13:37:18 UTC 2026
Views
0