Assembly Bill of Materials Report

Assembly Bill of Materials Report

Overview

If you have ever wanted to see a quick look at what assemblies a product is used in, this report will do the trick.   Complete the steps below once and save,  and you can run the report whenever you need it.   The report will be grouped by raw material (bill of materials item) and list each assembly that uses it and the quantities needed.

Setting up and Running the Report

  1. Navigate to Reports / Universal Report
  2. In the first drop down, choose Information Register.
  3. In the second drop down, choose Assembly BOM.
  4. Click the Show Settings button.
  5. Click the Grouping tab.
  6. Click the Add button.
  7. Click the plus sign next to Material.
  8. Find Material.Description and double click it.
  9. Click the Indicators tab.
  10. Uncheck Product, Material and Material Parent.
  11. Click the Add New Field button.
  12. Scroll down to Material Parent and click the plus sign.
  13. In the expanded field section, double click Description.
  14. Ensure the new field is  in the list as Material Parent.Description.
  15. HIghlight this new entry and click the blue up arrow until it is located directly under Material Level.
  16. Click Save Settings.
  17. Give the report a name
  18. Click Save.
  19. Click Run Report.
  20. Click the star next to the report name to save it in your favorites for easy access. (optional)
See screenshots below.
Explanation:   
Step 1 is navigation.
Steps 2-3 define the tables where the data is coming from.
Steps 4-8 define how the data will be grouped in the report.
Steps 9-15 define which fields will appear in the report and in which order.
Steps 16-18 save what you did in Steps 2-15 so you don't have to do this the next time you want to run the report.
Step 19 runs the report.
Step 20 saves the report to your favorites list.







    • Related Articles

    • Assembly/Bill of Materials

      Assembly CustomBooks™ has Assembly/Bill of Materials (BOM) functionality commonly used in the manufacturing industry, among others. The Assembly/BOM feature allows users to list all the components, raw materials, services or labor, and sub-assemblies ...

    • Assembly FAQ

      1.) I read somewhere that you have assemblies. What is an assembly? CustomBooks™ has Assembly or Bill of Materials (BOM) functionality commonly used in the manufacturing industry, among others. The Bill of Materials in CustomBooks™ allows you to ...

    • How do I print the components of an assembly build on a printed sales invoice?

      By default just the final product is printed on printed documents. There is an option to print the components on the sales invoice, however. To do so, take the following steps: 1) Navigate to Quick Menu → Settings → Print form setup. 2) Click Sales ...

    • Running Reports

      Overview Reports in CustomBooks™ are located in the Reports menu . They are broken down by module and are available in the menu for modules included in your edition of CustomBooks™. Common Features Across Reports Report Command Bar Run report - runs ...

    • CustomBooks™ Reports

      Reporting CustomBooks™ has a complete set of financial, operational and project based reports. Our advanced reporting customization features allow you to create the report you want. To run a report, Navigate to Reports → Report Category (Ex. Sales) → ...