Israel Gonzalez
06/02/2021, 4:00 PMMike Robbins
06/02/2021, 4:51 PMorderdoc
and orderline
column fields on Item Fulfillment records. That might be what you're looking for.zvictor
06/02/2021, 4:52 PMfulfillingtransaction
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).battk
06/02/2021, 5:02 PMbattk
06/02/2021, 5:02 PM