Print Shipping Labels in Box Quantities

Epicor ERP 10
, , ,
1

We would like to print shipping labels in box quantities out of customer shipment entry. We have an order line for 1000 pcs, each box holds 200 pcs, and we want 5 labels for 200 pcs each. Does anyone have any recommendations on how to handle this?

Thanks!

1 Like
2

Depends on how you are printing them. If you are using BarTender there are multiple ways to skin that cat that I could help with. Are you using standard auto print report styles? Are you using custom code? etc etc.

3

Rather than print labels have you looked at print tags - then you can specify how many per box and get the appropriate number of labels

e.g.
Produce 100 items
Print tags - 50 per box = 2 tags

5

I had been testing the print shipping labels out of customer shipment entry. We do have bar tender but have not yet been utilizing it as we just went live. How could we accomplish this using BarTender?

6

CullenOlson

2m

We do use print tags out of MES for printing tags in production. Where we run into issues is for our make to stock parts where we have finished goods sitting on the shelf that we need to pick. We need to print order/customer specific tags for shipment and they need to be in box quantities.
Thanks!

7

A really cool thing about sending data to BarTender is you could have it calculate the number of labels you need based on other values. It takes dynamic values for # of copies. Example if you have somewhere in the system what constitues a box you could have it divide that 1000pcs by 200pcs per box and give you those 5 labels. The system needs to know that so you can send that info and do those calculations but it’s all very do-able. How does your system know how many pieces are in a box today? Part Specific UOM? Parts Per Container?

There are a ton of different ways to send data to BarTender you can search the forum for specifics, but the 3 main ways to do it is.

  • Use the auto print feature that comes with some base reports (my least favorite pretty restrictive)
  • Use RDDs and Report Styles (ok way but you have to be careful what tables you link or it will shit out a ton of rows)
  • Use a BAQ and custom code in a BPM or a UBAQ and BAQ Export (my favorite, more complex, but gives you the most flexibility, granularity and least amount of junk data)
1 Like
8

Be careful letting Bartender calculate your labels. Yes it can calculate the labels, however, i was unable to get Bartender to show the Remainder when the amounts are not even.

i.e. Sales Order is for 90 parts. Boxes hold 20 parts. you will need 5 boxes. However the last box will only have 10.

Ideally Bartender would show Box 1 of 5, 2 of 5, etc. and show the box quantity for each box i.e. 20 per box except for the last box of just 10. I must confess it has been a few years since i tried to tackle this. at the time i created a ticket with Bartender to help me solve this issue. I never got an answer from them - I had to move on. Maybe there is a way to do this now. This is just a heads up - the answer may not be as simple as it sounds.

DaveO

9

We use Manifest/QuickShip and do a Phantom Pack to get multiple shipping labels for a single order/pack. But we do hundreds of shipments per day, not sure if you want to invest in that if you don’t do many shipments.

10

We added a Pack Line level UD field to indicate the number of labels.

Then the line quantity is divided by the number of labels. SSRS label is being used.

If you did not want the line quantity divided up, with this method you can leave the label quantity as 1 and then print one or more labels from the print screen with the full line quantity.

Brad