Importing data and updateing calculations

joftech · Post by **joftech** » Sun Feb 18, 2007 10:10 am

Hi Support,

I have a dental system that I am importing invoices and line items into.

Is there an easy way to get the invoice totals and line totals to auto calculate when the data is imported. At the moment I have to go to each invoice (over 2000 of them) and hit save to get the calculations to happen.

Best REgards

Alan

aware_support2 · Post by **aware_support2** » Sun Feb 18, 2007 11:05 am

Hi Alan,

Tick the Validate Data checkbox when importing object data. This will automatically execute rules for each imported object and affected related objects. Keep in mind that the import may take longer because of this.

joftech · Post by **joftech** » Sun Feb 18, 2007 1:52 pm

Hi Support,

Thank You

That worked well.

Alan

Hubertus · Post by **Hubertus** » Mon Feb 19, 2007 8:11 pm

You could also take a look at http://www.hiden.org/awareim/tips-n-tri ... sql-server where I've described a similar scenario.