search-icon

This inventory report shows products in DEAR with Bills of Materials (BOM) along with the details of the components under each BOM. Use this report to see what components are required for a parent product, and the component amount available and on hand. The report can be filtered by BOM products in/not in a sale and the available component quantity. 


To access the report, go to Reports and, under the Inventory Reports section, click BOM Component Details. You can then search for a specific item, after which the report will display all the products containing this item in their BOM.  


For help in customising this report, see Managing DEAR Reports.


For example, if there are two (2) BOM products named Wine Pack of 24 and Wine Pack of 6, and there is a component product in these BOMs named Bottle of Wine with an SKU of 001, you can filter the report using either the product name (Bottle of Wine) or the SKU (001). The report will then display the two BOM products (Wine Pack of 24 and Wine Pack of 6) along with each of their components and the details of each component.


Input

The report inputs are shown in the table below.

Field NameDescription
Show
This is set to All Products by default. To filter the report, select either Components in Sale or Components not in a Sale.
Filter by Available
Enabled by default. If unchecked, removes the Show components where available quantity is less than field (see below) from the report.
Show components where available quantity is less than
Blank by default. Specify a quantity to filter the report.
Update
Updates the report.
Reset Layout
Resets the report layout.
Export
Allows the user to export report data to Excel (with or without totals), PDF or RTF format.


Outputs

After setting the inputs described above, pressing the Update button refreshes the report based on the selected inputs. The output fields are shown in the table below. Use the Search bar to look for a specific product or component from the report

Column NameDescription
Product SKU
The SKU of the parent product

Product

The name of the parent product
Component SKU
The SKU of the parent's component product(s)
Component
The name of the parent's component product(s)
Quantity
The quantity of the component product(s) required for parent product (s)
Available
The available quantity of the component product(s)
On Hand
The on-hand quantity of the component product(s)


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.