Link question getting Part Revs

Yahoo Archive
1
you could sort partrev by effectivedate descending, and make a formula to
see if the partrev you are looking at is the first one you see.

make the following formula (exact syntax depends on if your using RB or
Crystal):
previous(partrev.partnum> <> partnum

and filter out all the ones for which that formula returns false.

That's what I'd use to just display a list of the latest revs. However,
inserting this logic into your already complex report will slow it WAY down.

If your using crystal, you could do a dbf export of the latest part revs and
link to that.

-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Tuesday, September 04, 2001 8:40 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Link question getting Part Revs


We unapprove old revisions, then you could filter on just approved ones.

Patrick

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 04, 2001 8:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Link question getting Part Revs


Hope everyone had a good 'non-labor' weekend.

I've written a report to audit Parts with incorrect Standard Costs. (We just
converted to Standard Cost this weekend).

The basic report links the PART table with PARTBIN and works fine.

Now I want to see where each part is used (Top Level): So I link to the
PartMtl to the Part table (link on Company field, and also link from
Part.PartNum to PartMtl.MtlPartNum.
The problem is that now I get a line for every revision of the
TopLevelPartNumber. How do I link so that I just get the most recent
revision from the PartMtl table?

Troy Funte
Liberty Electronics



[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

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



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/
2
Hope everyone had a good 'non-labor' weekend.

I've written a report to audit Parts with incorrect Standard Costs. (We just converted to Standard Cost this weekend).

The basic report links the PART table with PARTBIN and works fine.

Now I want to see where each part is used (Top Level): So I link to the PartMtl to the Part table (link on Company field, and also link from Part.PartNum to PartMtl.MtlPartNum.
The problem is that now I get a line for every revision of the TopLevelPartNumber. How do I link so that I just get the most recent revision from the PartMtl table?

Troy Funte
Liberty Electronics



[Non-text portions of this message have been removed]
3
We unapprove old revisions, then you could filter on just approved ones.

Patrick

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 04, 2001 8:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Link question getting Part Revs


Hope everyone had a good 'non-labor' weekend.

I've written a report to audit Parts with incorrect Standard Costs. (We just
converted to Standard Cost this weekend).

The basic report links the PART table with PARTBIN and works fine.

Now I want to see where each part is used (Top Level): So I link to the
PartMtl to the Part table (link on Company field, and also link from
Part.PartNum to PartMtl.MtlPartNum.
The problem is that now I get a line for every revision of the
TopLevelPartNumber. How do I link so that I just get the most recent
revision from the PartMtl table?

Troy Funte
Liberty Electronics



[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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
4
Thanks, Patrick. That looks like the best route at this point. Checking only approved (PartRev) revisions shortened things up quite a bit. We'll have a few parts to clean up in the process.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Winter, Patrick
To: 'vantage@yahoogroups.com'
Sent: Tuesday, September 04, 2001 9:40 AM
Subject: RE: [Vantage] Link question getting Part Revs


We unapprove old revisions, then you could filter on just approved ones.

Patrick

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Tuesday, September 04, 2001 8:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Link question getting Part Revs


Hope everyone had a good 'non-labor' weekend.

I've written a report to audit Parts with incorrect Standard Costs. (We just
converted to Standard Cost this weekend).

The basic report links the PART table with PARTBIN and works fine.

Now I want to see where each part is used (Top Level): So I link to the
PartMtl to the Part table (link on Company field, and also link from
Part.PartNum to PartMtl.MtlPartNum.
The problem is that now I get a line for every revision of the
TopLevelPartNumber. How do I link so that I just get the most recent
revision from the PartMtl table?

Troy Funte
Liberty Electronics



[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

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


Yahoo! Groups Sponsor
ADVERTISEMENT

Gender:
Female
Male
Weight:
lbs. kg.









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 the Yahoo! Terms of Service.



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