<@UAPHBR6TS> i set up line uniquekey as the field ...
# generalo
Ogabeg
05/08/2019, 7:30 PM@Gregory Jones i set up line uniquekey as the field but anyway to automate it (i.e..inline)
g
Gregory Jones
05/08/2019, 7:33 PMNot sure i understand what you mean by automate?
o
Ogabeg
05/08/2019, 7:57 PMso that everytime you add a new line item the field goes from 1..2...3
b
battk
05/08/2019, 8:01 PMAnd would the next transaction go 1 2 3
battk
05/08/2019, 8:02 PMOr 4 5 6
o
Ogabeg
05/08/2019, 8:03 PMgoal is to have each line number as unique so if you delete say number 3 it would be 1..2..4...5..6
Ogabeg
05/08/2019, 8:03 PMkind of like an internal ID but for each line item
b
battk
05/08/2019, 8:04 PMSame question
battk
05/08/2019, 8:04 PMWould the next transaction start over
battk
05/08/2019, 8:04 PMOr continue the sequence
o
Ogabeg
05/08/2019, 8:04 PMstart over
g
Gregory Jones
05/08/2019, 8:04 PM@Ogabeg {lineid} does that
💯 1
o
Ogabeg
05/08/2019, 8:05 PMhmm ill check that out
b
battk
05/08/2019, 8:06 PM@Gregory Jones is correct, netsuite already haa a field that does that
o
Ogabeg
05/09/2019, 3:50 PMi see linesequencenumber but no lineid
g
Gregory Jones
05/09/2019, 3:56 PMWhere are you looking? Saved Search?
o
Ogabeg
05/09/2019, 3:57 PManyway to add it directly to a SO form
g
Gregory Jones
05/09/2019, 4:06 PMNot sure. I've only ever needed to see it via transaction saved search.
Gregory Jones
05/09/2019, 4:07 PMIf you can't see it when editing a custom transaction line field, then my guess would be no, at least not without scripting.
o
Ogabeg
05/09/2019, 4:08 PMahh thats what i was assuming, thought perhaps there was a non scripting route
g
Gregory Jones
05/09/2019, 4:09 PMYeah, I wasn't sure about this one in particular, but seems to be the case.
o
Ogabeg
05/09/2019, 4:11 PMyeah it seems to only allow line sequence number on the form but not line ID
b
battk
05/09/2019, 4:24 PM{line}
g
Gregory Jones
05/09/2019, 4:30 PMGood call @battk!
Gregory Jones
05/09/2019, 4:30 PMthat works.
o
Ogabeg
05/09/2019, 4:30 PMgive me and error, did you just put {line} in the formula box
b
battk
05/09/2019, 4:30 PMyes
battk
05/09/2019, 4:31 PMwhat type of field do you have
g
Gregory Jones
05/09/2019, 4:32 PM@Ogabeg i set mine as free-form text, unchecked store value, display type: disabled, and added {line} in formula box
o
Ogabeg
05/09/2019, 4:39 PMi keep getting ERROR: Field "line" not found
b
battk
05/09/2019, 4:39 PMwhich transaction?
o
Ogabeg
05/09/2019, 4:39 PMsales order
b
battk
05/09/2019, 4:40 PMcreate or edit
o
Ogabeg
05/09/2019, 4:42 PMcreate
b
battk
05/09/2019, 4:43 PMthere is no line when the tranaction is created. Line is generated after it is saved
o
Ogabeg
05/09/2019, 4:43 PMahh okay let me try
Ogabeg
05/09/2019, 4:50 PMNICE!!! it works...gloriously done thanks @Gregory Jones and @battk
party furby 1
Ogabeg
05/09/2019, 4:52 PMonly down side is that it shows an error when entering data for the SO, but thats a minor
3 Views