Waste Reporting

The Waste Reporting screen provides an aggregated view of waste transactions for analysis and management reporting. It is a read-only enquiry screen — for editing individual waste records, use the Waste Log screen instead.

Purpose

The Waste Reporting screen is designed for supervisors and managers who need to analyse waste across a facility. It queries a reporting view that combines raw transaction data with calculated net weights and costs, and supports filtering by reporting groups, material types, locations, and date ranges. Results can be exported to Excel or printed.

Filtering

The following filters can be applied individually or in combination:

Filter	Description
Waste Material	Filter by a specific waste material code
Waste Location	Filter by the location where waste was recorded
Waste Container	Filter by the container type used
Reporting ID	Filter by Waste Reporting ID (a logical grouping of locations)
Waste Reason	Filter by the reason the waste occurred
Process Order	Filter transactions associated with a specific production order
User	Filter by the operator who recorded the transaction
Material Type	Dropdown — filter by waste material classification
Reporting Group	Dropdown — filter by the numeric reporting group
Transaction Type	Dropdown — filter by transaction type (e.g. Add, Remove)
Recyclable	Dropdown — Yes / No / All
Hazardous	Dropdown — Yes / No / All
Date From / Date To	Date range filters; each can be enabled independently using its checkbox
Limit Results	When enabled, restricts the result set to a specified number of rows

Lookup buttons are provided alongside the text filter fields to browse and select valid values.

Results Columns

Column	Description
Group	Reporting group number
Report ID	Waste Reporting ID
Location	Waste location ID
Container	Container type ID
Date Time	Timestamp of the transaction (YYYY-MM-DD HH:MM)
Transaction	Transaction type
Material	Waste material code
Mat Type	Waste material type classification
Reason	Reason code for the waste
Weight Kg	Gross weight recorded
Tare Weight	Container tare weight
Net Weight	Calculated: Gross Weight minus Tare Weight
Cost Per Kg	Unit cost for this waste material
Cost	Calculated: Net Weight multiplied by Cost Per Kg
Process Order	Production order associated with this transaction
Txn Ref	Transaction reference number (primary key)

Sorting

Results can be sorted by any column using the sort field dropdown and toggling between ascending and descending order. Column header clicks also sort the results.

Right-clicking a row provides a context menu with options to sort by the selected field, filter by the field value (which auto-populates the relevant filter field), or copy a field value to the clipboard.

Reporting Group and Reporting ID Hierarchy

Waste data is organised in a two-level reporting hierarchy:

Reporting Group — a numeric category grouping multiple Reporting IDs (for example, a factory zone or production area)
Reporting ID — a logical grouping of physical waste locations (for example, a production line that spans several physical waste points)

This hierarchy allows waste to be reported at any level of granularity, from an individual location up to a whole factory zone.

Export and Print

Excel — exports the full filtered result set to a file named waste_reporting.xls
Print — sends the filtered results to the system printer

Relationship to Waste Log

The Waste Reporting screen reads from the database view VIEW_WASTE_REPORTING, which aggregates data from the raw transaction table and joins it with material, location, and cost reference data. For viewing or editing individual transactions, use the Waste Log screen, which reads directly from APP_WASTE_LOG.