<< Click to Display Table of Contents >>

SA-F-B (Java) Customer Detail/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 line chart, summarized by day, week or month with an option to also include the COGS for the period and an option for a year to year comparison if the date range exceeds one year.   Detail Export is one line per invoice showing Invoice Number, Date, Customer code, 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.