KR20220057721A - System and method for providing office ERP solution based on document form big data - Google Patents

Abstract

The present invention relates to a system and method for providing an office ERP solution based on document form big data, which can enable an ERP user to select and use a form to be used or an existing independently used form such as Excel, Word, Hangul or the like, thereby conveniently computerizing manual enterprise resource planning at a low cost. When an ERP solution user searches for and selects a document form through access using a user terminal, an ERP server provides a result of searching for the document form and the selected document form in the same input form as an output form from a document file database, thereby enabling the user to perform document work in an existing way, and, accordingly, there is no need for a high cost or a special instruction due to the introduction of ERP, and, meanwhile, enterprise resource planning in accordance with a work process can be performed by automatically processing the input data.

Description

System and method for providing office ERP solution based on document form big data

The present invention relates to ERP for office use, and in particular, by enabling ERP users to select and use the form to be used or the document form previously used in Excel, Word, Korean, etc. It relates to a system and method for providing ERP solution for office work centered on big data in document form that can be easily computerized.

ERP (Enterprise Resources Management System), which consists of finance, human resources, materials, projects, and maintenance, is introduced in the order of system construction, system training, operation management/support after initial consulting.

The reason for the introduction of ERP is to integrate company resources for each individual, department, and division, and the main purpose is for efficient financial management, continuous business connection, and optimal business management.

In ERP, global companies such as SAP and Oracle are leading the market, and Oracle is making strides forward due to the nature of the existing ERP, which is centered on relational databases.

The basic form of the existing ERP, which converts all corporate assets into a database and outputs reports and documents necessary for work, has been maintained from the 1970s to the present. is following the existing system.

Looking at the domestic market situation, against foreign ERP, which is dominating the ERP market for large enterprises more than medium-sized companies, LGCNS is showing prominence in the market with customized strategies, etc. Although BIZON is widening the gap with other ERP companies with a market share of more than 80%, the reality is that the cost, training time, and difficulties in business application are very large for use by small and medium-sized enterprises and small business owners.

In particular, today's ERP has many different parts from the company's existing business, so it is difficult to understand and use ERP to the extent that high training costs occur even when using the introduced ERP. There is a problem.

KR 10-1773054 B1 (2017.08.24) KR 10-1428749 B1 (2014.08.04) KR 10-1944973 B1 (2019.01.28) KR 10-2006-0110530 A (2006.10.25)

Therefore, the present inventor comprehensively considers the above-mentioned issues and focuses on solving the limitations and problems of the existing ERP, and SaaS (Software as a Service) that can be easily used with minimized cost and time burden even in small business and small business-scale office work a Service), the present invention was created as a result of continuous research with an effort to develop a document format-oriented ERP.

Therefore, the technical task and purpose to be solved by the present invention is a document format big data-oriented office that can provide an ERP in the form of SaaS that can be easily used to small and medium-sized enterprises (SMEs) who are burdened with cost and time to use their own ERP or specific ERP. It is to provide an ERP solution providing system and method.

In addition, another technical problem and object to be solved by the present invention is an office ERP solution centered on document form big data that can increase business connectivity, security, and continuity to companies that have downloaded and used forms from Yesform, Bizform, etc. It is intended to provide a delivery system and method.

Here, the technical problems and objects to be solved by the present invention are not limited to the technical problems and objectives mentioned above, and other technical problems and objects not mentioned will be clearly understood by those skilled in the art from the following description.

A document form big data-oriented office ERP solution providing system according to the present invention for achieving the above object, a user terminal accessing the office ERP solution providing system through a web browser and an app; a web server providing a wired/wireless network so that the user terminal accesses the office ERP solution providing system; a document file database for storing document forms having a unique identifier (ID) for each input item by assigning an individual unique code, and providing the document form according to a search and selection request; a customer database for storing the data input from the user terminal together with the unique code of the document form and the unique identifier of the input item; and searching and calling the document form stored in the document file database according to the request of the user terminal, providing the called document form in the same input form as the output form, and using the data stored in the customer database It is characterized in that it is configured to include; an ERP server that is provided in combination with the related document form.

