Assembly analytics

Path: Business functionality > Assembly management > Assembly analytics · tier official · system assembly · narrative reviewed (checked by Opus)

Overview

Assembly analytics is the reporting area for assembly management in Business Central. It gives production and business professionals insight into current and past assembly activity, assembly bills of materials (BOMs), component usage, cost and availability.

The pages fit together as one overview page plus one page per report. The reports fall into groups. BOM structure reports are Assembly BOMs, Assembly BOM - End Items, BOM - Sub-Assemblies, BOM - Raw Materials and Where-used list. Cost and sales reports are BOM Cost Share Distribution and Assemble to order - Sales. Availability is covered by Item - Able to Make (Time).

Start with “Assembly Reports and Analytics in Business Central” for the overview, then open the page for the specific report you need.

Key points

• Assembly Reports and Analytics in Business Central is the overview page for assembly reporting and analytics.
• Assembly BOMs lists assembly BOMs with component names, BOM numbers, quantities, units of measure and nested BOMs.
• Assembly BOM - End Items lists items or BOMs that are not components in other BOMs, with filtering by replenishment system.
• BOM - Sub-Assemblies shows subassembly components with base unit of measure, inventory, unit costs and alternative items.
• BOM - Raw Materials shows components with inventory levels, units of measure, vendors and lead times.
• Where-used list shows which BOMs contain selected items as components.
• BOM Cost Share Distribution uses pie charts to show material/labor and direct/indirect cost proportions of an item’s cost.
• Item - Able to Make (Time) tracks BOM item availability over time from supply, demand and component availability; Assemble to order - Sales shows component sales figures and profit margin.

Learn pages

• About Assemble to order - Sales (report): Analyze the quantity, cost, sales, and profit figures of assembly components. Analyses can support decisions such as whether to price a kit differently, or to stop or start using a particular item in assemblies.
• About the BOM - Sub-Assemblies (report): Get an overview of the components in a subassembly bill of materials, for both assembly and production.
• Assembly BOM - End Items (report): Get a list of items or bill of materials (BOMs) that are not components of any other BOMs.
• Assembly BOMs (report): Get an overview of Assembly Bill of Materials (BOMs), including BOMs that are part of the main BOM.
• Assembly Reports and Analytics in Business Central: See which assembly reports and analytics are available in the standard version of Business Central so that you can keep track of your business.
• BOM - Raw Materials (report): Get an overview about the needed components for an items bill of material (BOM), both for assembly and for production.
• BOM Cost Share Distribution (report): This report helps you decide whether to change component suppliers, or replace internal resources with outsourced labor (or vice versa). It also helps you review and modify an item’s bill of materials.
• Item - Able to Make (Time) (report): Check whether you can fulfill a sales order for an item by a specified date. Look at its current availability in combination with quantities that its components can supply if someone starts an assembly order.
• Where-used list (report): Get a list of the bill of materials (BOMs) that the selected items are components of. Use the report in case you must change a component in a BOM. For example, if your vendor can no longer deliver a specific item that you used for your assembly/production.

Business Central pages and reports

The pages, reports and queries this hub’s Learn pages name (ms.search.form, API reference), joined to the code by exact object id (data/index/docs-objects.json); a page shows the table it runs on.

• Page 900 “Assembly Order” · on Table 900 “Assembly Header”
• Page 901 “Assembly Order Subform” · captioned “Lines” · on Table 901 “Assembly Line”
• Page 902 “Assembly Orders” · on Table 900 “Assembly Header”
• Page 903 “Assembly Lines” · on Table 901 “Assembly Line”
• Page 904 “Assembly List” · on Table 900 “Assembly Header”
• Page 905 “Assembly Setup” · on Table 905 “Assembly Setup”
• Page 907 “Assembly Comment Sheet” · on Table 906 “Assembly Comment Line”
• Page 910 “Assembly Item - Details” · on Table 27 “Item”
• Page 914 “Assemble-to-Order Lines” · on Table 901 “Assembly Line”
• Page 915 “Asm.-to-Order Whse. Shpt. Line” · on Table 7321 “Warehouse Shipment Line”
• Page 916 “Assembly Order Statistics” · on Table 900 “Assembly Header”
• Page 920 “Posted Assembly Order” · on Table 910 “Posted Assembly Header”
• Page 921 “Posted Assembly Order Subform” · captioned “Lines” · on Table 911 “Posted Assembly Line”
• Page 922 “Posted Assembly Orders” · on Table 910 “Posted Assembly Header”
• Page 923 “Posted Asm. Order Statistics” · on Table 910 “Posted Assembly Header”
• Page 930 “Assembly Quote” · on Table 900 “Assembly Header”
• Page 931 “Assembly Quote Subform” · captioned “Lines” · on Table 901 “Assembly Line”
• Page 932 “Assembly Quotes” · on Table 900 “Assembly Header”
• Page 940 “Blanket Assembly Order” · on Table 900 “Assembly Header”
• Page 941 “Blanket Assembly Order Subform” · captioned “Lines” · on Table 901 “Assembly Line”
• Page 942 “Blanket Assembly Orders” · on Table 900 “Assembly Header”
• Report 801 “Assembly BOMs” · captioned “BOMs”
• Report 809 “Where-Used List”
• Report 810 “Assembly BOM - Raw Materials” · captioned “BOM - Raw Materials”
• Report 811 “Assembly BOM - Subassemblies” · captioned “BOM - Sub-Assemblies”
• Report 812 “Assembly BOM - End Items”
• Report 915 “Assemble to Order - Sales”
• Report 5871 “Item - Able to Make (Timeline)”
• Report 5872 “BOM Cost Share Distribution”

Source: Microsoft Learn (CC BY 4.0). Descriptions are Learn’s own.