← Exception queue

JOB-0048Ilves Metalli Oy

Customer CUS-008 · Completed · opened 27.07.2025 at 00:06 · completed 02.09.2025 at 00:06

Work centres: CNC-1, WELD-1

—

—

Incomplete

Why no margin is shown

Import is stalestale_import
import run RUN-STALE-TIMECLOCK finished 96,00 h before the clock, over the policy limit of 48 h
Evidence (1 rows · Context reference: 1)
Context referenceContext rows — they show the job exists
These rows show that the job exists and was billed. They did not produce the amount, so they do not explain it.
Table Source Row Version Time (UTC) Mapping Quality Field
timeclock timeclock RUN-STALE-TIMECLOCK 1 14.09.2026 at 00:00 synthetic/v1 In order —
Unattributed subcontract costunattributed_subcontract
1 unattributed subcontract cost row(s) fall in this job's period: the export left them without a job, so this job cannot be certified
Evidence (1 rows · Context reference: 1)
Context referenceContext rows — they show the job exists
These rows show that the job exists and was billed. They did not produce the amount, so they do not explain it.
Table Source Row Version Time (UTC) Mapping Quality Field
erp erp SUB-UNATTRIBUTED-000001 1 17.09.2026 at 11:00 synthetic/v1 In order —

The line-by-line comparison is withheld because the job is blocked: components computed from an incomplete cost basis cannot be compared with the quote basis.

Snapshot computed 21.09.2026 at 14:48 · definition job-margin/2026-09-20.1 · inputs 0bc99dd9812a

The margin bridge

The bridge explains the arithmetic difference: each line says how much of the gap between the estimated and the actual margin that driver accounts for. It does not establish a cause. Why a price or an hours figure moved is a different question, and this view does not answer it.

The job is blocked: its cost basis is incomplete, so the bridge's differences are not reportable either. They are shown so that the missing posting is visible.

1Revenue differencerevenue_varianceCausal−425,86 €

Evidence (5 rows · Causal reference: 5)

Causal referenceThe rows that produced the amount

These rows produced the amount: every figure is computed from these rows.

Table	Source	Row	Version	Time (UTC)	Mapping	Quality	Field
Invoice line invoice_line	invoicing	IL-000292	1	17.09.2026 at 23:42	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000293	1	10.09.2025 at 22:29	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000294	1	09.05.2026 at 12:21	synthetic/v1	In order	—
Invoice line invoice_line	invoicing	IL-000295	1	12.09.2026 at 02:56	synthetic/v1	In order	—
Credit line credit_line	invoicing	CR-00034	1	03.04.2026 at 15:13	synthetic/v1	In order	—

2Material quantity differencematerial_quantity_varianceCausal+697,07 €

Evidence (10 rows · Causal reference: 10)

Causal referenceThe rows that produced the amount

These rows produced the amount: every figure is computed from these rows.

Table	Source	Row	Version	Time (UTC)	Mapping	Quality	Field
Material consumption material_consumption	erp	MC-000395	1	23.08.2025 at 21:10	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000396	1	12.08.2025 at 04:46	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000397	1	05.08.2025 at 04:11	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000398	1	12.08.2025 at 21:22	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000399	1	17.08.2025 at 08:07	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000400	1	15.08.2025 at 10:49	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000401	1	29.07.2025 at 15:47	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000402	1	31.08.2025 at 12:35	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000403	1	15.08.2025 at 14:45	synthetic/v1	In order	qty
Material consumption material_consumption	erp	MC-000404	1	27.08.2025 at 10:56	synthetic/v1	In order	qty

3Material price differencematerial_price_varianceCausal+120,74 €

Evidence (10 rows · Causal reference: 10)

Causal referenceThe rows that produced the amount

These rows produced the amount: every figure is computed from these rows.

Table	Source	Row	Version	Time (UTC)	Mapping	Quality	Field
Material consumption material_consumption	erp	MC-000395	1	23.08.2025 at 21:10	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000396	1	12.08.2025 at 04:46	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000397	1	05.08.2025 at 04:11	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000398	1	12.08.2025 at 21:22	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000399	1	17.08.2025 at 08:07	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000400	1	15.08.2025 at 10:49	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000401	1	29.07.2025 at 15:47	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000402	1	31.08.2025 at 12:35	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000403	1	15.08.2025 at 14:45	synthetic/v1	In order	unitCost
Material consumption material_consumption	erp	MC-000404	1	27.08.2025 at 10:56	synthetic/v1	In order	unitCost

