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
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.
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.
Yes we have CurrReport.Skip in Reports but thats not possible in page. did the above solution work ?
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
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
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
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,151 Super User 2024 Season 2
Martin Dráb 229,963 Most Valuable Professional
nmaenpaa 101,156