Import Utility

The ASI Import Utility's is a very flexible import utility providing many options to import the desired data. Whether its data from a file, another database source, from within the same or another SQL server, this import utility can handle your desired method. Data is validated before imported as well as provides the capability to review the data prior to import. Customize the mapping of the data to the fields according to your company's desired destination. Customer and vendor tables able to be updated or insert additional records into the masterfile tables.

   Available for GL, AR and AP

Import Capabilities:

• DTS Packages
• Linked Server 
• SQL to SQL
• Data File Access  
• ODBC Connectivity 

   Flexibility Features:

  • Solomon User Field Access 
  • Assign imported fields to appropriate Solomon table fields 
  • Modifiable Pre and Post Procedures for customized processing
  • Utilize Currency Conversion 
  • Master file ID fields validation 
  • Account and Sub Account validation
  • Account and Sub Account Mapping
  • Currency Rate Import 
  • Many setup options 
  
  
  [Print Friendly]