Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Dynamically updating fields
I'm trying to create a dynamically updating field on a custom record (it would need to act similar to the {actualtime} field on the job record that dynamically updates as time is allocated to a job).
The custom record is a "Publication Record" and the purpose of the custom field is to keep an up-to-date total of advertising sales relating to that particular publication.
The total would need to come from the 'sum' of line item transactions from Quotes / Bookings.
From what I can gather the best way to try and achieve this is to use a CASE statement within the custom field formula, however I'm not sure if it's even possible to access transaction records from the Publication record.
0