Discussions
Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Explore new breakthroughs, sharpen your skills, and connect with experts who are shaping what’s next. Experience bold keynotes, interactive learning, and connections that span the global NetSuite community. Discover what's next at SuiteConnect Tour 2026.
Using the LSA Date in Transaction Search
Before the last update to the LSA bundle, we used to use the Last Sales Activity Date in a number of transaction searches. For example, we'd send follow up emails 3 weeks after a SO was fulfilled, but check the LSA Date on the customer record to make sure we hadn't already talked to that customer recently.
With the latest update the LSA is now a custom record joined to the Customer. Because of this, the field isn't available on a transaction search. I'm trying to find a way that I can still accomplish the same thing. I've tried to setup a workflow to populate a custom field on the customer record, but I can't reach into the related record on a workflow, so that doesn't seem to work. I could possibly populate it on load, with a formula, but with the Workflow I need to store that value so that isn't working either.