Exponenciel - Efficient and affordable Sage ACT! add-ons

You are here: home > products > advanced sales lookup, export & reports for act! 2008/9

Advanced Sales Lookup, Export and Reports

Advanced Sales Lookup, Export & Reports is designed to help you manage your Sales Opportunities.

You can create Excel reports
on any information contained in your opportunities

As its name implies, it combines 3 functions:

  • it has very elaborate Opportunities Lookup features;
  • it allows you to export your sales data to a CSV (Comma delimited) file for easy import into another program;
  • it allows you to create reports in Excel with formatting, sorting and totals, so that you don't need to edit your report in Excel once created.

Also:

  • you can report on products
  • you can run calculations in Excel after data import (see the Commission report explanation in the user's manual)
  • you can insert blank columns

You may have Excel automatically
perform calculations on the imported data
to calculate commissions for instance

Here are some examples of what you can do with ASLR :

  • create a lookup or report containing opportunities created in the last month;
  • create a lookup or report containing all opportunities managed by a particular user;
  • identify opportunities based on 2 different criterias (any field of the sales record can be a criteria: product, type, quantity, amount, competitor, etc.) : for instance, you could create a report of opportunities for product 'Bulk Chocolate', with quantities above 1000, sorted by forecasted close dates.
  • Create a sales report in Excel and have Excel perform calculations on the imported data (to calculate commissions for instance).

NOTE: Requires Excel 2000 or higher. Compatible with Office 2007.

QUICK LINKS

 
   

Across this Web site, ACT! and ACT! Premium might be referred to as ACT! or Sage ACT!. Sage ACT! was the product name from 2010 to 2013.

home | products | support | order now | web design | resellers | contact us | privacy policy
Design by Exponenciel

Exponenciel has been a leading developer of Sage ACT! add-ons, Sage ACT! addons, Sage ACT! plug-ins, Sage ACT! plugins since 2001.
ACT!, ACT! for Workgroup, ACT! for Web, ACT! Pro and ACT! Premium are registered trademarks of Swiftpage.