6.1 Barcodes Blank Title 60159

system · October 26, 2007, 10:17am

Sorry, left early yesterday.

{@OperVendor}

if NOT IsNull ({joboper.oprseq}) and {joboper.optype} = yes then

'ID:' + ' ' + {joboper.VendorID} + ' ' +

if IsNull({joboper.PurPoint}) then {joboper.VendorName}

else {joboper.PurPoint} + ' ' + {joboper.VendorName}

else ''

Chris

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Hofert
Sent: Thursday, October 25, 2007 1:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]6.1 Barcodes

Has this been answered yet? I would like this thread to remain online.
If you are corresponding offline can you bring the topic back online?

Thanks

Todd

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Norm Watkins
Sent: Thursday, October 25, 2007 2:09 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage]6.1 Barcodes

Chris, how is the: {@OperVendor} field defined?

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ]On
Behalf
Of Chris Crosta
Sent: Thursday, October 25, 2007 12:36 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage]6.1 Barcodes

Norm,
Try this.

iif ({JOBOPER.BCOPRSEQ}>"" and {@OperVendor}="","*" & "%DA" & "$M" &
Trim({JOBOPER.JOBNUM}) & "$M" & Trim ({JOBOPER.ASMSEQ}) & "$M" & Trim
({JOBOPER.OPRSEQ}) &"$M" & "*","")

This will scan into the Job, Assembly Seq and Operation from the
employee log in.

Chris Crosta
Scott Lamp Company

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Norm Watkins
Sent: Thursday, October 25, 2007 10:30 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage]6.1 Barcodes

I'm in the beginning stages of implementing barcode readers for data
collection, but have run into a problem that I'm sure someone in this
group
has solved.

In the Crystal Reports Traveler I'm trying to combine JobNo, AssySeqNo,
and
OpSeqNo in one barcode for reading into the "Start Activity" screen
using
the following formula (found in Epicor's Knowledge Base for bar coding):

"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq}))+"$
M"+t
rim(totext({JobOper.OprSeq}))+"*"

This barcode formula is reading the AssySeq and OprSeq numbers with a
decimal point with two trailing zero's. Strangely enough, the AsySeq
field
accepts the 0.00 read and displays only a single digit in the Screen
Field,
however, the OprSeq field is reading 10.00, and is entering 1000 into
the
Screen Field.

How can I strip the decimal point and trailing zero's?

thanks,

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/> >
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>
Yahoo! Groups Links

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

system · October 25, 2007, 1:31pm

I'm in the beginning stages of implementing barcode readers for data
collection, but have run into a problem that I'm sure someone in this group
has solved.

In the Crystal Reports Traveler I'm trying to combine JobNo, AssySeqNo, and
OpSeqNo in one barcode for reading into the "Start Activity" screen using
the following formula (found in Epicor's Knowledge Base for bar coding):

"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq}))+"$M"+t
rim(totext({JobOper.OprSeq}))+"*"

This barcode formula is reading the AssySeq and OprSeq numbers with a
decimal point with two trailing zero's. Strangely enough, the AsySeq field
accepts the 0.00 read and displays only a single digit in the Screen Field,
however, the OprSeq field is reading 10.00, and is entering 1000 into the
Screen Field.

How can I strip the decimal point and trailing zero's?

thanks,

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307

system · October 25, 2007, 1:35pm

Norm,
Try this.

iif ({JOBOPER.BCOPRSEQ}>"" and {@OperVendor}="","*" & "%DA" & "$M" &
Trim({JOBOPER.JOBNUM}) & "$M" & Trim ({JOBOPER.ASMSEQ}) & "$M" & Trim
({JOBOPER.OPRSEQ}) &"$M" & "*","")

This will scan into the Job, Assembly Seq and Operation from the
employee log in.

Chris Crosta
Scott Lamp Company

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Norm Watkins
Sent: Thursday, October 25, 2007 10:30 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage]6.1 Barcodes

I'm in the beginning stages of implementing barcode readers for data
collection, but have run into a problem that I'm sure someone in this
group
has solved.

In the Crystal Reports Traveler I'm trying to combine JobNo, AssySeqNo,
and
OpSeqNo in one barcode for reading into the "Start Activity" screen
using
the following formula (found in Epicor's Knowledge Base for bar coding):

"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq}))+"$
M"+t
rim(totext({JobOper.OprSeq}))+"*"

This barcode formula is reading the AssySeq and OprSeq numbers with a
decimal point with two trailing zero's. Strangely enough, the AsySeq
field
accepts the 0.00 read and displays only a single digit in the Screen
Field,
however, the OprSeq field is reading 10.00, and is entering 1000 into
the
Screen Field.

How can I strip the decimal point and trailing zero's?

thanks,

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307

system · October 25, 2007, 2:07pm

Chris, how is the: {@OperVendor} field defined?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Chris Crosta
Sent: Thursday, October 25, 2007 12:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]6.1 Barcodes

Norm,
Try this.

iif ({JOBOPER.BCOPRSEQ}>"" and {@OperVendor}="","*" & "%DA" & "$M" &
Trim({JOBOPER.JOBNUM}) & "$M" & Trim ({JOBOPER.ASMSEQ}) & "$M" & Trim
({JOBOPER.OPRSEQ}) &"$M" & "*","")

This will scan into the Job, Assembly Seq and Operation from the
employee log in.

Chris Crosta
Scott Lamp Company

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Norm Watkins
Sent: Thursday, October 25, 2007 10:30 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage]6.1 Barcodes

