Epicor 9.05.701, Barcodes

Yahoo Archive
1

 

I’m not sure what you mean by adding a group.  Can you give me an example?

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 06, 2015 8:02 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

Can you add a group – the serial number – that way it will break on each serial number.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 06, 2015 4:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

 

Thank you Miguel.  That sort of worked, but it just printed the first, second or third serial number.

 

Anyone have an idea how I get all 9 to print one after the other?  Is there a way for it to do a new line instead of a comma in the Calc_DspSerialNumber field?

 

I don’t know how it is created, I just know it is the field in the packing slip which prints all of the serial numbers (if any).

 

Thanks,

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 06, 2015 5:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

I list my Serial numbers as individual lines or Fields.

 

Looks like you are using 1 field?

 

Maybe use the command SPLIT?

 

Split({Serial.Field},',') [1]

Split({Serial.Field},',') [2]

Split({Serial.Field},',') [3]

 

Then barcode that formula?

 

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 6, 2015 2:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

 

Hi Todd,

 

I was searching to see if someone had any advice on how to get Dataworks 39 to work in Cyrstal reports and found this message below.

 

Per your directions, I was able to get it to work for one serial number with the formula field I created:  "*" + {shipdtl.Calc_DspSerialNumber} + "*"

 

But when there are multiple serial numbers the barcodes do not work.  I have a feel it has something to do with the comma that is in the calculated field created when writing them out.  For example below is 9 serial numbers, which when written shows on the packing slip as:

 

NS4150284002, NS4150284003, NS4150284004, NS4150284005, NS4150284006, NS4150284007, NS4150284008, NS4150284009, NS4150284010

 

But we also want the barcode for each of those serial numbers to print on the packing slip.  Do you know how we can get it to display the Dataworks 39 font correctly so that it ignores the comas and therefore just prints the barcode for each serial number?

 

Thank you for your help.

 

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 5:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

2
I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael


3

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

4

Forgot – add the font on the server and any PC that will need to print bar coded items.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 4:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

5
Todd,
That is very useful, save for the barcode font.  I am needing to use the 128.  How do I tell Crystal to use that font?



On Thursday, May 28, 2015 4:22 PM, "Todd Caughey tcaughey@... [vantage]" <vantage@yahoogroups.com> wrote:


  
<div id="ygrps-yiv-440288124yiv9003672547ygrp-text">
  
  
  <div>
Forgot – add the font on the server and any PC that will need to print bar coded items.
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 4:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes
 
 
First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.
 
-Todd C.
 
 
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes
 
 
I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael
 
</div>
 


