JP2021068476A - Shipment information management device and shipment information management method and shipment information management program - Google Patents

Abstract

To provide a shipment information management device, a shipment information management method and a shipment information management program by which a person in charge can easily and precisely determine whether a product to be delivered is an up-to-date product.SOLUTION: In this embodiment, a warning display section specifies product information containing information being the same as customer identification information, delivery destination identification information, product identification information, and lot identification information that are input by a user referring to past delivery information including product information containing the customer identification information, the delivery destination identification information, the product identification information, the lot identification information and expiration date information, then displays a warning if expiration date information input by the user is older than the expiration date information contained in the specified product information.SELECTED DRAWING: Figure 1

Description

The present invention relates to a shipping information management device, a shipping information management method, and a shipping information management program.

Patent Document 1 discloses a shipping management system that facilitates shipping management when a renewal item, a campaign item, or the like that has the same contents but has been changed due to a change in packaging or the like occurs (for example). See claim 1, paragraph 0005, etc.).

Japanese Patent No. 4365176

Although the above-mentioned system has made it possible to easily perform shipping management, in recent years there has been a demand for a shipping management system capable of shipping in response to a customer's request. For example, if a customer wants to exclude products older than the previous transaction, the manufacturer's representative will ask if the product being delivered is up-to-date. It is necessary to confirm each time by referring to the record of the previous transaction. However, this confirmation work requires a great deal of labor by the person in charge. So, for example, if the product you are trying to deliver is older than the last transaction, and if a warning is automatically displayed by processing on the system, the person in charge will tell you that the product you are trying to deliver is the latest one. It is possible to easily and accurately determine whether or not the product is.

The present invention has been made in view of the above, and is a shipping information management device that allows a person in charge to easily and accurately determine whether or not the product to be delivered is the latest. Provides a shipping information management method and a shipping information management program.

In order to solve the above-mentioned problems and achieve the object, the shipping information management device according to the present invention is a shipping information management device including a control unit and a storage unit. Past shipping information for managing shipping information is stored, and the past shipping information includes product information including customer identification information, delivery destination identification information, product identification information, lot identification information, and expiration date information. The control unit identifies and inputs the product information including the same as the input customer identification information, delivery destination identification information, product identification information, and lot identification information with reference to the past shipment information. It is characterized in that it includes a warning display means for displaying a warning when the dated expiration date information is older than the expiration date information included in the specified product information.

Further, in the shipping information management device according to the present invention, the control unit refers to the past shipping information and obtains product information including the same as the customer identification information, the delivery destination identification information and the product identification information input. If the identified and further identified product information does not exist in the past shipping information, in addition to the entered customer identification information, delivery destination identification information and product identification information, the entered lot identification information and expiration date New product information including information is added to the past shipping information, and at least one of the input lot identification information and expiration date information is among the lot identification information and expiration date information included in the specified product information. If it is newer than at least one, the entered lot identification information and expiration date information are added to the past shipping information as information included in the specified product information, and the input lot identification information and the entered lot identification information and If the expiration date information is the same as or older than the lot identification information and the expiration date information included in the specified product information, the past shipment information update means that does not make any change to the past shipment information is further added. It is characterized by being prepared.

Further, in the shipping information management device according to the present invention, inventory information for managing information related to inventory is further stored in the storage unit, and the inventory information includes lot identification information and an allottable number. The control unit includes inventory information, and the control unit refers to the past shipping information and includes the same customer identification information, delivery destination identification information, and product identification information included in the input order information. In addition, with reference to the inventory information, each inventory information including the same lot identification information included in the specified product information is specified, and the number of products included in the input order information is When the number is less than or equal to the number that can be allocated included in each of the specified inventory information, it is characterized by further providing an allocation means for performing allocation processing.

Further, the shipping information management method according to the present invention is a shipping information management method executed by an information processing device including a control unit and a storage unit, and the storage unit manages information related to past shipments of products. The past shipping information is stored, and the past shipping information includes product information including customer identification information, delivery destination identification information, product identification information, lot identification information, and expiration date information. With reference to the past shipping information executed by the control unit, product information including the same as the input customer identification information, delivery destination identification information, product identification information and lot identification information is specified and input. It is characterized by including a warning display step for displaying a warning when the expiration date information is older than the expiration date information included in the specified product information.

Further, the shipping information management program according to the present invention is a shipping information management program for being executed by an information processing device including a control unit and a storage unit, and the storage unit stores information on past shipments of products. Past shipping information for management is stored, and the past shipping information includes product information including customer identification information, delivery destination identification information, product identification information, lot identification information, and expiration date information. With reference to the past shipping information to be executed by the control unit, the product information including the same as the input customer identification information, delivery destination identification information, product identification information and lot identification information is specified and input. It is characterized by including a warning display step of displaying a warning when the dated expiration date information is older than the expiration date information included in the specified product information.

According to the present invention, there is an effect that the person in charge can easily and accurately determine whether or not the product to be delivered is the latest one.

FIG. 1 is a block diagram showing an example of the configuration of the shipping information management device. FIG. 2 is a diagram showing an example of a warning display. FIG. 3 is a diagram showing an example of updating past shipping information. FIG. 4 is a diagram showing an example of the allocation process.

Hereinafter, embodiments of the shipping information management device, the shipping information management method, and the shipping information management program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[1. Overview]
In fields such as the pharmaceutical industry and food industry, when delivering products such as reagents and food products manufactured by manufacturers to customers, if unconditional allocation is made from existing inventory, the lot number will be older than the previous transaction. Goods may be reserved. However, since customers often request products with the latest lot number, the person in charge of the manufacturer allocates whether or not the lot number of the product to be allocated is the latest. I checked it one by one from time to time, but this confirmation work required a lot of effort.

Therefore, in the present embodiment, by storing (holding) the final shipping lot number of the product delivered to the customer, the product having a lot number older than the final shipping lot number is not subject to the allocation at the time of allocation. As a result, the labor of the confirmation work can be saved, and the shipping information management that can accurately and stably ship the product having the final shipping lot number to the customer. It provides equipment, shipping information management methods, and shipping information management programs. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
The configuration of the shipping information management 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 shipping information management device 100.

The shipping information management device 100 is a commercially available desktop personal computer. The shipping information management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like on the market. It may be a type information processing device.

As shown in FIG. 1, the shipping information management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the shipping information management device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the shipping information management 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 shipping information management device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet, a LAN (Local Area Network), or the like. The data stored in the storage unit 106, which will be described later, may be stored in the server 200.

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). As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. 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 previous shipment lot information 106a and inventory information 106b as past shipment information. The inventory information 106b is an arbitrary component and may or may not be included in the shipping information management device 100. However, the following [3. It is preferable to include the information because it is necessary information when performing the allocation process described in [Specific example of process].

The past shipment information is an information table for managing information related to the past shipment of products, and specifically, for each product shipped in the past, customer identification information, delivery destination identification information, product identification information, Includes items such as lot identification information and expiration date information. Of these, the customer is the person with whom the product is traded. The delivery destination is the delivery destination of the product. The customer and the delivery destination may be the same party or different parties.

The customer identification information, the delivery destination identification information, the product identification information, the lot identification information, and the expiration date information are information for identifying each product. Therefore, the notation of this information may be any notation as long as it can achieve the purpose of identifying each product, and specifically, it is an identification code such as a list of alphabets and numbers. It may be the actual customer company name, delivery company name, product name, lot number, and expiration date. Regarding the notation of the expiration date, the notation may be only the year, the notation up to the year and month, the notation up to the date, and the time in addition to the date. May be written up to.

The inventory information is an information table for managing information regarding the inventory of goods, and specifically, for each inventory, includes items such as lot identification information and the number that can be allocated. The number that can be reserved is the remaining quantity that can be reserved for goods, and is described in [3. As explained in [Specific example of processing], if the number of products exceeds this quantity, it cannot be reserved. In addition to the above items, the inventory information may include, for example, items such as product identification information and expiration date information. As the specific contents of the lot identification information, the product identification information and the expiration date information in the inventory information, the description of the lot identification information, the product identification information and the expiration date information in the above-mentioned past shipment information can be referred to.

The control unit 102 is a CPU or the like that collectively controls the shipping information management 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. The control unit 102 functionally conceptually (1) refers to the past shipment information, and obtains product information including the same as the input customer identification information, delivery destination identification information, product identification information, and lot identification information. Refer to the warning display unit 102a as a warning display means for displaying a warning when the specified and input expiration date information is older than the expiration date information included in the specified product information, and (2) the past shipping information. Then, the product information including the same as the input customer identification information, delivery destination identification information, and product identification information is specified, and if the specified product information does not exist in the past shipping information, the input is performed. In addition to the customer identification information, the delivery destination identification information, and the product identification information, new product information including the input lot identification information and the expiration date information is added to the past shipping information, and the input lot identification information is added. And if at least one of the expiration date information is newer than at least one of the lot identification information and the expiration date information included in the specified product information, the entered lot identification information and the expiration date information are used. , As the information included in the specified product information, the lot identification information and the expiration date information added to the past shipping information and input are compared with the lot identification information and the expiration date information included in the specified product information. If they are the same or older, they are input with reference to the past shipment information update unit 102b as the past shipment information update means without making any change to the past shipment information, and (3) the past shipment information. The customer identification information, the delivery destination identification information, and the product information including the same product identification information included in the order information are specified, and further, the lot identification information included in the specified product information is referred to by referring to the inventory information. When each inventory information including the same items as is specified and the number of products included in the entered order information is less than or equal to the number of items that can be allocated included in each specified inventory information, as an allocation means for performing allocation processing. It is provided with an allocation unit 102c. The past shipment information update unit 102b and the allocation unit 102c are arbitrary components and may or may not be included in the shipment information management device 100. Specific example of treatment], it is preferable to include it for the reason described in. Further, for details of the processing executed by the warning display unit 102a, the past shipment information update unit 102b, and the allocation unit 102c, see the following [3. Specific example of processing] will be described in detail.

The entered customer identification information, delivery destination identification information, product identification information, lot identification information, and expiration date information are input for the product that the user (for example, the person in charge of delivering the product at the manufacturer) is about to deliver. Information to do. For the specific contents of each of these items, the above-mentioned description of past shipping information can be referred to.

[3. Specific example of processing]
Specific examples of the processing according to the present embodiment will be described in detail with reference to FIGS. 2 to 4. FIG. 2 is a diagram showing an example of a warning display. FIG. 3 is a diagram showing an example of updating past shipping information. FIG. 4 is a diagram showing an example of the allocation process.

[3-1. Warning display]
First, the warning display performed by the warning display unit 102a will be described in detail with reference to FIG. In this item, first, a scene in which a warning is displayed for a product with lot number LOTO103 will be described, and then a scene in which a warning is not displayed for a product with lot number LOTO102 will be described.

First, the scene where the warning is displayed will be described. First, as shown in the order entry screen under the sentence "When sales / order entry is performed under the following conditions" by the person in charge of product delivery at the manufacturer, A0100 is used as a customer. N0001 is input as the delivery destination. Further, although not shown in FIG. 2, Shohin_01 is input in advance as the product name information in the computer. Then, as shown in the order entry screen under the sentence "Warning if older than the previous shipment lot" in FIG. 2, LOTO103 is entered as the lot number and 2015/09/30 is entered as the expiration date. ..

Subsequently, the warning display unit 102a refers to the table of the previous shipment lot of FIG. 2 as the past shipment information, and then refers to the input customer identification information, delivery destination identification information, product identification information, and lot identification information (A0100). , N0001, Shouhin_01 and LOTO103), and product information including the same items is specified as a comparison target. Here, referring to the table of the previous shipment lot in FIG. 2, the first product information from the top is the same as the input customer identification information, delivery destination identification information, product identification information, and lot identification information. Since it is included, it is specified as a comparison target.

Since the input expiration date information (2015/09/30) of the warning display unit 102a is older than the expiration date information (2015/10/31) included in the product information specified as the comparison target, FIG. The text "Warning !!" is displayed at the bottom of the order entry screen under the sentence "Warning if older than the previous shipment lot."

Next, a situation where the warning is not displayed will be described. First, the person in charge of product delivery at the manufacturer displays the order entry screen under the sentence "When sales / order entry is performed under the following conditions" in Fig. 2, and A0100 is set as the delivery destination. , N0002 (although it is N0001 in FIG. 2, it is changed to N0002 by the user) is input. Further, although not shown in FIG. 2, Shohin_01 is input in advance as the product name information in the computer. Then, as shown in the order input screen under the sentence "If it is not older than the previous shipment lot, there is no warning" in FIG. 2, LOTO102 is input as the lot number and 2015/09/30 is input as the expiration date. To.

Subsequently, the warning display unit 102a refers to the table of the previous shipment lot of FIG. 2 as the past shipment information, and then refers to the input customer identification information, delivery destination identification information, product identification information, and lot identification information (A0100). , N0002, Shouhin_01 and LOTO102), and product information including the same items is specified as a comparison target. Here, referring to the table of the previous shipment lot in FIG. 2, the second product information from the top is the same as the input customer identification information, delivery destination identification information, product identification information, and lot identification information. Since it is included, it is specified as a comparison target.

Then, in the warning display unit 102a, the input expiration date information (2015/09/30) is not older than the expiration date information (2015/09/30) included in the product information specified as the comparison target (same date). Therefore, the warning is not displayed as shown in the order input screen in "If it is not older than the previous shipment lot, there is no warning" in FIG.

As described above, according to the shipping information management device 100 according to the present embodiment, when the person in charge of delivering the product inputs the information of the product older than the previous transaction, a warning can be displayed by processing on the system. Therefore, the person in charge can easily and accurately determine whether or not the product to be delivered is the latest.

[3-2. Past shipping information update]
Next, the update of the past shipment information performed by the past shipment information update unit 102b will be described in detail with reference to FIG.

The update of the past shipment information means that at least one of the following three processes is performed. The first process is when the product information including the same as the input customer identification information, delivery destination identification information and product identification information cannot be specified by referring to the past shipment information (that is, the product information to be specified). However, in addition to the input customer identification information, delivery destination identification information, and product identification information, new product information including the input lot identification information and expiration date information is added. , This is a process of adding to the past shipment information (all information addition process). The second process refers to the past shipping information to identify the input customer identification information, the delivery destination identification information, and the product information including the same product identification information, and further, the input lot identification. If at least one of the information and the expiration date information is newer than at least one of the lot identification information and the expiration date information included in the specified product information, the input lot identification information and the expiration date information are entered. Is a process (partial information addition process) of adding the information to the past shipment information as the information included in the specified product information. The third process refers to the past shipping information to identify the product information including the same as the input customer identification information, delivery destination identification information, and product identification information, and further, the input lot identification. If the information and expiration date information are the same as or older than the lot identification information and expiration date information included in the specified product information, processing that does not change the past shipping information (unchanged processing) Is. As described above, the update of the past shipment information means that at least one of the above three processes is performed. Therefore, as the update of the past shipment information, one of the three processes is performed. Only one process may be performed, only two processes may be performed, or all three processes may be performed. However, in the following, the all information addition process and the partial information addition process may be performed. , The case where all three processes of the above-mentioned unchanged process are performed and the past shipment information is updated will be described in this order.

(Additional processing of all information)
First, all information addition processing will be described.

First, as shown in the second product information (slip No. 102) from the top of the shipping information table at the lower left of FIG. 3, A0100 is set as the delivery destination by the person in charge of delivering the product at the manufacturer. , N0002, Shoehin_01 as the product name, LOTO102 as the lot number, and 2015/09/30 as the expiration date are input.

Subsequently, the past shipment information update unit 102b refers to the previous shipment lot table in the upper right of FIG. 3 as the past shipment information, and the input customer identification information, delivery destination identification information, and product identification information (A0100, Product information including the same items as N0002 and Shouhin_01) is specified as a comparison target. Here, since none of the products in the previous shipment lot table on the upper right of FIG. 3 includes the same as the input customer identification information, delivery destination identification information, and product identification information, the product information to be specified is in the past. Not present in shipping information.

In this case, the past shipment information update unit 102b adds the input customer identification information (A0100), delivery destination identification information (N0002), and product identification information (Shouhin_01) to the input lot identification information (LOTO102). And new product information including expiration date information (2015/09/30), that is, all information of the product information of the delivered product is added to the previous shipment lot table in the upper right of FIG. 3 as past shipment information. The added product information is the second product information from the top in the updated previous shipment lot table at the lower right of FIG.

(Partial information addition processing)
Next, a partial information addition process will be described.

First, as shown in the first product information (slip No. 101) from the top of the shipping information table at the lower left of FIG. 3, A0100 is set as the delivery destination by the person in charge of delivering the product at the manufacturer. , N0001 is entered as the trade name, Shoehin_01 is entered, LOTO103 is entered as the lot number, and 2015/10/31 is entered as the expiration date.

Subsequently, the past shipment information update unit 102b refers to the previous shipment lot table in the upper right of FIG. 3 as the past shipment information, and the input customer identification information, delivery destination identification information, and product identification information (A0100, Product information including the same items as N0001 and Shohin_01) is specified as a comparison target. Here, referring to the previous shipment lot table on the upper right of FIG. 3, the first product information from the top includes the same customer identification information, delivery destination identification information, and product identification information that have been input. Specified for comparison.

The entered lot identification information (LOTO103) and expiration date information (2015/10/31) are both lot identification information (LOTO102) and expiration date information (2015/09) included in the product information specified as the comparison target. New compared to / 30).

In this case, the past shipment information update unit 102b uses the input lot identification information (LOTO103) and expiration date information (2015/10/31), that is, a part of the product information of the delivered product as the past shipment information. Add to the previous shipment lot table in the upper right of Fig. 3. The added lot identification information and expiration date information are the previous lot (LOTO103) and the previous expiration date (2015/10 /) of the first product information from the top in the updated previous shipment lot table at the lower right of FIG. It is the item of 31).

In addition, along with this partial information addition processing, the lot identification information (LOTO102) and the expiration date information (2015 /) included in the first product information from the top of the previous shipment lot table in the upper right of FIG. 3 specified as the comparison target. 09/30) is old information, but it is not deleted when some information is added, and the lot before the first product information from the top of the updated previous shipment lot table in the lower right of FIG. And you may move to the item of the expiration date two times before and store it. As a result, the person in charge of the product can not only know the latest lot identification information and expiration date information about a certain product by referring to the past shipping information, but also know the one old lot identification information and expiration date information. it can. Therefore, for example, when a customer requests delivery of a product having an older lot number or expiration date, the person in charge can quickly and surely deal with it.

Further, in this example, a case where both the input lot identification information and the expiration date information are newer than the lot identification information and the expiration date information in the product information specified in the past shipping information has been described. In the case of, some information addition processing may be performed. That is, the input expiration date information is the same as the expiration date information included in the product information specified by referring to the past shipping information, but the entered lot identification information is included in the specified product information. This is a case that is newer than the lot identification information. As a result, for example, since the products are manufactured on the same day, the expiration date is the same, but the manufacturing time and the manufacturing line are different, so even if there are new products and old products with lot numbers, the latest products (lots). It is possible to add the product information of the product with a new number) to the past shipping information.

(Unchanged processing)
Finally, the unchanged processing will be described.

First, as shown in the third product information (slip No. 103) from the top of the shipping information table at the lower left of FIG. 3, A0100 is set as the delivery destination by the person in charge of delivering the product at the manufacturer. , N0001 is entered as the trade name, Table_02, the lot number is entered as LOTO200, and the expiration date is entered as 2016/2/1.

Subsequently, the past shipment information update unit 102b refers to the previous shipment lot table in the upper right of FIG. 3 as the past shipment information, and the input customer identification information, delivery destination identification information, and product identification information (A0100, N0001). And Shouhin_02), the product information including the same information is specified as a comparison target. Here, referring to the previous shipment lot table on the upper right of FIG. 3, the second product information from the top includes the same as the input customer identification information, delivery destination identification information, and product identification information. Specified for comparison.

The entered lot identification information (LOTO200) and expiration date information (2016/2/1) are both lot identification information (LOTO201) and expiration date information (2016/4) included in the product information specified as the comparison target. It is older than / 1).

In this case, the past shipment information update unit 102b does not make any change to the previous shipment lot table in the upper right of FIG. 3 as the past shipment information.

In this example, the case where the input lot identification information and expiration date information are older than the lot identification information and expiration date information in the product information specified in the past shipping information has been described, but the input lot Even if the identification information and the expiration date information are the same as the lot identification information and the expiration date information in the product information specified in the past shipment information, no change may be made to the past shipment information.

(Update of past shipping information)
As described above, in this example, all three processes of the total information addition process, the partial information addition process, and the unchanged process are performed, and the previous shipment lot table in the upper right of FIG. 3 as the past shipment information is displayed. It is updated to the previous shipment lot table at the lower right of FIG. 3 as new past shipment information.

As described above, the shipping information management device 100 according to the present embodiment can automatically reflect the information in the latest transaction in the past shipping information, including the past shipping information updating unit 102b. This eliminates mistakes such as the person in charge forgetting to reflect the latest transaction information in the past shipping information, and delivers the latest products to customers more efficiently and more reliably. be able to.

[3-3. Reserve]
Finally, the allocation made by the allocation unit 102c will be described in detail with reference to FIG. In this item, first, the situation where the allocation is made will be explained, then the situation where the allocation is not made, and finally, the situation where the allocation by division is made will be explained.

First, the situation where the allocation is made will be described. First, the person in charge of delivering the product at the manufacturer determines the slip No. 4 in FIG. As shown in the order information table of J101, A0100 is input as a customer, N0001 is input as a delivery destination, Shohin_01 is input as a product name, and 80 is input as the number of products (quantity).

Subsequently, the allocation unit 102c refers to the previous shipment lot table of FIG. 4 as the past shipment information, and the customer identification information, the delivery destination identification information, and the product identification information (A0100, N0001) included in the input order information. And Shouhin_01), identify the product information including the same one. Here, referring to the previous shipment lot table of FIG. 4, since the first product information from the top includes the same customer identification information, delivery destination identification information, and product identification information that have been input, this is specified. It becomes the product information to be done.

Then, the allocation unit 106c identifies each inventory information including the same lot identification information (LOTO103) included in the specified product information with reference to the inventory information. Here, referring to the inventory information of FIG. 4, since the third inventory from the top includes the same lot identification information (LOTO103) as the lot identification information (LOTO103) included in the specified product information, this is specified. It becomes each inventory information.

Further, since the number of products (80) included in the input order information is equal to or less than the number of items (100) that can be reserved included in each of the specified inventory information, the allocation unit 102c performs the allocation process. When the allocation process is performed, the slip No. 4 in FIG. 4 is displayed. From the order information table of J101, as shown on the right side of the arrow, a table is created in which the items of the lot number (allocated lot) of the allocated inventory and the number of allocated products (quantity) are added to the right column of this table.

In addition, the slip No. of FIG. 4 The scene shown in the order information table of J103 can also be allocated by the same method. That is, the number of products (150) entered in the third order information table from the top on the left side of FIG. 4 becomes the specified inventory information (second inventory from the top in the inventory information of FIG. 4, LOTO 102). Since the number of possible allocations (200) or less is included, the allocation processing can be performed.

Next, the situation where the allocation is not made will be described. First, the person in charge of delivering the product at the manufacturer determines the slip No. 4 in FIG. As shown in the order information table of J102, A0100 is input as a customer, N0001 is input as a delivery destination, Shohin_01 is input as a product name, and 150 is input as the number of products (quantity).

The customer identification information, the delivery destination identification information, and the product identification information (A0100, N0001, and Shouhin_01) included in the input order information are the same as those in the above-mentioned situation where the allocation is made. The third inventory (LOTO103) is the specified inventory information.

The allocation unit 102c cannot make an allocation because the number of products (150) included in the input order information exceeds the number of allocations (100) included in each of the specified inventory information.

Finally, the situation where the provision by division is performed will be described. First, the person in charge of delivering the product at the manufacturer determines the slip No. 4 in FIG. As shown in the order information table of J104, A0100 is input as a customer, N0002 is input as a delivery destination, Shohin_01 is input as a product name, and 300 is input as the number of products (quantity).

By the same method as the above-mentioned allocation, the second product information from the top of the previous shipment lot table in FIG. 4 becomes the product information specified, and the second inventory from the top of the inventory information in FIG. 4 becomes the product information. (LOTO102) is each specified inventory information.

The allocation unit 102c cannot make an allocation because the number of products (300) included in the input order information exceeds the number of allocations (200) included in each of the specified inventory information. However, in the inventory information, there is newer inventory information (LOTO103) than each identified inventory information (LOTO102). In this way, each inventory information newer than each specified inventory information exists, and "the number of products included in the input order information (300) ≤ the number of items that can be allocated in each specified inventory information (LOTO102) (LOTO102). In the case of "200) + the number of allocations (100) in each newer inventory information (LOTO103)", the allocation unit 102c divides the allocation, that is, allocates from both the inventory of LOTO102 and the inventory of LOTO103. It can be performed. When the allocation process is performed, the slip No. 4 in FIG. 4 is displayed. From the order information table of J104, as shown on the right side of the arrow, a table is created on the right side of this table by adding the items of the lot number (allocated lot) of the allocated inventory and the number of allocated products (quantity).

As described above, the shipping information management device 100 according to the present embodiment automatically determines whether or not the allocation from the final shipping lot is possible based on the inventory information, including the allocation unit 102c, and when it is possible. Can automatically perform the allocation process, so that the labor and time required for the person in charge to perform the allocation process can be reduced, and human error that occurs during the allocation process can be eliminated.

[4. 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 automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part thereof 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 shipping information 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, with respect to the processing functions included in the shipping information management device 100, particularly each processing function performed by the control unit 102, 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 process described in the present embodiment, and shipping information management is performed as necessary. It is read mechanically by the device 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and cooperates with the CPU to form a control unit.

Further, this computer program may be stored in the application program server connected to the shipping information management device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. Is.

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), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

The "program" is a data processing method described in any 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. It should be noted that well-known configurations and procedures can be used for the specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, the installation procedure after reading, and the like.

Various databases and the like stored in the storage unit 106 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 shipping information 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 an arbitrary peripheral device is connected. Further, the shipping information management 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 particularly useful in fields such as the pharmaceutical industry and the food industry.

100 Shipping information management device
102 Control unit
102a Warning display
102b Past shipping information update department
102c Reserve
104 Communication interface section
106 Storage
106a Last shipment lot information
106b Inventory information
108 Input / output interface section
112 Input device
114 Output device 200 Server 300 Network

Claims (1)

A shipping information management device equipped with a control unit and a storage unit.
In the storage unit, past shipment information for managing information on past shipments of goods and past shipment information
Inventory information for managing inventory information and
Is stored,
The past shipping information includes product information including customer identification information, delivery destination identification information, product identification information, lot identification information, and expiration date information.
The inventory information includes each inventory information including lot identification information and available quantity.
The control unit
With reference to the past shipping information, product information including the same as the input customer identification information, delivery destination identification information, product identification information and lot identification information is specified, and the input expiration date information is the identification. A warning display means that displays a warning when the product information is older than the expiration date information included in the product information.
With reference to the past shipping information, the customer identification information, the delivery destination identification information, and the product information including the same as the product identification information included in the input order information are specified, and further, the inventory information is referred to. , Each inventory information including the same lot identification information included in the specified product information is specified, and the number of products included in the input order information is equal to or less than the allocateable number included in each specified inventory information. If, the allocation means for performing the allocation process and
To prepare
A shipping information management device characterized by this.

Images