1 Reply Latest reply on Jun 27, 2011 2:34 PM by TSGal

    Inconsistent Calculation in Preview Mode



      Inconsistent Calculation in Preview Mode


      FileMaker Pro


      Ver. 11.0v3

      Operating system version

      Windows XP Professional

      Description of the issue

      I have tables: Billing, Invoices, Equipment, and Contacts

      Billing Layout is the Main Menu.
      Portal to Invoice
      Invoice Equipment and costs brought to invoice from Equipment
      Billing gets Contact data for the main layout thru lookup.

      The Calculations on the Main layout are 100% superb.

      I have another layout on the same table as Billing, called Invoice. It shows the same details as the main menu but in a printable invoice design sheet, instead of a tabular menu input form.

      I have a Preview button that runs this script:
        Create New Window
        Omit Record
        Show all Omitted
        go to Layout Invoices (Uses Billing same as Main layout)
        Enter Preview mode (pause)

      NOT every time, but irregular occurrence.. 1 line item in the portal will calculate on the Total for the Forms window, but when entering the preview screen, it will be missing a single line form the calculation. Might be first, middle, last.. never the same. Not the same equipment, nor the same cost. Still haven't found a consistent reason. Still testing.

      If you print the preview it prints the bad figure, and the preview shows it right?

      If I have her close preview and change record and back, it is 100% correct and never has the flaw again.

      The Only regular constant is that it happens on the initial entry, while still on that invoice and you hit preview.. although it doesnt happen to every invoice or preview...

      Is there a way to force a Record refresh on the preview or just before preview to eliminate the issue?

      Steps to reproduce the problem

      Create a new record for the Main 'Billing' layout.
      create equipment line items in the portal
      hit preview
      Observe if the calculations are correct or fail.

      Doesn't always fail.

      Expected result

      Expect it to pass all the time, but inconsistent calculation drop of random line item.


      Leave preview, and change the record on main menu and return to the record in question. All calculations working fine.