Custom Threshold Report

The Custom Threshold Report is only available for SDS Management and SDS/Chemical Management accounts.

The information in this article is specific to the Custom Threshold Report. If you need information on reports in general see Reports Overview.

The Custom Threshold report compares the quantity of your products’ ingredients in your account on a specific date to any custom threshold you set either when you indexed the ingredient or that you entered in the Master Chemical List.

Note that this report will only include results for products for which you have indexed ingredients and created containers. See Ingredient Indexing and Creating and Managing Containers for more information.

The ingredient quantity is calculated by multiplying the total container weight by the ingredient’s % by weight. The % by weight is the upper end of the range when “Between” is selected; 100% when “Greater Than” is selected; and the amount entered when “Less Than” or “Equal To” is selected. If the % by weight is not entered or you select N/A when indexing the ingredients then the quantities cannot be calculated.

Select Products

By default, all locations are selected. To choose specific locations, click the Select Locations button.

If you have created reporting groups, you can select Products by Reporting Group which allows you to select a reporting group from the drop-down menu. If you have not created reporting groups this option will be grayed out. See Creating Reporting Groups for more information.

Select Date

The report must be run for a specific date, and will compare the quantity of your products’ ingredients to the custom threshold for all Active containers on that date

Click in the field to bring up a calendar. Use the calendar to select the date.

Select Display Options

If you want your report to add product quantities together and list the total by ingredient, select List by total quantity of ingredient.

If you want more detail about the products and locations for each ingredient, select List by quantity of ingredient by products and locations.

Ingredient quantity is listed by weight in pounds. You must index the specific gravity or vapor density for your products for the system to complete this calculation.

Select Report Columns

Once you’ve selected which products to include on the report, choose the data that you would like to appear in the report columns for each ingredient or product.

Some columns will be required and cannot be unchecked. You can select as many additional columns as you need.

Once you’ve made all of the selections for your Custom Threshold Report, click the Run Report button at the bottom of the page.