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
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