Transmashholding completes the project of creation of a single automated system of accounting and asset management

"Transmashholding" for the purpose of solving of tasks, connected with increase in production efficiency and labor productivity, decrease in management costs implemented the project on creation of a single automated system of accounting and asset management and financial resources based on solutions 1C and Microsoft SQL Server.

Tasks

In 2011 within development of the project it was decided to unify the accounting systems of the enterprises and to implement the uniform accounting principles based on the created system. Now in the centralized database about 20 thousand documents are processed. At the same time it steadily grows – about one and a half million records increase every month. Local storages based on the Microsoft SQL Server are unrolled also at the enterprises of holding.

Project

In a market analysis result the choice was stopped on the flagman solution of 1C Company – a standard configuration "1C:Enterprise 8. Management of manufacturing enterprise" and on optimal, according to specialists of department of information technologies of Transmashholding, Microsoft SQL Server 2008 database management system (DMS).

Advantages

In the new automation system the large volume of management information – in particular circulates because for increase in accuracy and efficiency of accounting the number of details is increased. If before when summing up all details were brought in a system once at the end of the month, then now use them weekly or even every two days. And at the same time adequate response time is provided.

Solution

At head enterprise of holding (in management company) centralized systems are implemented now: managements of budgets and financial flows; system of logistics; management system for implementation of finished goods.

In addition on two servers with the Microsoft SQL Server the centralized storage to which requests from the centralized applications are performed (management of supply, sale, payments and also all accounting of parent organization) is created. The consolidated parts of the databases functioning at the enterprises are transferred to the centralized storage. Now in the centralized database about 20 thousand documents are processed, and at the same time it steadily grows.

At the enterprises of holding local storages based on Microsoft SQL Servers, the appeal to which is performed from the applications functioning at the enterprise, are also unrolled. A part of information gets from the centralized storage to the local systems (for example, information on receivables).

Implementation of the Microsoft SQL Server at the enterprises of Transmashholding was performed by own forces of specialists of the company. Support and administration is also performed by a command of holding.

Advantages

Now users of an automated system of accounting and management are more than 3000 employees of key divisions of holding.

Upon transition from accounting to operational management the size of storage sharply increases. Frequency of advanced queries to the database grows. If earlier the administrative personnel was content with reports of times a month, then now there was an opportunity to train them weekly or even every two days.