In addition, in the document form big data-oriented office ERP solution providing system according to the present invention, the document file database stores templates matching the document form to different program formats, and the ERP server is the document of the user terminal. It is characterized in that the template is provided along with the data according to the selection of the output format of the form.

In addition, in the method of providing an office ERP solution centered on document form big data according to the present invention for achieving the above object, when the ERP solution user accesses the user terminal through a user terminal to search for and select a document form, the ERP server generates a document file providing the search result of the corresponding document form from the database and the selected document form in the same input form as the output form; When data is input in the provided document form, a data table including the input data, the document code of the document form, and a unique identifier of the corresponding input item of the document form in which the data is input is created and stored in the customer database and generating a document index table including the position of the document form by matching the document code and storing the document index table in a document file database; and when there is a call of a pre-written document from the user terminal, checking a document code of the called document from the data table, checking a form position in the document index table, and displaying the called document on the user terminal It is characterized in that it consists of ;

In addition, in the method of providing an office ERP solution centered on document form big data according to the present invention, the document form provided in the same input form as the output form creates an arbitrary document form in HTML, converts it into CSS, and It is characterized in that a plurality of ejs templates are generated for each different software format and stored in the document file database.

In addition, in the method of providing an office ERP solution centered on document format big data according to the present invention, the data table is characterized in that the input data is recorded in JSON format.

As described above, the present invention automatically processes all input data other than determining which form to use while allowing the ERP-introducing company to maintain the existing business system as it is, so that only the document form to be used is selected and the work is managed. The advantage is that there is no introduction cost.

In addition, the present invention has an advantage in that the ERP introduction failure rate is significantly lowered because it is tried according to the size of the company and a form is added according to business expansion.

In addition, the present invention does not deviate from the large frame of the existing method, so it is possible to minimize the training cost, and free from the preconceived notion that ERP is difficult, computerization of business of small and medium-sized companies, including small business owners, using only simple document forms such as quotations and transaction statements. There is a possible effect.

1 is a conceptual diagram of an office ERP solution centered on document form big data according to the present invention;
2 is a block diagram of a system for providing ERP solution for office use centered on document form big data according to the present invention;
3 is a view showing an estimate in the form of a document having a unique document number assigned with a unique code to each input item as an example according to the present invention;
4 is an exemplary view of document forms to which a document code stored in a document file database is assigned according to the present invention;
5 is an exemplary view of a data table in which data input by a user is stored in a customer database in a Jason format according to the present invention;
6 is an exemplary diagram of a document index table for finding a document form previously prepared by a user according to the present invention;

Hereinafter, an embodiment of a system and method for providing an office ERP solution centered on document form big data according to the present invention will be described in detail with reference to the drawings. The embodiments described below are provided to completely inform those of ordinary skill in the art of the scope of the invention, and the present invention is not limited to the embodiments disclosed below and may be implemented in various forms.

Like elements in the drawings denote like numerals wherever possible. Specific specific details are shown in the following description, which are provided to help a more general understanding of the present invention, and are not intended to limit the present invention to specific embodiments, and all changes included in the spirit and scope of the present invention , should be understood to include equivalents or substitutes. In the description of the present invention, if it is determined that a detailed description of a related known function or configuration may unnecessarily obscure the gist of the present invention, the detailed description thereof will be omitted.

Here, the accompanying drawings show that parts are exaggerated or simplified for convenience and clarity of explanation and understanding of the configuration and operation of the technology, and it is revealed that each component does not exactly match the actual size.

Terms such as first, second, etc. may be used to describe various elements, but the elements are not limited by the terms. The above terms are used only for the purpose of distinguishing one component from another. For example, without departing from the scope of the present invention, a first component may be referred to as a second component, and similarly, the second component may also be referred to as a first component.

When an element is referred to as being “connected” or “connected” to another element, it is understood that it may be directly connected or connected to the other element, but other elements may exist in between. should be On the other hand, when it is mentioned that a certain element is "directly connected" or "directly connected" to another element, it should be understood that no other element is present in the middle.

