To ensure that you have entered accurate orders, use the Validate command. This command checks a worksheet against a set of validation criteria. After running the verification you can view a list of errors encountered. From this list you can flag the erroneous parts or go to the part number in the worksheet.
-
From the Worksheet menu, select Validate.
The Validate Worksheet dialog appears. You can resize this dialog or go to the worksheet while this dialog is open.
The dialog lists part numbers in the worksheet that are not valid. You also see the errors on each part number. -
To change the validation criteria, click Criteria. In the Validation Criteria dialog check the ones you want verified then click OK.
The information on the Validate Worksheet dialog will be refreshed automatically. -
To make corrections, you can either:
- Click on Flag All to flag parts that are not valid. Without closing the dialog, make the corrections in the worksheet. Go back to the Validate Worksheet dialog and click Refresh to update the information.
- Click on a part number to make that part number current in the worksheet. Without closing the dialog, make the corrections in the worksheet. Go back to the Validate Worksheet dialog and click Refresh to update the information. -
Click Close to close the dialog.
Related articles
Update against a catalog
Update against a worksheet