Shipping Deadline Management Device, Shipping Deadline Management Method, and Shipping Deadline Management Program

Abstract

To automatically calculate a shipment deadline from a validity term / an expiration date for each commodity / lot and to prevent shipment after the shipping deadline.SOLUTION: A shipment deadline management device according to the present embodiment includes: a master in which a shipment reference is prescribed for each commodity; arrival input means that inputs arrival data including a commodity, a lot number, a validity term or an expiration date; shipment reference date calculation means that calculates a shipment reference date for the lot number of each commodity of the arrival data, on the basis of, the validity term and the expiration data and the shipment reference acquired from the master by using the commodity as a key; and checking means that checks the shipment reference date for the lot number of each commodity when a predetermined process is performed.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] The present invention relates to a shipment deadline management device, a shipment deadline management method, and a shipment deadline management program.

Background Art

[0002] For example, generally, solid drugs such as tablets with high stability have a long expiration date and similarly a wide shipment standard, while liquid drugs with low stability and a short expiration date have a narrow shipment standard. Thus, the shipment standards vary for each product. Conventionally, as a system for managing the shipment deadline, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, in the above Patent Document 1, there is no description regarding automatically calculating the shipment deadline from the expiration date / shelf life for each product / lot and preventing shipments that exceed the shipment deadline.

[0005] The present invention has been made in view of the above, and an object thereof is to provide a shipment deadline management device, a shipment deadline management method, and a shipment deadline management program capable of automatically calculating the shipment deadline from the expiration date / shelf life for each product / lot and preventing shipments that exceed the shipment deadline.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, the present invention is a shipment deadline management device including a storage unit and a control unit, wherein the storage unit includes a master defining a shipment standard for each product, and the control unit includes a receipt input means for inputting receipt data including a product, a lot number, an expiration date or a use-by date, a shipment standard date calculation means for calculating a shipment standard date based on the expiration date or the use-by date and the shipment standard obtained from the master using the product as a key for each lot number of the product in the receipt data, and a check means for checking the shipment standard date for each lot number of the product during a predetermined process.

[0007] Further, according to one aspect of the present invention, the check means may output an error when the shipment date exceeds the calculated shipment standard date for each lot number of the product during receipt input or sales input.

[0008] Further, according to one aspect of the present invention, the check means may exclude lot numbers of products whose shipment date exceeds the calculated shipment standard date from being allocated during inventory allocation with reference to the inventory, and allocate lot numbers of products whose shipment date does not exceed the calculated shipment standard date.

[0009] Further, according to one aspect of the present invention, the check means may be used for extraction or as one of the extraction conditions at the calculated shipment standard date during inventory inquiry or inventory list output.

[0010] Further, according to one aspect of the present invention, the shipment standard is defined by a month and / or a day, and the shipment standard date may be calculated as a date obtained by subtracting the month and / or the day of the shipment standard from the date of the expiration date or the use-by date.

[0011] Further, according to one aspect of the present invention, the product may be a drug or a food.

[0012] In addition, in order to solve the above-described problems and achieve the object, the present invention is a shipping deadline management method executed by an information processing apparatus including a control unit and a storage unit, wherein the storage unit includes, for each product, a master defining a shipping standard, and the control unit includes: a receipt input unit that inputs receipt data including a product, a lot number, an expiration date, or a shelf life; a shipping standard date calculation step of calculating a shipping standard date based on the expiration date or shelf life and the shipping standard obtained from the master using the product as a key for each lot number of the product in the receipt data; and a check step of checking the shipping standard date for each lot number of the product during a predetermined process.

[0013] In addition, in order to solve the above-described problems and achieve the object, the present invention is a shipping deadline management program for causing an information processing apparatus including a control unit and a storage unit to execute, wherein the storage unit includes, for each product, a master defining a shipping standard, and the control unit includes: a receipt input unit that inputs receipt data including a product, a lot number, an expiration date, or a shelf life; a shipping standard date calculation step of calculating a shipping standard date based on the expiration date or shelf life and the shipping standard obtained from the master using the product as a key for each lot number of the product in the receipt data; and a check step of checking the shipping standard date for each lot number of the product during a predetermined process, and is characterized in that it is a shipping deadline management program for causing the above to be executed.

