Actually, the problem is caused by having a relatively complex join
involving three different tables (BOLHead, Customer and Vendor). They do
this to show you all the information you need to identify the right BOL.
Personally, I think that they need to bend the rules of normalization a bit
and put the relevant fields in the BOLHead table even if it means
duplicating the data (after all, it wouldn't be the first time they've done
it). But then, Epicor hasn't been interested much in my opinion in the past
and I doubt that's likely to change anytime soon.
For those of you who don't speak Geek, normalization deals with how data is
stored in tables and when you should break up a table into two or more
related tables. Boring stuff unless you are intimately involved in the
design/implementation of database schemas.
================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, September 21, 2000 3:02 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Archive Bill Of Lading
My Groups | vantage Main Page | Start a new group!
This sounds like a database indexing problem not a data archive issue.
Patrick
-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Thursday, September 21, 2000 02:08 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Archive Bill Of Lading
I second that. I've held back from implementing Bills of lading because I
have 3-4 years of shipments that it has to grind through, and it takes
more
than 30 or 40 seconds. At first I thought the system had locked up it
took
so long.
Shirley H. Graver
Systems Administrator
Rubber Associates Inc. (Certified to QS9000/ISO9002)
Cleveland/Akron, Ohio
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
[Non-text portions of this message have been removed]
involving three different tables (BOLHead, Customer and Vendor). They do
this to show you all the information you need to identify the right BOL.
Personally, I think that they need to bend the rules of normalization a bit
and put the relevant fields in the BOLHead table even if it means
duplicating the data (after all, it wouldn't be the first time they've done
it). But then, Epicor hasn't been interested much in my opinion in the past
and I doubt that's likely to change anytime soon.
For those of you who don't speak Geek, normalization deals with how data is
stored in tables and when you should break up a table into two or more
related tables. Boring stuff unless you are intimately involved in the
design/implementation of database schemas.
================
Steve Sanders
Delta Centrifugal Corp.
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, September 21, 2000 3:02 PM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] Archive Bill Of Lading
My Groups | vantage Main Page | Start a new group!
This sounds like a database indexing problem not a data archive issue.
Patrick
-----Original Message-----
From: Shirley Graver [mailto:shirleyg@...]
Sent: Thursday, September 21, 2000 02:08 PM
To: vantage@egroups.com
Subject: RE: [Vantage] Archive Bill Of Lading
I second that. I've held back from implementing Bills of lading because I
have 3-4 years of shipments that it has to grind through, and it takes
more
than 30 or 40 seconds. At first I thought the system had locked up it
took
so long.
Shirley H. Graver
Systems Administrator
Rubber Associates Inc. (Certified to QS9000/ISO9002)
Cleveland/Akron, Ohio
We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go
to www.egroups.com, login and be sure to save your password, choose My
Groups, choose Vantage, then choose Files. If you save the password, the
link above will work the next time you try it.)
[Non-text portions of this message have been removed]