I'm in the beginning stages of implementing barcode readers for data
collection, but have run into a problem that I'm sure someone in this
group
has solved.

In the Crystal Reports Traveler I'm trying to combine JobNo, AssySeqNo,
and
OpSeqNo in one barcode for reading into the "Start Activity" screen
using
the following formula (found in Epicor's Knowledge Base for bar coding):

"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq}))+"$
M"+t
rim(totext({JobOper.OprSeq}))+"*"

This barcode formula is reading the AssySeq and OprSeq numbers with a
decimal point with two trailing zero's. Strangely enough, the AsySeq
field
accepts the 0.00 read and displays only a single digit in the Screen
Field,
however, the OprSeq field is reading 10.00, and is entering 1000 into
the
Screen Field.

How can I strip the decimal point and trailing zero's?

thanks,

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

system · October 25, 2007, 4:48pm

Has this been answered yet? I would like this thread to remain online.
If you are corresponding offline can you bring the topic back online?

Thanks

Todd

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Norm Watkins
Sent: Thursday, October 25, 2007 2:09 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]6.1 Barcodes

Chris, how is the: {@OperVendor} field defined?

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ]On
Behalf
Of Chris Crosta
Sent: Thursday, October 25, 2007 12:36 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage]6.1 Barcodes

Norm,
Try this.

iif ({JOBOPER.BCOPRSEQ}>"" and {@OperVendor}="","*" & "%DA" & "$M" &
Trim({JOBOPER.JOBNUM}) & "$M" & Trim ({JOBOPER.ASMSEQ}) & "$M" & Trim
({JOBOPER.OPRSEQ}) &"$M" & "*","")

This will scan into the Job, Assembly Seq and Operation from the
employee log in.

Chris Crosta
Scott Lamp Company

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Norm Watkins
Sent: Thursday, October 25, 2007 10:30 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage]6.1 Barcodes

I'm in the beginning stages of implementing barcode readers for data
collection, but have run into a problem that I'm sure someone in this
group
has solved.

