Inventory and Warehouse Reports and Analytics in Business Central

Inventory and warehouse reporting in Business Central allows inventory and business professionals to get insights and statistics about current and past inventory and warehouse activities.

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 stockkeeping 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. 1001
Item Expiration - Quantity Get an overview of the quantities of selected items in inventory with expiration dates within 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 that 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 of the selected item.

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. The list shows the number of units or value of the selected item that were added to or removed from inventory, and at which point in time. Items can be added to or removed from inventory as a result of purchases, sales, and positive and negative adjustments. 5807
Item Age Composition - Value Get an overview of the current age composition of selected items in your inventory. The list shows the number of units or value of the selected item that were added to or removed from inventory and at which point in time. Items can be added to or removed from inventory as a result of purchases, sales, and positive and negative adjustments. 5808
Inventory Cost and price list Displays a list of price information for the selected items or stockkeeping 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 customer's name, variant code, location code, bin code, shipment date, quantity to be shipped, 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 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. The only reasons for it to contain quantities are when it's the result of physical counting process, or if quantities are removed or added to the warehouse. 7320

Tasks

The following articles describe some of the key tasks for analyzing the state of your business:

See also

Setting Up Inventory
Inventory
Setting Up Warehouse Management
Warehouse Management Overview

Find free e-learning modules for Business Central here