[Pierre]

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).

ConcernsWorkflow 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?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?

What I think is best approach: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?
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?
This is a cached copy. Click here to see the original post.

[wwinters]

Hi Pierre,

A bit of insight into ‘inventorynumber’ vs ‘inventorydetail’ :

If you DO NOT have ‘Advanced Bin/Numbered Inventory Management’ turned on, the serial/lot numbers of an item are a sublist of the item record called ‘inventorynumber’

If you DO have ‘Advanced Bin/Numbered Inventory Management’ turned on, the serial/lot numbers of an item are a subrecord called ‘inventorydetail’

If you have a tab on your item records called ‘Inventory Detail’ you have that feature enabled, and no longer have ‘inventorynumber’

Hope that clears things up…

Best,

Wes

[Pierre]

Holy cow, Wes, thank you! That does help a lot for clarification. We definitely have Advanced turned on, so there’s one less record for me to look for.

[Author]

Posts