Choose from list and Warehouse

[Former Member]

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.

[AlexGrebennikov · Accepted solution]

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!