JP7610499B2 - Product delivery management device, product delivery management program, and product delivery management method - Google Patents

Description

The present invention relates to a product delivery management device, a product delivery management program, and a product delivery management method.

Conventionally, when an order is received for multiple items, each ordered item is packed separately, but if the number of ordered items is greater than or less than the packing unit, odd-numbered packages may be required. If all odd-numbered packages were shipped as a single packing unit, this would lead to increased costs if the delivery was outsourced, so the delivery staff takes into account the product shape, etc. to determine whether odd-numbered packages can be shipped together, and then delivers them.

When a staff member uses their experience to pack odd-lot products together, there is the problem that the work becomes dependent on the staff member, and because the shipping details are created after the packing work, it also creates the problem of time being required before the products can be shipped.

JP 2019-028992 A

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 load 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 load capacity of a delivery task with mixed loading added is set to the upper limit value of the mixed load 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.

The present invention has been made in consideration of the above 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 products in fractional packages that are larger than the packaging unit or smaller than the packaging unit can be mixed, and automatically decide whether to mix them based on the criteria, thereby improving the efficiency of delivery operations.

In order to solve the above-mentioned problems and achieve the object, the 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 packaging 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 the 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 the customer CD, delivery destination CD, delivery company CD, and order quantity of the product in the order data. The system is characterized by comprising: 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 for each ordered product, with reference to the packing unit in the product number master, in which the ordered quantity is divided into products that will be packaged as unit packing and products that will be packaged as fractional packing; and a mixed loading determination means for determining whether mixed loading is possible by referring to the product number master, the mixed loading type master, the mixed loading unit master, and the packing detail for products packaged as fractional packing by the packing detail creation means, obtaining the thickness, quantity, or weight of the fractional packing product by comparing the obtained thickness, quantity, or weight of the fractional packing product with the maximum mixed loading value stored in the maximum mixed loading value master.

In addition, in the product delivery management device according to the present invention, the consolidation determination means obtains the total thickness, quantity or weight of products that are fractional packages and have the same consolidation 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 fractional packages with the maximum consolidation value stored in the maximum consolidation value master to determine whether consolidation is possible.

The product delivery management device according to 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 details 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 equal to or less than the maximum mixed loading amount and which the mixed loading determination means has determined can be mixed.

The product delivery management device according to the present invention includes a delivery statement creation means for creating a delivery statement that 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, for a group of products that have been assigned the same package serial number.

The 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 able to access a product number master that stores information including the number of packaging units and mixed-loading type CD for each product, a mixed-loading type master that stores mixed-loading unit CD corresponding to the mixed-loading type CD, a mixed-loading unit master that stores mixed-loading units corresponding to the mixed-loading unit CD, a mixed-loading maximum value master that stores the maximum mixed-loading amount corresponding to the mixed-loading 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 product delivery management program to be executed by the control unit is able to access a product number master that stores information including the number of packaging units and mixed-loading type CD for each product, a mixed-loading type master that stores mixed-loading unit CD corresponding to the mixed-loading unit CD, a mixed-loading maximum value master that stores the maximum mixed-loading amount corresponding to the mixed-loading 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 product delivery management program is able to access a product delivery management program to be executed by the control unit, the product delivery management program being ... D, delivery company CD, and product with the same shipping date are grouped together in a packing number assignment step, which assigns the same packing number; a packing detail creation step, which refers to the packing unit in the product number master and creates a packing detail for each ordered product, dividing the ordered quantity into products that will be packaged as unit packing and products that will be packaged as fractional packing; and a mixed loading determination step, which refers to the product number master, the mixed loading type master, the mixed loading unit master, and the packing detail, for products packaged as fractional packing by the packing detail creation means, obtains the thickness, quantity, or weight of the product in the fractional packing, and compares the obtained thickness, quantity, or weight of the product in the fractional packing with the maximum mixed loading value stored in the maximum mixed loading value master to determine whether mixing is possible.

