#4424 Unable to View All the Locators

R2.6.0
closed
Kathy Pink
7
2007-05-10
2007-04-27
contract16
No

When we have large number locators, all the locators are not shown in the Locator Dialog's list box. In our application we have around 2000 locators (most of them in one warehouse).
1. Create Locators (around 250) under one or across warehouses.
2. Go to the inventory move window and create a new Move document.
3. Go to Move line tab and try to create a new move line.
4. Try to select a particular locator by clicking button in the Locator component (either from or to locator).
5. In the Locator Dialog click on the combo box, and observe that not all the locators are shown in the list.

Observation : Following message come on the console.
-----------> MLocatorLookup.run: Over Max Rows - 202 [41]
That means there is a limit of the locators that could be shown in the Locator Dialog's list box.

Due to this we are facing one more wiered problem in Physical Inventory window.

1. Go to Physical Inventory window and try to create a new Inventory Count document.
2. Now click on 'Create Inventory Count List' Button.
3. In the 'Create inventory count list' dialog click on locator button in locator component.
4. Observer that the locator dialog's list box displays some of the locators (around 200) and not all.
5. Click cancel and go back to 'Create inventory count list' dialog.
6. Requery for the locators.
7. Repeat step 3 and now observe that the locator dialog's list box now displays some of the locators which could be different as shown in the step 4.

Note: This could not be reproduced in Garder World if we don't create that many locators.

There are two possible solutions :

1. Define the locator as search window.
2. Give option to select the warehouse selection first and then allow to select locator within that warehouse. But still we have around 1500 locators in one warehouse, so the first is still required.

Discussion

  • contract16
    contract16
    2007-04-27

    • priority: 5 --> 7
     
  • Kathy Pink
    Kathy Pink
    2007-04-28

    • status: open --> pending
     
  • Kathy Pink
    Kathy Pink
    2007-04-28

    Logged In: YES
    user_id=329831
    Originator: NO

    did you try defining the specific locators for each product on the locator tab of the product?

     
  • Kathy Pink
    Kathy Pink
    2007-04-28

    Logged In: YES
    user_id=329831
    Originator: NO

    *** Status set to PENDING *** If the issue solved, please CLOSE
    this request - otherwise set the status back to OPEN (we only
    check OPEN items). If there is no reaction within a week, the
    system will automatically CLOSE it. To speed up response time,
    you may want to consider a support agreement.
    ***

     
  • contract16
    contract16
    2007-05-01

    • status: pending --> open
     
  • contract16
    contract16
    2007-05-01

    Logged In: YES
    user_id=1742483
    Originator: YES

    I will try this solution by wednesday.
    But how this effect in showing the locators list?

     
  • Jorg Janke
    Jorg Janke
    2007-05-03

    • status: open --> pending
     
  • Jorg Janke
    Jorg Janke
    2007-05-03

    Logged In: YES
    user_id=87038
    Originator: NO

    I suggest that you implement 261 with Product Locator control to manage locations more effectively. Alternatively change the Reference Type to Search.

     
  • contract16
    contract16
    2007-05-10

    • status: pending --> closed
     
  • contract16
    contract16
    2007-05-10

    Logged In: YES
    user_id=1742483
    Originator: YES

    No difference found in that but Yes Search is working fine.