Our AP Remittance report is having an issue with correctly filtering to all invoices tied to a check num for a single vendor to be sent on the check date.
The breaking routing for this report is set up to break on CheckHed_CheckNum and Calculated_CheckForContactInfo (I have also tried VendCnt_Name which is essentially the same as the Check for contact info calculated field) then the first condition checks the role code is APR (if not it sends an email) then a second condition to check that the vendor contacts email is valid (if it doesn’t contain the @ it sends another email) to then finally send an email with the report attached to the vendor contact. The logic makes sense and the parameter that is supposed to pass through is the CheckHed_CheckDate but for some reason, and I have just discovered this, when I filter the BAQ to a specific date it doesn’t completely filter the rows to the selected date. Why is that?
The resulting report shows all invoices no matter what check number. I am not understanding why the breaking routing is properly filtering these invoices based on the check numbers that have a check date that is the date that is passed through the parameter? Also I just noticed that the check date at the top is not the Date that was passed through the parameter upon runtime.
