Master creation device, master creation method, and master creation program

Abstract

To provide a master data creation device, a master data creation method, and a master data creation program that can efficiently suggest related recommended products. [Solution] The master creation device according to this embodiment includes a master creation means that, in response to an operator's operation on the master creation screen, specifies the products to be handled and the period, acquires sales slips containing the specified products from sales data for the specified period, calculates the quantity of each product other than the products handled in the acquired sales slip as a ratio to the quantity of the products handled in the same sales slip, creates a related recommendation master including the products handled, line number, related recommended products which are the products in the acquired sales slip, and the calculated quantity, and registers it in the storage area.

Description

Technical Field

[0001] The present invention relates to a master creation device, a master creation method, and a master creation program.

Background Art

[0002] For example, when receiving an order for a product, there may be a case where it is desired to propose related recommended products. Conventionally, as a system for creating a master, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, the additional proposal of related recommended products has depended on the know-how and information volume of sales staff, so there is a problem that the proposal of related recommended products cannot be efficiently performed.

[0005] The present invention has been made in view of the above, and an object thereof is to provide a master creation device, a master creation method, and a master creation program capable of efficiently proposing related recommended products.

Means for Solving the Problems

[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides a master creation device equipped with a control unit, wherein the control unit is configured to access a storage area that stores sales data including sales number, line number, sales date, product, and quantity, and is characterized by having a master creation means that, in response to an operator's operation on a master creation screen, specifies the products to be handled and a period, acquires sales slips containing the specified products from the sales data for the specified period, calculates the quantity of each product other than the products handled in the acquired sales slip as a ratio to the quantity of the products handled in the same sales slip, creates a related recommendation master including the products to be handled, line number, related recommended products which are the products in the acquired sales slip, and the calculated quantity, and registers it in the storage area.

[0007] Furthermore, according to one aspect of the present invention, the master creation means may display the products of the acquired sales slips as candidates for related recommended products in order of the number of items in a predetermined area of ​​the master creation screen, and create the related recommended master for the products selected by the operator.

[0008] Furthermore, according to one aspect of the present invention, the control unit may also be provided with order entry means that, in response to an operator's operation on the order entry screen, when a product to be handled and a quantity to be deployed are specified, refers to the related recommendation master and displays related recommended products associated with the specified product to be handled.

[0009] Furthermore, according to one aspect of the present invention, the order input means may calculate and display the quantity of related recommended products by multiplying the specified deployment quantity by the quantity of the related recommended products in the recommendation master.

[0010] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention is a master creation method performed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a storage area that stores sales data including sales number, line number, sales date, product, and quantity, and the method is characterized by including a master creation step performed by the control unit, in response to an operator's operation on a master creation screen, specifying the products to be handled and a period, acquiring sales slips containing the specified products from the sales data for the specified period, calculating the quantity of each product other than the products to be handled in the same sales slip as a ratio to the quantity of products to be handled in the same sales slip, creating a related recommendation master including the products to be handled, line number, related recommended products which are the products of the acquired sales slip, and the calculated quantity, and registering it in the storage area.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention is a master creation program to be executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a storage area that stores sales data including sales number, line number, sales date, product, and quantity, and the program is characterized in that it causes the control unit to execute a master creation process in which, in response to an operator's operation on a master creation screen, the product to be handled and a period are specified, for the specified period, sales slips containing the specified product to be handled are obtained from the sales data for the specified period, for each product other than the product to be handled in the obtained sales slip, the quantity is calculated as a ratio to the quantity of the product to be handled that exists in the same sales slip, a related recommendation master is created that includes the product to be handled, line number, related recommended product which is the product of the obtained sales slip, and the calculated quantity, and the master is registered in the storage area. [Effects of the Invention]

[0012] The present invention has the effect of enabling the efficient provision of recommendations for related products. [Brief explanation of the drawing]

[0013] [Figure 1]FIG. 1 is a block diagram showing an example of a master creation device according to the present embodiment. [Figure 2] FIG. 2 is a diagram showing a configuration example of a product master. [Figure 3] FIG. 3 is a diagram showing a configuration example of a product unit price master. [Figure 4] FIG. 4 is a diagram showing a configuration example of a related recommended master. [Figure 5] FIG. 5 is a diagram showing a flow for explaining an outline of the overall processing flow of the control unit of the master creation device. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the processing of the control unit of the master creation device. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the master creation device. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the master creation device. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the processing of the control unit of the master creation device. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the master creation device. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the master creation device. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the master creation device. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the processing of the control unit of the master creation device. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the processing of the control unit of the master creation device. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the processing of the control unit of the master creation device.

Embodiments for Carrying Out the Invention

[0015] [1. Overview] The overview of the present invention will be described in the order of "1-1. Problem", "1-2. Solution", and "1-3. Effect".

[0016] "1-1. Problem" When accepting an order for a product, there may be a case where it is desired to propose related recommended products. However, the additional proposal of related recommended products has depended on the know-how and information volume of each salesperson, so there is a problem that the proposal of related recommended products cannot be efficiently carried out. Also, salespersons who can make additional proposals also need to input related recommended products on the order input screen respectively, and there is a problem that the input load is large.

[0017] "1-2. Solution" Therefore, in the present invention, by creating a related recommendation master in which related recommended products of transaction products are registered based on sales results, it is possible to efficiently propose related recommended products without depending on the know-how and information volume of the person in charge. As a result, when receiving an order, it is possible to propose recommended products and lead to an increase in sales.

[0018] Also, in the present invention, an item for describing the presence or absence of recommended products is provided on the order input screen, and when there are related recommended products, for example, it is possible to make a proposal even while receiving a telephone order. Also, since related recommended products can be developed from the patterns registered in the related product master, the input load can be reduced.

[0019] "1-3. Effect" For example, when there are many products and it takes time to acquire knowledge, it is possible to make an additional proposal of related recommended products without depending on knowledge. As a result, it is possible to improve sales and acquire product (sales) knowledge at an early stage.

[0020] This invention is applicable to companies in any industry, particularly wholesale companies handling a large number of products. Furthermore, it is also possible to register related recommended products in the master data based not only on sales but also on purchase history (purchase data). In other words, a related recommendation master can be created based on transaction data such as sales data and purchase data.

[0021] [2. Structure] An example of the configuration of the master creation device according to this embodiment will be described with reference to the drawings.

[0022] Figure 2 is a block diagram showing an example of a master creation device according to this embodiment. The master creation device 100 is a workstation or a commercially available desktop personal computer, etc.

[0023] The master creation device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the master creation device 100 is connected to communicate via any communication path.

[0024] The communication interface unit 104 connects the master creation device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines. The communication interface unit 104 has the function of communicating data with other devices via communication lines. Here, the network 300 has the function of connecting the master creation device 100 with the server 200 and terminals 400... to enable mutual communication, and is, for example, the internet or a LAN (Local Area Network). As a result, the communication interface unit 104 is configured to communicate data with the server 200 and terminals 400... via the network 300. Terminals 400... are employee terminals.

[0025] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, a mouse, a microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or mouse 112.

[0026] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

[0027] Furthermore, the following is stored in this memory unit 106. Figure 2 shows an example of the configuration of the product master 106a. Figure 3 shows an example of the configuration of the product unit price master 106b. Figure 4 shows an example of the configuration of the related recommendation master 106c.

[0028] As shown in Figure 2, the product master 106a can consist of tables that register product codes and product names in association. The product master 106a is referenced when converting between product codes and product names.

[0029] As shown in Figure 3, the product unit price master 106b can consist of tables that associate products (product code and / or product name) with their unit prices (yen). The product unit price master 106b is referenced when calculating the price of a product on the order entry screen.

[0030] As shown in Figure 4, the related recommendation master 106c can consist of a table or similar document that associates and registers the handled product (handled product code and / or handled product name), row number, related recommended product (related recommended product code and / or related recommended product name), and quantity. The related recommendation master 106c is referenced on the order entry screen when displaying related recommended products for handled products and when calculating their quantities.

[0031] Sales data may include sales number, line number, sales date, product (product code and / or product name), and quantity.

[0032] The control unit 102 is a CPU or similar component that comprehensively controls the master creation device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0033] The control unit 102 is configured to access the product master 106a, product unit price master 106b, related recommendation master 106c, sales data, order data, etc., which are stored in the storage unit 106. Note that the product master 106a, product unit price master 106b, related recommendation master 106c, sales data, order data, etc. may be located in another location (for example, on the server 200), as long as the control unit 102 can access them.

[0034] Functionally, the control unit 102 comprises a sales input unit 102a, a master data creation unit 102b, an order input unit 102c, and a screen display control unit 102d.

[0035] The sales input unit 102a inputs sales data, including sales number, line number, sales date, product, and quantity, in response to, for example, the operator's actions on the sales input screen (not shown) displayed on the monitor 114, and registers it in the storage unit 106.

[0036] The master creation unit 102b, in response to the operator's operation on the master creation screen, specifies the products to be handled and the period, retrieves sales slips containing the specified products from the sales data for the specified period, calculates the quantity of each product other than the products handled in the retrieved sales slip as a ratio to the quantity of the products handled in the same sales slip, creates a related recommendation master 106c including the products handled, line number, related recommended products that are products in the retrieved sales slips, and the calculated quantities, and registers it in the storage unit 106.

[0037] The master creation unit 102b may display the products from the acquired sales slips as candidates for related recommended products in order of the number of line items in a designated area of ​​the master creation screen, and create a related recommended master 106c for the products selected by the operator.

[0038] The order entry unit 102c inputs order data and registers it in the storage unit 106, for example, in response to the operator's actions on the order entry screen displayed on the monitor 114.

[0039] In this case, the order entry unit 102c may, for example, refer to the related recommendation master 106c and display related recommended products associated with the specified product when the product to be handled and the quantity to be deployed are specified in response to the operator's operation on the order entry screen displayed on the monitor 114. The order entry unit 102c may calculate and display the quantity of related recommended products by multiplying the specified expansion quantity by the quantity of the related recommended product in the related recommended master 106c.

[0040] The screen display control unit 102f controls the display and input reception of various screens (for example, a master creation screen, an order entry screen, etc.) displayed on the monitor 114.

[0041] [3. Specific Examples] A specific example of the processing of the control unit 102 of the master creation device 100 according to this embodiment will be described with reference to Figures 1 to 15.

[0042] (3-1. Overall Processing) Figure 5 is a flowchart illustrating the overall processing flow of the control unit 102 of the master creation device 100. The overall processing flow of the control unit 102 of the master creation device 100 will be explained with reference to Figure 5.

[0043] The sales input unit 102a executes the sales input process (step S1). Specifically, in the sales input process, the sales input unit 102a inputs sales data, including sales number, line number, sales date, product, and quantity, in response to operations by an operator (e.g., a sales department employee) on the sales input screen (not shown) displayed on the monitor 114, and registers it in the storage unit 106.

[0044] The master creation unit 102b executes the related recommendation master creation process (step S2). Specifically, in the related recommendation master creation process, the master creation unit 102b specifies the products and period in response to the operator's (for example, a person in charge of the management planning department) operation on the master creation screen, retrieves sales slips containing the specified products from the sales data for the specified period, calculates the quantity of each product other than the products in the retrieved sales slip as a ratio to the quantity of the products present in the same sales slip, creates a related recommendation master 106c including the products, line number, related recommendation products which are the products in the retrieved sales slips, and the calculated quantities, and registers it in the storage unit 106.

[0045] The order entry unit 102c executes the order entry process (step S3). Specifically, in the order entry process, the order entry unit 102c, for example, in response to the operation of an operator (sales department representative) on the order entry screen displayed on monitor 114, when the product to be handled and the quantity to be distributed are specified, refers to the related recommendation master 106c and displays related recommended products associated with the specified product to be handled.

[0046] (3-2. Sample Data) Referring to Figures 6 to 15, a specific example of the processing performed by the control unit 102 of the master data creation device 100 will be explained. Figures 6 to 15 are diagrams illustrating a specific example of the processing performed by the control unit 102 of the master data creation device 100. For the sake of clarity, the master data and data are numbered in the following explanation. The following explanation will be based on sales data for July 2022.

[0047] (S1: Sales entry processing) A specific example of the sales input process will be explained with reference to Figure 6. The sales input unit 102a inputs sales data, including sales number, line number, sales date, product, and quantity, in response to, for example, the operator's actions on the sales input screen (not shown) displayed on the monitor 114, and registers it in the storage unit 106.

[0048] Figure 6(A) shows an example of sales data (July 2022). The sales data includes the following fields: sales number, line number, sales date, product, and quantity. Sales slips with the same sales number are considered the same. In the example shown in the figure, the first line has the sales number "MT001", line number "1", sales date "2022 / 7 / 1", product "SH01", and quantity "60 units", while the second line has the sales number "MT001", line number "2", sales date "2022 / 7 / 1", product "SH02", and quantity "60 units".

[0049] Figure 6(B) shows an example of data in product master 106a. Product master 106a has fields for product code and product name. In the example shown in the figure, the first row has product code "SH01" and product name "Adhesive (1)", and the second row has product code "SH02" and product name "Adhesive (2)".

