2 Replies Latest reply on Feb 28, 2015 10:23 AM by robyne

    Aging report error - FIND does not work.

    robyne

      Title

      Aging report error - FIND does not work.

      Post

      I have been running this aging report for several years, with no problems.  Suddenly, I can no longer find the correct data set.  Any thoughts about why?  Am using FM12 with Mac OS 10.7 & 10.8.    See details below.  I can no longer do a correct Find in my Current Balance Field.  If I put in >0, I find items that are zero AND that are empty AND that are greater than zero. 

      Script: 

      Go to layout [Aging Dialog]

      Enter Find Mode [restore, pause]

        Find mode Invoices::current balance > 0  AND  invoice::current balance < 0

      Perform Find

      Then the script sorts & sends you to the proper layout.

       

      Current Balance is defined as a calc field:  INV Amount Due  + late fee - Payments- Credit-Write off - commissions

      **Payments is a calc field that pulls the "summary of all payments" from the payments table.  I am assuming the problem lies here but I don't understand why it's worked all this time and now is failing

       

      Thanks.

        • 1. Re: Aging report error - FIND does not work.
          philmodjunk

          First, try performing this find manually using the same criteria as your script. If that works, your script may be damaged and you may want to replace that script with a new one. (Or just replace the entire file with a recent back up, or a backed up clone where you import all your data from your current copy.)

          If your manual find also fails, I suggest that you recover a copy of your file and test the recovered copy even if recover does not discover any problems. It's possible that an index has become corrupted and Recover rebuilds all indexes without actually inspecting them for problems.

          If the recovered copy works. Recover the original file again but use only these advanced recover options:

          Copy File Blocks "As Is"
          Rebuild Indexes [Now]

          BTW, a simpler way to find all invoices where the current balance is not zero is to set up an omit find request that omits all invoices where the value of that field is zero.

          • 2. Re: Aging report error - FIND does not work.
            robyne

            I have tried the manual find and it does fail so I'll try the recover.  many thanks!