Effects of the Invention

[0014] According to the present invention, there is an effect that it becomes possible to automatically calculate the shipping deadline from the expiration date / shelf life for each product / lot and prevent shipments that exceed the shipping deadline.

Brief Description of the Drawings

[0015]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

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

[0017] [1. Overview] For example, generally, solid medicines such as tablets that are highly stable have long expiration dates and similarly broad shipping standards, whereas liquid medicines that are less stable and have short expiration dates have narrower shipping standards. In other words, shipping standards vary depending on the product.

[0018] For example, in the case of food products, it is necessary to implement the one-third rule and other operational restrictions, such as restricting shipping to a date that dates back from the expiration date, rather than just the expiration date. However, this not only poses the risk of relying on human judgment and personalization, but also the risk of serious complaints due to shipping beyond the expiration date.

[0019] Here, we will explain in detail about "expiration date" and "shipping deadline". Regarding "expiration date", generally, medicines and test chemicals have a set expiration date, which is issued when they are produced by the manufacturer or in-house. It is necessary to manage the expiration date for each product / lot, and to manage inventory by expiration date and shipping allocation for orders by expiration date.

[0020] Regarding the "shipping standards", the shipment of expired drugs (products) must never be allowed. However, just because a product has not expired does not necessarily mean it can be shipped. It is necessary to manage the shipping standards (how many days before the expiration date a product can be shipped) so that products with an approaching expiration date cannot be shipped either.

[0021] Therefore, in this embodiment, the shipping deadline is automatically calculated from the expiration date for each product / lot to prevent shipments that exceed the shipping deadline. As a result, it is possible to prevent mis-shipments and claims, and by analyzing the shipping deadline date for each product / lot, it becomes possible to lead to the formulation of out-of-stock products and the establishment of sales plans.

[0022] The present invention is not limited to pharmaceuticals and test pharmaceuticals, but is applicable to various products such as foods. For example, in the case of foods, it is possible to apply by replacing the expiration date with the best-before date.

[0023] [2. Configuration] The configuration of the shipping deadline management device 100 according to this embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the shipping deadline management device 100.

[0024] The shipping deadline management device 100 is a commercially available desktop personal computer. Note that the shipping deadline management device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0025] As shown in FIG. 1, the shipping deadline 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 deadline management device 100 is communicably connected via an arbitrary communication path.

[0026] The communication interface unit 104 communicably connects the shipping deadline 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 a communication line. Here, the network 300 has a function of communicably connecting the shipping deadline management device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the storage unit 106 described later may be stored in the server 200.

[0027] An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, in addition to a monitor (including a home TV), a speaker or a printer can be used. 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 described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112. Further, "output" includes displaying on the monitor of the output device 114 and printing with the printer of the output device 114. Further, the user's operation etc. on the information displayed on the monitor 114 with the input device 112 etc. may be described as "user operation via the UI".

[0028] Various databases, tables, files, etc. are stored in the storage unit 106. A computer program for giving instructions to the CPU (Central Processing Unit) to perform various processes in cooperation with the OS (Operating System) is recorded in the storage unit 106. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory)·ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, and an optical disk can be used.

[0029] The memory unit 106 stores a product master 106a and a data file 106b. FIG. 2 is a diagram showing a configuration example of the product master 106a.

[0030] As shown in FIG. 2, the product master 106a can be configured as a registered table or the like that associates products with shipping criteria for the expiration date (specified by month and day, for example). The shipping criteria date can be calculated as the date obtained by subtracting the number of months of the shipping criteria from the expiration date at the time of product receipt and then subtracting the shipping criteria "day". In the example shown in the figure, the first row shows product "Product A", shipping criteria month "1" and day "0", and the second row shows product "Product B", shipping criteria month "1" and day "15".

