Commodity Average Cost Per Month compares recorded receipt costs across a rolling 12-month period ending in the selected month and year. Results are arranged by item and vendor, with a column for each month.

Each monthly value is the arithmetic average of stock cost records received during that month. Months without matching cost records appear blank; the query does not calculate a quantity-weighted average.

Select the month and year that should end the 12-month comparison.

Run the report. Selecting October 2026 displays November 2025 through October 2026 in the example.

Compare monthly values for each item/vendor combination, taking account of its displayed bulk unit.

The example below uses fictional records populated into the report’s Jasper layout. Demonstration labels have been added; the content and number of pages depend on your data and selected options.

The report contains:

• Item and vendor — Vendor code and name, item code and description, and bulk unit identify each cost series.
• Monthly average costs — Twelve month columns show average stock cost; a blank indicates no non-null cost records for that month.

This report does not include links to other reports.