Commodity delivery management apparatus, commodity delivery management program, and commodity delivery management method

Abstract

To provide a commodity delivery management apparatus configured to automatically determine whether odd commodities the number of which is equal to or less than a packaging unit can be loaded together with other odd commodities, thereby improving efficiency of delivery operation, a commodity delivery management program, and a commodity delivery management method.SOLUTION: A commodity delivery management apparatus including a control unit is allowed to access a commodity number master, a consolidation type master, a consolidation unit master, a consolidation maximum value master, and an order master. The control unit includes: packaging number addition means which groups commodities having the same client CD, etc., in the order data, and adds the same packaging number; packaging statement creation means which refers to the commodity number master to create a packaging statement formed by sorting the commodities into commodities for unit packaging and commodities for loose packaging; and consolidation determination means which compares thickness, or the like, of the commodities for loose packaging with a consolidation maximum value stored in the consolidation maximum value master to determine whether the commodities can be loaded together.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to a product delivery management device, a product delivery management program, and a product delivery management method. [Background technology]

[0002] Conventionally, when an order is received for multiple products, each ordered product is packed separately, but when the number of ordered products is greater than or less than the packing unit, fractional packages may be required. If fractional packages were all shipped as one packing unit, costs would increase if the delivery was outsourced, so delivery personnel consider the product shape, etc., and determine whether fractional packages can be shipped together.

[0003] When a staff member uses their experience to pack odd-lot products, there is the problem that the work becomes dependent on the staff member, and since the shipping details are created after the packing work, it also poses the problem of it taking time before the products are shipped. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] JP 2019-028992 A Summary of the Invention [Problem to be solved by the invention]

[0005] In a delivery plan generation method for outputting a delivery sequence for picking up and delivering cargo between multiple base stations using multiple delivery vehicles, a technology is disclosed in which a delivery capacity used to determine whether or not mixed loading is possible for a delivery vehicle is set in advance, and a mixed loading capacity with an upper limit value used to determine whether or not mixed loading is possible for a delivery task is set in advance, and the mixed loading capacity of a delivery task with mixed loading added is set to the upper limit value of the mixed loading capacity (for example, see Patent Document 1). However, Patent Document 1 does not relate to technology for bundling odd-packaged products together, and there is a demand for a system that can consolidate the individual packages of products to be delivered when shipping the products, thereby reducing the costs and time required for delivery.

