Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Filter Data of Purchas...
Microsoft Dynamics NAV (Archived)

Filter Data of Purchase Lines

(0) ShareShare
ReportReport
Posted on by jsshivalik 3,027

Hi

  How to filter data of Purchase Lines and display using Integer DataSource

Thanks

*This post is locked for comments

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Filter Data of Purchase Lines

    Agreed with Marcell's answer. Adding to that you can refer report 406 in Dynamics NAV as an example.

  • Suggested answer
    Marcellus Profile Picture
    Marcellus 2,735 on at
    RE: Filter Data of Purchase Lines

    Hi Jsshivalik,

    1. Add PurchaseLine as a global record variable.
    2. Filter PurchaseLine as you wish
    3. Filter the Integer table to the number of records you found using PurchaseLine.COUNT in the OnPreDataItem of your loop.
    4. in the OnAfterGetRecord of your loop find the PurchaseLines if it's first iteration and step through the PurchaseLines after that.

    I created an example for you:

    5305.Dataset.png

    PurchaseLineLoop - OnPreDataItem()
PurchaseLine.SETRANGE("Document Type", "Purchase Header"."Document Type");
PurchaseLine.SETRANGE("Document No.", "Purchase Header"."No.");
SETRANGE(Number, 1, PurchaseLine.COUNT);

PurchaseLineLoop - OnAfterGetRecord()
IF Number = 1 THEN
  PurchaseLine.FINDSET
ELSE
  PurchaseLine.NEXT;

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