Printing out bar codes

Hello,
I have a few questions about printing out barcodes. I am trying to
print out bar codes in crysatal Report, i want the bar code to pull
from vantage. I am using a user defined field I called BIN ID. Wayne
helped me find the tables for the user defined field. I have 3 other
bar codes set up in which use the formula:

"*" + {OrderHed.UserChar1} + "*"
In Vantage I have have a user defined field set up in sys utileties>
company confirguraton> Module configuration>>inventory management>
User field1 its called BIN ID. So,under my test part number in the
BIN ID field I added the numbers 123456789. When I open crystal
reports I tried to export my test order from Vantage to crystal and
everything pulled into the bar code (PO#, Part#,Qty)everyhting looks
right on the form. If any one has any ideas please help.
Thanks,

Pete Juratovic
Sabina Manufacturing
Hello,
I am trying to print out a bar code in Crystal for a user defined
feild in Vantage that I called Bin ID. (Part File
Mateince>usersfields and I named it Bin ID)Im not sure in Crystal how
to write the formula for this barcode.Im not sure what table the user
definded field is in. Is it always under the same table or how can I
checek? I have 3 other bar codes setup in Crystal allready. PO#,
Part#, QTY.
Im gonna edit the PO# bar code. It looks like this:

"*" + {OrderHed.PONum} + "*"
If anyone out there uses vantage and can help me I would really
appreciate it. Thank you,
PETE
As far as bar codes go, I just did this. Right click the field and click
format field. Click the FONT tab. Click the down arrow for FONT and
find "DataWorks Bar 39". Click it. You can then select the size of
the bar code. Hope this helps....

Gary L. Kacher
Database Manager
Giddens Industries
glk@...


----------
From: juratovic15@...
Reply To: vantage@yahoogroups.com
Sent: Wednesday, September 19, 2001 10:23 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Printing out bar codes

Hello,
I am trying to print out a bar code in Crystal for a user defined
feild in Vantage that I called Bin ID. (Part File
Mateince>usersfields and I named it Bin ID)Im not sure in Crystal how
to write the formula for this barcode.Im not sure what table the user
definded field is in. Is it always under the same table or how can I
checek? I have 3 other bar codes setup in Crystal allready. PO#,
Part#, QTY.
Im gonna edit the PO# bar code. It looks like this:

"*" + {OrderHed.PONum} + "*"
If anyone out there uses vantage and can help me I would really
appreciate it. Thank you,
PETE



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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



[Non-text portions of this message have been removed]
At 01:23 PM 9/19/2001 , you wrote:
> I am trying to print out a bar code in Crystal for a user defined field
> in Vantage that I called Bin ID. (Part File Maintenace > usersfields and
> I named it Bin ID)
>Im not sure what table the user definded field is in. Is it always under
>the same table

Is this one of the standard forms you're working with? Or a report you
developed to run via ODBC?

Those user defined fields are in the Part table as UserChar1 thru UserChar4.

If you're working with the standard forms however, they might not even be
in the exported DBF files, or the names may be different. Eg: in the PO
form they are in PODetail.PartUDChr1 thru 4.

Ever messed with VB Forms at all? They give you more fields to play with,
and you can put together a lot cleaner looking screens than what the
old-style user defined fields provide.

-Wayne Cox
Wayne,
Im kinda new at all this. We have to start the ODBC to
run Crystal.In vantage I went to the system
Utilites>>Company Configuration>>picked our
company>>Module configuration>>Inventory
Management>>Field 1 BIN ID>> Then under the date field
I put date costed. Now does that mean that the user
defined field would be UserChar1 because its the first
field? and when I go to crystal i can pick UserChar1
from the list of fields it looks like this when I
select it from the field but when I try to check it,
it gives the error field name not known:
"*" + {{OrderHed.UserChar1}} + "*"
Im just learning Crystal Reports and Report building
so it gets a little confusing sometimes.If you can hel
please do.
Thanks,
Pete
--- Wayne Cox <wmc@...> wrote:
> At 01:23 PM 9/19/2001 , you wrote:
> > I am trying to print out a bar code in Crystal
> for a user defined field
> > in Vantage that I called Bin ID. (Part File
> Maintenace > usersfields and
> > I named it Bin ID)
> >Im not sure what table the user definded field is
> in. Is it always under
> >the same table
>
> Is this one of the standard forms you're working
> with? Or a report you
> developed to run via ODBC?
>
> Those user defined fields are in the Part table as
> UserChar1 thru UserChar4.
>
> If you're working with the standard forms however,
> they might not even be
> in the exported DBF files, or the names may be
> different. Eg: in the PO
> form they are in PODetail.PartUDChr1 thru 4.
>
> Ever messed with VB Forms at all? They give you
> more fields to play with,
> and you can put together a lot cleaner looking
> screens than what the
> old-style user defined fields provide.
>
> -Wayne Cox
>
>
>
>


__________________________________________________
Terrorist Attacks on U.S. - How can you help?
Donate cash, emergency relief information
http://dailynews.yahoo.com/fc/US/Emergency_Information/