Help with RB report - Vendor Price Effective Dates

Hi All,

I am hoping someone can help. I am working on a report for specific
parts from the part master files. I am linking as follows

Company -> Part
Part -> VendPart

I want this report to pull the base unit price from the pimary
vendor. If there is more than one price from this vendor(eg. price
increase somewhere along the way) I only want the base unit price
from the most recent effective date.

1. I can't find the table/field where the primary vendor is stored

2. How do I go about limiting the base unit cost to the most recent
effective date for a vendor?

ver 5.1.131


Thanks very much,


Kim Trapp
Hawk Technology Ltd