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.
The report inputs are shown in the table below.
|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.|
|Updates the report.|
|Resets the report layout.|
|Allows the user to export report data to Excel (with or without totals), PDF or RTF format.|
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
|The SKU of the parent product|
|The name of the parent product|
|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)|