Skip to main content
Solved

Drop-Shipments not displaying properly on report


Forum|alt.badge.img

Hi everyone,

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.

Ship Via displayed on the printed invoice


 

Ship Via on the freight details on the invoice

 GetFile.ashx?cache=yes&file=New%20Support%20Case%20(326173)\Screenshot%202023-09-19%20at%204.56.22%20PM.png

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.

Shipment type on the printed invoice
Shipment type on the freight details on the invoice

GetFile.ashx?cache=yes&file=New%20Support%20Case%20(326173)\Screenshot%202023-09-19%20at%204.53.06%20PM.png

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!

View original
Did this topic help you find an answer to your question?

11 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • October 17, 2023

Hello,

I’d like to ask for more information, to help answer your question.

Please use Inspect Element to show the Data Class & Data Field name that you see on the Invoice or Shipment data entry screen.

Example: Shipping tab of Shipments screen SO302000: 

Then show us the field name that is on the Invoice report. Example:  Shipment Confirmation Report # SO642000, Ship Via Field:

Last, please show us the Relationship(s) that connect the first Data Class in the screen, to the  Ship Via field on the Report:

Relationship between Data Class SOShipment and Data Class Carrier

Thank you.

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • October 17, 2023

Hi @Laura02 , thanks for the response!

Here is the data class and data field.

Here is the field I am attempting to use

I am unsure if this is what you mean, but this is the relationship I am using in report writer.

I hope this helps!


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • October 17, 2023

Hi,

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.

Thank you!

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • October 17, 2023

@Laura02 

Hi Laura,

Do you mean on the relationship between SOShipment and SOFreightDetails? I do not see CompanyID in either.


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • October 17, 2023

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.

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • October 17, 2023

Hello,

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.

Nathan used only Shipper Number to join SOFreightDetails to SOShipment table, and only OrderNumber to join SOFreightDetails to SOOrder table. 

I hope you find some good information in the link! If not, someone else will come along to help you.

Laura

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • October 18, 2023

@Laura02 

Hi Laura,

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. 


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • October 18, 2023

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.


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • October 18, 2023

@ChandraM 

Hi Chandra,

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?

Thanks!


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 25 replies
  • Answer
  • October 24, 2023

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!


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • October 24, 2023

Thank you for sharing your solution with the community @aidenwills15!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings