I have to isolate some records that have to be updated by a server side script.
In my MRP solution I need to find all records that the calculation field "c_number_on_hand"(an unstored calculation field) is different from "number_on_hand" (a number field, updated periodically, to be shown in layouts and lists where the calculation update of c_number_on_hand would take to long).
Then I write the calculation value into "number_on_hand" for these records thereby updating the number field.
I would like to isolate these records without creating a extra field (c_number_on_hand<>number_on_hand) and search for that, without creating a TO where one field unequals the other.
How is that done?