Run the Reverse Product Explosion Report for a specific component

The Reverse Product Explosion report lists each product that is a component of another product through the bill of materials. For each component product it shows which main products it's linked to.

NOTE: The report is only available in the Additional Reports Backup.

If you need to run this report for only a specific component stock code, you must first edit the report and replace the existing criteria with new criteria.

Step 1 - Edit the report

1. Select the Reverse Product Explosion Report, then click Edit.
2. On the menu bar click Report, click Report Properties.
3. Enter a new report name and description, then click OK.

Step 2 - Add the new criteria

1. Click Report, then click Criteria.
2. Select the Show Disabled check box.
3. Select STOCK_CAT, then click Remove, then click Yes.
4. Select STOCK_CODE, then click Remove, then click Yes.
5. Click New Criteria, then click COMPONENT from the first drop-down list.
6. Select STOCK_CODE from the second drop-down list.
7. Click OK.
8. In the Criterion name field, enter STOCK_CODE.
9. Click OK, then click OK.
10. In the Page Header 2 section delete the following:
    
    • Category From: text box
    • Category To: text box
    • CRITERIA.STOCK_CAT_FROM variable
    • CRITERIA.STOCK_CAT_TO variable

Step 3 - Save the report

1. On the menu bar click File, then click Save As.
2. Enter a new file name then click Save.
3. On the menu bar click File, then click Exit

When you run the new report you can specify the component stock code you need.

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.