Bills of materials and batch records

Connect the selected recipe components to manufacturing execution. Keep revisions, required quantities and recorded consumption distinct.

Reconcile consumption after the ERP response is lost

Reading a BOM and posting actual consumption are separate operations. If the agreed connection includes outbound consumption, use this case to verify recovery after a commit with a lost acknowledgement. The material definition remains the planning input; the physical-use event is the basis of this movement.

A 2.40 kg consumption posts, but its acknowledgement is lost.

Batch B-610 consumes 2.40 kg from container C-610-04 in step 7. Seal records source event USE-610-007 and prepares transaction TX-610-007. The ERP commits movement M-88421. The connection times out before the acknowledgement is received, leaving the sending system uncertain about the destination outcome.

Scroll across to see every column →

Illustrative connection records
RecordIdentityKnown factWhat remains to establish
Physical useUSE-610-0072.40 kg was consumed in B-610 / step 7The operational event is not undone by a network error
Intended transactionTX-610-007One outbound consumption for USE-610-007Whether the ERP accepted this transaction
Delivery attemptATT-610-01Request sent; response timed outTimeout alone does not prove rejection
ERP movementM-88421Present in the illustrative ERP source evidenceMatch it back to TX-610-007 and verify its quantity and unit

Before creating another movement, query or otherwise reconcile the ERP using its supported transaction identity. If M-88421 is confirmed as the movement for TX-610-007, record that acknowledgement and complete the reconciliation. If the destination outcome cannot be established, keep the exchange unresolved for controlled recovery.

Download the source example
Trace the mapping and recovery decisions

Agree the movement contract before sending production data.

Choose the actual source event that should create a consumption movement. An ingredient reservation, an issue to production and a confirmed physical addition are different events. Agree the destination movement meaning and the source review state required for transmission. If the ERP expects material, plant, storage location and lot identifiers, resolve those mappings explicitly rather than relying on display names.

Define quantities and units at the boundary. If the source records 2.40 kg and the receiving movement is expressed in grams, the agreed quantity is 2,400 g. Preserve the original source quantity and the conversion applied. Check whether the destination expects a positive consumption quantity with a movement type or a signed quantity; do not infer that convention from a field called 'amount'.

Retain the intended transaction through an uncertain delivery.

Create the outbound transaction from the source event and record its immutable identity before the first send. Retain each attempt separately with its time, response classification and relevant evidence. A second attempt is not a second physical consumption event. The batch quantity must continue to reflect the actual execution even when the integration is unavailable.

Confirm whether the ERP supports an idempotency key, an external document reference, a searchable transaction identifier or another supported reconciliation route. Specify what that mechanism guarantees and how long its identity is retained. Sending the same key only prevents duplication if the destination actually honours that contract; a local 'sent' flag cannot guarantee exactly-once processing across two systems.

For the timeout in the example, inspect the destination outcome before authorising a new movement. Match M-88421 using the agreed identity and verify material, location, lot, quantity and unit. If the destination exposes no safe lookup or retry contract, route the uncertain case to the responsible owner. Preserve the unresolved state rather than turning absence of a response into a definite rejection.

Treat a corrected consumption as new controlled work.

Suppose the accepted source quantity later changes from 2.40 kg to 2.10 kg after a documented correction. Do not silently alter the payload recorded for the already posted TX-610-007. Retain the original event and transaction, the correction reason, and the authorised destination adjustment. The receiving ERP may require a reversal and replacement or a separate adjustment; use its supported accounting and inventory workflow.

The reconciliation must explain both systems' final state from their event histories. A net total that happens to agree is insufficient if one destination movement belongs to the wrong lot or location. Group the review by transaction identity and material context, then calculate the net quantities from the matched movements and authorised corrections.

Define what counts as a matching destination movement.

For TX-610-007, capture a reconciliation record containing the source event identity, intended destination operation, external reference, material, lot, plant/location, quantity, unit and any applicable posting date. Compare the supported destination lookup with that entire contract. A movement for 2.40 kg of the same material is a candidate; it is not necessarily this movement when two additions legitimately have equal quantities.

Classify the lookup explicitly. One matching destination identity with matching required fields resolves the delivery. A record with the expected reference but 2.10 kg instead of 2.40 kg is a conflict for the transaction owner. Multiple candidate matches require investigation. No visible match remains uncertain if the query is delayed or incomplete; retry is appropriate only under the operation’s supported recovery rules and the evidence available.

Retain the lookup time and the actual matched destination document with the outbound attempt. If a later source correction changes the accepted consumption, begin the separately authorized correction process against that document. Updating a local payload or clearing its sent flag cannot change the physical event or reverse an already posted movement.

Configure the exchange history and recovery review in Seal.

Use Templates for source events, transactions and recovery assessments, linked through Reference fields. Store quantities as Number fields with explicit units, destination identifiers as defined mapping fields, and send/acknowledgement timing as Time & date values. Attach relevant source exports, responses and reconciliation reports as Files. Keep credentials and unrelated personal data out of record evidence.

The connection itself requires a configured Script or supported integration route with the appropriate access. Agree where retries run, which owner sees rejected or unknown outcomes, and how the receiver's response is recorded. A scheduled retry process must be configured; the presence of an unresolved record does not automatically create one. Use the platform documentation and the selected ERP's current interface documentation when implementing the actual code.

Use Seal review requirements and Checks for the controlled decisions you need—for example, requiring destination evidence and a rationale before publishing a recovery assessment. These publication checks do not prove that a remote movement has occurred. Test the interface in an authorised non-production environment, including a response lost after destination commit, before relying on it for routine inventory exchange.

Inspect the proposed fields and acceptance cases

Adapt these fields to the receiving connection. The cases describe expected behaviour to verify with the configured interface.

Download the field list · Download acceptance cases

Source consumption event

Represents the manufacturing fact. Its identity remains stable across every delivery attempt.

Source eventText
USE-610-007; identify the actual event, not only the batch.
Batch, step and containerReferences
B-610, step 7 and C-610-04, with the material-lot relationship.
Quantity and unitNumber / Select
2.40 and kg, retaining the defined quantity being transferred.
Execution and review basisReferences
The source records establishing which consumption event is permitted to be sent.

Outbound transaction and attempts

Separates the one intended movement from its network delivery history.

Transaction identityText
TX-610-007; reuse the intended transaction identity during a supported retry.
Source eventReference
USE-610-007, allowing the batch reviewer to find the integration history.
Destination mappingText / References
ERP material, plant or site, storage location, lot and the configured movement meaning.
Payload revision and evidenceText / Reference to File
Retain the exact agreed payload or a safely redacted representation for review.
Attempt identity and timingText / Time & date
ATT-610-01 and any later attempts, each with its actual send and response history.
Exchange stateSelect
For example: prepared, sent, acknowledged, rejected or outcome unknown; define these states in the connection.

Destination acknowledgement and reconciliation

Records what the ERP confirms, including any mismatch requiring resolution.

ERP movement identityText
M-88421, from the destination's supported response or reconciliation evidence.
Acknowledged transactionReference / Text
The verified relationship to TX-610-007, not a match based only on quantity.
Posted quantity and unitNumber / Select
The destination quantity and its unit, compared with the intended transaction.
Reconciliation resultSelect / Text
Matched, rejected, mismatched or unresolved, with the reason and source evidence.
Recovery owner and actionsUser / References
The responsible integration or inventory owner and any authorised correction work.

Destination commits before the response is lost

Input: Send TX-610-007 for 2.40 kg, let the test ERP create M-88421, then simulate loss of the response.

Expected: The sender records an unknown outcome. Recovery locates and verifies M-88421 using the agreed identity. The reconciled destination contains one intended consumption, with both the original attempt and recovery evidence retained.

Quantity is numerically equal but the unit is wrong

Input: Return destination evidence showing 2.40 g for an intended 2.40 kg transaction.

Expected: Reconciliation reports a quantity/unit mismatch. It does not mark the exchange matched because the numeric values are equal.

The same batch contains two legitimate additions

Input: Create separate source events for two additions from the same lot in B-610, each consuming 2.40 kg.

Expected: Each event retains its own intended transaction. Duplicate prevention does not collapse legitimate movements merely because batch, material and quantity match.

Apply this to your records

Use one actual-consumption event and its uncertain outbound movement. Establish the exact operation’s recovery contract before deciding whether another send is appropriate.

Download the blank working review

Write your working notes here

Notes stay in this tab and are not submitted. Download them before leaving to keep a copy. Use record references to identify your evidence.

Identify the source event, material, lot, plant/location, actual quantity and unit. Record the exact destination operation, movement meaning and any signed-quantity convention. Distinguish this event from reservations and issues.

Retain the original transaction identity, payload/mapping revision, external reference and each attempt’s time and response classification. Record which attempt has an uncertain outcome; a timeout does not establish a rejection.

Cite the installed operation’s identity/idempotency behavior, retention period where relevant and supported destination query. Record query scope, time and any delay or incomplete visibility that limits interpretation.

For each candidate, compare the agreed identity and all required material/location/lot/quantity/unit fields. Classify one complete match, field conflict, multiple matches or no currently visible match. Identical quantities alone do not identify a movement.

Record the responsible owner’s next action under the operation’s supported rules. Retain matched destination-document evidence. Treat a later source correction as separately authorized work linked to the original movement, not a silent payload edit.

