I have been working through an issue that has me stumped where on the invoice report, it is assigning a completely random ship-via code to drop shipments.
As you can see, it doesn't match up. However, I did some more digging and realized that it isn't even recognizing the shipment type.
Here is the relationship between SOShipment and SOFreightDetail in report writer.
Thanks for the help!
Best answer by aidenwills15
Hello everyone,
I have finally figured it out. I had linked the SOShipment to the SOFreightDetail. Because of this, it was pulling the data from another shipment that had the same number as the purchase receipt, hence where that ShipVia code was coming from. I fixed this by connecting the SOInvoice to the SOFreightDetails and relating them by RefNbr, which made it pull the data from that tab on the invoice.
A silly mistake from me, but I hope this can maybe help someone in the future!
It looks like I missed part of the original post - sorry for making you repeat yourself.
Please try Joining on CompanyID as well as shipment Number and Shipment type. It looks like CompanyID is a key field in both SOShipment and SOFreightDetail.
If joining on CompanyID doesn’t solve the problem...SOFreightDetail actually has 7 key fields: CompanyID, DocType, RefNbr, ShipmentNbr, ShipmentType, OrderType and OrderNbr.
I identified for the Key Fields on SOShipment and SOFreightDetail using SQL Server.
Now I’ve got the Shipment Confirmation report open, and I’m seeing whether I can add SOFreightDetail table to Shipment confirmation by joining to SOShipment. I’ll report back shortly.
I searched the Community for help with the Join and found this useful post, answered by NathanKeating. The post includes a GI that links the same tables you are trying to link.
Unfortunately, that doesn't seem to work. Thanks for the suggestion! The strange thing is, it seems to be working correctly for normal shipments. However, when it comes to drop-shipments, it recognizes them all as normal shipments.
Hi @aidenwills15 Please clarify if the dropshipment referred by you is associated with a Purchase Receipt. And the Sales Order has a Shipvia “DROPSHIP”? Also, please provide screenshots on the data you are looking in the report.
Yes, it is associated with a purchase receipt. The sales order also has a shipvia of drop-ship. When you say the data I am looking at, so you mean the fields I am using?
I have finally figured it out. I had linked the SOShipment to the SOFreightDetail. Because of this, it was pulling the data from another shipment that had the same number as the purchase receipt, hence where that ShipVia code was coming from. I fixed this by connecting the SOInvoice to the SOFreightDetails and relating them by RefNbr, which made it pull the data from that tab on the invoice.
A silly mistake from me, but I hope this can maybe help someone in the future!
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.