Look up for a particular option.

(0) Share

Report

Posted on by Community Member

Hello Everyone,

I have created an option field 'Item Type' in 'Item Journal Line' table with few options like: Paper Roll, Ink, Plate, Chemical. Then I have taken this field in 'Item Journal' page.

Now from 'Item Journal' page if I select an 'Item Type' = Paper Roll then the look up page of 'Item No.' will only shows those values whose 'Item Type' will only be 'Paper Roll'. How could I

do this? I have no clues!

Thank You in advance.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Nareshwar Raju Vane... 5,596 on at

Like (1)

Report

Hi,

You have to set TableRelation property on the field "Item No." on Item Journal Line Table.

It should typically look like this: Item WHERE (Item Type=FIELD(Item Type))

Assumed that Item Type a Option field on Item Table.

Hope it helps.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Is Item Type field available at Item Card?

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,625 Super User 2025 Season 2 on at

Like (0)

Report

Hay Rajat,

Go to Table 37 and check the Table Relation Property of the No. Field.

If you understood this then I am sure you will achieve of your own.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Yeah Vishal you r right!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I can't do it this way Sir!

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Why?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank You everyone..The problem was resolved!

Was this reply helpful? Yes No