logo_home1.jpg (5641 bytes)logo_home.gif (2382 bytes)

save_home.gif (2970 bytes)

    
 

 

Accounts Payable | Accounts Receivable | Bank Reconciliation | Bar Code Master | Bill of Materials | Customizer Module
F9 Module | General Ledger | Inventory Management | Import Module | Job Cost | Materials Requirement Plan
Payroll | Purchase Order Module |Sales Order Module | Work Order Module | Sage MAS 90 Product Description

  IMPORT MASTER
Harness the power of your automated office with the Sage MAS 90 Import Master module. Using Import Master, you can channel information from virtually any source into Sage MAS 90.Quickly and easily import data in virtually any file format, including ASCII, dBASE™, DIF™, Microsoft® Excel® and Lotus® 1-2-3®, into any Sage MAS 90 data file. Whether you need to transfer budget information stored in a Lotus 1-2-3 spreadsheet, update your price list from the manufacturer’s price file or convert your present accounting data into the Sage MAS 90 format, make the conversion process painless and economical. It’s easy to use Import Master to bridge the gap between you and the information you need.Import Master features the same award-winning level of usability you’ve come to expect from every Sage MAS 90 module. Define custom import functions to perform simple data replacements or apply complex mathematical formulas when calculating values during the import process. With the freedom to create import functions, modify them at any time and verify their accuracy before Sage MAS 90 files are updated, you have full control over the information you wish to import. Reports
  • Import Master Log
  • Import Master Maintenance Listing
  • Data Dictionary Listing

FEATURES

Custom Import Functions

Import functions can be customized to accommodate virtually all data files used by Sage MAS 90 modules. Simply select the data file and data to be imported; once defined, custom functions can be used at any time. Imports can be run from the operating system, allowing users to run imports from a batch or script file.

Data Dictionary

Quick access to all Sage MAS 90 data file and item information is provided by the Data Dictionary. In addition, data files and items are assigned descriptive names for easy recognition.

Import File Types

Import data from this comprehensive collection of file types: ASCII text files, dBASE files, delimited text files, DIF files, direct and indexed BBx files, Excel .XLS and Lotus 1-2-3 .WKS spreadsheet files.

Import Operations

Existing data values can be manipulated prior to the import process. You can assign a literal value to an existing value, or replace, add to or subtract from existing values. You can increment values automatically from the first record in the file or begin incrementing from a predefined source record. In addition, you can link specific data items from multiple source files.

Calculated Information

Calculation formulas using constants, date item names, dates and mathematical operations can be used when importing data.

RecordSelection

Importing can be restricted to specific import file records. If no data selection criteria are specified, all data records from the import file will be imported. Positional selections can be done. For example, you can import records with the prefix “753” in the phone number.

Review Sample Data

A Sample Data option allows you to verify the accuracy of the defined import format before actually importing data. You can preview import data on your video monitor or print hard copy.

Import Master Log

This audit trail summarizes all import function information. The report can be printed for successfully imported records, for records which were not imported or for all records involved in the import process. The field contents of any failed import fields are displayed in the Import Log.

Import Master Maintenance Listing

All predefined import functions are listed on this report. The detailed version of this listing includes data item, record selection and record type selection information.

Data Dictionary Listing

Each data item contained within an Sage MAS 90 application data file is detailed on this report. In addition to data type, key and mask information, you can also print import validation or record type information on the listing.

Accounts Payable | Accounts Receivable | Bank Reconciliation | Bar Code Master | Bill of Materials | Customizer Module
F9 Module | General Ledger | Inventory Management | Import Module | Job Cost | Materials Requirement Plan
Payroll | Purchase Order Module |Sales Order Module | Work Order Module | Sage MAS 90 Product Description

Ifsslgo6.gif (1221 bytes)

Email : [email protected]
Phone: 1-888-818-9855
FAX: 1-713-896-1100

© 2007 Innovative Financial Systems, Inc. All Rights Reserved.
Sage MAS 90, Sage MAS 200 and Sage BusinessWorks are registered trademarks of Sage Software, Inc. © 2007.