8 Replies Latest reply on Oct 27, 2016 7:48 AM by philmodjunk

    Auto Calculated Fields

    mike.goss@citta.co.uk

      When are they calculated?

       

      I have an Invoice Database where there is a Goods Value, Discount %, Discounted Amount, Discounted Goods Value, Carriage, Net Value, Vat Rate, Vat Amount and Gross Value. Many of these fields are set up to auto-calculate from the others. For instance Net Value is Discounted Goods Value + Carriage, etc.

      Now I have seen situations where the non-calculated fields have data in them, but he calculated fields dependent upon them don't. Only to find the calculated fields are set correctly when I look at them later.

       

      When, precisely, are the values of calculated fields, calculated?

       

      If I can't get to the bottom of this I am going to have redefine the fields and add script steps to calculate them so I can be sure they are set when they need to be.

       

      Mike