Tech Tip: Avoid Commas When Assigning Vendor Numbers

Q: I have vendor records where the Vendor # includes a comma. When I generate reports for the said vendors filtered using the List option, I get the “No records found…” message. Why?

A: This is a system limitation for the List report filter. This filter uses a comma to separate vendor numbers (e.g., VENDOR#1, VENDOR#2, VENDOR#3). If the Vendor # has a comma, then it will consider the code as two separate vendors. For example, the Vendor # is BRADY, MIKE; it will return the “No records found…” message because the system cannot find a record for Vendor # BRADY and Vendor # MIKE.