Symptom
When running the vendor activity report using the total paid filter set to a number greater than 999.99, an error message ‘Invalid Syntax Near ‘,’ ‘ is produced. This only happens when the report was built with the ‘Assume last two digits are cents’ in ‘Customize Workstation Settings’ checked.
Product Line