The singular expression includes the plural expression unless the context clearly dictates otherwise. In the present application, terms such as “comprise” or “have” are intended to designate that a feature, number, step, operation, component, part, or combination thereof described in the specification exists, but one or more other features It should be understood that this does not preclude the existence or addition of numbers, steps, operations, components, parts, or combinations thereof.

In addition, when it is said that a part includes a certain component, it does not exclude other components unless otherwise stated, but it means that other components may be further included, and the meaning of the term "part" denotes a unit or module form that processes at least one function or operation, which may be implemented as hardware or software or a combination of hardware and software.

Unless defined otherwise, all terms used herein, including technical and scientific terms, have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. Terms such as those defined in a commonly used dictionary are defined in consideration of the function in the present invention, which should be interpreted as a concept consistent with the technical idea of the present invention and a meaning commonly or commonly recognized in the art. and, unless explicitly defined in the present application, it should not be construed in an ideal or excessively formal sense.

Combinations of each block in the accompanying block diagram and each step in the flowchart may be performed by computer program instructions. These computer program instructions may be embodied in a processor of a general-purpose computer, special purpose computer, or other programmable data processing equipment, such that the instructions executed by the processor of the computer or other programmable data processing equipment may be configured in the respective blocks of the block diagram or of the flowchart. Each step creates a means for performing the described functions.

These computer program instructions may also be stored in a computer-usable or computer-readable memory that may direct a computer or other programmable data processing equipment to implement a function in a particular manner, and thus the computer-usable or computer-readable memory. The instructions stored in the block diagram may also produce an item of manufacture containing instruction means for performing a function described in each block of the block diagram or each step of the flowchart.

The computer program instructions may also be mounted on a computer or other programmable data processing equipment, such that a series of operational steps are performed on the computer or other programmable data processing equipment to create a computer-executed process to create a computer or other programmable data processing equipment. It is also possible that instructions for performing the processing equipment provide steps for carrying out the functions described in each block of the block diagram and in each step of the flowchart.

Further, each block or each step may represent a module, segment, or portion of code comprising one or more executable instructions for executing specified logical function(s). It should also be noted that in some alternative embodiments it is also possible for the functions recited in blocks or steps to occur out of order. For example, it is possible that two blocks or steps shown one after another may in fact be performed substantially simultaneously, or that the blocks or steps may sometimes be performed in the reverse order according to the corresponding function.

1 is a conceptual diagram of an office ERP solution centered on document form big data according to the present invention. The office ERP solution centered on document form big data according to the present invention is its own ERP through a paradigm shift that converts all document forms into data. Or, for companies that have downloaded and used document forms from SMEs, Yesform, and Bizform, etc., which are burdensome in cost and time to use a specific ERP, computerization that increases the connectivity, security, and continuity of work with minimized cost and time burden The conversion is made immediately, and it has its technical characteristics.

Except for large enterprises that already use their own ERP or ERP with the highest specifications, the reason why even 100-1000-person companies did not introduce or fail to introduce ERP for the office is that the existing ERP is expensive and anyone can easily access it. This is because there are difficulties in use to the extent that special training is required for use, maintenance, and management.

Therefore, the office ERP solution centered on document format big data according to the present invention provides ERP in the form of SaaS (Software as a Service) that anyone can use easily.

2 is a block diagram of an office ERP solution providing system centered on document form big data according to the present invention. In the present invention, the ERP server 100 is a user terminal 500 connected to a service page through the web server 400 . It provides office ERP solution service centered on document form big data.

Accordingly, the user who has subscribed to the document form big data-oriented office ERP solution service according to the present invention accesses the service providing web page or app according to the present invention through the user terminal 500, and then needs to You can search for a document form to be used, select a desired document form from the search results, enter data as in the existing method, complete the document creation, and perform document work such as printing.

That is, since the user works with the document as it is in the existing method, there is no need for an expensive cost or special training for introducing the ERP according to the present invention. As usual, instead of searching for the quotation to be made on their PC or Bizform or Yesform, the user accesses the office ERP solution service centered on the document form big data according to the present invention, searches for the quotation, and enters data in the searched quotation. It is saved, and in order to deliver the saved file to the counterparty, output it in a format suitable for the program (viewer) desired by the counterparty.

