User Tools

Site Tools


budget:utilities:updatelastyearclosing

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
budget:utilities:updatelastyearclosing [2020/07/02 15:10] emorenobudget:utilities:updatelastyearclosing [2021/01/27 17:19] (current) emoreno
Line 5: Line 5:
 //**Budget > Utilities > Update Last Year Closing**// //**Budget > Utilities > Update Last Year Closing**//
  
-<WRAP round intro>This page is used to automatically transfer account codes and their closing amounts from the Finance application to the Budget master file. This utility allows you to update the **Last Year Closing Amount** column in the budget file with the current year-to-date amounts (using either Amended or Actual amounts) for all accounts in the Finance application. This utility is generally used to update the **Next Year Closing Amount** column after all audit entries have been entered and balanced in Finance. By selecting a file ID, you can choose where the closing entries exist, and copy them to Budget. Processing this selection multiple times does not create duplicate accounts, but updates existing budget balances and account codes being transferred from Finance to Budget.+<WRAP round intro>This utility is used to automatically transfer account codes and their closing amounts from the Finance application to the Budget master file. This utility allows you to update the **Last Year Closing Amount** column in the budget file with the current year-to-date amounts (using either Amended or Actual amounts) for all accounts in the Finance application. This utility is generally used to update the **Next Year Closing Amount** column after all audit entries have been entered and balanced in Finance. By selecting a file ID, you can choose where the closing entries exist, and copy them to Budget. Processing this selection multiple times does not create duplicate accounts, but updates existing budget balances and account codes being transferred from Finance to Budget.
  
 Records that exist in the Mass Change Account Codes, Mask Crosswalk option affect the accounts that are created or updated when using this option. Records that exist in the Mass Change Account Codes, Mask Crosswalk option affect the accounts that are created or updated when using this option.
Line 14: Line 14:
  
 ^ Field                                        ^ Description    /*Table with two rows*/ ^ Field                                        ^ Description    /*Table with two rows*/
-^From GL File ID|Select the desired from GL file ID. The accounting period values are changed according to the current and next accounting period values for the selected GL file ID.|+^From GL File ID|Select from GL file ID. The accounting period values are changed according to the current and next accounting period values for the selected GL file ID.|
  
 VCV Click **Retrieve** to update the **Accounting Period** options and fund information.  VCV Click **Retrieve** to update the **Accounting Period** options and fund information. 
Line 20: Line 20:
 VCV Under **From GL**, select one of the following options: VCV Under **From GL**, select one of the following options:
  
-^Amended|Select if you have posted Journal Budget or Amended Budget entries to Estimated Revenue or Appropriations, and selected Original Budget Only in the Move Budget to Finance utility.\\  **NOTE**: If **Capture Original Budget Flag** on District Budget Options is not selected or if **Original Budget Only** on Utilities > Move Budget to Finance is not selected, the original budget amount viewed in Budget Amendment will not display. If one or both of these features has not occurred prior to performing this process, zero amounts or only those amounts that had** Capture Original Budget Flag** selected on journal budget or current year amendment transactions will update the current **Original Budget** field.|+^Amended|Select if you have posted Journal Budget or Amended Budget entries to Estimated Revenue or Appropriations, and selected Original Budget Only in the Move Budget to Finance utility.\\  **Note**: If **Capture Original Budget Flag** on District Budget Options is not selected or if **Original Budget Only** on Utilities > Move Budget to Finance is not selected, the original budget amount viewed in Budget Amendment will not display. If one or both of these features has not occurred prior to performing this process, zero amounts or only those amounts that had** Capture Original Budget Flag** selected on journal budget or current year amendment transactions will update the current **Original Budget** field.|
 ^Actual|Select if you have posted entries that have increased or decreased Realized Revenue, Encumbrance, or Expenditures in Finance.| ^Actual|Select if you have posted entries that have increased or decreased Realized Revenue, Encumbrance, or Expenditures in Finance.|
  
Line 43: Line 43:
 {{page>general:fourarrowbuttons}} {{page>general:fourarrowbuttons}}
  
-^Execute|Click to execute the process. The Update Last Year Closing Report is displayed with the old and new account codes that were updated, and with the **Last Year Closing Amount** column populated. [[general:printreport|Review the report.]]| +VCV Click **Execute** to execute the process. The Update Last Year Closing Report is displayed with the old and new account codes that were updated, and with the **Last Year Closing Amount** column populated. [[general:printreport|Review the report.]] 
-^Process|Click to update the budget data.\\  {{page>general:budgetprocessutility}}|+ 
 +VCV Click **Process** to update the budget data.\\  {{page>general:budgetprocessutility}}
  
 <WRAP box>**Note**: If there are account components that exist in the Finance file ID that do not exist in the Budget file ID account code table, a Budget Error Report of the account components that must be updated in the Budget account code table is produced, and you are not allowed to proceed until these account components are updated in Budget.</WRAP>  <WRAP box>**Note**: If there are account components that exist in the Finance file ID that do not exist in the Budget file ID account code table, a Budget Error Report of the account components that must be updated in the Budget account code table is produced, and you are not allowed to proceed until these account components are updated in Budget.</WRAP> 
budget/utilities/updatelastyearclosing.1593702639.txt.gz · Last modified: 2020/07/02 10:10 (external edit)