I am working with client and we are having issues with Build Payment Batch, selecting vendors that shouldn't be paid. We have unmarked the AP setup "Exclude Expired Discounts from Payments" option, since when this was marked and if you miss the discount date the vendor and voucher never pull into the process causing vendors to not be paid, unless you know to manually go add.
The criteria we entered was Due Date/Discount Date Cutoff
Due Date Cutoff = 10/31/2020
Discount Date Cutoff = 10/31/2020
Apply Date = 10/26/2020
Using the above criteria when the batch was built:
Vendor 1 Invoice: discount date 10/9/2020, due date 11/8/2020, it didn't take the discount which is correct but why did it pull in the invoice to be paid
Vendor 2 Invoice: discount date 10/17/2020, due date 11/6/2020 - same issue as above
I have always looked at the apply date to give you a range of what discounts you want to take. So in my example above if the discount date is from 10/26 - 10/31 the invoice will be pulled in to be paid taking the discount.
What am I missing here.