Shipping instruction support device, shipping instruction support method, and shipping instruction support program

Abstract

To provide a shipment instruction support device or the like, which can aggregate information by combination of destination (e.g., shop or distribution center) and delivery date, and issue shipment instructions while checking only the total quantity, thereby realizing the efficiency and speed of shipment instruction work.SOLUTION: The present embodiment includes: (1) referring to an order table to extract order records that satisfy extraction conditions that shipment date is a shipment date designated by an operator on a shipment instruction input screen, storage warehouse is a warehouse designated by the operator on the shipment instruction input screen, allocated quantity is other than zero, and shipment instruction completion status classification is incomplete; (2) grouping the extracted order records by combination of destination and delivery date, and calculating the total allocated quantity and the number of different order numbers for each group; and (3) displaying, for each group, on the shipment instruction input screen, the combination of destination, shipment date, delivery date, quantity, and total as the number of order slips and the total as shipment instruction quantity.SELECTED DRAWING: Figure 5

Description

[Technical Field]

[0001] The present invention relates to a shipping instruction support device, a shipping instruction support method, and a shipping instruction support program. [Background technology]

[0002] Patent Document 1 discloses an information processing system that receives shipping instruction data, performs conversion processing based on the shipping instruction data, executes allocation processing, and creates picking instruction data. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent Publication No. 2021-39667 Summary of the Invention [Problem to be solved by the invention]

[0004] Among wholesalers that mainly supply products to mass retailers, companies with a large volume of goods and a large number of products handled may have the department that controls logistics handle shipping instructions for the entire company in bulk, in response to the large amount of order information entered at sales offices around the country and imported through EDI (Electronic Data Interchange) transactions with mass retailers.In order to increase the number of shipments per day (increase sales) and shorten delivery times, it is necessary to issue shipping instructions efficiently and quickly, and increase the number of items processed per day.

[0005] However, when issuing shipping instructions in the logistics control department, it is necessary to check for errors in the destination (for example, store or distribution center) and delivery date information, so shipping instructions must be issued for each item in the order unit. This process is an obstacle to issuing shipping instructions efficiently.

[0006] Therefore, when the sales office inputs order information, in addition to confirming the destination and delivery date, it also allocates inventory, and when EDI transactions are conducted, the general rule is to ship according to the other party's order. This led to the realization that as long as the inventory was allocated, there was no need to issue shipping instructions for each item.

[0007] The present invention has been made in consideration of the above, and aims to provide a shipping instruction support device, shipping instruction support method, and shipping instruction support program that can aggregate information in units of combinations of destination (e.g., store or distribution center) and delivery date, and issue shipping instructions while checking only the total quantity, thereby achieving efficiency and speed in shipping instruction work. [Means for solving the problem]

[0008] In order to solve the above-mentioned problems and achieve the object, the shipping instruction support device of the present invention is characterized by comprising: an extraction unit that references a memory area that stores, in association with each other, order identification information, product identification information of the ordered product, a delivery destination of the ordered product, a storage warehouse of the ordered product, a shipping date of the ordered product, a delivery date of the ordered product, an allocation quantity of the ordered product, and a classification that indicates whether the shipping instruction for the ordered product has been completed, and extracts information that satisfies the extraction conditions that the shipping date is a specified date, the storage warehouse is a specified warehouse, the allocation quantity is other than zero, and the classification indicates that the shipping instruction has not been completed; a calculation unit that groups the information extracted by the extraction unit by combination of the delivery destination and the delivery date, and calculates, for each group, the total of the allocation quantity and the number of different order identification information; and an output processing unit that outputs, for each group, a combination of the delivery destination, the shipping date, the delivery date, the quantity, and the total, with the number being the number of order slips and the total being the shipping instruction quantity.

