Is there a way to grab the related Inbound Shipmen...
# general
l
Is there a way to grab the related Inbound Shipment of an Item Receipt if the transaction saved search has Type of Item Receipt? It seems that the Item Receipt is linked to the Ownership Transfer instead. I basically need to copy a custom field value from the Inbound Shipment to the Item Receipt. I tried workflow, sourcing and defaulting, default formula but none of these work.
a
There is a field called Shipment Number on the Item Receipt, so you can get to the shipment, but it's not a linked field. You'd either need a SuiteAnlytics workbook or a script at the time the receipt is created that looks up that shipment.
I've run into a lot of limitations with Inbound Shipments. Like why can't I do a search from the PO and bring details from the shipment, but I can do a search from the shipment and bring details from the PO? 🤔
the new release of suiteanlytics that allows you to link to datasets will help
l
Thank you for the confirmation. There are really a lot of annoying limitations related to Inbound Shipments. Not being able to receive more than the IS quantity, not being able to edit the rates on OT, not being able to close certain lines, fields cannot be globally searched, I could go on. Sigh. Anyway, I need to expose it on the Item Receipt and not just show via saved searches/analytics. So, I guess this is doable only via a script? I tried WF but the fields seem to be not exposed.
a
script only. And to add to the annoyances...no global search option for inbound shipments...even on a custom field
r
I agree! So many different limitations!