Bill of Lading - Adding packing slips

In Crystal you can link the BOLHead.BOLNum to the ShipHead.ShipLog in the
visual linking screen. Accept the error that tells you the fields are
different types and exit. Next go to Database and Show SQL Query. Edit
BOLHead.BOLNum to show string(BOLHead.BOLNum) and it should work fine.

Michael



> -----Original Message-----
> From: esmalley@...
> [mailto:esmalley@...]
> Sent: Tuesday, September 25, 2001 4:05 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Bill of Lading - Adding packing slips
>
>
> Darren,
>
> In 3.0 the link was bewteen the BOL # and the Log field on the Pack
> Slips. The BIG problem is the BOL # is numeric and the Log field is
> alphanumeric which make it impossile to link them in Cyrstal or
> Report Builder. As I recall in testing 5.0, nothing had changed.
>
> Erik Smalley
> IT Manager
> Milford Enterprises Inc.
>
> --- In vantage@y..., Darren Mann <dmann@m...> wrote:
> > Is there a means of linking additional packing slips to a
> previously created
> > BOL?
> >
> > Is there a way to print linked packing slip #'s on BOL? I can not
> find a
> > link between the data structure to create the needed report and of
> course
> > they are not included in the .dbf files for the BOL report.
> >
> > Is anyone else tired of the slow delay to search for BOL's? This
> has been a
> > problem since 3.0 but nothing gets done. This area of the program
> could use
> > a lot of revamping but apparently it is not used by the larger
> Vantage
> > users.
> >
> >
> > Thanks for any assistance.
> >
> > Darren Mann
> > Miller Products Co.
>
>
>
> 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/
Is there a means of linking additional packing slips to a previously created
BOL?

Is there a way to print linked packing slip #'s on BOL? I can not find a
link between the data structure to create the needed report and of course
they are not included in the .dbf files for the BOL report.

Is anyone else tired of the slow delay to search for BOL's? This has been a
problem since 3.0 but nothing gets done. This area of the program could use
a lot of revamping but apparently it is not used by the larger Vantage
users.


Thanks for any assistance.

Darren Mann
Miller Products Co.
Darren,

In 3.0 the link was bewteen the BOL # and the Log field on the Pack
Slips. The BIG problem is the BOL # is numeric and the Log field is
alphanumeric which make it impossile to link them in Cyrstal or
Report Builder. As I recall in testing 5.0, nothing had changed.

Erik Smalley
IT Manager
Milford Enterprises Inc.

--- In vantage@y..., Darren Mann <dmann@m...> wrote:
> Is there a means of linking additional packing slips to a
previously created
> BOL?
>
> Is there a way to print linked packing slip #'s on BOL? I can not
find a
> link between the data structure to create the needed report and of
course
> they are not included in the .dbf files for the BOL report.
>
> Is anyone else tired of the slow delay to search for BOL's? This
has been a
> problem since 3.0 but nothing gets done. This area of the program
could use
> a lot of revamping but apparently it is not used by the larger
Vantage
> users.
>
>
> Thanks for any assistance.
>
> Darren Mann
> Miller Products Co.