Known Bug: Zero results when performing a find on a calculated field

Discussion created by sfjwatts on Jul 12, 2017
Latest reply on Jul 12, 2017 by sfjwatts

Hi All

I have come across a known bug (that was reported several years ago) that causes zero records to be found when I search on a calculated field and was wondering if anyone has a solution to the problem:

In my case I am searching for invoices with total value >0 on a specific date and customer, I know that there are 6 invoices but no invoices are found. If I restart FMS the problem is cured but it has now reoccurred for the 3rd time in 4 weeks, it is creating problems with a high profile customer that we automatically send email invoices once a day.

We are using Win 10 version of FMP/FMPA ver16 with FMS ver 15 on Mac OS