I'm looking at a transaction search here that uses...
# suitescriptc
creece
02/14/2020, 4:06 PMI'm looking at a transaction search here that uses customerMain as a search join and its failing in some accounts but not all. customer is also a valid search join and thats what the failing accounts appear to want. Why would 1 account work with customerMain and one only with customer? is this a bug or am I just going crazy today?
j
jarens
02/14/2020, 4:09 PMIs there a difference where the customer is a company vs an individual?
c
creece
02/14/2020, 4:18 PMcustomers in multiple accounts are of type "Customer" so there does not appear to be a difference
m
mattdahse
02/14/2020, 4:47 PMWhat types of transactions in this search?
c
creece
02/14/2020, 6:20 PMstraight up invoices
m
mattdahse
02/14/2020, 7:23 PMYou’re searching in script @creece and for whatever reason, you can’t join through entity?
c
creece
02/14/2020, 7:27 PMyeah there's an existing search and it uses customermain.entityid and it bombs out w/ customermain... in the accounts it works in customer (main) is available in a search filter criteria but in the accounts its messing up in, customer (main) is not available and just customer (fields) is available
creece
02/14/2020, 7:27 PMnot sure why the 2 accounts would be different when its the exact same bundle.. it smells like a ns bug but there may just be a setting somewhere
creece
02/14/2020, 7:33 PMim admin in both scenarios and runs as admin
creece
02/14/2020, 7:33 PMso its not permissions
m
mattdahse
02/14/2020, 10:13 PMIt’s clearly a feature that needs to be enabled.
mattdahse
02/14/2020, 10:19 PMAh…
mattdahse
02/14/2020, 10:19 PMAnswer id 81209
mattdahse
02/14/2020, 10:19 PMIf projects are enabled, you need customer main
mattdahse
02/14/2020, 10:21 PMYou can use
N/runtime.isFeatureInEffectc
creece
02/14/2020, 10:22 PMif only it was in 2.0 lol thanks man i'll take a look at this real quick
creece
02/14/2020, 10:25 PM+1million internet points to you...i searched all over suiteanswers i swear you gotta get the exact phrase or it just doesn't give you what you want
m
mattdahse
02/14/2020, 10:25 PMYeah, I’ve been trying different things throughout the day as I had time. Finally got lucky.
c
creece
02/14/2020, 10:27 PMdef appreciate it.. that should answer that one.. .i knew it was something simple
m
mattdahse
02/14/2020, 10:32 PMNo problem. I love getting random puzzles fed to me throughout the day. It’s why I love my job.
c
creece
02/14/2020, 10:54 PMdo you know what you searched to find that
m
mattdahse
02/14/2020, 10:54 PM“customer (main) enable feature”
💯 1