Order serialization - label x of y

Peter Fernandez

• September 19, 2022 19:07

Hi . I am new to this community.

i am trying to create labels from an excel file.  i have been able to add the data source with all the fields i

need for my label output.  but i am stuck on the Label X of Y.

Here is my issue.   I will have many lines of different item number/qty combo's.

Here is an example, i could end up with more items and Qty's just depending on order. 

U12-160   order qty 57

U12-205  order qty 70

S20-310  order qty 65

so i want the result for the label x of y to be.    Y = the total for all the lines 192

i would like  U12-160 to start at 1 of 192.. but stop printing at 57

then U12-205 would start at 58 of 192  but stop printing at 128

item S20-310 would start at 129 until 192  

i also have that order total of 192 in a column on each order detail line 

so the order qty and the total for all line items are on each row. 

any idea would be welcome. 

Peter

 

 

 

 

0

• 

  pthane

  ★ BarTender Hero ★

  • September 20, 2022 14:33

  As the total is on each row then this should be quite straight forward. 

  For the X, give this a default value of 1 and then on the Transforms set it to Increment and Reset to 1 Every Job as below:

  

   

  For the Y value link this to the filed that holds the total number of label in the database.

  On the File > Print screen, configure the Serial Numbers value (via the button to the right of the entry box) to Get Quantity form Database Field and link that the database field with the individual items quantities and then you are done.

  

   

  Using a simple text database with this data

  code,qty,total
  1111,2,8
  2222,3,8
  3333,3,8

  then the printed output would be 

  

  0

Please sign in to leave a comment.