Contract Price Update - Test Report

With the Contract Price Update - Test report, you can test which service contracts need price updates up to the date that you have specified. The report shows the contracts numbers, customer numbers, contract amounts, price update percentages and any errors that occur.

You can refine the information which the program will include in your report by applying filters to specific fields. To do this, in the Field field, press F3, click the AssistButton, and then select the relevant field(s). In the Filter field, enter the values that you want to use in the filters applied to the fields you have selected. You can set filters on any of the fields. If you do not set any filters, the report will include all your records.

To print the report, click the Print button. To see the report on screen, click Preview. If you do not want to print the report now, click Cancel to close the window.

To filter the information in the report, in the Filter field, fill in the relevant information as follows:

Service Contract tab

Contract No.: Here you can enter the contract numbers that you want to include in the report.

Item Filter: Here you can specify which items you want to include in the report. To see the existing item numbers, click the Filter field, then click the AssistButton that appears to the right.

Click the up-arrow in the lower left-hand corner of the window to see the result of the filters that you have defined for the table.

Options tab

Update to Date: Enter the date up to which you want to update prices. The report will include contracts with next price update dates on or before this date.

Price Update %: Enter the price update for the service item contract values in percentages.

Related Topics

Entering Criteria in Filters

Sorting

 



© 2009 Microsoft Corporation. All rights reserved.