Hello Bob,
Thank you for your question on the Forums today. My name is Brandon. I am an engineer on the Microsoft Support team.
First, let me make sure i understand your process.
- You create one Payment that is used to pay multiple Vendors.
- This create an ACH File with only on transaction on it for multiple Vendors.
- The file is submitted to bank to pay.
With my understanding of your process, i don't see how this would work. We cant apply a Payment from one Vendor to another Vendor. We don't have any National Account functionality in Payables Management so i don't see how you could apply one Payment to multiple Vendors.
With the above, if you are only doing one ACH Payment, how are you getting multiple transaction in the Bank Rec? One Payment would only have one record that would update the Bank Rec. Is there a different process you are using to apply to the Vendors? Are you creating multiple checks but modifying the the ACH file to only be one when you submit it to the bank?
Currently, the only way i see possible to get one Bank Record is to only do one check. There is no functionality to have multiple checks update once in the bank rec. Each transactions posts to the Bank Rec.
You would need to look at creating a customization or possibly a third party if you would like functionality to have multiple checks only create one record in the Bank Rec for all checks.
I look forward to hearing more about your process and determining if there are any further options that might be work for you.
Thank you!
Brandon Jarrett | Microsoft Support Engineer
