Report overview

Business Central comes with many built-in reports that businesses can use out-of-the-box.

> [!TIP] > If you have a production environment for Business Central online, you can click on a report ID in the following table to open the report in the product. If you want to stay on this page, hold down CTRL before you click. In most browsers, the report opens in a new browser tab..

Financial reports

The following table describes some key financial reports.

Report Description ID
Trial Balance Shows the chart of accounts with balances and net changes. You can choose to see a trial balance for selected dimensions or use the report at the close of an accounting period or fiscal year. 6
Trial Balance by Period Shows the opening balance by general ledger account, the movements in the selected period of month, quarter, or year, and the resulting closing balance.
Tip: The report can display profit and loss (P&L) with a total for each month.
38
Trial Balance/Budget Shows a trial balance in comparison to a budget. You can choose to see a trial balance for selected dimensions. Use this report at the close of an accounting period or fiscal year. 9
Detailed Trial Balance Shows a detailed trial balance for selected general ledger accounts. You can define which accounts are included in the report by setting filters. Use this report at the close of an accounting period or fiscal year. 4
Trial Balance/Previous Year Shows a trial balance in comparison to the previous year's figures. You can choose to see a trial balance for selected dimensions. Use this report at the close of an accounting period or fiscal year. The previous year means the same period one calendar year earlier. 7
Financial Report Financial reports can be used to display general ledger accounts in a different way than in the chart of accounts. For example, financial reports can be used to report on key figures. 25
Consolidated Trial Balance Shows a combined overview of general ledger entries for two or more companies in one consolidated company. Use this to report on consolidated financial data from multiple companies. Learn more at Set Up Company Consolidation. 17
Consolidated Trial Balance (4) Shows a combined overview of general ledger entries for two or more companies in one consolidated company. This version of the report lets you display up to four business units as columns. Learn more at Set Up Company Consolidation. Use this to report on consolidated financial data from multiple companies. 18

For more information, see Financial Reports and Analytics in Business Central.

Accounts receivable reports

The following table describes some of the key reports in accounts receivable.

Report Description ID
Aged Accounts Receivables Shows the amount outstanding with customers broken down into time intervals for the overdue time. The report also displays the part of the customers' balance that isn't due and can be shown with or without document details for each customer. This report is the main report for reconciling customer ledger to G/L. Assuming you don't allow direct posting to the accounts used in the customer posting groups' receivables account, this report is a specification of the amounts you find in the G/L. 120
Customer Statement Generates a customer statement for a specified time interval. You can send the report to customers to give them an overview of outstanding amounts and also as a payment reminder about overdue amounts. You can choose to show the overdue amounts in a separate section. You can include an aging band similar to the one used in the Aged Receivables report. For the aging band, you typically set 30D. 30D means 30 day intervals such as 30, 60, 90, and 90 days overdue. The intervals start from the ending date, or 1M+CM. 1M+CM is the current month in a separate interval and then monthly intervals for the preceding months. Note: In the customer list, this report also has a Scheduled Statements action. This action doesn't filter to the selected customer. It's the same report but used when you want to send statement to all or more customers. You can filter the report so that it shows only entries that are still open for the customer. To apply the filter when you're setting up the report, in the Statement Style field, choose Open Items. 1316
Customer - Balance to Date Shows the open customer ledger entries until the ending date. This report shows similar content as the customer statement but with no indication if the entry is overdue. Note: The date filter is applied to the detailed customer ledger entries. You might have payments later than the ending date but are applied to invoices within the date range. Those invoices appear in the report because they weren't closed as per the ending date. 121
Customer - Trial Balance Shows the net changes for customers for the period specified in the date filter. It also shows the net change year-to-date for the fiscal year for the selected period. The report is grouped by customer posting groups and gives a different view of the customer ledger than the Aged Account Receivables report. Note: If you don't set up accounting periods, Business Central doesn't know which fiscal year to use. It shows either year-to-date from the most recent fiscal year defined or just selects the period. The period might or might not be from the beginning of a year. 129
Customer - Detail Trial Balance Shows all the customer ledger entries within the specified date filter. This report is often used to check whether all entries for a specific customer are accounted for, or for other internal checks on customer ledgers. 104
Customer - Payment Receipt Creates a payment receipt for each customer ledger entry of type Payment. If the payment was applied to invoices, the invoices are specified; otherwise, it just states the payment amount as unapplied. You can send this report to customers who want documentation for receipt of payment. 211
Reconcile Customer and Vendor Accounts Shows the G/L entries resulting from posting customer and vendor entries split per G/L account and posting groups. Use this report to reconcile the balances on customer and vendor ledgers to general ledger balances. 33
Customer - Summary Aging Simp. This is a legacy version of an accounts receivables aging report. We recommend you use the Aged Accounts Receivables report instead. 109
Sales Statistics Shows amounts for sales, profit, invoice discount, and payment discount in LCY, and the profit percentage for each customer. The costs and profits are given as both the original and adjusted amounts. The original costs and profits are those values that were calculated at the time of posting, and the adjusted costs and profits reflect changes to the original costs of the items in the sales. The cost adjustment amount shown in the report is the difference between the original cost and the adjusted cost.
The figures are divided into three periods. You can select the length of the period, starting on a selected date. There are also columns for amounts before and after the three periods. Use the report to analyze earnings from an individual customer and earnings trends, for example.
In the US, Canada, and Mexico, this report is not available. Instead, use the Customer Sales Statistics (10047) report.
This report can also be used in accounts receivable as it's easier to do a quick look-up of posted payments, discounts, and sales for a given customer.
112
Customer List Shows various kinds of basic information for customers. For example, the customer posting group, discount group, finance charge and payment information, and so on. Use this report, for example, to maintain information in the Customer table. 101

