Forum Discussion

SBGoh's avatar
SBGoh
Icon for Helper I rankHelper I
3 years ago

How to get filtered lookup table?

Hi,   I want to get 2 tables below and they are link by SO #. I want to get the CS No. with the highest POS # where Code = 'ZC'. I am trying to use lookup table but seems not working. Can anyone a...
Need Help
SBGoh's avatar
SBGoh
Icon for Helper I rankHelper I
3 years ago

Hi, I have a Sales Order with SO # = 1900 with a list of 3 partners records. (The 2 tables are link by SO #).

The Code = 'ZC' refers to CS executive and there are 2 CS. I only want to display 1 CS record with highest POS #. In this case is the blue highlighed record with Code = 'ZC' and POS # = 0011 and CS No. = 2244.

 

Partner table

SO #POS #CodeCS No.
19000000VE1234
19000011ZC2244
19000000ZC3355

 

Sales Order table

SO #POS #Material
19000011PartNum 1
19000022PartNum 2
danextian's avatar
danextian
Icon for Super User rankSuper User
3 years ago

Please check the formulas i inititally provided. Either one should work.