Unanswered sections remain marked ‘Not recorded’ in the download.

Evidence needed to finish

The physical quantity remains unchanged by delivery attempts. The destination outcome is supported or explicitly unresolved, and any retry follows the exact operation’s contract. A correction references the original posted document and has its own traceable decision.

Identify the exact ERP product and BOM interface.

The product name alone is not an integration contract. Confirm the deployed ERP edition, enabled manufacturing features and documented endpoints or approved export interface. Check that the account can read the required BOM header, revisions, component lines and item references; do not infer BOM access from a successful connection to another ERP resource.

Define the first workflow narrowly: for example, populate a manufacturing preparation from a selected, effective BOM revision. Agree whether the ERP remains the owner of item masters, BOM definitions, inventory and production orders, and which execution or review records Seal owns. Keep those decisions visible in the mapping and operating procedure.

Select an effective revision and preserve the snapshot.

Resolve the BOM using the ERP identity and the dimensions relevant to the deployment, such as organisation, site or variant. Establish how revision status and effective dates determine the version appropriate for the intended order. A latest-modified timestamp alone does not prove that a revision is released or effective for that work.

When the manufacturing record is prepared, retain the source BOM and revision identity with the component snapshot used. If the ERP definition changes later, identify the difference and route any required update through the manufacturing workflow. Do not silently rewrite an in-progress record because a scheduled sync fetched a newer definition.

Map component quantities with their basis and units.

Preserve component line identity, item identity, quantity and unit, along with the parent quantity or other basis used by the ERP. A component requirement for a defined output quantity differs from an absolute amount to issue. Keep any configured conversion, rounding or yield rules explicit and test them with the team that owns the manufacturing definition.

Decide how to handle nested assemblies, alternatives and components requiring lot selection. A BOM names required material; it does not establish which lot was actually consumed or whether that lot is available and approved. Keep planned requirements, selected lots and actual consumption as distinct records or fields.

Return manufacturing outcomes through an explicit operation.

If Seal will return actual consumption, completion or another outcome, confirm the supported ERP operation and its required order, item, location and lot references. Define the state in which it is allowed and which review must happen first. A generic update of a BOM definition is not a substitute for an inventory or manufacturing transaction.

Retain a stable operation identity, the submitted payload and the receiver’s result. On an uncertain response, reconcile the ERP state before repeating a transaction that could move inventory twice. Handle validation failures and changed source records explicitly. Start with a test order and agreed reconciliation totals before scheduling broader exchange.

Test it with your data.

Use these cases to agree and test the connection’s behaviour. They are proposed acceptance checks, not completed tests or automatic connector features.

The batch scale differs from the BOM base quantity

The source BOM describes a base quantity of 100 units; the order requests 250.

Expected behaviour
Use the agreed scaling rules for applicable components. Preserve fixed quantities and other exceptions rather than multiplying every line by 2.5.
Evidence to keep
Base quantity, order quantity, each component’s scaling treatment and the reconciled requirements.

Actual usage differs from the planned component

Execution records a substitute material or a different consumed quantity.

Expected behaviour
Keep requirement and actual usage separate. Route the difference for the required assessment before any separately authorised ERP write-back.
Evidence to keep
The original requirement, actual material and lot, recorded quantity and the assessment or transaction outcome.
More checks for this connection
  • Compare a known BOM header, revision and every component line with the ERP, including units and quantity basis.
  • Test future-effective and superseded revisions so the selector cannot choose them merely because they were edited recently.
  • Change the source BOM after creating a test manufacturing record and verify that the retained snapshot stays identifiable.
  • Retry a completed read and simulate an uncertain write response. Confirm that the recovery path cannot issue material twice.

Before you connect

Can Seal push and pull ERP data?

Both directions can be configured where the provider exposes the required operations. Reading BOM definitions and writing manufacturing transactions are separate contracts with different permissions, mappings and verification needs.

Why use Seal Scripts instead of a fixed BOM connector?

The provider interface supplies the operations; the Script expresses your organisation’s mapping, selection and workflow rules using existing Seal capabilities. That flexibility still requires a tested contract for the exact ERP deployment and receiving templates.

Check your system’s connection options.

Confirm the installed version, available exports and permissions. These pages cover the source interface and link to setup instructions.

For configuration: Seal Scripts and local-file collection.

Work through the receiving process.

Explore the records, calculations and exception decisions behind this connection.

Start with one export.

Bring the source evidence and the records it needs to connect to. For this workflow, a useful starting pack is:

  • A known order and its selected BOM or recipe revision.
  • Base quantity, component quantities, units and any approved substitutions.
  • Actual material usage and the receiving transaction rules, if write-back is required.
Discuss this connection