[0009] In addition, in the shipping instruction support device of the present invention, the memory area may be records in an order table for managing information regarding orders, and the extraction unit may refer to the order table to extract the records that satisfy the extraction conditions, and store the combination of the order identification information, the destination, the shipping date, the delivery date, the storage warehouse, the product identification information, and the allocation quantity contained in the extracted records as the shipping instruction quantity in a first table, the calculation unit may group the records in the first table by combination of the destination and the delivery date, calculate the total of the shipping instruction quantity and the number for each group, and store the combination of the destination, the shipping date, the delivery date, the number, and the total for each group in a second table as the number of order slips, and the output processing unit may display the records in the second table on a shipping instruction input screen.

[0010] In addition, the shipping instruction support device of the present invention may further include a shipping instruction creation unit that creates a shipping instruction table based on the first table, which includes shipping instruction identification information assigned to each group, the destination, the shipping date, the delivery date, the storage warehouse, the product identification information, the shipping instruction quantity, and the order identification information.

[0011] In addition, in the shipping instruction support device of the present invention, the shipping instruction input screen may be capable of specifying that each displayed record is not subject to shipping instructions, and the shipping instruction creation unit may create the shipping instruction table by excluding the records that fall into the group corresponding to the records that have been specified as not subject on the shipping instruction input screen.

[0012] In addition, in the shipping instruction support device of the present invention, the shipping instruction creation unit may update the classification included in the record included in the order table, which is linked to the order identification information included in the record in the shipping instruction table, to one indicating that the shipping instruction has been completed.

[0013] In addition, the shipping instruction support device of the present invention may further include a picking list creation unit that creates a picking list containing the product identification information and the shipping instruction quantity for each combination of the destination and the delivery date based on the shipping instruction table.

[0014] In the shipping instruction support device according to the present invention, the merchandise may be an apparel product.

[0015] In the shipping instruction support device according to the present invention, the destination may be a store or a distribution center.

[0016] Furthermore, the shipping instruction support method of the present invention is characterized by including: an extraction step in which an extraction unit refers to a memory area that stores, in association with each other, order identification information, product identification information of the ordered product, a delivery destination of the ordered product, a storage warehouse of the ordered product, a shipping date of the ordered product, a delivery date of the ordered product, an allocation quantity of the ordered product, and a classification indicating whether the shipping instruction for the ordered product has been completed, and extracts information that satisfies the extraction conditions that the shipping date is a predetermined date, the storage warehouse is a predetermined warehouse, the allocation quantity is other than zero, and the classification indicates that the shipping instruction has not been completed; a calculation step in which a calculation unit groups the information extracted in the extraction step by combination of the delivery destination and the delivery date, and calculates, for each group, the total of the allocation quantity and the number of different order identification information; and an output processing step in which an output processing unit outputs, for each group, a combination of the delivery destination, the shipping date, the delivery date, the quantity, and the total, the number as the number of order slips and the total as the shipping instruction quantity.

[0017] Furthermore, the shipping instruction support program of the present invention causes an information processing device to function as: an extraction means that references a memory area that stores, in association with each other, order identification information, product identification information of the ordered product, a delivery destination of the ordered product, a storage warehouse for the ordered product, a shipping date of the ordered product, a delivery date for the ordered product, an allocation quantity of the ordered product, and a classification indicating whether the shipping instruction for the ordered product has been completed, and extracts information that satisfies the extraction conditions that the shipping date is a specified date, the storage warehouse is a specified warehouse, the allocation quantity is other than zero, and the classification indicates that the shipping instruction has not been completed; a calculation means that groups the information extracted by the extraction means by combination of the delivery destination and the delivery date, and calculates, for each group, the total of the allocation quantity and the number of different order identification information; and an output processing means that, for each group, outputs a combination of the delivery destination, the shipping date, the delivery date, the quantity, and the total, with the number being the number of order slips and the total being the shipping instruction quantity. [Effects of the Invention]

[0018] The present invention has the effect of aggregating information by combination of destination (e.g., store or distribution center) and delivery date, making it possible to give shipping instructions while checking only the total quantity, thereby achieving efficiency and speed in shipping instruction work. [Brief explanation of the drawings]

[0019] [Figure 1] FIG. 1 is a diagram showing an example of an outline of this embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of the configuration of the task assistance device according to this embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of the order data. [Figure 4] FIG. 4 is a diagram showing an example of a shipping instruction input screen in which extraction conditions have been specified and order data extracted using the specified extraction conditions. [Figure 5]FIG. 5 shows an example of breakdown data, display data, a shipping instruction input screen on which the display data is displayed, and a breakdown inquiry screen. [Figure 6] FIG. 6 is a diagram showing an example of a shipping instruction input screen on which display data is displayed, shipping instruction data, and updated order data. DETAILED DESCRIPTION OF THE INVENTION

[0020] Hereinafter, embodiments of a shipping instruction support device, a shipping instruction support method, and a shipping instruction support program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to these embodiments.

[0021] [1. Overview] An overview of this embodiment will be described with reference to Figure 1. As shown in <Normal Shipping Instruction Image> in Figure 1, shipping instructions are usually given by checking the quantity for each product, so the quantity is displayed for each combination of destination, delivery date, and product for the specified shipping date and warehouse.

[0022] On the other hand, as shown in the "Shipping Instruction Image of this Embodiment" in Figure 1, in this embodiment, shipping instructions are issued by checking only the total quantity. Therefore, for the specified shipping date and warehouse, the quantity on the invoice and the total quantity of each item are displayed for each combination of destination and delivery date. In addition, the quantity of each item can be confirmed by checking the details. Furthermore, information with the "Pending" checkbox checked can be excluded from shipping instructions. Since the units of measurement are uniform, even if multiple items are mixed, checking only the total quantity poses no problem at the time of issuing shipping instructions. Furthermore, there are cases where the relationship with other instructions is checked during the instruction process, and being able to check the details of the aggregated rows allows for detailed responses. Furthermore, the details of the items to be shipped can be confirmed on the picking list output after the shipping instruction is issued.

[0023] According to this embodiment, it is possible to improve the efficiency and speed of shipping instruction work. In particular, in shipping work for mass retailers where time is of the essence, it is possible to issue shipping instructions immediately after receiving an order via EDI, which is expected to have the effect of shortening delivery times.

[0024] [2. Configuration] An example of the configuration of a business support device 100 according to this embodiment (including the shipping instruction support device of the present invention) will be described with reference to Fig. 2 etc. Fig. 2 is a block diagram showing an example of the configuration of the shipping instruction support device.

[0025] The business support device 100 is constructed based on a commercially available desktop personal computer. Note that the business support device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may also be constructed based on a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

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

[0027] The communication interface unit 104 communicably connects the business assistance device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the business assistance device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the memory unit 106 may be stored in the server 200, for example.

[0028] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to achieve a pointing device function. 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 the mouse 112.

[0029] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc.

[0030] The memory unit 106 stores order data 106a (corresponding to the order table of the present invention), breakdown data 106b (corresponding to the first table of the present invention), display data 106c (corresponding to the second table of the present invention), and shipping instruction data 106d (corresponding to the shipping instruction table of the present invention), etc.

[0031] 3, 4, and 6 show examples of information stored in the order data 106a. The order data 106a is used to manage information related to orders. As shown in FIGS. 3, 4, and 6, the order data 106a stores information such as the order receiving establishment, order identification information (e.g., order number, etc.), line number, destination (e.g., store or distribution center, etc.), shipping date, delivery date, storage warehouse, product identification information (e.g., product code or product name assigned to a product such as apparel), order quantity, allocation quantity (e.g., allocation number, etc.), and shipping instruction completion status classification indicating whether the shipping instruction has been completed (e.g., "Completed" if the shipping instruction has been completed, "Incomplete" if the shipping instruction has not been completed, etc.). Note that the order data 106a shown in FIG. 3 is the status entered by each sales office, the order data 106a shown in FIG. 4 is the status extracted according to predetermined extraction conditions, and the order data 106a shown in FIG. 6 is the status after the shipping instruction completion status classification has been updated after the invoice has been registered.