[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a product delivery management device, a product delivery management program, and a product delivery management method that, when delivering multiple items, have criteria for whether or not products that are packaged in fractional packages greater than or less than the packaging unit can be mixed, and automatically decide whether or not to mix them based on the criteria, thereby improving the efficiency of delivery operations. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, a product delivery management device according to the present invention is a product delivery management device having a control unit, and is capable of accessing a product number master that stores information including the number of packing units and mixed load type CD for each product, a mixed load type master that stores mixed load unit CD corresponding to the mixed load type CD, a mixed load unit master that stores mixed load units corresponding to the mixed load unit CD, a mixed load maximum value master that stores a maximum mixed load amount corresponding to the mixed load type CD, and order data that stores data including the order date, shipping date, customer CD, delivery destination CD, delivery company CD, and order quantity of the product, and the control unit is capable of accessing a product number master that stores information including the number of packing units and mixed load type CD for each product, a mixed load type master that stores mixed load unit CD corresponding to the mixed load unit CD, a mixed load maximum value master that stores a maximum mixed load amount corresponding to the mixed load type CD, and order data that stores data including the order date, shipping date, customer CD, delivery destination CD, delivery company CD, and order quantity of the product, and D. A packing number assignment means for grouping products with the same shipping date and assigning the same packing number; a packing detail creation means for creating a packing detail in which, by referring to the packing unit in the product number master, the ordered quantity for each ordered product is divided into products that will be packaged as unit packages and products that will be packaged as fractional packages; and a mixing determination means for, for products that have been packaged as fractional packages by the packing detail creation means, referring to the product number master, the mixed loading type master, the mixed loading unit master, and the packing detail, acquiring the thickness, quantity or weight of the product in the fractional package, and comparing the acquired thickness, quantity or weight of the product in the fractional package with the maximum mixed loading value stored in the maximum mixed loading value master to determine whether mixing is possible.

[0008] In addition, in the product delivery management device of the present invention, the mixing determination means obtains the total thickness, quantity or weight of products that have been packed as fractional packages and have the same mixing type CD among the products to which the packing number assignment means has assigned the same packing number, and compares the obtained total thickness, quantity or weight of the products in the fractional package with the maximum mixing value stored in the maximum mixing value master to determine whether mixing is possible.

[0009] The product delivery management device of the present invention includes a unit serial number assignment means for assigning unit serial numbers to each of the unit packages and fractional packages of a product group to which the packing detail creation means has assigned the same packing number, and the unit serial number assignment means assigns the same unit serial number to a product group of fractional packages whose total mixed loading amount is less than or equal to the maximum mixed loading amount and which the mixed loading determination means has determined can be mixed.

[0010] The product delivery management device of the present invention is equipped with a delivery detail creation means for creating a delivery detail for a group of products that have been assigned the same packing serial number, which clearly indicates the total number of packages, package serial number, delivery address, delivery name, product information, product number CD, product number thickness, product number size, quantity, and whether or not the package is mixed.

[0011] A product delivery management program according to the present invention is a product delivery management program to be executed by a product delivery management device having a control unit, the product delivery management device being capable of accessing a product number master storing information including the number of packing units and mixed load type CD for each product, a mixed load type master storing mixed load unit CD corresponding to the mixed load type CD, a mixed load unit master storing mixed load unit corresponding to the mixed load unit CD, a mixed load maximum value master storing a maximum mixed load amount corresponding to the mixed load type CD, and order data storing data including the order date, shipping date, customer CD, delivery destination CD, delivery company CD, and order quantity of the product, and the product delivery management program to be executed by the control unit is capable of accessing a product number master storing information including the number of packing units and mixed load type CD for each product, a mixed load type master storing mixed load unit CD corresponding to the mixed load type CD, a mixed load maximum value master storing a maximum mixed load amount corresponding to the mixed load type CD, and order data storing data including the order date, shipping date, customer CD, delivery destination CD, delivery company CD, and order quantity of the product, The method includes a packing number assignment step of grouping products having the same D, delivery company CD and shipping date and assigning the same packing number; a packing detail creation step of creating a packing detail in which, with reference to the packing unit in the product number master, a packing detail is created for each ordered product in which the ordered quantity is divided into products that will be packaged as a unit and products that will be packaged as fractional quantities; and a mixing determination step of, for products that have been packaged as fractional quantities by the packing detail creation means, with reference to the product number master, the mixed loading type master, the mixed loading unit master and the packing detail, obtaining a thickness, quantity or weight of the product in the fractional package, and comparing the obtained thickness, quantity or weight of the product in the fractional package with a maximum mixed loading value stored in the maximum mixed loading value master to determine whether mixing is possible.

[0012] A product delivery management method according to the present invention is a product delivery management method executed by a product delivery management device having a control unit, the product delivery management device being capable of accessing a product number master storing information including the number of packing units and mixed load type CD for each product, a mixed load type master storing a mixed load unit CD corresponding to the mixed load type CD, a mixed load unit master storing a mixed load unit corresponding to the mixed load unit CD, a mixed load maximum value master storing a maximum mixed load amount corresponding to the mixed load type CD, and order data storing data including the order date, shipping date, customer CD, delivery destination CD, delivery company CD, and order quantity of the product, and the product delivery management device being capable of accessing a product number master storing information including the number of packing units and mixed load type CD for each product, a mixed load type master storing a mixed load unit CD corresponding to the mixed load unit CD, a mixed load maximum value master storing a maximum mixed load amount corresponding to the mixed load type CD, and order data stored by the control unit. The method includes a packing number assignment step of grouping CDs and products with the same shipping date and assigning the same packing number; a packing detail creation step of creating a packing detail in which, with reference to the packing unit in the product number master, a packing detail is created for each ordered product in which the ordered quantity is divided into products that will be packaged as unit packages and products that will be packaged as fractional packages; and a mixing determination step of, for products that have been packaged as fractional packages by the packing detail creation means, with reference to the product number master, the mixed load type master, the mixed load unit master, and the packing detail, obtaining a thickness, quantity or weight of the product in the fractional package, and comparing the obtained thickness, quantity or weight of the product in the fractional package with a maximum mixed load value stored in the maximum mixed load master to determine whether mixing is possible. Effect of the Invention

[0013] According to the present invention, when delivering multiple items, criteria are set for whether or not products that are packaged in fractional packages larger than or smaller than the packaging unit can be mixed, and a decision can be automatically made based on the criteria as to whether or not to mix them together, thereby achieving the effect of making delivery operations more efficient. [Brief description of the drawings]

[0014] [Figure 1] FIG. 1 is a diagram showing an example of a configuration of a product delivery management device 100 according to the present embodiment. [Diagram 2] FIG. 2 is a flowchart showing an example of the process of the product delivery management device 100 in this embodiment. [Diagram 3]FIG. 3 is a diagram showing an example of the product number master 106a. [Figure 4] FIG. 4 is a diagram showing an example of the mixed shipment type master 106b that stores the mixed shipment unit CD. [Diagram 5] FIG. 5 is a diagram showing an example of the mixed load unit master 106c that stores mixed load units. [Figure 6] FIG. 6 is a diagram showing an example of the mixed load maximum value master 106d that stores the maximum mixed load amount. [Figure 7] FIG. 7 is a diagram showing an example of the customer master 106e that stores customer names. [Figure 8] FIG. 8 is a diagram showing an example of the delivery destination master 106f that stores the names of delivery destinations. [Figure 9] FIG. 9 is a diagram showing an example of the delivery company master 106g that stores the names of delivery companies. [Figure 10] FIG. 10 is a diagram showing an example of the product order data 106h. [Figure 11] FIG. 11 is a diagram showing an example of the shipping instruction screen MA. [Figure 12] FIG. 12 is a diagram showing an example of the shipping schedule data 106i. [Figure 13] FIG. 13 is a diagram showing an example of the shipping schedule data 106i'. [Figure 14] FIG. 14 is a diagram for explaining the process of dividing an ordered product into unit packing and fractional packing based on the packing unit number. [Figure 15] FIG. 15 is a diagram showing an example of the packing details data 106j. [Figure 16] FIG. 16 is a diagram showing packing detail data 106j-1 obtained by extracting product data of fractional packages from the packing detail data 106j. [Figure 17] FIG. 17 is a diagram showing packing details data 106j-2 in which a column for the MAX package serial number is provided. [Figure 18] FIG. 18 is a diagram showing packing detail data 106j-3 after mixed loading determination and assignment of individual parcel serial numbers. [Figure 19]FIG. 19 is a diagram for explaining the assignment of individual package serial numbers to products that have been divided into unit packages and fractional packages. [Figure 20] FIG. 20 is a diagram showing an example of packing specification data 106j' in which a column for mixed load FLG is provided. [Figure 21] FIG. 21 is a diagram showing an example of the delivery details. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0015] Hereinafter, an embodiment of a product delivery management device, a product delivery management program, and a product delivery management method according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.

