Sage MAS 90 Level 3 Import Master Module

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.

Email : info@bestaccounting.com
Phone: 1-888-818-9855
FAX: 1-713-896-1100