Filter ITMREF field in Orders

Question

Hi, 
 I need to filter the products selection list when using itemref field in the POH2 screen. The table and field [F:ITM]CCE(0) contains the products linked to the order site. I want to show only products where [F:ITM]CCE(0) = [M:POH0]POHFCY 
 Could someone point me in the right direction? 
 
 Thanks

zpmarcos · Accepted Answer

Hi Duane,

My solution is not tested, so you might want to give me feedback after your test...

Edit SPEFCY.src to something like this:

"
$ACTION

Case ACTION
When "FILTRE" : Gosub FILTRE
Endcase

Return

$FILTRE
If !clalev ([F:ITM]) : Local File ITMMASTER [F:ITM] : Endif
Filter [ITM]

If GFONCTION = "GESPOH"
CRITERE = "[F:ITM]CCE ='" +[M:POH0]POHFCY + "'"
Endif

Return
"

After compiling, please validate "OPOH" window.
I hope it works.

Best Regards

Duane Chemaly · Answer

zpmarcos you are an absolute legend! worked like a bomb. Added the SPEITM.src to the SELITM Action and used your filter. Thank You very much!

Sage X3

Filter ITMREF field in Orders

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING