I've done something like that with a custom record...
# manufacturing
k
I've done something like that with a custom record before - it was painful and I wouldn't endeavor to repeat the process....
s
I had a feeling.. it’s even harder when building multiple quantities.. Nothing in NetSuite allows you to map a specific serial to a specific finished good.
k
Essentially what it was was a custom record that associated serial number to another serial number.
s
yep, and then that record has to be referenced as a basis for any transaction search.
k
granted - that was a half solution - and we had to do something to associate that custom record into the transaction in a multi-select field
s
I was thinking of creating a custom field on the item number record to store the finished good serial..
k
I wouldn't suggest doing that...
primarily because you can't join to the serial number while searching transactions
so it's a black box.
It has the information, but you can't utilize it.
s
via inventory detail, you can, if I recall.
anyhow, it’s a mess..
I had considered the custom record too..
The other option would be to put the finished good serials in a body field on each of the component builds.. which would source the transactions.. but you still wouldn’t know which component serial went with which finished good serial..
The option of building one at a time is also not an option.
k
Right - which is why we wound up with a custom record for doing that
s
did they have to map them?
k
The users did - yes.
s
seems the only person who could do that is the person doing the build..
k
However, I imagine you could write a script such that it told you which serial numbers to use instead of the other way around
s
yea, that seems like an added step/nightmare..
yea, jim, just go find serial number XXX323234-R2340FF63 in that bin over there.
k
i.e. for assembly item xyz - serial number Y - then use components serial numbers, a, b, c.
well, Not sure how else you'd get that info at the level you need
either the user has to tell it what was used
s
completely agree
k
or the system has to tell the user what to do
s
good.. glad to hear I’m not crazy or thinking about it incorrectly.
c
@suitedev I know this doesn't help now, but 2020.2 is bringing the Lot and Serial Trace SuiteApp
It might help you
Details are up in the RP Help Center
s
NICE!!!!
thanks @Clay Roper I’ll check it out!!
😃 1