Order management device, order management method, and order management program

Abstract

To provide a received order management device which can reduce work burden at the time of stockout when orders from multiple shops are received at the same time.SOLUTION: In a received order management device 100, a received order input unit 102a causes a storage unit 106 to store received order assignment master data 106a consisting of product and request destination pairs respectively associated with a received order quantity limit which have been registered and also operates to store received order data including a received order number, a received order delivery due date, a client which is a shop, a product, and a received order quantity in a data file 106b in the storage unit 106. An apportionment processing unit 102b refers to the data file 106b stored in the storage unit 106 and when the received order quantities of target received order data, having the same product and request destination pair, exceed a received order quantity limit which has been retrieved from the master data using the product and request destination pair as a key, automatically performs an apportionment process on the received order quantities within the received order quantity limit and updates them.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to an order management device, an order management method, and an order management program. [Background technology]

[0002] For example, there is a case where orders for daily delivery items for a plurality of stores are collectively requested to a manufacturer. Conventionally, an example of a system for receiving and placing orders is disclosed in Patent Document 1. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2007-272455 A Summary of the Invention [Problem to be solved by the invention]

[0004] However, the above-mentioned Patent Document 1 does not mention anything about reducing the workload when a stockout occurs when multiple orders are placed at once from multiple stores.

[0005] The present invention has been made in consideration of the above, and aims to provide an order management device, an order management method, and an order management program that can reduce the workload when stock shortages occur when orders are placed simultaneously from multiple stores. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an order management device equipped with a memory unit and a control unit, wherein the memory unit stores a master in which an order limit number is associated with each product and billing destination, and the control unit comprises an order input means for inputting order data including an order number, an order delivery date, a customer store, a product, and an order quantity, and an allocation processing means for automatically apportioning and updating the order quantity within the order limit number for order data for the same product and billing destination when the order quantity exceeds the order limit number obtained from the master using the product and billing destination as keys.

[0007] Furthermore, according to one aspect of the present invention, the apportionment processing means rearranges the target order data in descending order of order volume, counts up the allocated quantities evenly in descending order of order numbers with the largest order volumes within the order limit, and terminates the count-up for that order number when the order volume reaches the count-up value.

[0008] According to another aspect of the present invention, the control unit may further include a change unit that changes the order quantity of the target order data after the apportionment process in response to an operation by an operator.

[0009] According to another aspect of the present invention, the product may be a daily delivered item.

[0010] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention may provide an order management method executed by an information processing device having a control unit and a memory unit, wherein the memory unit stores a master in which an order limit number is associated with each product and billing destination, and the method may include an order input process executed by the control unit for inputting order data including an order number, order delivery date, a customer store, product, and order number, and an allocation processing process for automatically apportioning and updating the order number within the order limit number for order data for the same product and billing destination, when the order number exceeds the order limit number obtained from the master using the product and billing destination as keys.

[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention is an order management program to be executed by an information processing device having a control unit and a memory unit, wherein the memory unit stores a master in which an order limit number is associated with each product and billing destination, and the control unit executes an order input process in which order data including the order number, order delivery date, customer store, product, and order number is input, and an allocation processing process in which, for order data for the same product and billing destination, if the order number exceeds the order limit number obtained from the master using the product and billing destination as keys, the order number is automatically allocated and updated within the order limit number. Effect of the Invention

[0012] According to the present invention, when multiple orders are placed at once from a plurality of stores, it is possible to reduce the workload when a stockout occurs. [Brief description of the drawings]

[0013] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an order management device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the configuration of the order allocation master. [Diagram 3] FIG. 3 is a diagram illustrating a flow of the entire process of the control unit of the order management device according to the present embodiment. [Figure 4] FIG. 4 is a diagram for explaining a specific example of the process of the control unit of the order management device according to the present embodiment. [Diagram 5] FIG. 5 is a diagram for explaining a specific example of the process of the control unit of the order management device according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the process of the control unit of the order management device according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0014] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0015] [1. Overview] For example, because orders for daily necessities for each store were placed in bulk with manufacturers, when an item was out of stock it required manual intervention and took time to identify the cause.

[0016] Therefore, in this embodiment, when multiple stores place orders at once and a stockout occurs, the stock is automatically allocated according to the quantity set in advance. This reduces the workload when multiple stores place orders at once and a stockout occurs, and reduces the variation in stock among stores.

[0017] The order management device of this embodiment is applicable, for example, to the daily delivery industry, and is applicable to a wide range of products, not only food products but also products sold in drug stores, 100-yen shops, and the like.

[0018] [2. Configuration] An example of an order management device according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of an order management device according to this embodiment. In Fig. 1, the order management device 100 is a commercially available desktop personal computer. Note that the order management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0019] The order management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the order management device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0020] The communication interface unit 104 communicatively connects the order management device 100 to a 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 the communication line. Here, the network 300 has a function of connecting the order management device 100 and the server 200 etc. so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0021] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as a monitor 114.

[0022] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. 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 as the storage unit 106. The storage unit 106 also includes an order allocation master 106a and a data file 106b. FIG. 2 is a diagram showing an example of the configuration of the order allocation master 106a.

[0023] The order allocation master 106a can be configured as a table that associates and registers data such as product code, billing destination (customer) code of a manufacturer, etc., and order limit number, as shown in Fig. 2. In the example shown in Fig. 2, the product code is "A-01", the billing destination code is "S00001", and the order limit number is "311".

[0024] The data file 106b is a file for storing various data such as order data, etc. The order data may include data such as an order number, an order line number, an order delivery date, a billing code, a customer code, a product code, and an order quantity (see FIG. 3).

[0025] Returning to Fig. 1, the control unit 102 is a CPU or the like that performs overall control of the order management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. The control unit 102 conceptually includes an order input unit 102a, an apportionment processing unit 102b, a change processing unit 102c, a master maintenance unit 102d, and a screen display control unit 102e in terms of functions.

[0026] The order input unit 102a inputs order data including the order number, order delivery date, the customer store, the product, and the order quantity in response to an operation by an operator on an order input screen (not shown) displayed on the monitor 114, and registers the input data in the data file 106b. The product may be, for example, a daily delivery product.

[0027] For order data registered in data file 106b for the same product and billing destination, when the order quantity exceeds the order limit quantity obtained from order allocation master 106a using the product and billing destination as keys, apportionment processing unit 102b updates the order quantity by apportioning it within the order limit quantity.

[0028] In addition, the allocation processing unit 102b may rearrange the target order data in descending order of order volume, and evenly count up the allocation quantity in descending order of order number with the largest order volume within the order limit, and end the count-up for that order number when the order volume = count-up value is reached.

[0029] The proportionate distribution processing unit 102b may also proportionately distribute the allocation of the order quantity for the target order data within the range of the order limit quantity according to the priority order.

[0030] The change processing unit 102c changes the order quantity of the target order data after the apportionment process, in response to, for example, an operator's operation on a screen (not shown) displayed on the monitor 114.

[0031] The master maintenance section 102d is for performing editing such as registration, addition, and update of data in the order allocation master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0032] The screen display control unit 102e controls, for example, the display of various screens (for example, an order input screen, an order quantity change screen, etc.) displayed on the monitor 114 and the reception of inputs therefor.

[0033] [3. Specific Examples] A specific example of the processing of the order management device 100 according to the present embodiment will be described with reference to Figs. 1 to 6. Fig. 3 is a diagram showing a flow for explaining the overall processing flow of the order management device 100 according to the present embodiment. Figs. 4 to 6 are diagrams showing sample data for explaining a specific example of the processing of the control unit of the order management device 100 according to the present embodiment.

[0034] (3-1. Overall processing) The overall process flow of the order management device 100 according to this embodiment will be described with reference to FIG.

[0035] 3, the master maintenance unit 102d executes an order allocation master maintenance process (step S1). Specifically, in the order allocation master maintenance process, the master maintenance unit 102d sets data in the order allocation master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0036] The order input unit 102a executes the order input process (step S2). Specifically, in the order input process, the order input unit 102a, for example, inputs order data including the order number, order delivery date, the customer store, the product, and the order quantity in response to an operator's operation on an order input screen (not shown) displayed on the monitor 114, and registers the input data in the data file 106b. The product may be, for example, a daily delivery product.

[0037] The apportionment processing unit 102b executes the apportionment processing (step S3). Specifically, in the apportionment processing, when the order quantity of the target order data registered in the data file 106b and having the same product and billing destination exceeds the order limit quantity obtained from the order allocation master 106a using the product and billing destination as keys, the apportionment processing unit 102b automatically apportions and updates the order quantity within the order limit quantity.

[0038] In addition, the allocation processing unit 102b may rearrange the target order data in descending order of order volume, and evenly count up the allocation quantity in descending order of order number with the largest order volume within the order limit, and end the count-up for that order number when the order volume = count-up value is reached.

[0039] The change processing unit 102c executes an order quantity change process (step S4). Specifically, in the order quantity change process, the change processing unit 102c changes the order quantity of the target order data after the apportionment process in response to an operation by an operator on an order adjustment screen (not shown) displayed on the monitor 114, for example.

[0040] (3-2. Sample data) The overall process flow of the order management device 100 according to this embodiment will be described with reference to the sample data in FIGS.

