Provision to enter data in specific version in Report
I need to create a report with 3 versions actual,forecast,budget and the data is formula driven. But need to give provision for the planner to override the data only in forecast version which is calculated.Need few suggestions to implement this.
I presume that you have written the formula for the line Item
Now follow the below steps to achieve the functionality.
Step 1) Go to the blueprint view and set the formula scope to Actual Version in the line item.
(Now the formula is only applicable to the actual version of that line item. Budget version will be fully editable and forecast version will be editable from the switchover date)
Step 2) Now go to the versions tab, and set 'None' in the 'Edit From' and 'Edit To' fields for Budget version. Or you can set as per your requirement, making sure that 'Edit From' and 'Edit to 'time duration does not overlap the user input time duration.