i have a lookup in that i need to display InvoiceId, InvoiceAccount, Voucher, AmountMST. i did that and it is working good. now the issue is i need to show the all records which is unsettle only. in AmountMST field having all data containing settle and unsettle also. now i need to filter only unsettle records. how can i do that.
i saw that method in that they r joining wo tables. but in our scenario no need to go for other table. all fields are in the same table only. but in AmountMST field containing all settled and unsettled transaction amount. from that field we should fetch only unsettled transaction amounts. here all fields is in CustTrans table. i added the range on AmountMST field. basing on that field all other fields are showing. but now i need to filter only unsettled transaction amounts and corresponding other fields in lookup.