Connect CBSA Transaction Numbers to Lot, Production, Scrap, and Export Records
Canadian manufacturers using the Duty Relief Program need more than import paperwork. They need a reliable way to show what happened to imported material after it entered the plant.
10in6 helps manufacturers connect customs transaction data, supplier lots, production batches, scrap and waste records, inventory status, and export shipments into a single operational record — built across MES, DQS, lot traceability, ERP integration, scrap tracking, and export reporting.
Duty relief depends on more than the import record.
The Duty Relief Program can allow eligible importers to defer duties on goods brought into Canada when those goods are later exported, either in the same condition or after being used in production. The program is administered by the Canada Border Services Agency (CBSA) — see CBSA's Duty Relief Program page for the official program description and reporting requirements. The operational challenge starts after customs clearance.
A plant may receive multiple inbound trucks per day, with imported material coming from multiple suppliers across multiple part numbers, purchase orders, and shipments. The CBSA transaction number (from the CAD / B3) lives in customs documentation. The plant floor operates with supplier tags, lot numbers, production batches, inventory records, scrap entries, and shipping documents.
For manufacturing teams, the question becomes:
Can you trace imported material from the CBSA transaction number all the way through production, inventory, diversion, and export — and produce records needed to support DRP reporting and audit readiness?
That is the gap 10in6 helps close.
Customs-to-Receiving Reconciliation
The hardest practical gap in DRP traceability is linking broker and CAD transaction data to the physical supplier lots received at the plant. Customs data lives in one set of records. The skid on the dock has a different identifier on it. Until those two are connected, every downstream report — diversion, inventory, sales — has a missing first link.
The transaction-to-lot link should be created as close to receipt as possible, using broker data (received via SFTP, EDI, or structured file), ASN, PO, and invoice records, and supplier lot scans. Optional internal labels, barcode scans, or receiving workflows can be used to connect the CBSA transaction number to supplier lots and received material — based on what fits your receiving area and existing process.
- CBSA / CAD transaction number
- CAD line number
- Release date
- Imported part or material number
- PO, ASN, and invoice number
- Received quantity and unit of measure
- Supplier lot number
- Internal lot or batch number
Once those identifiers are connected at receipt, the rest of the traceability chain — production batch, scrap, finished goods, export — can carry the customs context with it instead of being reconstructed at month-end.
From customs clearance to export, in one connected record
The customs broker provides CAD transaction details — transaction number, line number, release date, country of origin, HS classification, duty rate, GST rate, value — through SFTP, EDI, or structured file import.
At receiving, the CAD transaction is linked to the ASN, PO, invoice, supplier lot, and internal lot or batch. Optional barcode scans, label print, or receiving workflows close the gap as close to receipt as possible.
Raw material lots are consumed into production batches. Each batch carries the originating CAD transaction reference forward through every operation.
Process scrap, flash, shavings, and rejected parts are recorded against the consumed lot — captured through operator entry, barcode scans, machine data, or system-calculated values.
Material still on hand is tracked by lot, with quantity, value, duties remitted, GST remitted, and aging against the required DRP timeline.
Finished goods shipments are tied back through the production batch to the consumed lot and the original CAD transaction, including customer, commercial invoice, ship-to country, export date, and export document reference.
Diversion, Import Summary, Inventory, and Sales & Export reports are generated from the same connected record set — in Excel format, on a repeatable schedule.
The reports a manufacturer may need to produce
10in6 can help generate the operational reports a manufacturer may need to produce during DRP reporting, review, or audit. Reports can be produced on a monthly cadence in Excel format using validated system data.
Diversion Report
Imported material that was not exported as finished goods — process scrap, flash, shavings, rejected parts, domestic sale, destruction, missing inventory, or material that exceeded the required DRP timeline. Combines customs data with production and scrap data to calculate diverted quantity, value, duty owing, and GST owing.
Import Summary Report
Every CAD transaction and line, with description, HS classification, PO, invoice, quantity received, quantity diverted, quantity exported, quantity remaining, duties remitted, GST remitted, and outstanding duty exposure.
Inventory Report
Imported material still on hand, by lot, item, quantity, CAD transaction number, CAD line, value, duties remitted, and GST remitted — with aging fields so material approaching the end of the required DRP timeline is visible early.
Sales & Export Report
Finished goods sold or exported, tied back through the consumed raw material to the original CAD transaction. Includes finished item, quantity shipped, customer, commercial invoice, invoice date, ship-to country, export date, and export document reference.
Built across the platform, not bolted onto one module
DRP traceability spans more than one part of the operation. 10in6 connects customs data, lot traceability, production records, scrap capture, inventory status, and export documentation across MES, DQS, and the integration services that tie them to your ERP and broker.
Customs and broker data integration
Receive CAD transaction data from customs brokers through available transfer methods such as SFTP, EDI, or structured file import.
ERP and inventory integration
Connect to ERP data such as POs, receipts, invoices, item masters, BOMs, routings, costs, exchange rates, inventory records, and shipping records.
Lot and batch traceability
Track supplier lots, internal lots, split lots, production batches, and material consumption through each stage of production.
Production and scrap capture
Use operator entry, barcode scanning, machine data, or system-calculated values to record production, scrap, flash, shavings, and rejected parts against the originating transaction.
Aging and timeline visibility
Track imported material against the required DRP timeline so aging exposure is visible before material moves out of compliance.
Report automation
Generate monthly Excel reports from validated system data instead of compiling information from multiple systems by hand.
Example: from imported raw material to exported finished goods
A manufacturer imports raw material into Canada under a Duty Relief Program licence. The customs broker provides CAD transaction details after clearance. The material arrives at the plant with supplier lot tags and is received into the ERP.
During production, the lot is consumed into batches. Some material becomes finished goods. Some becomes process scrap, flash, or shavings. Some remains in inventory. The finished goods are later shipped to a customer outside Canada.
With the right traceability layer in place, the team can show:
- Which CAD transaction and line the material came from
- Which supplier lot was scanned and consumed
- Which production batch used the lot, and when
- How much became finished goods, and how much became scrap, flash, or shavings
- What remains in inventory and how it is aging against the required DRP timeline
- Which finished goods were exported, to whom, and under what export reference
- Which records support each line of the monthly DRP report
Where DRP traceability shows up most often
DRP is most commonly used by Canadian manufacturers in automotive and automotive supply, metals processing and forging, fabricated metals, industrial components, and aerospace — operations that import raw material into Canada and export finished goods. Any operation that imports under a DRP licence and exports finished goods can benefit from a connected traceability and reporting layer.
Is DRP traceability relevant to your operation?
- You import raw material or components into Canada
- You export finished goods (or material in the same condition) outside Canada
- Your operation processes the imported material before export
- You need to establish lot or batch traceability through your production
If most of these apply, a connected traceability and reporting layer will materially reduce the recordkeeping burden of operating under DRP. Final program eligibility is determined by CBSA and your customs broker.
DRP traceability runs on real manufacturing workflows.
DRP traceability is not a generic recordkeeping problem. It depends on the actual way material moves through your plant — supplier tags, receiving workflow, lot rules, ERP master data, scrap calculation methods, production routes, and export documentation. None of that is the same from one operation to the next.
10in6 helps map the real process and build a workflow operators can actually follow. We do the field work to understand how supplier lots arrive, how the ERP is configured, how scrap is generated and counted, and how shipping records are produced — and then we build the traceability layer to fit. The result is a workflow that runs in production, not a system that requires a manual workaround every time something doesn't match the assumed model.
Process mapping
We walk the receiving area, the production floor, and the shipping dock. We document how material actually flows — supplier tags, lot rules, scrap behaviour, and export documentation — before any configuration begins.
Broker and ERP integration
We connect to your customs broker (SFTP, EDI, or file) and your ERP (POs, receipts, invoices, BOMs, costs, inventory, shipments). The integration is built and maintained by our team — not handed to your IT department.
Operator-ready workflow
Receiving steps, scrap entry, and production reporting are configured to match what operators are already doing — so the traceability data is captured during the work, not after it.
Ongoing support
Brokers change. ERP versions change. Product mixes change. Our team stays engaged so the traceability layer keeps producing the records you need without becoming a project that has to be rebuilt every year.
Where DRP traceability touches the platform
DRP traceability questions
- What is the Duty Relief Program?
- The Duty Relief Program (DRP) is a Canada Border Services Agency program that can allow eligible importers to bring goods into Canada without paying duties when those goods are later exported, either in the same condition or after being used in further processing. The official program description and reporting requirements are published on CBSA's Duty Relief Program page (cbsa-asfc.gc.ca/import/ddr-red/relief-report-eng.html). Specific eligibility, conditions, and timelines are set by CBSA and your customs broker.
- How is DRP different from Duty Drawback?
- DRP defers duties at the time of import — the duties are not paid up front, provided the goods are later exported within the required DRP timeline. Duty Drawback is a separate program where duties are paid on entry and refunded after the goods are exported, used in producing exported goods, or destroyed. Some manufacturers operate under both programs depending on the goods, timing, and how their broker structures filings. 10in6's traceability layer can support recordkeeping for either program.
- Where does PARS fit into the traceability flow?
- PARS (Pre-Arrival Review System) is the CBSA program that lets brokers submit release information before a truck arrives at the border. The PARS number is used by carriers during clearance and is later resolved into a CAD transaction number. From a plant-floor traceability perspective, the link that matters is the one made at receiving — the CAD transaction number connected to the physical supplier lot.
- Does 10in6 file DRP reports with CBSA?
- No. 10in6 does not determine DRP eligibility or file customs declarations. We help manufacturers build the operational traceability and reporting layer that supports their internal compliance process, ERP records, and customs broker workflows.
- How does the CBSA transaction number get connected to physical material?
- Customs transaction data can be received from your broker through SFTP, EDI, or structured file import, and then linked at receiving to the corresponding ASN, PO, invoice, supplier lot, and internal lot or batch. The transaction-to-lot link should be created as close to receipt as possible using broker data, ASN/PO/invoice records, and supplier lot scans.
- Do we need to print labels with the transaction number on them?
- Not necessarily. Optional internal labels, barcode scans, or receiving workflows can be used to connect the CBSA transaction number to supplier lots and received material — depending on what is practical in the receiving area and what fits your existing workflow.
- How is scrap, flash, and waste handled?
- Process scrap, flash, shavings, and rejected parts can be captured at the point of production through operator entry, barcode scanning, machine data, or system-calculated values, and linked back to the originating CAD transaction through the consumed lot.
- Do we need a specific ERP for this to work?
- 10in6 integrates with the ERP, inventory, and shipping systems you already use. The traceability layer connects customs data to those records rather than replacing them.
- Can we trace finished goods back to the imported raw material they came from?
- Yes. Finished goods exported to a customer can be tied back through the production batch and consumed lot to the original CAD transaction and line.
- What if imported material exceeds the required DRP timeline?
- The inventory report includes aging data so material approaching the end of the required DRP timeline is visible before it becomes a duty exposure issue. Specific timeline rules should be confirmed with your customs broker or CBSA.
- Is this only a Digital Quality System feature?
- No. DRP traceability spans MES, DQS, lot traceability, ERP integration, scrap tracking, and export reporting. It uses production data, quality records, customs data, and shipping data together — it is not a single-module feature.
- Which industries use DRP traceability most?
- DRP is most commonly used by Canadian manufacturers in automotive and automotive supply, metals processing and forging, fabricated metals, industrial components, and aerospace — anywhere imported raw material is processed and the resulting finished goods are exported. Any operation that imports under a DRP licence and exports finished goods can benefit from a connected traceability and reporting layer.
- How do I know if DRP is right for our operation?
- Generally, DRP applies when (1) you import raw material or components into Canada, (2) you export finished goods (or material in the same condition) outside Canada, (3) you can establish lot or batch traceability through your production process, and (4) the timing between import and export fits the required DRP timeline. Final eligibility is determined by CBSA and your customs broker.
Need this configured around your real workflow?
Every 10in6 deployment includes our team — connecting your equipment, configuring your workflows, and supporting your operation long after go-live.
Need to connect DRP requirements to your manufacturing process?
If your team needs to track imported goods through receiving, production, scrap, inventory, and export, 10in6 can help design a practical traceability and reporting workflow around your existing systems.