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.

greyterin

Reliable cargo registration services provide customer support to assist with queries related to shipment status, documentation, delays, or issues faced during transit.

magderuket

Choosing a reputable logistics provider is crucial for businesses and individuals who depend on efficient and secure cargo transportation. By prioritizing transparency, security, and efficiency, shippers can enhance their supply chain operations and ensure timely deliveries. The following trusted industry leaders like Chapman Freeborn can simplify the cargo registration process and provide peace of mind throughout the shipping journey. Chapman Freeborn, a global leader in aircraft charter solutions, including offering a humanitarian aid cargo charter. Whether it's emergency medical supplies, food, water, shelter materials, or other critical relief items, the company provides seamless air transport solutions tailored to urgent needs.

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.