[0016] [1. Configuration] An example of the configuration of a product delivery management device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a diagram showing an example of the configuration of a product delivery management device 100 according to this embodiment.

[0017] The product delivery management device 100 is constructed based on a commercially available desktop personal computer. The product delivery management device 100 is not limited to being constructed based on a stationary information processing device such as a desktop personal computer, but may 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.

[0018] The product delivery management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the product delivery management device 100 is connected to each other so as to be able to communicate with each other via an arbitrary communication path.

[0019] The communication interface unit 104 communicatively connects the product delivery management 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 product delivery management device 100 and the server device 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may be stored in the server device 200, for example.

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

[0021] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage 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 as the storage unit 106.

[0022] The memory unit 106 stores, for example, a product number master 106a, a mixed load type master 106b, a mixed load unit master 106c, a maximum mixed load value master 106d, a customer master 106e, a delivery destination master 106f, a delivery company master 106g, order data 106h, shipping schedule data 106i, and packing details data 106j.

[0023] The product number master 106a stores the product number and the mixed-item type CD of the product. For example, as shown in FIG. 3, the product number master 106a stores the product number code, product number name, number of packing units, unit weight, thickness, mixed-item type CD, accessory packing category, accessory packing limit number, size, etc. for each product. The mixed-item type CD is the mixed-item type attached to the product. For example, if the product number code HIN0041, HIN0048, or HIN0050 is attached with the same mixed-item type CD KS01, and the package quantity is a fractional package that is less than the package unit number, it is determined whether the products can be mixed. The same mixed-item type CD is attached to products with similar shapes, and it is determined whether they can be mixed. In addition, the accessory packing category is applied to small products, and it is determined whether products with different mixed-item type CDs can be mixed. Here, the accessory packing category "1" is a product that is determined to be mixed with products with different mixed-item type CDs. The accessory packing limit is the limit on the number of products that can be packed together when packed as a unit or when mixed with other products for accessory packing category "1".

[0024] The mixed item type master 106b stores the correspondence between the mixed item type CD, the mixed item type name, and the mixed item unit CD, as shown in FIG.

[0025] The mixed load unit master 106c stores the mixed load unit corresponding to the mixed load unit CD as shown in FIG.

[0026] As shown in Fig. 6, the maximum mixed value master 106d stores the maximum value when products in fractional packages are mixed for each mixed type CD. For example, as shown in Figs. 4-5, for a sheet (3 x 6) with mixed type CD KS01, the mixed unit CD is 1, and the mixed unit of mixed unit CD1 is thickness. According to Fig. 6, the maximum value of KS01 is 6, and if the thickness of the product in fractional package is 6 cm or more, it is not mixed, and if it is less than 6 cm, it is determined whether it can be mixed with products in fractional packages of other products of mixed type KS01. If the packing unit is quantity, the number of products in fractional packages is determined, and if the packing unit is weight, the weight of the products in fractional packages is determined to determine whether or not to mix.

