AR Payment term needs to be defined for 45 days but the terms need to start on the Last day of month

Hi All,

We have a business requirement where an AR Payment term needs to be defined for 45 days but the terms need to start on the Last day of month of the date of the Receivables Invoice.

For example see below the different scenarios and what Payment due date is required in each ( date format is dd/mm/yyyy)

Example Date of invoice	Last day in that month	Payment due date	payment period in days
01/01/2020	31/01/2020	16/03/2020	75
15/01/2020	31/01/2020	16/03/2020	61
31/01/2020	31/01/2020	16/03/2020	45
02/02/2020	29/02/2020	14/04/2020	72
28/02/2020	29/02/2020	14/04/2020	46
07/06/2020	30/06/2020	14/08/2020	68
30/07/2020	31/07/2020	14/09/2020	46

The format of the Receivables Payment term form does not seem to support this requirement. Can someone let me know if this requirement can be met - either directly or through a work around please?