4Labour hours differencelabour_hours_varianceCausal+1 037,26 €

Evidence (13 rows · Causal reference: 13)

Causal referenceThe rows that produced the amount

These rows produced the amount: every figure is computed from these rows.

Table	Source	Row	Version	Time (UTC)	Mapping	Quality	Field
Time entry time_entry	timeclock	TE-000704	1	16.08.2025 at 01:02	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000705	1	21.08.2025 at 10:28	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000706	1	23.08.2025 at 16:53	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000707	1	29.08.2025 at 20:13	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000708	1	21.08.2025 at 21:51	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000709	1	29.07.2025 at 14:50	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000710	1	30.07.2025 at 21:20	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000711	1	01.09.2025 at 04:37	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000712	1	13.08.2025 at 20:16	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000713	1	21.08.2025 at 08:15	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000714	1	12.08.2025 at 15:48	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000715	1	06.08.2025 at 04:03	synthetic/v1	In order	hours
Time entry time_entry	timeclock	TE-000716	1	26.08.2025 at 10:43	synthetic/v1	In order	hours

5Labour rate differencelabour_rate_varianceCausal−0,01 €

Evidence (13 rows · Causal reference: 13)

Causal referenceThe rows that produced the amount

These rows produced the amount: every figure is computed from these rows.

Table	Source	Row	Version	Time (UTC)	Mapping	Quality	Field
Time entry time_entry	timeclock	TE-000704	1	16.08.2025 at 01:02	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000705	1	21.08.2025 at 10:28	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000706	1	23.08.2025 at 16:53	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000707	1	29.08.2025 at 20:13	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000708	1	21.08.2025 at 21:51	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000709	1	29.07.2025 at 14:50	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000710	1	30.07.2025 at 21:20	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000711	1	01.09.2025 at 04:37	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000712	1	13.08.2025 at 20:16	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000713	1	21.08.2025 at 08:15	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000714	1	12.08.2025 at 15:48	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000715	1	06.08.2025 at 04:03	synthetic/v1	In order	rate
Time entry time_entry	timeclock	TE-000716	1	26.08.2025 at 10:43	synthetic/v1	In order	rate

6Subcontract differencesubcontract_varianceNo claim0,00 €
No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.
7Rework differencerework_varianceNo claim0,00 €
No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.
8Other variable cost differenceother_variable_varianceNo claim0,00 €
No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.
9Unexplained differenceresidual_unexplainedNo claim0,00 €
No claim A zero line points at no source rows: it claims nothing, so no evidence is to be expected.

Reconciliation0,00 €tolerance 172,40 €

Import is stalethe margin of JOB-0048 is not reportable: import run RUN-STALE-TIMECLOCK finished 96,00 h before the clock, over the policy limit of 48 h (rows RUN-STALE-TIMECLOCK)
Unattributed subcontract costthe margin of JOB-0048 is not reportable: 1 unattributed subcontract cost row(s) fall in this job's period: the export left them without a job, so this job cannot be certified (rows SUB-UNATTRIBUTED-000001)

The stored note

tolerance 17240 minor units; stale_import: the margin of JOB-0048 is not reportable: import run RUN-STALE-TIMECLOCK finished 96,00 h before the clock, over the policy limit of 48 h (rows RUN-STALE-TIMECLOCK) | unattributed_subcontract: the margin of JOB-0048 is not reportable: 1 unattributed subcontract cost row(s) fall in this job's period: the export left them without a job, so this job cannot be certified (rows SUB-UNATTRIBUTED-000001)

The bridge is computed from the stored snapshot. The next step is always the same: open the line's evidence and check the source rows.

Findings (1)Blocked: margin —

High highStale or incomplete importR9—No amount: the finding blocks reporting.

Postings on JOB-0048 cannot be certified as current (Import is stale, Unattributed subcontract cost).

The job is blocked (Incomplete) · work centres CNC-1, WELD-1 · version job-margin-rules/2026-09-20.1 · computed 21.09.2026 at 14:48

Evidence (2 rows · Context reference: 2)

Context referenceContext rows — they show the job exists

These rows show that the job exists and was billed. They did not produce the amount, so they do not explain it.

Table	Source	Row	Version	Time (UTC)	Mapping	Quality	Field
Import run import_run	timeclock	RUN-STALE-TIMECLOCK	1	14.09.2026 at 00:00	synthetic/v1	In order	—
Subcontract cost subcontract_cost	erp	SUB-UNATTRIBUTED-000001	1	17.09.2026 at 11:00	synthetic/v1	In order	—