[0027] The customer master 106e stores the relationship between the customer CD and the customer name, for example, as shown in FIG.

[0028] The delivery destination master 106f stores the relationship between delivery destinations CD and delivery destination names, for example, as shown in FIG.

[0029] The delivery company master 106g stores the relationship between the delivery company CD and the delivery company name, for example, as shown in FIG.

[0030] 10, the order data 106h consists of information such as order number, order date, shipping date, customer CD, delivery destination CD, delivery company CD, required arrival date, line number, product number CD, product name, order quantity, unit price, amount, shipping instruction completion FLG, delivery address, delivery name, etc. When the person in charge inputs the order date, shipping date, customer CD, delivery destination CD, delivery company CD, required arrival date, product number CD, order quantity, etc. for the ordered product, the same order number is automatically assigned to products with the same order date, shipping date, customer CD, delivery destination CD, delivery company CD, and required arrival date, and the unit price, amount, delivery address, delivery name, etc. are automatically input into the order data 106h by referring to each master.

[0031] The shipping schedule data 106i, for example, as shown in Fig. 12, includes a packing number, packing line number, order number, order date, shipping date, customer CD, delivery destination CD, delivery company CD, required arrival date, line number, product number CD, item name, order quantity, instruction count, etc. The shipping schedule data 106i is obtained by extracting only data with the same shipping date from the order data 106h, and the shipping schedule data 106i is created, for example, when the number of shipping instructions and the shipping date are input on the shipping instruction screen MA shown in Fig. 11. When a packing number is assigned by the packing number assignment unit 102b described later, the shipping schedule data 106i is updated to shipping schedule data 106i' with the packing number, etc., input (see Fig. 13).

[0032] 15, the packing details data 106j includes, for example, packing number, packing serial number, parcel serial number, customer CD, delivery destination CD, delivery company CD, required arrival date, product number CD, product name, order quantity, quantity, unit packing number, fractional packing number, packing unit number, mixed loading type, mixed loading unit, mixed loading maximum value, attached packing category, attached packing limit, size, thickness, unit weight, etc. With reference to the shipping schedule data 106i, product number master 106a, mixed loading type master 106b, mixed loading unit master 106c, maximum mixed loading amount master 106d, etc., the number of packing units, mixed loading type, mixed loading unit, mixed loading maximum value, attached packing category, attached packing limit, size, thickness, unit weight are obtained using the product number, etc. as a key to create the packing details data 106j.

[0033] In the packing detail data 106j, for each product in the shipping schedule data 106i, the packing unit in the product number master 106a is referred to, and the product is divided into a unit packing and a fractional packing. For example, the order quantity of the product (packing line number 1) with packing number KON001 and product number code HIN0041 shown in FIG. 13 is 20 sheets, and the number of packing units is 10 sheets (see FIG. 3). In the packing detail data 106j shown in FIG. 15, the packing number KON001 and product number code HIN0041 are divided and described into two unit packs of 10 sheets (packing number KON001, packing sequence numbers 1 and 2). Also, the order quantity of the product (packing line number 2) with packing number KON001 and product number code HIN0048 shown in FIG. 13 is 40 sheets, and the number of packing units is 30 sheets (see FIG. 3). In the packing detail data 106j of FIG. 15, the packing number KON001, product number code HIN0048 are divided into a unit pack of 30 sheets and a fractional pack of 10 sheets (packing number KON001, packing sequence numbers 3 and 4). In the packing detail data 106j, the quantity written in the column next to the order quantity means the quantity in one package; for example, the quantity of products in the package with packing number KON001 and packing sequence number 1 is 10, and it can be seen that it is a unit package that contains the same quantity as the packing unit number (10). In the case of a unit package, the number of unit packages is 1. Also, the product with packing number KON001 and packing sequence number 4 (product number code: HIN0048) has a quantity of products in one package of 10, which is a fractional package that contains a quantity less than the packing unit number of 30, so the number of unit packages is 0 and the number of packages, 10, is entered as the fractional package number.

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

[0035] The control unit 102 conceptually includes, functionally, a shipping schedule data creation unit 102a, a packing number assignment unit 102b, a packing detail creation unit 102c, a mixed loading determination unit 102d, an individual parcel serial number assignment unit 102e, a delivery detail creation unit 102f, and the like.

[0036] The shipping schedule data creating unit 102a creates shipping schedule data 106i for packaging and delivery. The shipping schedule data creating unit 102a extracts shipping schedule data from the order data 106h according to the shipping date to create the shipping schedule data 106i.

