Budget > Utilities > Mass Change Account Codes > Mask Crosswalk
This tab is used to select elements of any 20-digit account code number and change it to another number, copying the account codes and balances for the old account to the new account. The old account and amount are deleted from the budget tables. The new account is accessible to all those whose user profile includes the new account codes. Single or multiple account code changes can be made on this page. Changes to account codes in next year payroll and end-of-year accruals (August accruals) can be easily and quickly changed using this function. Care should be taken when choosing these two options as they affect all next year payroll frequencies. These entries also affect the Create Budget Data, Update Budget Data, and Update Last Year Closing options.
The from and to account codes cannot be all Xs or all spaces. If all digits are entered in each component, the codes must exist in the code table. The account code components are checked as follows:
Object and function edits are as follows:
From Mask | Type the from fiscal year code you want to crosswalk. |
---|---|
To Mask | Type the to fiscal year code you want to crosswalk. |
❏ Click +Add to include additional account codes in the mask crosswalk.
NOTE: Verify the mask for accuracy. The data in the From Mask field is copied to what is in the To Mask field. If the account code for the To Mask field does not currently exist, the account code tables are automatically created and updated. When crosswalking from one fund/fiscal year to another fund/fiscal year only, the from fund/fiscal year from the fund code table is deleted.
❏ Under Object Description, select one of the following:
Existing Code Description from Budget |
Select to retrieve the existing code element description from the current budget. |
---|---|
New Object Description from Object Table | Select to replace the current description from the budget with the object code description in the account code table. |
❏ Under Options, select one of the following if changes need to be made to transactions related to the budget:
Do not select any options if following the Budget Processing steps.
NOTE: If any of the below options are selected, it is highly recommended that the Payroll > Utilities > Export Pay Tables utility be used to create a backup of each pay frequency before continuing to process this crosswalk. However, if Update PMIS Forecast Distribution is the only option selected, do not run the Payroll > Utilities > Export Pay Tables utility before continuing to process this crosswalk.
Update Payroll Distributions | Select to change all payroll distribution account codes in next year payroll that match the from mask are changed to the to mask account code. This updates all next year payroll frequencies. |
---|---|
Update EOY Accrual Data | Select to change account codes in the EOY accrual work table. If this crosswalk has funds and fiscal years that also exist in the EOY Payroll Accruals, Run Calculations tab and some of those funds/fiscal years have been selected to not decrement (Funds/Yrs to not Decrement field), the new fund and fiscal year used for expensing the EOY accruals will not be decremented. Example: Fund 211/1 was included with other funds in the Funds/Yrs to not Decrement field when the EOY Payroll Accrual, Run Calculations was performed. In the Mask Crosswalk, you have selected to change fund 211/1 to 215/1. Then, the same logic of not decrementing the fiscal year will apply to the new fund. Accrual reports reflect fund 215/1, and that fund/fiscal year will be what is posted to Finance. If a fund/fiscal year in the Mask Crosswalk was not included in funds/years to not decrement, decrementing of the fiscal year will apply to the new fund. The user should evaluate the entries on the EOY Payroll Accruals, Decrement tab for accuracy if the from fund/fiscal year is not the same as the to fund/fiscal year.
|
Update NY Payroll Budget | Select to change all account codes in the next year payroll budget that matches the from mask are changed to the to mask account code. This updates all next year payroll frequencies. |
Update PMIS Forecast Distribution | Select to update next year Position Management distribution records. When this option is selected, a Budget export should be processed. |
❏ Click Reset to clear all crosswalk records and reset all previously selected options to the default.
❏ Click Execute to initiate the mask crosswalk.
A message is displayed indicating that the process was successfully completed. Click OK.
❏ Click Cancel to discard the mask crosswalk and close the page without changing any account codes.
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.