Sales restriction device, sales restriction method, and sales restriction program

Abstract

To restrict sales for each customer at the time of inputting an order for a product according to a maker that manufactures the product or a group of the product.SOLUTION: A sales restriction apparatus according to this embodiment comprises: a product master in which a product and a maker that manufactures the product are associated with each other and registered; a product group master in which the product and a product group indicating the group of the product are associated with each other and registered; a sales restriction master in which the product group or the maker which subjects to sales restriction is associated with each customer and registered; and input restriction means for acquiring, if the customer and the product are input on an order input screen displayed on a display unit, the product group or the maker from the sales restriction master using the input customer as a key, and restricting an order input if the input product is associated with the product group acquired by referring to the product group master or if the input product is associated with the maker acquired by referring to the product master.SELECTED DRAWING: Figure 1

Description

Technical Field

[0006] ,

[0001] The present invention relates to a sales restriction device, a sales restriction method, and a sales restriction program.

Background Art

[0002] For example, in the wholesale industry that handles a wide variety of products, there is a business custom in which the customers who can sell are limited depending on whether there is a contract with the manufacturer. Conventionally, as a system for restricting sales, 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, in the above Patent Document 1, it was not possible to restrict the customers to whom sales are made.

[0005] The present invention has been made in view of the above, and an object thereof is to provide a sales restriction device, a sales restriction method, and a sales restriction program capable of performing sales restriction for each customer according to the manufacturer who is the manufacturer of the product or the group of the product when receiving an order input for the product.

Means for Solving the Problems

[0006] To solve the above-mentioned problems and achieve the objective, the present invention provides a sales restriction device comprising a storage unit and a control unit, wherein the storage unit stores a product master registered as associating a product with the manufacturer that produces the product, a product group master registered as associating a product (product code and / or product name) with a product group (product group code and / or product group name) that indicates a group of products, and a sales restriction master registered as associating a product group or manufacturer (manufacturer code and / or manufacturer name) to restrict sales for each customer, and the control unit is characterized in that, when a customer and a product are entered on the order entry screen displayed on the display unit, it retrieves a product group or manufacturer from the sales restriction master using the entered customer as a key, and restricts order entry when the entered product is associated with a product group obtained by referring to the product group master, or when the entered product is associated with a manufacturer obtained by referring to the product master.

[0007] Furthermore, according to one aspect of the present invention, the sales restriction master may include, for each customer, permission settings that define the processing content when sales are restricted, in addition to the product groups or manufacturers whose sales are restricted, and the input restriction means may restrict order entry in accordance with the permission settings.

[0008] Furthermore, according to one aspect of the present invention, the permission setting may include a warning, and the input restriction means may display a warning message on the order entry screen if the permission setting is a warning.

[0009] Furthermore, according to one aspect of the present invention, the permission setting may include errors, and the input restriction means may, if the permission setting is an error, display an error message on the order entry screen and prevent order entry.

[0010] Furthermore, according to one aspect of the present invention, the permission setting may include permission, and the input restriction means may temporarily allow order entry if the permission setting is permission.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides a sales restriction method to be executed by an information processing device equipped with a storage unit and a control unit, wherein the storage unit stores a product master registered as associating a product with the manufacturer that produces the product, a product group master registered as associating a product with a product group indicating a group of products, and a sales restriction master registered as associating a product group or manufacturer to be restricted for each customer, and the control unit executes an input restriction step in which, when a customer and a product are entered on an order entry screen displayed on a display unit, the entered customer is used as a key to obtain a product group or manufacturer from the sales restriction master, and the entered product is associated with a product group obtained by referring to the product group master, or the entered product is associated with a manufacturer obtained by referring to the product master, thereby restricting the order entry.

[0012] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention is a sales restriction program to be executed by an information processing device equipped with a control unit, wherein the storage unit stores a product master in which products are registered in association with the manufacturer of the product, a product group master in which products are registered in association with the product group indicating a group of products, and a sales restriction master in which products are registered in association with the product group or manufacturer to be restricted for each customer, and the control unit executes an order entry screen displayed on the display unit, in which a customer and a product are entered, and the product group or manufacturer is obtained from the sales restriction master using the entered customer as a key, and the entered product is associated with the product group obtained by referring to the product group master, or the entered product is associated with the manufacturer obtained by referring to the product master, and the computer is instructed to execute an input restriction process to restrict order entry. [Effects of the Invention]

[0013] According to the present invention, when an order for a product is received, it is possible to impose sales restrictions for each customer according to the manufacturer that is the producer of the product or the group of the product, and the present invention has the effect of making this possible.

Brief Description of Drawings

[0014] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a sales restriction device according to the present embodiment. [Figure 2] FIG. 2 is a diagram showing an example of the configuration of a product master. [Figure 3] FIG. 3 is a diagram showing an example of the configuration of a product group master. [Figure 4] FIG. 4 is a diagram showing an example of the configuration of a manufacturer master. [Figure 5] FIG. 5 is a diagram showing an example of the configuration of a sales restriction master. [[ID=)22]] [Figure 6] FIG. 6 is a diagram showing an example of the setting of the master. [Figure 7] FIG. 7 is a diagram for explaining the order of input restriction processing and the corresponding patterns. [Figure 8] FIG. 8 is a diagram showing an example of a flow for explaining the input restriction processing executed by the input restriction unit.

Embodiments of the Invention

[0015] Embodiments of the present invention will be described in detail based on the drawings. Note that the present invention is not limited to the present embodiments.

[0016] [1. Outline] For example, in the wholesale industry that deals with a wide variety of products, there is a business custom that the customers who can sell are limited depending on whether there is a contract with the manufacturer. Here, the wholesale industry is, for example, various wholesale industries such as beauty product wholesalers, food wholesalers, building material wholesalers, retail wholesalers, chemical product wholesalers, pharmaceutical product wholesalers, and machinery and equipment wholesalers.

[0017] However, in the conventional system, it has not been possible to restrict the customers to whom sales are made.

[0018] Therefore, in the present embodiment, at the time of receiving an order input for a product (when entering an order slip), sales restrictions (input restrictions) are imposed for each customer according to the manufacturer that is the producer of the product or the group of the product.

[0019] The present embodiment is applicable to various wholesale industries such as beauty product wholesalers, food wholesalers, building material wholesalers, retail product wholesalers, chemical product wholesalers, pharmaceutical product wholesalers, and machinery and equipment wholesalers.

[0020] [2. Configuration] Referring to FIG. 1, an example of a sales restriction device according to the present embodiment will be described. FIG. 1 is a block diagram showing an example of the configuration of the sales restriction device according to the present embodiment.

[0021] The sales restriction device 100 is, for example, a commercially available desktop personal computer. Note that the sales restriction device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer. In FIG. 1, the sales restriction device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the sales restriction device 100 is communicably connected via an arbitrary communication path.

[0022] The communication interface unit 104 communicably connects the sales restriction device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of communicably connecting the sales restriction device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).

[0023] 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, mouse, microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. Note that in the following, the output device 114 may be referred to as the monitor 114.

[0024] 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.

[0025] The storage unit 106 includes a product master 106a, a product group master 106b, a manufacturer master 106c, a sales restriction master 106d, and a data file 106e. Figure 2 shows an example of the configuration of the product master 106a. Figure 3 shows an example of the configuration of the product group master 106b. Figure 4 shows an example of the configuration of the manufacturer master 106c. Figure 5 shows an example of the configuration of the sales restriction master 106d.

[0026] As shown in Figure 2, the product master 106a can be composed of tables that register product codes and manufacturer codes in association.

[0027] As shown in Figure 3, the product group master 106b can be composed of tables and the like that register product group codes and product codes in association.

[0028] The manufacturer master 106c can be composed of tables that register manufacturer codes, as shown in Figure 4.

[0029] The Sales Restriction Master 106d is a master database used to set product groups or manufacturers whose sales are restricted for each customer. As shown in Figure 5, the Sales Restriction Master 106d can consist of tables that associate customer codes, product group codes, manufacturer codes, and permission settings (whether or not to allow sales). The permission settings are "0: Warning," "1: Error," "2: Allow," and "No setting." Depending on the "Permission setting" value in the Sales Restriction Master 106d, a warning or error message will be displayed on the order entry screen.

[0030] For example, if the setting is "0: Warning," a warning message will be displayed stating, "Sales are restricted. Do you wish to proceed with registration?" If the setting is "1: Error," an error message will be displayed stating, "Registration is not possible because sales are restricted." If the setting is "2: Allowed" or "Not Set," no warning or error will be displayed, and normal order entry will be possible.

[0031] Data file 106e is a file for storing various types of data, such as order data. The order data may include data such as order number, customer, product, order quantity, and order amount.

[0032] Returning to Figure 1, the control unit 102 is a CPU or the like that comprehensively controls the sales restriction device 100. The control unit 102 has an 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. Functionally, the control unit 102 comprises a master maintenance unit 102a, an order input unit 102b, an input restriction unit 102c, and a screen display control unit 102d.

[0033] The master maintenance unit 102a performs settings such as inputting, adding, and modifying data for the product master 106a, product group master 106b, manufacturer master 106c, and sales restriction master 106d, for example, in response to the operator's operation of the input device 112 on a master maintenance screen (not shown) displayed on the monitor 114.

[0034] The order input unit 102b inputs order data in response to the operator's operation of the input device 112 on an order input screen (not shown) displayed on the monitor 114, for example, and registers it in the data file 106e.

[0035] The input restriction unit 102c, when a customer and product are entered on the order entry screen, retrieves a product group or manufacturer from the sales restriction master 106d using the entered customer as a key, and restricts order entry if the entered product is associated with a product group obtained by referring to the product group master 106b, or if the entered product is associated with a manufacturer obtained by referring to the product master 106a.

[0036] The input restriction unit 102c may restrict order entry according to the permission settings of the sales restriction master 106d.

[0037] The input restriction unit 102c may also display a warning message on the order entry screen if the permission setting in the sales restriction master 106d is a warning.

[0038] The input restriction unit 102c may also display an error message on the order entry screen and disable order entry if the permission setting in the sales restriction master 106d is incorrect.

[0039] The input restriction unit 102c may temporarily allow order entry if the permission setting in the sales restriction master 106d is permitted.

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

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

[0042] (3-1. Master Maintenance Processing) Figure 6 shows an example of setting the product master 106a, product group master 106b, manufacturer master 106c, and sales restriction master 106d. The master maintenance unit 102a performs master maintenance processing and sets data for the product master 106a, product group master 106b, manufacturer master 106c, and sales restriction master 106d in response to the operation of the input device 112 by the operator on the master maintenance screen (not shown) displayed on the monitor 114.

[0043] In Figure 6, in the example of product master 106a, the first row is set to product code "101-0011" and manufacturer code "M100", the second row is set to product code "101-0012" and manufacturer code "M100", the third row is set to product code "101-0013" and manufacturer code "M100", the fourth row is set to product code "101-0014" and manufacturer code "M100", and the fifth row is set to product code "101-0015" and manufacturer code "M200".

[0044] In the example of product group master 106b, the first row is set to product group code "A100" and product code "101-0012", and the second row is set to product group code "B100" and product code "101-0013".

[0045] In the example of manufacturer master 106c, the first row is set to "M100" and the second row is set to "M200".

[0046] In the example of sales restriction master 106d, the first row contains customer code "10011", product group code "B100", manufacturer code "(not set)", and permission setting "0: Warning", while the second row contains customer code "20011", product group code "(not set)", manufacturer code "M200", and permission setting "1: Error".

[0047] (3-2: Input restriction processing) Figure 7 is a diagram illustrating the order and corresponding patterns of input restriction processing. Figure 8 is a diagram illustrating an example of the processing flow of input restriction processing. The following explanation will use the example of master settings in Figure 6. The input restriction unit 102c executes input restriction processing, and when a customer and product are entered on the order entry screen, it retrieves a product group or manufacturer from the sales restriction master 106d using the entered customer as a key, and restricts order entry if the entered product is associated with a product group obtained by referring to the product group master 106b, or if the entered product is associated with a manufacturer obtained by referring to the product master 106a.

[0048] In Figure 7, in STEP 1, if the product group code in sales restriction master 106d belongs to a group, the permission setting is "0: Warning," and it is subject to a disallowance check. For example, if the status is "0: Warning," a warning message will be displayed on the order entry screen stating, "There are restrictions preventing sales. Do you wish to proceed with registration?"

[0049] In STEP 2, if the manufacturer code in sales restriction master 106d belongs to a company, the permission setting is set to "1: Error," and it is subject to a disallowance check. In the case of "1: Error," an error message is displayed stating, "Registration is not possible because sales are restricted." In the case of "1: Error," the order data cannot be registered, which is a stricter condition than "0: Warning," where the operator can decide whether to register the order data.

[0050] This section explains cases that do not fall under STEP 1 and 2. If the permission setting is "2: Allowed" or if there are no settings for the product group code and manufacturer code, registration is possible without checking the box on the order entry screen. The permission setting "2: Allowed" is for temporary permission and can be used when you want to exclude items from the check depending on the timing. For example, if you want to temporarily (seasonally) allow a certain product, you can set it to "2: Allowed," and at other times set it to "0: Warning" or "1: Error." This makes it easier for operators to understand that the product is subject to seasonal sales restrictions (permissions) than setting it to "No setting," and simplifies the operator's settings.

[0051] Figure 8 shows the processing flow of the input restriction process executed by the input restriction unit 102c. In Figure 8, when the customer code and product code are entered on the order entry screen (S1), the sales restriction master 106d determines whether or not there is a product group code associated with the entered customer code (S2). If there is no product group code associated with the customer code (S2 "No"), the process proceeds to S4.

[0052] On the other hand, if there is a product group code associated with the customer code (Yes in S2), it is determined whether the entered product code is associated with that product group code in the product group master 106b (S3). If the entered product code is not associated with that product group code in the product group master 106b (No in S3), the process proceeds to S4. On the other hand, if the entered product code is associated with that product group code in the product group master 106b (Yes in S3), input restrictions are applied to the corresponding permission settings in the sales restriction master 106d (S6).

[0053] In S4, it is determined whether there is a manufacturer code associated with the customer code entered in the sales restriction master 106d. If there is no manufacturer code associated with the entered customer code (S4 "No"), the process proceeds to S7. If there is a manufacturer code associated with the entered customer code (S4 "Yes"), it is determined whether the entered product code is associated with that manufacturer code in the product master 106a (S5).

[0054] If the entered product code is not associated with the corresponding manufacturer code in product master 106a (S5 "No"), the process proceeds to S7. On the other hand, if the entered product code is associated with the corresponding manufacturer code in product master 106a (S5 "Yes"), the input restriction in the corresponding permission setting of sales restriction master 106d is applied (S6).

[0055] In S7, input restrictions are not enforced, so order entry (registration) is possible.

[0056] For example, if customer code "10011" and product code "101-0013" are entered, in Figure 6, there is a product group code "B100" associated with customer code "10011" in the sales restriction master 106d (S2 "Yes"), and the entered product code "101-0013" is associated with the same product group code "B100" in the product group master 106b (S3 "Yes"). Therefore, the corresponding permission setting "0: Warning" in the sales restriction master 106d is applied as an input restriction (S6), and the message "Sales are restricted. Do you want to proceed with registration?" is displayed on the order entry screen.

[0057] Furthermore, if customer code "20011" and product code "101-0015" are entered, as shown in Figure 6, there is a manufacturer code "M200" linked to the customer code "20011" entered in sales restriction master 106d (Yes in S4), and the entered product code "101-0013" is linked to the manufacturer code "M200" in product master 106a (Yes in S5). Therefore, the corresponding permission setting "0: Error" in sales restriction master 106d is set to restrict input (S6), and the message "The manufacturer has imposed a sales restriction" is displayed on the order entry screen, preventing order entry (registration).

