Expiry date management device, expiration date management method, and expiration date management program

Abstract

To efficiently ship commodities when expiration date is set for each destination which is a combination of a client and a shipping destination.SOLUTION: An expiration date management apparatus includes: a master which registers data for calculating expiration date range for each commodity and each destination which is a combination of a client and a shipping destination; order input means which inputs order information including a destination and a commodity; allocation means which calculates an expiration date range by referring to the master regarding the destination and the commodity in the order information, and allocates inventory that falls within a product-specific expiration date and within the calculated expiration date range, for a commodity in inventory information.SELECTED DRAWING: Figure 1

Description

[Technical field]

[0001] The present invention relates to an expiration date management device, an expiration date management method, and an expiration date management program. [Background technology]

[0002] For example, chemical manufacturers and the like have set permissible expiration dates for each destination, which is a combination of a customer and a delivery destination. In this case, in addition to the expiration date set in-house as inventory information, it is necessary to check the expiration date for each destination to determine whether shipment is possible. For example, Patent Document 1 is an example of a system for managing the expiration date of inventory. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] JP 2009-245217 A Summary of the Invention [Problem to be solved by the invention]

[0004] However, the above-mentioned Patent Document 1 does not disclose anything about making shipping operations more efficient when the expiration date of a product is determined for each destination, which is a combination of a customer and a delivery destination.

[0005] The present invention has been made in consideration of the above, and aims to provide an expiration date management program that can streamline shipping operations when product expiration dates are set for each destination, which is a combination of a customer and a delivery destination. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the objective, the present invention provides an expiration date management device equipped with a memory unit and a control unit, wherein the memory unit stores a master that registers data for calculating an expiration date range by destination and product, which is a combination of a customer and a delivery destination, and inventory information including product-specific expiration dates, which are the quality assurance deadlines for each inventory of products, and the control unit comprises an order input means for inputting order information including the destination and product, and an allocation means for calculating an expiration date range for the destination and product of the order information by referring to the master, and for the products that are the subject of the inventory information, allocating inventory that is within the expiration date for each product and within the calculated expiration date range.

[0007] In addition, according to one aspect of the present invention, when there are multiple items of inventory that are within the product-specific expiration date and fall within the calculated expiration date range, the allocation means may allocate the inventory with the oldest product-specific expiration date.

[0008] In addition, according to one aspect of the present invention, the data for calculating the validity period of the master includes a starting date, a unit for calculating the validity period range, and an validity period calculation value for calculating the upper and lower limits of the validity period range, and the allocation means may calculate the validity period range by obtaining the starting date, the unit for calculating the validity period range, and the validity period calculation value from the master using the destination and product of the order information as keys.

[0009] According to another aspect of the present invention, the starting date may be a scheduled shipping date or a scheduled arrival date.

[0010] The unit may be the number of months or the number of days.

[0011] In addition, in order to solve the above-mentioned problems and achieve the objective, the present invention provides an expiration date management method to be executed by an information processing device equipped with a control unit and a memory unit, wherein the memory unit stores a master that registers data for calculating an expiration date range by destination and product, which is a combination of a customer and a delivery destination, and inventory information including an expiration date by product, which is a quality assurance period for each inventory of the product, and the method includes an order input process executed by the control unit, for inputting order information including the destination and the product, and an allocation process that calculates an expiration date range for the destination and product of the order information by referring to the master, and allocates inventory for the product that is the subject of the inventory information that is within the expiration date by product and within the calculated expiration date range.

[0012] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides an expiration date management program to be executed by an information processing device having a control unit and a memory unit, wherein the memory unit stores a master that registers data for calculating an expiration date range by destination and product, which is a combination of a customer and a delivery destination, and inventory information including the expiration date by product, which is the quality assurance period for each inventory of the product, and the control unit executes an order input process for inputting order information including the destination and the product, and an allocation process for calculating the expiration date range for the destination and product of the order information by referring to the master, and allocating inventory within the calculated expiration date range for the product that is the subject of the inventory information. Effect of the Invention

[0013] According to the present invention, when the expiration date of a product is determined for each destination, which is a combination of a customer and a delivery destination, it is possible to improve the efficiency of shipping operations. [Brief description of the drawings]

