DB2 Custom Reports
MainDB2eServeOrder 3eViewOther ProductsSharewareNewsCustomer
Optional Custom Reports for DB2!
These optional custom reports get the most from your DB2! All the reports and outputs contained on this page are part of the same and easy to use database. Use the user friendly interface to pick and choose the output you need! You can use these reports 'as-is' or customize them anyway you choose. Professionally designed by Carol Brown, these reports and outputs show what you can do with DB2 on your team!
Customer Usage Reports:
Usage Report Request Form:
The Custom Reports Database comes with a request form to simplify usage report requests. Click the heading link for a sample of this form.
Customer Usage By Sales Dollars:
This customer usage report ranks items by total (extended) sales dollars. Click the heading link for a sample of this report.
Customer Usage By Department By Sales Dollars:
This customer usage report also ranks by sales dollars except it groups and totals by customer department. Click the heading link for a sample of this report.
Customer Usage by Department By Manufacturer:
Similar to the Customer Usage By Department above, this report sorts by manufacturer prefix within a department. Click the heading link for a sample of this report.
Departmental Usage With List and Discount:
This customer usage report includes both the list price and the customer discount. Click the heading link for a sample.
Usage Report Sorted by Manufacturer:
This customer usage report is sorted by manufacturer prefix. Click the heading link for a sample.
Customer Usage With List and Discount:
This report, similar to the departmental usage with list and discount, does not group or total by department. Click the heading link for a sample.
Sales Analysis Reports:
Company Summary by Discount Type:
This report shows a quick view of exactly what is happening with your pricing. Totaled by price type code you can quickly spot problem areas and address them before they become major issues! Click the heading link for a sample of this report.
Customer Profit Summary by Price Type:
This companion to the company summary by price type details how individual customers are being priced. Increase customer profitability by close monitoring of pricing practices with this report!
Customer Purchases of Top 25 Items:
This valuable report shows exactly what any individual customer is buying from your top 25 items. Click the heading link for a sample of this report.
Daily Sales and Line Count Report:
Use this report to track, day by day, how sales are stacking up. Never get caught in the dark again! Click the heading link for a sample of this report.
Internet VS Non-Internet Sales:
This quick look report details how your Internet business is performing. Click the heading link for a sample of this report.
Sales Analysis Excel Outputs:
Included in this custom DB2 database are several sales analysis output queries designed to export to Excel. You will need Excel to view these samples.
Contract Detail Output:
This output provides contract detail in an easy to use Excel format. Click the heading link for a sample of this output file.
Contract Item Totals with Current Cost:
This detailed contract output provides essential information for analyzing your contracts! Click the heading link for a sample output file.
Customers Who Have Not Purchased:
This important output file contains a list of customers that have not purchased in the number of days you specify. Click the heading link for a sample output file.
Item Manufacturer Usage Totals:
This valuable output is essential to better purchasing. Showing quantities and profits this output is 'Required Reading' before direct buy purchases. Click the heading link for a sample output file.
Month to Date Sales Rep Totals:
This output shows each sales rep and their total sales for the month. Click the heading link for a sample.
Order Detail For Low Margin Items:
This output shows items sales reps are selling below cost or lower than a margin you specify. Click the heading link for a sample output file.
Top 200 Items By Hits:
This output shows your top 200 items ranked by the number of hits. Click the heading link for a sample.
Top 200 Items By GP Dollars:
This output also shows your top 200 items but ranked by gross profit dollars. Click the heading link for a sample.
Top 200 Items By Sales Dollars:
This output again shows your top 200 items but ranked by total sales dollars. Click the heading link for a sample.
Shared Bottom Border

Home Contact Products Order
Survey Customer Events Resources
eOrder  eNside  eForms  eView
DB2  eOffice  eXpand  eServ  eShare
Most Popular Destinations:
eOrder On-Line Demonstration  Sample eForm Demonstration
eView On-Line Demonstration  eServ On-Line Demonstration
eOffice Contract Manager Download Page
eXpand Laundry List Editor  eXpand Sales Data Mine
eShare Journal Edit  eShare Contract Janitor
OPSoftware is Exclusively Marketed By:
Prop Solutions, Ltd.
32 Saint Aurics Drive
Suwanee, GA 30024
770-633-3232
Rick Marlette
OPSoftware is the trade name for a suite of software products created by Prop Solutions, Ltd. Prop Solutions, Ltd. and other authorized independent agents support OPSoftware products.