We have just begun using Electronic Bank Payments to generate ACH payments to vendors. One of the options when doing Bill Payment Processing is to Aggregate By Payee, which creates a single line on the EFT file for a vendor and accumulates the amounts of all bills to be paid into a single value. If you do not check that box, then each bill gets a separate line on the generated EFT file.
Our A/P department has explicitly stated that they do NOT want to Aggregate by Payee and would like that each bill receives its own entry in the file.
However, on the flip side, on the generated Bill Payment, the A/P department wants all the bills that were paid to be gathered per vendor into a single payment. So we have a bit of a paradox here: NO for aggregated payments in the EFT file, but YES for aggregated payments in the Bill Payment record itself.
To elaborate, if you pick NO for Aggregate By Payee, each bill gets its own Bill Payment record, as below:
But if you pick YES for Aggregate By Payee, each vendor gets a single Bill Payment record:
Is this possible—without any customization—or will we just have to tell A/P that they're going to have to check the Aggregate By Payee after all?