RB: Parts with no Vendor

Yahoo Archive
1
I will try it. Thanks!


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Michael D. Howard
Sent: Friday, May 20, 2005 2:51 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB: Parts with no Vendor


Would PartPlant.VendorNum give you a way to go?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Juliet Martin
Sent: Friday, May 20, 2005 2:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB: Parts with no Vendor


I am trying to run a report to find parts in a certain class that have no
vendors set up. In Data Dictionary it says the Vendor field in Part Tran is
initial set to 0. I have tried ?, 0. No luck. Does anyone know how to
query what isn't there?

Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217



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











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
2
I am trying to run a report to find parts in a certain class that have no vendors set up. In Data Dictionary it says the Vendor field in Part Tran is initial set to 0. I have tried ?, 0. No luck. Does anyone know how to query what isn't there?

Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217
3
Would PartPlant.VendorNum give you a way to go?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Juliet Martin
Sent: Friday, May 20, 2005 2:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RB: Parts with no Vendor


I am trying to run a report to find parts in a certain class that have no
vendors set up. In Data Dictionary it says the Vendor field in Part Tran is
initial set to 0. I have tried ?, 0. No luck. Does anyone know how to
query what isn't there?

Juliet Martin
Information Manager
Rosenboom Machine & Tool, Inc.
Sheldon, IA 51201
712-324-4854 x1217



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