Is it possible to search for transactions that use...
# generald
dcrsmith
05/22/2019, 5:59 PMIs it possible to search for transactions that use "custom" SHIP TO addresses?
t
ted_p
05/22/2019, 6:09 PMin the past, i've had to make a saved search and export to csv and then dig from there. 😕
d
dcrsmith
05/22/2019, 6:10 PMThanks. That will not work in this case. However, it is tied with a script so I might have to do something that way.
m
Michael Pope
05/22/2019, 6:31 PMYou'd need to do some scripting to do that
Michael Pope
05/22/2019, 6:31 PM1) Do a search for all addresses for all customers (and get the address internal ids)
Michael Pope
05/22/2019, 6:31 PM2) Compare that to the Shipping and Billing Address internal id
Michael Pope
05/22/2019, 6:31 PMfor each transaction
Michael Pope
05/22/2019, 6:31 PMThe ones that aren't there are custom
d
dcrsmith
05/22/2019, 6:33 PMThanks. I'm trying to avoid that if possible.
m
Michael Pope
05/22/2019, 6:33 PMYeah =/
Michael Pope
05/22/2019, 6:33 PMI tried seeing if there was a way... couldn't find it myself... sorry
Michael Pope
05/22/2019, 6:34 PMThe problem is you need a double joing
Michael Pope
05/22/2019, 6:34 PMjoin*
Michael Pope
05/22/2019, 6:34 PMand Netsuite doesn't have those
Michael Pope
05/22/2019, 6:34 PMAddress join Customer compared to Address join Transaction join Customer
Michael Pope
05/22/2019, 6:36 PMHold on... might be able to get it working...
d
dcrsmith
05/22/2019, 6:38 PMThat would be great! I was trying to use the Workbooks to do it but still having issues there too.
m
Michael Pope
05/22/2019, 6:39 PMSo I think I can get it so where you can get everything all in one search... however... you can't filter out the bad ones... you still need to run a script (because Netsuite only uses Outer joins). But let me see what I can do.
👍 1
Michael Pope
05/22/2019, 6:42 PMSo try this:
Michael Pope
05/22/2019, 6:43 PMEntity Search
Michael Pope
05/22/2019, 6:43 PMIn Results
Michael Pope
05/22/2019, 6:43 PMTransaction Fields Billing Address
Michael Pope
05/22/2019, 6:43 PMTransaction Fields Shipping Address
Michael Pope
05/22/2019, 6:43 PMAddress Fields Address
Michael Pope
05/22/2019, 6:43 PMThat should give you every combination
Michael Pope
05/22/2019, 6:44 PMbut that doesn't just highlight the custom ones so that probably doesn't work =/
Michael Pope
05/22/2019, 6:44 PMHmmm
Michael Pope
05/22/2019, 6:45 PMYeah, so I'm going to say not possible without scripting probably
Michael Pope
05/22/2019, 6:46 PMSorry about that
Michael Pope
05/22/2019, 6:46 PMI'd do the method i mentioned earlier, two separate searches and then a comparison
Michael Pope
05/22/2019, 6:46 PMIt'll probably be the most performant
d
dcrsmith
05/22/2019, 6:46 PMThanks. It would be a lot easier if the custom address showed up on the entity record somewhere
m
Michael Pope
05/22/2019, 6:46 PMYeah, with a flag or something
Michael Pope
05/22/2019, 6:47 PMBest of Luck with it
3 Views