[0032] An example of information stored in the breakdown data 106b is shown in Figure 5. The breakdown data 106b is intended to hold information related to breakdown inquiries, which will be described later. As shown in Figure 5, the breakdown data 106b stores the order-receiving business establishment, order identification information, line number, destination, shipping date, delivery date, storage warehouse, product identification information, and shipping instruction quantity.

[0033] An example of information stored in the display data 106c is shown in Fig. 5. The display data 106c is used to manage information to be displayed on a shipping instruction input screen, etc., which will be described later. As shown in Fig. 5, the display data 106c stores the destination, shipping date, delivery date, storage warehouse, number of order slips, total number of shipping instructions, etc.

[0034] An example of information stored in the shipping instruction data 106d is shown in Figure 6. The shipping instruction data 106d is data related to shipping instructions and is used to manage data that is the basis for creating a picking list. As shown in Figure 6, the shipping instruction data 106d stores the storage warehouse, shipping instruction identification information (e.g., shipping instruction number, etc.), line number, destination, shipping date, delivery date, product identification information, shipping instruction quantity, order identification information, line number, etc.

[0035] 2, the control unit 102 is a CPU or the like that performs overall control of the business support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.

[0036] The control unit 102 conceptually includes a shipping instruction input unit 102a, a picking list creation unit 102b, etc. The shipping instruction input unit 102a includes an extraction unit 102a1, a calculation unit 102a2, an output processing unit 102a3, and a shipping instruction creation unit 102a4, etc.

[0037] The shipping instruction input unit 102a displays a shipping instruction input screen MA (see FIGS. 4, 5, and 6) on the monitor 114. As shown in FIG. 4, the shipping instruction screen MA is mainly composed of: (1) an area MA1 for inputting extraction conditions; (2) an area MA2 for displaying the extraction results (specifically, information stored in the display data 106c); (3) an area MA3 indicating that the function key F6 on the keyboard 112 functions to display the extraction results in the area MA2; (4) an area MA4 indicating that the function key F7 on the keyboard 112 functions to instruct the display of a breakdown inquiry screen MB (described later); (5) an area MA5 indicating that the function key F10 on the keyboard 112 functions to register a slip, create shipping instruction data 106d, and update the order data 106a; and (6) an area MA6 indicating that the function key F12 on the keyboard 112 functions to terminate the shipping instruction input screen MA.

[0038] When the function key F6 on the keyboard 112 is pressed while the shipping instruction input screen MA is displayed, the extraction unit 102a1 extracts from the order data 106a order records that satisfy the extraction conditions set in the area MA1, have an allocation quantity other than zero, and have a shipping instruction completion status classification of "uncompleted," and stores the necessary information contained in the extracted order records in the breakdown data 106b. The allocation quantity contained in the order record is stored as the shipping instruction quantity.

[0039] The calculation unit 102a2 groups (aggregates) each breakdown record in the breakdown data 106b by combination of destination and delivery date, calculates the total shipping instruction quantity and the number of different order identification information for each group, and stores the combination of destination, shipping date, delivery date, quantity, and total for each group in the display data 106c. The quantity is stored as the number of order slips.

[0040] The output processing unit 102a3 displays the display record in the display data 106c in area MA2 of the shipping instruction input screen MA. The output processing unit 102a3 displays the line number in area MA21, the destination in area MA22, the shipping date in area MA23, the delivery date in area MA24, the number of order slips in area MA25, and the total number in area MA26.

[0041] When the function key F7 on the keyboard 112 is pressed while a row is specified in the area MA2, the output processing unit 102a3 identifies from the breakdown data 106b the breakdown record that is the source of the information displayed in the specified row, and displays the order identification information, row number, product identification information, and shipping instruction quantity contained in the identified breakdown record on the breakdown inquiry screen MB, together with the delivery destination and delivery date displayed in the specified row.

[0042] When function key F10 on keyboard 112 is pressed while shipping instruction input screen MA is displayed, shipping instruction creation unit 102a4 creates shipping instruction data 106d based on breakdown data 106b, excluding rows with check marks in area MA27, including the storage warehouse, shipping instruction identification information assigned by group, row number, destination, shipping date, delivery date, product identification information, shipping instruction quantity, order identification information, and row number. In addition, shipping instruction creation unit 102a4 updates the status of the shipping instruction completion status classification included in the record in order data 106a linked to the order identification information included in the record in shipping instruction data 106d to "completed."

[0043] The picking list creation unit 102b creates a picking list (for example, PDF data) containing product identification information and shipping instruction quantities for each combination of destination and delivery date based on the shipping instruction data 106d in response to an instruction from an operator.

[0044] [3. Specific examples of processing] A specific example of the processing executed by the task assistance device 100 will be described in detail with reference to FIGS. 4 to 6 along with an example of the flow of a task performed using the task assistance device 100. FIG.

[0045] [3-1. The operator specifies the extraction conditions on the shipping instruction input screen] First, the operator enters the shipping date "2022 / 12 / 1" and the warehouse "001" (logistics warehouse) in area MA1 of the shipping instruction input screen MA, and presses the function key F6 on the keyboard 112 (see FIG. 4).

[0046] [Extraction of order data using the extraction conditions in 3-2.3-1] The extraction unit 102a1 then extracts from the order data 106a order records whose shipping date is "2022 / 12 / 1," whose warehouse is "001" (logistics warehouse), whose "allocation quantity" is not "0," and whose shipping instruction completion status is "incomplete" (see FIG. 4). In this explanation, of the order records (1) to (13) in the order data 106a in FIG. 3, order records (1) to (3), (6) to (9), (11), and (12) are extracted. Note that when "allocation quantity = 0," there is no inventory in the corresponding warehouse and shipping instructions cannot be issued, so the order is not extracted. Specifically, order records (4) and (5) in the order data 106a in FIG. 3 are not extracted because they correspond to "allocation quantity = 0." Furthermore, order record (10) in the order data 106a in FIG. 3 is not extracted because its shipping date is "2022 / 12 / 2." Furthermore, the order record (13) in the order data 106a in FIG. 3 is not extracted because the warehouse is on "2nd floor."

[0047] [Set the allocation quantity of the order data in 3-3.3-2 to the specified quantity] Next, the extraction unit 102a1 stores the combination of the order receiving business, order number, line number, destination, shipping date, delivery date, warehouse, product, and allocation quantity contained in the extracted order record in the breakdown data 106b, with the allocation quantity being the instructed quantity (see Figure 5).

[0048] [3-4.3-3 breakdown data is aggregated by the same destination > shipping date > delivery date unit, and the number of order slips and the specified quantity are tallied. This information is displayed on the screen.] Next, the calculation unit 102a2 aggregates each breakdown record in the breakdown data 106b in the order of the same destination, the same shipping date, and the same delivery date, and calculates the total of the specified quantity and the number of units with different order numbers for each aggregation unit, and stores the combination of the destination, shipping date, delivery date, warehouse, calculated number, and calculated total for each aggregation unit in the display data 106c, with the number of units as the number of slips and the total as the total number (see Figure 5). In this description, the display record in the first line from the top in the display data 106c is generated from the breakdown records (1) to (3) in the breakdown data 106b, the display record in the second line from the top in the display data 106c is generated from the breakdown records (6) and (7) in the breakdown data 106b, the display record in the third line from the top in the display data 106c is generated from the breakdown record (8) in the breakdown data 106b, the display record in the fourth line from the top in the display data 106c is generated from the breakdown record (9) in the breakdown data 106b, and the display record in the fifth line from the top in the display data 106c is generated from the breakdown records (11) and (12) in the breakdown data 106b.

