12-Month Gross Profit by Preferred Vendor
This application creates a rolling 12-month gross profit report by preferred vendor ID (from part maintenance) and customer ID (from the customer order).
Description
The resulting data is automatically opened in Excel for analysis.
The columns that are output are:
- Customer ID
- Sold To Name
- Sales Rep ID
- Customer UDF 1
- Bill To City, State, Zip
- Customer Phone
- Total $ for all open sales orders
- Total sales $ for all vendors
- Total profit $ for all vendors
- Total profit % for all vendors
- Period 1 sales $ for the selected vendor
- Period 1 profit $ for the selected vendor
- Period 1 profit % for the selected vendor
- 12 periods total are printed with this same data along with grand total columns
Screenshots
