Thank you for posting here, @-activia-com-sg.
I see that canceling the partially paid invoice we have will help achieve our goal. However, There's an option to avoid canceling it and consider the payment to the previous one. We can do this by opening the partially paid invoice and applying it to the previous payment. Let me guide you on how to do it:
- Go to Sales, then choose All Sales.
- Find the partial payment transaction you received.
- Click the View/Edit icon.

- Two invoice transactions will show up. Uncheck the one we want to remove the partial payment and tick the correct one.

- Tap Save and new.
Therefore, we don't need to create a new invoice to be issued since we already transfer the partial payment to the previous one.
I'll be adding this article to help you manage your invoice transactions: Deposit payments into the Undeposited Funds account in QuickBooks Online.
I'm grateful to have you here. Please come back if you have additional questions. I'll be happy to lend a hand. Take care always.