- Go to Sales > Pricing > Price Contract Report.
- On the Price Contract Report pop-up that appears, select options to build your custom report with the data you want to see.
- Under File, choose whether you want to include Current prices and costs or Future prices and costs.
- If you want to set of range of dates, choose either Effective or Expiration, and then choose the Starting and End date. If you want to view pricing information from all dates, leave this section blank.
- You can further narrow the data set by choosing a Vendor, Salesman, and/or Customer on which to report. If you choose a Salesman, then all customers associated with that salesman will appear. Note that these fields are not filters; they are independent of one another. So if you choose
- Vendor=AAA Wholesale
- Salesman=Fred
- Customer=ABC
- Choose how you want to sort the contract, Sort By–Contract number, Vendor number, Salesman code, or Customer number.
- To include Customer names and numbers in the report, select the Show Customers check box.
- To include price overrides as well as net price and formula for each product, select the Show Price Overrides check box.
- To include each individual product within a contract, select the Show Products check box.
- To show only current contracts, excluding those that have expired and those that have future dates, select the Exclude Expired Contract and Future Entered check box.
- To print each contract on an individual page, select the Contract Page Break check box.
- To include only contracts with net prices, excluding those with rebates, select the Price Only Contracts check box.
- Click Run.
Then your report will contain all pricing associated with Vendor AAA, and all customers of Salesman Fred, and Customer ABC, regardless of whether that customer is associated with Salesman Fred.
If you sort by Customer, may sure you select the Show Customers check box.