Business

User Tools

Site Tools

Trace: • body • Export by File ID - BUD7400 • Mass Delete Zero Balance Accounts - BUD7400 • Update Budget Data - BUD6000 • create_transactions
budget:utilities:updatebudgetdata

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:updatebudgetdata [2018/02/07 17:09] – emorenobudget:utilities:updatebudgetdata [2020/09/30 15:33] (current) – emoreno
Line 5: Line 5:
 //**Budget > Utilities > Update Budget Data**// //**Budget > Utilities > Update Budget Data**//
  
-<WRAP round intro>This page is used to transfer account codes and amounts from the Finance application to the Budget application master file. The amounts to be used for the update are based on the **Update Column** and the **Accounting Period** selections. Use this option after you have created the Budget master table. If you want to copy additional Fund/Year codes, then you must first use the Create Budget Data page. +<WRAP round intro>This utility is used to transfer account codes and amounts from the Finance application to the Budget application master file. The amounts to be used for the update are based on the **Update Column** and the **Accounting Period** selections. Use this option after you have created the Budget master table. If you want to copy additional Fund/Year codes, then you must first use the Create Budget Data page. 
  
 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 13: Line 13:
 ====Update budget data:==== ====Update budget data:====
  
- 
-<<screenshot of Update Budget Data>> 
  
 ^ Field                                        ^ Description   ^  /*Table with two rows*/ ^ Field                                        ^ Description   ^  /*Table with two rows*/
 ^From GL File ID|Select the prior year 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 the prior year 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.|
  
-Click **Retrieve** to update the **Accounting Period** options and fund information. +VCV Click **Retrieve** to update the **Accounting Period** options and fund information. 
  
-Select one of the following **Update Column** options:+VCV Under **Update Column**, select one of the following options:
  
-During budget processing, select **Amended** or **Actual** to update those columns in Budget for the selected fund/year codes.+VCV During budget processing, select **Amended** or **Actual** to update those columns in Budget for the selected fund/year codes.
  
  
-^Original|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.| +^Original|{{page>general:updatebudgetdata:original}}| 
-^Amended|Select if you have posted entries in Journal Budget or Amended Budget to Estimated Revenue or Appropriations and did not select **Original Budget Only** in the Move Budget to Finance utility.| +^Amended|{{page>general:updatebudgetdata:amended}}| 
-^Actual|Select if you have posted entries that have increased or decreased Realized Revenue, Encumbrance, or Expenditures in Finance.|+^Actual|{{page>general:updatebudgetdata:actual}}|
  
-Select one of the following **Account Code** options: +{{page>general:updatebudgetdata:accountcodeoptions}}
- +
-During budget processing, it is recommended that none of the below options are selected. +
- +
-^Include Inactive| Select to include inactive account codes and amounts in the list of available account codes to be transferred.| +
-^Use Crosswalk|Select to crosswalk any account code elements for the selected fund/years that exist in the Mask Crosswalk utility. See Mask Crosswalk (Mass Change Account Codes).| +
-^Only Existing Budget Accts|Select to include existing account codes and amounts in the list of available account codes to be transferred.|+
    
-Select one of the following **Accounting Period** options:+VCV Under **Accounting Period**, select one of the following options:
  
-During the budget processing, select **Current** month if the current month and next month are the same. If the current month and next month are different, select **Next**. +VCV During the budget processing, select the **Current** month if the current month and next month are the same. If the current month and next month are different, you can select **Next**. 
  
 ^Current|The accounting period is set to **Current** by default, which uses the current accounting period amounts from the Finance application to populate the Budget application amounts.|  ^Current|The accounting period is set to **Current** by default, which uses the current accounting period amounts from the Finance application to populate the Budget application amounts.| 
 ^Next|Select to create Budget data using the next accounting period amounts in the Finance application.| ^Next|Select to create Budget data using the next accounting period amounts in the Finance application.|
  
-Select one of the following **Object Description** options:+VCV Under **Object Description**, select one of the following options: 
 ^Description from GL (New Account Codes)|Select to update the new Budget account code descriptions based on the general ledger description.| ^Description from GL (New Account Codes)|Select to update the new Budget account code descriptions based on the general ledger description.|
-^Description from GL (All Account Codes)|Select to update the object description for all account codes.|+^Description from GL (All Account Codes)|Select to update the object description for all account codes. This description is retrieved from the Chart of Accounts. |
 ^Description from Budget Object Code Table|Select to update the object description for new account codes only.| ^Description from Budget Object Code Table|Select to update the object description for new account codes only.|
  
-All available fund/year codes from the Finance application are displayed on the left side of the page. Select the available fund/year codes to move to the right side of the page for the budget account code tables, general ledger accounts. Use the following buttons to move all from left to the right:+VCV All available fund/year codes from the Finance application are displayed on the left side of the page. Select the available fund/year codes to move to the right side of the page for the budget account code tables, general ledger accounts. Use the following buttons to move all from left to the right:
  
 {{page>general:fourarrowbuttons}} {{page>general:fourarrowbuttons}}
  
-^Execute|Click to execute the process. The Update Budget Data Report is displayed with the old and new account codes that were updated. ++Review the report.|{{page>general:printreport}}++| +{{page>general:updatebudgetdataexecute}}
-^Process|++Click to update the budget data.|{{page>general:budgetprocessutility}}++|+
  
 {{indexmenu_n>25}} {{indexmenu_n>25}}
budget/utilities/updatebudgetdata.1518023359.txt.gz · Last modified: 2018/02/07 12:09 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.