Correct Errors in Spreadsheet

If the validation performed in the previous section finds an error, a dialog box will display which shows the errors found. The picture below shows an error involving an incorrect GL account.

If multiple errors exist, they will all show in the dialog box shown above.

To correct the problem.

1. Select the error in question by clicking on the appropriate line.
2. Once the item is selected, select the Go To Error button at the bottom of the screen. The dialog box will then disappear and your cursor will be placed in the cell containing the error. This is especially useful for long entries.

Custom Validation errors, if utilized, are denoted with a CV-E in front of the error message, indicating Custom Validation – Error.

You can view extended SAP message information (long text) for all messages except when GLSU or CustVal is in the Source column. To view the Source and other values select More.

For ease of error processing, you may also copy to the clipboard or insert a worksheet of errors from the Validation Errors dialog. To do this simply right-click and then select the appropriate option.

After insertion of an “errors” worksheet, you may use the hyperlinks (In Excel 2000 or later) at the left of the newly created worksheet.

Please note that these messages are only valid until changes are made to the contents of the worksheet or the worksheet name is changed.

It is also possible to print a list of errors from this worksheet. Simply use the standard File > Print functionality from within Excel.

Note: If the error is an out of balance situation, GLSU will not know which line item is incorrect. You will have to find the error manually and correct it before posting.

Conditional Formatting of pre-validation messages within the cells.

In addition to highlighting pre-validation errors in the dialog pop-up and the Show Validation Again features, GLSU contains functionality which allows the pre-validation messages to be shown in-line via conditional formatting within the cells.

To enable this feature, select the Options ribbon button, and then the Validation tab. Check the Show Validation Markers checkbox and select ok.

When performing a Validate, the regular GLSU pre-validations will run. If the Show Validation Markers are enabled and you have errors, your sheet will look similar to the worksheet below. You will need to single-click on the highlighted cell (and other cells) to view the error.

You can clear the validation makers by selecting the Clear Validation Markers checkbox below the ok button on any validation screen and then select ok.

Note: Please note that validation markers will automatically be cleared upon modification of the GLSU sheet via Choose Fields and upon exit from Excel. It should also be noted that certain manual manipulation of the worksheet may invalidate the conditional formatting. You should always be using Choose Fields to modify the layout of a GLSU worksheet as has always been the case. In the event of a modified sheet utilizing Choose Fields, simply run the Validation again and new markers will be shown.