You can generate barcodes in BUZ for individual job lines, which can be scanned and statuses updated as required.
The formula for this is =IF(ISBLANK(Data!AV11),"",I2OF5MOD10(BarcodeValue(Data!$BC$5,Data!$BD$5,Data!$AW11,1),0))
For the barcode to work in Job Scanning, the Data!$BC$5 & Data!$BD$5 cells cannot be changed. The only variable will be Data!$AW, which will start from AW11 and then AW12, and so on…
Breakdown of the formula:
IF(ISBLANK(Data!AV11),"", If the job sheet has data for that line, then produce a barcode
I2OF5MOD10 - Used by the conversion program to populate the barcode
BarcodeValue - Formula to generate value for the barcode
Data!$BC$5 - Order number
Data!$BD$5 - Revisions number
Data!$AW11 - Fixed line number. This can be a variable to allow BUZ to scan individual lines in the job
1),0) - Parameters for barcode value
...
The Barcode width is dependant on the row height. Our recommended minimum row height is 75. You can have set it set lower; however, it may cut off the bottom of the barcode.
...