Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Look up for a particul...
Microsoft Dynamics NAV (Archived)

Look up for a particular option with an expression.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

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.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    Can you attach error screenshot here?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    Sir, another thing in the 'Entry Type' field, it will only take other options rather than 'Negative Adjmt.'. If I select the 'Negative Adjmt.' it shows an error. Sir, plz tell me how can I do this??

                                                     Regards,

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    Go to new line and see if it works. Do not try to amend the existing line.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    Sir, right now I'm facing an issue over this problem again. It only works for Item Type = 'Paper Roll'. But when I select another 'Item Type' let's say 'Plate' or 'Ink' it shows a message "The view is filtered, and the entry is outside filter'. Some actions may not work". What should I do now??

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    I think it serves my purpose.. [tag:ThankYouVishal] fr the help!!

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    Both are same dear. Item Ledger Entry -> Sum of Quantity = Item.Inventory.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    But Sir the filter will apply on the Sum of Quantity field in Item Ledger Entry not 'Inventory'.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    That's all. This would meet your requirement of Expression based filtering.

    You would only see the Item's having inventory > 0.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    Thank You Sir! And after that what should I do next??

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Look up for a particular option with an expression.

    Hi,

    Simply define the table relation in Item Journal Line > Item No. as follow. 

    1351.1.PNG

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans