Apply a standard invoice to multiple prepayments

Hello

We have a requirement to apply a standard invoice to multiple prepayments when importing on the interface. We found this Doc ID 2084877.1 that we can do it on the interface by identify the prepayment amount and not identify prepayment number then system will apply standard invoice to the oldest prepayment first then apply the remaining amount to the other available prepayments.

However, we have a business condition that our store locator number (which is a segment on our Chart of Accounts) need to be the same on standard invoice and prepayment and if they are not the same the business can't apply the standard invoice to the prepayments as store locator will be incorrect. So, with the solution from