Blog

2026.11.09

Roll Material Remaining Length and Lot Control: An Implementation Guide

Roll Material Remaining Length and Lot Control: An Implementation Guide

A roll material remaining length and lot control system must answer a question that a count of rolls cannot: which specific roll can supply the next production order? Film, wire and fabric rolls may leave a warehouse, be cut several times and return with damaged edges or a different usable length. This guide explains roll identity, receiving and issue transactions, cutting and returns, ERP–WMS–MES integration, and the evidence to request in an RFP, FAT and SAT.

Why lot tracking alone cannot show usable roll length

Ten rolls from the same supplier lot can have ten different initial lengths, histories, locations and conditions. The supplier lot groups material for quality investigation; an internal roll ID identifies each physical roll. A screen showing 800 m for the lot cannot establish whether a 250 m continuous cut is possible. Several short remnants may add up to 800 m without supplying that order. Conversely, a 300 m roll returned from the line may be invisible to purchasing if the issue was never reversed or reconciled.

Separate the data into three levels: material and specification revision, supplier lot, and internal roll ID. The first defines compatibility, such as width, thickness, material or electrical grade. The second supports quality status and traceability. The third holds the individual roll’s length, location and transactions. An internal roll ID is a local system design choice. GS1 Application Identifiers support product identification and variable measures, but do not mandate a factory’s internal ID or automatic updates after every cut.

GS1 gives rope, chain, fabric and carpet on a roll as examples of variable measure trade items. Its Logistic Label Guideline describes AI (311n) for length in metres, AI (10) for batch or lot, and AI (8001) for roll attributes. These references help when interpreting supplier labels. They do not mean every factory roll must carry those fields. In particular, the length received from a supplier and the remaining length measured after factory use are different facts with different timestamps and sources.

Define the boundary between inventory, cutting and returns

Start by deciding when responsibility moves from warehouse to line and when a returned roll becomes available again. A basic path is: receive and assign an ID; inspect; approve; store; reserve and issue; mount and cut; return; verify remaining length and condition; and release for another order. Real operations also include temporary storage beside a machine, shift handover, subcontracting, and quality hold. State which statuses count as on hand, available or reserved in the RFP.

A finished goods record saying “400 m of film consumed” cannot tell staff which roll was used or where the remainder went. The issue also differs from a generic offcut program. A roll’s winding direction, splices, core diameter and continuous usable length can determine whether it fits a machine or order. See the related guides on offcut inventory control and surplus material returns. Here the focus is preserving one roll’s identity through repeated cuts and returns.

Pilot one material family, one warehouse and one or two lines. Include examples of full consumption, partial return, damaged edges and a quality hold. A pilot consisting only of full rolls will never test the return and reallocation process. An initial scope containing every exceptional material may bury the basic issue and return workflow in special development.

Roll Material Remaining Length and Lot Control: An Implementation Guide - figure 1

Model roll ID and supplier lot separately

At minimum, store internal roll ID, material code and revision, supplier lot, receipt date and length, unit, calculated remaining length, latest measured length, usable length, location, status, measurement method and timestamp. Add width, thickness, core size, winding direction, splice count, supplier roll number and restrictions when they affect selection. Film of the wrong width, wire of the wrong grade and fabric from an incompatible colour lot cannot be made interchangeable merely by adding their metres together.

Supplier labels may be missing or use a number more than once. Avoid treating a supplier lot number alone as a unique roll key. Make the internal roll ID unique, retain the supplier number as a reference, and search by supplier, material and lot. Decide whether a damaged internal label is reprinted or a new identity is issued. A simple reprint should not split one roll’s history into two records.

Barcode, QR and RFID are possible capture methods. Choose based on the physical reading point and maintenance needs. A label on the outer wrap may disappear when the roll is mounted; a core or end label may work better. If the label prints a remaining length, define how obsolete labels are invalidated after cutting. Keeping the system as the length record and the label as an ID lookup often makes repeated use easier to reconcile. Where the network is unreliable, specify offline capture, synchronization and duplicate prevention.

AI (10) represents a batch or lot, AI (311n) a variable measure trade item’s length, and AI (8001) roll attributes including width, length, core diameter, winding direction and splices. They inform trade label design. Reading the initial supplier length does not maintain a live factory balance. Retain the supplier reading, factory transaction history and later measurements separately, with the person or device and time that established each value.

Keep book length, measured length and usable length distinct

