Discussions
Update custom field when Avg Cost changes
Hello everyone,
We are trying to figure out the best way to update the value in an Item custom field when the Avg cost or either of two other custom fields are changed. The custom field's value is based on a formula using avg cost and the other two fields. We also need this value to be available for searches. Since Avg Cost is auto calculated by NetSuite when items are received, not sure what would be best to use to trigger an update to the custom item field. Any help is appreciated.
Thanks
Karen