Microsoft Dynamics NAV (Archived)

Skip Record in a Form

(1) Share

Report

Posted on by jsshivalik

3,099

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

I have the same question (0)

All responses (8)

Answers (0)

Gabby 2 on at

Like (0)

Report

Skip Record in a Form

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 49,206 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

RE: Skip Record in a Form

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

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

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

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report
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

Was this reply helpful? Yes No
Suggested answer

CDsilva 4,188 on at

Like (0)

Report

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

Was this reply helpful? Yes No