[0050] Figure 6(C) shows an example of data from the product unit price master 106b. The product unit price master 106b has fields for product code and unit price (yen). The first row shows product code "SH01" and unit price "800", and the second row shows product code "SH02" and unit price "800".

[0051] (S2: Related Recommended Master Creation Process) Refer to Figures 7 to 11 to explain a specific example of the related recommendation master creation process. The master creation unit 102b, in response to the operator's operation on the master creation screen, specifies the products to be handled and the period, retrieves sales slips containing the specified products from the sales data for the specified period, calculates the quantity of each product other than the products handled in the retrieved sales slips as a ratio to the quantity of the products handled in the same sales slip, creates a related recommendation master 106c including the products handled, line number, related recommendation products that are products of the retrieved sales slips, and the calculated quantity, and registers it in the storage unit 106. The master creation unit 102b may also display the products of the retrieved sales slips as candidates for related recommendation products in order of the number of details in a predetermined area of ​​the master creation screen (for example, the candidate display area), and create a related recommendation master 106c for the products selected by the operator. In the related recommendation master creation process, in order of products sold together with the products handled, the related recommendation master 106c is created based on sales data.

[0052] Figure 7 shows an example of the display of the main screen 500 of the related recommendation master creation screen. On the main screen 500, after entering the products to be handled and pressing the display button, a list of related recommended products will be displayed from the sales data.

[0053] As shown in Figure 7, the main screen 500 includes a header section 501 for specifying the products to be handled and extraction conditions (actual date), a display button for displaying related recommended product candidates in the candidate display section 502, a candidate display section 502 for displaying sales data that matches the extraction conditions as related recommended product candidates, and a registration button for registering the related recommended product candidates displayed in the candidate display section 502 to the related recommendation master 106c. The candidate display section 502 displays checkboxes for selecting rows, product codes, product names, quantities, units, number of details, and rows (see Figure 8). When the products to be handled and extraction conditions are entered and the display button is pressed, sales data that matches the extraction conditions is extracted and related recommended product candidates are displayed in the candidate display section 502.

[0054] In the example shown in Figure 7, the product "SH01" and the extraction conditions (actual dates) "2022 / 7 / 1~2022 / 7 / 31" are specified. When the display button is pressed, as shown in Figure 8(A), candidate recommended products are displayed in the candidate display unit 502. Since these are candidate recommended products, the actual product is not displayed. In this example, row "1" has product code "SH02", product name "Adhesive (2)", quantity "1", unit "piece", and number of details "4", and row "2" has product code "SH03", product name "Adhesive Refill", quantity "2", unit "piece", and number of details "3".

[0055] When a row is selected (for example, by double-clicking), the details screen 600 for editing the selected row is displayed, as shown in Figure 8(B). In this details screen 600, the details of the selected row can be edited. After editing in the details screen 600 and pressing the register button within the details screen 600, the edited content is reflected in the candidate display unit 502. In this example, row "1" is selected, and the details screen 600 for row "1" is displayed.

[0056] When a selection is made in the selection box in the candidate display unit 502 and the registration button in the main screen 500 is pressed, the details of the selected row are registered in the related recommendation master 106c.

[0057] Refer to Figures 9 to 11 to explain the creation logic for the related recommended master 106c. (1) Acquisition of target data From the sales data for the target period of the actual date (in this example, "2022 / 7 / 1" to "2022 / 7 / 31"), we obtain the details of sales slips (details with the same sales number as the handled product) that include the handled product (in this example, "SH001"), excluding the handled product. Figure 9 shows an example of sales data for the target period "2022 / 7 / 1" to "2022 / 7 / 31". In this example, details for NO2,4,5,7,8,9,11,12,14,15 are obtained.

[0058] (2) The quantity for each product is totaled, the number of sales details in the sales data is counted, the data is sorted in descending order of the number of details, and displayed in the candidate display unit 502. For each product, the "quantity" is calculated as a ratio to the total quantity of products handled. Figure 10 shows an example of intermediate data generated by aggregating the quantity for each product, counting the number of sales details in the sales data, and sorting them in descending order of the number of details. Based on this intermediate data, related recommended product candidates are displayed in the candidate display unit 502.

[0059] Let's explain the formula for calculating "quantity." The quantity of each product is calculated as a ratio to the quantity of product "SH01" that is included in the same invoice.