The document form big data-oriented office ERP solution according to the present invention allows the user to select a document form and input data to create an arbitrary document as usual or to perform daily tasks such as calling and modifying an already created document. And, by storing the input data in connection with the document form selected by the ERP server according to the present invention, the input data is automatically processed according to the business process without any additional work by the user, thereby accounting, taxation, and sales aggregation It automatically collects and derives financial and management indicators such as financial statements and income statements. For document work performed by users on a daily basis, the data entered by the user are automatically stored in the database, change history data such as correction and deletion are managed, and numeric data such as amounts are automatically converted into a database and processed as related accounting. By processing the stored data, management information and business reports are automatically organized, and the online payment system is also applied.

On the other hand, the daily work of a company is a repetition of tasks that the user has to endure every time he or she has to go through the trouble of searching his or her PC or searching for a colleague's PC in order to find a specific document prepared in advance, and regardless of the size of the company, regardless of the size of the company, large or small. In an office environment that is not computerized, this makes work difficult.

Therefore, the office ERP solution centered on the document form big data according to the present invention converts various document forms necessary for daily work of the company into data and processes it into big data, and provides the specific document form searched for according to the user's request as it is, and is created By continuously managing documents and data, users can quickly and easily find and use previously created documents.

In particular, the office ERP solution centered on document form big data according to the present invention provides the same input form as the output form for the various document forms shown in FIG. Users can search the document form in the usual way, enter data in the searched document form, print it out and send it by fax, or save it in a specific program format and send it by e-mail. Although the user routinely calls an arbitrary document form and inputs data to create one document, the office ERP solution centered on document form big data according to the present invention provides the document form (data about) and the data entered by the user. is stored in the database, and this data is processed according to the business process to perform enterprise-wide resource management.

To this end, the office ERP solution centered on the document form big data according to the present invention is HTML (Hypertext) first, It is produced in Mark-up Language). Then, the document form made in HTML is converted into CSS (Cascading Style Sheets). HTML has many restrictions in designing web documents in various ways and changing them frequently. By converting them to CSS, the overall document consistency is maintained and the need for detailed styling is reduced.

In addition, each software format is converted into CSS to provide a document format that is suitable for the program format that is used according to the user environment using various different software (Korean, MS Word, MS Excel, MS powerpoint, pdf, printer document). Create each ejs template for writing variable values using Node JS for the document form.

That is, Quote #1.html is converted to Quote #1.css, and it is converted into Quote #1-Hangul.ejs, Quote #1-Word.ejs, Quote #1-Excel.ejs, Quote #1-Powerpoint.ejs. Ejs templates are created for each program format with high usage rate, such as , quote#1-pdf.ejs, and quote#1-printer file.ejs. The ejs template is stored based on a unique ID (document code) in the document file database 200 by the ERP server 100 . In FIG. 3, an estimate to which a unique document number (doc1111) is assigned is shown as an example. Each input item on the estimate shown in FIG. 3 is assigned a unique code (ID). Therefore, when data is input to the corresponding input item, the ERP server 100 stores the input data in the customer database 300 based on the unique code.

Fig. 4 shows an example of the document forms to which the document code stored in the document file database 200 is assigned. As shown in Fig. 4, the document forms made of the ejs template stored in the document file database 200 with a unique document code are outputted after the user creates a document by inputting data into the document form. It is provided through the user terminal 500 such as a PC, a smart phone, or a smart pad according to a format (Hangul, Word, Excel, PowerPoint, PDF, printer document, etc.) is selected.

When the user selects a format that the user wants to output, the ERP server 100 calls the ejs template generated in the corresponding format from the document file database 200 to display the document written by the user in the corresponding format on the user terminal 500 .

The document form according to the present invention generated as described above has a unique ID for each entry item. Therefore, when the user inputs data to the corresponding item, the ERP server 100 according to the present invention converts the input data based on the unique code of the corresponding item into the customer database 300 in the Jason (JavaScript Object Notation, JSON) format. ) is stored in This is shown as an example in FIG. 5 . As shown in Fig. 5, the input data for the unique code is recorded in JSON format, and the associated document form is also recorded in the data table together with the unique document code. JSON can record a lot of data in the input data field without increasing the fields of the data table, so it is possible to implement this function of JSON in other formats that can be implemented.