Book length is the receipt length less recorded use and scrap. Measured length comes from a length counter, measuring device, weight conversion or roll diameter estimate. Usable length is what a particular order can actually consume after allowing for a damaged edge, leader material, splice restrictions and other quality rules. Overwriting all three in one field erases the reason for a discrepancy.

Consider an illustrative example, not an industry benchmark. A roll arrives at 500 m. Good production uses 180 m, startup consumes 12 m, and recorded scrap is 3 m. Its book balance is 305 m. A return measurement finds 302 m. The 3 m difference should trigger a review of measurement tolerance, counter position, timing and unposted cuts before anyone calls it a loss. If 5 m of its leading edge is damaged, usable length for a particular order may be 297 m or less. Different orders may apply different quality restrictions.

Every measurement has uncertainty. A feed encoder can slip or be affected by tension. Weight conversion depends on mass per metre and core weight. Diameter estimates depend on thickness, winding tightness and core size. Test the method against a reference on the materials and machines in scope, then set tolerances. Display the estimate, most recent measurement and its date together. A long, critical order may require a fresh measurement before reservation.

Record receiving, cuts and returns as transactions

Keep an event ledger rather than only the latest balance. Define events for receipt, inspection release, movement, reservation, issue, mounting, cut, startup loss, scrap, return, measured adjustment and quality hold or release. Record roll ID, occurrence and entry time, operator or device, source and destination, quantity and unit, reason and production order. Then book length can be reconstructed. A measurement adjustment has its own reason and approval instead of silently changing history.

For a cut, distinguish length contained in good product from material threaded into a machine, removed during setup, used for inspection or scrapped. A production order requiring 100 m in finished product may consume more from its roll. Yet too much manual entry discourages capture. Find which readings can be taken from the measuring device and production order, leaving operators to confirm exceptions and reason codes. Specify when a device reading becomes final and what happens during a communication failure.

A return is more than moving a location. Read the ID, measure or verify remaining length, and check edge condition, winding, splices and protective packaging. Keep “returned, awaiting inspection” separate from “available for allocation.” Microsoft Dynamics 365 documentation distinguishes inventory transaction details, physical and financial updates, and references to source transactions. This is a useful example of why an audit trail matters, not a recommendation that every plant adopt that product.

During a count, reconcile identity, location, length and status. Fixing only the length will not help if staff cannot find the roll; fixing only its location still leaves an impossible allocation. Classify discrepancies such as missed scan, unposted cut, measurement error, quality restriction or duplicate ID. Require an approved adjustment linked to the earlier event.

Roll Material Remaining Length and Lot Control: An Implementation Guide - figure 2

Allocate by continuous length and compatibility, not total metres

Allocation criteria include material revision, width, thickness, colour lot, winding direction, core size, quality approval, continuous usable length and required date. Three 90 m rolls plus one 30 m roll total 300 m, but none can serve a 200 m unbroken cut. The answer may differ if a product explicitly permits a splice. Store that permission in the product or process rule, and show candidate rolls and exclusion reasons on the allocation screen.

Priority rules can favour older material, shorter remnants, nearby storage or a required lot. Using the shortest remnant first may reduce waste, but could consume the only long roll needed for an urgent order. FIFO cannot override a hold or quality restriction. Show the rule, usable length, measurement freshness and existing reservation so staff can make an authorized exception with a recorded reason.

Microsoft’s warehouse documentation explains that the point at which a batch or license plate is identified and reserved depends on the reservation hierarchy. Its mobile picking guidance discusses batch capture and separate target license plates for partial picks. If using that platform, test exactly what standard functions do for an internal roll ID, each cut, a measured discrepancy and continuous length. The same questions apply to other platforms. A demonstration of lot reservation alone does not prove that a returned roll can be reallocated safely.

Assign one source of truth across ERP, WMS and MES

ERP often owns purchasing, valuation, costing and orders; WMS often owns locations and issue; MES often owns mounting, cutting and production records. Actual responsibilities depend on the installed systems. Define one source of truth for each field rather than relying on product labels. One possible split is ERP for materials and supplier lots, WMS for roll ID and location, and MES for cuts and measurements. Prevent three systems from independently editing a remaining length and showing three answers the next morning.

Integration messages should include event ID, roll ID, material, lot, transaction type, quantity and unit, occurrence and entry times, order number, prior event and state version. Treat a resent event ID as the same transaction. Distinguish provisional from confirmed cuts. Test a line that records offline and uploads later, including a return arriving before its cut event. A negative balance caused by out-of-order messages must be held for review, not silently accepted.

