Is there a way for me to change the

inventorynumber

field on an inventory number record or do I have to cycle through every transaction?

you probably want to at least try only changing the record that created the inventory number

It only changes it on that record. The problem I have is that every transaction type has a different way of changing the lot. I have to write a function to change each one.

Are you asking if you can give Lot “ABEC” a new name like “CEBA”? If that is the case, then I don’t think you can do that. you will need to adjust out the on hand quantity and adjust it back in with the corrected lot number.