Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Filter question

Posted on by Microsoft Employee

At my work we use Nav for doing sales. Everyday I have to filter the open sales orders by <the next days date. I am hoping to create a shortcut that somehow changes the date to the next day. So everyday when I click on the shortcut it will only show me open sales orders dated for <the next day. Not sure if it is possible but it would sure help out a lot.

*This post is locked for comments

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Filter question

    Are you use using Classic Client or Roled Tailored Client?

    I think NAV Roled Tailored Client 2009 has the feature. Otherwise, you should have your NAV Supplier customize for you.

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,184 on at
    RE: Filter question

    Hi,

    In tge page 9305, you can code as following on open page trigger

    OnOpenPage()

    IF UserMgt.GetSalesFilter <> '' THEN BEGIN

     FILTERGROUP(2);

     SETRANGE("Responsibility Center",UserMgt.GetSalesFilter);

     FILTERGROUP(0);

    END;

    //SETRANGE("Date Filter",0D,WORKDATE - 1); //commented

    //Chris code added **START*

    SETRANGE(Status,Status::Open);

    SETRANGE("Date Filter",CALCDATE('<1D>',TODAY));

    //Chris code added **END*

    JobQueueActive := SalesSetup.JobQueueActive;

    CRMIntegrationEnabled := CRMIntegrationManagement.IsCRMIntegrationEnabled;

    IsOfficeAddin := OfficeMgt.IsAvailable;

    CopySellToCustomerFilter;

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans