Skip to Content
author's profile photo Former Member
Former Member

Choose from list and Warehouse

Hi all,

Our customer have a lot of warehouse, for example when they do a quotation or sales order, when the "Item No." Field is tabbed, then the "choose from list" appears with all items and their stock levels as total for ALL warehouse.(that show almost 1000 lines of items from all warehouses)Thats mean they have to scroll down to search for the item.

Is there any way i can do this: when the "Item No." field is tabbed, "select warehouse" first then the "choose from list" appears showing the items in that particullar warehouse only.

Thanks in advance,

Bruce.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 07, 2005 at 07:27 AM

    Hi Bruce!

    I guess you should write a query for Formatted Search with arguments.

    It would be the following:

    SELECT

    T0.ItemCode,

    T0.ItemName,

    T1.OnHand

    FROM

    OITM T0

    LEFT JOIN <b>OWHS</b> T1 ON

    T1.ItemCode = T0.ItemCode

    WHERE

    T1.WhsCode LIKE N'[%0]%'

    I bold here OWHS-table because i forget tablename for ItemsOnWH-master data..

    Just replace it with property tablename, save query, link it to ItemCode column, press Sh+F2, enter needed WHCode and enjoy!

    😊

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.