<div class="ygrps-yiv-440288124yiv9003672547yqt3586524510" id="ygrps-yiv-440288124yiv9003672547yqt17023"><div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547 -- #ygrps-yiv-440288124yiv9003672547ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mkp #ygrps-yiv-440288124yiv9003672547hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mkp #ygrps-yiv-440288124yiv9003672547ads {
margin-bottom:10px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mkp .ygrps-yiv-440288124yiv9003672547ad {
padding:0 0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mkp .ygrps-yiv-440288124yiv9003672547ad p {
margin:0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mkp .ygrps-yiv-440288124yiv9003672547ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-sponsor #ygrps-yiv-440288124yiv9003672547ygrp-lc {
font-family:Arial;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-sponsor #ygrps-yiv-440288124yiv9003672547ygrp-lc #ygrps-yiv-440288124yiv9003672547hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-sponsor #ygrps-yiv-440288124yiv9003672547ygrp-lc .ygrps-yiv-440288124yiv9003672547ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547activity span {
font-weight:700;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547activity span span {
color:#ff7900;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547activity span .ygrps-yiv-440288124yiv9003672547underline {
text-decoration:underline;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547attach div a {
text-decoration:none;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547attach img {
border:none;padding-right:5px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547attach label a {
text-decoration:none;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547bold a {
text-decoration:none;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 dd.ygrps-yiv-440288124yiv9003672547last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 dd.ygrps-yiv-440288124yiv9003672547last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 dd.ygrps-yiv-440288124yiv9003672547last p span.ygrps-yiv-440288124yiv9003672547yshortcuts {
margin-right:0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547attach-table div div a {
text-decoration:none;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547attach-table {
width:400px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547file-title a, #ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547file-title a:active, #ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547file-title a:hover, #ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547file-title a:visited {
text-decoration:none;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547photo-title a, #ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547photo-title a:active, #ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547photo-title a:hover, #ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div.ygrps-yiv-440288124yiv9003672547photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 div#ygrps-yiv-440288124yiv9003672547ygrp-mlmsg #ygrps-yiv-440288124yiv9003672547ygrp-msg p a span.ygrps-yiv-440288124yiv9003672547yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547green {
color:#628c2a;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 o {
font-size:0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547photos div {
float:left;width:72px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547reco-category {
font-size:77%;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547reco-desc {
font-size:77%;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 .ygrps-yiv-440288124yiv9003672547replbq {
margin:4px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mlmsg select, #ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 input, #ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mlmsg pre, #ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 code {
font:115% monospace;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-mlmsg #ygrps-yiv-440288124yiv9003672547logo {
padding-bottom:10px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-msg p#ygrps-yiv-440288124yiv9003672547attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-reco #ygrps-yiv-440288124yiv9003672547reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-sponsor #ygrps-yiv-440288124yiv9003672547ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-sponsor #ygrps-yiv-440288124yiv9003672547ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-sponsor #ygrps-yiv-440288124yiv9003672547ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-text {
font-family:Georgia;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-text tt {
font-size:120%;}

#ygrps-yiv-440288124 #ygrps-yiv-440288124yiv9003672547 #ygrps-yiv-440288124yiv9003672547ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-440288124



6

You don’t. Code 128 is different… completely. It’s just not a font. You’ll need a plugin for CR.

 

http://www.idautomation.com/font-encoders/crystal-reports/font-formulas.html

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 29, 2015 8:53 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9.05.701, Barcodes

 

 

Todd,

That is very useful, save for the barcode font.  I am needing to use the 128.  How do I tell Crystal to use that font?

 

 

On Thursday, May 28, 2015 4:22 PM, "Todd Caughey tcaughey@... [vantage]" <vantage@yahoogroups.com> wrote:

 

 

Forgot – add the font on the server and any PC that will need to print bar coded items.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 4:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

 

7

The only time I’ve done this was by purchasing the Code 128 User Function Library from  Azalea Software.  In CR 2011 if you right click a field on a form (any will do) and select Change to Barcode then select one of the pre-installed Code 39 options the “View Vendor Website” button will activate.  Once there under products look for Code 128.  If I recall it was a couple hundred dollars.  Code 128 is a lot trickier than a simple font substitution due to some built in check-digits to assure a good scan.  I have also tried a freeware function library routine that did the calculations as a function and the result could be used with a Code 128 font – but I had mixed results with that.  Now I use BarTender for anything requiring Code 128 (especially customer spec product labels) and also for new requests for 2D Matrix type symbologies.

 

Or… cheat a bit.  If a customer specs out Code 128 for labels it is often not because they have automated routing systems that need good scans but rather just because some consultants told them they needed it so they could sell their vendors special bar coding systems.  They were not really using the features of Code 128 so I used Code 39 and they never knew since most scanners are happy with either and the data looked right.

 

-Todd

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, May 29, 2015 7:53 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Epicor 9.05.701, Barcodes

 

 

Todd,

That is very useful, save for the barcode font.  I am needing to use the 128.  How do I tell Crystal to use that font?

 

 

On Thursday, May 28, 2015 4:22 PM, "Todd Caughey tcaughey@... [vantage]" <vantage@yahoogroups.com> wrote:

 

 

Forgot – add the font on the server and any PC that will need to print bar coded items.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 4:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

 

8

 

Hi Todd,

 

I was searching to see if someone had any advice on how to get Dataworks 39 to work in Cyrstal reports and found this message below.

 

Per your directions, I was able to get it to work for one serial number with the formula field I created:  "*" + {shipdtl.Calc_DspSerialNumber} + "*"

 

But when there are multiple serial numbers the barcodes do not work.  I have a feel it has something to do with the comma that is in the calculated field created when writing them out.  For example below is 9 serial numbers, which when written shows on the packing slip as:

 

NS4150284002, NS4150284003, NS4150284004, NS4150284005, NS4150284006, NS4150284007, NS4150284008, NS4150284009, NS4150284010

 

But we also want the barcode for each of those serial numbers to print on the packing slip.  Do you know how we can get it to display the Dataworks 39 font correctly so that it ignores the comas and therefore just prints the barcode for each serial number?

 

Thank you for your help.

 

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 5:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

9

I list my Serial numbers as individual lines or Fields.

 

Looks like you are using 1 field?

 

Maybe use the command SPLIT?

 

Split({Serial.Field},',') [1]

Split({Serial.Field},',') [2]

Split({Serial.Field},',') [3]

 

Then barcode that formula?

 

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 6, 2015 2:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

 

Hi Todd,

 

I was searching to see if someone had any advice on how to get Dataworks 39 to work in Cyrstal reports and found this message below.

 

Per your directions, I was able to get it to work for one serial number with the formula field I created:  "*" + {shipdtl.Calc_DspSerialNumber} + "*"

 

But when there are multiple serial numbers the barcodes do not work.  I have a feel it has something to do with the comma that is in the calculated field created when writing them out.  For example below is 9 serial numbers, which when written shows on the packing slip as:

 

NS4150284002, NS4150284003, NS4150284004, NS4150284005, NS4150284006, NS4150284007, NS4150284008, NS4150284009, NS4150284010

 

But we also want the barcode for each of those serial numbers to print on the packing slip.  Do you know how we can get it to display the Dataworks 39 font correctly so that it ignores the comas and therefore just prints the barcode for each serial number?

 

Thank you for your help.

 

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 5:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 



Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

10

I would use the split command and put them into an array. Then it would be a matter of printing the array.

Sent by Outlook for Android




On Tue, Oct 6, 2015 at 2:31 PM -0700, "Deb Devlin ddevlin@... [vantage]" <vantage@yahoogroups.com> wrote:

 

 

Hi Todd,

 

I was searching to see if someone had any advice on how to get Dataworks 39 to work in Cyrstal reports and found this message below.

 

Per your directions, I was able to get it to work for one serial number with the formula field I created:  "*" + {shipdtl.Calc_DspSerialNumber} + "*"

 

But when there are multiple serial numbers the barcodes do not work.  I have a feel it has something to do with the comma that is in the calculated field created when writing them out.  For example below is 9 serial numbers, which when written shows on the packing slip as:

 

NS4150284002, NS4150284003, NS4150284004, NS4150284005, NS4150284006, NS4150284007, NS4150284008, NS4150284009, NS4150284010

 

But we also want the barcode for each of those serial numbers to print on the packing slip.  Do you know how we can get it to display the Dataworks 39 font correctly so that it ignores the comas and therefore just prints the barcode for each serial number?

 

Thank you for your help.

 

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 5:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

11

 

Thank you Miguel.  That sort of worked, but it just printed the first, second or third serial number.

 

Anyone have an idea how I get all 9 to print one after the other?  Is there a way for it to do a new line instead of a comma in the Calc_DspSerialNumber field?

 

I don’t know how it is created, I just know it is the field in the packing slip which prints all of the serial numbers (if any).

 

Thanks,

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 06, 2015 5:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

I list my Serial numbers as individual lines or Fields.

 

Looks like you are using 1 field?

 

Maybe use the command SPLIT?

 

Split({Serial.Field},',') [1]

Split({Serial.Field},',') [2]

Split({Serial.Field},',') [3]

 

Then barcode that formula?

 

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 6, 2015 2:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

 

Hi Todd,

 

I was searching to see if someone had any advice on how to get Dataworks 39 to work in Cyrstal reports and found this message below.

 

Per your directions, I was able to get it to work for one serial number with the formula field I created:  "*" + {shipdtl.Calc_DspSerialNumber} + "*"

 

But when there are multiple serial numbers the barcodes do not work.  I have a feel it has something to do with the comma that is in the calculated field created when writing them out.  For example below is 9 serial numbers, which when written shows on the packing slip as:

 

NS4150284002, NS4150284003, NS4150284004, NS4150284005, NS4150284006, NS4150284007, NS4150284008, NS4150284009, NS4150284010

 

But we also want the barcode for each of those serial numbers to print on the packing slip.  Do you know how we can get it to display the Dataworks 39 font correctly so that it ignores the comas and therefore just prints the barcode for each serial number?

 

Thank you for your help.

 

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 5:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

12

 

Sorry I don’t know what you mean about putting them in an array.  Can you give me an example?

 

Maybe that’s how I get multiple serial numbers to print?

 

Thanks,

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 06, 2015 6:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

I would use the split command and put them into an array. Then it would be a matter of printing the array.

Sent by Outlook for Android



On Tue, Oct 6, 2015 at 2:31 PM -0700, "Deb Devlin ddevlin@... [vantage]" <vantage@yahoogroups.com> wrote:

 

 

Hi Todd,

 

I was searching to see if someone had any advice on how to get Dataworks 39 to work in Cyrstal reports and found this message below.

 

Per your directions, I was able to get it to work for one serial number with the formula field I created:  "*" + {shipdtl.Calc_DspSerialNumber} + "*"

 

But when there are multiple serial numbers the barcodes do not work.  I have a feel it has something to do with the comma that is in the calculated field created when writing them out.  For example below is 9 serial numbers, which when written shows on the packing slip as:

 

NS4150284002, NS4150284003, NS4150284004, NS4150284005, NS4150284006, NS4150284007, NS4150284008, NS4150284009, NS4150284010

 

But we also want the barcode for each of those serial numbers to print on the packing slip.  Do you know how we can get it to display the Dataworks 39 font correctly so that it ignores the comas and therefore just prints the barcode for each serial number?

 

Thank you for your help.

 

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 5:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

13

Can you add a group – the serial number – that way it will break on each serial number.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 06, 2015 4:13 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

 

Thank you Miguel.  That sort of worked, but it just printed the first, second or third serial number.

 

Anyone have an idea how I get all 9 to print one after the other?  Is there a way for it to do a new line instead of a comma in the Calc_DspSerialNumber field?

 

I don’t know how it is created, I just know it is the field in the packing slip which prints all of the serial numbers (if any).

 

Thanks,

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 06, 2015 5:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

I list my Serial numbers as individual lines or Fields.

 

Looks like you are using 1 field?

 

Maybe use the command SPLIT?

 

Split({Serial.Field},',') [1]

Split({Serial.Field},',') [2]

Split({Serial.Field},',') [3]

 

Then barcode that formula?

 

 

Miguel A. Santillan

Compass Manufacturing Systems

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Tuesday, October 6, 2015 2:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

 

Hi Todd,

 

I was searching to see if someone had any advice on how to get Dataworks 39 to work in Cyrstal reports and found this message below.

 

Per your directions, I was able to get it to work for one serial number with the formula field I created:  "*" + {shipdtl.Calc_DspSerialNumber} + "*"

 

But when there are multiple serial numbers the barcodes do not work.  I have a feel it has something to do with the comma that is in the calculated field created when writing them out.  For example below is 9 serial numbers, which when written shows on the packing slip as:

 

NS4150284002, NS4150284003, NS4150284004, NS4150284005, NS4150284006, NS4150284007, NS4150284008, NS4150284009, NS4150284010

 

But we also want the barcode for each of those serial numbers to print on the packing slip.  Do you know how we can get it to display the Dataworks 39 font correctly so that it ignores the comas and therefore just prints the barcode for each serial number?

 

Thank you for your help.

 

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 5:20 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Epicor 9.05.701, Barcodes

 

 

First install (if not already) the DWBAR39.ttf (or Dataworks 39) bar code font.  This is for Code 39 symbology (no check digits like Code 128).  Then use a formula field for anything to be bar coded and append astericks to the front and back.  If the data is not String type then use the ToText() function to convert it.   So Packing Slip # might be --   â€œ*” + ToText(Shiphead.PackNum) + “*” (just guessing table.field name).  Then place this on the report and change font to the barcode.  Also upsize the font size to something like 36 or so and make sure there is a clear (quiet) space of ¼” or so in front and behind.  That should do it.

 

-Todd C.

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 28, 2015 3:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Epicor 9.05.701, Barcodes

 

 

I am trying to setup a Barcode for a specific customer to print out to the crystal report for packing slips.  I know I need to modify the existing Crystal report, but I can find nothing to assist in setting up the barcode itself.
Any help would be beyond appreciated.  I am starting at ground 0 on this...

Thank you in advance,
Michael

 

 

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

14
Not sure what to try on serial numbers.

>>> “*” + ToText(Shiphead.PackNum) + “*”
Just wanted to mention there used to some answerbooks on EpicWeb for earier version of Vantage
One included an example formula for concatenating data and control characters on the traveler.
Could reduce the number of bar codes users needed to scan when starting activities in MES.


"*" + TRIM (({JobHead.JobNum})) + "$I" +  TRIM (ToText({JobAsmbl.AssemblySeq},"0")) + "$I" + TRIM (ToText ({JobOper.OprSeq},"0"))+ "$I"  + "$M" + "*"
15

 

Thanks for the info!  We haven’t fully implemented MES, but that is next on our to do list.  And we will want to be able to scan the info on the traveler, so I will probably need this information.

 

Deb

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Wednesday, October 07, 2015 4:58 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Epicor 9.05.701, Barcodes

 

 

Not sure what to try on serial numbers.

>>> “*” + ToText(Shiphead.PackNum) + “*”
Just wanted to mention there used to some answerbooks on EpicWeb for earier version of Vantage
One included an example formula for concatenating data and control characters on the traveler.
Could reduce the number of bar codes users needed to scan when starting activities in MES.


"*" + TRIM (({JobHead.JobNum})) + "$I" +  TRIM (ToText({JobAsmbl.AssemblySeq},"0")) + "$I" + TRIM (ToText ({JobOper.OprSeq},"0"))+ "$I"  + "$M" + "*"