[0060] Quantity of SH02 = Quantity of SH02 (60 + 50 + 50 + 40 = 200) ÷ Quantity of SH01 (60 + 50 + 50 + 40 = 200) = 1 Quantity of SH03 = Quantity of SH03 (100 + 100 + 80 = 280) ÷ Quantity of SH01 (50 + 50 + 40 = 140) = 2 Quantity of SH04 = Quantity of SH04 (5 + 4 = 9) ÷ Quantity of SH01 (50 + 40 = 90) = 0.1 Quantity of SH05 = Quantity of SH05 (10) ÷ Quantity of SH01 (40) = 0.25

[0061] (3) Register the checked details in the related recommendation master. The items with checked checkboxes in the candidate display section 502 of the main screen 500 are registered in the related recommendation master 106c along with the products handled.

[0062] In the example in Figure 8(A), the checkboxes for rows "1", "2", and "3" are checked. When the Register button is pressed, the related recommendation master 106c shown in Figure 11 is registered.

[0063] Figure 11 shows an example of data in the registered related recommendation master 106c. The related recommendation master 106c has fields for product code, row number, related recommendation product code, and quantity. In the example shown in the figure, the first row has product code "SH01", row number "1", related recommendation product code "SH02", and quantity "1", the second row has product code "SH01", row number "2", related recommendation product code "SH03", and quantity "2", and the third row has product code "SH01", row number "3", related recommendation product code "SH04", and quantity "0.1".

[0064] (S3: Order entry processing) A specific example of order entry processing will be explained with reference to Figures 12 to 15. For example, the order entry unit 102c may, in response to the operator's operation on the order entry screen displayed on the monitor 114, refer to the related recommendation master 106c and display related recommended products associated with the specified product when the product to be handled and the quantity to be deployed are specified. Alternatively, the order entry unit 102c may calculate and display the quantity of related recommended products by multiplying the specified quantity to be deployed by the quantity of the related recommended product in the related recommendation master 106c.

[0065] Figure 12 shows an example of the display of the order entry screen 700. The order entry screen 700 includes a header section 701 with fields for specifying the order date, shipping date, planned sales date, customer, delivery destination, warehouse, description, handled products, and expanded quantity, as well as an expanded button, a new row button, and a document registration button, and a detail section 702. The detail section 702 displays the row, quantity, unit price, and amount (see Figure 15). When the document registration button is pressed, order data corresponding to the input content (display content) of the order entry screen 700 is registered in the storage unit 106.

[0066] (1) Enter the header information in the header section 701. Then, press the "New Row" button to display the details screen for the first line of details. In the example shown in Figure 12, the order date is entered as "2022 / 8 / 5", the shipping date as "2022 / 8 / 8", the planned sales date as "2022 / 8 / 10", the customer as "T001", the delivery destination as "N001", and the warehouse as "S001".

[0067] Figure 13 shows an example of the details screen 800. As shown in Figure 13, the details screen 800 includes fields for specifying the product, quantity, unit price, amount, and description, as well as a detail registration button.

[0068] (2) If a product (product handled) with related recommended products is entered on the first line of the details screen 800, the message "Related recommended products available" will be displayed. Using the product (handled product) as the key, it is determined whether or not there are related recommended products in the related recommended master 106c (Figure 11), and if there are, the message "Related recommended products available" is displayed. In the example shown in Figure 13, product "SH01" is specified, and related recommended products "SH02, SH03, SH04" for product "SH01" are registered in the related recommended master 106c, so the message "Related recommended products available" is displayed.

[0069] (3) Return to the header section 701, enter the product code, specify the quantity to be expanded, and press the expand button. In the order entry screen 700 shown in Figure 14, when the product "SH01" and the quantity to be expanded "10" are specified and the expand button is pressed, the data is expanded in the detail section 702 as shown in Figure 15.

[0070] (4) When the expand button is pressed, the system refers to the related recommendation master 106c and expands the related recommended products associated with the product in the detail section 702. The unit price is obtained from the product unit price master 106b using the product as the key. The quantity is calculated by multiplying the expanded quantity entered in the header section 701 by the quantity in the related recommendation master 106c.

[0071] In the example shown in Figure 15, detail section 702 displays the following in the first row: product "SH01", quantity "10 (=(10×1))", unit price "800", amount "8000", product "SH02", quantity "10 (=(10×1))", unit price "800", amount "8000", product "SH03", quantity "20 (=(10×2))", unit price "700", amount "14000", and product "SH04", quantity "1 (=(10×0.1))", unit price "500", amount "5000".

