Manila inventory barcodes
What is the contents of your current QR code and 1D barcodes on seed packets in storage?
Fill GG-CE with barcodes
update inventory set
barcode=concat('GR-', FORMAT(inventory_number_part2, '0000000000'))
where barcode is null and form_type_code != '**' and inventory_maint_policy_id in (2,3,4,5,10,11);
-- And for planted
update inventory set barcode = concat('GRC-',inventory_number_part3,'-',inventory_number_part1,'-',convert(varchar,inventory_number_part2)) from inventory
where form_type_code <>'**' and inventory_maint_policy_id=8 AND INVENTORY_number_part3 is not null;