Find using wrong field

Discussion created by fireballprinting on Jun 26, 2016
Latest reply on Jun 26, 2016 by Johan Hedman



I'm having a strange problem. I have a script that searches for invoices with a balance >0. The script suddenly started returning invoices with balances that =0 as well. I tried manually searching for invoices >0 and had the same problem. Through trial and error it seems that instead of searching from the balance_due field, filemaker is referencing the total_grand field, and returning results based on the grand total, not the balance. This is true even if I manually search. Is there any reason this mixup would happen, and anything I can do to fix it?