Once changes are complete, click on the Update button at the far right of the rectangular area to make the change. Once Update has been clicked, the add/update row will clear (except for the Fund Code and Cost Center fields) and the updated data will show in the grid below. To delete a row that has been entered, click on a row to highlight it. Click on the Remove Row(s) button and a confirm deletion message box will appear. When the Remove Row button is clicked, the following window will appear. To cancel the deletion, click the Cancel button. To complete the deletion, click the OK button. To sort the rows - If you have multiple rows and wish to sort them, click on the Sort Rows button. This will sort the rows in order by Fund Code, Cost Center, and Account Number. Alternatively, you can sort by Fund Code or Cost Center by selecting from drop downs to the right of those field names. The rows will sort in Fund Code, Cost Center, Account Number order, ascending. Click a second time and they will sort in descending order. Note: There is also a built-in sort for Fund Code, Cost Center, Account Number, Account Description, etc…. Receipts The Add/Edit Row(s) functionality for Receipts is identical to the Requirements functionality and therefore each step will not be replicated here. Summary When Requirements and/or Receipts entries are entered into the Worksheet I form, the data populates the Summary table at the bottom of the Budget Detail tab. The Summary table will add all Requirements and Receipts entered in this form and calculate the Appropriation amount. An example of the summary table for an Actuals Worksheet I Budget Detail form will look like this: An example of the summary table for an Increase/Decrease Worksheet I Budget Detail form will look like this: BUDGET OVERVIEW TAB
Once changes are complete, click on the Update button at the far right of the rectangular area to make the change. Once Update has been clicked, the add/update row will clear (except for the Fund Code and Cost Center fields) and the updated data will show in the grid below. To delete a row that has been entered, click on a row to highlight it. Click on the Remove Row(s) button and a confirm deletion message box will appear. When the Remove Row button is clicked, the following window will appear. To cancel the deletion, click the Cancel button. To complete the deletion, click the OK button. To sort the rows - If you have multiple rows and wish to sort them, click on the Sort Rows button. This will sort the rows in order by Fund Code, Cost Center, and Account Number. Alternatively, you can sort by Fund Code or Cost Center by selecting from drop downs to the right of those field names. The rows will sort in Fund Code, Cost Center, Account Number order, ascending. Click a second time and they will sort in descending order. Note: There is also a built-in sort for Fund Code, Cost Center, Account Number, Account Description, etc…. Receipts The Add/Edit Row(s) functionality for Receipts is identical to the Requirements functionality and therefore each step will not be replicated here. Summary When Requirements and/or Receipts entries are entered into the Worksheet I form, the data populates the Summary table at the bottom of the Budget Detail tab. The Summary table will add all Requirements and Receipts entered in this form and calculate the Appropriation amount. An example of the summary table for an Actuals Worksheet I Budget Detail form will look like this: An example of the summary table for an Increase/Decrease Worksheet I Budget Detail form will look like this: BUDGET OVERVIEW TAB