[0037] The packing number assignment unit 102b groups products with the same customer CD, delivery destination CD, delivery company CD, and shipping date in the shipping schedule data 106i, and assigns the same packing number. Figure 13 shows shipping schedule data 106i' in which the packing numbers and packing line numbers assigned by the packing number assignment unit 102b are input for the shipping schedule data 106i in Figure 12. In Figure 13, the packing number KON001 is assigned to products (JYU001 and JYU002) with a customer CD of TOK001, a delivery destination CD of NOU001A, a delivery company CD of 10, and a shipping date of 9 / 22 / 2021, the packing number KON002 is assigned to products (JYU004 and JYU003) with a customer CD of TOK001, a delivery destination CD of NOU001B, a delivery company CD of 20, and a shipping date of 9 / 22 / 2021, and the packing number KON003 is assigned to products (JYU005) with a customer CD of TOK002, a delivery destination CD of NOU002D, a delivery company CD of 21, and a shipping date of 9 / 22 / 2021. The packing line number is a serial number for products with the same packing line number.

[0038] The packing detail creation unit 102c creates packing detail data 106j for the products in the shipping schedule data 106i' by referring to the packing unit of each product stored in the product number master 106a and dividing the ordered quantity of each product into products that will be packaged as a unit and products that will be packaged as a fraction. FIG. 14 is a diagram for explaining the process of dividing each product in the product group KON001 into unit packages and fraction packages based on the number of packages of each product. The ordered quantity of XX sheet No. 52 (product number code: HIN0041) is 20 sheets and the package unit is 10 sheets, and each package is packed as a unit of 10 sheets. The ordered quantity of XX sheet No. 28 (product number code: HIN0048) is 40 sheets and the package unit is 30 sheets, and each package is divided into a unit package of 30 sheets and a fraction package of 10 sheets. The ordered quantity of XX bond (product number code: HIN0090) is 10 pieces and the package unit is 24 pieces, and each package is packed as a fraction of 10 pieces. The order quantity for Double-Sided Tape WF-5 (product code: HIN0281) is 10 pieces, and the packaging unit is 120 pieces, so it will be packaged as a fractional package of 10 pieces. The order quantity for Acrylic ○○PG-95 (product code: HIN1210) is 5 sheets, and the packaging unit is 5 sheets, so it will be packaged as a unit package of 5 sheets. Additionally, the order quantity for Resin Glass A00 Acrylic Transparent (product code: HIN1677) is 10 sheets, and the packaging unit is 4 sheets, so it will be divided into two unit packages of 4 sheets and a fractional package of 2 sheets.

[0039] Fig. 15 is the packing detail data 106j of the shipping schedule data 106i' in Fig. 13. As described above, for example, the order quantity of XX sheet No. 52 (packing line No. 1) with packing number KON001 and product code HIN0041 shown in Fig. 13 is 20 sheets, and the number of packing units is 10 sheets (see Fig. 3), so in the packing detail data 106j in Fig. 15, XX sheet No. 52 with packing number KON001 and product code HIN0041 is divided and described into two unit packs of 10 sheets (packing number KON001, packing serial numbers 1 and 2). In addition, the order quantity for XX sheet No. 28 (packing row number 2) with packing number KON001 and product code HIN0048 in Figure 13 is 40 sheets and the packing unit number is 30 sheets (see Figure 3), so in the packing detail data 106j in Figure 15, packing number KON001 and product code HIN0048 are divided into a unit pack of 30 sheets and a fractional pack of 10 sheets (packing number KON001, packing sequence numbers 3 and 4) and listed.

[0040] The mixed loading determination unit 102d refers to the product number master 106a, mixed loading type master 106b, mixed loading unit master 106c, and packing detail data 106j to obtain the thickness, quantity or weight of the product in the fractional package for a product that has been packed as a fractional package by the packing detail creation unit 102c, and compares the obtained thickness, quantity or weight of the product in the fractional package with the maximum mixed loading value stored in the maximum mixed loading value master 106d to determine whether mixed loading is possible.

[0041] Fig. 16 is a diagram showing packing detail data 106j-1 obtained by extracting data on fractional packages from the packing detail data 106j in Fig. 15. In Fig. 15, the data on fractional packages is for a product with piece serial number 0 (the unit package number is 0 and the fractional package number is an integer of 1 or more).