For more information, see Accounts Receivable Reports and Analytics in Business Central.

Accounts payable reports

The following table describes some of the key reports for accounts payable.

Report Description ID
Aged Accounts Payable Shows overdue balances for vendors in time intervals. The overdue amounts can show by due date, posting date, or by document date. You can choose to show the amounts in local currency (LCY) and print details of the overdue documents. The time intervals can have headings with dates or with number of dates overdue, relative to the specified aging by type.
This report is the main report for reconciling vendor ledger to G/L. Assuming that you don't post directly to the payables account for the vendor posting group, this report is a specification of the amounts in the general ledger.
322
Vendor - Balance to Date Shows the vendor balance by the ending date of the specified date range. You can choose to display the vendor balance in your local currency (LCY). Select the Include Unapplied Entries field to show entries that were closed by the ending date but were unapplied (opened) at a later date. Select the Show Entries with Zero Balance to show vendors with a balance of zero by the ending date of the date filter. The date filter applies to the detailed vendor ledger entries for the entries in the report. If a payment was made after the ending date, and the payment was applied to invoices within the date range, the report includes the invoice. The report includes the invoice because it wasn't closed before the ending date. 321
Vendor - Trial Balance Shows the net changes for vendors for the period specified in the date filter, and the net change year-to-date for the corresponding fiscal year. The report is grouped by vendor posting groups and gives a different view of the vendor ledger than the Aged Accounts Payable report. Note: If you don't set up accounting periods, Business Central doesn't know which fiscal year to use. It shows the year-to-date from the most recent fiscal year, or just the selected period. The date might not be from the beginning of a year. 329
Vendor - Detail Trial Balance Shows all the vendor ledger entries within the specified date filter. The report shows the vendor's beginning balances relative to the date filter. 304
Purchase Statistics Shows purchase statistics for each vendor. The statistics include information for five periods, starting on the date that you specify.The report includes the total purchases, payments, finance charges, and discount information that includes the payment discounts taken and lost.Statistics are calculated for:* Purchases before the date entered, at three intervals of one month from the date entered. * A period that includes all purchases made after the third one-month interval.
This report can also be used in accounts payable as it's easier to do a quick look-up of posted payments, discounts, and other transactions for a given vendor.
312
Vendor - Summary Aging Legacy report for aged accounts payable. We recommend that you use Aged Accounts Payables report instead. You can choose a period length and a date to use for an overdue per date. 305
Payments on Hold Shows vendor ledger entries where the On Hold field isn't blank. 319
Vendor Pre-Payment Journal Shows the payment journal with payment discount and tolerance information. The report can be used to check payments before creating payment files and posting the journal. Note: The report shows payment discounts incorrectly when multiple credit memos were used in an application. In this case, the payment discounts for the extra credit memos are shown as unapplied amounts. 317
Vendor - List Shows basic information for vendors, such as the vendor posting group, discount and payment information, and priority level. The report also shows the vendor's default currency, and the vendor's current balance (in LCY). Use the report, for example, to maintain information about the vendor. 301
Payment Practice Shows how quickly you pay your vendors. You can base the report on a specific period, or by the size of the vendor company in terms of its number of employees. Some countries require this report. To learn more, go to Payment practices report. page 687

