We use prefixes on our Stock Items to indicate the condition of products. I’m trying to use the LEFT function on the ARTran.InventoryID field in a GI to return the first 3 characters of the InventoryID but it is instead returning 3 numbers.
I’ve tried using all the conversion functions and they all return a string of numbers from the ARTran.InventoryID field.
Any suggestions?