AnsweredAssumed Answered

Zeros shown in results when searching for > X

Question asked by velistar on Nov 21, 2015
Latest reply on Nov 21, 2015 by Mike_Mitchell

Hi all,


I got a call from a prospective client today and whilst speaking about different things on FM he asked me something which really surprised me.


He has an FM solution for customers, invoicing, etc. and the solution is on FM 11. When he makes a Find request in the Customer Balance to get all the customers that owe him more than an amount X, the correct results show up but also a whole lot of customers with Balances of zero (0). Also he told me that this issue cropped up around a year ago.


I know its a bit vague and I still haven't got a look at the database just yet but I was wondering if anyone has ever come across something like this to point me in the correct direction.