[0014] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of an expiration date management device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of the configuration of the delivery condition master. [Diagram 3] FIG. 3 is a flowchart for explaining the overall process flow of the control unit of the validity period management device according to the present embodiment. [Figure 4] FIG. 4 is a diagram for explaining a specific example of the process of the control unit of the validity period management device according to the present embodiment. [Diagram 5] FIG. 5 is a diagram for explaining a specific example of the process of the control unit of the validity period management device according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0015] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0016] [1. Overview] For example, chemical manufacturers and the like may determine, in addition to the expiration date that is the quality guarantee period of a product, an allowable range of expiration dates for each destination, which is a combination of a customer and a delivery destination.

[0017] Specifically, for example, even if the customer is the same, the place where the goods are delivered (delivery destination) may be different, and a different validity period range may be set for each delivery destination. For example, a customer may be "XX Trading Co.", and its delivery destinations may be "△△ Sales Office," "□□ Branch," "XX Warehouse," etc., and a different validity period range may be set for each delivery destination.

[0018] In such a case, when shipping inventory, it is necessary to determine whether shipment is possible by determining the expiration date range for each destination in addition to the expiration date for each product, which is the quality assurance date.

[0019] However, in the past, inventory information was managed separately for each product's expiration date and for the range of expiration dates that could be shipped by destination, which meant that it took time to select the products to be shipped.In addition, it was not possible to use first-in, first-out ordering starting from the oldest item, which meant that there was an issue of having slow-moving inventory (items that were close to their expiration date (including expired items)).

[0020] In this embodiment, when the permissible expiration date range of a product is determined for each destination, which is a combination of a customer and a delivery destination, in order to streamline shipping operations, not only the expiration date for each product managed as inventory information but also the expiration date range for each destination and product is stored in master data, and allocation processing is automated. Specifically, in this embodiment, (1) inventory within the expiration date range for products that can be shipped for each destination and product is allocated (shipped), and (2) if there is multiple inventory that satisfies (1), the inventory with the oldest expiration date is allocated (shipped).

[0021] In this way, by realizing automatic allocation processing, it is possible to streamline shipping operations. In addition, it is possible to realize a first-in, first-out system starting with the oldest item while satisfying the requirements for each destination, and to avoid having unnecessary backlogged inventory.

[0022] This embodiment is widely applicable when expiration date management is required when shipping a product, and is applicable to various industries such as chemicals (including intermediate products and finished products), food, cosmetics, pharmaceuticals, etc. In this specification, the term "expiration date" is used to include "best before date", and for example, when the product is a "food product", the expiration date is replaced with the best before date.

[0023] [2. Configuration] An example of an expiration date management device according to the present embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the expiration date management device according to the present embodiment. In FIG. 1, the expiration date management device 100 is, for example, a commercially available desktop personal computer. Note that the expiration date management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer. The expiration date management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the expiration date management device 100 is connected to be able to communicate with each other via an arbitrary communication path.

[0024] The communication interface unit 104 communicatively connects the expiration date management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the expiration date management device 100 and the server 200 etc. so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

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

[0026] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, optical disks, etc. can be used as the storage unit 106.

[0027] The storage unit 106 includes a delivery condition master 106a, an inventory file 106b, and a data file 106c. Fig. 2 is a diagram showing an example of the configuration of the delivery condition master 106a.

[0028] The delivery condition master 106a is a master for registering data for calculating the expiration date range by destination, which is a combination of a customer and a delivery destination, and by product. The delivery condition master 106a can be configured as a table or the like in which data for destination (customer, delivery destination), product, starting date (scheduled shipping date or scheduled arrival date), expiration date calculation unit (months or days), and expiration date calculation value (lower limit, upper limit) are associated and registered, as shown in FIG. 2. The "starting date" is the scheduled shipping date or scheduled arrival date. The "expiration date calculation unit" specifies the unit for specifying the lower limit to the upper limit of the expiration date range, and is specified in months or days. Here, the reason why the expiration date can be specified as a range (not only the lower limit but also the upper limit) is that, for example, when a product is just completed, the ingredients are unstable, and some destinations dislike this, and it is necessary to ship products that have a certain curing period guaranteed.

[0029] In the example shown in Figure 2, the customer is "A Trading Co.," the delivery destination is "P Warehouse," the product is "X Product," the start date is "Scheduled Arrival Date," the expiration date calculation unit is "Number of months," the expiration date calculation value (lower limit) is "2," and the expiration date calculation value (upper limit) is "6."

[0030] The inventory file 106b is a file for storing inventory information. The inventory information may include, for example, data on the product, lot number, manufacturing date, and expiration date for each product, which is the quality assurance period for each inventory (for example, a predetermined period from the manufacturing date).

