Requested - BUD6500

Budget > Utilities > Mass Increase/Decrease Account Codes > Requested

This tab is used to generate requested-level budget simulations for selected accounts based on account values from either the last year closing, this year original budget, this year amended budget, this year actual, or the next year requested columns from the Requested tab of the Budget Data Maintenance page.

Each simulation can have multiple sequences. Each simulation sequence is performed in the order listed (e.g., The first sequence could affect accounts within the mask of 199-XX-63XX-XX-X-XXXX by multiplying the This Yr Actual Amt column by 10% and populating the result in the Next Yr Requested column. The second sequence could affect accounts within the mask of 199-XX-62XX-XX-X-XXXX by adding $200.00 to the This Yr Amend Budget column and populating the result in the Next Yr Requested column.). You can only view your simulations.

The utility enables you to create a simulation that will provide a report of how accounts are affected but will not automatically update the selected accounts and amounts. Only when the user selects Budget Level Processing and processes the simulation will the accounts and amounts be updated in the Next Yr Requested column.

Note: Simulations are based on the user profile of the logged-on user. Requested-level users do not have access to the 61XX payroll accounts even if they are included in the account selection criteria. If any accounts in the selection criteria are not available to the user on the user profile at the time the simulation is executed, those accounts are not included in the calculations.

Example: If your user profile only allows you access to 62XX accounts and you choose as part of the criteria to update all 6XXX accounts, only those accounts that met the 62XX criteria are reflected in the preview report when the simulation is executed. No 61XX, 63XX, 64XX, etc. are included in the calculations.

Mass increase/decrease account codes at the requested level:

Field Description
Simulation Name

Type a name for a new simulation. The field can be a maximum of seven characters and is a required field. Or, type the name of an existing simulation, and click Retrieve.

To search for a specific simulation, click Directory.
In the Search field, type a name for the simulation. A list of simulations that match the data you entered is displayed.
To search through all available data, leave the Search field blank.
Select a simulation name from the list.
Otherwise, click Cancel.

Simulation Description

Type a description for the simulation. The field can be a maximum of 30 characters.

Base Column

Select a column on which to base the simulation calculations. This is a required field.

Round to Nearest Dollar Amount

Select if all calculations are to be rounded during the simulation. If not selected, exact calculated amounts are displayed.

Cutoff Date

The date that account updates are no longer allowed is displayed.

If the district uses cutoff dates, simulation data cannot be created after the displayed cutoff date.

If the district does not use cutoff dates, simulation data can be created at any time up to final budget approval.

❏ Click +Add to add a sequence row to the grid.

Seq NbrThe sequence row is automatically displayed.
Account Code

The 20-character account code mask with all Xs is displayed.

Only populate the account code elements to be modified during the simulation (e.g., 199 for all 199 account codes). Use a mask with all Xs to change all accounts.

Even if a mask is used, only those accounts that match your user profile are included in the calculations.

OperatorSelect the operator function (i.e., Multiply, Add, Equal or No Change) to be applied to the simulation.
Percent/AmountType the value the operator applies to the simulation.


Multiply - entered as a percentage value (e.g., 0.00000). When Multiply is selected, the percentage entered in this field is multiplied by the value of the selected column in the Base Column field. The result is used to update the Next Yr Approved column.

Add - entered as a dollar value (e.g., 1,500.00). When Add is selected, the amount entered in this field is added to the value of the selected column in the Base Column field. The result is used to update the Next Yr Approved column.

Equals - entered as a dollar value (e.g., 1,000.00). When Equal is selected, the amount entered in this field is used to update the Next Yr Approved column. The value of the selected column in the Base Column field is not used for the calculations.

No Change - set to a noneditable 0.00. When No Change is selected, the Next Yr Approved column is updated by the value of the selected column in the Base Column field.

❏ Click Save.

❏ Click Copy to copy the simulation. The copy from simulation window is displayed with a list of all saved simulations.

  • Select an existing simulation name from the list.
  • Click OK. The window is closed, and the copied simulation populates all the fields on the tab.

❏ Click Execute to execute the process. A Mass Increase/Decrease Budget Account Code Report is displayed. Review the report.

❏ Click Process to complete the simulation process.

❏ Click Cancel to return to the Requested tab of the Mass Increase/Decrease Account Codes page.

Other functions and features:

Retrieve

The Retrieve button is also used to retrieve information from the last save. If you click Retrieve, any unsaved changes are lost.

Delete

Click to delete the selected simulation.

Trashcan Icon

Click to delete a row. The row is shaded red to indicate that it will be deleted when the record is saved.

Click Save.