This IT project is part of our digitalization and optimization of our customers’ IT landscape. Through targeted measures, we promote technological progress, optimize cross-system processes and create a sustainable basis for future developments. Our IT reference projects serve as a basis for orientation. They support the reusability of tried and tested concepts as part of project implementation.
This is one of 4843 IT projects that we have successfully completed with our customers.How can we support you?
Interface for automatic transfer of accounting data
Project duration: 7 months
Brief description
Combined with the company-wide introduction of a new ERP software, the analysis, technical implementation and developer test for a data interface are carried out. Data from accounts receivable is sent via the new interface from the ERP system to an external financial services provider.
Supplement
From the ERP software, accounts receivable data is made available each day via an SQL database. These data, such as customer information, open claims or outstanding balances from open accounts receivable transactions, are read each day automatically, prepared for sending to a financial services provider, and transferred to a defined data format. The results of the data formatting are sent by SFTP to the financial services provider. The interface is based on SQL Server Integration Services (SSIS). The interface is implemented using SQL Server Data Tools (SQL Server Management Studio, Visual Studio).
Subject description
The aim is to transfer data from the new ERP system that is to be introduced in order to perform a correct valuation of the accounts receivable values and minimize the financial risk to the company.
IT project data
- Industries trade
- Specialist tasks financial accounting, interfaces
- DP tasks IT consulting
- System environments Client/Server
- Procedure model customer standard
- Programming languages SQL
- Databases MS SQL Server
- Development and test tool MS Visual Studio, Notepad++
- System software TortoiseSVN
- Middleware and frameworks MS SQL Server Integration Services (SSIS)
Project period16.11.2016 - 30.06.2017
Customers who trust us
Have we sparked your interest ?
