Primary Vendor / Preferred supplier report

Thanks for the help, yes PartPlant was the one I wanted. I thought the
checkbox would be controlling some boolean value somewhere, but it
seems to update the PartPlant table with the actual vendor num.

Cheers again,

Jonny
Hi All,

We are currently running Vantage 4.0, Progress 9.0B and I can't work
out which tables I need for my report.
In Part file maintenance, price list..., supplier price break
maintenance... If you update/add a supplier there is a check box which
is labeled "Primary supplier".

I want to be able to print a very simple report which has Part number
and its primary(preferred) supplier.

Does anyone know where I might find this field, or is it something
custom that we've had added to our database that exists in a user
defined field somewhere? (I've only been at the company a year and the
Vantage installation is over 5 years old).

Cheers,

Jonny
Hi Jonny,

We're on 6.1, don't know if the tables have changed, but on our system
I'd look at the PartPlant table.

As a hint, from the vantage screen, try right-clicking and choose
Control List from the pop-up, you can often figure out the table you are
looking for.

SQL statement follows:

SELECT dbo.tblPart.PartNum, dbo.tblPart.PartDescription,
dbo.tblVendor.VendorID, dbo.tblVendor.Name
FROM dbo.tblPartPlant INNER JOIN
dbo.tblPart ON dbo.tblPartPlant.Company =
dbo.tblPart.Company AND dbo.tblPartPlant.PartNum = dbo.tblPart.PartNum
INNER JOIN
dbo.tblVendor ON dbo.tblPartPlant.Company =
dbo.tblVendor.Company AND dbo.tblPartPlant.VendorNum =
dbo.tblVendor.VendorNum CROSS JOIN
dbo.qryPoAllPosPartVendorInformation

Best of luck,

Steve

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of jonnyfatman666
Sent: Tuesday, February 28, 2006 6:38 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Primary Vendor / Preferred supplier report

Hi All,

We are currently running Vantage 4.0, Progress 9.0B and I can't work
out which tables I need for my report.
In Part file maintenance, price list..., supplier price break
maintenance... If you update/add a supplier there is a check box which
is labeled "Primary supplier".

I want to be able to print a very simple report which has Part number
and its primary(preferred) supplier.

Does anyone know where I might find this field, or is it something
custom that we've had added to our database that exists in a user
defined field somewhere? (I've only been at the company a year and the
Vantage installation is over 5 years old).

Cheers,

Jonny





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