Add Conditions to Price SchedulesAdd Conditions to Price SchedulesYou add conditions to a price schedule in the Customer Agreements (SP) application. Conditions include a classification, priority, included services or service groups, and other conditions that you define. Adding conditions to a price schedule makes the price schedule applicable only to tickets, work orders, or sales orders with the same conditions. If you do not specify conditions on the price schedule, it can be applied to records with any conditions.
Note: Other matching criteria apply. See the topic About Price Schedules for more information about matching price schedules to tickets, work orders, and sales orders.
In the Customer Agreements (SP) application, display the customer agreement with the price schedule to which you want to add conditions.
Click the Price Schedules tab, and then click the Conditions subtab.
To specify a
classification, in the Classification
field, enter a value or click Detail Menu 
to select an
option and retrieve a value.
To specify an
internal priority, in the Internal Priority
field, click Select Value 
to enter a comparison selector.
In the next field, enter a numerical value.
To specify a service group or service, in the Included Services table, click New Row. Select a service group or a service. Add more rows as needed.
To specify a structured condition that compares values in fields, in the Conditions table, click Add First Row and specify the conditions. For more information about specifying conditions, see the topic Add Structured Conditions to a Price Schedule.
To specify free-form conditions with the SQL Expression builder, take the following steps:
In the Additional Price
Schedule Criteria table, click Maximize Section 
.
Click SQL Expression
Builder 
to open the SQL Expression Builder dialog box.
Build your SQL expression. For help using this dialog box, see the topic Use the SQL Expression Builder.
Click OK to save the expression. The expression displays in the Condition field.
Click Save Agreement
.
Note: To modify your selections after approving the record, create a revision to the record.
Add Services to a Price Schedule