[0031] The data file 106c is a file for storing various data such as order information, etc. The order information may include data such as an order number, a destination (customer, delivery destination), a product, an order quantity, a scheduled shipping date, and a scheduled arrival date.

[0032] Returning to Fig. 1, the control unit 102 is a CPU or the like that performs overall control of the expiration date management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. The control unit 102 conceptually includes an inventory management unit 102a, an order input unit 102b, an allocation processing unit 102c, a master maintenance unit 102d, and a screen display control unit 102e in terms of functions.

[0033] The inventory management unit 102a inputs and updates inventory information in response to, for example, an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers and updates the inventory information in the inventory file 106b.

[0034] The order input unit 102b inputs and updates order information in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers and updates the order information in the data file 106c.

[0035] The allocation processing unit 102c calculates the expiration date range for the destination and product of the order information by referring to the delivery condition master 106a, and automatically allocates inventory within the calculated expiration date range for the target product of the inventory information. When there are multiple items of inventory within the calculated expiration date range for each product, the allocation processing unit 102c may allocate the inventory with the oldest product expiration date.

[0036] The data for calculating the validity period range in the delivery condition master 106a includes the starting date, the validity period calculation unit for calculating the validity period range, and the validity period calculation value for calculating the lower and upper limits of the validity period range, and the allocation processing unit 102c may calculate the validity period range by acquiring the starting date, the validity period calculation unit, and the validity period calculation value from the delivery condition master 106a using the destination and product of the order information as keys. The starting date may be the scheduled shipping date or the scheduled arrival date. The validity period calculation unit may be the number of months or the number of days.

[0037] The master maintenance section 102d is for performing editing such as inputting, adding, and changing data for the delivery condition master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 112, for example.

[0038] The screen display control unit 102e controls, for example, the display of various screens (for example, an input screen, a master maintenance screen, etc.) displayed on the monitor 112 and the reception of inputs therefor.

[0039] [3. Specific Examples] A specific example of the processing of the validity period management device 100 according to the present embodiment will be described with reference to Fig. 1 to Fig. 5. Fig. 3 is a diagram illustrating a flow of the overall processing of the validity period management device 100 according to the present embodiment. Figs. 4 and 5 are diagrams illustrating a specific example of the processing of the control unit of the validity period management device 100 according to the present embodiment.

[0040] The overall process flow of the expiration date management device 100 according to the present embodiment will be described with reference to Fig. 3. In Fig. 3, the master maintenance unit 102d executes master maintenance processing (step S1). Specifically, in the master maintenance processing, the master maintenance unit 102d sets data in the delivery condition master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 112, for example.

[0041] The order input unit 102b executes an order input process (step S2). Specifically, in the order input process, the order input unit 102b inputs order information in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, for example, and registers the information in the data file 106c.

[0042] The allocation processing unit 102c executes the allocation process (step S3). Specifically, in the allocation process, for the destination and product of the order information, the delivery condition master 106a is referenced to calculate the expiration date range, and for the target product of the inventory information, the allocation processing unit 102c automatically allocates the inventory within the product-specific expiration date and the calculated expiration date range. In addition, when there are multiple inventory items within the product-specific expiration date and the calculated expiration date range, the allocation processing unit 102c may allocate the inventory with the oldest product-specific expiration date.

[0043] Next, a specific example of the process of the control unit of the validity period management device 100 according to the present embodiment will be described with reference to FIG. 4 and FIG.

[0044] (Master maintenance processing) The master maintenance unit 102d sets data in the delivery condition master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 112, for example.

[0045] In the example of delivery condition master 106a shown in Figure 4 (A), the customer is "A Trading Company", the delivery destination is "P Warehouse", the product is "X Product", the starting date is "Scheduled Arrival Date", the expiration calculation unit is "Number of months", the expiration calculation value (lower limit) is "2", and the expiration calculation value (upper limit) is "6". The "starting date" is the scheduled shipping date or the scheduled arrival date. The "expiration calculation value" specifies the unit for specifying the expiration range (lower limit to upper limit) and is specified in months or days.

[0046] Next, the calculation logic for the expiration date range (lower limit to upper limit) will be explained. Figure 4 (B) is a diagram for explaining the case where the expiration date calculation unit is "number of months". The date obtained by adding the expiration date calculation value by months to the starting date is calculated as the expiration date range. If the starting date is "2020 / 03 / 31", the expiration date calculation unit is "number of months", and the expiration date calculation value (lower limit) is "2", the expiration date calculation value (lower limit) of "2" months is added to the starting date of "2020 / 03 / 31" to obtain the expiration date range (lower limit) of "2020 / 05 / 31". The same addition is made for the upper limit.