For more information, see Accounts Payable Reports and Analytics in Business Central.

Sustainability reports

The following table describes some of the key reports in sustainability.

Report Description ID
Total Emissions Shows the sum of greenhouse gas emissions per different scopes and their participation it total emission. There are also analyses about total emissions per account through a period, or only total emission for each through a period. 6212
Emission Per Facility Shows the sum of greenhouse gas emissions per facility - responsibility center. There are also analyses about emissions by scope and responsibility center or country/region code, and by account and responsibility center or country/region code. 6211
Emission By Category Shows the sum and average amounts of greenhouse gas emissions by category with or without details. There are also analyses that show detailed emissions per posted document. 6210

For more information, see Sustainability reports.

Sales reports

The following table describes some of the key reports for sales. The reports help different roles in sales departments make informed decisions that optimize their operations.

To... Open in Business Central (CTRL+select) Learn more ID
Analyze nonshipped orders to understand your expected sales volume. Forecast your expected monthly sales revenue. Customer - Order Summary About Customer - Order Summary 107
Analyze outstanding sales orders and understand expected sales volumes for customers. Compare your overall outstanding shipments with the planned shipment date and highlight overdue back orders. Customer - Order Detail About Customer - Order Detail 108
Review customers with the most transactions within a selected period to identify sales trends and manage collectable debts. Customer - Top 10 list About Customer - Top 10 list 111
Analyze earnings from an individual customer or earnings trends. Sales Statistics

Note! This report isn't available in the US, Canada, and Mexico. Instead, use the Customer Sales Statistics (10047) report.
About Sales Statistics 112
Analyze item sales per customer to understand sales trends, optimize inventory management, and improve marketing efforts. Assess the relationship between discounts, sales amounts, and volume of item sales. Customer/Item Sales About Customer/Item Sales 113
Get an overview of customer sales for a period. Use the overview to report to the customs and tax authorities. Customer - Sales list About Customer - Sales list 119
Generate customer statements to get a clear summary of amounts due. You can share the amounts with customers to follow up on payments. For example, if you need to close an accounting period or fiscal year. Customer - Balance to date About Customer - Balance to date 121
Analyze and reconcile customer balances at the end of the period. Explore opening balances, transactions within the period, and closing balances for customers. Customer - Trial Balance About Customer - Trial Balance 129
Get an overview of the items that are available to fulfill sales orders and ensure that inventory reservations are accurate. Sales Reservation Avail. About Sales Reservation Avail. 209
Analyze outstanding sales orders to understand expected sales volumes for items. To highlight overdue back orders, compare overall outstanding shipments with the planned shipment dates. Inventory Order Details About Inventory Order Details 708
Get an overview of sales orders that you can't fulfill because items are out-of-stock. Inventory Sales Back Orders About Inventory Sales Back Orders 718
Explore sales orders that are covered when you pick items from inventory. Inventory Picking List About Inventory Picking List 813

For more information, see Sales Reports and Analytics in Business Central.

Purchase reports

The following table describes some of the key reports related to purchasing. The reports help different roles in purchasing departments make informed decisions to optimize their operations.

To... Open in Business Central (CTRL+select) Learn more ID
Analyze and reconcile vendor balances at the end of a period. Vendor - Detail Trial Balance About Vendor - Detail Trial Balance 304
Analyze outstanding purchase orders to understand expected purchase volume. Forecast your monthly expected costs & expenses. Vendor - Order Summary About Vendor - Order Summary 307
Analyze outstanding purchase orders to understand expected purchase volume from vendors. Compare overall outstanding receipts with the expected receipt date to highlight overdue back orders. Vendor - Order Detail About Vendor - Order Detail 308
Analyze vendors' effect on cash flow and prioritize vendor payments. Vendor - Top 10 List About Vendor - Top 10 List 311
Keep track of vendor performance and ensure that your company gets the best value for its money. Purchase statistics About Purchase statistics 312
Analyze item purchases per vendor to manage inventory procurement and improve supply chain processes. Assess the relationship between discounts, cost amounts, and volume of item purchases. Vendor/Item Purchases About Vendor/Item Purchases 313
Get a checklist of all vendor ledger entries where the invoice is in dispute and the On Hold field isn't blank. Payments on Hold About Payments on Hold 319
Get a list of vendors by item or items per vendor. Vendor Item catalog

