I need a little help deciding on an approach, if you all have any ideas, I'd much appreciate any input - I've searched the forums pretty exhaustively, not to mention stackoverflow and whatever else my google fu would provide.
Situation - need to create a custom record (asset) when serial number subrecord is created. As many other folks I've noticed on here, we have a custom record for serialized assembly items we build, because the subrecord doesn't cut it - we need to attach things like calibration certificate pdf, store calibration data per item, etc. Apparently before my time we had a script created by a third party but they turned it off as it was duplicating the records. Also, from what I can tell by looking at the scripts, our process has changed somewhat since then.
Situation part 2 - I'm a sub-par scripter. I've been able to get our labour calculated automatically and cal PDFs to autogenerate, and I love the learning process, but there may be some logic I'm unaware of - hence the cry for help.
What I think is the best solution - creating record after submit of assembly build/on creation of serial number record. The default info I need on the custom record exists on the Assembly build (any info from the SO comes later in our process, so the basics are fine).
Concerns
[LIST]
[*]Workflow with serial number record (as I'm sure you all know) is not possible
[*]Tried making relationship by creating Item number field on serial number record for custom record, with matching inventory number list field on custom record - but I can't make the list field Parent (greyed out).
[*]Serial number record is sub record of transaction, but inventory detail on assembly item messes with my head - where does this info live?
[LIST]
[*]I'm told by support that the serial number record (the pop up you get when clicking inventory detail sublist in item) is 'inventorynumber' subrecord, but everything I'm reading talks about 'inventorydetail' - are these the same record/subrecord?
[/LIST]
[/LIST] What I think is best approach:
[LIST]
[*]After submit on build, load inventorydetail - (if I script this as a workflow action, will I be able to access serial numbers for create record in a workflow aftersubmit on assembly build?)
[*]script the whole dang thing as user event script on aftersubmit of assembly build - though I already have a script running in that spot on form to assign labour -- and it doesn't look like I can have multiple functions on save?
[/LIST] As I said, would appreciate any input from others in the same boat or with bright ideas. Not looking for scripting handouts, just want to ensure I have the logic of the process down and can access the (correct) record before I blow another week on this
TL;DR - want to create custom record based on creation of serial number record, and what the heck is the difference between inventorydetail and inventorynumber?