[0072] As described above, according to this embodiment, in response to the operator's operation on the master creation screen, the product to be handled and the period are specified, and for the specified period, sales slips containing the specified product to be handled are obtained from the sales data for the specified period, and for each product other than the product to be handled in the obtained sales slip, the quantity is calculated as a ratio to the quantity of the product to be handled that exists in the same sales slip, and a related recommendation master 106c is created including the product to be handled, the line number, the related recommended product which is the product of the obtained sales slip, and the calculated quantity, and registered in the storage unit 106, thereby enabling efficient proposal of related recommended products.

[0073] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions by companies, thereby contributing to SDGs Goals 8 and 9.

[0074] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0075] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[0076] [5. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

[0077] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.

[0078] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0079] Furthermore, with respect to the master creation device 100, each component shown in the illustration is a functional concept and does not necessarily need to be physically configured as shown.

[0080] For example, the processing functions of the master creation device 100, particularly those performed in the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the master creation device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0081] Furthermore, this computer program may be stored on an application program server connected to the master creation device 100 via any network, and it is possible to download all or part of it as needed.

[0082] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0083] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0084] The various databases stored in the memory unit are storage means such as RAM, ROM, other memory devices, hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0085] Furthermore, the master creation device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the master creation device 100 may be implemented by installing software (including programs or data, etc.) that enables the processing described in this embodiment onto the device.

[0086] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the illustration, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of Symbols]

[0087] 100 Master Creation Device 102 Control Unit 102a Sales Input Section 102b Master Creation Department 102c Order Entry Section 102d Screen display control unit 104 Communication Interface Section 106 Storage section 106a Product Master 106b Product Unit Price Master Recommended Master for 106c 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks 400 devices

Claims

1. A master creation device equipped with a control unit, The control unit, It is configured to allow access to a storage area that stores sales data including sales number, line number, sales date, product, and quantity. A master creation device characterized by comprising a master creation means that, in response to an operator's operation on the master creation screen, specifies the products to be handled and the period, retrieves sales slips containing the specified products from the sales data for the specified period, calculates the quantity of each product other than the products handled in the retrieved sales slip as a ratio to the quantity of the products handled in the same sales slip, creates a related recommendation master including the products handled, line number, related recommended products which are the products in the retrieved sales slip, and the calculated quantity, and registers it in the storage area.

2. The master creation device according to claim 1, characterized in that the master creation means displays the products of the acquired sales slips as candidates for related recommended products in order of the number of items in a predetermined area of ​​the master creation screen, and creates the related recommended master for the products selected by the operator.

3. The control unit further, The master creation device according to claim 1 or 2, characterized in that, in response to an operator's operation on the order entry screen, when the product to be handled and the quantity to be deployed are specified, the device refers to the related recommended master and displays related recommended products associated with the specified product to be handled.

4. The master creation device according to claim 3, characterized in that the order entry means calculates and displays the quantity of related recommended products by multiplying the specified deployment quantity by the quantity of the related recommended products in the related recommended master.

5. A master creation method performed by an information processing device equipped with a control unit, The control unit, It is configured to allow access to a storage area that stores sales data including sales number, line number, sales date, product, and quantity. The control unit is executed as follows: A master creation method characterized by including a master creation step in which, in response to an operator's operation on the master creation screen, the operator specifies the products to be handled and the period, for the specified period, sales slips containing the specified products to be handled are obtained from the sales data for the specified period, for each product other than the products to be handled in the obtained sales slip, the quantity is calculated as a ratio to the quantity of the products to be handled that exist in the same sales slip, and a related recommendation master is created that includes the products to be handled, the line number, related recommended products that are the products of the obtained sales slip, and the calculated quantity, and the master is registered in the storage area.

6. A master creation program to be executed by an information processing device equipped with a control unit, The control unit, It is configured to allow access to a storage area that stores sales data including sales number, line number, sales date, product, and quantity. The control unit, A master creation program for executing a master creation process in which, in response to operator operations on the master creation screen, the program specifies the products to be handled and the period, retrieves sales slips containing the specified products from the sales data for the specified period, calculates the quantity of each product other than the products handled in the retrieved sales slips as a ratio to the quantity of the products handled in the same sales slip, creates a related recommendation master including the products handled, line numbers, related recommended products that are the products in the retrieved sales slips, and the calculated quantities, and registers it in the storage area.

Images