Sales Summary

The Sales Summary window provides an overview of sales history on a per Client per Product basis.

This is a tool for researching your Clients' purchasing history. Having this information at your fingertips is valuable for up-sell and cross-selling opportunities. This data includes a record for every Client/Product combination in your sales history. Whenever you sell a new Product to a Client, a new record will be added to the list. Then, as you sell additional quantities, AcctVantage will update the record to keep the totals up to date.

The system automatically tracks the following values:

  • Client Name: The client who the product was sold to.
  • Part Number & Product Name: The product that was sold to the client.
  • Total Qty: How many units have been shipped to this Client over your entire history.
  • Total Sales: This is a dollar figure showing the total sales of the Product to the Client.
  • First Sale Date: When did you first Invoice the customer for the item. This column will stay at 00/00/00 until you post the first Invoice for the Client/Product.
  • Last Sale Date: When did you most recently ship this item to the Client?
  • High Price: What is the highest price you've invoiced for this Product to this Client?
  • Low Price: What is the lowest price you've invoiced for this Product to this Client?
  • Last Price: What is the most recent price you've invoiced for this Product to this Client?
    • Note: The Client may have a new or different price break for the Product. This value shows what you actually Invoiced for on the last sale.
  • Open Order Qty: How many units are on Sales Orders that have not yet been Invoiced?

Updating the Sales Summary Screen

The Sales Summary screen is not updated in real-time.  

There is a potential to cause a dramatic system slow down by calculating large volumes of data for these summary records while users are on the system. AcctVantage will update the table each evening as part of the Once Daily Update routine, which is normally is set to run overnight.

  • This feature can be turned off completely via System Configuration.
  • Sales Summary data can be calculated on-the-fly (i.e. not part of the Once Daily Update) via the Utilities window.