Assemblies: Tracking

What you’ll learn

Follow your assemblies in the Admin Portal once they are built and in use: how many you have and what they are worth, who has one out right now, which condition each serial number is in, which parts are built into them, and what has happened to them. It also covers the history in reports and in the BI feed, and what happens when an assembly is scrapped.

The example is the serialized assembly ASM-DRILL-20, Drilling assembly Ø20. It is built from the drill body DRL-BODY-20 (durable, serialized) and a solid carbide drill (consumable). Two have been built: DA-26-001 is out with an operator, and DA-26-002 was scrapped.


Where to find what

Question Where to look in the Admin Portal
How many assemblies do we have, and what are they worth? Reports > Report viewer > Inventory
Who has an assembly out right now? Overviews > Picked items locations
What does one assembly cost, and when did that change? The assembly item, Supplier tab and Change history tab
Where is each serial number, and in which condition? Overviews > Serialized items
Which parts are built into assemblies? Overviews > Serialized items, searched for the part
What has happened to one assembly? The serial number’s Transaction history, the Raw transaction report and the BI feed RawTransactions

Stock and value of your assemblies

The Inventory report lists every item in each device with its standard cost, its value and the quantity in stock. Assemblies are listed like any other durable item.

  1. Select Reports, then Report viewer.
  2. Double-click Inventory.
  3. Type part of your assembly item IDs into the Item ID filter above the column. If the filters are hidden, select Show inline filters.

Inventory report with the Item ID filter set to ASM (1) and the ASM-DRILL-20 row showing standard cost 240 EUR, value 240 EUR and quantity in stock 0 (2) highlighted

The Item ID filter set to ASM (1). ASM-DRILL-20 has nothing in stock but is worth 240 EUR (2), because one assembly is out in production.

How the value is worked out:

  • Value = (quantity in stock + assemblies picked and not yet returned) × standard cost. An assembly that someone has picked still belongs to you, so it still counts. ASM-DRILL-20 shows 0 in stock and 240 EUR: DA-26-001 is out, and the standard cost is 240 EUR.
  • Scrapped assemblies do not count. DA-26-002 adds nothing.
  • Assemblies away at service do not count either. The face mill assembly ASM-FACE-MILL-63 has two serial numbers, one in stock and one In service. The report shows 1 in stock and 280 EUR, the value of one.
  • Parts are not counted twice. A durable part inside an assembly is no longer in stock, so its value is carried by the assembly only. The drill body DRL-BODY-20 has three serial numbers, but two are built into assemblies. The report shows 1 in stock and 240 EUR for it.

To see who has the assemblies that are out, open Overviews > Picked items locations and select Expand all. Every durable item that is picked and not returned is listed with the person who picked it and when.

Locations of picked durable items overview with ASM-DRILL-20 picked by Axel Wise on 09.11.2026 highlighted (1)

ASM-DRILL-20 has been out with Axel Wise since 09.11.2026 (1). This is the assembly that the Inventory report still counts.

Note: A newly built assembly starts out checked out to the person who built it, so it shows here until it is returned. See Assemblies: Building and stocking.


Standard cost and when it is recalculated

You never type in a standard cost for an assembly. CRIBWISE works it out from the bill of materials: the standard cost of each durable part multiplied by its requested quantity. Consumable parts add nothing. ASM-DRILL-20 is 240 EUR, the cost of its drill body, and the drill does not count. Assemblies: Understanding the concept explains the formula with more examples.

When the figure changes:

  • When the bill of materials is saved. Adding or removing a part, or changing its requested quantity, recalculates the assembly’s standard cost straight away. There is nothing to run.
  • When a part’s own standard cost changes. The assembly follows at the next standard cost recalculation, not before. On our test system, with Set standard cost as Average acquisition cost, we raised the purchase price of the tool holder DEMO-TH-01 from 100 to 110 EUR. Its standard cost and that of its assemblies DEMO-ASM-02 and DEMO-ASM-20 stayed at 100 EUR until the recalculation ran, and then all three read 110 EUR. The schedule is set under Administration > System settings > Purchase > Standard cost of item, in Schedule calculation. Update now runs it immediately. The message says the recalculation was scheduled, but it starts straight away and the new figures appear within seconds. See Understanding item costs: standard cost and usage cost.

