Sage 300 Data Extraction and Reporting

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.

Pharmaceutical & Biotech

Construction Management

AMDG

Sage 300 Data Extraction and Reporting

Sage 300 is the leading Construction and Real Estate property management software. AutoSoft Systems has developed data extraction tools to allow Sage users to extract all the data from the 300+ tables in the Sage database for further manipulation and use.

This tool provides the foundation for an infinite variety of reports and exports. In this fashion, the user can extract information out of the Sage 300 database and automatically manipulate it for automatic insertion into another application, eliminating double data entry.

This easy to use tool extracts the entire contents of every table in the Sage 300 database, and places the data in a series of Excel workbooks. Here is a screen shot of the ensuing directory:

This redacted screen shot displays the partial contents of the APM_MASTER_DIST_PAYMENT table

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 04/30/2015 03:15 PM and is written in EXCEL!

Sage 300 is a trademark of Sage Software - AutoSoft Systems is not affiliated with Sage Software