[0042] First, the mixed loading determination unit 102d checks whether the product contained in the fractional package is equal to or less than the mixed loading maximum value. Depending on the shape of the product, the mixed loading unit is either thickness, quantity, or weight. For example, the mixed loading unit of the first line (product number CD: HIN0048, XX sheet No. 28) of the packing detail data 106j-1 is thickness, the mixed loading unit of the third line (product number CD: HIN0090, XX bond) is quantity, and the mixed loading unit of the seventh line (product number CD: HIN7019, XX sheet light gray unryu) is weight. Since HIN0048 has a thickness of 0.20 cm and the quantity of the fractional package is 10 sheets, the thickness when packed is 2 cm, which is equal to or less than the mixed loading maximum value of 6 cm, it is determined that it can be mixed with other products. Furthermore, since the quantity of HIN0090 is 10 pieces and the mixed loading maximum value is 24 pieces or less, it is determined that it can be mixed. HIN7019 has a unit weight of 0.48 kg and the quantity is 100 pieces, so the packaged weight will be 48 kg, which is less than the maximum mixed load weight of 300 kg, and so it is determined that mixed load is possible.

[0043] When it is determined that products in fractional packages can be mixed in as described above, the mixing determination unit 102d obtains the total thickness, quantity or weight of the products that have been given the same packaging number and are fractional packages and have the same mixing type CD, and compares the obtained total thickness, quantity or weight of the products in fractional packages with the maximum mixing value stored in the maximum mixing value master 106d to determine whether they can be mixed in.

[0044] In the packing detail data 106j-1 of Figure 16, products that have the same packing number and the same mixed type CD include HIN0867 and HIN0868 (packing number: KON002, mixed type: KS25), HIN7019 and HIN7020 (packing number: KON002, mixed type: KS44), and HIN1207 and HIN1210 (packing number: KON003, mixed type: KS03).

[0045] HIN0867 can be mixed because the quantity of fractional packages is 1, which is less than the maximum mixed load limit of 2. HIN0868 can also be mixed because the quantity of fractional packages is 1, which is less than the maximum mixed load limit of 2. If HIN0867 and HIN0868 are mixed, the total quantity is 2, which is less than the maximum mixed load limit of 2, so they are considered to be mixed.

[0046] Also, HIN7019 has a unit weight of 0.48 kg, the quantity of the fractional package is 100, the weight of the fractional package is 48 kg, and the maximum mixed load is 300 kg or less, so it can be mixed. HIN7020 has a unit weight of 0.48 kg, the quantity of the fractional package is 100, the weight of the fractional package is 48 kg, and the maximum mixed load is 300 kg or less, so it can be mixed. If HIN7019 and HIN7020 are mixed, the total weight is 96 kg, which is less than the maximum mixed load of 300 kg, so it is determined that they can be mixed.

[0047] On the other hand, HIN1207 is 3.00 cm thick and there is one fractional package, so the thickness of the fractional package is 3.00 cm, which is less than the maximum mixed loading limit of 10 cm, so it can be mixed in. HIN1210 is 2.00 cm thick and there are two fractional packages, so the thickness of the fractional package is 4 cm, which is less than the maximum mixed loading limit of 10 cm, so it can be mixed in. If HIN1207 and HIN1210 are mixed in, the total thickness is 7 cm, which is less than the maximum mixed loading limit of 10 cm, so it is determined that they can be mixed in.

[0048] In addition, the consolidation determination unit 102d also determines whether products with an attached packing category of 0 can be mixed with products with different consolidation categories CD if they are products with the same packing number and fractional packages. For example, HIN0090 and HIN0281 in FIG. 16 have different consolidation categories CD (KS31, KS39) but the same packing number (KON001) and are fractional packages with an attached packing category of 1, so it determines whether they can be mixed. HIN0090 can be mixed because the quantity of fractional packages is 10, which is less than the maximum mixed quantity of 24. HIN0281 can be mixed because the quantity of fractional packages is 10, which is less than the maximum mixed quantity of 120. If HIN0090 and HIN0281 are mixed, the total quantity is 12, which is less than the maximum mixed quantity of 24 for HIN0090, so it is determined that they can be mixed.

[0049] The package serial number assignment unit 102e assigns package serial numbers to each product in the unit package and fractional packages of a product group to which the packing details creation unit 102c has assigned the same packing number. Package serial numbers are sequential numbers assigned to products with the same packing number for each packing unit, and the total number of products in a product group with a single packing number can be determined by the number of package serial numbers. In the packing details data 106j shown in FIG. 15, package serial numbers have only been assigned to products in unit packages, and package serial numbers have not yet been assigned to products in fractional packages (packing serial number 0).

[0050] The unit serial number assignment unit 102e assigns the same unit serial number to a group of products in a fractional package that the consolidation determination unit 102d has determined can be consolidated. Fig. 18 is a diagram showing packing detail data 106j-3 after consolidation determination is performed and unit serial numbers have been assigned. In Fig. 18, the same unit serial number is assigned to a group of products in a fractional package that the consolidation determination unit 102d has determined can be consolidated. For example, unit serial number 9 is assigned to HIN0090 and HIN0281 of KON001, unit serial number 6 is assigned to HIN7019 and HIN7020 of KON002, and unit serial number 7 is assigned to HIN1207 and HIN1210 of KON003.