The 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 that stores information including the number of packaging 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 the 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 product delivery management device being capable of accessing a product delivery management device having a control unit that stores information including the number of packaging units and mixed load type CD for each product, a product delivery management device having a control unit that stores information including the number of packaging 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 the 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 product delivery management device being capable of accessing a product delivery management device having a control unit that stores information including the number of packaging units and mixed load type CD for each product, and a mixed load type master that stores mixed load unit CD corresponding to the mixed load type CD, a mixed load maximum value master that stores the 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 product delivery management device being capable of accessing a product delivery management device having a control unit that stores information including the number of packaging units and mixed load type CD for each product. The method includes a packing number assignment step for grouping CDs and products with the same shipping date and assigning the same packing number; a packing detail creation step for creating a packing detail for each ordered product by referencing the packing unit in the product number master and dividing the ordered quantity into products that will be packaged as unit packing and products that will be packaged as fractional packing; and a mixed loading determination step for determining whether mixed loading is possible by referring to the product number master, the mixed loading type master, the mixed loading unit master, and the packing detail for products packaged as fractional packing by the packing detail creation means, and comparing the thickness, quantity, or weight of the fractional packed product with the maximum mixed loading value stored in the maximum mixed loading value master.

According to the present invention, when multiple items are delivered, criteria are set for whether 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, resulting in the effect of making delivery operations more efficient.

FIG. 1 is a diagram showing an example of a configuration of a product delivery management device 100 according to the present embodiment. FIG. 2 is a flowchart showing an example of the process of the product delivery management device 100 in this embodiment. FIG. 3 is a diagram showing an example of the product number master 106a. FIG. 4 is a diagram showing an example of the mixed shipment type master 106b that stores the mixed shipment unit CD. FIG. 5 is a diagram showing an example of the mixed load unit master 106c that stores mixed load units. FIG. 6 is a diagram showing an example of the mixed load maximum value master 106d that stores the maximum mixed load amount. FIG. 7 is a diagram showing an example of the customer master 106e that stores customer names. FIG. 8 is a diagram showing an example of the delivery destination master 106f that stores the names of delivery destinations. FIG. 9 is a diagram showing an example of the delivery company master 106g that stores the names of delivery companies. FIG. 10 is a diagram showing an example of the product order data 106h. FIG. 11 is a diagram showing an example of the shipping instruction screen MA. FIG. 12 is a diagram showing an example of the shipping schedule data 106i. FIG. 13 is a diagram showing an example of the shipping schedule data 106i'. FIG. 14 is a diagram for explaining the process of dividing an ordered product into unit packages and fractional packages based on the number of packages per order. FIG. 15 is a diagram showing an example of the packing detail data 106j. 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. FIG. 17 is a diagram showing packing detail data 106j-2 in which a column for MAX package serial number is provided. FIG. 18 is a diagram showing packing detail data 106j-3 after mixed loading determination and assignment of individual parcel serial numbers. 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. FIG. 20 is a diagram showing an example of packing detail data 106j' in which a column for mixed load FLG is provided. FIG. 21 is a diagram showing an example of a delivery statement.

Below, 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 present embodiment.

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

The product delivery management device 100 is constructed based on a commercially available desktop personal computer. Note that 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 also be constructed based on a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The product delivery management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit of the product delivery management device 100 is connected to each other so that they can communicate with each other via any communication path.

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.

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 works with a mouse to provide 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.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like.

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 mixed load maximum 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.

The product number and mixed-item type CD of the product are stored in the product number master 106a. 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 it can be mixed. The same mixed-item type CD is attached to products with similar shapes, and it is determined whether it 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 they are packaged as a unit or mixed with other products for accessory packing category "1".

As shown in FIG. 4, the mixed load type master 106b stores the correspondence between the mixed load type CD, the mixed load type name, and the mixed load unit CD.

The mixed load unit master 106c stores the mixed load unit corresponding to the mixed load unit CD, as shown in FIG. 5.

As shown in Figure 6, the maximum mixed value master 106d stores the maximum value when fractional packaged products are mixed for each mixed type CD. For example, as shown in Figures 4 and 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 Figure 6, the maximum value of KS01 is 6, and if the thickness of the fractional packaged product is 6 cm or more, it is not mixed, but if it is less than 6 cm, it is determined whether it can be mixed with fractional packaged products of other mixed type KS01 products. If the packaging unit is quantity, the number of fractional packaged products is determined, and if the packaging unit is weight, the weight of the fractional packaged products is determined to determine whether or not to mix.

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

