Serial Numbers

I assigned a range of 10 serial numbers to a 10 pc job (053782). Then
I received 10 into inventory from that job. Later I issued 4 of the 10
from inventory to other jobs (1 was job # 204859-3-1). When the PDR
for the original job, 053782 is printed only 6 serial numbers appear
when the "Print Serial Numbers" box is checked. These are the ones
remaining in inventory. The 4 that were issued to the second job
disappeared. Since the premise of serial numbering is trace-ability,
it seems that this is a broken link. Has anyone experienced this and
if so is there an explanation other than the dreaded "Working as
Designed" from Epicor?
We have serial numbers and heat code suffixes combined in a character02
feild in our Vantage 6.1 system. Because Crystal treats the feild as
amemo we are having trouble splitting out the values so we can print
shipping labels. Any ideas?
I have never tried it (yet but soon will) so don't know the details but there is a technique for truncating memo fields to something like 128 characters in the database schema (I believe) or the definition that CR looks at. This allows it to be used in formulas but no longer allows as much data in the field to be accessed. I think Epicor has a knowledgebase article on it.
-Todd C.

-----Original Message-----
From: bkh156 [mailto:bkh156@...]
Sent: Thursday, August 25, 2005 9:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Serial Numbers


We have serial numbers and heat code suffixes combined in a character02
feild in our Vantage 6.1 system. Because Crystal treats the feild as
amemo we are having trouble splitting out the values so we can print
shipping labels. Any ideas?




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




SPONSORED LINKS
Technical <http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=D_JdAFeHAoeH6OugOKk1Yg> support Vantage <http://groups.yahoo.com/gads?t=ms&k=Vantage&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=8zJYQk3edGWFMUVgup9jKw> Database <http://groups.yahoo.com/gads?t=ms&k=Database&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=PnI9nhHllVsjEbHxRXs1IQ>
Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=fKR9gtx-Yh-u9MWSh0_-hA> management software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=Nu4StMQZ8LT26M5TzRGQlg> database software Church <http://groups.yahoo.com/gads?t=ms&k=Church+database+software&w1=Technical+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+database+software&w6=Church+database+software&c=6&s=148&.sig=UAiQi3Ftbp7Qnq6ys_yZxg> database software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]
In crystal 9 you do not have to do anything to the database

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, August 26, 2005 9:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Serial Numbers


I have never tried it (yet but soon will) so don't know the details but
there is a technique for truncating memo fields to something like 128
characters in the database schema (I believe) or the definition that CR
looks at. This allows it to be used in formulas but no longer allows as
much data in the field to be accessed. I think Epicor has a knowledgebase
article on it. -Todd C.

-----Original Message-----
From: bkh156 [mailto:bkh156@...]
Sent: Thursday, August 25, 2005 9:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Serial Numbers


We have serial numbers and heat code suffixes combined in a character02
feild in our Vantage 6.1 system. Because Crystal treats the feild as
amemo we are having trouble splitting out the values so we can print
shipping labels. Any ideas?




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




SPONSORED LINKS
Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&
w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+databas
e+software&w6=Church+database+software&c=6&s=148&.sig=D_JdAFeHAoeH6OugOKk1Yg
> support Vantage
<http://groups.yahoo.com/gads?t=ms&k=Vantage&w1=Technical+support&w2=Vantage
&w3=Database&w4=Database+management+software&w5=Membership+database+software
&w6=Church+database+software&c=6&s=148&.sig=8zJYQk3edGWFMUVgup9jKw>
Database
<http://groups.yahoo.com/gads?t=ms&k=Database&w1=Technical+support&w2=Vantag
e&w3=Database&w4=Database+management+software&w5=Membership+database+softwar
e&w6=Church+database+software&c=6&s=148&.sig=PnI9nhHllVsjEbHxRXs1IQ>
Database
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Technic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=fKR9gtx-Yh-
u9MWSh0_-hA> management software Membership
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Technic
al+support&w2=Vantage&w3=Database&w4=Database+management+software&w5=Members
hip+database+software&w6=Church+database+software&c=6&s=148&.sig=Nu4StMQZ8LT
26M5TzRGQlg> database software Church
<http://groups.yahoo.com/gads?t=ms&k=Church+database+software&w1=Technical+s
upport&w2=Vantage&w3=Database&w4=Database+management+software&w5=Membership+
database+software&w6=Church+database+software&c=6&s=148&.sig=UAiQi3Ftbp7Qnq6
ys_yZxg> database software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage>
" on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


_____




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




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