The current figure is shown, read-only, as Standard cost on the assembly’s Supplier tab. To see when it changed, open the assembly item and select the Change history tab.

Change history tab of ASM-DRILL-20 (1) with Assembly item added and Standard cost changed in the same minute highlighted (2)

The Change history tab (1). Adding the assembly items and the Standard cost changed entry happened in the same minute (2).

Note: Standard cost is what an assembly is worth in stock. What a pick of the assembly costs comes from its own Usage cost structure and Cost on the General information tab.


Assembly serial numbers in the serialized overview

A serialized assembly is tracked like any other serialized item. Every assembly you build has its own serial number, condition and location, and the Serialized items overview lists them all, scrapped ones included.

  1. Select Overviews, then Serialized items.
  2. Type the assembly item ID into the search box and select Search.
  3. Expand the item with the arrow, or select Expand all.

Serialized item overview searched for ASM-DRILL-20 (1), with serial DA-26-001 New and In production (2) and DA-26-002 Scrapped (3) highlighted

Search for the assembly (1). DA-26-001 is out in production (2). DA-26-002 was scrapped and stays in the list (3).

What the Location column shows for an assembly serial number:

The assembly is… Condition Location
In stock New, Used or Refurbished Its stock, device and location address
Picked, including right after it was built The condition it was picked in In production
Waiting for service For service Its stock location
Away at service In service Service list, or the service order
Scrapped Scrapped Empty

An assembly keeps its condition while it is out. DA-26-001 was returned new once and picked again, so it still reads New. The condition only changes when the assembly is returned, serviced or scrapped.

To list only assemblies, open the Advanced filter and set Assembly to show only assemblies. The filters, columns and saved views work as for any serialized item; see Serialized items: Tracking.


Component parts: In assembly

When an assembly is built, each serialized durable part used in it gets the status In assembly. It leaves its stock location, and its location shows In production. It keeps both for as long as it is part of the assembly: while the assembly is in stock, out with an operator, or away at service.

Search the overview for the part’s item ID to see which of its serial numbers are built in and which are free:

Serialized item overview searched for DRL-BODY-20 with DB-26-001 and DB-26-002 In assembly, location In production (1) and DB-26-003 New in stock (2) highlighted

Two drill bodies are built into assemblies (1). The third is free and in stock (2).

The same list is on the part’s own item, on its Serialized item tab. A part that is In assembly:

  • cannot be picked, returned or serviced on its own
  • gets no transactions while its assembly is used, serviced or restocked
  • does not count towards its own service rule
  • is not counted in the part’s stock or value

Note: The Admin Portal does not show which assembly serial number a part is built into. If you need that link, write it in a comment on the part’s or the assembly’s instance, see Comments in Serialized items: Tracking.

Non-serialized durable parts, such as a holder without serial numbers, simply leave stock when the assembly is built. You see this in the history, as described next.


History of an assembly

On the serial number

Open the assembly item, go to its Serialized item tab and double-click a serial number. The Transaction history tab lists everything that happened to that assembly. Here is the fine boring assembly FB-26-001 after two uses and one service:

Instance detail of assembly serial FB-26-001 with the Transaction history tab (1), its transactions (2) and the button that opens the full report (3) highlighted

The Transaction history tab (1) with the picks, returns, pick for service and restock of this one assembly (2). The button (3) opens the full transaction report.

In the Raw transaction report

Every transaction is also in Reports > Report viewer > Raw transaction report, with the item ID, the serial number and the user. Filter the Item ID column to narrow it down.

Building an assembly writes one row for the assembly and one for each part, all at the same moment:

Row Transaction type What it means
The assembly Pick The new assembly is checked out to the builder. It has no stock location, because it did not come out of a location. A pick of an assembly carries its usage cost.
Each durable part Withdraw The part leaves its stock location and goes into the assembly. A serialized part shows its serial number.
Each consumable part Pick An ordinary pick of the consumable, with its own cost.

Raw transaction report with the Item ID filter (1) and the three rows of one assembly build at 08:22 highlighted (2): Pick of DEMO-ASM-03, Withdraw of DEMO-HLD-02 and Pick of DEMO-DRL-01