[0058] As described above, according to this embodiment, a product master 106a is registered as a link between a product and the manufacturer that produces the product; a product group master 106b is registered as a link between a product and a product group that indicates a group of products; a sales restriction master 106d is registered as a link between each customer and a product group or manufacturer to which sales are restricted; and an input restriction unit 102c is provided that, when a customer and a product are entered on the order entry screen displayed on the monitor 114, the system retrieves a product group or manufacturer from the sales restriction master using the entered customer as a key, and restricts order entry when the entered product is associated with a product group obtained by referring to the product group master, or when the entered product is associated with a manufacturer obtained by referring to the product master. Therefore, when an order is entered for a product, the system has the effect of being able to restrict sales for each customer according to the manufacturer that produces the product or the group of products.

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

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

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

[0062] [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.

[0063] 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.

[0064] 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.

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

[0066] For example, the processing functions of the sales restriction device 100, particularly those performed by the control unit 102, 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 sales restriction device 100 as needed. That is, a storage unit 106 such as a 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 102.

[0067] Furthermore, this computer program may be stored on an application program server connected to the sales restriction device 100 via any network, and all or part of it can be downloaded as needed.

[0068] 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.

[0069] 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.

[0070] The various databases stored in the memory unit 106 include memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

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

[0072] 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 functionally or physically distributed and integrated in any unit according to various additions or functional additions. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Explanation of Symbols]

[0073] 100 Sales restriction device 102 Control Unit 102a Master Maintenance Department 102b Order Entry Section 102c Input Limiting Section 102d Screen display control unit 104 Communication Interface Section 106 Storage section 106a Product Master 106b Product Group Master 106c Manufacturer Master 106d Sales Restriction Master 106e Data File 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks

Claims

1. A sales restriction device comprising a memory unit and a control unit, The aforementioned storage unit includes: A product master that links a product with the manufacturer of that product, A sales restriction master is registered, which associates the manufacturers whose sales are restricted with each customer. It is stored there, The control unit, A sales restriction device characterized by having an input restriction means that, when a customer and product are entered on the order entry screen displayed on the display unit, retrieves the manufacturer from the sales restriction master using the entered customer as a key, and restricts order entry when the entered product is associated with the manufacturer obtained by referring to the product master.

2. The sales restriction master registers, for each customer, a permission setting that defines the processing content when sales are restricted, in addition to the manufacturers whose sales are restricted. The sales restriction device according to claim 1, characterized in that the input restriction means restricts order entry in accordance with the permission setting.

3. The sales restriction device according to claim 2, wherein the permission setting includes a warning, and the input restriction means displays a warning message on the order entry screen if the permission setting is a warning.

4. The sales restriction device according to claim 2, wherein the permission setting includes an error, and the input restriction means displays an error message on the order entry screen and prevents order entry if the permission setting is an error.

5. The sales restriction device according to claim 2, wherein the permission setting includes permission, and the input restriction means temporarily permits order entry when the permission setting is permission.

6. A sales restriction method performed by an information processing device comprising a storage unit and a control unit, The aforementioned storage unit includes: A product master that links a product with the manufacturer of that product, A sales restriction master is registered, which associates the manufacturers whose sales are restricted with each customer. It is stored there, The control unit executes: A sales restriction method characterized by including an input restriction step in which, when a customer and product are entered on an order entry screen displayed on a display unit, the manufacturer is obtained from the sales restriction master using the entered customer as a key, and the entered product is restricted if the manufacturer obtained by referring to the product master is associated with the entered product.

7. A sales restriction program to be executed by an information processing device having a storage unit and a control unit, The aforementioned storage unit includes: A product master that links a product with the manufacturer of that product, A sales restriction master is registered, which associates the manufacturers whose sales are restricted with each customer. It is stored there, The control unit, A sales restriction program that, when a customer and product are entered on the order entry screen displayed on the display unit, retrieves the manufacturer from the sales restriction master using the entered customer as a key, and if the entered product is associated with the manufacturer retrieved by referring to the product master, executes an input restriction process to restrict order entry.

Images