JMast
Reputable Poster
Hello All,
I have a situation where I need to know the distance between two letters in my UBE ER code. Is there a business function that will provide the ascii or Unicode values so I can do the math? The scenario is for our warehouse. For the purposes of picking orders, they want to know how close the products are in the warehouse aisles. The idea is to identify pickslips where all the products are fairly close together for faster picking. So, I would like to do something like the following. Sort the lines by location. Take the first letter of the first location and the first letter of the last location and compare. If the "distance" is less than 3, this is a candidate for fast pickling.
We do not use advanced warehousing.
Thank you for your help,
Jer
I have a situation where I need to know the distance between two letters in my UBE ER code. Is there a business function that will provide the ascii or Unicode values so I can do the math? The scenario is for our warehouse. For the purposes of picking orders, they want to know how close the products are in the warehouse aisles. The idea is to identify pickslips where all the products are fairly close together for faster picking. So, I would like to do something like the following. Sort the lines by location. Take the first letter of the first location and the first letter of the last location and compare. If the "distance" is less than 3, this is a candidate for fast pickling.
We do not use advanced warehousing.
Thank you for your help,
Jer