Define conversions at the boundary. Purchasing may buy kilograms, the warehouse count rolls, and production use metres. A kg-per-metre factor can vary with width and material; core and packaging weight also matter. Specify which unit is authoritative for cutting, whether receipt length was measured or declared, the conversion revision, rounding and variance handling. ERP valuation and MES usage may use different units while still referring to the same physical event.

Write exception scenarios into the RFP

Describe the pilot materials and lines, locations, estimated transaction volume, existing systems, devices and network. If volumes are unknown, ask for a site survey rather than inventing numbers. Replace “supports roll management” with testable requirements: several IDs under one supplier lot; partial use and return under the same ID; a book-versus-measured variance; a hold that prevents allocation; and a subsequent release and reallocation.

Specify the measurement interface. Will a device send data through an API, a PLC, or manual terminal entry? What are its unit, resolution, reset behaviour and time synchronization? List label printers, scanners and handheld devices by work point. Test a scan with gloves and check whether an end label survives movement. A polished demo cannot compensate for an ID that operators cannot read.

Request separate estimates for software, devices, measurement integration, ERP/WMS/MES interfaces, master data, migration, FAT, SAT, training and support. No generic price or ROI can be inferred from the cited sources. Measure today’s discrepancies, search time, repeat buying, stoppages and discarded length using consistent definitions. Ask which requirements are standard product capabilities and which are custom development that future upgrades must preserve.

Verify remaining length in FAT and SAT

In factory acceptance testing (FAT), run a scripted case set: multiple rolls under one lot, differing initial lengths, partial issue, repeated cuts, startup loss, return measurement variance, hold, reallocation and count adjustment. Write the input, action and expected book balance, usable length, event history and ERP result before testing. Include event resend, out-of-order delivery, offline recovery and duplicate scans.

In site acceptance testing (SAT), repeat the path with real rolls, labels, scanners, measurements, lines and network. Focus on rewinding, dirty labels, counter resets, shift changes and night returns that a test environment may miss. At migration, separate a book roll with no physical item, a physical roll with no ID, and a roll at a different location. Resolve the difference before declaring the new record trustworthy.

Each plant sets its acceptance tolerances. Some checks need no invented threshold: the ledger recomputes book length; a held roll cannot appear as allocatable; a reconnect creates no duplicate transaction. Establish measurement tolerance for each material, machine and method. Record failure cause, temporary control, owner and retest criteria.

Roll Material Remaining Length and Lot Control: An Implementation Guide - figure 3

Track operating outcomes after go-live

The number of registered rolls alone is a weak measure. Track the share of readable receipt IDs, completed cut events, time to return, book-to-measurement variance, unexplained differences, and allocations rejected at the line. Compare discarded length, emergency purchases and material search time with a preimplementation baseline using the same definitions. Separately verify that quality holds are respected and lot histories can be traced.

If variance grows, separate missed events from measurement problems. A line-specific problem points to counters or setup recording; a material-specific problem may indicate thickness or weight conversion; a shift-specific problem may point to device placement and training. Clearing all differences with a count adjustment erases the cause. Review the leading reason codes monthly and change the capture or interface process accordingly.

Also distinguish a shortage of total metres from a shortage of sufficiently long rolls. The first may require purchasing or planning changes. The second may be addressed through cutting sequence, permitted splices or remnant selection. Short pieces have little value if no approved product can use them. Review usable stock against specifications, quality state and storage limits.

Frequently asked questions about roll material control

How should a Thai plant run roll control across languages?

Connecting a Thai production line to a Japanese headquarters ERP requires more than translated screen text. Material codes, quality states, scrap reasons, measurement methods and units must mean the same thing in each system. “Returned” may mean physically back in the warehouse or already inspected and reusable; make these separate events and use one underlying state code across languages. Show whether each state permits allocation. If operators misunderstand it, revise the screen sequence and decision owner as well as the translation.

Write responsibilities into the procedure. For example, warehouse staff verify receipt, quality staff decide whether damage permits use, production confirms a cut, and an inventory controller approves a count adjustment. Define a provisional status for night or holiday periods when an approver is absent. System permissions should match this responsibility table. Routine use of unrestricted administrator edits makes it difficult to reconstruct the original balance.