In addition, the ERP server 100 according to the present invention records and manages a previously prepared document form in a document index table as shown in FIG. 6 .

Accordingly, when the user calls a pre-written document, the ERP server 100 according to the present invention checks the document code matching the input data recorded in JSON format with reference to the data table, and matches the confirmed document code. The position of the document form is checked in the document index table of FIG. 6, the document form is called from the document form position of the confirmed document file database 200, customer data is retrieved from the customer database 300, and it is combined with the user ( terminal) is provided.

The document file database 200 may be implemented in NoSQL or MongoDB, and thus provides a mechanism for storing and retrieving document forms to the user. The customer database 300 may be implemented as a general relational database (RDB).

In the document file database 200 , in addition to the document form, common data on available assets of the company may be stored and searched for, and various options may be applied thereto.

The data stored in the customer database 300 and input by the user while filling out the document form is CRM (Customer Relationship Management), SCM (Supply Chain Management), National Tax Service, It is used in connection with electronic payment, etc.

As described above, the system and method for providing an ERP solution for office use centered on document form big data according to the present invention allows the ERP-introducing company to maintain the existing business system as it is, while only allowing the user to select a form and fill out the corresponding document form. As all input data is automatically processed with this system, there is no high cost associated with the introduction of ERP, and there is no deviation from the existing method, so training costs can be minimized. It is possible to computerize the work of small and medium-sized companies, including small business owners, just by using the existing document form, such as small business owners, and the failure rate of ERP introduction is remarkably low because only the relevant document form is added according to the business expansion.

On the other hand, although the detailed description of the present invention has been described in detail with reference to the preferred embodiments referred to by the accompanying drawings, various modifications are possible without departing from the scope of the present invention. Therefore, the scope of the present invention should not be limited to the described embodiments and should be defined by the claims described below as well as the claims and equivalents.

100: ERP server 200: document file database
300: customer database 400: web server
500: user terminal

Claims (5)

In the office ERP solution providing system,
a user terminal accessing the office ERP solution providing system through a web browser and an app;
a web server providing a wired/wireless network so that the user terminal accesses the office ERP solution providing system;
a document file database for storing document forms having a unique identifier (ID) for each input item by assigning an individual unique code, and providing the document form according to a search and selection request;
a customer database for storing the data input from the user terminal together with the unique code of the document form and the unique identifier of the input item; and
According to the request of the user terminal, the search and call of the document form stored in the document file database is performed, the called document form is provided in the same input form as the output form, and the data stored in the customer database is related ERP server that provides combined with document form; Document form big data-centered office ERP solution providing system including;
The method of claim 1,
The document file database is
storing the template that matches the document format to different program formats,
The ERP server,
An office ERP solution providing system centered on document form big data, characterized in that the template is provided together with the data according to the selection of the output format of the document form of the user terminal.
In the method of providing an office ERP solution,
When the ERP solution user accesses the user terminal and searches for and selects a document form, the ERP server provides the search result of the document form from the document file database and the selected document form as the same input form as the output form;
When data is entered into the provided document form, a data table including the input data, the document code of the document form, and a unique identifier of the corresponding input item of the document form into which the data is input is created and stored in the customer database and generating a document index table including the position of the document form by matching the document code and storing the document index table in a document file database; and
displaying the called document on the user terminal by checking the document code of the document called from the data table, checking the form position in the document index table, when there is a call of the previously prepared document from the user terminal; A method of providing ERP solution for office work centered on big data in document form.
The method of claim 3, wherein the document form provided in the same input form as the output form,
A method of providing an office ERP solution centered on document form big data, characterized in that an arbitrary document form is written in HTML, converted to CSS, and a plurality of ejs templates are created for each different software format and stored in the document file database .
According to claim 3 or 4, wherein the data table,
A method of providing an office ERP solution centered on document form big data, characterized in that the inputted data is recorded in JSON format.

Images