Item Reports

Each item has several reports, which can be accessed from Stock -> Items, by clicking on the Reports Reports button on an item's line.

Jump to report:

1. Stock history - historical information on stock levels and balance.
2. Bookings - the list of bookings for this item.
3. Expected lots - the list of incoming stock lots.
4. Manufacturing orders - the list of manufacturing orders and cost statistics for this item.
5. Purchases - the list of purchases and cost statistics for this item.
6. Engagement - the list of BOMs this item belongs to.
7. Relations - the list of relations this item belongs to.
8. Serial numbers - the list of serial numbered parts of this item.

Report “Stock history”

The Stock -> Items -> An item's reports -> Stock history report shows the historical stock levels of this item as a graph, and detailed stock movements and balance as a table.

Report “Bookings”

The Stock -> Items -> An item's reports -> Bookings report shows the list of Manufacturing Orders and Customer Orders for which this item has been booked. The bookings can be edited by clicking on the Edit Edit button.

Report “Expected lots”

The Stock -> Items -> An item's reports -> Expected lots report shows the detailed list of future expected stock lots (batches) of this item and their sources – purchase orders for parts, and production orders for products.

Report “Manufacturing orders”

The Stock -> Items -> An item's reports -> Manufacturing Orders report shows the list of manufacturing orders made for this item as a table, and the manufacturing cost per unit as a graph. Manufacturing orders can be edited.

To see this report, the item must be marked as This is a procured item: No.

Report “Purchases”

The Stock -> Items -> An item's reports -> Purchases report shows the list of purchases made for this item as a table and the historical purchase price per unit as a graph.

To see this report, the item must be marked as This is a procured item: Yes.

Report “Engagement”

The Stock -> Items -> An item's reports -> Engagement report shows the list of products that have this item in their Bill of Materials as a part. This is also known as the "Where used" report.

Important notes:

• If an item is referred to on the different BOM levels, the quantities to produce 1 unit of the resulting product are summarized and shown as used on the lowest level.

• If the item is part of a Matrix BOM, the reference to the BOM, the level, and 0 quantity is displayed. Quantity is not calculated (per variation), variations of a product are not listed. 

Report “Relations”

The Stock -> Items -> An item's reports -> Relations report shows the list of relations that contain this item.

Report “Serial numbers”

The Stock -> Items -> An item's reports -> Serial numbers report shows the list of all serial numbers of that stock item.