[0031] The data file 106b is a file for storing various data such as incoming shipment data, inventory data, order receipt data, and sales data. The incoming shipment data may include data such as an incoming shipment number, product, lot number, incoming shipment quantity, and expiration date / consumption date. The order receipt data may include data such as an order receipt number, product, lot number, order receipt quantity, shipping date, and reserved quantity. The inventory data may include data such as an inventory number, warehouse, product, lot number, inventory quantity, expiration date / consumption date, and shipping criteria date.

[0032] The control unit 102 is a CPU or the like that comprehensively controls the shipping deadline management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs. Conceptually in terms of functions, the control unit 102 includes a receipt input unit 102a, a shipping criteria date calculation unit 102b, a check unit 102c, a master maintenance unit 102d, and a screen display control unit 102e.

[0033] The receipt input unit 102a inputs incoming shipment data including a product, lot number, and expiration date or consumption date in response to an operator's operation on an input screen displayed on the monitor 114, for example, and stores it in the data file 106b. In this case, the product may be a drug or food.

[0034] The shipping standard date calculation unit 102b calculates the shipping standard date for each lot number of the products in the incoming data based on the expiration date or the consumption deadline and the shipping standard obtained from the product master 106a using the product as a key, and adds the shipping standard date to the incoming data. The shipping standard date calculation unit 102b registers the incoming data with the added standard shipping date in the inventory data of the data file 106b. In this case, the shipping standard may be defined by month and / or day, and the shipping standard date may be calculated as the date obtained by subtracting the month and / or day of the shipping standard from the date of the expiration date or the consumption deadline.

[0035] The check unit 102c checks the shipping standard date for each lot number of the product during a predetermined process. Specifically, the check unit 102c may output an error when the shipping date exceeds the calculated shipping standard date for each lot number of the product during the reception input or the sales input. In addition, the check unit 102c may refer to the inventory and exclude the lot numbers of the products whose shipping date exceeds the calculated shipping standard date from the allocation target, and allocate the lot numbers of the products whose shipping date does not exceed the calculated shipping standard date. Further, the check unit 102c may use the calculated shipping standard date for extraction or as one of the extraction conditions during the inventory inquiry or the inventory list output.

[0036] The master maintenance unit 102d performs editing such as data input, addition, change, and update on the product master 106a according to the operation of the operator on a master maintenance screen (not shown) displayed on the monitor 114, for example.

[0037] The screen display control unit 102e controls the display of various screens to be displayed on the monitor 114 and the reception of their inputs.

[0038] [3. Specific Example of Processing] With reference to FIGS. 1 to 6, a specific example of the processing of the shipping deadline management device 100 according to the present embodiment will be described. In the following description, the data example of the product master 106a in FIG. 2 will be used.

[0039] (1. Calculation of the Shipment Standard Date for Incoming Data) FIG. 3 is a diagram for explaining the calculation of the shipment standard date for incoming data. With reference to FIG. 3, the calculation of the shipment standard date for incoming data will be explained.

[0040] FIG. 3(A) is a diagram showing an example of incoming data. The incoming input unit 102a inputs the incoming data. In the example shown in FIG. 3(A), the first row shows the product "Product A", lot number "L01", expiration date "2020 / 8 / 31", the second row shows the product "Product B", lot number "L02", expiration date "2020 / 11 / 30", and the third row shows the product "Product B", lot number "L03", expiration date "2020 / 12 / 31".

[0041] The shipment standard date calculation unit 102b calculates the shipment standard date as the date obtained by subtracting the number of months of the shipment standard from the expiration date at the time of product receipt and then subtracting the shipment standard "day".

[0042] FIG. 3(B) shows an example of calculating the shipment standard date for the incoming data. For the product "Product A" and lot number "L01" in the first row, the expiration date is "2020 / 8 / 31", and the shipment standard month "1" and day "0" of the product "Product A" in the product master 106a, so the shipment standard date is the date obtained by subtracting the shipment standard month "1" from the expiration date "2020 / 8 / 31", which is "2020 / 7 / 31".

[0043] For the product "Product B" and lot number "L02" in the second row, the expiration date is "2020 / 11 / 30", and the shipment standard month "1" and day "15" of the product "Product B" in the product master 106a, so the shipment standard date is the date obtained by subtracting the shipment standard month "1" and day "15" from the expiration date "2020 / 11 / 30", which is "2020 / 10 / 16".

