Updating calculation after Importing records

poshaccy

Hi - I have a BO that looks after the stock of tyres within a garage. Within the Stock BO there are many attributes such as tyre size, load rating, performance rating etc, etc. it also has details of Purchase prices and current stock levels.

I can import and update (via an import) for the static details such as tyre size, load rating and price, however, any attributes that have rules attached (i.e. calculations used to for the Sale Price etc) are not updated when the Import is carried out, so I then have to go through each individual record and SAVE it - this is a problem when I have +500 records to update.

Is there a way to update the rules of each record within the BO after records have been Imported? OR a bulk update that actually SAVES all the records and performs an update of all calculations - if that makes sense.

Many thanks
Paul

Jaymer

UPDATE Action

poshaccy

Hi Jaymer - many thanks for your pointer that's sorted it out nicely (so easy when you know how).

Cheers Paul

BobK

You can use Validation on the import. This will cause the BO rules to execute.

If you are using the IMPORT action in a rule, add
WITH VALIDATION
to your rule.

if you are using the Import menu option, select the Validate option.

See the User Guide for more details

PointsWell

BobK wrote
You can use Validation on the import. This will cause the BO rules to execute.

If you are using the IMPORT action in a rule, add
WITH VALIDATION
to your rule.

if you are using the Import menu option, select the Validate option.

See the User Guide for more details

IMPORT action defined here