Results 1 to 6 of 6

Thread: Count distance between letters in ER code

  1. #1

    Count distance between letters in ER code

    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
    Current: E1 9.2, TR 9.2.2.5, Win2012 R2, SQL Server 2014 R2, Weblogic, OneView, Embedded BIP
    Upgrade: E1 9.1, TR 9.1.4.4, Win2008 R2, SQL Server 2008 R2, WebLogic, OneView, Embedded BIP
    Original: E1 8.0, SP 24.1.2, Win2003, SQL Server 2005 SP3, all fat client

  2. #2
    Senior Member DSauve's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA
    Posts
    1,259
    Jer,

    I think you'll have to create a C business function to convert the character to its ASCII value, or you could also create a custom UDC, where each character would represent a unique UDC value, and the ASCII value is the UDC description. Then you could just take the value of the description for doing your math -- without having to have a C business function. Just a thought.
    Don Sauve
    Wagstaff, Inc.
    E1 9.2, Win2016, SQL Server 2016, TR 9.2.2.6, WebLogic 12.2.1, BI Publisher

  3. #3
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,376
    Could you not try a string loaded up with ABCDEFGHIK etc and then Find Position in a String using what you said above.

    Or this guy....
    N4600540 - F4100 Calculate Proximity. It requires people to enter the locations actual grid coordinates though. Or coordinates from a reference point.

    As your method is relying on the fact they are physically laid out alphabetically. that's not always going to the be case in rows
    In this example of 2 rows

    ABCD
    EFGH

    H is closer to D than E is
    Last edited by johndanter; 07-22-2019 at 02:29 AM.

  4. #4
    Thank you both for excellent suggestions. Both the UDC and position in a string options will work well. I got stuck in ASCII land and didn't think outside of the box.
    Current: E1 9.2, TR 9.2.2.5, Win2012 R2, SQL Server 2014 R2, Weblogic, OneView, Embedded BIP
    Upgrade: E1 9.1, TR 9.1.4.4, Win2008 R2, SQL Server 2008 R2, WebLogic, OneView, Embedded BIP
    Original: E1 8.0, SP 24.1.2, Win2003, SQL Server 2005 SP3, all fat client

  5. #5
    Senior Member johndanter's Avatar
    Join Date
    Sep 2003
    Location
    Cork, Ireland
    Posts
    1,376
    Welcome
    Those 3 coordinate fields work well too mind as they are true actual positions but require a lot of setup. I used them at an older site
    I asked our warehouse guy what he does here and we use look at the putaway sequence field WSQP and the LA05/LA06 for this kind of stuff

    If you are interested, I also wrote something that helps people pick like orders in batches. That also speeds up picking

  6. #6
    John, putaway sequence sounds like advanced warehousing, am I missing something that we could be using? I hear you on the coordinates and it would be interesting to do, but our warehouse is a simple setup. While D is actually closer to W than to K, the conveyor running down the middle makes it farther. So, the simple find position in a string is sufficient.

    We have a batch picking process in place, one of the drivers for my project is to identify and get orders funneled into that process so it is used at a higher capacity for the small orders.

    Thanks again for your time,
    Jer
    Current: E1 9.2, TR 9.2.2.5, Win2012 R2, SQL Server 2014 R2, Weblogic, OneView, Embedded BIP
    Upgrade: E1 9.1, TR 9.1.4.4, Win2008 R2, SQL Server 2008 R2, WebLogic, OneView, Embedded BIP
    Original: E1 8.0, SP 24.1.2, Win2003, SQL Server 2005 SP3, all fat client

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.