Symptom
Values appearing on the completed form is different from roll up report.
Environment
Compensation
Cause
Here the values are populated by a custom column which was associated with a formula involving look up table.
After forms are moved to completed status, any value changes in the look up table will recalculate and populates new calculated value on the form when completed forms are opened again. But, In database the value will be stored before form gets moved to completed. Hence, Values appearing on the roll up report will be of older value which was on the form while it was not in competed state.
For more understanding , Let's say we have a form with two steps.
1. comp_admin
2. completed.
Value1-> when the form is with comp_admin, value will be populated automatically using look up table and stored in database.
Now, forms gets moved to compled state. After that, Let's say we have a change in look up table. When you open the completed form, new value will be populated according to the changes made in look up table.
Value2-> When the form is in completed status and new value has been populated due to change in look up table. But this value won't be stored in database.
So, when we run roll up report value1 will shown on the report and in the completed forms, we will see value2.
Resolution
Mass update run including completed forms will resolve this issue.
Keywords
KBA , LOD-SF-CMP , Compensation Management , Problem