Generate Cost Neutrality Spreadsheet

Contents ShowHide

The Generate Cost Neutrality Spreadsheet screen is used to generate the Cost Neutrality Spreadsheet (Output).

For detailed information about the system output generated, see Cost Neutrality Spreadsheet (Output).

The Generate Cost Neutrality Spreadsheet screen is available in the following applications:

Vendor

Generate Cost Neutrality Spreadsheet screen

Screen Access

Display the Generate Reports screen > Double-click Cost Neutrality Spreadsheet.

Interface Initialization

Upon initial display of the screen, the following occurs:

The title bar text is set to "Generate Cost Neutrality Spreadsheet".

The Date Range group box is visible, enabled, and presented as follows:.

The From calendar control is visible, enabled, and blank.
The To calendar control in visible, enabled, and blank.

The Quarter drop-down list box in the Selected Dates by Quarter (optional) group box is blank as the default.
The Fiscal Year drop-down list box in the Selected Dates by Quarter (optional) group box is blank as the default.

The OK button is visible and enabled as the default.

The Cancel button is visible and enabled as the default.

Screen Elements

Unless otherwise stated below, all controls on the Generate Cost Neutrality Spreadsheet screen are visible and enabled when:

The screen is active.

If one or more special conditions exist that affect a control on the Generate Cost Neutrality Spreadsheet screen, the condition(s) are documented for that specific control below.

Date Range group box

Complete the information in the Date Range group box.

This group box includes calendar controls that allow you to specify the date range for which to generate the system output. The title text of the group box is set to "Date Range". Complete the information in the following calendar controls to specify the date range the system output will cover:

From calendar control

Select or enter the starting date of the date range in this calendar control.

To calendar control

Select or enter the ending date of the date range in this calendar control.

The From date entered must be equal to or less than the To date entered. If not, a standard error message (E0047) displays when the screen is processed.

Selected Dates by Quarter (optional) group box

Complete the information in the Selected Dates by Quarter (optional) group box.

This group box includes controls that allow you to specify the financial quarter and fiscal year for which to generate the system output. The title text of the group box is set to "Select Dates by Quarter (optional)". Complete information in the following controls:

Quarter drop-down list box

Select the quarter designation of "October-December", "January-March", "April-June", or "July-September" from this drop-down list box. When a Quarter and a Fiscal Year are selected, the From and To Dates are automatically populated with the starting and ending dates of the quarter.

Fiscal Year drop-down list box

Select the fiscal year from this drop-down list box.

OK button

Click the OK button to generate the system output.

It is the default button for the screen.

It does not have a mnemonic. Its keyboard shortcut is the Enter key.

A Windows Save As screen displays when the button is clicked.

Cancel button

Click the Cancel button to close the screen without generating the system output.

It does not have a mnemonic. Its keyboard shortcut is the Esc (escape) key.

The Generate Reports screen displays when the button is clicked.

Processing

If data can be validated and saved on the screen, the following processes occur when the screen is processed:

A process to check for required controls as identified in the Data Map below is performed.
A process to check for valid entries as identified individually for each applicable control in Screen Elements above is performed.
A process to check for edits and cross edits as identified for each applicable control in Screen Elements above is performed.
If any checks or processes fail, a standard error message displays.

If no data can be validated and saved on the screen:

No cross edits are performed.
All values are considered legitimate.
No data is written to the database.

Data Map

The Data Map defines the values saved for all controls on the screen. If available, any additional notes or comments are displayed in the Notes column.

Control Label	Required
Date Range	X (or Select Dates by Quarter)
Selected Dates by Quarter (optional)	X (or Date Range)

Software Version: 2.40.00