|
|
|
|
|
|
|
|
|
|
|
|
AutoSoft Systems |
|
| |
|
|
|
AutoSoft
Systems |
2 Round Hill
Court |
|
| |
|
|
|
East Greenwich,
RI 02818 |
|
| |
|
|
|
401.885.3631 |
|
| |
|
|
|
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 |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
AMDG |
|
![MCBD05374_0000[1]](salesbysic_files/index_0000_image004.png)
|
|
| 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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|