Importing data and updateing calculations

joftech

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

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

Hi Support,

Thank You

That worked well.

Alan

Hubertus

You could also take a look at http://www.hiden.org/awareim/tips-n-tricks/keeping-awareim-data-in-sync-with-data-from-a-ms-sql-server where I've described a similar scenario.