Thank you, check this Out.
One last question, For 1 project we have multiple SO. For example a new opportunity (parent opportunity) comes, we have a sync with sales force automatically a SO is created, along with a custom opp record.
After some approvals in SO by operations, the project is created and the sales order is tagged with that SO.
But for any new opportunity (child opportunity) for the same project, a new SO is created and project value and end date is extended by the operations team.
And based on PMs input new project tasks (milestones are created).
We do not have any way to know which milestone belongs to which sales order.
Will invoicing be impacted bcz of it, if we follow your above suggestion.