Desing and implementation of modules in the BNS system for long-term cashflow planning

The economic environment is becoming increasingly unstable. Due to the pandemic and war conflicts, many companies have run into minor or major financial problems in last years, and some of them had to close their business for these reasons. In order to react more quickly to the adverse effects of the external and internal environment of the company, more and more companies are starting up to invest in tools to support financial performance management. These tools provide mechanisms for faster and more efficient planning and subsequent monitoring of deviations between created plan and reality. Based on these documents, the company's management considers the most suitable options for further strategic, tactical and operational steps. Most companies are only focused on planning and monitoring costs and incomes, usually in the form of a statement oriented to the needs of the company, known as a management income statement. However, some companies do not monitor the movement of funds, which is usually the reason why the company is forced to close down its activities. The rule is that companies do not close because of low or negative profits, but because of a lack of funds. This thesis is mainly oriented on the area of this problem. The goal of this thesis is design and implementation of an analytical and planning application in the BNS (Business Navigation System) to enable the creation of a long-term cashflow plan compiled by the indirect method at Inekon Systems and subsequent monitoring of deviations between planned and actual cash flow. Except of needs described above, another reasons for creating a new solution is its current absence in the company and emphasis of the new parent company ABRA Software a.s. to improve the quality of the planning process and reporting. In order to achieve targets of implemented solution it is also necessary to provide access to financial data from the ABRA Gen system. This system replaced the current WAM S/3 ERP system at the Czech branch of the company, and its deployment took place at the beginning of 2023. In the context of the entire solution, this thesis is based on standard Business Intelligence methodology, where it is necessary to integrate data from the ABRA Gen system into the data warehouse and with using of historical data from the WAM S/3 system prepare a complete database for analytical services based on Microsoft SQL server and a subsequent application implemented in the BNS system.