Order management device, order management method, and order management program
The order management device simplifies inventory and order adjustments by using a control unit with acquisition, display, reception, and determination units to manage product inventory by item number and unit, addressing the complexity of large-scale order processing.
Patent Information
- Authority / Receiving Office
- JP · JP
- Patent Type
- Applications
- Current Assignee / Owner
- OBIC CO LTD
- Filing Date
- 2024-12-18
- Publication Date
- 2026-06-30
AI Technical Summary
Managing product inventory in two stages by item number and product unit becomes complicated when large-scale orders are received simultaneously, especially at events like exhibitions, due to the need for complex order adjustments.
An order management device and method that includes a storage unit and control unit with acquisition, display, reception, and determination units to manage and adjust orders by item number and product unit, allowing easy processing and tracking of inventory and order adjustments.
Facilitates easy adjustment of orders and inventory management by product number and unit, simplifying the processing of large-scale orders and improving operational efficiency.
Smart Images

Figure 2026106672000001_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to an order management device, an order management method, and an order management program.
Background Art
[0002] For example, a merchant dealing with products such as clothing, watches, furniture, etc. may manage the inventory of products in two stages: by item number and by products with different sizes and colors associated with the item number. Such a merchant may receive orders in terms of item numbers without specifying the breakdown by product unit at an event such as an exhibition.
Prior Art Documents
Patent Documents
[0003]
Patent Document 1
Summary of the Invention
Problems to be Solved by the Invention
[0004] At large-scale exhibitions and the like, orders in terms of item numbers may be received from a plurality of customers simultaneously, and the adjustment of the order quantity may become complicated.
[0005] The present invention has been made in view of the above, and an object thereof is to provide an order management device, an order management method, and an order management program that can easily perform order adjustment when managing product inventory in two stages: by item number and by product unit.
Means for Solving the Problems
[0006] To solve the above-mentioned problems and achieve the objective, the order management device according to the present invention manages orders for product numbers associated with multiple products. The order management device comprises a storage unit and a control unit. The control unit comprises an acquisition unit, a display unit, a reception unit, and a determination unit. The acquisition unit acquires a first quantity in unit of product numbers, associated with multiple order sources. The display unit displays the multiple first quantities in unit of product numbers, associated with each of the multiple order sources. The reception unit receives input of a second quantity to be assigned to the first quantity for each order source. The determination unit calculates the total quantity of the second quantities associated with the multiple order sources and determines whether the calculated total quantity exceeds a third quantity.
[0007] Furthermore, the order management method according to the present invention includes the steps of: obtaining a first quantity in unit of product numbers associated with a plurality of order sources; displaying the plurality of first quantities in unit of product numbers, associated with each of the plurality of order sources; receiving input of a second quantity to be assigned to the first quantity for each order source; calculating the total quantity of the second quantities associated with the plurality of order sources, and determining whether the calculated total quantity exceeds a third quantity.
[0008] Furthermore, the order management program according to the present invention causes the control unit to perform the following steps: acquire a first quantity in unit of part numbers associated with a plurality of order sources; display the plurality of first quantities in unit of part numbers, associated with each of the plurality of order sources; receive input of a second quantity to be assigned to the first quantity for each order source; calculate the total quantity of the second quantities associated with the plurality of order sources, and determine whether the calculated total quantity exceeds a third quantity. [Effects of the Invention]
[0009] According to the present invention, when managing product inventory in two stages, by product number and by individual product, it becomes possible to easily adjust order processing. [Brief explanation of the drawing]
[0010] [Figure 1] Figure 1 shows an example of the order management process flow using the order management system in the embodiment. [Figure 2] Figure 2 shows an example of the configuration of an order management system according to the present invention. [Figure 3] Figure 3 shows an example of the information stored in the master storage unit of the order management device according to this embodiment. [Figure 4] Figure 4 shows an example of a part number master according to the embodiment. [Figure 5] Figure 5 shows an example of a customer master according to the embodiment. [Figure 6] Figure 6 shows an example of a warehouse master according to the embodiment. [Figure 7] Figure 7 shows an example of a delivery destination master according to the embodiment. [Figure 8] Figure 8 shows an example of shipping data stored in the data storage unit of the order management device according to the embodiment. [Figure 9] Figure 9 shows an example of inputting a temporary reserve quantity on the temporary input screen according to the embodiment. [Figure 10] Figure 10 shows an example of order processing for inventory data and order data stored in the data storage unit of the order management device according to the embodiment. [Figure 11] Figure 11 shows an example of inventory data according to the embodiment. [Figure 12] Figure 12 shows an example of a separate order slip containing part number data stored in the data storage unit of the order management device according to the embodiment. [Figure 13] Figure 13 is a diagram showing another example of inventory data according to the order slip embodiment used in the order processing according to the embodiment. [Figure 14] Figure 14 shows an example of incoming delivery details data stored in the data storage unit of the order management device according to the embodiment. [Figure 15] Figure 15 is a diagram showing another example of the inventory data inventory inquiry screen after the receipt quantity is imported according to the embodiment. [Figure 16] Figure 16 is a diagram showing an example of the input of the secured quantity on the main input screen according to the embodiment. [Figure 17] Figure 17 is a diagram showing another example of the item number - specific data according to the embodiment. [Figure 18] Figure 18 is a diagram showing an example of the breakdown input screen according to the embodiment. [Figure 19] Figure 19 is a diagram showing another example of the order inquiry screen that has received a breakdown data change operation according to the embodiment. [Figure 20] Figure 20 is a diagram showing an example of the order input screen according to the embodiment. [Figure 21] Figure 21 is a diagram showing an example of the order details input screen according to the embodiment. [Figure 22] Figure 22 is a diagram showing another example of the order header 106be according to the embodiment. [Figure 23] Figure 23 is a diagram showing another example of the order details data 106bf according to the embodiment. [Figure 24] Figure 24 is a diagram showing another example of the item number - specific data according to the embodiment. [Figure 25] Figure 25 is a diagram showing another example of the breakdown data according to the embodiment. [Figure 26] Figure 26 is a diagram showing another example of the inventory data according to the embodiment. [Figure 27] Figure 27 is a diagram showing another example of the inventory data according to the embodiment. [Figure 28] Figure 28 is a diagram showing another example of the breakdown data 106bb according to the embodiment. [Figure 29] Figure 29 is a diagram showing an example of another breakdown input screen 3900 according to the embodiment.
Mode for Carrying Out the Invention
[0011] Embodiments of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to these embodiments.
[0012] [1. Overview] First, the shipment adjustment process in this embodiment will be explained using Figures 1 and 2. Figure 1 is a diagram showing an example of the flow of the shipment adjustment process by the order management system 1 in this embodiment. Figure 2 is a diagram showing an example of the configuration of the order management system 1 according to this embodiment.
[0013] In this embodiment, product inventory is managed using products with different sizes and colors, each associated with a product number, as the smallest management unit (SKU: Stock Keeping Unit). In cases such as large-scale events like trade shows, the company may receive tentative inquiries from multiple customers at the product number level, specified at the SKU level. Furthermore, depending on the customer's inventory levels and sales situation, the quantity of tentative inquiries and the actual order quantity may fluctuate significantly, and orders based on inquiries may be placed in multiple installments.
[0014] In this embodiment, the order management device 100 shown in Figure 2 first provisionally secures inventory on a part number basis without specifying a breakdown by product (SKU) unit in response to the provisional inquiry (part number-based inventory securing process shown in Figure 1). Next, when an order is placed with a supplier such as a wholesaler or factory based on the secured inventory, the order management device 100 processes the inventory to incorporate the goods received as a result of the order (incoming inventory processing). Note that the incoming inventory processing may be omitted if there is a sufficient quantity of inventory without the need to place a new order.
[0015] Once the inventory quantity has been secured through the incoming inventory processing, the order management device 100 secures the quantity for each product number from the provisionally secured inventory (product number-specific final reservation processing). Subsequently, the order management device 100 accepts input of the breakdown for each product number (breakdown input processing), and then transfers the entered breakdown to the actual order (order transfer processing). After that, when the ordered goods are shipped, the order management device 100 reflects the quantity of the shipped goods in the inventory quantity (shipment reflection processing).
[0016] [2. Structure] The order management system 1 according to this embodiment can be used by companies that handle items where product management is performed in two layers: product number + product (size, color, etc.), such as apparel companies and manufacturers of miscellaneous goods such as watches and furniture.
[0017] In Figure 2, the order management system 1 is configured, for example, as a server-client system, with an order management device 100 that functions as a server and multiple terminal devices 200 that are able to communicate with each other via a network 300.
[0018] Terminal devices 200 are placed in various departments within the company (e.g., sales department, shipping department, warehouse department, etc.). Each terminal device 200 is equipped with a monitor, keyboard, printer, etc., and displays various input screens provided by the order management system 100 on the monitor, allowing the person in charge (operator) to perform various inputs. In addition, each terminal device 200 displays various data information stored by the order management system 100 and various output screens generated by the order management system 100 on the monitor, allowing users to view this information and input into the various output screens.
[0019] The terminal device 200 may be, for example, a commercially available desktop personal computer, and is not limited to stationary information processing devices such as desktop personal computers, but may also be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, or tablet personal computers.
[0020] The order management device 100 can be configured, for example, as a workstation or a personal computer.
[0021] The order management device 100 comprises a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the order management device 100 is connected to communicate via any communication path.
[0022] The communication interface unit 104 connects the order management device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines, enabling communication between the network and the order management device 100. The communication interface unit 104 has the function of communicating data with other devices via communication lines. Here, the network 300 has the function of connecting the order management device 100 and the terminal device 200 so that they can communicate with 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, a mouse, a microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or mouse 112.
[0024] The control unit 102 is a CPU or the like that comprehensively controls the order management device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. Functionally, the control unit 102 comprises an acquisition unit 102a, a display unit 102b, a reception unit 102c, and a determination unit 102d. Each processing unit 102a to 102d will be described in detail later.
[0025] 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.
[0026] As shown in Figure 2, the storage unit 106 includes a master storage unit 106a and a data storage unit 106b.
[0027] As shown in Figure 3, the master storage unit 106a stores the part number master 106aa, the customer master 106ab, the warehouse master 106ac, and the delivery destination master 106ad. Figure 3 is a diagram showing an example of the information stored in the master storage unit 106a of the order management device 100 according to this embodiment.
[0028] The part number master 106aa stores information about multiple products associated with a part number. As shown in Figure 4, the part number master 106aa can consist of tables that associate and register "part number name," "product code," and "product name," as well as "sales price" and "consumption tax rate," in association with the "part number code." Figure 4 is a diagram showing an example of the part number master 106aa according to an embodiment. The "part number code" is information that uniquely identifies the "part number name." The "product code" is information that uniquely identifies the "product name."
[0029] As shown in Figure 4, in this embodiment, multiple product codes are associated with a single product code. Also, as shown in Figure 4, products with the same product code but different product codes are, for example, products with the same product name but different colors or sizes, as shown in columns aa1 and aa2 in Figure 4. In this embodiment, the unit sales price of multiple products associated with the same product code is the same, as shown in column aa3 in Figure 4, but the unit sales price may differ for each product. Note that although only the record for product code "SHO001" is shown in Figure 4, a different product code master 106aa may be prepared for each product code, and records for other product codes may be registered in the product code master 106aa.
[0030] The customer master 106ab stores information about customers who place orders for goods, as shown in Figure 5, by associating a "customer code," which is information that uniquely identifies the customer, with a "customer name." Figure 5 is a diagram showing an example of the customer master 106ab according to the embodiment. As shown in Figure 5, in the customer master 106ab of the embodiment, a customer code is assigned to each of the three customers A to C. Note that the customer is an example of a customer who places an order.
[0031] As shown in Figure 6, the warehouse master 106ac stores a "warehouse code," which is information that uniquely identifies the warehouse from which goods ordered by a customer are shipped, and associates this code with a "warehouse name," which indicates the name of the warehouse. Figure 6 shows an example of the warehouse master 106ac according to this embodiment.
[0032] As shown in Figure 7, the delivery destination master 106ad stores information about the delivery destinations of goods ordered by customers. Figure 7 is a diagram showing an example of the delivery destination master 106ad according to the embodiment. The delivery destination master 106ad stores a "delivery destination code," which is information that uniquely identifies a delivery destination, a "delivery destination name" that indicates the name of the delivery destination, and a "customer code" of the customer associated with that delivery destination, in association with each other. In Figure 7, only one delivery destination name is registered for one customer code, but multiple delivery destination names may be registered for one customer code, and records for multiple customer codes may be registered.
[0033] As shown in Figure 8, the data storage unit 106b stores part number data 106ba, breakdown data 106bb, inventory data 106bc, incoming goods detail data 106bd, order header 106be, and order detail data 106bf. Figure 8 is a diagram showing an example of the information stored by the data storage unit 106b of the order management device 100 according to this embodiment. Part number data 106ba stores information such as provisional inquiries from customers in the pre-order stage, on a part number basis. Breakdown data 106bb stores information such as the number of items allocated to customers and the quantity transferred to orders, on a product basis corresponding to the part number. Inventory data 106bc stores the inventory quantity of goods on a product basis corresponding to the part number. Incoming goods detail data 106bd stores information about goods received when an order is placed with a supplier, on a product basis corresponding to the part number. Order header 106be stores information about orders from customers. Order detail data 106bf stores the details of the order. The contents of each data 106ba to 106bf will be explained in detail later.
[0034] [3-1. Temporary reservation process by part number] When a customer makes an inquiry specifying an estimated quantity at the pre-order stage, without specifying a breakdown by product unit, the order management device 100 performs product-specific reservation processing. In product-specific reservation processing, the display unit 102b of the order management device 100 displays the reservation input screen 1000 shown in Figure 9 on, for example, the terminal device 200 or the monitor 114. Figure 9 is a diagram showing an example of inputting a provisional reservation quantity on the provisional input screen 1100. Note that when distinguishing between the reservation input screen 1000 displayed in the product-specific provisional reservation processing shown in Figure 9 and the product-specific final reservation processing described later, they may be referred to as the provisional input screen 1100 and the final input screen 1200, respectively.
[0035] As shown in Figure 9, the temporary input screen 1100 has an input field 1111 for the product code, an input field 1121 for the warehouse code, and an input field 1130 for the temporary reserve quantity. When a product code is entered in the product code input field 1111, the display unit 102b refers to the product code master 106aa shown in Figure 5 and displays the product code name corresponding to the entered product code in the product code name display field 1112. Similarly, when a warehouse code is entered in the warehouse code input field 1121, the display unit 102b refers to the warehouse master 106ac shown in Figure 7 and displays the warehouse name corresponding to the entered warehouse code in the warehouse name display field 1122.
[0036] Note that the input field 1111 for the part number code shown in Figure 9 may be a pull-down menu or the like where the part number codes registered in the part number master 106aa shown in Figure 5 are registered, and the part number name corresponding to the part number code in the pull-down menu or the like may be displayed in the display field 1112. The same applies to the input field 1121 and display field 1122 for the warehouse code shown in Figure 9, and to each field in each of the following input screens.
[0037] Furthermore, the temporary input screen 1100 shown in Figure 9 has a customer field 1140. The customer field 1140 displays the customer codes "TOK001", "TOK002", and "TOK003" registered in the customer master 106ab shown in Figure 5, as well as the customer name corresponding to each customer code. The temporary reservation quantity input field 1130 is where the temporary reservation quantities from customer A, customer B, and customer C are entered. The display unit 102b calculates the total of the temporary reservation quantities entered in the temporary reservation quantity input field 1130 and displays it in the "Total" field 1139. In Figure 9, information is entered indicating that customer A has inquired for "100 units", customer B for "200 units", and customer C for "300 units" for product code "SHO001". The total temporary reservation quantity of "600 units" is displayed in the total field 1139. In the temporary input screen 1100 shown in Figure 9, the reservation number 1151 is information that uniquely identifies the information regarding the reservation of goods on a per-product-number basis, and is automatically assigned, for example, when the input in the temporary reservation quantity input field 1130 is completed. Note that the temporary reservation quantity is an example of the first quantity on a per-product-number basis.
[0038] The acquisition unit 102a registers the provisionally reserved quantity entered in the provisional reservation quantity input field 1130 into the product number-specific data 106ba shown in Figure 10. Figure 10 is a diagram showing an example of product number-specific data 106ba according to the embodiment. As shown in Figure 10, the product number-specific data 106ba stores the "provisionally reserved quantity" shown in column ba1, the "confirmed reserved quantity" shown in column ba2, and the "order transfer quantity" shown in column ba3, associated with the "reservation number," the "product number code" and "product number name," the "warehouse code" and "warehouse name," and the "customer code" and "customer name." The "reservation number" column registers the reservation number assigned on the provisional input screen 1100. The "product number code" and "product number name," and the "warehouse code" and "warehouse name" columns register the product number code and warehouse code entered on the provisional input screen 1100, as well as the corresponding product number name and warehouse name. The "Temporarily Reserved Quantity" column registers the temporarily reserved quantities entered in the temporary input screen 1100, associated with the "Customer Code" and "Customer Name." In other words, the acquisition unit 102a acquires the first quantity on a per-product basis, associated with multiple order sources. Note that in the per-product-number temporary reservation process, no information is registered in the confirmed reserved quantity shown in column ba2 and the quantity transferred from orders shown in column ba3, and no records are registered in the breakdown data 106bb shown in Figure 2.
[0039] Furthermore, the configuration in which the acquisition unit 102a acquires the provisional reserve count is not limited to accepting input on the provisional input screen 1100. For example, the acquisition unit 102a may be configured to acquire the count from the terminal device 200 or other devices via the communication interface unit 104 and network 300 shown in Figure 2.
[0040] Furthermore, the display unit 102b may display the contents of the inventory data 106bc shown in Figure 11 on the temporary input screen 1100. Figure 11 is a diagram showing an example of inventory data 106bc according to the embodiment. As shown in Figure 11, the inventory data 106bc includes a "warehouse code" and a "warehouse name", a "product code", a "current inventory" shown in column bc1, a "number of unshipped orders" shown in column bc2, and a "number of undelivered ordered items" shown in column bc3. The "warehouse code" indicates the warehouse where the inventory is stored, and the "current inventory" indicates the number of items in stock at that warehouse. The "number of unshipped orders" indicates the quantity of items that have been ordered by customers but have not yet been shipped, and the "number of undelivered ordered items" indicates the quantity of items that have been ordered from suppliers but have not yet been delivered.
[0041] When accepting input for a provisional reserve quantity, an order for goods corresponding to that provisional reserve quantity may be placed separately with the supplier. For example, an order processing process related to an order slip, as shown in Figure 12, is performed. Figure 12 is a diagram showing an example of an order slip 2000 according to the embodiment. The order slip 2000 includes, for example as shown in Figure 12, an order number 2051 which is information that uniquely identifies the order, a product code 2011 which is the product code to be ordered, and a warehouse code 2021 which indicates the warehouse to which the ordered goods will be received. The order number 2051 is assigned automatically, for example, during the order processing. In addition, the order quantity for multiple products associated with product codes is entered in column 2030 of the order slip 2000.
[0042] Furthermore, if an order is placed, the acquisition unit 102a may reflect the ordered quantity in the inventory data 106bc as shown in Figure 13. Figure 13 is a diagram showing another example of the inventory data 106bc according to the embodiment. The incoming delivery slip number shown in Figure 13 is information that uniquely identifies the arrival of goods associated with an order, and is assigned by the supplier, for example, corresponding to the order number 2051 shown in Figure 12.
[0043] As shown in column bc3 of Figure 13, the number of undelivered ordered items in inventory data 106bc is increased by the order quantity entered in the column of order slip 2000. For example, for the product code "SHO0010103" shown in row bc03 of Figure 13, the quantity "50" entered in column bc3 of Figure 11 is increased by the quantity "50" entered in row 2003 of order slip 2000 in Figure 12, resulting in "100".
[0044] Furthermore, order processing may be performed by a device other than the order management device 100, for example. Also, order processing may be performed on a part number basis, without specifying individual product units. In this case, the actual quantity of products to be received can be arbitrarily determined by the supplier, etc.
[0045] [3-2. Incoming Stock Processing] Then, in the incoming goods import process shown in Figure 1, the order management device 100 imports the quantity received based on the order slip 2000 into the current inventory count shown in Figure 11. Figure 14 is a diagram showing an example of incoming goods detail data 106bd according to the embodiment.
[0046] Furthermore, the quantity ordered may not match the number of items received due to changes in the amount of material inventory at the manufacturing stage, which may result in production cuts or increases. For example, for product codes "SHO0010103" and "SHO0010203", the number of items received may be "45" for the ordered quantity of "50" shown in Figure 12, as shown in rows bd03 and bd06 of Figure 14. In this case, the total number of items received may be "590", which is less than the total ordered quantity of "600". In this case, after consulting separately with customers A through C, the order management device 100 will make adjustments to the provisional reserved quantity entered in the product code data 106ba during the product code-specific reservation process.
[0047] Furthermore, as shown in Figure 15, the acquisition unit 102a updates the current inventory quantity shown in column bc1 and the number of ordered items not yet received shown in column bc3 of the inventory data 106bc. Figure 15 is a diagram showing another example of inventory data 106bc according to the embodiment. For example, the current inventory quantity of "47" for product code "SHO0010203" shown in Figure 15 is obtained by adding the current inventory quantity of "2" before the receiving import process shown in Figure 13 to the number of received items of "45" shown in Figure 14.
[0048] In this case, as shown in row bc03 of Figure 15, the quantity "50" listed on order slip 2000 is subtracted from the number of ordered but undelivered items, but only the "45" that were actually received are added to the current inventory.
[0049] [3-3. Securing of stock by product number] Next, in the final reservation process by product number, the display unit 102b displays the final input screen 1200, which includes the contents of the updated inventory data 106bc. Figure 16 is a diagram showing an example of inputting the final reservation quantity on the final input screen 1200 according to the embodiment. The final input screen 1200 shown in Figure 16 displays the reservation number "KK00001" indicated by reference numeral 1151, which was assigned in the temporary input screen 1100 shown in Figure 9, and column 1130 displays the temporary reservation quantity entered in the temporary input screen 1100. That is, the display unit 102b displays the multiple first quantities in association with each of the multiple customer bases, on a per-product-number basis. In addition, the "final reservation quantity" input field indicated by reference numeral 1240 on the final input screen 1200 is entered by a user (not shown) for each customer. The final reservation quantity is an example of a second quantity assigned to the first quantity for each customer base.
[0050] Furthermore, this input screen 1200 also displays that the total confirmed reserved quantity "590" shown in the total quantity field 1249 is less than the total provisional reserved quantity "600" shown in symbol 1139. This allows the user to view the provisional reserved quantities across multiple customers in a list, making it easy to adjust the reserved quantities.
[0051] Furthermore, the reception unit 102c receives input for the input field 1240 of the final reserved quantity to be assigned to the provisional reserved quantity displayed in column 1130 of Figure 16. In other words, the reception unit 102c receives input for the second quantity to be assigned to the first quantity for each of the order sources.
[0052] The determination unit 102d may calculate the total number of reserved items entered in the input field 1240 and determine whether the calculated total quantity exceeds the total number of incoming items. The total number of incoming items, "590," is an example of the third quantity, which is the number of items that can be shipped per item number. In other words, the determination unit 102d may calculate the total quantity of the second quantity associated with multiple order sources and determine whether the calculated total quantity exceeds the third quantity. If the determination unit 102d determines that the calculated total quantity exceeds the total number of incoming items, the display unit 102b may display an error message on the input screen 1200 shown in Figure 16.
[0053] Furthermore, the reception unit 102c reflects the confirmed reserved quantity entered on the input screen 1200 into the product code data 106ba, as shown in Figure 17. Figure 17 is a diagram showing another example of the product code data 106ba according to the embodiment. As shown in columns ba1 and ba2 of Figure 17, a confirmed reserved quantity of "98" is assigned to customer A's provisional reserved quantity of "100", a confirmed reserved quantity of "197" is assigned to customer B's provisional reserved quantity of "200", and a confirmed reserved quantity of "295" is assigned to customer C's provisional reserved quantity of "300". Note that even at this stage, no record is registered in the breakdown data 106bb.
[0054] [3-4. Breakdown Input Processing] Furthermore, when the reception unit 102c receives confirmation that row 1201 has been selected in the main input screen 1200 shown in Figure 16, the display unit 102b displays the breakdown input screen 3100 shown in Figure 18. Figure 18 is a diagram showing an example of the breakdown input screen 3100 according to the embodiment. As shown in Figure 18, the breakdown input screen 3100 has an input field 3151 for the reserved number, an input field 3121 for the product code, an input field 3131 for the warehouse code, and an input field 3161 for the customer code. In Figure 18, when a reserved number is entered in the input field 3151, the display unit 102b displays the product code, product name, warehouse code, and warehouse name corresponding to the entered reserved number from the product code data 106ba shown in Figure 17 on the breakdown input screen 3100. In addition, the display field 3149 for the number of reserved items by customer displays the confirmed reserved number "98" registered in the product code data 106ba shown in Figure 17, which corresponds to the customer code entered in the input field 3161.
[0055] Furthermore, the breakdown input screen 3100 displays the current stock quantity, the number of orders not yet shipped, and the number of orders not yet received, per product, extracted from the inventory data 106bc shown in Figure 15. In addition, the breakdown input screen 3100 displays the number of items available for shipment, which is calculated by, for example, the following formula (1). Available quantity for shipment = Current inventory + Number of orders not yet received - Number of orders not yet received...(1)
[0056] For example, as shown in row bc03 of Figure 15, the number of items available for shipment for product code "SHO0010103" is calculated as current inventory "45" + undelivered orders "50" - unshipped orders "10". Therefore, column 3170 in Figure 18 displays "85".
[0057] The reception unit 102c receives input of the confirmed reserved quantity per product code in column 3140 of the breakdown input screen 3100, and registers the entered confirmed reserved quantity in the breakdown data 106bb shown in Figure 19. Figure 19 is a diagram showing an example of the breakdown data 106bb according to the embodiment. Note that the confirmed reserved quantity per product code is another example of the second quantity. That is, the reception unit receives input of the second quantity.
[0058] As shown in Figure 19, the breakdown data 106bb contains the confirmed reserved quantity for each product code for the record with customer code "TOK001". Note that the product code data 106ba is not updated during the breakdown input process.
[0059] [3-5. Order Transfer Processing] Then, when the order management device 100 receives an order from a customer based on sales status, inventory levels, etc., it executes an order transfer process. During the order transfer process, the display unit 102b displays the order input screen 4100 shown in Figure 20. Figure 20 is a diagram showing an example of the order input screen 4100 according to the embodiment. As shown in Figure 20, the order input screen 4100 has an order number field 4150, an order date and delivery date input field 4169, a customer code input field 4161, a warehouse code input field 4121, and a delivery destination code input field 4163. The order number 4150 shown in Figure 20 is information that uniquely identifies an order from a customer and is automatically assigned during the order transfer process.
[0060] Furthermore, by selecting, for example, row 4101 on the order entry screen 4100, an order details entry screen 4200, as shown in Figure 21, may be displayed. Figure 21 is a diagram showing an example of an order details entry screen 4200 according to the embodiment. Note that, on the order details entry screen 4200, if, for example, the number of orders entered 4281 exceeds the number of confirmed orders 4241 that has been displayed in advance, the display unit 102b may output an error message 4299 to the order details entry screen 4200.
[0061] The reception unit 102c updates the order header 106be and order detail data 106bf shown in Figures 22 and 23 using the entered order number if the number of orders entered on the order entry screen 4100 or the order detail entry screen 4200 is less than or equal to the confirmed reserved number. Figure 22 is a diagram showing an example of the order header 106be according to the embodiment, and Figure 23 is a diagram showing an example of the order detail data 106bf according to the embodiment. The order detail data 106bf registers the number of orders for each product, the sales unit price, the sales amount, the consumption tax amount, and the sales amount including tax, which are entered on the order entry screen 4100 or the order detail entry screen 4200. The order header 106be is entered with the sales amount, consumption tax amount, and sales amount including tax, associated with the order number, order date, delivery date, customer code, warehouse code, and delivery destination code entered on the order entry screen 4100.
[0062] The order number column contains the order number assigned by the reception unit 102c. The row number column of the order details data 106bf contains the row number shown on the order details input screen 4200. The columns for order date, delivery date, customer code, warehouse code, and delivery destination code contain the information entered on the order input screen 4100. The columns for sales amount, consumption tax amount, and sales amount including tax display the total sales amount, consumption tax amount, and sales amount including tax for each product, calculated based on the sales unit price and consumption tax rate obtained from the product master 106aa shown in Figure 4, and the product code and order quantity entered on the order details input screen 4200 shown in Figure 21.
[0063] Furthermore, the reception unit 102c updates the product code data 106ba shown in Figure 24 and the breakdown data 106bb shown in Figure 25. Figure 24 is a diagram showing another example of the product code data 106ba according to the embodiment, and Figure 25 is a diagram showing another example of the breakdown data 106bb according to the embodiment. For example, for each product with product codes "SHO0010101", "SHO0010102", and "SHO0010103", the order quantities "5", "10", and "10" entered on the order entry screen 4100 shown in Figure 20 are added to the order transfer quantity column bb2, respectively.
[0064] Furthermore, the reception unit 102c updates the number of unshipped orders in the inventory data 106bc using the entered order quantity, as shown in Figure 26. Figure 26 is a diagram showing another example of the inventory data 106bc according to the embodiment. For example, for the product with product code "SHO0010101", the number of unshipped orders "10" shown in column bc2 of the inventory data 106bc in Figure 15 is added to the number of transferred orders "5" shown in column bb2 of the breakdown data 106bb in Figure 25. As a result of this process, the number of unshipped orders is updated, and the updated order details are reflected in the number of available shipments displayed in Figure 18. This allows the user to see the number of unshipped orders in addition to the current inventory, thereby reducing lost opportunities.
[0065] [3-6. Shipping Update Processing] Furthermore, when the shipment of goods corresponding to the number of orders is completed, the order management device 100 executes the shipment reflection process shown in Figure 1. In the shipment reflection process, the receiving unit 102c may subtract the number of orders from the number of unshipped orders in the inventory data 106bc, as shown in Figure 27, and may also subtract the number of orders from the current inventory quantity in the inventory data 106bc. Figure 27 shows another example of the inventory data 106bc according to this embodiment.
[0066] For example, in Figure 27, the current inventory quantity of "95" shown in column bc1 for product code "SHO0010101" is the number obtained by subtracting the number of transferred orders, "5" shown in column bb2 of Figure 25, from the current inventory quantity of "100" shown in column bc1 of Figure 26. Also, the number of unshipped orders, "10" shown in column bc2 for product code "SHO0010101" is the number obtained by subtracting the number of transferred orders, "5" shown in column bb3 of Figure 25, from the number of unshipped orders, "20" shown in column bc2 of Figure 26.
[0067] [3-7. Variations] Furthermore, the "Number of items that can be shipped" displayed on the breakdown input screen 3100 shown in Figure 18 may also reflect the number of items that can be confirmed on a per-product basis, as shown in Figure 28. Figure 28 is a diagram showing another example of the breakdown data 106bb according to the embodiment. In Figure 28, in addition to the number of confirmed orders for customer A with customer code "TOK001", the number of confirmed orders for customer B with customer code "TOK002" is also registered.
[0068] In this case, the number of items available for shipment displayed on the separate breakdown input screen 3900 shown in Figure 29 is the number after subtracting the number of items that can be confirmed. Figure 29 is a diagram showing an example of the separate breakdown input screen 3900 according to the embodiment. The number of items available for shipment shown in column 3970 of Figure 29 is the number obtained by further subtracting the number of items that can be confirmed and secured shown in column bb1 of Figure 28 from the number of items available for shipment shown in column 3190 of Figure 18. For example, the number of items available for shipment for product code "SHO0010103" is the number obtained by subtracting the number of items that can be confirmed and secured for customer code "TOK001" and the number of items that can be confirmed and secured for customer code "TOK002" shown in Figure 28 from the number of items available for shipment "85" shown in Figure 18.
[0069] In Figure 29, for example, the confirmed reserved quantity "70" entered for product code "SHO0010103" exceeds the available shipment quantity "5". In this case, the display unit 102b may display error message 3999 on the breakdown input screen 3900, as shown in Figure 29. Note that the available shipment quantity per product code is just one example of the third quantity. That is, the determination unit may sum the quantities entered for each product and determine whether or not it exceeds the third quantity, which is the available shipment quantity for each product.
[0070] [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 enabling contributions to SDGs Goals 8 and 9.
[0071] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.
[0072] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.
[0073] [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.
[0074] 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.
[0075] 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.
[0076] Furthermore, with respect to the order management device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown. For example, the acquisition unit 102a and the receiving unit 102c shown in Figure 2 may be executed by a single processing unit, and the process of registering information regarding the confirmed number of orders and the process of acquiring information regarding orders corresponding to the confirmed number of orders may be executed by separate processing units.
[0077] Furthermore, for example, the processing functions of the order management device 100, particularly those performed in the control unit, may be implemented entirely or partially 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 order management device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.
[0078] Furthermore, this computer program may be stored on an application program server connected to the order management device 100 via any network, and it is possible to download all or part of it as needed.
[0079] 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.
[0080] 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.
[0081] The various databases stored in the memory unit are 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.
[0082] Furthermore, the order management device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the order management device 100 may be implemented by installing software (including programs or data, etc.) that realizes the processing described in this embodiment on the device.
[0083] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]
[0084] This invention is useful in industries such as apparel and general merchandise manufacturing, where product inventory is managed in two stages: by product number and by individual product. [Explanation of Symbols]
[0085] 1. Order Management System 100 Order Management System 102 Control Unit 102a Acquisition Department 102b Display section 102c Reception Desk 102d Judgment section 104 Communication Interface Section 106 Storage section 106a Master Storage Unit 106aa Part Number Master 106ab Customer Master 106ac Warehouse Master 106ad Delivery Destination Master 106b Data storage unit 106ba Data by Part Number 106bb Breakdown Data 106bc Inventory Data 106bd Inventory Details Data 106be Order Header 106bf Order Details Data 108 Input / Output Interface Section 112 mice 112-key keyboard 112 Input device 114 Output device 114 monitors 200 terminal devices 300 Networks 1000 Reserve Input Screen 1100 Temporary Input Screen 1200 input screens 2000 Purchase Order 3100,3900 Breakdown input screen 4100 Order entry screen 4200 Order Details Input Screen
Claims
1. An order management device comprising a storage unit and a control unit for managing orders for product numbers associated with multiple products, The control unit, An acquisition unit that acquires a first quantity by part number, associated with multiple customers, A display unit that displays multiple first quantities in association with each of the multiple order sources, in units of the product number, A receiving unit that receives input for a second quantity to be allocated to the first quantity for each of the aforementioned order sources, A determination unit calculates the total quantity of the second quantity associated with multiple order sources and determines whether the calculated total quantity exceeds the third quantity. Having, Order management system.
2. The receiving unit receives the input of the second quantity in units of the product number. The determination unit determines whether the total quantity exceeds the third quantity, which is the number of units that can be shipped per product number. The order management device according to claim 1.
3. The reception unit receives the input of the second quantity in units of products associated with the product number. The determination unit sums the quantities entered for each product unit and determines whether the sum exceeds the third quantity, which is the number of units of the product that can be shipped. The order management device according to claim 1.
4. An order management method performed by an order management device comprising a storage unit and a control unit, The control unit, Steps include obtaining the first quantity by part number, which is associated with multiple customer orders, The steps include: displaying the multiple first quantities in association with each of the multiple order sources, and displaying them in units of the product number; For each of the aforementioned order sources, the step of receiving input for a second quantity to be allocated to the first quantity, The steps include: calculating the total quantity of the second quantity associated with multiple order sources, and determining whether the calculated total quantity exceeds the third quantity; An order management method characterized by performing the following actions.
5. An order management program to be executed on an order management device comprising a memory unit and a control unit, The control unit, Steps include obtaining the first quantity by part number, which is associated with multiple customer orders, The steps include: displaying the multiple first quantities in units of the product number, in association with each of the multiple order sources; For each of the aforementioned order sources, the step of receiving input for a second quantity to be allocated to the first quantity, The steps include: calculating the total quantity of the second quantity associated with multiple order sources, and determining whether the calculated total quantity exceeds the third quantity; An order management program characterized by its ability to execute certain actions.