Material Usage report

The Material Usage report displays all of the batches that used a specified material during a specified time period. This report has a Material Usage table plus a header section. The header displays the specifics of the material and the amount consumed. The Material Usage table displays a list of batches that used the material. The report lists:

Expand the Batch to view associated Units used with the amount of material consumed.

This report has hyperlinks to these reports:

This report features filters for

Date

and

Time

ranges,

Process Cell

,

Unit Name

,

Recipe Name

, and

Material Name

. The

Batch ID

filter can filter data by inputting search criteria in the form of a

Batch Name

. Use the asterisk (*) as a wildcard character.

The

Number of Rows

filter allows users a way to be able to limit how many rows of data the database query returns to the report. This filter is set to 1000 by default.

While this can be useful in limiting the amount of data returned from a dataset and displayed in a report, it can lead to confusion when used in conjunction with other filters such as Recipe Name, Process Cell, Unit Name, etc.

If a user wants to filter data shown in a report using any of the filters other than

Number of Rows

, the

Number of Rows

filter should be changed from 1000 to 0. This ensures all rows of data are filtered as specified and displayed correctly.