Due Dates based on criteria or project
I need to update the due date for all the AP invoices pertaining to a project. The project master data has the "ValidTo" field. Whenever the project master field is updated or extended to a new date, the due date should be updated with the new date so as to get the ageing correctly based on the due date.
This scenario is applicable to the construction industry.
Ex: Project master : Project 1 Validto: "31/12/2016"
AP invoice # 1 created on 1/2/2015 with retention dues.. The retention due date should be reflected as 31/12/2016.
AP invoice # 2 created on 1/4/2015 with retention dues.. The retention due date should be reflected as 31/12/2016.
When the project master is extended to the new valid date i.e. Validto is changed from 31/12/2016 to 31/12/2017, the due dates for the retention dues should reflect the new date i.d. 31/12/2017 for the new transactions and also, for the old transactions.
How can we do this? Is it possible to handle this?