[0041] (Order allocation master maintenance processing S1) The master maintenance unit 102d sets data in the order allocation master 106a in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0042] Fig. 4(A) shows an example of data setting of the order allocation master 106a. In the example of the order allocation master 106a shown in Fig. 4(A), the product code is "A-01", the billing code is "S00001", and the order limit number is "311".

[0043] (Order entry process S2) The order input unit 102a inputs order data including the order number, order delivery date, customer store, product, and order quantity in response to, for example, an operator's operation on an order input screen (not shown) displayed on the monitor 114, and registers the data in a data file 106b.

[0044] FIG. 4B shows an example of the order data. In the example of order data shown in Figure 4 (B), the first line has order number "J00001", order line number "1", order delivery date "2020 / 09 / 30", billing code "S00001", customer code "T00001", product code "A-01", and order quantity "60". The second line has order number "J00002", order line number "1", order delivery date "2020 / 09 / 30", billing code "S00001", customer code "T00001", product code "A-01", and order quantity "80". The third line has order number "J00003", order line number "1", order delivery date "2020 / 09 / 30", billing code "S00001", customer code "T00002", product code "A-01", and order quantity "95".

[0045] The fourth line has the order number "J00004", order line number "1", order delivery date "2020 / 09 / 30", billing code "S00001", customer code "T00003", product code "A-01", and order quantity "100". The fifth line has the order number "J00005", order line number "1", order delivery date "2020 / 09 / 30", billing code "S00002", customer code "T00004", product code "A-01", and order quantity "60".

[0046] (Apportionment processing S3) For order data registered in data file 106b for the same product and billing destination, when the order quantity exceeds the order limit quantity obtained from order allocation master 106a using the product and billing destination as keys, apportionment processing unit 102b automatically updates the order quantity by apportioning it within the order limit quantity.

[0047] The order data is for backlogs that have not been ordered (not purchase / order data) and have not been allocated. Items with the same product code and billing code are processed. Using the product code and billing code as keys, the order limit is obtained from the order allocation master 106a, and if the total order quantity of the target order data is greater than the obtained order limit, an apportionment process is performed.

[0048] In the example of Fig. 4(B), the four items, order numbers "J00001" to "J00004" of billing code "S00001" and product code "A-01", are subject to the pro rata process. The total order quantity of order numbers "J00001" to "J00004" is "335 (=60+80+95+100)", which is greater than the order limit quantity "311" of product code "A-01" and billing code "S00001" in the order allocation master 106a, so the pro rata process is performed.

[0049] Figure 4(C) shows an example of order data after the order numbers have been apportioned. As shown in Figure 4(C), after the apportionment, order number "J00001" has an order number of "60", order number "J00002" has an order number of "80", order number "J00003" has an order number of "85", and order number "J00004" has an order number of "86".

[0050] A specific method of the proportional division process will be described with reference to Fig. 5. Fig. 5 is a diagram for explaining a specific method of the proportional division process.

[0051] (1) The order data to be allocated is sorted in descending order of quantity. In the example shown in Figure 5, the data is sorted in descending order of order quantity, with order number "J00004" (order quantity "100"), order number "J00003" (order quantity "95"), order number "J00002" (order quantity "80"), and order number "J00001" (order quantity "60").

[0052] (2) The number of orders is apportioned based on the order allocation master 106a. For the target order data, The allocated quantity is counted up evenly in increments of "1" for the order numbers with the largest order quantities until the order limit is reached ("311" in the example shown in Figure 5). When the order quantity = count-up value is reached, the count-up for the relevant detail ends. In the case of Figure 5, the count-up ends at "60" for order number "J00001". The count-up ends at "80" for order number "J00002".

[0053] If the order quantity is greater than the order quantity after allocation and the order limit has not been reached, the remaining items will be prorated. The fractional part will be assigned to the line item with the largest order quantity. If the order quantity before the change is less than the order quantity after the change, the order quantity before the change will be output as is. In the case of Figure 5, the count-up will end at "85" for order number "J00003" and "86" for order number "J00004".

[0054] Manual allocation requires confirmation of the number of orders from each customer, which requires communication between departments. By automatically allocating in this embodiment, the amount according to the number of orders can be calculated uniformly for each customer, and this can be explained to the customer.

[0055] The allocation processor 102b may allocate the number of received orders based on the set priorities, instead of just counting up the orders equally.

[0056] (Order quantity change process S4) The change processing unit 102c can change the order quantity of the target order data after the proportional division process within the range of the order limit quantity in response to, for example, an operator's operation on a screen (not shown) displayed on the monitor 114. Fig. 6 is a diagram for explaining an example of the order quantity change process.