[0044] For the product "Product B" and lot number "L03" on the 3rd line, the expiration date is "2020 / 12 / 31", and since the month "1" and day "15" of the shipping standard of the product "Product B" in the product master 106a, the date obtained by subtracting the month "1" and day "15" of the shipping standard from the expiration date "2020 / 12 / 31" is "2020 / 11 / 15".

[0045] The shipping standard date calculation unit 102b calculates the above-mentioned shipping standard date each time from the expiration date of each lot of the product. As will be described later, the check unit 102c compares with the shipping date at the time of order receipt or reservation, etc., and performs an error check on whether the shipping date exceeds the shipping standard date.

[0046] (2. Check of shipping standard date for order receipt data) Figure 4 is a diagram for explaining the check of the shipping standard date for order receipt data. Referring to Figure 4, the check of the shipping standard date for order receipt data will be described.

[0047] In Figure 4, for the 1st line, the product is "Product A", the lot number is "L01", the shipping date is "2020 / 7 / 31", and the shipping standard date is "2020 / 7 / 31". Since the shipping date does not exceed the shipping standard date, it is determined that the shipment is OK.

[0048] For the 2nd line, the product is "Product A", the lot number is "L01", and the shipping date is "2020 / 8 / 1". Since the shipping standard date is "2020 / 7 / 31", and the shipping date exceeds the shipping standard date, it is determined that the shipment is NG.

[0049] For the 3rd line, the product is "Product B", the lot number is "L02", the shipping date is "2020 / 10 / 16", and the shipping standard date is "2020 / 10 / 16". Since the shipping date does not exceed the shipping standard date, it is determined that the shipment is OK.

[0050] For the 4th line, the product is "Product B", the lot number is "L02", and the shipping date is "2020 / 10 / 17". Since the shipping standard date is "2020 / 10 / 16", and the shipping date exceeds the shipping standard date, it is determined that the shipment is NG.

[0051] Figure 5 is a diagram showing the processing image when shipment is NG at the time of order receipt. Referring to Figure 5, the processing image when shipment is NG at the time of order receipt will be described. In Figure 5, an order for delivery at the end of October 2020 for product B will be described.

[0052] In Figure 5(A), the order data is product "Product B", lot number "L02", order quantity "50", and shipment date "2020 / 10 / 17". However, since the shipment standard date is "2020 / 10 / 16" and the shipment date exceeds the shipment standard date, it is determined that the shipment is NG.

[0053] Since the shipment date "2020 / 10 / 17" is in error, the shipment standard date for each lot of product B is queried from the inventory inquiry to confirm the shippable lot. For example, assume there is inventory data as shown in Figure 5(B). In Figure 5(B), the first line is product "Product B", lot number "L02", inventory quantity "100", expiration date "2020 / 11 / 30", and shipment standard date "2020 / 10 / 16". The second line is product "Product B", lot number "L03", inventory quantity "200", expiration date "2020 / 12 / 31", and shipment standard date "2020 / 11 / 15".

[0054] For product "Product B" and lot number "L03", since the shipment standard date is "2020 / 11 / 15" and it does not exceed the shipment date "2020 / 10 / 17", the shipment is possible. Therefore, as shown in Figure 5(C), the lot number is changed to "L03".

[0055] FIG. 6 is a diagram for explaining the processing image of the inventory re-allocation process. Referring to FIG. 6, the processing image of the inventory re-allocation process will be described. The checking unit 102c excludes lot numbers with a shipping date exceeding the shipping standard date from the objects of allocation, and allocates lot numbers that do not exceed the shipping standard date. FIG. 6(A) shows an example of unallocated order receiving data before the inventory re-allocation process. In FIG. 6(A), the first row shows the order receiving number "J0001", product "Product C", lot number "L11", order receiving quantity "30", shipping date "2020 / 12 / 1", allocated quantity "0"; the second row shows the order receiving number "J0002", product "Product C", lot number "L11", order receiving quantity "30", shipping date "2020 / 11 / 20", allocated quantity "0"; the third row shows the order receiving number "J0003", product "Product D", lot number "L12", order receiving quantity "30", shipping date "2020 / 12 / 20", allocated quantity "0"; the fourth row shows the order receiving number "J0004", product "Product D", lot number "L13", order receiving quantity "30", shipping date "2020 / 12 / 20", allocated quantity "0".

