Master Class

Essential Reporting Knowledge

Full Product BOM

Summary

Full Product BOM expands a finished product into its formula, ingredient and packaging requirements. The report shows the quantities, units, costs and work centers returned by the bill-of-materials query.

Use the standard layout for reading by product, or select Excel Friendly Format for a flatter export layout. The example shows the requirements for a fictional 1,000-bottle product batch.

Report Setup

Select a product formula, or leave the product selection blank to include all matching products.

Leave Excel Friendly Format clear for the standard grouped report, or select it for the alternate export layout.

Run the report and review the component quantities and costs under each product heading.

Example input controls, reconstructed from the report parameters. Installed labels, choices and defaults may differ.Click the image to enlarge.

Sample Report

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:

  • Product heading — Product code and description with the formula's default quantity and unit.
  • BOM detail — Commodity code and description, expanded quantity and unit, and item type: product formula, batch formula, ingredient or packaging.
  • Cost and work center — Component cost, work center and the source SC field. Purchased items are shown with Purchasing as their work center.

This report does not include links to other reports.

Report example

Scroll to read the image. Press Esc to close.

Was this page helpful?
YesNo