How to calculate Rebate in sales order based on GL date

In a scenario, wherein order was entered in January.

Same order was Invoiced and sales updated in month of March.

Rebate set up for this order customer item combination was entered in month of March (1 to 31 as validity)

In this case rebate was not picked by order, as rebate set up was not there in month of January.

Can we calculate rebate based on Invoice/GL date, or a report/program to calculate rebate based on GL date ?

Thanks

Maneesh