[0049] Next, the output processing unit 102a3 displays each display record in the display data 106c in the area MA2 of the shipping instruction input screen MA (see FIG. 5).

[0050] The operator then checks the information displayed in area MA2 against the chain store slip, delivery details, order summary sheet, etc. that he or she has on hand (see FIG. 5).

[0051] If the operator wishes to check more detailed information about the information displayed in area MA2, he or she specifies the row in area MA2 that the operator wishes to check and presses function key F7 on keyboard 112. This causes output processing unit 102a3 to display a breakdown inquiry screen MB based on the breakdown record that is the source of the information displayed in the specified row (see FIG. 5). Specifically, when row number "1" in area MA2 is specified, based on the breakdown records (1) to (3) that are the source of the information displayed in that row, the combination of invoice number "JH101", row number "1", product "Product X", and specified quantity "10", the combination of invoice number "JH101", row number "2", product "Product Y", and specified quantity "20", and the combination of invoice number "JH102", row number "1", product "Product Z", and specified quantity "5", along with the destination "Company A" and delivery date "2022 / 12 / 3", are displayed on the breakdown inquiry screen MB (see Figure 5). Furthermore, when the row with row number "4" in area MA2 is specified, based on the breakdown record (9) that is the source of the information displayed in that row, the combination of document number "JH212", row number "1", product "Product Y", and specified quantity "10" is displayed on the breakdown inquiry screen MB along with the destination "Company C" and delivery date "2022 / 12 / 4" (see Figure 5).

[0052] [3-5. If, after checking against the slips and documents on hand, you determine that Company C's portion is not subject to shipping instructions, turn on the hold check. In this state, register the slip.] Next, if the operator compares the information displayed in area MA2 with the chain store invoice, delivery details, order summary sheet, etc. on hand and decides that the information displayed in row number "4" in area MA2 is not subject to shipping instructions, the operator turns on the hold check in area MA27 included in the row with row number "4" and presses function key F10 on keyboard 112 (see Figure 6).

[0053] Then, the shipping instruction creation unit 102a4 creates shipping instruction data 106d based on the breakdown records in the breakdown data 106b, excluding the breakdown record corresponding to the information displayed in row number "4" for which the hold check is ON (see FIG. 6). In this description, shipping instruction records (1) to (3) in the shipping instruction data 106d are created from breakdown records (1) to (3) that were the source of the information displayed in row number "1" in area MA2. Also, shipping instruction records (6) and (7) in the shipping instruction data 106d are created from breakdown records (6) and (7) that were the source of the information displayed in row number "2" in area MA2. Also, shipping instruction record (8) in the shipping instruction data 106d is created from breakdown record (8) that was the source of the information displayed in row number "3" in area MA2. In addition, the shipping instruction records (11) and (12) in the shipping instruction data 106d are created from the breakdown records (11) and (12) that are the source of the information displayed on the line with line number "5" in area MA2.

[0054] Furthermore, the shipping instruction preparation unit 102a4 updates the status of the shipping instruction completion status category included in the corresponding order record in the order data 106a to "completed" (see FIG. 6).

[0055] In this example, the order record (1) in the order data 106a is linked to the breakdown record (1) in the breakdown data 106b and corresponds to the shipping instruction record (1) in the shipping instruction data 106d, so the status of the shipping instruction completion status category included in the order record is updated from "incomplete" to "completed." Also, the order record (2) in the order data 106a is linked to the breakdown record (2) in the breakdown data 106b and corresponds to the shipping instruction record (2) in the shipping instruction data 106d, so the status of the shipping instruction completion status category included in the order record is updated from "incomplete" to "completed." Also, the order record (3) in the order data 106a is linked to the breakdown record (3) in the breakdown data 106b and corresponds to the shipping instruction record (3) in the shipping instruction data 106d, so the status of the shipping instruction completion status category included in the order record is updated from "incomplete" to "completed."

[0056] Furthermore, since the order record (6) in the order data 106a is linked to the breakdown record (6) in the breakdown data 106b and corresponds to the shipping instruction record (6) in the shipping instruction data 106d, the status of the shipping instruction completion status category included in the order record is updated from "incomplete" to "completed." Furthermore, the order record (7) in the order data 106a is linked to the breakdown record (7) in the breakdown data 106b and corresponds to the shipping instruction record (7) in the shipping instruction data 106d, the status of the shipping instruction completion status category included in the order record is updated from "incomplete" to "completed." Furthermore, the order record (8) in the order data 106a is linked to the breakdown record (8) in the breakdown data 106b and corresponds to the shipping instruction record (8) in the shipping instruction data 106d, the status of the shipping instruction completion status category included in the order record is updated from "incomplete" to "completed."

[0057] Furthermore, since the order record (11) in the order data 106a is linked to the breakdown record (11) in the breakdown data 106b and corresponds to the shipping instruction record (11) in the shipping instruction data 106d, the status of the shipping instruction completion status classification included in the order record is updated from "incomplete" to "completed." Furthermore, the order record (12) in the order data 106a is linked to the breakdown record (12) in the breakdown data 106b and corresponds to the shipping instruction record (12) in the shipping instruction data 106d, the status of the shipping instruction completion status classification included in the order record is updated from "incomplete" to "completed."

[0058] Next, the operator issues an instruction to create a picking list. In response, the picking list creation unit 102b creates a picking list that lists products and shipping instruction quantities for each combination of destination and delivery date from the shipping instruction data 106d (see FIG. 6). In this example, picking lists P1 to P4 are created.

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

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

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

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

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

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

[0065] Furthermore, with regard to the task support device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0066] For example, all or any part of the processing functions of the business support device 100, particularly the processing functions performed by the control unit, 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 business support device 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

