eye.jpg
 
                      AutoSoft Systems
        AutoSoft Systems 2 Round Hill Court
        East Greenwich, RI 02818
        401.885.3631
        401.884.5653 Fax
                        401.996.3631 Cell
AMDG       "Once you know it, it's Easy!" autosoft@aol.com
Commercial and custom computer related products spanning the areas of data acquisition and control, simulation and modeling, numerical analysis, chemical process design and manufacturing management information systems design. 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
SMART
SMART Tools for AXIOM Enhancement
AXIOM is the premiere ERP solution for manufacturers of metals, wire and cable, as well as metal service centers
(Click here to view the AXIOM web site)
(AXIOM is a Trademark of Consona  - AutoSoft Systems is not affiliated with Consona)
This document outlines and illustrates the features of the SMART suite of AXIOM enhancement tools that are currently in use at:
C&M Corporation (www.cmcorporation.com) Aluminum Line Products (www.AluminumLine.com) Times Fiber Corporation (www.timesfiber.com)
TMK - IPSCO and are now available to other AXIOM users.  
The SMART suite of software products common features
All users use one copy located on a network drive              
No installation on workstations necessary – The executables only require 4 DDL files to be present in the same folder as the executable
All reports are outputted to Excel (The free Excel Reader works!)   Some recently asked questions about SMART
All source code is included   Enhancements Since May, 2009
                               
AXIOM License Management Material Tracking and Control
StopAx Tag Tracking Tool
Automatic logoff of inactive AXIOM users Enter a tag #, determine every associated raw material, WIP and product
CART Reports Load Status Report
Conversion of cryptic AXIOM Exports into user-friendly Excel Workbooks Manage your shipment department with this powerful tool
License Counting Tool Packing Slip Printing Utility 
Count AXIOM license usage 24x7 - FREE DOWNLOAD Print Packing Slips as you want them - Excel based
System Administration Shipment Performance Report
On time performance sliced, diced and trended as you wish
WatchDog Vendor Managed Inventory Tools
Automatic email and text messaging warning if queues or reports are delayed Manage suppliers and customers inventories with these tools
CART Archiving Customer Email Notification of Shipments
“Freeze Framing” of CART reports for historical analysis - FREE SAMPLE CODE Automatic updates to customers of recent and impending shipments
Data Load Macros ODBC
Quickly and easily upload thousands of records in AXIOM
Big File Extraction Tool DART
65,536 rows are no longer a limit - FREE DOWNLOAD Direct AXIOM Reporting – ODBC for the masses
Programmatic sending of Emails and Text messages TART - Total AXIOM Reporting Tool
How to use Excel to send Emails and Texts - FREE DOWNLOAD Replicating & searching the Progress Databases & source code 
CHART Performance Measurement
Managing the cumbersome Change Audit Table
A Summary of Software used to build AutoSoft products Sales Scorecards
See how the Master does it Performance Measurement of Sales Personnel
FileSync Machine Utilization and Efficiency Reporting
Need to keep multiple copies of files synchronized?  FREE DOWNLOAD Instant utilization, efficiency and productivity by work center, part, shift, operator, etc.
Sales Order Management AutoKPM
Key Performance Measurements
Sales Order Extractor Tool Scrap Reporting
Pull sales orders from AXIOM in a usable format (Excel of course!) Instant scrap reporting, sliced and diced many ways
Sales Activity Report Process / Routings Tools
Slice and dice sales actual vs. forecast by a variety of subsets
Sales and Bookings Summary Report BART – Bill of Material reporting tool
Automatic PowerPoint slide generation Indented bill of materials reporting tool with capacity planning
Orders and Invoices Summary Report PART – Quick AXIOM part lookup utility
Totals and drill-downs for user specified date ranges Quick AXIOM part lookup utility
Sales By SIC Codes WART
Trend sales month-to-month by SIC codes Indented Work Order Reporting
Inventory Control User Data Reports
Automatically build stand-alone Excel workbooks with all user data
AutoLogger Inventory Lot Size to Order Size Reconciliation
Silo Monitoring & Automatic Updating of AXIOM Inventory Levels Finds and corrects discrepancies between lot sizes and order sizes
OBSOLART Parts Cost and Margin Report
Measuring Obsolete and Excess Inventory Items (2 Flavors) Excel report listing costs and margins for all parts
Purchasing and Receiving Material Requirements Planning
AutoSAF MART
Special Purchasing and Manufacturing Management Tool Extracting AXIOM MRP information for a variety of uses
PPV Forecast Manager
Purchase Price Variance Report Generating the necessary files for input into AXIOM MRP
Raw Material Quote Analyzer Quality Tracking and Control Tools
Confirm vendor quotes in AXIOM are accurate and up to date
Cost Accounting Tools Quality Specifications Report
List all your Quality Specifications on one easy to read Excel worksheet
Current Cost Change Report AXIOM Interfacing with other Software
Notifies account managers when costs change
Current vs. Frozen Costs Exception Reports EDI made easy (AutoEDI)
Reports discrpancies in the AXIOM data AXIOM's HTML-based EDI module is less of a chore with this utility
Activity-Based Cost Management Customer Relationship Management (CRM)
Determine profits from each customer, product line, part number and more Interface with Salesforce.com
Finance Tools Customs Management
Facilitate the paperwork associated with moving parts between Mexico and the USA
GAP Report Production Line Data Monitoring
Measures current and projects future profitability, bookings and shipments Integrating automatic production line monitoring with AXIOM
AutoBudget Embedding Excel Workbooks in AXIOM User Data
An Excel-based Budget Performance Tool fully integrated with AXIOM Imagine the possibilities with Excel workbooks in AXIOM user data fields
APART – Accounts Payable Reporting Sales Tax Report
A better report Interface with Vertex
Accounts Receivable Management UL - CSA Reporting
This report provides great detail and projects future cash flow Extracting Data from the Midwest EZRF system and merging it with AXIOM User Data
Other AutoSoft Product bundled with SMART
AutoData TimeTool
Process and Lab Information Management System Time Management and Tracking Tool
AutoMaintain EPD
Preventative Maintenance Management System Project Portfolio Management Tool
                             
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/19/2011 01:03 PM 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