In the Crystal Reports Traveler I'm trying to combine JobNo, AssySeqNo,
and
OpSeqNo in one barcode for reading into the "Start Activity" screen
using
the following formula (found in Epicor's Knowledge Base for bar coding):

"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq}))+"$
M"+t
rim(totext({JobOper.OprSeq}))+"*"

This barcode formula is reading the AssySeq and OprSeq numbers with a
decimal point with two trailing zero's. Strangely enough, the AsySeq
field
accepts the 0.00 read and displays only a single digit in the Screen
Field,
however, the OprSeq field is reading 10.00, and is entering 1000 into
the
Screen Field.

How can I strip the decimal point and trailing zero's?

thanks,

Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

This e-mail and any attachments may contain confidential and privileged
information. If you are not the intended recipient, please notify the
sender immediately by return e-mail, delete this e-mail and destroy any
copies. Any dissemination or use of this information by a person other
than the intended recipient is unauthorized and may be illegal.

[Non-text portions of this message have been removed]

system · October 25, 2007, 6:26pm

This gives the numbers without decimals (tested on CR XI):

"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq},0))+"$M"+trim(totext({JobOper.OprSeq},0))+"*"

Look up the "ToText" function in the Crystal help files for info on
the optional arguments. This is a Basic function so it should be the
same for CR 8.

Thanks for bringing this up. I've been meaning to look into having a
single bar code for all three data entries. For V8, I'll need to add
the option for the enter=tab but it should work. I don't have time to
test tonight.

Chris

--- In vantage@yahoogroups.com, "Norm Watkins" <nwatkins@...> wrote:
>
> I'm in the beginning stages of implementing barcode readers for data
> collection, but have run into a problem that I'm sure someone in
this group
> has solved.
>
> In the Crystal Reports Traveler I'm trying to combine JobNo,
AssySeqNo, and
> OpSeqNo in one barcode for reading into the "Start Activity" screen
using
> the following formula (found in Epicor's Knowledge Base for bar coding):
>
>
"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq}))+"$M"+t
> rim(totext({JobOper.OprSeq}))+"*"
>
> This barcode formula is reading the AssySeq and OprSeq numbers with a
> decimal point with two trailing zero's. Strangely enough, the
AsySeq field
> accepts the 0.00 read and displays only a single digit in the Screen
Field,
> however, the OprSeq field is reading 10.00, and is entering 1000
into the
> Screen Field.
>
> How can I strip the decimal point and trailing zero's?
>
> thanks,
>
>
> Norm Watkins
> Engineering Mgr.
> ELECPAC
> 847-639-2307
>

system · October 26, 2007, 6:58am

Our barcode, printed per job op on the Traveller and read happily by Wasp
CCD scanner is constructed as,
"*" + trim({jobhead.JOBNUM} + "$I" + trim(totext({jobasmbl.ASMSEQ})) + "$I"
+ trim(totext({JOBOPER.OPRSEQ}))) + "$M" + "*"

HTH

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
saab_barracuda
Sent: 25 October 2007 23:26
To: vantage@yahoogroups.com
Subject: Re: [Vantage]6.1 Barcodes

This gives the numbers without decimals (tested on CR XI):

"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq},0))+"$
M"+trim(totext({JobOper.OprSeq},0))+"*"

Look up the "ToText" function in the Crystal help files for info on
the optional arguments. This is a Basic function so it should be the
same for CR 8.

Thanks for bringing this up. I've been meaning to look into having a
single bar code for all three data entries. For V8, I'll need to add
the option for the enter=tab but it should work. I don't have time to
test tonight.

Chris

--- In vantage@yahoogroups.com, "Norm Watkins" <nwatkins@...> wrote:
>
> I'm in the beginning stages of implementing barcode readers for data
> collection, but have run into a problem that I'm sure someone in
this group
> has solved.
>
> In the Crystal Reports Traveler I'm trying to combine JobNo,
AssySeqNo, and
> OpSeqNo in one barcode for reading into the "Start Activity" screen
using
> the following formula (found in Epicor's Knowledge Base for bar coding):
>
>
"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq}))+"$M"
+t
> rim(totext({JobOper.OprSeq}))+"*"
>
> This barcode formula is reading the AssySeq and OprSeq numbers with a
> decimal point with two trailing zero's. Strangely enough, the
AsySeq field
> accepts the 0.00 read and displays only a single digit in the Screen
Field,
> however, the OprSeq field is reading 10.00, and is entering 1000
into the
> Screen Field.
>
> How can I strip the decimal point and trailing zero's?
>
> thanks,
>
>
> Norm Watkins
> Engineering Mgr.
> ELECPAC
> 847-639-2307
>

[Non-text portions of this message have been removed]

system · October 26, 2007, 7:43am

Thanks, this works perfectly. I did add another "$M" before the last "*" to
enter the last field, but that's optional depending on whether or not you
want to verify the field inputs before accepting it.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of saab_barracuda
Sent: Thursday, October 25, 2007 5:26 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage]6.1 Barcodes

This gives the numbers without decimals (tested on CR XI):

"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq},0))+"$M"
+trim(totext({JobOper.OprSeq},0))+"*"

Look up the "ToText" function in the Crystal help files for info on
the optional arguments. This is a Basic function so it should be the
same for CR 8.

Thanks for bringing this up. I've been meaning to look into having a
single bar code for all three data entries. For V8, I'll need to add
the option for the enter=tab but it should work. I don't have time to
test tonight.

Chris

--- In vantage@yahoogroups.com, "Norm Watkins" <nwatkins@...> wrote:
>
> I'm in the beginning stages of implementing barcode readers for data
> collection, but have run into a problem that I'm sure someone in
this group
> has solved.
>
> In the Crystal Reports Traveler I'm trying to combine JobNo,
AssySeqNo, and
> OpSeqNo in one barcode for reading into the "Start Activity" screen
using
> the following formula (found in Epicor's Knowledge Base for bar coding):
>
>
"*"+Trim({JobAsmbl.JobNum})+"$M"+trim(totext({JobAsmbl.AssemblySeq}))+"$M"+t
> rim(totext({JobOper.OprSeq}))+"*"
>
> This barcode formula is reading the AssySeq and OprSeq numbers with a
> decimal point with two trailing zero's. Strangely enough, the
AsySeq field
> accepts the 0.00 read and displays only a single digit in the Screen
Field,
> however, the OprSeq field is reading 10.00, and is entering 1000
into the
> Screen Field.
>
> How can I strip the decimal point and trailing zero's?
>
> thanks,
>
>
> Norm Watkins
> Engineering Mgr.
> ELECPAC
> 847-639-2307
>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links

Topic		Replies	Views
Vantage - Problems Scanning Job Traveller Barcodes Yahoo Archive	1	443	November 19, 2008
Bar Code Job + Asm + Seq Help Yahoo Archive	7	644	April 27, 2005
Barcode Equipment Yahoo Archive	4	550	April 1, 2002
Barcoding a string of fields Yahoo Archive	0	343	October 21, 2008
Barcode Yahoo Archive	6	603	November 8, 2006

6.1 Barcodes Blank Title 60159

Related topics