Train each role on its own daily sequence with physical rolls. Operators practise reading the ID before mounting, confirming cuts, holding a damaged roll and recording a return. Quality staff practise documenting a hold and the effect on related rolls. Planners practise explaining why a candidate is excluded and when it was last measured. Knowing how to open a screen is not enough; staff must know when an exception must stop the ordinary workflow.

Which roll length boundary cases belong in acceptance tests?

A roll nearly empty is a critical test. A book balance exactly equal to product length may still be too short after threading or trimming. Decide whether setup allowance depends on machine, material or cutting pattern, using trial data. If a shortage lies within measurement uncertainty, request a fresh measurement or authorized decision rather than automatically declaring the roll usable.

Also test two planners reserving the same roll simultaneously. A screen may show it free when opened, but the final save must recompute availability after another reservation. Test partial release of a reservation, a roll still mounted during shift handover and two terminals acting at once. For quality, test a product permitting one splice and another permitting none. A damaged edge that is physically trimmed needs a scrap event in addition to any quality judgement; this keeps physical consumption distinct from the decision that a roll can be used.

After launch, bring a physical roll and its ledger to improvement meetings. Can planning explain an exclusion, warehouse find it, production show the last cut and quality show the hold reason? A matching number is insufficient if the real material is damaged. Correct the capture point or rule when the physical evidence disagrees.

Teams may use “inventory” to mean different things. Purchasing wants to see open orders, production wants material available to its line today, and quality wants held stock visible but excluded from allocation. Show ordered, received, awaiting inspection, usable, issued, awaiting return and reserved quantities as distinct states. Different totals can be valid if their inclusions are explicit.

During migration, paper issue slips and new terminal transactions may run in parallel. Decide which is authoritative and reconcile daily to prevent double consumption. Add roll IDs to the old slips where possible. End parallel operation only after the main scenarios work reliably, discrepancy reasons are understood and night shift training is complete.

Can the lot number also be the roll ID?

Only in a narrow case where a lot always has one roll. With multiple rolls or partial returns, use a supplier lot for shared quality history and a unique roll ID for each balance and location. Link them for search and traceability.

Is a length measuring device required from day one?

You can begin with a calculated book balance from receipt, use and scrap, clearly labelled as such. Add physical verification first at returns or before critical long cuts. Validate weight or diameter estimates on the actual material before using them for allocation.

Can an existing ERP or WMS do this alone?

It depends on the product and configuration. Standard batch tracking, transactions and mobile picking may help, but test individual roll cuts, measured differences and continuous-length allocation with real scenarios. FAT should show where standard functions end and an MES or extension begins.

Does GS1 AI (311n) automatically update remaining length?

No. It encodes a length for a variable measure trade item. The factory still needs to record cutting, loss, return and measurement events to know its current balance. Keep trade label data distinct from the live roll ledger.

What should be compared in implementation quotes?

Compare the same scenarios and scope, including devices, measurement, system interfaces, data cleanup, pre-migration physical inventory counts, FAT, SAT, training and support. A quote excluding returns or quality holds can appear cheaper while omitting the workflow the plant needs most.

Conclusion: make each roll’s usable length visible

Before migration, match each physical roll to its label, material revision, supplier lot, location and a documented length check. Mark unknown values as unverified rather than entering a guess as a measurement. Keep unlabeled, missing or uncertain rolls out of ordinary available stock until investigated. Otherwise an accurate new transaction ledger begins from an unreliable opening balance.

Define how identity changes when a roll is rewound, its core replaced, one roll split into two, or material laminated. Sometimes the same ID can retain an updated attribute; sometimes child IDs linked to a parent are needed. Quality and production should decide together. Quantity reconciliation alone cannot preserve physical lineage.

The planner ultimately needs more than a displayed metre value: whether it was measured or calculated, when, what orders reserve it, and what quality restrictions apply. Show impossible conditions such as a balance above received length, the same roll in two places, or usable length unchanged after disposal as blocking exceptions. Review repeated small differences by machine and event history before using the roll in tomorrow’s allocation. Compare consistent pre- and postimplementation measures to establish the actual benefit at that plant.

Useful roll material control combines supplier lot traceability with internal roll identity, transaction history, book and measured length, quality state and continuous-length allocation. Define states and system ownership first; specify exceptions in the RFP; and follow the same roll from receipt through return and reallocation in FAT and SAT. This exposes gaps that a screen demonstration misses.

If you are exploring roll-level control for film, wire or fabric, contact TOMAS TECH with a sample issue slip, return procedure and the systems involved. An early discussion can focus on the transaction that is currently hardest to trace.

References