Validate Worksheet

Access this feature using Activities>Budget Worksheet> Validate Worksheet.

Use this button to automatically validate every budget item in the worksheet before transferring the worksheet. A worksheet, or a portion of a worksheet, can be validated at any time.

• To validate a row or set of rows, select the rows (or cells in the rows), right-click on the worksheet, and select Validate Rows.
• To validate the entire worksheet, click the Validate button.

 

New Worksheets: Only the G/L Code, Segment Code, Effective Date, and budget entry columns are subject to validation.

All Worksheets Types: Each budget item receives Pass, Warning, or Error in the Status column of validated rows, followed by an explanation of why the system returned that value.

Status	Result
Error	The worksheet cannot be transferred.
Warning	The worksheet can be transferred. This value is used for inactive account codes and negative budget amounts.
Pass	The worksheet can be transferred. No errors exist.

Note: Only rows marked as Budget Items, with a "B" in Column A, can be validated. Furthermore, you are not warned about any duplicate budget items or invalid account code combinations.