SA-F-C (Java) Salesperson Summary

 

General Program Description

Use this report for a graphical analysis of gross profit by invoice or an extraction of the data to CSV file.   Graphical option is a pie or bar chart, summarized by Sales Rep.   Detail Export is one line per invoice showing Invoice Number, Date, Bill To Customer, Ship To Customer, Invoice Number, Invoice Subtotal, Invoice Total, COGS, Margin and Margin %

 

The graphical option will open in your default Windows image viewer, at which time you can save or print it.  The Export option will genreate a CSV file and then open it in the Windows default application (typically Excel or equivalent), at which time you can save or print it.

 

Setting up the Database

 

See ODBC Data Connection for information regarding setting up the database for the Java programs.