Note: This report isn't available in the US, Canada, and Mexico. Instead, use the Item/Vendor Catalog (10164) report.
About Vendor Item catalog 320
Analyze vendor balances at the end of each period. Monitor unpaid invoices, and prioritize payments for overdue accounts. Easily reconcile vendor subledgers against payable accounts in the general ledger, assuming that direct posting is disabled. Aged Accounts Payable About Aged Accounts Payable 322
Analyze the closing balance of vendors at the end of the period and reconcile the vendor subledger against the payables accounts in the general ledger. Vendor - Trial Balance About Vendor - Trial Balance 329
Explore the availability of items for shipment on purchase documents, such as return orders. Purchase Reservation Availability About Purchase Reservation Availability 409
Analyze outstanding purchase orders to understand expected purchase volume for items. Compare overall outstanding receipts with the expected receipt date to highlight overdue back orders. Inventory Purchase Orders About Inventory Purchase Orders 709
Analyze your vendor purchases per item to manage inventory procurement and improve supply chain processes. Assess the relationship between discounts, cost amount, and volume of item purchases. Inventory Vendor Purchases About Inventory Vendor Purchases 714

For more information, see Purchasing Reports and Analytics in Business Central.

Inventory and warehouse reports

The following table describes some of the key reports in inventory and warehouse management.

Report Description ID
Inventory Availability Plan Get an overview of specific items and stock-keeping units, and their availability. This report shows accumulated values such as gross requirements, scheduled and planned receipts, inventory, and so on. 707
Inventory Valuation Displays inventory valuation for selected items in your inventory. The report also shows information about the value of increases and decreases in inventory over time.

The report will also print the expected cost of entries that have been posted as received or shipped, depending on whether you enable the Include Expected Cost toggle.

If you enable Include Expected Cost, the report groups entries and shows a group total of invoiced and expected costs for each Inventory Posting Group.

You can also narrow your report output with the Location and Variant Filters. However, as the report is built on top of a value entry, you can't use Bin Filter.

To ensure that the Inventory Valuation report is up-to-date, it's recommended to run the Adjust Cost - Item Entries batch job prior to running this report.

In the US, Canada, and Mexico, this report isn't available. Instead, use the localized version of Inventory Valuation (10139) report.
1001
Item Expiration - Quantity Get an overview of the quantities of selected items in inventory with expiration dates in a certain period. The list shows the number of units of the selected item that will expire in a given time period. For each of the items you specify, the report shows the number of units that will expire during each of three periods of equal length and the total inventory quantity.

Use filters to specify what the report includes. If you don't set filters, the report will include all your records. The quantities in the report reflect only the quantities of the item for which expiration dates are defined.
5809
Item Age Composition - Quantity Get an overview of the current age composition of selected items in your inventory. This report categorizes the on-hand quantity for selected items into three period buckets. You can specify the end date of the last bucket and duration of time buckets (period). The report analyzes the remaining quantity of open item ledger entries that are usually a result of purchases, output, or positive adjustments. 5807
Item Age Composition - Value Get an overview of the current age composition of selected items in your inventory. This report categorizes of on-hand value for selected items into three period buckets. You can specify the end date of the last bucket and duration of time buckets (period). The report analyzes the remaining quantity of open item ledger entries that are usually a result of purchases, output, or positive adjustments. 5808
Inventory Cost and price list Displays a list of price information for the selected items or stock-keeping units: direct unit cost, last direct cost, unit price, profit percentage, and profit. 716
Warehouse Bin List Get an overview of warehouse bins, their setup, and the quantity of items within the bins. This report can cover all locations at which bins are mandatory. 7319
Warehouse Shipment Status Get an overview of source documents that are open and have items shipped or due for shipping per location. This report can be used for all locations that require shipments, and it shows locations, bin codes, document status, quantities. 7313
Inventory Picking List Displays a list of the sales orders that include a selected item. It shows the following information for each item: sales order line with the customer's name, variant code, location code, bin code, shipment date, quantity to ship, and unit of measure. The quantity to be shipped is totaled for each item. Use the report when you need to pick items from inventory.

NOTE: This report isn't available for advanced warehouse functionality.
813
Warehouse Adjustment Bin This report is meant only for an advanced warehouse. It shows the remaining quantities that are stored in the adjustment bin itself. Typically, the adjustment bin should be empty. There are two reasons for it to contain quantities. When it's the result of physical counting process, or if quantities are removed or added to the warehouse. 7320