The delivery destination master 106f stores the relationship between delivery destination CD and delivery destination name, for example, as shown in FIG. 8.

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

As shown in FIG. 10, the order data 106h consists of information such as the 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 flag, 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 entered into the order data 106h by referencing each master.

As shown in FIG. 12, the shipping schedule data 106i includes, for example, 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, and number of instructions. The shipping schedule data 106i is an extract of only data with the same shipping date from the order data 106h. For example, the shipping schedule data 106i is created when the number of shipping instructions and the shipping date are entered on the shipping instruction screen MA shown in FIG. 11. When a packing number is assigned by the packing number assignment unit 102b described below, the shipping schedule data 106i is updated to shipping schedule data 106i' with the packing number, etc., entered (see FIG. 13).

As shown in FIG. 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, number of unit packages, number of fractional packages, number of packing units, mixed load type, mixed load unit, maximum mixed load, attached packing category, attached packing limit, size, thickness, unit weight, etc. Packing details data 106j is created by referencing shipping schedule data 106i, product number master 106a, mixed load type master 106b, mixed load unit master 106c, maximum mixed load amount master 106d, etc., and obtaining the number of packing units, mixed load type, mixed load unit, maximum mixed load, attached packing category, attached packing limit, size, thickness, and unit weight using the product number, etc. as a key.

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 referenced, and products are divided into unit packing and 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 in FIG. 15, packing number KON0001 and product number code HIN0041 are divided into two unit packs of 10 sheets (packing number KON0001, 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 and product code HIN0048 are divided into a unit pack of 30 sheets and a fractional pack of 10 sheets (packing number KON0001, packing serial 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 serial number 1 is 10, and it can be seen that it is a unit pack that contains the same quantity as the packing unit number (10). In the case of a unit pack, the number of unit packages is 1. Also, the product with packing number KON001 and packing serial number 4 (product code: HIN0048) has a quantity of products in one package of 10, which is a fractional pack that contains 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.

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, etc., and executes various information processing operations based on these stored programs.

The control unit 102 conceptually includes, in terms of functions, 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, and a delivery detail creation unit 102f.

The shipping schedule data creation unit 102a creates shipping schedule data 106i for packaging and delivery. The shipping schedule data creation unit 102a extracts shipping schedule data from the order data 106h based on the shipping date to create 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. 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 FIG. 13, the packing number KON0001 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 2021/9/22, the packing number 0002 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 2021/9/22, and the packing number KON0003 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 2021/9/22. The packing line number is a serial number for products with the same packing line number.

The packing details creation unit 102c creates packing details 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 fractional package. FIG. 14 is a diagram explaining the work of dividing each product in the product group KON001 into unit packages and fractional packages based on the number of packages of each product. XX sheet No. 52 (product number code: HIN0041) has an order quantity of 20 sheets and a package unit of 10 sheets, and each is packaged as a unit of 10 sheets. In addition, XX sheet No. 28 (product number code: HIN0048) has an order quantity of 40 sheets and a package unit of 30 sheets, and is divided into a unit package of 30 sheets and a fractional package of 10 sheets. XX bond (product number code: HIN0090) has an order quantity of 10 pieces and a package unit of 24 pieces, and is packaged as a fractional package 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.

Figure 15 is the packing detail data 106j of the shipping schedule data 106i' in Figure 13. As described above, for example, the order quantity of XX sheet No. 52 (packing row No. 1) with packing number KON001 and product code HIN0041 shown in Figure 13 is 20 sheets and the number of packing units is 10 sheets (see Figure 3), so in the packing detail data 106j in Figure 15, XX sheet No. 52 with packing number KON001 and product code HIN0041 is divided into two unit packs of 10 sheets (packing number KON0001, packing sequence numbers 1 and 2) and recorded. 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 number of packing units 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 KON0001, packing sequence numbers 3 and 4).

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 products that have been packed as fractional packages 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.

Figure 16 is a diagram showing packing detail data 106j-1, which is product data for fractional packages extracted from the packing detail data 106j in Figure 15. In Figure 15, the product data for fractional packages is 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).

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 details 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 a quantity of 100, so the packaged weight is 48 kg, which is less than the maximum mixed load weight of 300 kg, and so it is determined that mixed loading is possible.

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 products that are fractional packages among products that are assigned the same package number 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.

In the packing detail data 106j-1 of FIG. 16, products that are assigned the same packing number and have the same mixed type CD include HIN0867 and HIN0868 (packing number: KON0002, mixed type: KS25), HIN7019 and HIN7020 (packing number: KON0002, mixed type: KS44), and HIN1207 and HIN1210 (packing number: KON0003, mixed type: KS03).

HIN0867 can be mixed because the fractional package quantity is 1, which is less than the maximum mixed package quantity of 2. HIN0868 can also be mixed because the fractional package quantity is 1, which is less than the maximum mixed package quantity of 2. When HIN0867 and HIN0868 are mixed, the total quantity is 2, which is less than the maximum mixed package quantity of 2, so it is determined that they can be mixed.

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 value 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 value 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 value of 300 kg, so it is determined that they can be mixed.

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 value of 10 cm and 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 value of 10 cm and can be mixed in. When HIN1207 and HIN1210 are mixed in, the total thickness is 7 cm, which is less than the maximum mixed loading value of 10 cm and can be mixed in.

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

The package serial number assignment unit 102e assigns package serial numbers to each product in unit packages 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 one 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).

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

The delivery details creation unit 102f creates a delivery details for a group of products to which the same packing serial number has been assigned, which 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. 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 the 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 KON0001 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. This makes it easy to check the products to be packaged and the number of packages at the time of delivery, and enables accurate packaging and shipping of products in a short time.

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

This explanation will be given of the process in which the product delivery management device 100 uses each master and data to package and deliver products. Figure 2 is a flowchart showing an example of the process of the product delivery management device 100 in this embodiment.

When the operator inputs a shipping date on the shipping instruction screen MA shown in FIG. 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). FIG. 12 shows shipping schedule data 106i in which the product data for the shipping date of 2021/9/22 has been extracted.

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). Figure 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 KON0001 is assigned to the product with customer CD TOK001, delivery destination CD NOU001A, and delivery company CD 10, packing number 0002 is assigned to the product with customer CD TOK001, delivery destination CD NOU001B, and delivery company CD 20, and packing number KON0003 is assigned to the product with customer CD TOK002, delivery destination CD NOU002D, and delivery company CD 21. The packing line number is a serial number for products with the same packing line number.

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 ordered product quantity for each product in the shipping schedule data 106i', divided into products that will be unit packings and products that will be fractional packings. Here, a unit packing refers to an item in which the number of products in the packing unit set for each product are packed, and a fractional packing is an item that does not reach the number of packing units. By dividing the ordered product quantity into products that will be unit packings and products that will be fractional packings, it becomes easier to grasp the total number of products with one packing number, that is, products with the same customer, delivery destination, delivery company, and shipping date. Note that if products in fractional packings are mixed in due to the mixed-in determination described below, the total number will change.

The mixed-loading determination unit 102d performs mixed-loading determination for products in fractional packages among 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 product data in fractional packages from the packing detail data 106j. The mixed-loading determination unit 102d also obtains a MAX package serial number, which is the number of packages of products that are packaged as a unit package for each packing number. The MAX package serial number can be obtained from the packing detail data 106j shown in FIG. 15. For example, the maximum 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 has been entered into 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.

After the mixed loading determination unit 102d makes a mixed loading determination, the unit serial number assignment unit 102e assigns unit serial numbers to each of 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 unit serial number assignment unit 102e assigns the same unit serial numbers to the product group of fractional packages that the mixed loading determination unit 102d has determined can be mixed, but assigns unit serial numbers in the order of the MAX unit serial number. Figure 19 is a diagram explaining the assignment of unit serial numbers to products allocated to unit packages and fractional packages for the product group KON001. Unit-packaged products are assigned the item serial numbers 1 to 6, while odd-packaged products were not assigned item serial numbers until they were mixed in due to a mixed-packing determination. In Figure 19, 10 pieces of XX bond and 10 pieces of double-sided tape WF-5 are mixed in, so the same item serial number 9 is assigned. Other odd-packaged products, 10 sheets of XX sheet No. 28 and 2 sheets of resin glass A00 acrylic transparency, are each packaged separately and assigned item serial numbers 7 and 8. Assigning item serial numbers to all products in the KON0001 product group makes it easier to understand and manage the products when they are packaged and shipped.

After the unit serial numbers are assigned, the packing details creation unit 102c acquires the unit serial numbers of the fractional packaged products and information on whether or not the products are mixed-loaded, and updates the packing details data 106j. Figure 20 is a diagram showing an example of packing details data 106j' with a mixed-loading FLG column, in which products with a "1" in the mixed-loading FLG column are mixed-loaded, and the unit serial numbers of the fractional packaged products have also been updated.

After the parcel serial number has been 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, it is possible to pack and ship while checking the delivery statement, which reduces packing and shipping errors. In addition, since the delivery statement can be prepared before packing and shipping, the time required for shipping can be reduced. In addition, since it is possible to automatically determine whether products packed in fractional quantities are mixed in the same package, it is possible to prevent dependency on a specific person and reduce the cost required for shipping the products.

As described above, according to this embodiment, for products that are packaged in fractional packages that 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 streamline delivery operations.

[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 making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

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.

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 a known method.

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

Furthermore, with regard to the product delivery management device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

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 on a non-transient computer-readable recording medium that contains 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 is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the product delivery management device 100 via any network, and all or part of it may be downloaded as needed.

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

A "program" is a data processing method written in any language or description method, and may be in any format, 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 consisting of multiple modules or libraries, and a program that works in conjunction 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, can use well-known configurations and procedures.

The various databases stored in the memory unit are storage devices such as RAM, ROM, etc., 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.

The product delivery management 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 product delivery management device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on 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.

The present invention is particularly useful in industries such as packaging and shipping that involve multiple products of similar shapes.

100 Product delivery management device 102 Control unit 102a Shipping schedule data creation unit 102b Packing number assignment unit 102c Packing details creation unit 102d Consolidation determination unit 102e Parcel serial number assignment unit 102f Delivery details creation unit 104 Communication interface unit 106 Storage unit 106a Product number master 106b Consolidation type master 106c Consolidation unit master 106d Maximum consolidation 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 unit 112 Input device 114 Output device 200 Server 300 Network

Claims (6)

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 packaged as unit packages and products that are packaged as fractional packages by referring to the package 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 detail data for the product that has been packed as a fractional package by the packing detail 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: The mixed loading determination means obtains a total thickness, quantity or weight of products that are fractional packages and have the same mixed loading type CD among the products to which the package number assignment means assigns the same package number, and compares the obtained total thickness, quantity or weight of the fractional packages with the maximum mixed loading value stored in the maximum mixed loading value master to determine whether mixed loading is possible.
The product delivery management device according to claim 1. a unit serial number assigning means for assigning a unit serial number to each of the unit packages and fractional packages of the product group to which the packing detail creation means has assigned the same packing number;
The unit serial number assignment means assigns the same unit serial number to a group of products in a fractional package that is determined by the consolidation determination means to have a total consolidation amount equal to or less than a maximum consolidation amount and can be consolidate.
The product delivery management device according to claim 2. The product delivery management device according to claim 3, further comprising a delivery statement creation means for creating a delivery statement 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 the package is mixed, for a group of products to which the same package serial number is assigned. A product delivery management program to be executed by a product delivery management device having a control unit,
The product delivery management device includes:
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
To cause the control unit to execute
A packing number assignment step 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;
a packing detail creating step of creating packing detail data in which the ordered quantity of each ordered product is divided into products that are packaged as unit packages and products that are packaged as fractional packages by referring to the packing unit of the product number master;
a consolidation determination step of 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 detail data for the product that has been packed as a fractional package by the packing detail creation means, and 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;
containing,
A product delivery management program that features: A product delivery management method executed by a product delivery management device having a control unit,
The product delivery management device includes:
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
Executed by the control unit,
A packing number assignment step 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;
a packing detail creating step of creating packing detail data in which the ordered quantity of each ordered product is divided into products that are packaged as unit packages and products that are packaged as fractional packages by referring to the packing unit of the product number master;
a consolidation determination step of 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 detail data for the product that has been packed as a fractional package by the packing detail creation means, and 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;
containing,
A product delivery management method comprising the steps of:

Images