Description: Looking for a report that could provide the vendor contract and unit cost of an item using the logic in the PO process - which factors in vendor agreement participant and vendor agreement priority. This information is needed to help determine pricing for a particular location on a large scale for reporting and helps to evaluate our pricing index.
Work Around: Currently, we pull a full item/contract listing and try to match the appropriate vendor agreement (PO25) based on participant company and sorting of vendor agreement priority. It is a very manual process and does not always provide the best results based on the intricacies of some of our vendor agreements.
Proposed Solution: A report screen that determines the vendor agreement and calculates unit cost pricing for an item based on a company and/or location settings.