For more information, see Inventory and Warehouse Reports and Analytics in Business Central.

Project reports

The following table describes some of the key reports in jobs reporting.

Report Description Id
Project Analysis Analyzes your project by using settings that you specify. For example, you can create a report that shows you the budgeted prices, usage prices, and billable prices, and then compares the three sets of prices.
Use a combination of the available Amount fields to create your own analysis. For each field, select one of the following prices, costs, or profit values: Schedule, Usage, Contract, and Invoiced.
Select whether the currency is specified in Local Currency or Foreign Currency.
1008
Project Planning Lines This report shows the different planning and project task lines – including the line type, quantities, unit of measure, total costs, etc. 1006
Project Actual to Budget Compares scheduled and usage amounts for selected projects. All lines of the selected job show quantity, total cost, and line amount.
This report is intended for completed jobs, although you can use it at any time during a job.
In the US, Canada, and Mexico, this report is not available. Instead, use the Project Actual to Budget (Cost) (10210) or Project Actual to Budget (Price) (10211) reports.
1009
Project Suggested Billing Shows a list of all projects, grouped by customer, how much the customer has already been invoiced, and how much remains to be invoiced, that is, the suggested billing.
In the US, Canada, and Mexico, this report is not available. Instead, use the Project Cost Suggested Billing (10219) report.
1011
Projects per Customer Shows a list of all projects, grouped by customer. It allows you to compare the scheduled price, the percentage of completion, the invoiced price, and the percentage of invoiced amounts for each Bill-to Customer. 1012
Items per Project An overview about the used items in a project. Depending on the report that you want to use to get an overview about the planned items for a project, you can set an additional filter. The report shows the relevant items and an accumulated value about the costs. 1013
Project per Item An overview about the used items in a project. Depending on the report that you want to use to get an overview about the planned items for a project, you can set an additional filter. The report shows the relevant items and an accumulated value about the costs. 1014
Project Transaction Detail This report will give you an overview over the posted project tasks like resources and items. Includes a detailed information about the total costs and total prices plus an information concerning line discounts,and so on. The report shows data from the project ledger entries. 1007
Project WIP to G/L Shows the value of work in process on the projects that you select compared to the amount that has been posted in the general ledger. 1010

For more information, see Project Reports and Analytics in Business Central.

Fixed assets reports

The following table describes some of the key reports in fixed assets reporting.

Report Description Id
Fixed Asset List Shows the list of fixed asset and their setup info for a given depreciation book. 5601
Fixed Asset - Acquisition List List all assets acquired within a given date range. You can also include fixed assets that are created but not yet acquired. 5608
Fixed Asset Details Shows the fixed asset ledger entries for fixed assets. 5604
Fixed Asset Analysis An analysis report where you can specify two date columns and three data columns to see in the report. For example, to generate a report to use for reconciling with the general ledger, add columns for acquisition cost at ending date, depreciation at ending date, and book value at ending date. A check report could have acquisitions/net change, write-down/net change, and Appreciation/net change, so every change to fixed asset can be checked if necessary. If you select the Budget Report field and specify an ending date in the future, the report will calculate the future depreciation and can give estimates for future depreciation and book values, if you selected those fields as report columns. 5600
Fixed Asset Projected Value Shows the projected depreciation amounts and book value for a future period for assets. The report is useful when you are using different depreciation methods for your assets and want to estimate next year's depreciation, for example. Use the report to create the budget amounts for depreciation by selecting a budget and the Copy to G/L Budget field. 5607
Fixed Asset Book Value 01 Shows detailed information about acquisition cost, depreciation value, and book value for both individual assets and groups of assets. For each of these three amount types, amounts are calculated at the beginning and at the end of a specified period and for the period itself. If you select the Budget Report field, the report will calculate the expected depreciation for the period. Enter a group type if you want the report to group the fixed assets and print group totals. For example, if you have set up six FA classes, select the FA Class option to have group totals printed for each of the six class codes. 5605
Fixed Asset Book Value 02 Shows the breakdown of fixed asset book value by changes in acquisition, depreciation, and appreciation within the period with a further breakdown by additions and disposals within the period. Use this report to describe the changes in fixed assets for a given period when many different changes occur across the grouping of fixed assets. If you select the Budget Report field, the report will calculate the expected depreciation for the period. Enter a group type if you want the report to group the fixed assets and print group totals. For example, if you have set up six FA classes, select the FA Class option to have group totals printed for each of the six class codes. 5606
Fixed Asset G/L Analysis Shows an analysis of your fixed assets (FA) with various types of data for individual assets and/or groups of assets. On the Fixed Assets FastTab, you can set filters if you want the report to include only certain fixed assets. On the Options FastTab, tailor the report to meet your specific needs. The report is similar to the Fixed Asset Analysis report, but specifically for reconciling to the general ledger and specifically for validating the disposal entries. The report assumes that you know the G/L accounts that are specified in the posting setup. 5610
Fixed Asset Register Shows posted fixed asset ledger entries that are sorted and divided by register number. You can determine which registers' entries are shown by setting a filter. It is important to set a filter; otherwise, the report may show a very large amount of information. 5603

For more information, see Fixed Assets Reports and Analytics in Business Central.

Assembly reports

The following table describes some of the key reports in assembly reporting.

Report Description Id
Assembly BOMs Displays a list of BOMs: name, BOM number, BOM components, and any other BOMs that are part of the BOM. The BOM components are defined in the BOM Component table. You will see here also the unit of measure and the needed quantity of each component per base unit of measure. 801
Item - Able to Make (Time) Shows how five different key availability figures change over time for a BOM item. These figures change according to expected supply and demand events and to supply that is based on available components that can be assembled or produced.
You can use the report to see whether you can fulfill a sales order for an item on a specified date by looking at its current availability in combination with the potential quantities that its components can supply if an assembly order were started. The report shows you when and how many units of an assembly and production item you can make based on component availability and the item’s current availability. This is shown as the total quantity.
The information is shown in a graph where each availability figure is a line that progresses along the timeline and moves up and down as quantities change. The quantity figures come from the same engine that provides information to the Item Availability by BOM Level window.
5871
BOM Cost Share Distribution Shows graphically how an assembled or produced item’s cost is distributed through its BOM.
Such information can be useful in deciding whether to change component suppliers, replace internal capacity usage with outsourced labor, or vice versa, or when reviewing and modifying an item’s bill of material, for example.
The first chart in the report shows the total unit cost of the parent item’s components and labor resources broken down in up to five different cost shares, and represented graphically with different colors.
The pie chart with the caption By Material/Labor shows the proportional distribution between the parent item’s material and labor costs, as well as its own manufacturing overhead. The material cost share includes the item’s material costs. The labor cost share includes capacity, capacity overhead and subcontracted costs. The cost shares are displayed differently depending on your choices in the Show only field.
The pie chart with the caption By Direct/Indirect shows the proportional distribution between the parent item’s direct and indirect costs. The direct cost share includes the item’s material, capacity, and subcontracted costs. The indirect cost share includes capacity overhead and manufacturing overhead.
The table at the bottom of the report is included when you select the Include Details check box. It shows selected values from the BOM Cost Shares window by single level or rolled up, depending on the option that you choose in the Show Cost Shares as field.
5872
Where-used list Displays a list of the BOMs that the selected items are components of. A helpful overview in case you must change a component in a BOM that is inserted in an assembly item. For example, if your vendor can no longer deliver a specific item that you used for your assembly/production. In such scenarios, this report provides you with an easy overview of which BOMs the component is included in. You can set a filter for the number of the component. 809
BOM - Raw Materials This report can give you an overview about the needed components, both for assembly and for production. You will see the inventory, base unit of measure, the main vendor if the vendor no. is written in the item card itself, and the lead time calculation. 810
BOM - Sub-Assemblies If you produce and/or assemble sub-assemblies, use this report to get an overview about this type of component. This report shows you the base unit of measure, the inventory, unit costs, and an alternative item number. 811
Assembly BOM - End Items Shows a list of items or BOMs that are not components of BOMs. Note: This report is not restricted to BOM only, so remember to set filter in the Assembly BOM field or the Replenishment System fields 812
Assemble to order - Sales Shows key sales figures for assembly component items that can be sold both as part of an assembly in assemble-to-order sales and as a separate item directly from inventory.
Use this report to analyze the quantity, cost, sales, and profit figures of assembly components to support your decisions, such as whether to price a kit differently or to stop or start using a particular item in assemblies.
The In Assembly row shows sales figures for the total quantity that is sold as part of an assembly item. The specific assembly item sales that sum up to this total are shown if you select the Show Assembly Details field.
The focus is on the assembly components, but the figures are calculated from the profit margin of their parent, the assembly item. Accordingly, the sales amount of each component is calculated from its own cost and the profit margin of its parent in the following formula.
The report shows information for items that meet one or both of the following criteria:
- Exist in the assembly BOM of an item that uses the Assemble-to-Order assembly policy.
- Has been sold as part of assemble-to-order sale.
915

