How to split installment in mass of all AR invoices of a customer in order to spread his balance ?

Summary:

How to split installment in mass of all AR invoices of a customer in order to spread his balance from a given date and in function of a given number of periods ?

Invoice A :

• Invoice date : 01 October 2024
• Invoice Amount = 1000
• Payment term = 30 End of Month
• Due Date : 30 November 2024

Invoice B :

• Invoice date : 05 October 2024
• Invoice Amount = 2000
• Payment term = 30 End of Month
• Due Date : 30 November 2024

On 15 November 2024, you decide to split installment of all AR invoices of a customer from 30 November 2023 and in function of 3 periods

⇒

Invoice A :

• Invoice date : 01 October 2024
• Invoice Amount = 1000
• Payment term = 30 End of Month ?
• Due Date 1 : 30 November 2024 : Due Amount 1 : 333,33