[0067] This computer program may be stored in an application program server connected to the business support device 100 via any network, and all or part of it may be downloaded as needed.

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

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

[0070] The various databases stored in the memory unit 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.

[0071] The business support 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 to which any peripheral device is connected. The business support device 100 may be realized by installing software (including programs, data, etc.) that causes the device to perform the processes described in this embodiment.

[0072] 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 functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0073] The present invention is useful in the wholesale industry, manufacturing industry, and the like. [Explanation of symbols]

[0074] 100 Business support equipment 102 Control section 102a Shipping instruction input section 102a1 Extraction part 102a2 Calculation part 102a3 Output processing section 102a4 Shipping Instruction Preparation Department 102b Picking List Creation Department 104 Communication interface unit 106 Storage section 106a Order Data 106b Breakdown Data 106c Display data 106d Shipping instruction data 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. an extraction unit that refers to a storage area that stores, in association with each other, order identification information, product identification information of the ordered product, a delivery destination of the ordered product, a storage warehouse of the ordered product, a shipping date of the ordered product, a delivery date of the ordered product, an allocated quantity of the ordered product, and a classification indicating whether or not a shipping instruction for the ordered product has been completed, and extracts information that satisfies the extraction conditions that the shipping date is a specified date, the storage warehouse is a specified warehouse, the allocated quantity is other than zero, and the classification indicates that the shipping instruction has not been completed; a calculation unit that groups the information extracted by the extraction unit according to the combination of the delivery destination and the delivery date, and calculates the total of the allocation quantity and the number of different pieces of order identification information for each group; an output processing unit that outputs, for each group, a combination of the destination, the shipping date, the delivery date, the quantity, and the total, the quantity as the number of order slips, and the total as a shipping instruction quantity; A shipping instruction support device comprising:

