Primary Vendor / Preferred supplier report

Yahoo Archive
1
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
2
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
3
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