Look up for a particular option with an expression.

Rajat_M

Hello Everyone,

I have created an option field 'Item Type' in 'Item’ & ‘Item Journal Line’ tables with few options like: Paper Roll, Ink, Plate, Chemical. Then I have taken this field in 'Item Card' & ‘Item Journal’ pages.

Now from 'Item Journal' page if I select an 'Item Type' = Paper Roll then the look up page of 'Item No.' is showing only those values whose 'Item Type' is 'Paper Roll' . No issue with that.

Now suppose there are 3 quantities for ‘Paper Roll’ Item Type in ‘Item Journal Line’ table. Now I need to create an expression by which I can able to see only those records whose Quantity Sum will be greater than zero (>0) in ILE table. Only those records I can able to see on the Look up page of ‘Item Type’ field in ‘Item Journal’ page.

I have got stuck in this problem. Can anyone help me!

Thank You in anticipation.

RockWithNAV

I believe again you can play this with the Table Relation.