I have about 280k transactions which need to be edited/saved in order to trigger a script that calculates/populates two line-level fields. Sending CSV imports with the Internal ID's takes too long. Does anyone know of a way to trigger edit/save of a transaction, based on results of a Saved Search?

How long does it take when you use CSV import?

It'll probably be quicker to calculate externally, then CSV in the updated values with scripting turned off. Or use a map/reduce with large concurrency to do the save. How many suitecloud+ licenses do you have?

If your saved search could correctly find the 280k transactions You could consider testing these solutions: 1. Mass Update Script with a fake field (to trigger the change 2. Custom mass update with a load/save script In these 2 cases, make sure the fields that are changing has an impact and will show up on the UE script context.newRecord. Otherwise, a M/R script and in the getInputData you could have the saved search, and the map stage to execute whatever you need. If you can break the 280k based on dates, I'd break it to batches, or have a condition that makes sure the number of records that need to run decreases as part of the criterea

@Justin usually a Custom Mass Update will trigger scripts to run. Use the same criteria of your saved search to build a Custom Mass Update then have it just check a custom checkbox or something

@NS Expert It depends on the transaction type and number or lines, but anywhere between 15-20k records a day. The problem is that I'm clogging the feed for other uses.

Have a look at integrator.io, you could do this with their free tier