7 Replies Latest reply on Jun 26, 2016 11:47 PM by Johan Hedman

    Find using wrong field




      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?