[0047] FIG. 4(C) is a diagram for explaining the case where the expiration calculation unit is "number of days." The date obtained by adding the expiration calculation value by the number of days to the starting date is calculated as the expiration range. If the starting date is "2020 / 03 / 31", the expiration calculation unit is "number of days", and the expiration calculation value (lower limit) is "10", the expiration calculation value (lower limit) of "10" days is added to the starting date of "2020 / 03 / 31" to obtain the expiration range (lower limit) of "2020 / 04 / 10". The same addition is made for the upper limit.

[0048] (Allocation processing) The allocation processing unit 102c calculates the expiration date range for each destination and product for the destination and product of the order information by referring to the delivery condition master 106a, and for the product that is the subject of the inventory information, allocates inventory that is within the expiration date for each product and within the calculated expiration date range for each destination and product, and if there are multiple items of inventory that are within the expiration date for each product and within the calculated expiration date range for each destination and product, allocates the inventory with the oldest expiration date.

[0049] In the example of order information shown in Figure 5 (A), the product is "X Product", the customer is "A Trading Company", the delivery destination is "P Warehouse", the scheduled shipping date is "2020 / 11 / 2", and the scheduled shipping date is "2020 / 11 / 6".

[0050] In the example of the delivery condition master 106a shown in FIG. 5(B), the customer is “A Trading Company”, the delivery destination is “P Warehouse”, the product is “X Product”, the starting date is “Scheduled Arrival Date”, the expiration calculation unit is “Number of months”, the expiration calculation value (lower limit) is “2”, and the expiration calculation value (upper limit) is “6”.

[0051] In this case, the validity period ranges for the customer "A Trading", delivery destination "P Warehouse", and product "X Product" are as shown in Fig. 5(C). Specifically, the allocation processing unit 102c uses the destination of the order information "Customer "A Trading", delivery destination "P Warehouse"" and product "X Product" as keys to obtain the starting date "Scheduled Arrival Date", validity period calculation unit "Number of months", validity period calculation value (lower limit) "2", and validity period calculation value (upper limit) "6" from the delivery condition master 106a. The allocation processing unit 102c adds the expiration calculation value (lower limit) of "2" months to the "scheduled arrival date 2020 / 11 / 6" of the inventory information, which is the starting date, to calculate the expiration range (lower limit) of "2021 / 1 / 6", and also adds the expiration calculation value (upper limit) of "6" months to the "scheduled arrival date 2020 / 11 / 6" of the inventory information, which is the starting date, to calculate the expiration range (upper limit) of "2021 / 5 / 6".

[0052] In the example of inventory information shown in Figure 5 (D), the first line has the product "X product", lot number "LOT001", manufacturing date "2020 / 7 / 15", and expiration date (by product) "2020 / 10 / 15". The second line has the product "X product", lot number "LOT002", manufacturing date "2020 / 8 / 1", ​​and expiration date (by product) "2020 / 11 / 1". The third line has the product "X product", lot number "LOT003", manufacturing date "2020 / 9 / 3", and expiration date (by product) "2020 / 12 / 3".

[0053] The fourth line has the product "X Product", lot number "LOT004", manufacturing date "2020 / 10 / 12", and expiration date (by product) "2021 / 1 / 12", the fifth line has the product "X Product", lot number "LOT005", manufacturing date "2020 / 10 / 27", and expiration date (by product) "2021 / 1 / 27", and the sixth line has the product "X Product", lot number "LOT006", manufacturing date "2020 / 11 / 2", and expiration date (by product) "2021 / 2 / 2".

[0054] The allocation processing unit 102c allocates the inventory information based on the product-specific expiration date, and from among the inventory that is within the product-specific expiration date range "2021 / 01 / 6" to "2021 / 05 / 6" for the calculated destination (customer "A Trading Company", delivery destination "P Warehouse") and product "X Product", the inventory with the oldest product-specific expiration date.

[0055] The first and second lines cannot be allocated (cannot be shipped) because the expiration date for each product has expired (defective products). The third line cannot be allocated (cannot be shipped) because it is outside the expiration date range for each destination and product. Lines 4 to 6 are within the expiration date for each product and are within the expiration date range for each destination and product. Of these, the expiration date (by product) for line 4 is "2021 / 1 / 12", making it the oldest product, so this inventory will be allocated.

