While Unanet can provide tremendous value as a standalone system, it can also be used in conjunction with other existing systems. It is often common for customers to integrate Unanet with their existing Human Resources, Payroll or Accounting systems to avoid duplicate data entry, improve data accuracy, expedite payroll, employee reimbursement, customer billing and more.
Unanet provides an Integration Manager consisting of imports and exports to interface Unanet with other existing systems.
Unanet has been integrated with:
Accounting Systems:
ACCPAC
Advantage
Deltek Costpoint (see Export Time to Costpoint and Export Expenses to Costpoint for more information)
Deltek GCS Premier (see Export Time to Deltek and Export Expenses to Deltek for more information)
Deltek System 1
J.D. Edwards
Lawson
MAS 90/200
Microsoft Dynamics GP (Great Plains)
Microsoft Dynamics NV (Navision)
Microsoft Dynamics SL (Solomon)
Oracle Financials
PeachTree
Peoplesoft
Procas
QuickBooks (You can download additional material from our Knowledge Center on this topic)
SAP
Sympaq (see Import from Sympaq for more information)
Payroll Systems:
ADP
Ceridian
CompuPay
PayChex
Peoplesoft
UltiPro
Typical applications:
Import from General Ledger, Payroll, Human Resource, Accounts Payable, and Accounts Receivable Systems.
Feed new / changed people data and project data into the Unanet database
Import Other Direct Costs into Unanet to obtain a complete view of project costs
Export based upon the status of timesheets and expense reports to General Ledger, Payroll, Human Resource, Accounts Payable, Accounts Receivable Systems and other back office systems.
To facilitate the integration process, Unanet has developed an Import feature which will allow for the importing of user and project data. There are a number of imports available including People, Project, Task, Assignments, Time, Expense and more. The import process currently requires a simple comma separated file format (one format for each of the import types).
To facilitate unattended imports, Unanet has a Command Line Import feature which can be used in conjunction with a custom customer created process to programmatically invoke a particular import. This could be used, for example, to keep Unanet updated on a periodic basis with the latest personnel and project data updates.
To further help manage the various steps included with an inbound interface, the Integration Management Utility (IMU) can be used to help control the execution of the data generation steps, the import into Unanet steps, error checking and reporting, etc.
To facilitate the feeding of actuals collected in Unanet, a powerful Export feature is available which can be used to define data output formats (via export templates). Current output formats include fixed fielded and csv (comma separated values) formats. Many customers utilize the export feature to pull data for the purposes of feeding a downstream system while others utilize this feature for loading data into a spreadsheet program for additional data analysis and custom reporting needs.
To facilitate unattended exports, Unanet has a Command Line Export feature which can be used in conjunction with a custom customer created process to programmatically invoke a particular export. This could be used, for example, to pull completed expense reports into a downstream system on a periodic basis without requiring any human intervention.
While customers may use Unanet for a variety of purposes and may interface with a variety of 3rd party products, it may be helpful to follow one of the standard configuration guidelines when integrating with a particular back office product.
You may also be interested in: