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
Updating calculation after Importing records
Re: Updating calculation after Importing records
UPDATE Action
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
Re: Updating calculation after Importing records
Hi Jaymer - many thanks for your pointer that's sorted it out nicely (so easy when you know how).
Cheers Paul
Cheers Paul
Re: Updating calculation after Importing records
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
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
Bob
-
- Posts: 1460
- Joined: Tue Jan 24, 2017 5:51 am
- Location: 'Stralya
Re: Updating calculation after Importing records
IMPORT action defined hereBobK wrote: ↑Fri Nov 04, 2022 12:47 pm 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