|
RealWorld Expertise.LAN/Expertise.SQL
Data Manager
Custom application development, program modifications and enhancements can be
accomplished in a much shorter time frame with the Data Manager. This module allows you to
import any ASCII, comma- or tab-delimited file directly into nearly every field of every
Expertise.LAN/Expertise.SQL file. The Dynamic Data Exchange (DDE) with most major
Microsoft Windows spreadsheet products gives you visual control of all data elements that
are being imported and exported.
- The Data Manager enables system integrators to link external applications with Visual
Accounting at the file system level. Any product that can read Btrieve Data Definition
Formats (DDFs) can be used as a front-end development tool. For example, products such as
Microsoft Access and Visual Basic, and Trinzic Corporation's Forest & Trees can be
used to develop front-end systems for vertical market applications that integrate with
Expertise.LAN/Expertise.SQL modules.
- The Data Manager provides the ability to add supplementary menu selections to menus and
to access custom applications from standard desktop buttons.
- Commonly used import maps can be saved for periodic imports.
- Automatic spreadsheet column formatting, according to stored data type, is provided.
- A full set of data dictionary tools is included and all data dictionary file formats can
be easily managed.
- Accounting data can be set up without re-entry. Key field data--such as the chart of
accounts, vendor number, inventory part number--can be exported from every file, the data
can be modified and the changes can be imported.
- Commonly used data files can be imported through a template with features for adding new
records, changing existing records, or adding and changing existing records.
- Checking account information can be integrated electronically and directly with the bank
files.
- Executive level reporting outside of Expertise.LAN/Expertise.SQL data file access can be
managed.
- Files can be created without the supporting module, such as Job Cost and Purchase Order.
- Interface data can be output in text or DDF file formats or for use in Forest &
Trees.
- Security levels can be easily set up to ensure integrity of accounting files.
|
