Payment file for payment of payables invoices with credit memo got rejected

We created a payment that included both a standard invoice and a credit memo for the same supplier, and the net value is positive amount. However, the payment file was rejected by Bank due to the credit memo having a negative amount.

Could you please advise if there is any solution or workaround? Thank you.