[0056] As described above, according to this embodiment, there are provided a delivery condition master 106a in which data for calculating the validity period range is registered for each destination and product, which is a combination of customer and delivery destination, an order input unit 102b for inputting order information including the destination and product, and an allocation processing unit 102c for calculating the validity period range for the destination and product of the order information by referring to the delivery condition master 106a, and for the target product of the inventory information, for which the validity period is within the product-specific validity period and within the calculated validity period range, so that it is possible to streamline shipping operations when the validity period of a product is determined for each destination, which is a combination of customer and delivery destination.

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

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

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

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

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

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

[0063] Moreover, with regard to the validity period management device 100, each of the components shown in the figures is merely a functional concept, and the device does not necessarily have to be physically configured as shown in the figures.

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

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

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

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

[0068] The various databases etc. stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

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

[0070] Furthermore, the specific form of distribution and integration of the devices is not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]

[0071] 100 Expiration date management device 102 Control section 102a Inventory Control Department 102b Order entry section 102c Allocation processing section 102d Master Maintenance Department 102e Screen display control unit 104 Communication interface section 106 Storage section 106a Delivery condition master 106b Inventory File 106c Data File 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. An expiration date management device for managing the expiration date of a product that needs to be shipped after a certain curing period, the device comprising a memory unit and a control unit, The storage unit includes: A master that registers data for calculating the expiration date range by destination (combination of customer and delivery destination) and by product, Inventory information including product-specific expiration dates, which are the quality assurance periods for each item in stock; is stored, The control unit is An order input means for inputting order information including a destination and a product; an allocation means for calculating an expiration date range for the destination and product of the order information by referring to the master, and for the target product of the inventory information, allocating inventory within the expiration date for each product and within the calculated expiration date range; Equipped with The data for calculating the validity period of the master includes a starting date, a unit for calculating the validity period range, and a validity period calculation value for calculating the upper and lower limits of the validity period range, The allocation means is characterized in that it calculates the expiration date range by obtaining the starting date, the unit for calculating the expiration date range, and the expiration date calculation value from the master using the destination and product of the order information as keys, and calculates the expiration date range.

2. 2. The expiration date management device according to claim 1, wherein, when there are a plurality of items of inventory within the expiration date of each product and within the calculated expiration date range, the allocation means allocates the inventory with the oldest expiration date of each product.

3. 3. The expiration date management device according to claim 1, wherein the starting date is a scheduled shipping date or a scheduled arrival date.

4. 4. The expiration date management device according to claim 1, wherein the unit is the number of months or the number of days.

5. An expiration date management method executed by an expiration date management device that includes a control unit and a storage unit and that manages the expiration date of a product that needs to be shipped after a certain curing period is guaranteed, The storage unit includes: A master that registers data for calculating the expiration date range by destination (combination of customer and delivery destination) and by product, Inventory information including product-specific expiration dates, which are the quality assurance periods for each item in stock; is stored, Executed in the control unit, an order input process for inputting order information including a destination and a product; an allocation process of calculating an expiration date range for the destination and product of the order information by referring to the master, and allocating inventory within the expiration date for each product and within the calculated expiration date range for the target product of the inventory information; Including, The data for calculating the validity period of the master includes a starting date, a unit for calculating the validity period range, and a validity period calculation value for calculating the upper and lower limits of the validity period range, The allocation process is an expiration date management method characterized in that the destination and product of the order information are used as keys to obtain the starting date, the unit for calculating the expiration date range, and the expiration date calculation value from the master, and calculate the expiration date range.

6. An expiration date management program to be executed by an expiration date management device that includes a control unit and a storage unit and that manages the expiration date of a product that needs to be shipped after a certain curing period is guaranteed, The storage unit includes: A master that registers data for calculating the expiration date range by destination (combination of customer and delivery destination) and by product, Inventory information including product-specific expiration dates, which are the quality assurance periods for each item in stock; is stored, The control unit, an order input process for inputting order information including a destination and a product; an allocation process of calculating an expiration date range for the destination and product of the order information by referring to the master, and allocating inventory within the expiration date for each product and within the calculated expiration date range for the target product of the inventory information; This is an expiration date management program for executing The data for calculating the validity period of the master includes a starting date, a unit for calculating the validity period range, and a validity period calculation value for calculating the upper and lower limits of the validity period range, The allocation process is characterized by an expiration date management program that uses the destination and product of the order information as keys to obtain the starting date, the unit for calculating the expiration date range, and the expiration date calculation value from the master, and calculates the expiration date range.

Images