Report Requirement

Yahoo Archive
1
When I create the join and select LOG Number, the BOL Number
disappears and is not an option.

--- In vantage@yahoogroups.com, "Shirley Graver" <shirleyg@R...>
wrote:
> Link from your LOG number in your packing slip to your BOL number.
>
> Shirley Graver
> Systems Administrator
> Rubber Associates Inc.
>
> -----Original Message-----
> From: Todd Hofert [mailto:todd@s...]
> Sent: Tuesday, January 13, 2004 12:41 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Report Requirement
>
>
>
>
> > I have been asked to create a report for a customer that shows all
> > orders for this customer including PO Number and the weight of the
> > shipment as listed on the Bill of Lading. I cannot figure out how
to
> > get both the BOLDetail.Weight field AND the Customers PO Number
on the
> > same report. I cannot figure out how the Bill of Lading and the
Pack
> > Slip are linked together. Please help.
> >
> > Thank You
> >
> > Todd Hofert
> >
>
>
> [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/.
> <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
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
> * 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
> <http://docs.yahoo.com/info/terms/> Service.
>
> Tracking #: 6377DB7C248EC648B32D51B23B1916B756D7A874
>
>
> [Non-text portions of this message have been removed]
2
> I have been asked to create a report for a customer that shows all
> orders for this customer including PO Number and the weight of the
> shipment as listed on the Bill of Lading. I cannot figure out how to
> get both the BOLDetail.Weight field AND the Customers PO Number on the
> same report. I cannot figure out how the Bill of Lading and the Pack
> Slip are linked together. Please help.
>
> Thank You
>
> Todd Hofert
>


[Non-text portions of this message have been removed]
3
Link from your LOG number in your packing slip to your BOL number.

Shirley Graver
Systems Administrator
Rubber Associates Inc.

-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Tuesday, January 13, 2004 12:41 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Requirement




> I have been asked to create a report for a customer that shows all
> orders for this customer including PO Number and the weight of the
> shipment as listed on the Bill of Lading. I cannot figure out how to
> get both the BOLDetail.Weight field AND the Customers PO Number on the
> same report. I cannot figure out how the Bill of Lading and the Pack
> Slip are linked together. Please help.
>
> Thank You
>
> Todd Hofert
>


[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/.
<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
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* 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
<http://docs.yahoo.com/info/terms/> Service.

Tracking #: 6377DB7C248EC648B32D51B23B1916B756D7A874


[Non-text portions of this message have been removed]
4
Try using CustNum, ShipToNum, ShipDate to link Orders to BOL's. Skip the
Packing Slip.
Good luck. (No Indexes in the BOLHEAD table to speed up the report.)

Patrick Winter


-----Original Message-----
From: Todd Hofert [mailto:todd@...]
Sent: Tuesday, January 13, 2004 11:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Report Requirement





> I have been asked to create a report for a customer that shows all
> orders for this customer including PO Number and the weight of the
> shipment as listed on the Bill of Lading. I cannot figure out how to
> get both the BOLDetail.Weight field AND the Customers PO Number on the
> same report. I cannot figure out how the Bill of Lading and the Pack
> Slip are linked together. Please help.
>
> Thank You
>
> Todd Hofert
>


[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

To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

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