Can someone help with identifying which filed on t...
# suitescript
i
Can someone help with identifying which filed on the item fulfillment will give the order line it corresponds to on the sale order? Need to create and after submit script that references the sales order line for each item on the item fulfillment but canโ€™t seem to find what the name of that field would be. Thanks
m
There are
orderdoc
and
orderline
column fields on Item Fulfillment records. That might be what you're looking for.
z
Nice answer, Mike Robbins. I forgot about those. I was thinking ... Get Sales Order line-level data via Transaction search and refer to the field
fulfillingtransaction
As I recall, there are limitations. Unless I'm mistaken ... ๐Ÿ™ Given that the same Item can appear on multiple lines in multiple quantities on the originating Sales Order and that these quantities and lines may be combined or split unpredictably on one or more spawned Item Fulfillments, the structure and resolution of the information itself is insufficient to support deterministic matching in every case. One wants a level of quality-in-information that can only be guaranteed with serialized or perhaps lot-controlled inventory -- yet without the burden that comes with producing input and controlling process at that resolution. ๐Ÿ˜€ If your Orders are such that the same Item never appears on multiple lines, and especially if you don't split quantities of the same Item over multiple fulfillments, then you can get the quality of information you seek, either algorithmically (old school) or via
fulfillingtransaction
(a relatively recent field, actually).
b
the other search alternative is to use the applying transaction join from a sales order search, or the applied to transaction join from the item fulfillment search
๐Ÿ‘๐Ÿผ 1
both joins link the transaction lines between each transaction