Business

User Tools

Site Tools

Trace:
budget:utilities:createbudgetdata

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:createbudgetdata [2017/05/10 16:14] – emorenobudget:utilities:createbudgetdata [2021/01/27 17:20] (current) – emoreno
Line 5: Line 5:
 //**Budget > Utilities > Create Budget Data**// //**Budget > Utilities > Create Budget Data**//
  
-<WRAP round intro>This page is used to automatically transfer account codes and amounts from the Finance application to the Budget master file. This utility transfers balances and associated account codes from the Finance Original Budget (Estimated Revenues and Appropriations), Amended Budget (Estimated Revenue and Appropriations), and Actual Amount (Realized Revenue, Encumbrances and Expenditures) columns. The transfer can be from either the current or next accounting period amounts. Use this option when creating the Budget master table for the first time. Processing this selection multiple times does not create duplicate accounts, but does update existing budget balances and account codes being transferred from the Finance application to the Budget application.+<WRAP round intro>This utility is used to automatically transfer account codes and amounts from the Finance application to the Budget master file. This utility transfers balances and associated account codes from the Finance Original Budget (Estimated Revenues and Appropriations), Amended Budget (Estimated Revenue and Appropriations), and Actual Amount (Realized Revenue, Encumbrances and Expenditures) columns. The transfer can be from either the current or next accounting period amounts. Use this option when creating the Budget master table for the first time. Processing this selection multiple times does not create duplicate accounts, but does update existing budget balances and account codes being transferred from the Finance application to the Budget application.
  
 **Note**:  Records that exist in the Mass Change Account Codes, Mask Crosswalk option affect the accounts that are created or updated when using this option. **Note**:  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 a 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 **Retreive** to update the **Accounting Period** options and fund information. +VCV Click **Retrieve** to update the **Accounting Period** options and fund information.  
 + 
 +VCV Under **Account Code**, select one of the following options:
  
-Select one of the following **Account Code** options: 
 ^Include Inactive| Select to include inactive account codes and amounts in the list of available account codes to be transferred.| ^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).| ^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).|
  
-Select one of the following **Accounting Period** options:+VCV Under **Accounting Period**, select one of the following options: 
 ^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.|
 ^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, and amounts using the following buttons:+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, and amounts using the following buttons:
  
 {{page>general:fourarrowbuttons}} {{page>general:fourarrowbuttons}}
  
-^Execute|Click to execute the process. The Create Budget Data Report is displayed with the old fund/fiscal year account codes and amounts as well as the new fund/fiscal year account codes and associated amounts that are being transferred to Budget. ++Review the report.|{{page>general:printreport}}++| +VCV Click **Execute** to execute the process. The Create Budget Data Report is displayed with the old fund/fiscal year account codes and amounts as well as the new fund/fiscal year account codes and associated amounts that are being transferred to Budget. [[general:printreport|Review the report.]] 
-^Process|Click to create the budget data.++|{{page>general:budgetprocessutility}}++|+ 
 +VCV Click **Execute** to create the budget data. You are prompted to create a [[general:financebackup|backup]]. 
 + 
 +{{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> 
  
 <color red>**Caution**: If there are accounts in the Budget file ID that have been updated that do not exist in the Finance file ID, those accounts are not updated, and the totals in Finance and Budget may not match.</color> <color red>**Caution**: If there are accounts in the Budget file ID that have been updated that do not exist in the Finance file ID, those accounts are not updated, and the totals in Finance and Budget may not match.</color>
 +
 +{{indexmenu_n>20}}
budget/utilities/createbudgetdata.1494432863.txt.gz · Last modified: 2017/05/10 11:14 (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.