Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Skip Record in a Form
Microsoft Dynamics NAV (Archived)

Skip Record in a Form

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

Hi

  I want to display only those records in a subform which satisfy below condition. Total Amount is FlowField

ReceiptAmount - "Total amount" > 0

Thanks

*This post is locked for comments

  • Gabby Profile Picture
    Gabby 2 on at
    Skip Record in a Form
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Skip Record in a Form

    Create additional field and populate the value in that field whenever Receipt Amount is changed/validated and store the value of ReceiptAmount - TotalAmount, then you can use that field as filter for the subform.

  • Suggested answer
    4BzSoftware Profile Picture
    4BzSoftware 6,071 on at
    RE: Skip Record in a Form

    Hi jsshivalik,

    It looks like you can use Status field, is it correct?

    Otherwise, you have to create a new field, can be named "Remaining Amount" = ("Total amount" - ReceiptAmount). Update its values whenever ReceiptAmount changed. Then, filter ["Remaining Amount" > 0] on the SubForm.

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,184 on at
    RE: Skip Record in a Form

    Yes we have CurrReport.Skip in Reports but thats not possible in page. did the above solution work ?

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Skip Record in a Form

    Hi

     o.k . Thanks . Can't we write condition like this in Form - AfterGetRecord Trigger

    If Amount - Camunt > 0 then it should display line else no . In Report we use CurrReport.Skip

    Thanks

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,184 on at
    RE: Skip Record in a Form

    You can still keep the balance field in the table. On Validate of AMount and Camount,

    insert the code:

    Balance : Amount -Cmount;

    Then you can use the same SourceTableView where Balance > 0.

    Do not display this field in the subform

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Skip Record in a Form

    Hi

     I have Data like this in Table . I want to display those records only which have Amount - CAmount > 0 . Earlier i was having Balance Field and in SubForm SourceTableView i had given where Balance > 0 . Now i don't want to use Balance Field.

    Date	         Amount	     Location	Posted Date	Posted Amount	Camount	 Status
01/10/2017	3,400.00	AMB		0	0	                  Open
03/10/2017	2,100.00	AMB		0	                2,100.00  Open
04/10/2017	4,801.00	AMB		0	                4,801.00  Open
05/10/2017	8,577.00	AMB		0	0	                  Open
07/10/2017	500	        AMB		0	0	                  Open
08/10/2017	17,360.00	AMB		0	0	                  Open
03/10/2017	0	        AMB	03/10/2017	2,000.00	2,100.00	Closed
04/10/2017	0	        AMB	04/10/2017	4,801.00	4,801.00	Closed
03/10/2017	0	        AMB	05/10/2017	100	        2,100.00	Closed


    Thanks

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,184 on at
    RE: Skip Record in a Form

    Record.CALCIFIED(Total amount);

    then create a function in Subform and call it from main form by passing the field value

    CurrForm.SalesLines.FORM.Filterlinerecords(MainForm.field);

    In the function:

    Record.CALCIFIED(Total amount);

    //your code

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

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,963 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans