Primary Accounting Documents, Excise and Identification Labels Database Management System

The customer needed special software solution to manage primary accounting documents, excise and identification labels (DFL) databases, including the registration of business operations, processing and long term storage of these operations as well as providing the operational information for state regulatory authorities.

Customer’s requirements to the system:

  • The new solution has to ensure easy and effective way of handling the information.
  • The information stored in the system should be properly secured.
  • All the components of the system should be presented as individual applications that can be installed on physical servers in any combination.

Actions Taken

The customer together with BelHard analysts have discussed all the requirements to the project and the most suitable way of cooperation for both parties. After choosing the appropriate technologies and development tools, BelHard agreed the plan of actions with the customer. After signing the agreement, BelHard created a dedicated team of professionals who carried out the development process.

The system was organized in the following way:

The server part of the system performs the following functions:

  • accepting the information coming from the client part of the system
  • handling the accepted information
  • placing the information into e-databases
  • extracting the information from the database
  • storing the transmitted information
  • generating an answer to the transmitted information: acknowledgment of receipt or information provision

The client part of the system performs the following functions:

  • information input
  • initial information handling
  • placing the information in the local database
  • generating requests for placing the information in e-databases
  • generating requests for getting the information from e-databases
  • getting responses to the previously transmitted requests
  • displaying the information taken from e-databases

System advantages

  • Client applications interact with the application server via the .Net Remoting technology.
  • For organizations the interaction between the client and the server parts is carried out via information exchange catalogues.
  • Information stored in the catalogues is protected from unauthorized actions (adding, deleting, changing) by data security software tools and digital signatures.
  • All the above mentioned components of the client part of the system are individual applications installed on physical servers in any combination.
  • The message format is unified and XML-based.
  • Transmitted and received messages are kept in transmission and reception places.
  • In case of a connection breakup, messages are automatically transmitted after the connection restoration.
  • Messages are received from other participants of corporate systems.
  • Guaranteed delivery.
  • Transactional integrity.

Results Achieved

Nowadays the system performs the following functions:

  • accounting of applications for obtaining primary accounting documents, excise and identification labels;
  • accounting of completed primary accounting documents, excise and identification labels;
  • accounting of primary accounting documents, excise and identification labels at storage areas;
  • realization of primary accounting documents, excise and identification labels to market participants;
  • accounting of returned and unused primary accounting documents, excise and identification labels to market participants;
  • accounting of lost primary accounting documents;
  • accounting of abolished primary accounting documents, excise and identification labels;
  • accounting of used primary accounting documents, excise and identification labels;
  • accounting of settled primary accounting documents, excise and identification labels;
  • accounting of written-off excise and identification labels;

The system has been functioning for more than 10 years and has significantly improved the performance of the agency.

The system was redesigned three times. Recently the customer has a vision of the further extensions of the system: integration of the database management and high performance archiving systems.

The given system has proved to be effective and can be optimized for foreign enterprises, taking into account the country’s legislation and standards.

Overview

Country:
Belarus

Client:
State supervision for telecommunication of the Republic of Belarus

Industry:
Finance and accounting

Technology:
AJAX, С++, DHTML, Entity framework, JQuery, LDAP, LinQ, Microsoft SQL Server 200X, Microsoft Visual Studio.Net, Mojo CMS, MVC Framework, WCF