[0051] The delivery details creation unit 102f creates a delivery details indicating the total number of packages, package serial number, delivery address, delivery name, product information, product number CD, product number thickness, product number size, quantity, and whether or not mixed loading is performed for a group of products to which the same packing serial number is assigned. FIG. 21 is a diagram showing an example of a delivery details. In FIG. 21, a delivery details is created as a label to be attached to a packaged product. An example of a general delivery details label is shown in the center, and a delivery details label for a group of products with packing serial number KON001 is shown on the right. Each label not only functions as a delivery details when attached to a product, but also indicates the total number of packages, package serial number, delivery address, delivery name, product information, product number CD, product number thickness, product number size, quantity, and whether or not mixed loading is performed for the products to be packed, so that the products to be packed and the number of packages at the time of delivery can be easily confirmed, and it becomes possible to accurately pack and ship products in a short time.

[0052] [2. Processing] Here, a specific example of the process executed by the product delivery management device 100 will be described with reference to FIGS.

[0053] This description will be directed to a process of packaging and delivering products using each master and data by the product delivery management device 100. Fig. 2 is a flowchart showing an example of a process of the product delivery management device 100 in this embodiment.

[0054] When the operator inputs the shipping date on the shipping instruction screen MA shown in Figure 11, the shipping schedule data creation unit 102a extracts the product data for the input shipping date from the order data 106h and creates shipping schedule data 106i (step S-1). Figure 12 shows the shipping schedule data 106i extracted from the product data for the shipping date 2021 / 9 / 22.

[0055] After creating the shipping schedule data 106i, the packing number assignment unit 102b groups products with the same customer CD, delivery destination CD, delivery company CD, and shipping date in the shipping schedule data 106i, and assigns the same packing number (step S-2). FIG. 13 shows shipping schedule data 106i' to which the packing numbers and packing line numbers assigned by the packing number assignment unit 102b have been input. Packing number KON001 is assigned to a product with customer CD TOK001, delivery destination CD NOU001A, and delivery company CD 10, packing number KON002 is assigned to a product with customer CD TOK001, delivery destination CD NOU001B, and delivery company CD 20, and packing number KON003 is assigned to a product with customer CD TOK002, delivery destination CD NOU002D, and delivery company CD 21. The packing line number is a reference number for products with the same packing line number.

[0056] After inputting the packing number into the shipping schedule data 106i', the packing detail creation unit 102c creates packing detail data 106j (step S-3). As shown in FIG. 15, the packing detail data 106j is data that clearly indicates the division of the ordered product quantity into unit packing products and fractional packing products for each product in the shipping schedule data 106i'. Here, unit packing means an item in which the product is packed in the packing unit number set for each product, and fractional packing is an item that does not reach the packing unit number. By dividing the ordered product quantity into unit packing products and fractional packing products, it becomes easy to grasp the total number of products of one packing number, that is, products of the same customer, delivery destination, delivery company, and shipping date. Note that if fractional packing products are mixed in due to the mixed loading judgment described later, the total number will change.

[0057] The mixed-loading determination unit 102d performs mixed-loading determination for fractional packaged products in the packing detail data 106j created by the packing detail creation unit 102c (step S-4). FIG. 16 is a diagram showing packing detail data 106j-1 obtained by extracting fractional packaged product data from the packing detail data 106j. The mixed-loading determination unit 102d also acquires a MAX package serial number, which is the number of packages of products that are packaged as a unit for each packing number. The MAX package serial number can be acquired from the packing detail data 106j shown in FIG. 15. For example, the largest package serial number for packing number KON001 is 6, so the MAX package serial number for packing number KON001 is 6. FIG. 17 is a diagram showing packing detail data 106j-2 with a column for the MAX package serial number, in which the same MAX package serial number is entered in the column for the same packing number. The MAX package serial number 6 is entered in packing number KON001. The consolidation determination unit 102d performs consolidation determination for the fractional package in FIG. 17. The consolidation determination unit 102d refers to the product number master 106a, the consolidation type master 106b, the consolidation unit master 106c, and the packing detail data 106j to acquire the thickness, quantity, or weight of the fractional packaged product, and compares the acquired thickness, quantity, or weight of the fractional packaged product with the maximum consolidation value stored in the maximum consolidation value master 106d to determine whether consolidation is possible. If it is determined that the fractional packaged product can be consolidated, the consolidation determination unit 102d acquires the total thickness, quantity, or weight of the fractional packaged product with the same consolidation type CD among the products with the same packing number, and compares the acquired total thickness, quantity, or weight of the fractional packaged product with the maximum consolidation value stored in the maximum consolidation value master 106d to determine whether consolidation is possible.

