Data Migration, Integration and Updates
SunSystems Data Conversion, Mapping, Migration and Recovery
Pearce Ross has extensive experience working with Infor SunSystems and Professional Advantage data, providing practical solutions for data conversion, enhancement, mapping, migration, integration and recovery.
Whether moving to a new financial system, upgrading an existing installation, restructuring data or integrating SunSystems with other business systems, we understand the importance of maintaining the integrity, continuity and auditability of financial information.
SunSystems Data Migration
Data migration is often one of the most challenging parts of a financial systems project. Historical information needs to be understood, mapped and transferred accurately, while ensuring that the resulting data remains useful and auditable.
We can provide bulk updates, data mapping and migration of SunSystems and Professional Advantage data, including the movement of historic information into new or separate business units for continued reporting and analysis.
Our experience includes:
- SunSystems data conversion and migration
- Professional Advantage data migration
- Bulk data updates and amendments
- Data mapping and re-mapping
- Historic data migration and retention
- Data enhancement and restructuring
- Data recovery
- Data reconciliation and validation
Retrospective Coding Changes
Financial systems sometimes need to accommodate changes to the way information is coded after transactions have already been processed.
We can re-map live data to incorporate retrospective coding changes, helping organisations maintain consistent reporting and analysis without losing the relationship between historic and current information.
This can be particularly valuable where changes have been made to account codes, analysis codes, organisational structures or other elements of the financial reporting structure.
Historic Data and Information Continuity
Moving to a new financial system does not necessarily mean that historic data should be discarded.
Retaining historic information can provide essential comparative information and control when analysing fixed assets, debtors, creditors and bank accounts. It can also provide an important audit trail between the legacy system and the new financial system.
We can help organisations retain and access historic SunSystems and Professional Advantage data in a structured and practical way, including moving historic data into separate business units where appropriate.
"Retention will probably be a legal requirement."
Data Integration
Financial systems increasingly need to exchange information with other business applications, data warehouses and data lakes.
We can create automatic data extracts from SunSystems and Professional Advantage for integration with third-party systems and other data platforms.
This can reduce manual data handling, improve consistency and make financial information available to other systems and reporting processes in a controlled and repeatable way.
Data Extraction and Analysis
Efficient extraction and analysis of financial data is essential when planning a migration, investigating historic information or preparing data for integration.
Our knowledge of the underlying SunSystems and Professional Advantage data structures allows us to identify, extract, analyse and re-map information efficiently.
We can also work with clients to understand how data has been structured historically and how it needs to be represented in the target system.
Understanding SunSystems & Professional Advantage Database Structures
Audit Trail and Data Integrity
For financial data, knowing where information came from and how it has been changed is just as important as moving the data itself.
A full audit trail of the data migration path from source to target can be provided, helping organisations understand how information has been transformed and providing confidence that the migrated data can be reconciled with its source.
Our approach is designed to maintain the integrity of the information throughout the migration or integration process.
Practical Experience
Successful data migration is not simply a technical exercise. It requires an understanding of the financial information being moved, how it has been used historically and how it will need to be used in the future.
With over 30 years' experience working with financial systems and Infor SunSystems, Pearce Ross combines technical knowledge with practical financial systems experience to help clients manage complex data migration, integration and restructuring requirements.