JP2020135657A - Packing instruction data generation device, packing instruction data generation method and packing instruction data generation program - Google Patents

Abstract

To provide a packing instruction data generation device or the like that can generate packing instruction data gradually roughening a packing grain size.SOLUTION: In this embodiment, order entry data containing multiple order entry disclosures having a key, a commodity code, a carton quantity and a floor area ratio is referred to, and (1) the same number is numbered to an order entry disclosure that the sum of the floor area ratio becomes 100% among the order entry disclosures that the commodity code is the same as the key, (2) the same number is numbered to an order entry disclosure that the sum of the floor area ratio becomes 100% among the order entry disclosures that the key is the same but the commodity codes are different, (3) the same number is numbered to an order entry disclosure that the sum of the floor area ratio becomes 100% among the order entry disclosures that both of the key and the commodity codes are different but the carton quantity is the same, and (4) the same number is numbered to an order entry disclosure that the sum of the floor area ratio becomes a predetermined threshold or less among the order entry disclosures that the key, the commodity code and the carton quantity are different, and thereby the number being numbered as well as the commodity code of the order entry disclosure with the same number and the floor area ratio are stored in packing instruction data as packing information per 1-carton.SELECTED DRAWING: Figure 11

Description

The present invention relates to a packing instruction data generation device, a packing instruction data generation method, and a packing instruction data generation program.

Patent Document 1 describes a packing planning device, a packing planning system, and a packing planning method for the purpose of preventing the completion deadline of packing work from being not met and the packing work cost from increasing due to overtime work. And the program is disclosed (see paragraph 0007, etc.).

Japanese Unexamined Patent Publication No. 2017-12476

In the field of packing management in this way, as a method of generating packing instruction data, first of all, packing of products with high commonality (for example, products having the same key and product code), that is, with fine particle size Generate packing instruction data for packing. Next, when there are no more products with high commonality, products with medium commonality (for example, products with the same key but different product codes) are packed together, that is, packing with medium particle size. Generate the packing instruction data that has been performed. Finally, when there are no products with medium commonality, products with low commonality (for example, products with different keys and product codes) are packed together, that is, packed with coarse particle size. Generate instruction data.

However, since it has not been possible to automatically generate packing instruction data in which the particle size of such packing is gradually coarsened, there is a problem that the work of packing instruction requires a great deal of labor and time.

The present invention has been made in view of the above problems, and provides a packing instruction data generating device capable of generating packing instruction data in which the particle size of the packing is gradually coarsened, a packing instruction data generation method, and a packing instruction data generation program. The purpose is to do.

In order to solve the above-mentioned problems and achieve the object, the packing instruction data generation device according to the present invention is a packing instruction data generation device including a control unit, and the control unit includes key data and product identification data. Order detail data having the number of items in a carton, which is the number of items that can be put in one carton, the number of orders for the item, and the volume ratio of the item in one carton calculated based on the number of items in the carton. With reference to the order data including a plurality of items, the same carton number is assigned to the order item data in which the key data is the same and the product identification data is the same and the sum of the volume ratios is 100%. The first packing means for numbering and storing the product identification data and the volume ratio of the order detail data with the same carton number and the same carton number in the packing instruction data as packing information per carton. With reference to the order data excluding the order detail data in which the carton number is assigned by the first packing means, the order detail data having the same key data and different product identification data is described. The same carton number is assigned to the data whose sum of the volume ratios is 100%, and the product identification data and the volume ratio of the order detail data with the carton number and the same carton number are assigned. The second packing means stored in the packing instruction data as packing information per carton, and the order data excluding the order detail data in which the carton number is assigned by the first packing means and the second packing means. With reference to the same carton for the order detail data in which the key data is different, the product identification data is different, and the number of items in the carton is the same, the sum of the volume ratios is 100%. A number is assigned, and the product identification data and the volume ratio of the order detail data with the same carton number and the same carton number are stored in the packing instruction data as packing information per carton. (Iii) The key data is different with reference to the order data excluding the order detail data in which the carton number is assigned by the first packing means, the second packing means, and the third packing means. The same carton number is assigned to the order detail data in which the product identification data is different and the carton quantity is different and the sum of the volume ratios is equal to or less than a predetermined threshold. It is provided with a fourth packing means for storing the product identification data and the floor area ratio of the order detail data with the same carton number in the packing instruction data as packing information per carton. It is a feature.

In order to solve the above-mentioned problems and achieve the object, in the packing instruction data generation device according to the present invention, the control unit refers to the product master including the product identification data and the carton quantity, and the order data. The number of carton pieces associated with the product identification data included in the order data is acquired and stored in the order data, and 100 is added to the value obtained by dividing the number of orders included in the order data by the number of carton pieces stored in the order data. It is characterized in that the volume ratio calculation means for calculating the volume ratio by multiplying and storing the calculated volume ratio in the order data is further provided.

Further, the packing instruction data generation method according to the present invention is a packing instruction data generation method executed by an information processing apparatus including a control unit, and is executed by the control unit with key data, product identification data, and one carton. Includes a plurality of order detail data having the number of carton pieces that can be put in per carton, the number of orders for the item, and the volume ratio of the item per carton calculated based on the number of items in the carton. With reference to the order data, the same carton number is assigned to the order detail data in which the key data is the same and the product identification data is the same and the sum of the volume ratios is 100%. Then, the first packing step of storing the product identification data and the volume ratio of the order detail data with the carton number and the same carton number in the packing instruction data as packing information per carton. With reference to the order data excluding the order detail data for which the carton number was assigned in the first packing step, the volume ratio of the order detail data having the same key data but different product identification data. The same carton number is assigned to the sum of 100%, and the product identification data and the volume ratio of the order detail data with the carton number and the same carton number are set to one carton. Refer to the second packing step stored in the packing instruction data as the per-packing information, and the order data excluding the order detail data in which the carton number is assigned in the first packing step and the second packing step. Therefore, the same carton number is assigned to the order detail data in which the key data is different, the product identification data is different, and the carton quantity is the same, and the sum of the volume ratios is 100%. A third packing that is numbered and stores the product identification data and the volume ratio of the order detail data with the same carton number and the same carton number in the packing instruction data as packing information per carton. With reference to the order data excluding the order detail data in which the carton number is assigned in the step, the first packing step, the second packing step, and the third packing step, the key data is different, and the product The same carton number is assigned to the order detail data in which the identification data is different and the carton quantity is different and the sum of the volume ratios is equal to or less than a predetermined threshold. A fourth packing that is numbered and stores the product identification data and the floor area ratio of the order detail data with the same carton number and the same carton number in the packing instruction data as packing information per carton. It is characterized by including, and.

Further, the packing instruction data generation program according to the present invention is a packing instruction data generation program to be executed by an information processing apparatus including a control unit, and includes key data and product identification data to be executed by the control unit. Order detail data having the number of items in a carton, which is the number of items that can be put in one carton, the number of orders for the item, and the volume ratio of the item in one carton calculated based on the number of items in the carton. With reference to the order data including a plurality of items, the same carton number is assigned to the order item data in which the key data is the same and the product identification data is the same and the sum of the volume ratios is 100%. The first packing step of numbering and storing the product identification data and the volume ratio of the order detail data with the same carton number and the same carton number in the packing instruction data as packing information per carton. With reference to the order data excluding the order detail data for which the carton number was assigned in the first packing step, the order detail data having the same key data and different product identification data is described. The same carton number is assigned to the data whose sum of the volume ratios is 100%, and the product identification data and the volume ratio of the order detail data with the carton number and the same carton number are assigned. The second packing step stored in the packing instruction data as packing information per carton, and the order data excluding the order detail data in which the carton number is assigned in the first packing step and the second packing step are stored. With reference to the same carton for the order detail data in which the key data is different, the product identification data is different, and the number of items in the carton is the same, the sum of the volume ratios is 100%. A number is assigned, and the product identification data and the volume ratio of the order detail data with the same carton number and the same carton number are stored in the packing instruction data as packing information per carton. The key data is different with reference to the order data excluding the order detail data in which the carton number is assigned in the first packing step, the second packing step, and the third packing step. For the order detail data in which the product identification data is different and the carton quantity is different, the sum of the volume ratios is equal to or less than a predetermined threshold value. Then, the same carton number is assigned, and the product identification data and the floor area ratio of the order detail data with the same carton number and the same carton number are used as packing information per carton to indicate the packing. It is characterized by including a fourth packing step to be stored in the data.

According to the present invention, it is possible to generate packing instruction data in which the particle size of the packing is gradually coarsened.

FIG. 1 is a block diagram showing an example of a configuration of a packing instruction data generation device. FIG. 2 is a diagram showing an example of a processing flow according to the present embodiment. FIG. 3 is a diagram showing an example of the relationship between an item and a table that holds the item. FIG. 4 is a diagram showing an example of the product hierarchy. FIG. 5 is a diagram showing an example of order data before storing the floor area ratio. FIG. 6 is a diagram showing an example of a product master. FIG. 7 is a diagram showing an example of order data after storing the floor area ratio. FIG. 8 is a diagram showing an example of a work table and a packing result in a case where automatic packing processing is performed for order detail data having the same key and the same product code. FIG. 9 is a diagram showing an example of a work table and packing results when automatic packing processing is performed for order detail data having the same key but different product codes. FIG. 10 is a diagram showing an example of a work table and packing results in a case where automatic packing processing is performed for order detail data having different keys, different product codes, and the same carton quantity. FIG. 11 is a diagram showing an example of a work table and packing results in a case where automatic packing processing is performed on order detail data having different keys, different product codes, and different carton quantity. FIG. 12 is a diagram showing an example of a screen for instructing the operation of the automatic packing process.

Hereinafter, embodiments of a packing instruction data generation device, a packing instruction data generation method, and a packing instruction data generation program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment. Hereinafter, a specific configuration and operation will be described.

[1. Constitution]
An example of the configuration of the packing instruction data generation device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the packing instruction data generation device 100.

The packing instruction data generation device 100 is a commercially available desktop personal computer. The packing instruction data generation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is not limited to a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like. It may be a portable information processing device.

The packing instruction data generation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the packing instruction data generation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the packing instruction data generation device 100 to the network 300 so as to be communicable 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 another device via a communication line. Here, the network 300 has a function of connecting the packing instruction data generation device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Data of various masters and the like, which will be described later, may be stored in the server 200, for example.

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

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving a command to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, 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 can be used.

The storage unit 106 includes, for example, order data 106a, product master 106b, and packing instruction data 106c.

As shown in FIG. 7, the order data 106a includes, for example, key data (key), product identification data (product code), the number of products in a carton, which is the number of products that can be stored in one carton, and the above. It includes a plurality of order detail data having the volume ratio of the product per carton calculated based on the number of orders for the product and the number of items in the carton, and the like. The order details data further includes, for example, the number of orders for the product, the order number, the expected arrival date of the product, the warehouse for receiving the product, and the classification of whether the product is paid or free. You may.

Specifically, the key data is a product manager code, a supplier code, a product type code, a representative product number, a full product number, and the like. The unit for expressing the number of the commodities is not particularly limited, but in the present specification, Pieces (PCS), which is a unit often used in the trading industry and the like, is used. For example, XX PCS is synonymous with XX pieces. In the present embodiment, the packing method of the product is not limited to carton packing, and may be, for example, a packing method such as back packing, case packing, crate packing, drum packing, pallet packing, and skid packing. For example, in the case of case packing, the number of items in the carton is the number of items in the case (the number of products that can be put in one case).

The product master 106b is the acquisition destination of the carton quantity and the like, and the carton quantity and the like acquired from the product master 106b are stored in the order data 106a. Although not shown, the product master 106b includes, for example, the product identification data (product code), the carton quantity, the product manager code, the supplier code, the country of origin of the product, and the like. including.

As shown in the lower figures of FIGS. 8 to 11, the packing instruction data 106c includes, for example, a carton number, the product identification data (product code), the floor area ratio, and the like. In addition, in this specification and this drawing, packing instruction data 106c may be referred to as packing instruction information 106c, packing instruction table 106c or packing result 106c, but the meanings are all the same.

The control unit 102 is a CPU or the like that collectively controls the packing instruction data generation device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

Functionally, the control unit 102 refers to (1) the product master including the product identification data and the carton quantity, and acquires the carton quantity associated with the product identification data included in the order data. Then, the volume ratio is calculated by multiplying the value obtained by dividing the number of orders included in the order data by the number of carton pieces stored in the order data by 100, and the calculated volume ratio is calculated. The volume ratio calculation unit 102a as a volume ratio calculation means for storing the data in the order data, (2) key data, product identification data, the number of products in a carton, which is the number of products that can be stored in one carton, and the product. The key data is the same and the product identification is performed with reference to the order data including a plurality of order detail data having the number of orders received and the volume ratio of the product per carton calculated based on the number of orders received. The same carton number is assigned to the order detail data having the same data and the sum of the volume ratios is 100%, and the carton number and the same carton number are attached to the order detail. The first packing unit 102b as the first packing means for storing the product identification data and the volume ratio of the data in the packing instruction data as packing information per carton, and (3) the carton in the first packing means. With reference to the order data excluding the order detail data numbered, the sum of the volume ratios of the order detail data having the same key data but different product identification data is 100%. The same carton number is assigned to the data, and the product identification data and the volume ratio of the order detail data with the same carton number and the same carton number are used as packing information per carton. The second packing unit 102c as the second packing means to be stored in the instruction data, and (4) the order data excluding the order detail data in which the carton number is assigned by the first packing means and the second packing means. With reference to the same carton for the order detail data in which the key data is different, the product identification data is different, and the number of items in the carton is the same, the sum of the volume ratios is 100%. A number is assigned, and the product identification data and the volume ratio of the order detail data with the same carton number and the same carton number are stored in the packing instruction data as packing information per carton. Three packing means (5) The order data excluding the order detail data in which the carton number is assigned by the first packing means, the second packing means, and the third packing means. , The same carton number is adopted for the order detail data in which the key data is different, the product identification data is different, and the carton quantity is different, and the sum of the floor area ratios is equal to or less than a predetermined threshold. A fourth packing means for storing the product identification data and the floor area ratio of the order detail data with the same carton number and the same carton number in the packing instruction data as packing information per carton. The fourth packing unit 102e and the like are provided.

The floor area ratio calculation unit 102a refers to the product master 106b including the product code and the carton quantity, acquires the carton quantity associated with the product code included in the order data 106a, stores it in the order data 106a, and receives an order. The floor area ratio is calculated by multiplying the value obtained by dividing the number of orders included in the data 106a by the number of carton pieces stored in the order data 106a by 100, and the calculated floor area ratio is stored in the order data 106a.

The first packing unit 102b refers to the order data 106a including a plurality of order detail data having a key, a product code, a carton quantity, and a floor area ratio, and has the same key and the same product code. Of these, the same carton number is assigned to those for which the sum of the floor area ratios is 100%, and the product code and floor area ratio of the order detail data with the carton number and the same carton number are assigned to one carton. It is stored in the packing instruction data 106c as the packing information per hit. Simply put, the first packing unit 102b packs products having the same key and product code, that is, packs them in a fine particle size.

The second packing unit 102c refers to the order data 106a excluding the order detail data in which the carton number is assigned by the first packing unit 102b, and refers to the floor area ratio of the order detail data having the same key but different product codes. The same carton number is assigned to the item whose sum is 100%, and the product code and floor area ratio of the order detail data with the carton number and the same carton number are included in the packing information per carton. Is stored in the packing instruction data 106c. Simply put, the second packing unit 102c packs products with the same key but different product codes, that is, packing with a medium particle size.

The third packing unit 102d refers to the order data 106a excluding the order detail data in which the carton number is assigned by the first packing unit 102b and the second packing unit 102c, and the key is different, the product code is different, and the carton is used. The same carton number is assigned to the order detail data with the same quantity and the sum of the floor area ratios is 100%, and the order detail data with the same carton number and the same carton number is assigned. The product code and floor area ratio of the product are stored in the packing instruction data 106c as packing information per carton. Simply put, the third packing unit 102d packs products having different keys and product codes but the same number of cartons, that is, packing with a coarse particle size.

The fourth packing section 102e refers to the order data 106a excluding the order detail data in which the carton number is assigned by the first packing section 102b, the second packing section 102c, and the third packing section 102d, and the key is different, and the product code is different. The same carton number is assigned to the order detail data with different carton quantities and the sum of the floor area ratios is less than or equal to a predetermined threshold, and the carton number and the same carton number are assigned. The product code and floor area ratio of the received order detail data are stored in the packing instruction data 106c as packing information per carton. Simply put, the fourth packing unit 102e packs products having different keys, product codes, and carton quantities, that is, packing with a coarse particle size.

The predetermined threshold value described in the previous paragraph is not particularly limited and can be set arbitrarily, but is, for example, 80%. In the fourth packing section 102e, the sum of the floor area ratios is not set to 100%, but is set to be equal to or less than a predetermined threshold, for example, for the following reasons. That is, in the coarse-grained packing performed by the fourth packing section 102e, for example, products whose packing efficiency is not good due to their different shapes are packed in the same carton, so the sum of the floor area ratios is 100. If it is set to%, there is a possibility that the products will not fit in the same carton. Therefore, by setting the floor area ratio to, for example, 80% with a margin, it is possible to ensure that different products fit in the same carton.

[2. processing]
In this item, an example of the process according to the present embodiment will be described.

First, as shown in MA1 in the screen example of the automatic packing process of FIG. 12, when the extraction condition is input and "F10: execute" is pressed, the order detail data of the unpacked order data 106a Is listed in the MA4 area.

From the order details data listed in the MA4 area, the target order details data is selected by checking the square frame indicated by MA2, and when the "Register" button is pressed, the selection is made. The automatic packing process (process described in [2-2] to [2-5] below) is executed for the order detail data. When the "Batch packing" button is pressed, all the order details data listed in the MA4 area are selected, that is, the state to be packed.

After executing the automatic packing process, the numbered packing number is displayed in the MA3 area. Based on the displayed packing number, the packing result can be confirmed in the packing adjustment input checklist.

Hereinafter, the automatic packing process executed when the predetermined order detail data is selected and the "Register" button is pressed will be described in detail. However, the floor area ratio calculation process as a preprocessing for performing the automatic packing process will be described. First, it will be described in [2-1]. As a premise, it is assumed that the order data 106a is input in advance with the contents shown in FIG. 5, and the product master 106b is preset with the contents shown in FIG.

[2-1. Floor area ratio calculation process]
For example, the floor area ratio calculation unit 102a refers to the product master 106b of FIG. 6 and acquires the carton quantity 432PCS associated with the product code “product A” included in the order data 106a of FIG. 5, and receives the order of FIG. Store in data 106a. Then, the floor area ratio calculation unit 102a multiplies the value (≈0.8) obtained by dividing the number of orders 345PCS included in the order data 106a of FIG. 5 by the number of cartons 432PCS stored in the order data 106a of FIG. The floor area ratio of 80% is calculated, and the calculated floor area ratio of 80% is stored in the order data 106a of FIG. In this way, the order detail data numbered 1-1 in the order data 106a of FIG. 7 is generated. Although detailed description is omitted, other order detail data shown in FIG. 7 is also generated by the same method.

Hereinafter, in [2-2] to [2-5], the automatic packing process (= carton numbering process) will be described. In the following [2-2] to [2-5], for the sake of simplicity, the order detail data is described only by the numbers attached to the left side of FIGS. 7 to 11. For example, in the case of order detail data numbered 1-1 in FIG. 7, it is simply described as "1-1".

[2-2. First packing process]
The first packing unit 102b refers to the order data 106a of FIG. 7, and refers to the same carton for the order detail data having the same key and the same product code and having a sum of floor area ratios of 100%. Numbers are assigned. Specifically, in FIG. 7, the floor area ratio of 1-2 140% exceeds 100%. In this case, the first packing unit 102b divides 1-2 into 1-2A having a floor area ratio of 100% and 1-2B having a floor area ratio of 40%, as shown in the upper figure of FIG. The carton number "01" is assigned to 2A. Similarly, in FIG. 7, the floor area ratio of 2-1 is 160%, which exceeds 100%. In this case, the first packing unit 102b divides 2-1 into 2-1A having a floor area ratio of 100% and 2-1B having a floor area ratio of 60%, as shown in the upper figure of FIG. The carton number "02" is assigned to 1A.

Then, as shown in the packing result of the lower figure of FIG. 8, the first packing unit 102b has the numbered carton number “01” and the product code “product B” of 1-2A with the carton number “01”. And the floor area ratio "100%" are stored in the packing instruction data 106c as packing information per carton. Similarly, as shown in the packing result of the lower figure of FIG. 8, the first packing unit 102b has the numbered carton number “02” and the product code “product C” of 2-1A with the carton number “02”. And the floor area ratio “100%” are stored in the packing instruction data 106c as packing information per carton.

As described above, by the process described in this item [2-2], the packing instruction data 106c obtained by packing products having high commonality (things having the same key and product code), that is, packing with fine particle size. It will be generated.

[2-3. Second packing process]
The second packing unit 102c refers to the order data 106a in FIG. 8 excluding the order detail data in which the carton number is assigned in [2-2], and refers to the order detail data having the same key but different product codes. The same carton number is assigned to those for which the sum of the floor area ratios is 100%. Specifically, in the upper figure of FIG. 8, the sum of 80% of the floor area ratio of 1-1 and 20% of the 40% of the floor area ratio of 1-2B is 100%. In this case, the second packing unit 102c divides 1-2B into 1-2Ba having a floor area ratio of 20% and 1-2Bb having a floor area ratio of 20%, as shown in the upper figure of FIG. 9, and 1- The carton number "03" is assigned to 1 and 1-2 Ba. Similarly, in the upper figure of FIG. 8, the sum of 60% of the floor area ratio of 3-1 and 40% of the 90% of the floor area ratio of 3-2 is 100%. In this case, the second packing unit 102c divides 3-2 into 3-2A having a floor area ratio of 40% and 3-2B having a floor area ratio of 50%, as shown in the upper figure of FIG. The carton number "04" is assigned to 1 and 3-2A.

Then, as shown by hatching in the packing result shown in the lower figure of FIG. 9, the second packing unit 102c has the numbered carton number “03” and the product code “1-1 having the numbered carton number“ 03 ”. "Product A" and floor area ratio "80%", product code "Product B" and floor area ratio "20%" of 1-2Ba with the numbered carton number "03", and packing information per carton Is stored in the packing instruction data 106c. Similarly, the second packing unit 102c has the product code of the numbered carton number “04” and the product code of 3-1 having the numbered carton number “04” as shown by hatching in the packing result of FIG. 9 below. "Product D" and floor area ratio "60%", and product code "Product E" and floor area ratio "40%" of 3-2A having the numbered carton number "04" are packed per carton. It is stored in the packing instruction data 106c as information.

As described above, by the process described in this item [2-3], products with medium commonality (those with the same key but different product codes) are packed, that is, they are packed with medium particle size. This means that the packing instruction data 106c has been generated.

[2-4. Third packing process]
The third packing unit 102d refers to the order data 106a in FIG. 9 excluding the order detail data in which the carton number is assigned in [2-2] and [2-3], and the key is different and the product code is different. The same carton number is assigned to the order detail data that are different and have the same number of cartons and the sum of the floor area ratios is 100%. Specifically, in the upper figure of FIG. 9, the sum of the floor area ratio of 1-2Bb of 20%, the floor area ratio of 2-1B of 60%, and the floor area ratio of 3-2B of 50% is 100%. .. In this case, the third packing unit 102d divides 3-2B into 3-2Ba having a floor area ratio of 20% and 3-2Bb having a floor area ratio of 30%, 1-2Bb, 2-1B and 3-2Ba. The carton number "05" is assigned to the carton number "05".

Then, as shown by hatching in the packing result in the lower figure of FIG. 10, the third packing unit 102d has the product code “05” of the numbered carton number “05” and the product code “1-2Bb” having the numbered carton number “05”. Product code "Product C" and floor area ratio "60%" and numbered carton number "05" possessed by 2-1B having "Product B" and floor area ratio "20%" and numbered carton number "05" The product code "product E" and the floor area ratio "20%" possessed by 3-2Ba having the above are stored in the packing instruction data 106c as packing information per carton.

[2-5. Fourth packing process]
The fourth packing unit 102e refers to the order data 106a in FIG. 10 excluding the order detail data in which the carton numbers are assigned in [2-2], [2-3], and [2-4]. The same carton number is assigned to the order detail data in which the product code is different, the carton quantity is different, and the sum of the floor area ratios is equal to or less than a predetermined threshold value (80%). Specifically, in the upper figure of FIG. 10, the sum of the floor area ratio of 3-2Bb of 30%, the floor area ratio of 4-1 of 40%, and the floor area ratio of 5-1 of 70% is 80%. .. In this case, the fourth packing unit 102e divides 5-1 into 5-1A having a floor area ratio of 10% and 5-1B having a floor area ratio of 60%, 3-2Bb, 4-1 and 5-1A. The carton number "06" is assigned to the carton number "06". Further, the fourth packing unit 102e assigns the carton number "07" to the carton number unnumbered 5-1B.

Then, as shown by hatching in the packing result shown in the lower figure of FIG. 11, the fourth packing unit 102e has the product code "06" having the numbered carton number "06" and the product code "3-2Bb having the numbered carton number" 06 ". Product code "Product F" and floor area ratio "40%" possessed by 4-1 having "Product E" and floor area ratio "30%" and numbered carton number "06", and numbered carton number "06" The product code "commodity G" and the floor area ratio "10%" possessed by 5-1A having the above are stored in the packing instruction data 106c as packing information per carton. Further, the fourth packing unit 102e has a product code "07" having a numbered carton number "07" and a product code "5-1B having the numbered carton number" 07 "as shown by hatching in the packing result in the lower figure of FIG. "Product G" and the floor area ratio "60%" are stored in the packing instruction data 106c as packing information per carton.

As described above, by the processing described in the previous item [2-4] and this item [2-5], packing of products having low commonality (those with different keys and product codes), that is, packing with coarse particle size is performed. It means that the performed packing instruction data 106c has been generated.

[2-6. Summary of processing]
As mentioned above, this item [2. By the process described in [Process], finally, the packing instruction data 106c at the lower part of FIG. 11 was generated. The packing instruction data 106c at the lower part of FIG. 11 is data in which the particle size of the packing is gradually coarsened as the carton number increases.

[3. Specific example of processing]
In this item, a specific example of the process according to the present embodiment will be described.

[3-1. Overview]
The functional user of the present invention is, for example, a business unit. The functional utilization timing and outline of the present invention are as follows, for example. That is, packing (piece → carton, carton → pallet) is performed so that a packing instruction can be issued, and the packing result can be adjusted manually. In automatic packing, packing processing is performed from an inventory management unit (piece) to a carton unit.

[3-2. Process flow]
The processing flow of the present invention is, for example, as shown in FIG.

[3-3. Packing number numbering unit]
The packing number is assigned for each item shown in FIG. 3, for example. When the items shown in FIG. 3 are the same, the packing numbers are the same.

[3-4. Prerequisites: About product hierarchy]
The product hierarchy is, for example, three layers shown in FIG. In the packing process, the process is carried out with the idea of packing in units of lower layers (similar product groups).

[3-5. How to number carton numbers]
In the present invention, for example, the floor area ratio is calculated by the formula shown in the next paragraph, and then the carton numbers are numbered from those that can be determined as described in (0) to (3) from the next paragraph. ..

(Calculation formula for calculating floor area ratio)
Floor area ratio = number of orders (PCS) / number of products in carton of product master * The number of carton is the number of PCS in one carton.

(0) Same key (same product in full product number unit)
First, the number of orders for order data with the same key is totaled. Specifically, it is determined that the floor area ratio is 100%, the carton number is assigned, and the fraction is handled in the next process (1).

Key (full part number)
・ Product manager ・ Supplier ・ Product type ・ Representative product number ・ Full product number * The order is alphabetical order of representative product number and full product number.

(1) Items with the same key (products with the same representative product number)
Next, the number of orders for order data with the same key is totaled. Specifically, it is determined that the floor area ratio is 100%, the carton number is assigned, and the fraction is handled in the next process (2).

Key (representative product number)
・ Product management person code ・ Supplier code ・ Product code ・ Representative product number * The order is alphabetical order of full product numbers

(2) Items with different keys but the same number of cartons Next, among those fractionalized in the process of (1), the number of orders for order data with the same number of items in the carton is totaled. Specifically, it is determined that the floor area ratio is 100%, the carton number is assigned, and the fraction is handled in the next process (3).

(3) Items with different carton quantities Finally, the number of orders received for the order data that was a fraction of the process in (2) is totaled. Specifically, carton numbers are assigned so that the floor area ratio does not exceed 80%. The threshold value of 80% can be set differently depending on each company.

Priority ・ Floor area ratio at the time of (2) ・ Product management person code ・ Supplier code ・ Product code ・ Representative product number

[4. Summary of this embodiment]
As described above, according to the packing instruction data generation device 100 according to the present embodiment, it is possible to generate packing instruction data in which the particle size of the packing is gradually coarsened.

Here, in the past, in order to reflect the packing instruction information in the trade documents and the packing instruction, it was troublesome to input the result of the examination outside the system each time in the system.

Therefore, in the present embodiment, the order data and the product are managed by managing what, when, and how many PCS are planned to be exported in the order data, and by managing how many PCS the product enters in 1 C / T in the product master. Packing instruction information is automatically calculated (automatically generated) based on the master, and can be automatically reflected in trade documents and packing instructions. The automatically calculated (automatically generated) packing instruction information can be manually adjusted according to the actual situation at the site.

In this way, by making it possible to calculate (generate) the packing instruction information based on the rules by the system instead of manually, for example, it is possible to make a packing plan early and accurately.

[5. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being performed automatically may be performed manually, or all the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the packing instruction data generation 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, with respect to the processing functions included in the packing instruction data generation device 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the processing described in the present embodiment, and packing instruction data is required. It is read mechanically by the generator 100. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into RAM, and cooperates with a CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the packing instruction data generator 100 via an arbitrary network, and all or a part thereof may be downloaded as needed. It is possible.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in an arbitrary language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. A well-known configuration and procedure can be used for a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the packing instruction data generation 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 an arbitrary peripheral device is connected. Further, the packing instruction data generation device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Further, the specific form of the distribution / integration of the device is not limited to the one shown in the drawing, and all or a part thereof may be functionally or physically in an arbitrary unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is useful, for example, in an industry in which there is an export business, the packing instruction information is examined in-house, and instructions are given to Otsunaka (shipping freight handling company).

100 Packing instruction data generator 102 Control unit
102a Floor area ratio calculation unit
102b First packing section
102c Second packing section
102d Third packing section
102e Fourth packing unit 104 Communication interface unit 106 Storage unit
106a Order data
106b Product master
106c Packing instruction data 108 Input / output interface 112 Input device 114 Output device 200 Server 300 Network

Claims (4)

A packing instruction data generator equipped with a control unit.
The control unit
The volume ratio of the product per carton calculated based on the key data, product identification data, the number of products that can be put in one carton, the number of orders for the product, and the number of products in the carton. With reference to the order data including a plurality of order detail data having the above, the sum of the volume ratios of the order detail data having the same key data and the same product identification data is 100%. On the other hand, the same carton number is assigned, and the product identification data and the volume ratio of the order detail data with the carton number and the same carton number are used as packing instruction data per carton. The first packing means to store in
With reference to the order data excluding the order detail data in which the carton number is assigned by the first packing means, the volume ratio of the order detail data having the same key data but different product identification data. The same carton number is assigned to the sum of 100%, and the product identification data and the volume ratio of the order detail data with the carton number and the same carton number are set to one carton. The second packing means to be stored in the packing instruction data as the packing information of each, and
The key data is different, the product identification data is different, and the carton is different, with reference to the order data excluding the order detail data in which the carton number is assigned by the first packing means and the second packing means. The same carton number is assigned to the order detail data having the same quantity and the sum of the volume ratios is 100%, and the carton number and the same carton number are attached to the order. A third packing means for storing the product identification data and the volume ratio of the detailed data in the packing instruction data as packing information per carton.
The key data is different, and the product identification data is different with reference to the order data excluding the order detail data in which the carton number is assigned by the first packing means, the second packing means, and the third packing means. The same carton number is assigned to the order detail data that is different and the carton quantity is different and the sum of the volume ratios is equal to or less than a predetermined threshold, and the carton number and the same carton number are assigned. A fourth packing means for storing the product identification data and the volume ratio of the order detail data with the mark in the packing instruction data as packing information per carton.
To prepare
A packing instruction data generator characterized by. The control unit
With reference to the product master including the product identification data and the carton quantity, the carton quantity associated with the product identification data included in the order data is acquired, stored in the order data, and included in the order data. The floor area ratio is calculated by multiplying the value obtained by dividing the number of orders by the number of cartons stored in the order data by 100, and the floor area ratio calculation means for storing the calculated floor area ratio in the order data is further provided. ,
The packing instruction data generation device according to claim 1. It is a packing instruction data generation method executed by an information processing device equipped with a control unit.
Executed by the control unit,
The volume ratio of the product per carton calculated based on the key data, product identification data, the number of products that can be put in one carton, the number of orders for the product, and the number of products in the carton. With reference to the order data including a plurality of order detail data having the above, the sum of the volume ratios of the order detail data having the same key data and the same product identification data is 100%. On the other hand, the same carton number is assigned, and the product identification data and the volume ratio of the order detail data with the carton number and the same carton number are used as packing instruction data per carton. The first packing step to store in and
With reference to the order data excluding the order detail data for which the carton number was assigned in the first packing step, the volume ratio of the order detail data having the same key data but different product identification data. The same carton number is assigned to the sum of 100%, and the product identification data and the volume ratio of the order detail data with the carton number and the same carton number are set to one carton. The second packing step to be stored in the packing instruction data as the packing information per, and
The key data is different, the product identification data is different, and the carton is different with reference to the order data excluding the order detail data in which the carton number is assigned in the first packing step and the second packing step. The same carton number is assigned to the order detail data having the same quantity and the sum of the volume ratios is 100%, and the carton number and the same carton number are attached to the order. A third packing step of storing the product identification data and the volume ratio of the detailed data in the packing instruction data as packing information per carton.
The key data is different and the product identification data is different with reference to the order data excluding the order detail data in which the carton number is assigned in the first packing step, the second packing step, and the third packing step. The same carton number is assigned to the order detail data that is different and the carton quantity is different and the sum of the volume ratios is equal to or less than a predetermined threshold, and the carton number and the same carton number are assigned. A fourth packing step of storing the product identification data and the volume ratio of the order detail data with the mark in the packing instruction data as packing information per carton.
Including,
A packing instruction data generation method characterized by. It is a packing instruction data generation program to be executed by an information processing device equipped with a control unit.
To make the control unit execute
The volume ratio of the product per carton calculated based on the key data, product identification data, the number of products that can be put in one carton, the number of orders for the product, and the number of products in the carton. With reference to the order data including a plurality of order detail data having the above, the sum of the volume ratios of the order detail data having the same key data and the same product identification data is 100%. On the other hand, the same carton number is assigned, and the product identification data and the volume ratio of the order detail data with the carton number and the same carton number are used as packing instruction data per carton. The first packing step to store in and
With reference to the order data excluding the order detail data for which the carton number was assigned in the first packing step, the volume ratio of the order detail data having the same key data but different product identification data. The same carton number is assigned to the sum of 100%, and the product identification data and the volume ratio of the order detail data with the carton number and the same carton number are set to one carton. The second packing step to be stored in the packing instruction data as the packing information per, and
The key data is different, the product identification data is different, and the carton is different with reference to the order data excluding the order detail data in which the carton number is assigned in the first packing step and the second packing step. The same carton number is assigned to the order detail data having the same quantity and the sum of the volume ratios is 100%, and the carton number and the same carton number are attached to the order. A third packing step of storing the product identification data and the volume ratio of the detailed data in the packing instruction data as packing information per carton.
The key data is different and the product identification data is different with reference to the order data excluding the order detail data in which the carton number is assigned in the first packing step, the second packing step, and the third packing step. The same carton number is assigned to the order detail data that is different and the carton quantity is different and the sum of the volume ratios is equal to or less than a predetermined threshold, and the carton number and the same carton number are assigned. A fourth packing step of storing the product identification data and the volume ratio of the order detail data with the mark in the packing instruction data as packing information per carton.
Including,
A packing instruction data generation program characterized by.

Images