Solved

Multiple Packages/Tracking in Shipment

  • 1 March 2024
  • 8 replies
  • 103 views

Userlevel 4
Badge

Has anybody figured out how to show multiple tracking numbers per shipment, so we can have that populated in an email template to notify our customers with all tracking numbers along with the URL linked. 

Just looking for an example if somebody has cracked this code. 

Scenario: Shipment document might have few line items which needs to be shipped and the shipper packages into multiple boxes and gets tracking number for all those boxes, the tracking number gets stored against each package. 

How do we show those tracking numbers in the email template with looping so it has the tracking number and URL to click. 

Appreciate the response.

icon

Best answer by meganfriesen37 1 March 2024, 22:09

View original

8 replies

Userlevel 6
Badge +6

Not sure how you’re currently using your email template.  Looking at the fields, this is the one you’ll need:
 

As well as the Tracking URL below it if you want to include that as well.  Alternatively, you can include the tracking information to the shipment confirmation attached to the notifications where you can add the line number formulas. 

 

Here’s how I’ve incorporated that into our email templates:

Dear ((Shipping_Contact.Salutation)).

This is an automatic email to notify you that Order #((OrderList.OrderNbr)) has been shipped with Shipment #((ShipmentNbr)).

You can find a copy of the shipment confirmation attached to this email.


Here is your tracking number(s):

((Packages.TrackNumber))​


If you have any questions, please don’t hesitate to contact us at ((DefaultCompanyContact.EMail)).

Userlevel 4
Badge

Thanks, Jamesh for your comments. 

I know it works for single package but I’m looking into bit more complex scenario which is “If the Shipment has more than 1 package and more than 1 shipment tracking” then it needs to list all tracking numbers and URL list.

 

Userlevel 6
Badge +6

@hsarjapur 

So this doesn’t list the multiple lines if there’s more than one package then?  
 

I think at this point I would stick to including the multiple tracking numbers inside the report then. Here’s an example to this showing the report and sub report to help with this although it’s a couple versions behind:


https://www.augforums.com/forums/everything-else/need-to-display-multiple-tracking-numbers-on-the-shipment-notification/

Userlevel 7
Badge +10

There’s another post on the AUGForums for a different email notification but you can try using a “for each” option to get multiple records to display in a new row.  You might have to do it by business event and group based on “Shipment Number” so that you’ll have 1 shipment, but multiple tracking numbers.

https://www.augforums.com/forums/everything-else/how-to-send-1-email-a-day-for-approvals/#post-7022

Userlevel 6
Badge +6

@meganfriesen37 so you would add the HTML to look like this?

 

<foreach>
((Packages.TrackNumber))​

</foreach>

 

Userlevel 7
Badge +10

I’m not an HTML expert.  That looks like it should be correct.  You’ll need to make sure that you have all the details expanded out in your underlying GI.  I always have a bit of trial and error to get it to work for me :)

Userlevel 4
Badge

Yes, that’s what I was looking for to do inside of the email template, pretty simple hack that I’m surprised Acumatica hasn’t created an article or a template to use. I had to search entire Google to get a code sample and here is the code snippet if it helps others. 

<foreach view ="Packages">

((Packages.CustomRefNbr1)) - ((Packages.TrackNumber))  - ((Packages.TrackUrl))

</foreach>

I didn’t connect to any carriers, just used demo data and added my own tracking numbers to test the loop condition working and it did spit out the tracking number fields per package for the same shipment.

 

  Thanks everyone … Happy Friday !!! 

Userlevel 4
Badge

I just responded with my comments I guess it's still sitting with moderator to approve my response. 

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved