Ibadan Inventory barcode
The inventory barcode in Ibadan has 8 digits, with zeros (0) on to the right side as padding, but the current data in the barcode field doesn't have padding.
in this example, the barcode must be 00436375
instead 436375
.
to fix the problem, please, execute this script:
begin transaction
update inventory
set barcode
= right('00000000' + rtrim(ltrim(barcode)),8)
where barcode is not null
commit transaction