Содержание
- Introduction
- 1. Description of the enterprise
- 2.The goals of creating a database for the enterprise
- 3. Brief description of how the database works
- Conclusion
- References
Introduction
Filling out the documents in writing is quite laborious and takes a lot of time for the user, as well as planning sales or managing customer orders, purchases, stocks, overheads. In order to facilitate the work of employees, almost every enterprise needs a database that will help speed up the process of performing work, each such database must be flexible, which will allow it to be improved if the need to increase the functionality and speed of calculations is required. The base must include powerful means of interrelated planning and control of sales and purchases, this will allow you to reserve goods in warehouses, comprehensively solve the tasks of maintaining customer orders, identify the required needs for goods, as well as form orders to suppliers on their basis.
Nowadays, it has become popular to have your own database in the enterprise. Almost every enterprise has its own database, which helps staff to speed up the work process. The bases in the enterprises give the workers of the company strong tools for planning the volume of sales in volume and value terms, as well as planning based on sales data for previous periods. Provides information about the current balances received during the planning period from customer orders, selling prices, including based on information about the current prices of the company and competitors, as well as the cost of sales, taking into account information about prices and the actual cost of sales for a certain period. The capabilities of planning and plan-fact analysis implemented in the system provide support for decision-making that determines the development of the business, and allow you to move from "spontaneous" management to regular sales management, if required by the enterprise.
1. Description of the enterprise
Limited Liability Company "MITLINE" was established on October 26, 2017 by combining the property contributions of its members for the purpose of making a profit and is registered by the Department of State Registration of the Ministry of Revenue and Duties of the Donetsk People's Republic under the number 051157. The Company is a legal entity and builds its activities on the basis of the Charter and the current legislation of the Donetsk People's Republic. It is one of the forms of entrepreneurial activity.
The company's field of activity is wholesale trade in poultry meat and meat products. LLC "MITLINE" is a subject of foreign economic activity. Contracts have been signed with major manufacturers of the Russian Federation. The enterprise makes it easier for manufacturers to reach a large number of corporate buyers, and is also able to select the goods and make the assortment that buyers need, thereby saving retailers from unnecessary work. An enterprise purchases goods in relatively large quantities, stores it and then resells it to retailers in smaller quantities.
2. The goals of creating a database for the enterprise
The aim of the study is to analyze the effectiveness of managers' work with clients, automate the work of the enterprise and supplement the database with documents "Bonuses", "Settlements with counterparties" and "Entering information about bank cards of employees"
The main objectives of the study:
- study of types of reports in "1C: Enterprise 8.2"
- studying the architecture of databases in "1C: Enterprise 8.2"
- finding the best system performance
- types of registers and their significance when working with data
- development of a system of sales bonuses for managers
- development of documents "Bonuses", "Settlements with counterparties" and "Entering information about bank cards of employees"
- development of a configuration for an enterprise in the 1C: Enterprise 8.2 system.
Object of research: system 1c Enterprise 8.1.
The developed software product must meet the following requirements:
- User-friendly interface
- Hotkey support
- Speed ??and stability of the database
- Implementation of all required modules, subsystems, reports, etc.
- Separations by access for each user
- Implementation of the document and report "Bonuses" for managers
- Implementation of the documents "Settlements with counterparties" and "Entering information about bank cards of employees"
- Possibility of revision if necessary.
3. Brief description of how the database works
In the process of developing a database for a wholesale and trade enterprise in the 1C: Enterprise system, a lot of reference books and documents were researched and implemented for working with contractors, customers and employees at the enterprise itself. In particular, the document "Setting sales bonuses" for managers was implemented.
The company (Code, Name, Short name) delivers various goods (Code, Name, Short name) to customers. Receiving orders from customers is carried out by a special service (Code, Name, Short name) of the enterprise. In order to become a consumer of the company's services, each subscriber must register, while his name, address, telephone number and passport data (Series, Number, Date of issue, Issued by) are recorded. Each client can make several orders during the day (Date, Time), the order is assigned a number.Each order can contain several products, for each the quantity of the product, the unit of measurement (Code, Name, Short Name), the price per unit of the product, and the total cost of the product are indicated. The order also has a total. When forming the order form, which will be signed by the subscriber upon receipt of the goods, the order is paid for, or the subscriber receives the goods on credit. Also on the order form it is indicated: details of the enterprise (name, address, contact numbers); Name and manager who accepted the order; Full name, position of the employee who delivered the order.
Only an administrator can fill in the document "Setting sales bonuses", the data entered is: the item, the amount of the bonus per unit of goods, as well as the person in charge. This document is linked to the periodic register of information "Scale of sales bonuses" with a conduction period within a day, as well as the "Bonuses" report. The "Bonuses" report is associated with the documents: "Sales", "Contractor", "Manager" and "Nomenclature". With the help of the periodic register of information "Scale of bonuses" traces the number of sales, the amount of the bonus per unit of goods and displays the amount of remuneration for the entered period of time in the report settings.
The document "Settlements with a counterparty" allows you to manually enter the initial balances when filling out this document, as well as what document is needed to reflect documents that are not in the database. The entry of the initial balances is the remaining debts for counterparties, which will be entered into the new database. In the previous version of the database, this document contained only information about counterparties and the amount of debt, therefore, it is required to add to this document the column "contracts" and also "organization" to simplify the work of employees with the document.
In this document, entering information about bank cards of employees, it is required to implement the columns: "Responsible" (who will fill out the document, that is, an accountant), "Method of payment" (you can through a bank or cash desk), "Employee" (means that to whom the salary will be issued), "Bank" (details of the bank responsible for issuing salaries to the employee), and the "Card number" of the employee. All this information is entered into the information system using this document. Access to the document is carried out through the menu items (interface Payroll of employees of the organization):Payroll - Cashier and Bank - Entering information about employees' bank cards. Implementation of the document "Entering information about bank cards of employees" will allow to avoid issuing wages to employees of the enterprise by accountants and cashiers to calculating it directly from the bank account to the employee's card.
Conclusion
In the course of the graduation project, the main database architectures were considered, the main types of reports and documents in the 1C: Enterprise 8.2 system were studied, the search for the best database performance was carried out, and the analysis of analogs of similar databases was carried out. The result of the work was a database for the wholesale trade enterprise "MITLINE" LLC. The developed database allows automating the work of the enterprise, moving from cash payments of wages to payment by bank cards, adding a document that allows you to immediately fill in the initial balances of the enterprise, as well as a document that will allow managers to accrue bonuses from the sale of goods.
As a result of testing, some shortcomings of the software product were identified, however, due to the short time of software development and testing, the complexity of its functionality and the features of the tools used, these shortcomings are quite acceptable and do not affect the main tasks performed by the application. In the future, with the maintenance of this software product and its completion, most of its shortcomings will be corrected, and the functionality will be expanded.
References
- М.Г, Радченко. 1С:Предприятие 8.1. Практическое пособие разработчика. Примеры и типовые приёмы. Питер : "СПб Питер", 2007.
- Митичкин, С.А. Разработка в системе 1С:Предприятие 8.0. Питер : "СПб Питер", 2003.
- Радченко, М.Г. Архитектура и работа с данными 1С:Предприятие 8.2. Питер : "СПб Питер", 2010.
- Хрусталева, Е.Ю. Разработка сложных отчетов в 1С:Предприятии 8. Система компоновки данных. Питер : "СПб Питер", 2008.