Mass Update is a powerful tool that allows you to make changes to your system. Make sure to make a backup of your database before running any mass update process. Customer Support can assist you with using Mass Updates but will not be able to assist in creating formulas.
A backup can be performed within MIP under File > Backup. If you do not have the option to perform a backup, we do not recommend moving forward with performing any Mass Update changes as there is no simple method to undo the changes made.
When using the Mass Update tool to implement a change, you may want to round the value. Which rounding option you use is determined by what effect you are intending.
There are three options that can be used for rounding. All can be found under the Formulas tab under the Math Section as seen here:
The three options are round, rounddown and roundup. Please note that rounddown and roundup will always round in one direction and can have unexpected results.
The description of each provides a brief overview of the effects:
The following screenshots show the effects of each option.
Without rounding, this is how a 5.1% pay raise would appear:
This would be the effect of rounddown:
This is the effect of roundup:
The round option
MIP Fund Accounting