You can generate barcodes in BUZ for individual job lines which can be scanned and statuses updated as required.
The formula for this is =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:
I2OF5MOD10 - Used by 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
Here is an example of the Job Sheet:
The Barcode width is dependant on the row height. Our recommended minimum row height is 75. You can have it set lower however it may cut off the bottom of the barcode.
Here are some examples of what the barcode will look like with different row heights
Row Height 25 | Row Height 70 | Row Height 75 |
|---|---|---|
 |  |  |