Medisoft Utilities Repair Currency Fields
Medisoft Utilities Repair Currency Fields
The Repair Currency Fields utility truncates the values of every currency field in the database to two decimal points.
From each table in the database, the utility creates a field list of float data fields. Only currency fields are added to the field list. For each record in the current table, only those fields which are in the field list are assigned a new value.
The formula the utility uses is: truncate (Field Value multiply it by 100) and then divide it by 100.
To Repair Currency Fields
-
On the Utilities Tree, double-click Repair Currency Fields. The Warning – Be sure to backup your data window appears.
-
Click the Backup Data Now button to complete the data backup process. For data backup instruction see the topic To Back up Data . Complete this process and go to step four.
-
Option: click the Continue w/o Backup button. The Repair Currency Fields window appears.
-
On the Repair Currency Fields window, click the Start button. The utility runs and, when complete, the Information window appears.
-
On the Information window, click the OK button. The Information window and the Repair Currency Fields window close. The main application window appears.