6.1 Barcodes Blank Title 60159

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]
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
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
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
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]
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
>
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]
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