[0057] In FIG. 6, for example, the order data is output in a file of a specified format (for example, an Excel file), and the order quantity can be maintained for the output file of the order data of the specified format (for example, an Excel file). FIG. 6(A) shows an example of the order data output (for example, Excel data). FIG. 6(B) shows an example of the order data after the order quantity has been changed (for example, corrected in Excel). In the example shown in FIG. 6(B), the order quantity for the order number "J00002" has been corrected (+2) from "80" to "82", and the order quantity for the order number "J00003" has been corrected (-2) from "85" to "83". The order quantity can be updated in bulk for the order quantity after the change in the imported file, using the order number + order line number as a key. As shown in FIG. 6(C), when the file of the specified format of the changed order data is imported, the order quantity of the order data is updated. This is a countermeasure when there are customers for whom adjustments cannot be made even with automatic allocation.

[0058] As described above, according to this embodiment, there are provided an order allocation master 106a in which an order limit quantity is registered in association with each product and billing destination, an order input unit 102a for inputting order data including an order number, an order delivery date, a customer store (product), and an order quantity, and an allocation processing unit 102b for automatically apportioning and updating the order quantity within the order limit quantity for order data with the same product and billing destination when the order quantity exceeds the order limit quantity obtained from the order allocation master 106a using the product and billing destination as keys. Therefore, when orders are received from multiple stores at the same time, it is possible to reduce the workload when stock shortages occur.

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

[0060] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0061] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0062] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth 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 using known methods.

[0064] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0065] Moreover, with regard to the order management device 100, the components shown in the figures are merely conceptual functional elements, and the device does not necessarily have to be physically configured as shown in the figures.

[0066] For example, the processing functions of the order management device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the order management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in the storage unit 106 such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes the control unit 102 in cooperation with the CPU.

[0067] In addition, this computer program may be stored in an application program server connected to the order management device 100 via any network, and it is also possible to download all or part of it as necessary.

[0068] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0069] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0070] The various databases etc. stored in the memory unit 106 are storage means such as 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 etc. used for various processes and providing websites.

[0071] The order management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The order management device 100 may be realized by implementing software (including programs or data, etc.) that causes the information processing device to realize the processes described in this embodiment.

[0072] Furthermore, the specific form of distribution and integration of the devices is not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]

[0073] 100 Order management device 102 Control section 102a Order Entry Section 102b Proportional division processing unit 102c Change processing section 102d Master Maintenance Department 102e Screen display control unit 104 Communication interface section 106 Storage section 106a Order Allocation Master 106b Data File 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. An order management device that includes a storage unit and a control unit, and that consolidates orders for products from a plurality of customers and places an order for the products with a billing party that is a supplier of the products, The storage unit includes: A master record is stored that associates the order limit quantity for each product and billing destination. The control unit is an order input means for inputting order data including an order number, an order delivery date, a customer store, a product, and an order quantity; an apportionment processing means for automatically apportioning and updating the order quantity within the range of the order limit quantity when the order quantity of the target order data having the same product and billing address exceeds the order limit quantity obtained from the master using the product and billing address as keys; An order management device comprising:

2. The order management device according to claim 1, characterized in that the apportionment processing means rearranges the target order data in descending order of order volume, counts up the allocated quantity evenly in descending order of order number with the largest order volume within the order limit number, and terminates the count-up for that order number when the order volume = count-up value is reached.

3. The control unit further 3. The order management device according to claim 1, further comprising a change means for changing the order quantity of the order data subject to the apportionment process in response to an operation by an operator.

4. 4. The order management device according to claim 1, wherein the merchandise is a daily delivered item.

5. An order management method executed by an order management device that includes a control unit and a storage unit and that consolidates orders for products from a plurality of customers and places an order for the products with a billing party that is a supplier of the products, comprising: The storage unit includes: A master record is stored that associates the order limit quantity for each product and billing destination. Executed in the control unit, An order entry process for entering order data including order number, order delivery date, customer (store), product, and order quantity; an allocation process for automatically allocating and updating the order quantity within the range of the order limit when the order quantity of the target order data having the same product and billing address exceeds the order limit obtained from the master using the product and billing address as keys; 2. An order management method comprising:

6. An order management program for causing an order management device to execute the order management program, the order management device comprising a control unit and a storage unit, which consolidates orders for products from a plurality of customers and places an order for the products with a billing party that is a supplier of the products, The storage unit includes: A master record is stored that associates the order limit quantity for each product and billing destination. The control unit, An order entry process for entering order data including order number, order delivery date, customer (store), product, and order quantity; an allocation process for automatically allocating and updating the order quantity within the range of the order limit when the order quantity of the target order data having the same product and billing address exceeds the order limit obtained from the master using the product and billing address as keys; An order management program to execute the above.

Images