AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       Decision Ready Information! autosoft@aol.com
Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems.  Founded in 1982.
We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.
Home About Us Literature Wire & Cable Pharmaceutical & Biotech Construction Management Commercial Products Custom Solutions
Contact Us Events Downloads
Custom Sales Reporting
This custom report was designed to report on sales by companies with the same SIC codes in AXIOM.  By drawing upon my vast library of code, I was able to complete this task in just a few hours.  The user is presented with the following screen upon opening:
In this case, the implementation is not using the SIC code field to store SIC codes, but is storing a code specific to each customer.  This is because AXIOM does not support multiple billing addresses for the same customer, and this AXIOM implementation has customers that have multiple billing addresses.  The SIC code field is used to group these multiple billing addresses.                
Note the Data and Time Picker.  Unlike the normal implementation of this feature, which involves the use of an ActiveX control, this is all native Excel.  This avoids the problem of assuring that every user has the proper version of the Date and Time Picker installed on their machine.                
After the Yellow button is clicked, the final report looks like:
One can report on Margins, Volume and Sales by use of a drop down pick list:
Trends are automatically calculated, as well as green/red metrics to show growth and shrinkage.
AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631 
This web page was last updated at 02/21/2014 07:47 AM and is written in EXCEL!
AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach