Base Rate Chart Types - Use custom stored procedure

Owned by Michelle Cabaya
Last updated: Jan 19, 2023
2 min read

"Use custom stored procedure" is used to apply a custom rating procedure. Enter the stored procedure name in "Proc Name". 

How to Create a New Use custom stored procedure Base Rate Chart

  1. Click the arrow next to the New button, or press the N key. 

  2. Click Rate Charts. 

  3. Select Base Rate. 

  4. Under Chart Type select "Use custom stored procedure". 

  5. Select the Rate zone to be used .

  6. For Proc Name, enter the custom stored procedure to be used when calculating the rate.

  7. Click Apply to save the rate chart and keep it open or click OK to save and close the rate chart.

See Base Rate Charts - New / Edit Base Rate Chart for more information on base rate charts.

Example

Orders using Base Chart ID 1 with order type "Example One Hour Order" will rate based upon the custom stored procedure "ENTER STORED PROC NAME HERE".