Hi all,
My saved search right now looks for docum...
# generalk
Ken
12/20/2022, 9:48 PMHi all,
My saved search right now looks for document Number “Equal to” 1900, but it will show result of 19000, 21900, etc.. it will not search of only specifically 1900.
How can I fix this to only find for 1900 specifically
b
battk
12/20/2022, 9:54 PMthis doesnt sound right
battk
12/20/2022, 9:54 PMinternal id is not the same as document number
k
Ken
12/20/2022, 9:55 PMI’m trying to use Order # of a sales order to get the internal Id for a sales order
Ken
12/20/2022, 9:58 PMI tried document number equal to my order # but it shows result of sales order contain my order #
Ken
12/20/2022, 9:59 PM@battk What would be the proper way to get internal Id from an Order# for sales order?
Ken
12/20/2022, 10:01 PMMy saved search right now looks for document Number 1900, but it will show result of 19000, 21900, etc.. it will not search of only specifically 1900
b
battk
12/20/2022, 10:04 PMin general its search the document number/id for your id
battk
12/20/2022, 10:04 PMmake sure to use the is filter
battk
12/20/2022, 10:04 PMdocument number by itself works for newer accounts
k
Ken
12/20/2022, 10:05 PMI used Document Number / Id and “is” filter but still shows other results
b
battk
12/20/2022, 10:05 PMbut eventually fails for older accounts, document number/id isnt actually unique
battk
12/20/2022, 10:05 PMwhat does your search look like
k
Ken
12/20/2022, 10:05 PMmessage has been deleted
b
battk
12/20/2022, 10:07 PMwhat do the results look like
k
Ken
12/20/2022, 10:13 PMmessage has been deleted
Ken
12/20/2022, 10:15 PMit shows any number that contains 1926
b
battk
12/20/2022, 10:25 PMthe filter that you are working actually does some conversion when its a number
battk
12/20/2022, 10:26 PMmostly so that it works with the suffixes and prefixes
k
Ken
12/20/2022, 10:27 PMYou are right, i made a sales order #319261 and it does not show
b
battk
12/20/2022, 10:27 PMmy guess is that your document numbers have actually have been set to allow override
battk
12/20/2022, 10:27 PMand that its supposed to normally have a prefix
battk
12/20/2022, 10:29 PMand netsuite is using that logic that allows searching for the number of the document number without that prefix
battk
12/20/2022, 10:30 PMwhich doesnt quite work with your document numbers since they dont have prefixes
k
Ken
12/20/2022, 10:32 PMInteresting. Does that mean I need A1920 and B21920
Ken
12/20/2022, 10:32 PM?
b
battk
12/20/2022, 10:33 PMyou can try it out, but if these are being generated outside of netsuite, its best to have a custom field to put the id in
battk
12/20/2022, 10:33 PMand use that instead
k
Ken
12/20/2022, 10:44 PMAh, would memo work? @battk
b
battk
12/20/2022, 10:46 PMmaybe, but i wouldnt reuse a native field for this
2 Views