I've done something like that with a custom record...
# manufacturingk
KevinJ of Kansas
08/05/2020, 8:52 PMI've done something like that with a custom record before - it was painful and I wouldn't endeavor to repeat the process....
s
suitedev
08/05/2020, 8:55 PMI 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
KevinJ of Kansas
08/05/2020, 8:55 PMEssentially what it was was a custom record that associated serial number to another serial number.
s
suitedev
08/05/2020, 8:55 PMyep, and then that record has to be referenced as a basis for any transaction search.
k
KevinJ of Kansas
08/05/2020, 8:56 PMgranted - 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
suitedev
08/05/2020, 8:56 PMI was thinking of creating a custom field on the item number record to store the finished good serial..
k
KevinJ of Kansas
08/05/2020, 8:56 PMI wouldn't suggest doing that...
KevinJ of Kansas
08/05/2020, 8:56 PMprimarily because you can't join to the serial number while searching transactions
KevinJ of Kansas
08/05/2020, 8:56 PMso it's a black box.
KevinJ of Kansas
08/05/2020, 8:57 PMIt has the information, but you can't utilize it.
s
suitedev
08/05/2020, 8:57 PMvia inventory detail, you can, if I recall.
suitedev
08/05/2020, 8:57 PManyhow, it’s a mess..
suitedev
08/05/2020, 8:57 PMI had considered the custom record too..
suitedev
08/05/2020, 8:58 PMThe 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..
suitedev
08/05/2020, 8:59 PMThe option of building one at a time is also not an option.
k
KevinJ of Kansas
08/05/2020, 8:59 PMRight - which is why we wound up with a custom record for doing that
s
suitedev
08/05/2020, 8:59 PMdid they have to map them?
k
KevinJ of Kansas
08/05/2020, 9:00 PMThe users did - yes.
s
suitedev
08/05/2020, 9:00 PMseems the only person who could do that is the person doing the build..
k
KevinJ of Kansas
08/05/2020, 9:00 PMHowever, I imagine you could write a script such that it told you which serial numbers to use instead of the other way around
s
suitedev
08/05/2020, 9:00 PMyea, that seems like an added step/nightmare..
suitedev
08/05/2020, 9:01 PMyea, jim, just go find serial number XXX323234-R2340FF63 in that bin over there.
k
KevinJ of Kansas
08/05/2020, 9:01 PMi.e. for assembly item xyz - serial number Y - then use components serial numbers, a, b, c.
KevinJ of Kansas
08/05/2020, 9:01 PMwell, Not sure how else you'd get that info at the level you need
KevinJ of Kansas
08/05/2020, 9:01 PMeither the user has to tell it what was used
s
suitedev
08/05/2020, 9:01 PMcompletely agree
k
KevinJ of Kansas
08/05/2020, 9:01 PMor the system has to tell the user what to do
s
suitedev
08/05/2020, 9:02 PMgood.. glad to hear I’m not crazy or thinking about it incorrectly.
c
Clay Roper
08/05/2020, 9:05 PM@suitedev I know this doesn't help now, but 2020.2 is bringing the Lot and Serial Trace SuiteApp
Clay Roper
08/05/2020, 9:05 PMIt might help you
Clay Roper
08/05/2020, 9:05 PMDetails are up in the RP Help Center
s
suitedev
08/05/2020, 9:12 PMNICE!!!!
suitedev
08/05/2020, 9:12 PMthanks @Clay Roper I’ll check it out!!
😃 1
4 Views