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
Thank You everyone..The problem was resolved!
Why?
I can't do it this way Sir!
Yeah Vishal you r right!
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.
Is Item Type field available at Item Card?
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.
Share
Report
All responses (
Answers (
6,749
