Navigation:  Business Operations > Cost Centre Rate Scenario >

Results

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
Show/Hide Hidden Text

On this tab the following fields can be viewed:

hmtoggle_plus1Grid

The grid is used to view the result set calculated according to the specified SQL query, to update this result set where necessary and to save this result set to the Cost Centre Rate Scenario table (Save button). Or to view saved results displayed from the Cost Centre Rate Scenario table and to maintain (Save button) or delete (Delete button) these results.

 

The grid consists of maintainable and non-maintainable columns.

The non-maintainable columns consist of the:

Cost Centre, Description, Financial Year, Calculated Labour Rate, Calculated Variable Overhead Rate, Calculated Fixed Overhead Rate and Calculated Charge Out rate.

 

The calculated columns are used to serve as a reference when the user changes values in the adjusted value columns.

 

The maintainable columns consist of the:

Adjusted Labour Rate, Adjusted Variable Overhead Rate, Adjusted Fixed Overhead Rate and Adjusted Charge Out rate.

 

When the result is displayed in the grid, the calculated value will be equal to the adjusted value.

 

These columns is used to enable the user to do final adjustments to cost Centre values before the result is saved to the Cost Centre Rate Scenario table.

 

Take not that the adjusted value will be saved to the Cost Centre Rate Scenario table.

 

These columns will only be maintainable under the following conditions:

A result is displayed in the grid.

The status of the selected Scenario is equal to created.

 

Take note that individual cost centres can be maintained on the Cost Centre Rate Scenario tab (Cost Centre function) before or after the data was saved to the Cost Centre Rate Scenario table. If the data was maintained before the data was saved, take note that if the Override Existing Records check box was checked when the data was saved, the value will be replaced by the value as displayed in the grid (Adjusted column).

hmtoggle_plus1Results Function

This tab is used to enable the user to:

View Saved SQL Results (View Options).

 

Save a new or existing result or Delete an existing saved result (To Save Or Delete Result).  Copy an existing approved result to the Cost Centre Financial Year Data table (Copy Price).

 

Take note that after the Test button is applied, the Result Errors tab will be displayed if any errors exist or if no errors exist the Results tab will be displayed. The user has the option to view the results even if errors do exist.

hmtoggle_plus1To Save Or Delete Result

This frame is used to enable the user to:

Save a new result to a selected financial year where the user has the option to override existing records or not.

 

To save results the following has to be complied to:

A Scenario and Created By have to be selected.

 

And the result of the specified SQL query (SQL Routine) has to be displayed in the Grid.

 

And all records have to be displayed in the grid meaning that the Max Rows To Return value has to be equal to "All".

 

And the signed - on employee has to be equal to the selected created by employee.

 

And the signed - on employee has to have a profile, linked to the Cost Centre Rate Scenario function with Add, Change and Delete rights.

 

And the Status of the selected scenario has to be equal to created.

 

And a financial year has to be selected in the financial year combo box. This combo box populates with financial years from the Financial Year table.

 

Take note that the values as displayed in the calculated columns in the grid will be saved.

 

To delete results the following has to be complied to when the button is applied:

A Scenario and Created By have to be selected.

 

The result of the specified SQL query (SQL Routine) has to be displayed in the Grid.

 

And the result has to exist on the Cost Centre Rate Scenario table.

 

And the signed - on employee has to be equal to the selected created by employee.

 

And the signed - on employee has to have a profile, linked to the Cost Centre Rate Scenario function with at least Inquiry and Delete rights.

 

And the Status of the selected scenario has to be equal to created.

 

Override Existing Records check box:

This check box is used in conjunction with the Save button and the Financial Year combo box.

 

If this check box is checked when the signed - on employee saves a result all existing records on the Cost Centre Rate Scenario table will be replaced with the new records.

 

If this check box is unchecked when the signed - on employee saves a result only records that does not exist on the Part Price Scenario table will be inserted.

hmtoggle_plus1View Current Sql Results

This frame is used to enable the user to view:

Current SQL Results:

The Current SQL Results option is used to enable the user to view the specified SQL query on the SQL Routine tab.

 

This option will only be available after a Scenario and Created By were selected.

 

Saved SQL Results

The Saved SQL Results option is used to enable the user to view an existing SQL query from the Cost Centre Rate Scenario SQL table.

 

This option is used in conjunction with the financial year to be specified in the financial year combo box. Take note that this combo box will only be enabled after the View Saved SQL Result option was selected and will only populate with financial years that exist on the Cost Centre Rate Scenario SQL table.

 

Show button:

To view the specified SQL query in the SQL routine tab or to view an existing SQL query from the Cost Centre Rate Scenario table the following has to be complied to when the show button is applied:

A scenario code and created by employee have to be selected.

 

The View Current SQL Results option has to be selected.

 

Or the View Saved SQL Results option including a financial year have to be selected.

 

When the show button is applied the result will be displayed in the Grid.