[0058] After the mixed loading determination unit 102d determines whether the product is mixed, the package serial number assignment unit 102e assigns package serial numbers to the unit packages and fractional packages of the product group to which the packing detail creation unit 102c has assigned the same packing number (step S-5). The package serial number assignment unit 102e assigns the same package serial numbers to the product group of fractional packages that the mixed loading determination unit 102d has determined can be mixed, but assigns package serial numbers in order of the MAX package serial number. Figure 19 is a diagram explaining the assignment of package serial numbers to products that have been allocated to unit packages and fractional packages for the product group KON001. Unit-packaged products are assigned the individual package serial numbers 1 to 6, while odd-packaged products were not assigned individual package serial numbers, but due to a mixed-loading judgment, odd-packaged products, such as 10 pieces of XX bond and 10 pieces of double-sided tape WF-5 in Figure 19, are mixed together and are assigned the same individual package serial number 9. Other odd-packaged products, such as 10 pieces of XX sheet No. 28, resin glass A00, and 2 sheets of clear acrylic, are each packaged individually and assigned individual package serial numbers 7 and 8. Assigning individual package serial numbers to all of the KON001 product group makes it easier to understand and manage the products when packaging and shipping them.

[0059] After the unit serial number is assigned, the packing detail creation unit 102c acquires the unit serial number of the fractional package product and information on whether or not it is mixed, and updates the packing detail data 106j. Fig. 20 is a diagram showing an example of packing detail data 106j' with a mixed-package FLG column, in which a product with a "1" in the mixed-package FLG column indicates that it is mixed, and the unit serial number of the fractional package product has also been updated.

[0060] After the parcel serial number is assigned, the delivery statement creation unit 102f creates a delivery statement (step S-6). By entering the total number of parcels of the products to be packed, the parcel serial number, delivery address, delivery name, product information, product number CD, product number thickness, product number size, quantity, and whether or not the products are mixed in the delivery statement, the products can be packed and delivered while checking the delivery statement, which reduces packing and delivery errors. In addition, since the delivery statement can be prepared before packing and delivery, the time required for delivery can be reduced. In addition, since it is possible to automatically determine whether products packed in fractional quantities are mixed in the delivery statement, it is possible to prevent the process from depending on a person and to reduce the cost required for delivery of the products.

[0061] As described above, according to this embodiment, for products that are packaged in fractional packages and do not fill the packaging unit, criteria are set for whether or not they can be packaged together, and a decision is automatically made based on the criteria as to whether or not they can be packaged together, thereby making it possible to improve the efficiency of delivery operations.

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

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

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

[0065] [4. Other embodiments] The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

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

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

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

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

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

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

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

[0073] The various databases etc. 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 etc. used for various processes and providing websites.

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

[0075] 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 functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]

[0076] The present invention is particularly useful in the packaging and delivery industry involving a plurality of similar products. [Explanation of symbols]

[0077] 100 Product delivery management device 102 Control section 102a Shipping Schedule Data Creation Department 102b Packing Number Assignment Department 102c Packing List Creation Department 102d Mixed Load Judgment Section 102e Small unit serial number assignment section 102f Delivery Details Creation Department 104 Communication interface section 106 Storage section 106a Part Number Master 106b Mixed load type master 106c Mixed unit master 106d Mixed Maximum Value Master 106e Customer Master 106f Delivery destination master 106g Delivery company master 106h Order data 106i shipping schedule data 106j, 106j', 106j-1, 106j-2, 106j-3 Packing details data 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

[Claim 1] A product delivery management device including a control unit, A product number master that stores information including the number of packaging units and mixed-loading type CD for each product; a mixed-pack type master that stores mixed-pack unit CDs corresponding to the mixed-pack type CDs; a mixed load unit master that stores a mixed load unit corresponding to the mixed load unit CD; a mixed load maximum value master that stores a maximum mixed load amount according to the mixed load type CD; Order data including the order date, shipping date, customer CD, delivery destination CD, delivery company CD, and order quantity of the product; is accessible to The control unit is a packing number assigning means for grouping products having the same customer CD, delivery destination CD, delivery company CD, and shipping date in the order data and assigning the same packing number to the products; a packing specification creation means for creating packing specification data in which the ordered quantity of each ordered product is divided into products that are to be packed as a unit and products that are to be packed as fractional quantities by referring to the packing unit of the product number master; a consolidation determination means for obtaining a thickness, quantity or weight of the fractional packaged product by referring to the product number master, the consolidation type master, the consolidation unit master and the packing details for the product that has been packed as a fractional package by the packing details creation means, and for comparing the obtained thickness, quantity or weight of the fractional packaged product with a maximum consolidation value stored in the maximum consolidation value master to determine whether consolidation is possible; A product delivery management device comprising:

Images