E-Ledger Application

Problem Statement

An Oracle ERP implementation company needs a standalone web application written in Java to transmit and receive e-Ledger data (accounting related General Ledger and Journal Book) to a central data centre unit. The application will extract data from Oracle systems, will wrap the data in required XML format and be able to send / receive e-ledger. E-Ledger data will be sealed and electronically signed and will be uploaded on Government portal for regulatory compliances by companies. Finally patent file is sealed with financial seal by revenue administration and is ready to download for the user. The data will be archived in the oracle database.

The Challenge

In order to accept the files that are created by the standards established by the General Regulations as e-ledger, it has to be sealed with the financial seal or signed with a secure electronic signature and must be patented with e-Ledger application.

The related procedures are listed below-

  • “E-Ledger” format files are created in accordance with the standards and formats specified in the relevant manuals.
  • The created file is placed is placed in the designated field which is stated in schema structure
  • The created “ledger” file is signed or sealed. (The file created in this way has to be kept as ledger by the taxpayer after getting its patent. However, in order to consider the file as valid ledger, the patent must be gotten and be kept together with the file)
  • “Patent” file is created by getting certain information from the sealed or signed “ledger” file.
  • “Patent” file is signed or sealed.
  • Signed or sealed patent file is packed.
  • The prepared package is uploaded on e-Ledger Application on www.edefter.gov.tr
  • The patent is sealed with the financial seal of the Revenue Administration and is given access to the ledger owner to download. (The e-ledger patent file that has been given access to download must be kept with the signed or sealed ledger file.)

TI Solution

The solution was proposed to development it on JBoss-SpringFramework, Hibernate and JSF development stack. One of the key aspect of the project was to provide Smartcard based digital document signing feature. The signing was essential for uploading documents to Government portal. Documents generated at each stage are stored as Binary object in the Oracle database itself thereby eliminating the need for a separate file database server.

Advantages

  • The solution was implemented within 2 months although it took almost the same amount of time to get the application procedural steps accepted from the Government.
  • Application is fully parameterized including name of source and target database, the name of tables, the directory providing the ERP implementer full flexibility to offer this solution as an add on service to its client.

View Screenshots

E-Ledger Application

TechInfiniti Advantages

TechInfiniti offers innovative technology solutions that can be easily scalable with the requirement of the client and also our teams believe in ensuring that we keep ourselves abreast with the latest developments in the field of Information Technology.

TechInfiniti offers clients with services and solutions that are a perfect fit to their area of operations or expertise. Customization to suit the requirement of the client is one of the key areas we believe in and ensure we deliver on this parameter time and again.

TechInfiniti believes in using Open Source technology and collaborate the same with Commercial of the Shelf software for any domain which ensure that the total cost of ownership of the service or solution is reduced drastically and also the return on investment can be recovered in a short span of time.

TechInfiniti has always ensured that the services and solutions that are on offer to clients have the utmost quality standards. As the solution is customized to meet the requirement of the client, the performance of the service or solution is given utmost importance. We ensure that we consult the client on each and every aspect of operations that ensure that service or solution performs and delivers desired results to the client time and again.

TechInfiniti offers solutions which are developed using open source and commercial of the shelf software which results in making the solution more affordable to the client as the TCO and ROI factors help them incur huge amount of savings over a period of time.

TechInfiniti believes in providing quality solutions and services to all clients. This is a result of the methodology we use in creating the solutions or services for our clients by understanding their operational procedure and taking their suggestions on board during the developmental phase of the solution or service.

We at TechInfiniti have a unique development methodology where we using a combination of waterfall and scrum model of development. This includes getting the client involved during the developmental stage of the solution so that we could provide them with a solution or service that meets their specifications and also ensures that it delivers on all parameters defined by the client.

TechInfiniti as an organization has key capabilities when it comes to Infrastructure with over 4000 Sq Ft of facility which currently houses a data center with 24 hour power back up. With a connectivity of 7MBPS and 24 static IP address. A further 20000 sqft space is available for expansion.