Thanks, I would like to do that but the boxes are labeled well in advance of a pack slip being created. Conversely they are not "finished goods" inventory either and remain WIP until shipped. Boxes are also packed across several weeks for a given SO/Line/Release and from various jobs linked to a release. Also some can be packed in morning and then in afternoon of same day so just using date won't work.
On the old VAX/VMS systems there was a useful function for Clunks (seconds since 1/1/1970) but I think RB's time functions are frozen at report startup and not "real time". I was hoping there was some sort of realtime function in RB that I'd missed.
I have the hex formula down now so will probably go with that.
-Todd C.
-----Original Message-----
From:
vantage@yahoogroups.com [mailto:
vantage@yahoogroups.com]On Behalf Of Podlin, Michael
Sent: Monday, July 17, 2006 1:54 PM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] RB Serial # on label
My serial numbers are PackSlip# - Line# - Box#.....
So if Packing Slip # 1234 had three Line items (1st one has 3 boxes, 2nd line has 1 box & 3 line has 2 boxes) I would have labels with the following serial numbers:
1234-1-1
1234-1-2
1234-1-3
1234-1-4
1234-2-1
1234-3-1
1234-3-2
This way if there is a problem, the serial number is useful to us for tracking down which packing slip and line item its from.
-----Original Message-----
From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On Behalf Of Todd Caughey
Sent: Monday, July 17, 2006 1:27 PM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] RB Serial # on label
Major customer wants a unique "serial number" on every box label. Currently labels are made using RB and printed on Zebra printer in "laser printer" mode (no ZPL-II coding). The limit appears to be 8 characters. Must be generatable on each run without entry or lookup to reference prior numbers.
The best I have come up with so far is "day of year" for Date_rb expressed as 2 characters (A-Z & 0-9 so 36) then 3 characters for minutes since midnight for report time followed by 2 digit page number for each label. The labels are all the same except for serial # so I will enter the number desired via filter and suppress label printing for pages after the limit. Or maybe even create a number (max would be 365,143,999 and convert to hexidecimal or even base 36) to shorten it.
But I have a feeling I am making this way too hard and there is an easier way to independently generate a unique number/character combo for each label. Any suggestions?
Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]