Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Add Date filter in table
Microsoft Dynamics NAV (Archived)

Add Date filter in table

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

Hello

In table Customer (18) i have flowfield  (traite à l'escompte) based on table Payment Line (10866) with this calcformula :

<< Sum("Payment Line"."Amount (LCY)" WHERE (Account Type=FILTER(Customer),Account No.=FIELD(No.),Payment class="FILTER"(ENC-EFF),Copied To No.=FILTER(''),Status No.=FILTER(50000|70000)))>>

i want to add a new filter on the field Due Date (Date d'echéance) in this Flowfield with the value ">work date (or Today)" ,

like this :       " field: DueDate ;Type: Filter ; Value : >workdate "

When i do it and i want open a customer card an error message appear : the value 280716D can not be evaluated by date type.

Can any one help me and Think you

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add Date filter in table

    Hello

    no Alexander the due date in payment line is normal field and his dont exist as field in payment line header

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add Date filter in table

    Hello

    How ,  can you give me more information how do it

  • Ashwini Tripathi Profile Picture
    Ashwini Tripathi 4,624 on at
    RE: Add Date filter in table

    Use Flowfilter as you use for calculating NetChange or other fields in standard Navision.

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: Add Date filter in table

    Hi froyed,

    I went through your attachment...
    Why don't you use Flowfilter...

    FlowFilter is a also a type of Fieldclass property  in Dynamics Nav table's field, which is use to set ranges on the calculations that are calculated in FlowFields. Eg if the FlowField contains the total inventory of an item, then you can use a FlowFilter to see the total for a period of time slot like month, day etc. 

  • Suggested answer
    Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Add Date filter in table

    Can it be the case that the DueDate field in the Payment Line table is itself a flow field by document number from the Payment header table? I do not have quick access to French localization, but can you kindly check the properties of the DueDate field?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add Date filter in table

    hello rabindra Sah

    think you for your suggestion , can you please download this document which includes all print screen for the two table and the formula and the flowfield..

    www.mediafire.com/.../To_Alexander.docx

    think you very much man , please help me

  • Suggested answer
    Rabin Profile Picture
    Rabin 2,976 on at
    RE: Add Date filter in table

    Hi Froyed,

    This error occurs :a flowfield is part of the query column list, this is not supported:, when you are using a field which is a flowfield itself  in flowfield formula calculation... Try checking the Formula and the field used in it and eliminate the flowfield...

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add Date filter in table

    hello

    yes we work with french localization but i don't understand what you mean how due date orginized

    i'm sure i do not create a flowfield from other flowfield

    i will send you print screen

    http://www.mediafire.com/download/mmm4x4isenyct63/To_Alexander.docx

    Think you very much for you attention

  • Alexander Ermakov Profile Picture
    Alexander Ermakov 28,094 on at
    RE: Add Date filter in table

    It looks like you are now trying to create a flowfield from another flowfield... How is Due Date field organized? Are you working with French localization?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Add Date filter in table

    think you Alexander

    i try it but i have an error message "a flowfield is part of the query column list, this is not supported"

    thinks

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