https://netsuiteprofessionals.com logo
Title
m

mattb

02/14/2019, 3:44 AM
has anyone out there got an ideas on a saved transaction search that will detect whether the same item has been added to a sales order twice? (so I can alert via email and then to slack that there’s a possible entry error)
a

ABJ

02/14/2019, 3:54 AM
Group the transaction id, use item count summary in results. Then use the summary in the criteria, show only if the count is more than 2.
m

mattb

02/14/2019, 6:26 AM
thank you! what if there are other items on the transaction?
e

ERP Experts

02/14/2019, 1:34 PM
it wont matter as they will have a count of 1.
m

mattb

02/19/2019, 10:22 AM
thank you both!
👍 1