Action condition through user status as well as date profile
My scenario is like action will be triggered through date. I have the scenario like we hv to create the exchange order and after that we hv to create the sales prder. The maximum time gap betewwen the exchange order and sales order is 1 month. If customer does not return the goods within 21 days we hv to send a mail to customer saying "you have another 7 days to return the product" means before 7 days we hv to send a warning mail to customer. Again if the customer send the old goods then we will make a fresh order on the reference on exchange order. Can u tell me how can I achieve this through action peofile. That is condition will be date management and user status.
Status is opened state. Before 7 days mail will be sent to customer. If customer does not return the product the status will be cancelled.
How mail will be sending to customer automatically after 21 days to return the products?
Your help will be appreciated.