For more information, see Assembly Management Reports and Analytics in Business Central.

Production reports

The following table describes some of the key reports in production reporting.

Report Description Id
Quantity Explosion of BOM Shows an indented BOM listing for the item or items that you specify in the filters. The production BOM is completely exploded for all levels. 99000753
Item - Able to Make (Time) Shows how five different key availability figures change over time for a BOM item. These figures change according to expected supply and demand events and to supply that is based on available components that can be assembled or produced.
You can use the report to see whether you can fulfill a sales order for an item on a specified date by looking at its current availability in combination with the potential quantities that its components can supply if an assembly order has been started. The report shows you when and how many units of an assembly and production item you can make based on component availability and the item's current availability. This is shown as the total quantity.
The information is shown in a graph where each availability figure is a line that progresses along the timeline and moves up and down as quantities change. The quantity figures come from the same engine that provides information to the Item Availability by BOM Level window.
5871
BOM Cost Share Distribution Shows graphically how an assembled or produced item’s cost is distributed through its BOM.
Such information can be useful in deciding, for example, whether to change component suppliers, replace internal capacity usage with outsourced labor or vice versa or when reviewing and modifying an item’s bill of material.
The first chart in the report shows the total unit cost of the parent item’s components and labor resources broken down in up to five different cost shares, and represented graphically with different colors.
The pie chart with the caption By Material/Labor shows the proportional distribution between the parent item’s material and labor costs, as well as its own manufacturing overhead. The material cost share includes the item's material costs. The labor cost share includes capacity, capacity overhead and subcontracted costs. The cost shares are displayed differently depending on your choices in the Show only field.
The pie chart with the caption By Direct/Indirect shows the proportional distribution between the parent item's direct and indirect costs. The direct cost share includes the item's material, capacity, and subcontracted costs. The indirect cost share includes capacity overhead and manufacturing overhead.
The table at the bottom of the report is included when you select the Include Details check box. It shows selected values from the BOM Cost Shares window by single level or rolled up, depending on your choices in the Show Cost Shares as field.
5872
Detailed Calculation Shows a cost list per item taking into account the scrap. 99000756
Where-Used (Top Level) Shows where and in what quantities the items are used in the product structure.
The report shows only the item as where-used, when the base item is used as the top-level item. For example, if item "A" is used to produce item "B", and item "B" is used to produce item "C", the report will show item B if you run this report for item A. If you run this report for item B, then item C will be shown as where-used.
You can also open the Where-Used Line page directly from the item.
99000757
Item BOM Compare list This report gives you the possibility to compare similar final products concerning the costs. You will see a listing with all components and their costs as well the needed quantities. The calculation date is normally set to the work date. 99000758
Production Order Statistics Specifies the various costs that have accumulated for the selected production order.
The content of the report are very similar to the Production Order Statistics page.
For production orders that use the Make-to-Order manufacturing policy, the window only shows material and capacity cost of items at the highest BOM level.
99000791
Capacity Task list Shows the production orders that are waiting to be processed at the work centers and machine centers. Printouts are made for the capacity of the work center or machine center). The report includes information such as starting and ending time, date per production order and input quantity. 99000780
Work Center Load Shows a list for the load on a work center. The load on a work center is the sum of the required number of times that all the planned and actual orders are run on the work center in a specified period. 99000783
Machine Center Load Shows a list for the load on a machine center. The load on a machine center is the sum of the required number of times that all the planned and actual orders are run on the work center in a specified period. 99000784
Prod. Order Shortage list This report can be used to see all components that are not available because of missing stock. So, this overview can be used to see in time, if the timeline for a planned or released production order if the planned time can be kept. 99000788
Prod. Order - Calculation Shows a list of the production orders and their costs. It includes expected operation costs, expected component costs, and total costs. 99000767

For more information, see Production Reports and Analytics in Business Central.

See also

Report Overview
Analyze list and query data with analysis mode
Analytics overview

Find free e-learning modules for Business Central here