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.
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Stay in the Know
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Be sure you're subscribed to NetSuite communication to stay in the know about monthly happenings, updates and announcements. Subscribe
Like in a saved search formula
Ok so here is what im trying to do and wondering if im going down the right path.
I have a report that pulls in a list of all transactions that has a line item that contains the name "TR-APT-" or "TR-SS-". Which works great gives me 16 transaction numbers but should only have 12
So there are 4 transactions that have more than just either a TR-APT or TR-SS item attached and i would like only to see those that have just either item.
I am trying to use DECODE to see if the number of items with a TR-APT or TR-SS matches the number of total items in the transaction. I am looking at the correct function to use or am i way off.
0