on 06-07-2005 3:30 AM
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.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
100 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.