2. The storage area is a record in an order table for managing information about orders, the extraction unit refers to the order table, extracts the record that satisfies the extraction condition, and stores a combination of the order identification information, the destination, the shipping date, the delivery date, the storage warehouse, the product identification information, and the allocated quantity included in the extracted record in a first table, with the allocated quantity being the shipping instruction quantity; the calculation unit groups the records in the first table by combination of the destination and the delivery date, calculates the total of the shipping instruction quantity and the number of units for each group, and stores the combination of the destination, the shipping date, the delivery date, the number of units, and the total for each group in a second table as the number of order slips; the output processing unit displays the records in the second table on a shipping instruction input screen; 2. The shipping instruction support device according to claim 1, wherein:

3. a shipping instruction creation unit that creates a shipping instruction table based on the first table, the shipping instruction identification information assigned to each group, the destination, the shipping date, the delivery date, the storage warehouse, the product identification information, the shipping instruction quantity, and the order identification information; 3. The shipping instruction support device according to claim 2, wherein:

4. the shipping instruction input screen allows a user to specify that each of the displayed records is not subject to shipping instructions, the shipping instruction creation unit creates the shipping instruction table by excluding the records that fall into the group corresponding to the records that are specified as excluded on the shipping instruction input screen; 4. The shipping instruction support device according to claim 3, wherein:

5. the shipping instruction creation unit updates the classification included in the record included in the order receipt table, which is linked to the order identification information included in the record in the shipping instruction table, to one indicating that the shipping instruction has been completed; 5. The shipping instruction support device according to claim 3 or 4, wherein:

6. a picking list creation unit that creates a picking list containing the commodity identification information and the shipping instruction quantity for each combination of the destination and the delivery date based on the shipping instruction table; 6. The shipping instruction support device according to claim 5,

7. The said goods are apparel goods; 7. The shipping instruction support device according to claim 6, wherein:

8. The destination is a store or distribution center; 8. The shipping instruction support device according to claim 7, wherein:

9. an extraction step in which the extraction unit refers to a storage area that stores, in association with each other, order identification information, product identification information of the ordered product, a delivery destination of the ordered product, a storage warehouse of the ordered product, a shipping date of the ordered product, a delivery date of the ordered product, an allocated quantity of the ordered product, and a classification indicating whether or not a shipping instruction for the ordered product has been completed, and extracts information that satisfies the extraction conditions that the shipping date is a predetermined date, the storage warehouse is a predetermined warehouse, the allocated quantity is other than zero, and the classification indicates that the shipping instruction has not been completed; a calculation step in which a calculation unit groups the information extracted in the extraction step by combination of the delivery destination and the delivery date, and calculates, for each group, the total allocation quantity and the number of different pieces of order identification information; an output processing step in which an output processing unit outputs, for each group, a combination of the destination, the shipping date, the delivery date, the quantity, and the total, with the quantity as the number of order slips and the total as a shipping instruction quantity; A shipping instruction support method comprising:

10. An information processing device an extraction means for referencing a storage area storing, in association with each other, order identification information, product identification information of the ordered product, a delivery destination of the ordered product, a storage warehouse of the ordered product, a shipping date of the ordered product, a delivery date of the ordered product, an allocated quantity of the ordered product, and a classification indicating whether or not a shipping instruction for the ordered product has been completed, and extracting information that satisfies the extraction conditions that the shipping date is a predetermined date, the storage warehouse is a predetermined warehouse, the allocated quantity is other than zero, and the classification indicates that the shipping instruction has not been completed; a calculation means for grouping the information extracted by the extraction means for each combination of the destination and the delivery date, and calculating the total of the allocation quantity and the number of different pieces of order identification information for each group; an output processing means for outputting, for each group, a combination of the destination, the shipping date, the delivery date, the number of items, and the total, with the number of items as the number of order slips and the total as the shipping instruction quantity; A shipping instruction support program that functions as a

Images