How to transfer Inventory Pick No to Sales Shipment

samantha73

Hi All
I'm struggling to find an event to transfer inventory pick header no (Record "Warehouse Activity Header") to the posted sales shipment header field. WHat happens is when using inventory picks the warehouse employee post the doc but then struggle find a relationship when looking at posted sales shipments so though create a fiedl to hold the no

vaprog

samantha73 wrote: »

Hi All
I'm struggling to find an event to transfer inventory pick header no (Record "Warehouse Activity Header") to the posted sales shipment header field.

That is, because no such relation exists. Even on a document line level there may be multiple pick documents related to one shipment, and there may be multiple shipments related to one pick document line, and these may vary from line to line.

So, to get the full picture, you need to create a query. The sales order (line) primary key is the common fields.

In your setup, probably in most cases, there really is just one pick document no. involved in one shipment. You would need to impose restrictions to make this sure.

To get data that probably is sufficient for reference, you could transfer the pick document no. to the source line (sales line) probably best during registration, then transfer the field from the sales line to the posted sales shipment line when posting the shipment, and, if you really want, find some algorithm to decide, which pick document no. from the lines to transfer to the sales shipment header, also during or directly after posting the shipment.

You should have no trouble finding events for each of these steps.

vaprog

samantha73 wrote: »

Hi All
I'm struggling to find an event to transfer inventory pick header no (Record "Warehouse Activity Header") to the posted sales shipment header field.

That is, because no such relation exists. Even on a document line level there may be multiple pick documents related to one shipment, and there may be multiple shipments related to one pick document line, and these may vary from line to line.

So, to get the full picture, you need to create a query. The sales order (line) primary key is the common fields.

In your setup, probably in most cases, there really is just one pick document no. involved in one shipment. You would need to impose restrictions to make this sure.

To get data that probably is sufficient for reference, you could transfer the pick document no. to the source line (sales line) probably best during registration, then transfer the field from the sales line to the posted sales shipment line when posting the shipment, and, if you really want, find some algorithm to decide, which pick document no. from the lines to transfer to the sales shipment header, also during or directly after posting the shipment.

You should have no trouble finding events for each of these steps.