howto I filter warehouse by org of selected order in process parameter panel?

19 views
Skip to first unread message

Hiep Lq

unread,
Feb 8, 2014, 5:46:09 AM2/8/14
to idem...@googlegroups.com

I want run process create production from "order line" with parameter as below:
1. order, 2. order line, 3. warehouse, 4. locator

process is run by click "window toolbar button" at "order line" window and production window

(*) at order window. dialog input parameter is show as below
    1. order get from Env => ok, 
        has order info at Env => make order input read-only
    2. order line get from Env => ok
        has order line info at Env => make order line input read-only
    3. warehouse filter by org => ok
    4. locator filter by warehouse => ok

(*) at production window this dialog show as below
    1. order show list for use select => ok
      after user select a order, value is set to Env, key is same as order line window => order input switch to read-only => NG
    2. order line filter by order => ok
     after user select a order, value is set to Env, key is same as order line window => order input switch to read-only => NG
   3. I want warehouse is filter by org of selected order. I try validate code with "M_Warehouse.AD_Org_ID=@C_Order_ID.AD_Org_ID@" but it not work

howto I make "warehouse is filter by org of selected order"?

Hiep Lq

unread,
Feb 8, 2014, 7:33:31 AM2/8/14
to idem...@googlegroups.com

can filter with validate code
M_Warehouse.AD_Org_ID IN (SELECT C_Order.AD_Org_ID FROM C_Order WHERE C_Order.C_Order_ID = @C_Order_ID@)

with "order input switch to read-only => NG". just don't switch to read-only
Reply all
Reply to author
Forward
0 new messages