What is the best approach to create an accrual for fixed amount every month for a customer
Summary:
The client requirement to create an Accrual for a fixed amount every month for a Customer. Now the customer may have more than one promotion for different duration as shown below.
Customer A | Accrual Amt | Promotion Start Date | Promotion End Date |
---|---|---|---|
ABC | 1000 | 01/01/2025 | 12/31/2025 |
ABC | 1800 | 02/01/2024 | 12/31/2025 |
First option that comes to mind is create a LumpSum program. But then customer will have to create a LumpSum program for 1000 & 1800 at the beginning or end of each month for two promotions.
Unlike Customer Promotion, they cannot create it in advance as for LumpSum program, Accrual amount is created immediately when the LumpSum program is submitted.