Adding Total Shipping Weight to Picking Ticket

(0) Share

Report

Posted on by Community Member

Hi All,

I am wanting to add a field to our current picking tickets that will give the total order weight under our barcode that our warehouse can use to determine box size for the 1/1/2015 Fedex DIM change.

Any and all help is appreciated!!

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (2)

Community Member on at

Like (0)

Report

Do you have smartbuilder, ?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Smartlist Builder, Yes.

Was this reply helpful? Yes No
Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

What type of form are you using for the pick ticket? Report Writer or some other form type?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Frank,

Yes we are using Report Writer.

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

Okay, then you'll need to drag IV00101.ITEMSHWT onto the report at the line level, insert a calculated field to extend the quantity picked * ITEMSHWT and then a SUM field to calculate total pick list weight.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ok, I see the Item shipping weight in the Fields box, but not in the Toolbox screen? Is there a guide you can direct me to?

Was this reply helpful? Yes No
Suggested answer

Frank Hamelly | MVP... 46,625 Super User 2025 Season 2 on at

Like (0)

Report

F1 while you're in Report Writer will bring up RW Help.

Was this reply helpful? Yes No
Verified answer

steveendow 2,281 on at

Like (0)

Report

Hey Dave,

Call me if you need any assistance adding the field to the report.

Was this reply helpful? Yes No
Verified answer

steveendow 2,281 on at

Like (1)

Report

Hi Dave,

To summarize our call:

We verified that you had properly added the Item Master table to the report, but for some reason it was not showing up in the table list in the Toolbox.

We removed the Item Master table, then re-added it, and then it showed up in the table list.

Once we could view the Item Master table in the toolbox, we created an Extended Item Ship Weight calculated field (Qty * Ship Weight). We then added that field to the report to test.

We observed that the Ship Weight value is stored in IV00101 without decimals, so we ultimately applied the DLR6_S2 format to the field, which gave us 2 decimals for the field value.

We added the Extended Item Ship Weight field to the Body section with the field Display Type set to Data. We then enabled the Report Footer section for the report, and added the calculated field again to the Report Footer, and used a Display Type value of Sum on the footer version of the field.

And with that, I've had my annual dose of Report Writer for the year, so I'll display my vaccination record next time!

Was this reply helpful? Yes No