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)

Suggested answer

CDsilva 4,188 on at

Like (0)

Report

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
jsshivalik 3,099 on at

Like (0)

Report
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

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

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

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

Was this reply helpful? Yes No
Suggested answer

4BzSoftware 6,073 on at

Like (0)

Report

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

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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
Gabby 2 on at

Like (0)

Report

Was this reply helpful? Yes No