I am trying to overwrite the serial/lot number field on inventory detail subrecord of an item receipt on before load, I am failing as it seems that it expects an integer (internal id) of an existing serial/lot number. When creating a new item receipt you can type a string and when you save it i will create the serial/lot number record and associate it with the inventory detail. This does not seem to work the same on before submit. Has anyone been able to write a before submit script that swaps out whatever the user entered with a different serial/lot number?
l
Luiz Morais
10/05/2021, 9:42 AM
Hey Martin… there are 2 fields for inventory number on inventory detail. One for Item Fulfillment that requires internal id and another one that’s string for inbounds like item receipt… if I’m not wrong it’s “issueinventorynumber”. Did you try this one?
m
Martin Kolev
10/05/2021, 12:27 PM
Hi, thanks for the reply, yes this is on an item receipt and i tried issueinventorynumber, when adding a new line and configuring the detail the Serial/Lot Number is a text field. When you save the record it becomes a custom record
Martin Kolev
10/05/2021, 12:29 PM
This is on create (text field)
Martin Kolev
10/05/2021, 12:30 PM
This is after its saved, testing is now an actual record
Martin Kolev
10/05/2021, 12:31 PM
My goal is to replace “testing” with a custom calculated serial/lot number on beforeSubmit of the item receipt, but when I try to modify the serial/lot number (issueinventorynumber) I get unexpected error, every single time unless instead of a string i pass an integer for an internal id of an existing inventory number record, then it works
Martin Kolev
10/05/2021, 1:56 PM
Issue is now resolved. I was not able to update the serial/lot number of an existing subrecord, so now i delete the existing, create a new one and it works