DB2 Sample Reports
DB2 Sales Rep Module:
Sales reps are integral parts of your business. Knowing how they are performing on a day by day or hour by hour basis can uncover minor problems before they become major ones.
Sales Rep Summary Chart
This chart format report shows total sales by sales rep over the number of days you specify. Perfect for motivation, performance at a glance, and comparison purposes. Utilizing your sales history, you can specify as many, or as few days to include. See your sales reps performance charted for this week, this month, this year, or any number of days. Use this chart anytime you want a snapshot in time of sales by sales rep. Click the heading link for a sample of this chart.
DB2 Customer Module:
The DB2 Customer Database contains all the information from 17 separate DDMS customer files in one easy to use database.
Customer Profit Summary Report
This report by sales rep shows ALL the different pricing combinations and the results on profit for each customer and department with sales over a specified number of days. Verify the different pricing methods used by customer and even differences within a department. Use this report anytime you want to check on pricing practices and how they affect your bottom line. Click the heading link for a sample of this report.
DB2 Accounts Receivable Module:
Efficient accounts receivable collection is one clear way to increase your bottom line. Below are some samples of the FREE reports included in DB2 Accounts Receivable.
A/R Summary Chart
This chart format report shows where you stand, day by day, on your accounts receivable. You specify any start and end days, 30-45, 28-62, 45-55, ANY range. The report charts the open accounts receivable balance for each day between the values you enter, ready to print. Use this chart daily to monitor your accounts receivable aging at a glance. Click the heading link for a sample of this chart.
A/R Customer Summary by Day Report
The A/R Customer Summary by Day report is a companion to the A/R Summary Chart. When unusually high balances appear for a particular day, you can use this report to ‘see’ who the customers are. This summary report asks for the start and end days and then reports each customer, one per line, that has open invoices falling within the day range you specify. For example, if you enter 45 as the start day, and 90 as the end day, then only those customers with open invoices between 45 and 90 days will be listed. Customers are output by department on a single line with the highest amount shown first on the report. Use this fast and compact summary report to spot potential problem accounts before they become actual problem accounts. Click the heading link for a sample of this report.
A/R Customer Summary Report
The A/R Customer Summary report is a companion to the A/R Customer Summary by Day report. This report details a single customer. When potential problem accounts are identified through the A/R Customer Summary by Day report, you can then run this report for more detailed information. The report asks for the customer number and the minimum number of days. Use this fast customer report to view past dues showing the invoice numbers, debits, credits, and balances on an invoice-by-invoice basis. Click the heading link for a sample of this report.
AR-Floating Column Summary Trial Balance
This single-line-per-customer trial balance allows you to pick a middle floating column to age. For example, if you pick 40 as the starting days and 50 as the ending days, the report groups and totals your accounts receivable in four columns: Less than 40 days, between 40 and 50 days, over 50 days, and a total balance column. This fast summary report is excellent for spotting problems before they become disasters. Click the heading link for a sample of this report.
AR-Floating Column Detail Trial Balance
This companion to the floating column summary trial balance shows each invoice aged with your floating column selection. Click the heading link for a sample of this report.
DB2 Sales History Module:
Sales history is the unquestionable king of business data analysis. Having modern extraction tools for this important part of your business can be the difference between success and failure.
Customer Profit Summary Report
This report by sales rep shows ALL the different pricing combinations and the results on profit for each customer and department with sales over a specified number of days. Verify the different pricing methods used by customer and even differences within a department. Use this report anytime you want to check on pricing practices and how they affect your bottom line. Click the heading link for a sample of this report.
Cost Difference Summary Report
Use this report to check your file cost against the returned wholesaler short-buy cost over a period of time. This excellent tool helps you maintain accurate costs and monitor price discrepancies. The sales history version here (there is an open order version as well) checks back as far as you want to go by entering the number of days to go back when the report is run. Use this report frequently to monitor cost differences, over-charges and bad price updates. Click the heading link for a sample of this report.
Cost Difference Detail Report
This companion report to the Cost Difference Summary shows details at the item level sub-totaled by vendor purchase order. When discrepancies are found on the summary report, run this report to show item details including PO number, PO date, vendor, item number, quantity, and the received versus file cost differences. Use this report when cost differences on the summary report require further investigation. Click the heading link for a sample of this report.
Sales Rep Summary Chart
This chart format report shows total sales by sales rep over the number of days you specify. Perfect for motivation, performance at a glance, and comparison purposes. Utilizing your sales history, you can specify as many, or as few days to include. See your sales reps performance charted for this week, this month, this year, or any number of days. Use this chart anytime you want a snapshot in time of sales by sales rep. Click the heading link for a sample of this chart.
Sales By Day Summary Chart
This important line chart format report shows sales, cost, and profit by day for a specified number of days. Sales, cost, and profit are all three charted on this informative and snapshot view of your business. Utilizing your sales history, you can chart the last week, last two weeks, or the entire last month. Use this report daily to monitor the most critical functions of your business: sales and profits. Click the heading link for a sample of this chart.
DB2 Inventory Module
All your inventory data in one place with DB2 inventory module. Multiple locations, full catalog information, and easy access to the purchasing cost make DB2 inventory a snap for novice users.
Retail Shelf Labels
Retail shelf labels made easy! Finally, you can process professional retail shelf labels without jumping through hoops and have them priced just as they would be at the cash register. Click the heading link for a sample page.
Retail Shelf Labels with UPC Barcodes!
This variation of the retail shelf labels has a UPC barcode in place of the logo. You can modify these labels to suite your individual needs and preferences. Click the heading link for a sample page of this label format.
DB2 Contracts Module:
The DB2 contracts module is another important area where you can save REAL dollars. From contracts that don't perform, to contracts that perform un-expectedly, to presentation quality contracts, DB2 contracts will set your business apart from the competition.
Contract Master List Report
This simple, fast, and highly useful report shows all the contracts in your system. The contract number, description, fixed/flexible indicator, start date, end date, and the number of item records on the contract. Use this report to check for contracts about to expire, old or temporary contracts, and contracts you didn’t know you had. Click the heading link for a sample of this report.
eContent Contract Report
This report takes an existing contract from your system and turns it into a presentation quality format. Sorted using the wholesaler eContent, this report shows full catalog text, full size images, manufacturer names, consumer descriptions, and of course, your contract price. Use this report anytime you want to impress customers and secure new business. Click the heading link for a sample of this report.
Contract Performance Summary Report
This report details contract performance at the contract level. Using your actual sales history, the report asks for the number of days to go back, and then reports each contract in your system showing the sales, cost, and profit this contract generated. Each and every contract is listed on a separate line, even those without any sales, so you can quickly spot high performers, low performers, and those that did not perform at all. Use this report to monitor your contracts regularly. Because this report uses actual sales and cost figures, and you can enter the number of days to go back, and then can keep your contracts fine-tuned and your profits in line. Click the heading link for a sample of this report.
Contract Performance Detail Report
This report is a companion to the Contract Performance Summary report. This report details an individual contract, item by item, and shows the contract price, quantity sold, total sales, cost, and profit. All items on the contract are listed on a separate line, even those that did not sell, so you can quickly spot problem items. This report also uses actual sales history and requests the number of days to go back. You can check the performance of any contract in your system for the past week, month, year, or any number of days. Use this report when unusual profits or losses appear on the Contract Performance Summary report to identify, at the item level, where adjustments may be necessary. Click the heading link for a sample of this report.
DB2 eContent Module:
The eContent available from the wholesalers contains a wealth of information you can put to use in your business to increase profits, generate new sales, and optimize your item databases. Since wholesaler catalogs are overwhelmingly the number one catalog in use by independent dealers, it only makes sense to use this solid platform for development of your business.
eContent Contract Report
This report takes an existing contract from your system and turns it into a presentation quality format. Sorted using the wholesaler eContent, this report shows full catalog text, full size images, manufacturer names, consumer descriptions, and of course, your contract price. Use this report anytime you want to impress customers and secure new business. Click the heading link for a sample of this report.
DB2 Open Order Module:
Knowing where you stand at any moment can be important to your business. These sample DB2 reports show the power of and what you can learn from your open order database.
Cost Difference Summary Report
This report is the same as the history cost difference summary except that it operates off your current open order file. After short buys complete and day-end flushes are finished, use this report to check for any cost discrepancies for the day’s transmissions. Use this report daily to check for cost discrepancies before they become larger issues. Click the heading link for a sample of this report.
Cost Difference Detail Report
Again, like the history cost difference detail, this open order version of the cost difference detail report shows item details of any cost differences. Use this report when cost differences on the summary report require further investigation. Click the heading link for a sample of this report.
Open Order Chart By Pay Code
This chart format report shows the total amounts of all orders within the days you specify by pay code. Each pay code is represented by a different bar showing the total dollar value of the orders with this specific pay code. Use this report to spot check for COD, credit card, and open account orders. Click the heading link for a sample of this report.
Open Order Chart By Status
Like the open order chart by pay code, this status version shows the total amounts of all orders within the days you specify by order status. Each order status is represented by a different bar showing the total dollar value of the orders. Use this report to spot check for quotes, bad status orders, and billed orders. Click the heading link for a sample of this report.
Ticket Summary by Pay Code Report
This report shows summary information for each ticket with a pay code that you enter. Use this report to get a listing of all tickets within a pay code. Click the heading link for a sample of this report.
Ticket Summary by Status Report
Like the Ticket Summary by Pay Code, this report shows summary information for each ticket with the status code you enter. Use this report to get a listing of all tickets with a specified order status code. Click the heading link for a sample of this report.
DB2 Accounts Payable Module:
Accounts Payable is a recent addition to the DB2 family. Look for new reports and analysis for this important module coming soon.
DB2 Purchase Order Module:
Purchase orders are another recent addition to the DB2 family. Look for new reports and analysis for this important module coming soon.
DB2 General Ledger Module:
General Ledger is another recent addition to the DB2 family. Look for new reports and analysis for this important module coming soon.
DB2 DS Import:
DS Import for DB2 will copy the user information, which you created and own, including email addresses, right off the DS admin screen and download it to your computer into a standard Microsoft Access database format. Easily export your valuable data to Excel, Word, or Outlook for analysis, letters, or broadcast email messages. And better yet, since DS update can be integrated into the popular DB2 package from OPSoftware, you can analyze the complete picture including sales history comparisons, what if scenarios, and billing discrepancies.
S. P. Richards Item File Import Module:
The newest DB2 module is the S. P. Richards item file import. Now you can import the COMPLETE S. P. Richards item file containing a wealth of information missing from your existing item database. Compare this complete item file to your existing file for missing items, wrong costs, and product substitutions. Matched completely to your existing item file, the FULL S. P. Richards item file import is a must-have for the cost conscious dealer.
  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.