Hello!
I am creating a custom GI that aims to pull the Shipment Details by a given date. I want to show what inventory ID shipped out on what shipment along with the qty shipped and the shipping address. However, I am facing some trouble when I try to pull the shipping address onto the GI.
I was able to join the SOOrder and SOShipmentAddress tables by joining the SOOrder.shipAddressID and SOShipmentAddress.AddressID fields (See below).
However, it seems to pull the shipping address from the customer rather than the shipping address that is on the Sales Order or Shipment.
We typically have to override the shipping address when entering a Sales Order, as we are in a business where a customer has many open job sites / warehouses to ship to.
Does anyone know how we can get around the override and have the user-entered Ship-To address to come up in the GI?
Thank you!