Filtered on the item IDs (1). One build of the drilling tool assembly DEMO-ASM-03 (2): the assembly is picked, its holder is withdrawn and its drill is picked, all at 08:22.

After that, the assembly’s own rows follow its life: Pick, Return, Pick for service, Restock, Goods received and Scrap. The parts get no more rows while they are built in.

In the BI feed

The BI feed RawTransactions holds the same transactions for Power BI, Excel or any other OData client. Two fields are useful for assemblies:

  • IsAssembly is true on every row of an assembly item. Use it to get the history of all assemblies at once.
  • ItemTechnicalId is the item’s internal ID. It never changes, even if the item ID is renamed. Use it to get the full history of one assembly item.

For example, with [AP_base_uri] being the host your Admin Portal runs on:

[AP_base_uri]/Reporting/Integration/RawTransactions?$filter=IsAssembly eq true
[AP_base_uri]/Reporting/Integration/RawTransactions?$filter=ItemTechnicalId eq 'Stock.Item321305'
[AP_base_uri]/Reporting/Integration/RawTransactions?$filter=ItemTechnicalId eq 'Stock.Item321305' and SerialNumber eq 'DA-26-001'

To find an item’s ItemTechnicalId, filter the feed once by its item ID (PartNumber eq 'ASM-DRILL-20') and read the value from any row.

Important: A transaction keeps the item ID it was booked with. ASM-DRILL-20 was renamed from DEMO-ASM-13 after its first assemblies were built, so its earlier transactions still read DEMO-ASM-13. Filtering the Raw transaction report on ASM-DRILL-20 finds none of them, and the Transaction history of a serial number only lists the transactions booked under the current item ID. In the BI feed, ItemTechnicalId returns all of them.

Tip: On the RawTransactions feed, a misspelled field name in $filter does not cause an error. It returns no rows. If a filter returns nothing, check the spelling against the feed’s $metadata first. See BI interface: connect a BI tool to CRIBWISE reporting data.


Scrapping an assembly, and taking one apart

Scrapping works as for any durable item: return the assembly with the condition Scrap, see Assemblies: Picking and returning. A serialized assembly then shows Scrapped, it stays in the serialized overview, and it no longer counts in stock or value. The history gets a Scrap row for the assembly.

The parts are not touched by the scrap. Their serial numbers keep the status In assembly, and they do not return to stock. DB-26-002, the drill body of the scrapped DA-26-002, still shows In assembly in the screenshot under Component parts: In assembly above.

Taking an assembly apart is not possible in CRIBWISE. Neither the Admin Portal nor the Shop Floor Interface has a function that dismantles an assembly or returns its parts to stock. Once a part is built in, it stays part of that assembly.

Warning: If parts physically come out of an assembly, for example when you salvage a holder from a scrapped tool, the only way to change a part’s record is to change its instance status by hand on its instance detail in the Admin Portal. Use it only for exceptions, as described under Change instance status in Serialized items: Tracking.


Common confusion

People often think… But actually…
An assembly that is out of stock is worth nothing. Assemblies that are picked and not returned still count. ASM-DRILL-20 has 0 in stock and a value of 240 EUR.
Parts inside an assembly are counted twice, once in the part and once in the assembly. A built-in part is no longer in stock, so only the assembly carries its value.
The standard cost of an assembly only changes when the recalculation runs. It changes straight away when the bill of materials is saved. Changes to a part’s own standard cost follow with the recalculation.
Scrapping an assembly scraps or frees its parts. The parts stay In assembly. Nothing returns to stock.
An assembly can be taken apart and its parts restocked. There is no dismantle function. A part’s status can only be changed by hand, for exceptions.
The serial number of a part tells you which assembly it is in. It shows only In assembly and In production. Keep the link in a comment if you need it.
Filtering a report on the item ID shows the whole history. Only the transactions booked under that item ID. After a rename, use ItemTechnicalId in the BI feed.

Take action

New to assemblies? Start with Assemblies: Understanding the concept.

Want this data in Power BI or Excel? Connect to the reporting feeds with BI interface: connect a BI tool to CRIBWISE reporting data.


Was this article helpful?

Related Articles