OPTIMIZATION OF FIXED ASSETS INVENTORY BY CREATING A TELEGRAM BOT
- Authors: Nasibulin R.O.1, Safonova E.A.1, Abdullin D.M.1, Gareeva G.A.1
-
Affiliations:
- Kazan National Research Technical University named after A.N. Tupolev-KAI
- Issue: Vol 13, No 1 (2023)
- Pages: 90-101
- Section: Articles
- Published: 30.03.2023
- URL: https://journals.rcsi.science/2328-1391/article/view/347114
- DOI: https://doi.org/10.12731/2227-930X-2023-13-1-90-101
- EDN: https://elibrary.ru/VLVPYI
- ID: 347114
Cite item
Full Text
Abstract
This article is about the optimization of fixed assets inventory by means of Telegram bot. The feature of the systems which are realized with the help of bots is the ease of use and minimization of resources spent on software storage, which greatly simplifies the interaction with the system. One of today’s popular platforms for deploying bots is the Telegram messenger.
Purpose – create a tool for inventory of fixed assets, interaction with the database, creation of reports in Excel format and carrying out stock-taking with the help of QR code recognition.
Method or methodology of the work. The article considers the method that implements the inventory of fixed assets and carrying out an inventory. For the implementation it is used: the SQLite database and the programming language Python.
Result: developed a unique tool that implements the functions of adding, storing and interacting with the data of fixed assets.
Scope of the results: object data stored in the database is reasonable to use for inventory and monitoring the current balance of fixed assets.
About the authors
Ruslan O. Nasibulin
Kazan National Research Technical University named after A.N. Tupolev-KAI
Author for correspondence.
Email: drakon.2011.23.11@mail.ru
student
Russian Federation, 1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian Federation
Ekaterina A. Safonova
Kazan National Research Technical University named after A.N. Tupolev-KAI
Email: sea55555@bk.ru
student
Russian Federation, 1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian Federation
Danil M. Abdullin
Kazan National Research Technical University named after A.N. Tupolev-KAI
Email: AbdullinDM@stud.kai.ru
student
Russian Federation, 1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian Federation
Gulnara A. Gareeva
Kazan National Research Technical University named after A.N. Tupolev-KAI
Email: gagareeva1977@mail.ru
ORCID iD: 0000-0002-8539-4541
SPIN-code: 3279-8465
Scopus Author ID: 36801593200
ResearcherId: М-1728-2015
Head of the Department of Information Systems, Candidate of
Pedagogical sciences, Associate professor
Russian Federation, 1, Akademika Koroleva Str., Naberezhnye Chelny, 423814, Russian Federation
References
- Blinova U. Yu., Astakhova E. Yu., Golysheva N. I. et al. Documentation of business transactions and accounting of the organization’s property. Textbook. M.: KnoRus, 2021. 306 p.
- Gartvich A. Accounting in tables and charts / A. Gartvich. St. Petersburg: Piter, 2019. 288 p.
- James R. Groff. SQL. The Complete Guide / James R. Groff, Paul N. Weinberg, Andrew J. Oppel. St. Petersburg: Williams, 2019. 957 p.
- Inventory and accounting of fixed assets (OS) // First Bit - 2022 [Electronic resource]. Access mode: https://nizhnekamsk.1cbit.ru/blog/effektivnaya-inventarizatsiya-i-uchyet-os/
- Leevik Yu.S. Accounting financial accounting / Yu.S. Leevik. St. Petersburg: Piter, 2018. 208 p.
- Melnik M.V. Accounting and analysis (for bachelors) / M.V. Melnik, N.K. Muravitskaya, E.B. Gerasimov. M.: KnoRus, 2018. 272 p.
- Prokhorenok N.A. OpenCV and Java. Image processing and computer vision / N.А. Prokhorenok. St. Petersburg: BHV-Peterburg, 2018. 320 p.
- Sadykova, T.M. Accounting and analysis: Textbook / Sadykova T.M., Tserpento S.I. M.: ITs RIOR, NITs INFRA-M, 2018. 256 p.
- Fedorov D.Yu. Programming in the high-level language Python: textbook for applied undergraduate studies / D. Yu. Fedorov. 2nd ed., revised. and additional Moscow: Yurayt Publishing House, 2019. 161 p.
- Feldman, I. A. Accounting: a textbook for universities / I. A. Feldman. Moscow: Yurayt Publishing House, 2019. 287 p.
- Alex Root Jr. Aiogram Documentation, November 2022 [Electronic resource]. Access mode: https://readthedocs.org/projects/aiogram/downloads/pdf/latest/
Supplementary files