[0056] FIG. 6(B) shows the inventory status of the inventory data before the inventory re-allocation process. In FIG. 6(B), the first row shows the product "Product C", lot number "L11", inventory quantity "100", expiration date "2020 / 12 / 31", shipping standard date "2020 / 11 / 30"; the second row shows the product "Product D", lot number "L12", inventory quantity "100", expiration date "2020 / 12 / 31", shipping standard date "2020 / 11 / 30"; the third row shows the product "Product D", lot number "L13", inventory quantity "100", expiration date "2021 / 1 / 31", shipping standard date "2020 / 12 / 31".

[0057] The order receiving data after the inventory re-allocation process is as shown in FIG. 6(C). For the product "Product C" with the order receiving number "J0001" in the first row, since the shipping date > the shipping standard date, the allocated quantity is "0". For the product "Product C" with the order receiving number "J0002" in the second row, since the shipping date ≤ the shipping standard date, the allocated quantity is "30".

[0058] For the product "Product D" with the order number "J0003" on the 3rd line, since the shipment date > the shipment standard date, the reserved quantity is "0". For the product "Product D" with the order number "J0004" on the 4th line, since the shipment date ≤ the shipment standard date, the reserved quantity is "30".

[0059] As described above, according to this embodiment, for each product, there are provided a product master 106a that defines the shipment standard, an incoming shipment input unit 10 for inputting incoming shipment data including the product, lot number, expiration date, or use-by date, a shipment standard date calculation means for calculating the shipment standard date based on the expiration date or use-by date and the shipment standard obtained from the master using the product as a key for each lot number of the product in the incoming shipment data, and a check means for checking the shipment standard date for each lot number of the product during a predetermined process. Therefore, it is possible to automatically calculate the shipment deadline from the expiration date / use-by date for each product / lot and prevent shipments that exceed the shipment deadline.

[0060] [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 idea described in the claims.

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

[0062] Also, regarding 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 the drawings, they can be arbitrarily changed unless otherwise specified.

[0063] Also, regarding the shipment deadline management device 100, each of the illustrated components is a functional concept and does not necessarily have to be physically configured as shown in the figure.

[0064] For example, regarding the processing functions provided by the shipping deadline management device 100, particularly each processing function performed by the control unit 102, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processing described in this embodiment, and is mechanically read by the shipping deadline management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS to perform 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 constitutes the control unit in cooperation with the CPU.

[0065] Also, this computer program may be stored in an application program server connected to the shipping deadline management device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

[0066] Also, a program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium, and may also be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as 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), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0067] Also, the "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributedly configured as a plurality of modules or libraries, or those that achieve their functions in cooperation with another program represented by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0068] The various databases and the like stored in the storage unit 106 are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0069] Further, the shipping deadline 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 deadline management device 100 may be realized by installing software (including a program or data, etc.) for realizing the processes described in the present embodiment in the device.

[0070] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the function load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Description of Reference Numerals

[0071] 100 Shipping deadline management device 102 Control unit 102a Receipt input unit 102b Shipping reference date calculation unit 102c Check unit 102d Master maintenance unit 102e Screen display control unit 104 Communication interface unit 106 Storage unit 106a Product master 106b Data file 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims

1. A shipping deadline management device that includes a control unit and manages shipping deadlines for products to be sold, The control unit is Master data that specifies the shipping standards for each product, Inventory data including inventory numbers, warehouses, products, lot numbers, inventory quantities, expiration dates or best before dates, and shipping reference dates; is configured to be accessible to An arrival input means for inputting arrival data including a product, a lot number, and an expiration date or a best-by date; a shipping reference date calculation means for calculating a shipping reference date that is a date prior to the expiration date or best-before date for each lot number of the product in the arrival data, based on the expiration date or best-before date and a shipping reference date acquired from a master using the product as a key, and updating the shipping reference date of the inventory data; A check means for checking the shipping reference date for each lot number of the product when inputting an order or sales; Equipped with The shipping deadline management device is characterized in that, if the shipping date exceeds the calculated shipping reference date at the time of order input, the check means, in response to an operator's operation, refers to the inventory data through an inventory inquiry to inquire about the shipping reference date of each lot number of the product whose shipping date exceeds the calculated shipping reference date, and changes the lot number of the product to be shipped whose shipping date exceeds the calculated shipping reference date to a lot number that does not exceed the shipping reference date.

2. 2. The shipping deadline management device according to claim 1, wherein the checking means outputs an error when the shipping date for each lot number of a product exceeds the calculated shipping reference date during order entry and sales entry.

3. The shipping deadline management device according to claim 1, characterized in that the checking means, when allocating inventory, refers to the inventory and excludes lot numbers of products whose shipping dates exceed the calculated shipping reference date from the allocation, and allocates lot numbers of products whose shipping dates do not exceed the calculated shipping reference date.

4. 2. The shipping deadline management device according to claim 1, wherein the check means uses the calculated shipping reference date as one of the extraction conditions or extraction conditions when making an inventory inquiry or outputting an inventory list.

5. The shipping criteria are specified by month and / or day, 5. The shipping deadline management device according to claim 1, wherein the shipping reference date is calculated by subtracting the shipping reference month and / or day from the expiration date or best before date.

6. 6. The shipping deadline management device according to claim 1, wherein the product is a medicine or a food product.

7. A shipping deadline management method executed by a shipping deadline management device that has a control unit and manages shipping deadlines of products to be sold, The control unit is Master data that specifies the shipping standards for each product, Inventory data including inventory numbers, warehouses, products, lot numbers, inventory quantities, expiration dates or best before dates, and shipping reference dates; is configured to be accessible to Executed in the control unit, an arrival input step of inputting arrival data including a product, a lot number, and an expiration date or a best-by date; a shipping reference date calculation step of calculating a shipping reference date that is a date prior to the expiration date or best-before date for each lot number of the product in the arrival data, based on the expiration date or best-before date and the shipping reference date acquired from the master using the product as a key, and updating the shipping reference date of the inventory data; a checking step of checking the shipping reference date for each lot number of the product when inputting an order or sales; Including, In the checking step, if the shipping date at the time of order input is beyond the calculated shipping reference date, in response to an operation by an operator, the inventory data is referenced by inventory inquiry to inquire about the shipping reference date of each lot number of the product whose shipping date is beyond the calculated shipping reference date, and the lot number of the product to be shipped whose shipping date is beyond the calculated shipping reference date is changed to a lot number that is not beyond the shipping reference date.

8. A shipping deadline management program to be executed by a shipping deadline management device that includes a control unit and manages shipping deadlines of products to be sold, The control unit is Master data that specifies the shipping standards for each product, Inventory data including inventory numbers, warehouses, products, lot numbers, inventory quantities, expiration dates or best before dates, and shipping reference dates; is configured to be accessible to The control unit, an arrival input step of inputting arrival data including a product, a lot number, and an expiration date or a best-by date; a shipping reference date calculation step of calculating a shipping reference date that is a date prior to the expiration date or best-before date for each lot number of the product in the arrival data, based on the expiration date or best-before date and the shipping reference date acquired from the master using the product as a key, and updating the shipping reference date of the inventory data; a checking step of checking the shipping reference date for each lot number of the product when inputting an order or sales; This is a shipping deadline management program for executing In the checking step, if the shipping date at the time of order input is beyond the calculated shipping reference date, the shipping deadline management program refers to the inventory data through an inventory inquiry in response to an operator's operation to inquire about the shipping reference date of each lot number of the product whose shipping date is beyond the calculated shipping reference date, and changes the lot number of the product to be shipped whose shipping date is beyond the calculated shipping reference date to a lot number that is not beyond the shipping reference date.

Images