Automatic splitting of Vendor payments based on amount threshold and do payment using multiple payme

Hi experts,

We have a specific client requirement pertaining to processing of Vendor payments for Inventory based purchases. Though we are aware of the "Split schedule" functionality in AP Invoice workbench, however it's still a manual workaround for splitting the payment one at a time.

As the volume of Inventory based invoices is quite high, the client is not comfortable with a manual approach and thus we would like to explore if the requirement can somehow be achieved by leveraging the standard Payments functionality preferably, and not through customization.

Requirement is as below:

Most of the vendors are tagged with a vendor payment method of "Factoring" or "Promissory Note" in the vendor master.