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
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!
Hey Dave,
Call me if you need any assistance adding the field to the report.
F1 while you're in Report Writer will bring up RW Help.
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?
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.
Frank,
Yes we are using Report Writer.
What type of form are you using for the pick ticket? Report Writer or some other form type?
Smartlist Builder, Yes.
Do you have smartbuilder, ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (