Bill of Lading Linked Pack DB location

Yahoo Archive
1
Thanks. I'll keep that in mind. I agree that the BOL screen isn't real great, but we are looking to link multiple packing slips to a single BOL.



--- In vantage@yahoogroups.com, "Vic Drecchio" <vic.drecchio@...> wrote:
>
> Are you trying to create a BOL?
>
> Here’s what I’ve always done....... move the “BOL” to the Customer Shipment Screen.
>
> Meaning, modify your PackSlip RDD and create the BOL from there. The default BOL form is horrible and that hole BOL entry screen is clunky, IMO.
>
> I always have BOL’s as a Report Style within the Customer Shipment Entry screen. Works like a charm.
>
> From: carson251
> Sent: Thursday, January 12, 2012 12:22 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Bill of Lading Linked Pack DB location
>
>
> Yes. I'm trying to use the shipping tables on custom BOL reports, but I can't figure out how to link the BOL tables to the shipping tables. The screen displays the the linked packing slip numbers, but under technical details it does not give the DB location of that info.
>
> --- In mailto:vantage%40yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > If I understand your post...
> > I use the shipping tables on a couple of custom BOL reports, ShipHead and ShipDtl.
> >
> > --- In mailto:vantage%40yahoogroups.com, "carson251" <carsonepicor@> wrote:
> > >
> > > Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.
> > >
> > > Thanks
> > >
> > >
> > > Carson
> > >
> >
>
>
>
>
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2012.0.1901 / Virus Database: 2109/4738 - Release Date: 01/12/12
>
>
> [Non-text portions of this message have been removed]
>
2
Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.

Thanks


Carson
3
Not 100% sure, but sniff around the two tables, masterpack, and masterpackdtl.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of carson251
Sent: Wednesday, January 11, 2012 2:35 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Bill of Lading Linked Pack DB location



Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.

Thanks

Carson



[Non-text portions of this message have been removed]
4
Scratch that...incorrect information.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Wednesday, January 11, 2012 7:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Bill of Lading Linked Pack DB location



Not 100% sure, but sniff around the two tables, masterpack, and masterpackdtl.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...<mailto:1.234354861%40web65412.mail.ac4.yahoo.com>]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of carson251
Sent: Wednesday, January 11, 2012 2:35 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Bill of Lading Linked Pack DB location

Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.

Thanks

Carson

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



[Non-text portions of this message have been removed]
5
If I understand your post...
I use the shipping tables on a couple of custom BOL reports, ShipHead and ShipDtl.

--- In vantage@yahoogroups.com, "carson251" <carsonepicor@...> wrote:
>
> Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.
>
> Thanks
>
>
> Carson
>
6
Yes. I'm trying to use the shipping tables on custom BOL reports, but I can't figure out how to link the BOL tables to the shipping tables. The screen displays the the linked packing slip numbers, but under technical details it does not give the DB location of that info.

--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> If I understand your post...
> I use the shipping tables on a couple of custom BOL reports, ShipHead and ShipDtl.
>
> --- In vantage@yahoogroups.com, "carson251" <carsonepicor@> wrote:
> >
> > Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.
> >
> > Thanks
> >
> >
> > Carson
> >
>
7
Are you trying to create a BOL?

Here’s what I’ve always done....... move the “BOL” to the Customer Shipment Screen.

Meaning, modify your PackSlip RDD and create the BOL from there. The default BOL form is horrible and that hole BOL entry screen is clunky, IMO.

I always have BOL’s as a Report Style within the Customer Shipment Entry screen. Works like a charm.

From: carson251
Sent: Thursday, January 12, 2012 12:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Bill of Lading Linked Pack DB location


Yes. I'm trying to use the shipping tables on custom BOL reports, but I can't figure out how to link the BOL tables to the shipping tables. The screen displays the the linked packing slip numbers, but under technical details it does not give the DB location of that info.

--- In mailto:vantage%40yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> If I understand your post...
> I use the shipping tables on a couple of custom BOL reports, ShipHead and ShipDtl.
>
> --- In mailto:vantage%40yahoogroups.com, "carson251" <carsonepicor@> wrote:
> >
> > Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.
> >
> > Thanks
> >
> >
> > Carson
> >
>




No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1901 / Virus Database: 2109/4738 - Release Date: 01/12/12


[Non-text portions of this message have been removed]
8
The ShipHead table has fields for the BOL if that helps.

--- In vantage@yahoogroups.com, "carson251" <carsonepicor@...> wrote:
>
> Yes. I'm trying to use the shipping tables on custom BOL reports, but I can't figure out how to link the BOL tables to the shipping tables. The screen displays the the linked packing slip numbers, but under technical details it does not give the DB location of that info.
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> >
> > If I understand your post...
> > I use the shipping tables on a couple of custom BOL reports, ShipHead and ShipDtl.
> >
> > --- In vantage@yahoogroups.com, "carson251" <carsonepicor@> wrote:
> > >
> > > Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.
> > >
> > > Thanks
> > >
> > >
> > > Carson
> > >
> >
>
9
Vic, you don’t like the BOL entry form? I thought that thing worked pretty great… your opinion sucks..


Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Thursday, January 12, 2012 11:46 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Bill of Lading Linked Pack DB location



Are you trying to create a BOL?

Here’s what I’ve always done....... move the “BOL” to the Customer Shipment Screen.

Meaning, modify your PackSlip RDD and create the BOL from there. The default BOL form is horrible and that hole BOL entry screen is clunky, IMO.

I always have BOL’s as a Report Style within the Customer Shipment Entry screen. Works like a charm.

From: carson251
Sent: Thursday, January 12, 2012 12:22 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Bill of Lading Linked Pack DB location

Yes. I'm trying to use the shipping tables on custom BOL reports, but I can't figure out how to link the BOL tables to the shipping tables. The screen displays the the linked packing slip numbers, but under technical details it does not give the DB location of that info.

--- In mailto:vantage%40yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> If I understand your post...
> I use the shipping tables on a couple of custom BOL reports, ShipHead and ShipDtl.
>
> --- In mailto:vantage%40yahoogroups.com, "carson251" <carsonepicor@> wrote:
> >
> > Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.
> >
> > Thanks
> >
> >
> > Carson
> >
>

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1901 / Virus Database: 2109/4738 - Release Date: 01/12/12

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



[Non-text portions of this message have been removed]
10
Thanks! That's exactly what I was looking for. The BOL link is stored in ShipHead:BOLNum and ShipHead:BOLLine.



--- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...> wrote:
>
> The ShipHead table has fields for the BOL if that helps.
>
> --- In vantage@yahoogroups.com, "carson251" <carsonepicor@> wrote:
> >
> > Yes. I'm trying to use the shipping tables on custom BOL reports, but I can't figure out how to link the BOL tables to the shipping tables. The screen displays the the linked packing slip numbers, but under technical details it does not give the DB location of that info.
> >
> > --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@> wrote:
> > >
> > > If I understand your post...
> > > I use the shipping tables on a couple of custom BOL reports, ShipHead and ShipDtl.
> > >
> > > --- In vantage@yahoogroups.com, "carson251" <carsonepicor@> wrote:
> > > >
> > > > Does anyone know how the linked pack is stored in the BOL table? It doesn't appear to be in the BOLHed or BOLDtl.
> > > >
> > > > Thanks
> > > >
> > > >
> > > > Carson
> > > >
> > >
> >
>