Inventory allocation processing device, inventory allocation processing method, and inventory allocation processing program
The inventory allocation processing device addresses inefficiencies by securing inventory based on specified conditions, enabling efficient allocation and shipment from reserved inventory.
Patent Information
- Application Number
- JP2024077532
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2024-05-10
- Publication Date
- 2025-07-31
- Estimated Expiration
- 2038-06-27
AI Technical Summary
Existing inventory allocation systems rely on transaction records such as estimates and orders, which can lead to inefficiencies and the need for dummy order recording, especially when securing inventory without actual transactions.
An inventory allocation processing device that references inventory data to reserve products based on specified conditions, storing reservation data and allocating products according to order conditions, allowing for secure inventory management independent of transaction records.
Enables secure inventory management without relying on transaction records, facilitating efficient allocation and preferential shipment from reserved inventory when actual orders are received.
Smart Images

Figure 0007716533000001 
Figure 0007716533000002 
Figure 0007716533000003
Abstract
Description
[Technical Field]
[0001] The present invention relates to an inventory allocation processing device, an inventory allocation processing method, and an inventory allocation processing program. [Background technology]
[0002] Patent Document 1 discloses a sales terminal device 11 that creates reservation application information containing at least information on product codes and reservation quantities for reserving product inventory based on business negotiation information. An order management computer 22 performs inventory allocation processing based on the reservation application information. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2006-106847 Summary of the Invention [Problem to be solved by the invention]
[0004] However, the above technology only allows orders for products that have not yet been confirmed to be placed ahead of schedule, and in actual inventory allocation processing, the number of orders included in the reservation request information is simply subtracted from the order quantity.
[0005] The present invention has been made in consideration of the above, and aims to provide an inventory allocation processing device, an inventory allocation processing method, and an inventory allocation processing program that can secure current inventory without being based on transaction records such as estimates and orders. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the inventory allocation processing device of the present invention comprises an allocation data management unit that references inventory data stored in an inventory data table to reserve a specified quantity of products that meet specified reservation conditions, and stores in the reservation data table reservation data including the reserved number of the reserved products as the allocated number; and an order data management unit that extracts from the reservation data table reservation data that matches the order conditions specified when the order data was input, allocates the required number of products for the order based on the reservation data, and stores in the order data table the allocated number of products that have been allocated based on the reservation data and the order conditions, wherein the reservation conditions and the order conditions are at least one or more of the inventory location of the products, the person in charge who wishes to reserve the products, and the department who wishes to reserve the products, and when the reserved number of the reservation data extracted as meeting the order conditions is equal to or greater than the order quantity, the order data management unit sets the current transfer number, which is the required number, arbitrarily specified with the order quantity as the maximum value. By doing so, the current transfer quantity that matches the securing conditions and the order conditions, which are at least one or more of the inventory location of the product, the person in charge who wants to secure the product, and the department who wants to secure the product, is set. .
[0007] Furthermore, the inventory allocation processing method according to the present invention comprises an allocation data management step in which an allocation data management unit reserves a specified quantity of products that meet specified reservation conditions by referring to inventory data stored in an inventory data table, and stores allocation data in the allocation data table, the allocation number of the reserved products being included in the reservation data; and an order data management step in which an order data management unit extracts reservation data that meets order conditions specified when the order data was input from the reservation data table, allocates a required number of products for the order based on the reservation data, and stores order data in the order data table, the allocated number of products that have been allocated based on the reservation data and the order conditions, the reservation conditions and the order conditions being included in at least one or more of the inventory location of the products, the person in charge who wishes to reserve the products, and the department who wishes to reserve the products. In the order data management step, if the reservation number of the reservation data extracted as meeting the order conditions is equal to or greater than the order quantity, a current transfer number is set, which is the required number that is arbitrarily specified with the order quantity as the maximum value. By doing so, the current transfer quantity is set to match the securing conditions and the order conditions, which are at least one or more of the inventory location of the product, the person in charge who wishes to secure the product, and the department who wishes to secure the product.
[0008] Furthermore, the inventory allocation processing program of the present invention causes a computer to function as an allocation data management unit that references inventory data stored in an inventory data table to reserve a specified quantity of merchandise that meets specified reservation conditions, and stores in the reservation data table reservation data including the reservation number of the reserved merchandise as an allocated number; and an order data management unit that extracts from the reservation data table reservation data that matches the order conditions specified when the order data was input, allocates the required number of merchandise for the order based on the reservation data, and stores in the order data table the allocated number of merchandise that has been allocated based on the reservation data and the order conditions, the reservation conditions and the order conditions being at least one or more of the inventory location of the merchandise, the person in charge who wishes to reserve the merchandise, and the department who wishes to reserve the merchandise, and when the reservation number of the reservation data extracted as meeting the order conditions is equal to or greater than the order quantity, the order data management unit sets the current transfer number, which is the required number, arbitrarily specified with the order quantity as the maximum value. By doing so, the current transfer quantity is set to match the securing conditions and the order conditions, which are at least one or more of the inventory location of the product, the person in charge who wishes to secure the product, and the department who wishes to secure the product. [Effects of the Invention]
[0009] According to the present invention, it is possible to secure current inventory without relying on transaction records such as estimates and orders. [Brief explanation of the drawings]
[0010] [Figure 1] FIG. 1 is a block diagram illustrating an example of the configuration of an inventory allocation processing device according to an embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of an allocation data input screen of the inventory allocation processing device according to the embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of various masters stored in the storage unit of the inventory allocation processing device according to the embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of the reservation data table of the inventory allocation processing device according to the embodiment. [Figure 5]FIG. 5 is a diagram illustrating an example of an inventory data table of the inventory allocation processing device according to the embodiment. [Figure 6] FIG. 6 is a diagram illustrating an example of an order data input screen of the inventory allocation processing device according to the embodiment. [Figure 7] FIG. 7 is a diagram illustrating an example of a no-match error screen of the inventory allocation processing device according to the embodiment. [Figure 8] FIG. 8 is a diagram illustrating an example of a reservation transfer instruction screen of the inventory allocation processing device according to the embodiment. [Figure 9] FIG. 9 is a diagram illustrating an example of an order data table of the inventory allocation processing device according to the embodiment. [Figure 10] FIG. 10 is a diagram illustrating an example of the reservation data table of the inventory allocation processing device according to the embodiment. [Figure 11] FIG. 11 is a diagram illustrating an example of an inventory data table of the inventory allocation processing device according to the embodiment. [Figure 12] FIG. 12 is a diagram illustrating an example of an allocation data inquiry screen of the inventory allocation processing device according to the embodiment. [Figure 13] FIG. 13 is a diagram illustrating an example of a stock data inquiry screen of the stock allocation processing device according to the embodiment. [Figure 14] FIG. 14 is a flowchart illustrating an example of a procedure of inventory allocation processing executed by the inventory allocation processing device according to the embodiment. [Figure 15] FIG. 15 is a diagram showing an example of an allocation data input screen of the inventory allocation processing device according to the modified example of the embodiment. DETAILED DESCRIPTION OF THE INVENTION
[0011] An embodiment of an inventory allocation processing device, an inventory allocation processing method, and an inventory allocation processing program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.
[0012] [1. Configuration] An example of the configuration of the inventory reservation processing apparatus 100 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 the inventory reservation processing apparatus 100 according to the embodiment.
[0013] The inventory reservation processing apparatus 100 is, for example, a commercially available desktop personal computer. However, the inventory reservation processing apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, and may be a portable information processing apparatus such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer.
[0014] The inventory reservation processing apparatus 100 makes an inventory reservation for order data based on transaction results such as estimates and orders. Further, the inventory reservation processing apparatus 100 makes an inventory reservation for secured data not based on transaction results such as estimates and orders. To realize such a function, the inventory reservation processing apparatus 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 inventory reservation processing apparatus 100 is communicably connected via an arbitrary communication path.
[0015] The communication interface unit 104 communicably connects the inventory reservation processing apparatus 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 inventory reservation processing apparatus 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).
[0016] 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, as well as 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.
[0017] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores computer programs that cooperate with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 includes an inventory data table 106a, a reservation data table 106b, an order data table 106c, screen data 106d, and master information 106e.
[0018] The inventory data table 106a stores inventory data for each product that is available, and includes data such as product information, inventory storage locations, and current inventory quantities.
[0019] The reservation data table 106b stores reservation data for each product handled. The reservation data indicates the inventory reservation status of each product for each responsible department. Products specified in the reservation data are reserved without being allocated, for example, due to orders for other products. The reservation data table 106b includes data such as product information, the location where the product is reserved, and the quantity reserved.
[0020] The order data table 106c stores order data for products for which orders have been received, and includes data such as the ordered product, the department in charge, and the delivery destination of the product.
[0021] The screen data 106d stores the screen data for displaying various screens on the output device 114 or the like. Examples of the various screens include display screens for information such as the inventory data table 106a, the secured data table 106b, and the order received data table 106c. Further, examples of the various screens include input screens for securing or receiving orders for products and the like.
[0022] The master information 106e stores various masters. Examples of the various masters include an operator master having information on the name of an operator associated with an operator code, a department master having information on the name of a department associated with a department code, and the like.
[0023] The control unit 102 is a CPU or the like that comprehensively controls the inventory reservation processing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs defining various processing procedures, required data, and the like, and executes various information processes based on these stored programs. Here, the control unit 102 functionally includes an inventory data management unit 102a, a secured data management unit 102b, an order received data management unit 102c, and a display execution unit 102d.
[0024] The inventory data management unit 102a as the second update means manages the inventory data table 106a. For example, the inventory data management unit 102a updates the inventory data table 106a when there is a new arrival of a predetermined product or when there is a new order received for a predetermined product.
[0025] The secured data management unit 102b as the first update means manages the secured data table 106b. For example, the secured data management unit 102b updates the secured data table 106b when there is a new request for securing a predetermined product or when there is a new order received for a predetermined product.
[0026] The order data management unit 102c, which serves as an acquisition unit, manages the order data table 106c. For example, the order data management unit 102c updates the order data table 106c when a new order for a specific product is received. The order data table 106c also acquires necessary information from the reserved data table 106b.
[0027] The display execution unit 102d as a display execution means uses the screen data 106d to display various display screens and various input screens on the output device 114 or the like.
[0028] [2. Specific Examples] An example of the functions of the inventory allocation processing device 100 according to this embodiment will be specifically described with reference to FIGS.
[0029] From the perspective of inventory management, there are cases where it is necessary to secure a certain amount of inventory without being based on transaction records such as estimates or orders. This can occur when a specific department or person in charge needs to reserve an amount of inventory expected to be shipped over a certain period of time, or when an expected transaction volume for a major customer needs to be secured in advance. By setting the securing data, the inventory allocation processing device 100 of the embodiment makes it possible to secure a certain amount of inventory for a specific product without being based on transaction records.
[0030] FIG. 2 is a diagram showing an example of an allocation data input screen of the inventory allocation processing device 100 according to an embodiment. As shown in FIG. 2, a user can request the allocation of a predetermined number of a predetermined product by inputting various information on the allocation data input screen. In the example shown in FIG. 2, the allocation data requests the allocation of 13 units of product A. In response to this, the allocated number is 13 units. This indicates that there is sufficient stock of product A, and all 13 requested units have been allocated.
[0031] More specifically, on the secured data input screen, the user can specify the warehouse which is the inventory location of the target product, the person in charge and department who wish to secure the product, the customer which is the delivery destination of the product, the shipping date indicating the date to secure the product, the product to be secured, the quantity required for securing, and so on.
[0032] Regarding the person in charge, department, and customer, a person-in-charge master, department master, and customer master in which the person-in-charge code, department code, and customer code are associated with each piece of information, respectively, are stored in the storage unit 106.
[0033] FIG. 3 is a diagram showing an example of various masters stored in the storage unit 106 of the inventory reservation processing apparatus 100 according to the embodiment. FIG. 3(a) is the person-in-charge master. In the person-in-charge master, information such as the name of the person in charge and the department to which the person in charge belongs is associated with the person-in-charge code. FIG. 3(b) is the department master. In the department master, information such as the department name is associated with the department code. FIG. 3(c) is the customer master. In the customer master, information such as the customer name and customer classification is associated with the customer code.
[0034] With these various masters, the user can specify the name of the person in charge, the department in charge, and the customer by inputting a predetermined code on the secured data input screen, making the input easier. However, whether or not to input the person in charge and the customer is optional. In this embodiment, the case where the person in charge and the customer are not input will be described.
[0035] Thus, when secured data is input on the secured data input screen, the secured data management unit 102b adds this new secured data to the secured data table 106b.
[0036] Figure 4 is a diagram showing an example of the allocation data table 106b of the inventory allocation processing device 100 according to the embodiment. As shown in Figure 4, the allocation data table 106b contains information such as the allocation number, warehouse, person in charge, department, customer, shipping date, product, quantity, allocated number, transferred number, and transfer completion category. In the example of Figure 4, the newly entered allocation data of Figure 2 has been added as the allocation number "KAK00001." The person in charge and customer are not entered and are left blank.
[0037] More specifically, the allocation data management unit 102b first causes the inventory data management unit 102a to extract inventory data related to the item to be allocated from the inventory data table 106a. The allocation data management unit 102b then references the number of items in stock that can be allocated for the item. If the available allocation number for the item is equal to or greater than the requested allocation number, the allocation data management unit 102b sets the available allocation number as the allocated number for the item. If the available allocation number is less than the allocated number, the allocation number is set as the allocated number for the item.
[0038] 4, the quantity is the requested number of items to be reserved. The allocated number is the number of items that have actually been reserved. The transferred number and transfer completion classification will be described later.
[0039] The display execution unit 102e refers to the reservation data added to the reservation data table 106b, and displays the allocated quantity set in the reservation data table 106b on the reservation data input screen, as described above.
[0040] When the allocation data management unit 102b sets a new allocated quantity in the allocation data table 106b, the inventory data management unit 102a updates the inventory data table 106a.
[0041] Fig. 5 is a diagram showing an example of the inventory data table 106a of the inventory allocation processing device 100 according to the embodiment. As shown in Fig. 5, the inventory data table 106a has information such as warehouse, product, current inventory quantity, allocated quantity, and available allocation quantity. In the example of Fig. 5, the allocated quantity and available allocation quantity for product A stocked in warehouse A have been updated.
[0042] More specifically, when an allocated quantity is set in the allocation data table 106b, the inventory data management unit 102a subtracts the allocated quantity from the current inventory quantity of the corresponding product in the inventory data table 106a. Also, the inventory data management unit 102a adds the allocated quantity to the allocated quantity of the corresponding product in the inventory data table 106a. Furthermore, the inventory data management unit 102a subtracts the allocated quantity from the available allocation quantity of the corresponding product in the inventory data table 106a.
[0043] In other words, among the various information in the inventory data table 106a shown in Figure 5, the allocated quantity includes the quantity of products that are still in the warehouse but have been secured by request. This means that even though these products are actually in existence, they are in a secured state so that they cannot be shipped based on, for example, orders for other products.
[0044] Next, the actual receipt of an order for a product will be described.
[0045] 6 is a diagram showing an example of an order data input screen of the inventory allocation processing device 100 according to the embodiment. As shown in FIG. 6, a user can enter various information on the order data input screen to confirm an order for a specific product. In the example shown in FIG. 6, the order data requests delivery of 20 units of product A to customer A.
[0046] More specifically, on the order data input screen, the user can specify the warehouse, customer, person in charge, department, product, product quantity, etc. The customer, person in charge, and department can be specified by inputting a predetermined code on the order data input screen using the various masters shown in Figure 3. At this time, the user can also press the reserve transfer button to check whether products that meet the above input conditions have been reserved.
[0047] 7 is a diagram showing an example of a no-match error screen of the inventory allocation processing device 100 according to the embodiment. When a product matching the input order data is not available, the no-match error screen shown in FIG. 7 is displayed. In this case, the ordered product is allocated from the regular inventory (current stock).
[0048] 8 is a diagram showing an example of a reservation transfer instruction screen of the inventory allocation processing device 100 according to the embodiment. When a product matching the input order data is reserved, the reservation transfer instruction screen shown in FIG. 8 is displayed.
[0049] More specifically, when a user presses the reservation transfer button, the order data management unit 102c references the reservation data table 106b to obtain reservation data that matches the input on the order data input screen. For the order data management unit 102c to determine that a product matching the input order data has been reserved, reservation data must exist that matches at least the warehouse, product, and department. Additionally, reservation data that matches the responsible person and responsible department, or in which these are not set, is determined to meet the conditions. In the example of FIG. 8, reservation data without a responsible person or responsible department set (blank fields) is extracted.
[0050] On the transfer instruction screen, the user can input the number of transfers desired for the current order. When the secured quantity of the secured data extracted as meeting the conditions is greater than or equal to the order quantity, the user can set any value with the order quantity as the maximum value as the current transfer quantity. When the secured quantity of the secured data is less than the order quantity, the user can set any value with the secured quantity as the maximum value as the current transfer quantity. The shortage for the order quantity is allocated from the normal inventory (current inventory). Note that as the initial value on the secured transfer instruction screen, the maximum value is input in any of the above cases. Thereby, if no numerical value change is made by the user, allocation can be preferentially performed from the secured data, and the shortage can be filled from the current inventory.
[0051] As described above, when the required number of products for an order is allocated, the order data management unit 102c adds this new order data to the order data table 106c.
[0052] FIG. 9 is a diagram showing an example of the order data table 106c of the inventory allocation processing apparatus 100 according to the embodiment. As shown in FIG. 9, the order data table 106c has information such as order number, warehouse, person in charge, department, customer, shipping date, product, quantity, and allocated quantity. In the example of FIG. 9, the order data of FIG. 6 newly input is added as the order number "JUT00001".
[0053] Also, as described above, when a transfer occurs from the secured data, the secured data management unit 102b updates the secured data table 106b.
[0054] FIG. 10 is a diagram showing an example of the secured data table 106b of the inventory allocation processing apparatus 100 according to the embodiment. In the example of FIG. 10, for the secured data of the secured number "KAK00001" from the example of FIG. 4 shown above, the allocated quantity and the transferred quantity have been updated.
[0055] More specifically, when a transfer occurs from the secured data, the secured data management unit 102b subtracts the current transfer number in Figure 8 from the allocated number of the corresponding secured data in the secured data table 106b. Also, the secured data management unit 102b adds the current transfer number to the transferred number of the corresponding secured data in the secured data table 106b.
[0056] In other words, among the various information in the reservation data table 106b shown in Figure 10, the allocated quantity indicates the quantity of product currently reserved. In the example of Figure 10, all 13 units reserved for product A have been transferred, so the current reservation quantity for product A in the reservation data with reservation number "KAK00001" is zero. In other words, all transfers for this reservation data have been completed.
[0057] In this way, when the transfer of a certain secured data item is completely completed, the secured data management unit 102b changes the status of the transfer completion category of the secured data item from FALSE to TRUE, thereby indicating that the transfer of the secured data item is completed.
[0058] Furthermore, as described above, when the quantity currently in stock changes due to a new order, the inventory data management unit 102a updates the inventory data table 106a.
[0059] 11 is a diagram illustrating an example of the inventory data table 106a of the inventory allocation processing device 100 according to the embodiment. In the example of Fig. 11, the allocated quantity and available allocation quantity of product A stocked in warehouse A have been updated from the example of Fig. 5 shown above.
[0060] More specifically, when there is a new order for a predetermined product, the inventory data management unit 102a adds the amount allocated from the current inventory to the allocated quantity of the corresponding product in the inventory data table 106a. In the above example, out of the 20 ordered items, 7 items excluding the 13 allocated items are the amount allocated from the current inventory. Also, the inventory data management unit 102a subtracts the amount allocated from the current inventory from the available allocation quantity of the corresponding product in the inventory data table 106a.
[0061] That is, among the various types of information in the inventory data table 106a shown in FIG. 11, the allocated quantity includes the allocated quantity based on transaction records such as estimates and orders, and the allocated quantity based on secured data.
[0062] Note that the inventory allocation processing device 100 has a function of querying secured data and inventory data.
[0063] FIG. 12 is a diagram showing an example of a secured data query screen of the inventory allocation processing device 100 according to the embodiment. As shown in FIG. 12, information such as the secured number, secured date, warehouse, person in charge, department, customer, shipping date, product, and secured quantity is displayed on the secured data query screen. Thereby, the user can confirm whether there is any secured data of unknown use or fraudulent secured data registered.
[0064] FIG. 13 is a diagram showing an example of an inventory data query screen of the inventory allocation processing device 100 according to the embodiment. As shown in FIG. 13, information such as the warehouse, product, current inventory quantity, allocated quantity, and available allocation quantity is displayed on the inventory data query screen. As described above, the available allocation quantity does not include the products corresponding to the secured data that cannot actually be allocated although there is still inventory. Thereby, the user can know the substantially allocable quantity among the products actually in stock.
[0065] [3. Processing] An example of inventory allocation processing executed by the inventory allocation processing device 100 having the above-described configuration will be described with reference to Fig. 14. Fig. 14 is a flow diagram showing an example of the procedure of inventory allocation processing executed by the inventory allocation processing device 100 according to the embodiment.
[0066] 14, the inventory allocation processing device 100 accepts the user's input of order data on the order data input screen (step S10). When the user presses the reservation transfer button on the order data input screen (step S20), the order data management unit 102c refers to the reservation data table 106b and determines whether there is reservation data whose input contents on the order data input screen match at least the warehouse, product, and department (step S30).
[0067] If there is no corresponding secured data, the received order data management unit 102c determines that there is no match (step S30: No), and the display execution unit 102d displays a no match error screen on the output device 114 (step S70).
[0068] If there is corresponding secured data (step S30: Yes), the order data management unit 102c determines whether the person in charge of the secured data matches the input content or whether the field is blank (step S40).
[0069] If the person in charge of the reservation data is not blank and does not match the input content (step S40: No), the display execution unit 102d displays a no match error screen on the output device 114 (step S70).
[0070] If the person in charge of the secured data matches the input content or is left blank (step S40: Yes), the order data management unit 102c determines whether the customer of the secured data matches the input content or is left blank (step S50).
[0071] If the customer of the secured data is not blank but does not match the input content (step S50: No), the display execution unit 102d causes the output device 114 to display a non-applicable error screen (step S70).
[0072] If the customer of the secured data matches the input content or is blank (step S50: Yes), the order receiving data management unit 102c acquires the secured data, and the display execution unit 102d causes the output device 114 to display a secured transfer instruction screen based on the information of the secured data (step S60).
[0073] As described above, the inventory reservation process executed by the inventory reservation processing device 100 ends.
[0074] [4. Effects of the Embodiment] There are cases where it is desired to secure a predetermined quantity of inventory for a certain product without relying on transaction results such as estimates and orders, for example, when shipments of a predetermined product are expected within a certain period. Conventionally, in such cases, it has been necessary to record dummy order receiving data or the like. Furthermore, when an actual order is received later, complicated procedures such as subtracting the reserved quantity based on the dummy order receiving data and transferring the reserved inventory to the order receiving data of the actual transaction have been required.
[0075] According to the inventory reservation processing device 100 of the embodiment, at least by setting a warehouse, a product, and a department and registering the secured data, it is possible to easily secure a predetermined product without relying on transaction results. As a result, it becomes possible to manage the secured inventory that is not linked to the transaction results in addition to the current inventory and the reserved inventory.
[0076] According to the inventory reservation processing device 100 of the embodiment, when an actual order is received, it is possible to preferentially ship from the secured inventory. At that time, the user can arbitrarily specify the quantity to be transferred this time from among the secured quantity.
[0077] [5. Modification Example] Next, an inventory allocation processing device according to a modification of the embodiment will be described with reference to Fig. 15. The inventory allocation processing device according to the modification differs from the embodiment described above in that a person in charge and a customer are set in the reservation data.
[0078] 15 is a diagram showing an example of an allocation data input screen of an inventory allocation processing device according to a modified example of the embodiment. As shown in FIG. 15, on the order data input screen, in addition to the warehouse, product, department, etc., the person in charge, and customer are set.
[0079] In the inventory allocation processing device of the modified example, by setting a customer, it is possible to more reliably reserve products for a specific customer, for example, in cases where a customer has regular deliveries or a specific customer is expected to suddenly receive a large order, etc. Unlike when the customer field is left blank, it is possible to prevent the reserved products from being allocated to other orders.
[0080] In the inventory allocation processing device of the modified example, by setting a customer, it is possible to meet the needs of, for example, a department that needs to secure merchandise for each customer on a departmental basis, or a department that wants to secure merchandise on a departmental basis. Also, by setting both a person in charge and a customer, it is possible to meet the needs of, for example, a department that needs to secure merchandise for each customer on a departmental basis, or a department that wants to secure merchandise for a specific customer on a departmental basis.
[0081] 6. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0082] 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.
[0083] Furthermore, 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 can be changed as desired unless otherwise specified.
[0084] Furthermore, with regard to the inventory allocation processing device 100, the components shown in the figures are functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.
[0085] For example, all or any part of the processing functions of the inventory allocation processing device 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory, computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the inventory allocation processing device 100 as needed. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to issue instructions to the CPU and perform various processes. The computer program is executed by being loaded into RAM, and works with the CPU to constitute the control unit 102.
[0086] This computer program may also be stored in an application program server connected to the inventory allocation processing device 100 via any network, and all or part of it may be downloaded as needed.
[0087] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "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.
[0088] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. 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, can use well-known configurations and procedures.
[0089] The various databases 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 used for various processes and providing websites.
[0090] The inventory allocation processing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device connected to any peripheral device. The inventory allocation processing device 100 may also be realized by installing software (including programs, data, etc.) that causes the information processing device to perform the processing described in this embodiment.
[0091] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or function additions. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]
[0092] The present invention is useful in industries such as distribution and retail. [Explanation of symbols]
[0093] 100 Inventory allocation processing device 102 Control section 102a Inventory Data Management Department 102b Secured Data Management Department 102c Order Data Management Department 102d Display execution unit 104 Communication interface unit 106 Storage section 106a Inventory Data Table 106b Reserved Data Table 106c Order data table 106d screen data 106e Master Information 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network
Claims
1. An allocation data management unit that secures a specified quantity of products that meet the specified securing conditions, referring to the inventory data stored in the inventory data table, and stores the securing data including the secured quantity of the secured products as the allocated quantity in the securing data table; An order data management unit that extracts, from the securing data table, the securing data that meets the order conditions specified at the time of input of order data, makes an allocation for the quantity of products required for the order based on the securing data, and stores, in the order data table, the order data including the allocated quantity of the products allocated based on the securing data and the order conditions; and The securing conditions and the order conditions are at least one or more of the inventory location of the product, the person in charge who wishes to secure the product, and the department that wishes to secure the product; When the secured quantity of the securing data extracted as meeting the order conditions is equal to or greater than the order quantity, the order data management unit sets the current transfer quantity, which is the required quantity arbitrarily specified with the order quantity as the maximum value, so as to set the current transfer quantity that meets the securing conditions and the order conditions, which are at least one or more of the inventory location of the product, the person in charge who wishes to secure the product, and the department that wishes to secure the product; An inventory allocation processing apparatus, characterized by the above.
2. When the secured quantity of the securing data extracted as meeting the order conditions is less than the order quantity, the order data management unit sets the current transfer quantity, which is arbitrarily specified with the secured quantity as the maximum value, as the allocated quantity, and allocates the shortage with respect to the order quantity from the current inventory; The inventory allocation processing apparatus according to claim 1, characterized by the above.
3. The securing conditions and the order conditions are at least one or more of the inventory location of the product, the person in charge who wishes to secure the product, the department that wishes to secure the product, and the customer, which is the delivery destination of the product; The inventory allocation processing apparatus according to claim 1 or claim 2, characterized by the above.
4. A securing data management step in which a securing data management unit secures a specified quantity of products that meet the specified securing conditions, referring to the inventory data stored in the inventory data table, and stores the securing data including the secured quantity of the secured products as the allocated quantity in the securing data table; The order data management unit extracts the secured data that meets the order conditions specified at the time of input of the order data from the secured data table, makes an appropriation for the required number of products for the order based on the secured data, and stores the appropriated quantity of the products appropriated based on the secured data and the order data including the order conditions in the order data table, and the secured conditions and the order conditions are at least one or more of the inventory location of the product, the person in charge who wishes to secure the product, and the department that wishes to secure the product, in the order data management step, when the secured quantity of the secured data extracted as meeting the order conditions is equal to or greater than the order quantity, by setting the current transfer quantity, which is the required quantity arbitrarily designated with the order quantity as the maximum value, to set the current transfer quantity that meets at least one or more of the secured conditions and the order conditions, which are the inventory location of the product, the person in charge who wishes to secure the product, and the department that wishes to secure the product, characterized by an inventory appropriation processing method.
5. A computer, secures the specified quantity of products that meet the specified secured conditions by referring to the inventory data stored in the inventory data table, and functions as a secured data management unit that stores the secured data including the secured quantity of the secured products as the appropriated quantity in the secured data table, extracts the secured data that meets the order conditions specified at the time of input of the order data from the secured data table, makes an appropriation for the required number of products for the order based on the secured data, and functions as an order data management unit that stores the appropriated quantity of the products appropriated based on the secured data and the order data including the order conditions in the order data table, the secured conditions and the order conditions are at least one or more of the inventory location of the product, the person in charge who wishes to secure the product, and the department that wishes to secure the product, the order data management unit, when the secured quantity of the secured data extracted as meeting the order conditions is equal to or greater than the order quantity, by setting the current transfer quantity, which is the required quantity arbitrarily designated with the order quantity as the maximum value, to set the current transfer quantity that meets at least one or more of the secured conditions and the order conditions, which are the inventory location of the product, the person in charge who wishes to secure the product, and the department that wishes to secure the product, characterized by an inventory appropriation processing program.
Citation Information
Patent Citations
Distributed data processing system
JP2000322390A
Commodity allocation system, commodity allocation method, commodity allocation program, and storage medium
JP2005038259A
System for securing and processing commodity inventory
JP2006106847A