SA-F-D (Java) Item Sales Analysis

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 by item class, or if Top N Items is selected, chart by item.   Detail Export is one line per invoice showing Item Class, Item Number, Item Description, Invoice Number, Invoice Date, Customer, Quantity,  Extension, Unit Cost, Category, Extended 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.