Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Condition not working

Posted on by 3,027

Hi

 I have the below code but filter is not wtoking. ItemLine is Record DataType of Item.


Requistion Line - OnPreDataItem()


  ItemLine.RESET;
  ItemLine.SETRANGE(ItemLine."No.","Requistion Line"."No.");
  IF ItemLine.FINDFIRST THEN BEGIN
    IF ItemLine."Color" <> ColorType THEN
      CurrReport.SKIP
  END;

Thanks

*This post is locked for comments

  • ManishS Profile Picture
    ManishS 6,578 on at
    RE: Condition not working

    Also set the DataItemTableView of requisition line to filter records on type item.

  • Verified answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Condition not working

    You need to write your code on OnAfterGetRecord Trigger ...

  • Suggested answer
    Mohana Yadav Profile Picture
    Mohana Yadav 59,139 Super User 2024 Season 2 on at
    RE: Condition not working

    did you try moving it to OnAfterGetrecord trigger?

  • Verified answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Condition not working

    On PreDataItem, you will not have the value, you need to add that value OnAfterGetRecord Trigger.

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans