JP2024045660A - Shipment deadline management device, shipment deadline management method, and shipment deadline management program - Google Patents

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

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

For example, generally, highly stable solid medicines such as tablets have long expiration dates and similarly broad shipping standards, while liquid medicines that are less stable and have short expiration dates have narrower shipping standards. In other words, shipping standards differ for each product. For example, Patent Document 1 is a conventional system for managing shipping deadlines.

JP 2015-9927 Publication

However, the above-mentioned Patent Document 1 does not state anything about automatically calculating the shipping deadline from the expiry date/best before date for each product/lot and preventing shipments that exceed the shipping deadline.

The present invention has been made in view of the above, and is capable of automatically calculating a shipping deadline from the expiration date/expiration date of each product/lot and preventing shipments that exceed the shipping deadline. The purpose of the present invention is to provide a management device, a shipping deadline management method, and a shipping deadline management program.

In order to solve the above-mentioned problems and achieve the objects, the present invention provides a shipping deadline management device that includes a storage section and a control section, and the storage section stores a master that defines shipping standards for each product. The control unit includes an arrival input means for inputting arrival data including a product, a lot number, an expiration date, or an expiration date; A shipping reference date calculation means for calculating the shipping reference date based on the shipping reference obtained from the master as a key, and a checking means for checking the shipping reference date for each lot number of the product during a predetermined process. It is characterized by having

According to one aspect of the present invention, the check means may output an error when an order or sales entry is made and the shipping date for each lot number of a product is later than the calculated shipping reference date.

Further, according to one aspect of the present invention, when making inventory reservation, the checking means refers to inventory and excludes lot numbers of products whose shipping date exceeds the calculated shipping reference date from being reserved. , the lot number of the product whose shipping date does not exceed the calculated shipping reference date may be assigned.

According to one aspect of the present invention, the check means may use the calculated shipping reference date as one of the extraction conditions or extraction conditions when making an inventory inquiry or outputting an inventory list.

Further, according to one aspect of the present invention, the shipping standard is defined in months and/or days,
The shipping standard date may be calculated by subtracting the shipping standard month and/or day from the expiration date or expiration date.

According to one aspect of the present invention, the product may be a medicine or food.

Moreover, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides a shipping deadline management method executed by an information processing device including a control unit and a storage unit, wherein the storage unit a receipt input means for inputting arrival data including the product, lot number, expiration date, or expiration date, which is executed in the control unit, and includes a master that defines shipping standards, and each lot number of the product in the arrival data. The shipping standard date calculation process calculates the shipping standard date based on the expiry date or expiration date and the shipping standard obtained from the master data using the product as a key, and each lot number of the product is calculated during predetermined processing. and a checking step of checking a shipping reference date for the shipping date.

Further, in order to solve the above-mentioned problems and achieve the purpose, the present invention provides a shipping deadline management program to be executed by an information processing device including a control unit and a storage unit, the storage unit being a master that defines shipping standards for each product, and in the control section, an arrival input means for inputting arrival data including the product, lot number, expiration date or expiration date, and for each lot number of the product in the arrival data, A shipping standard date calculation process that calculates the shipping standard date based on the expiry date or consumption date and the shipping standard obtained from the master using the product as a key, and the shipping standard date for each lot number of the product during predetermined processing. The present invention is characterized by being a shipping deadline management program for executing a check step of checking a reference date.

The present invention has the effect of automatically calculating the shipping deadline from the expiry date/best before date for each product/lot, making it possible to prevent shipments that exceed the shipping deadline.

FIG. 1 is a block diagram showing an example of the configuration of a shipping deadline management device according to the present embodiment. FIG. 2 is a diagram showing an example of the configuration of the product master. FIG. 3 is a diagram for explaining calculation of a shipping reference date for arrival data. FIG. 4 is a diagram for explaining checking of the shipping reference date for order data. FIG. 5 is a diagram showing a processing image when shipping is rejected during order entry. FIG. 6 is a diagram for explaining an image of the inventory reallocation process.

DESCRIPTION OF EMBODIMENTS Below, embodiments 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 based on the drawings. Note that the present invention is not limited to this embodiment.

[1. overview]
For example, solid drugs such as tablets that are generally highly stable have long expiration dates and have wide shipping standards, but liquid drugs that are less stable and have short expiration dates have narrower shipping standards. shipping standards are different.

For example, in the case of food products, it is necessary for business purposes to restrict shipments not only by the expiry date of the product, but also by dates retroactive to the expiration date, such as the one-third rule, but it is necessary to limit shipments based on the date back from the expiry date, such as the one-third rule. There was not only the risk of overdue shipping, but also the risk of serious claims due to overdue shipments.

Here, we will explain in detail about "expiration dates" and "shipping deadlines." Regarding "expiration dates," pharmaceuticals and test chemicals generally have a set expiration date that is issued when they are produced by the manufacturer or in-house. It is necessary to manage the expiration date for each product/lot, as well as manage inventory by expiration date and shipping allocation for orders by expiration date.

Regarding "shipping standards," expired medicines (products) must never be shipped, but it is not necessarily acceptable to ship products that have not yet passed their expiration date. Similarly, it is necessary to manage the shipping standards (how many days before the expiration date products can be shipped) so that products close to their expiration date cannot be shipped either.

In this embodiment, the shipping deadline is automatically calculated from the expiration date for each product/lot, and shipments that exceed the shipping deadline are prevented. This prevents incorrect shipments and complaints, and by being able to analyze the shipping deadline for each product/lot, it is possible to use this to plan clearance items and create sales plans.

The present invention is not limited to pharmaceuticals or test chemicals, but can be applied to various products such as food. For example, in the case of food, the expiration date can be replaced with the best-by date.

[2. composition]
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.

The shipping deadline management device 100 is a commercially available desktop personal computer. The shipping deadline management device 100 is not limited to stationary information processing devices such as desktop personal computers, but may also be portable information processing devices such as commercially available notebook personal computers, PDAs (Personal Digital Assistants), smartphones, and tablet personal computers.

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

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 connecting the shipping deadline management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). Note that 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, in addition to a monitor (including a home television), 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. Note that in the following description, 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. Furthermore, "output" includes displaying on the monitor of the output device 114 and printing with the printer of the output device 114. Furthermore, a user's operation on information displayed on the monitor 114 using the input device 112 or the like may be referred to as "user operation via UI."

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a CPU (Central Processing Unit) to perform various processes in cooperation with an OS (Operating System). 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, etc. can be used.

The storage unit 106 stores a product master 106a and a data file 106b. FIG. 2 is a diagram showing an example of the configuration of the product master 106a.

As shown in FIG. 2, the product master 106a can be composed of a registered table that associates products with shipping standards (specified by month and day, for example) with respect to expiration dates. The shipping reference date can be calculated as the date obtained by subtracting the number of months of the shipping standard from the expiration date at the time of arrival of the product, and subtracting the shipping standard of "day". In the example shown in the figure, the first line shows the product "Product A", the shipping standard month "1" and the day "0", and the second line shows the product "Product B", the shipping standard month "1", and The day is "15".

The data file 106b is a file for storing various data such as arrival data, inventory data, order data, and sales data. The arrival data may include data such as an arrival number, a product, a lot number, the number of arrivals, and an expiration date/expiration date. The order data may include data such as an order number, product, lot number, number of orders, shipping date, and number of reservations. The inventory data may include data such as inventory number, warehouse, product, lot number, inventory quantity, expiration date/expiration date, and shipping reference date.

The control unit 102 is a CPU or the like that controls the shipping deadline management device 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as an OS, programs specifying various processing procedures, required data, etc., and performs various information processing based on these stored programs. Execute. The control unit 102 functionally includes an arrival input unit 102a, a shipping reference date calculation unit 102b, a check unit 102c, a master maintenance unit 102d, and a screen display control unit 102e.

For example, the arrival input unit 102a inputs arrival data including the product, lot number, expiration date, or expiration date according to an operator's operation on the input screen displayed on the monitor 114, and stores the input data in the data file 106b. do. In this case, the product may be medicine or food.

The shipping reference date calculation unit 102b calculates a shipping reference 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 obtained from the product master 106a using the product as a key, and adds the shipping reference date to the arrival data. The shipping reference date calculation unit 102b registers the arrival data with the reference shipping date added to the inventory data in the data file 106b. In this case, the shipping reference may be specified by month and/or day, and the shipping reference date may be calculated by subtracting the month and/or day of the shipping reference from the expiration date or best before date.

The checking unit 102c checks the shipping reference date for each lot number of the product during a specified process. Specifically, when inputting an order or sales, the checking unit 102c may output an error if the shipping date for each lot number of the product exceeds the calculated shipping reference date. Furthermore, the checking unit 102c may refer to the inventory and exclude lot numbers of products whose shipping dates exceed the calculated shipping reference date from the allocation target, and allocate lot numbers of products whose shipping dates do not exceed the calculated shipping reference date. Furthermore, the checking unit 102c may use the calculated shipping reference date for extraction or as one of the extraction conditions when inquiring about inventory or outputting an inventory list.

For example, the master maintenance unit 102d performs editing such as inputting, adding, changing, updating data, etc. to the product master 106a in response to an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114. .

The screen display control unit 102e controls the display of various screens on the monitor 114 and the reception of inputs therefor.

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

(1. Calculation of shipping reference date for arrival data)
FIG. 3 is a diagram for explaining calculation of a shipping reference date for arrival data. With reference to FIG. 3, calculation of the shipping reference date for the arrival data will be explained.

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

The shipping reference date calculation unit 102b calculates the shipping reference date as the date obtained by subtracting the number of "months" of the shipping reference from the expiration date at the time of arrival of the product and also subtracting the shipping reference "day".

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

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

For the product "Product B" and lot number "L03" in the third row, the expiration date is "2020/12/31", and the shipping reference month is "1" and day is "15" for the product "Product B" in the product master 106a, so the date is "2020/11/15", which is the date obtained by subtracting the shipping reference month "1" and day "15" from the expiration date "2020/12/31".

The shipping reference date calculation unit 102b calculates the shipping reference date described above each time from the expiration date of each lot of products. As will be described later, the checking unit 102c compares the shipping date of the received order with the shipping date at the time of receiving the order, reserving the order, etc., and performs an error check to see if the shipping date exceeds the standard shipping date.

(2. Checking the shipping reference date for order data)
FIG. 4 is a diagram for explaining checking of the shipping reference date for order data. With reference to FIG. 4, checking of the shipping reference date for order data will be explained.

In Figure 4, the first line is the product "Product A", the lot number "L01" is the shipping date "2020/7/31", and the shipping reference date is "2020/7/31", so the shipping Since the date does not exceed the shipping reference date, it is determined that shipping is OK.

The second line has the product "Product A", lot number "L01", and shipping date "2020/8/1", but the shipping reference date is "2020/7/31", so the shipping date is after the shipping reference date, and the product is deemed not eligible for shipping.

The third line is the product "Product B", the lot number "L02", and the shipping date "2020/10/16", and the shipping reference date is "2020/10/16", so the shipping date is the shipping reference date. Since it does not exceed the above limit, it is determined that it is OK to ship.

The fourth line has the product "Product B", lot number "L02", and shipping date "2020/10/17", but the shipping reference date is "2020/10/16", so the shipping date is after the shipping reference date and the product is deemed NG for shipping.

Figure 5 is a diagram showing a processing image when shipment is not possible at the time of order entry. With reference to Figure 5, a processing image when shipment is not possible at the time of order entry will be explained. Figure 5 explains an order for product B to be delivered at the end of October 2020.

In Figure 5 (A), the order data is for product "Product B", lot number "L02", order quantity "50", and shipping date "2020/10/17", but the shipping reference date is "2020/10/16", so the shipping date is after the shipping reference date, and it is determined that the item cannot be shipped.

Because an error occurred for the shipping date of "2020/10/17", the shipping reference date for each lot of product B is inquired via inventory inquiry to confirm which lots are available for shipping. For example, assume that there is inventory data as shown in Figure 5 (B). In Figure 5 (B), the first line is product "product B", lot number "L02", stock quantity "100", expiration date "2020/11/30", and shipping reference date "2020/10/16", and the second line is product "product B", lot number "L03", stock quantity "200", expiration date "2020/12/31", and shipping reference date "2020/11/15".

Product "Product B", lot number "L03" has a shipping reference date of "2020/11/15" and can be shipped because it does not exceed the shipping date of "2020/10/17". ), change the lot number to "L03".

Figure 6 is a diagram for explaining the process image of the inventory reallocation process. The process image of the inventory reallocation process will be explained with reference to Figure 6. The checking unit 102c excludes lot numbers whose shipping dates fall after the shipping reference date from the allocation target, and allocates lot numbers whose shipping dates do not fall after the shipping reference date. Figure 6 (A) shows an example of unallocated order data before the inventory reallocation process. In FIG. 6(A), the first line shows the order number "J0001", the product "Product C", the lot number "L11", the order quantity "30", the shipping date "2020/12/1", and the allocation quantity "0". The second line shows the order number "J0002", the product "Product C", the lot number "L11", the order quantity "30", the shipping date "2020/11/20", and the allocation quantity "0". The third line shows the order number "J0003", the product "Product D", the lot number "L12", the order quantity "30", the shipping date "2020/12/20", and the allocation quantity "0". The fourth line shows the order number "J0004", the product "Product D", the lot number "L13", the order quantity "30", the shipping date "2020/12/20", and the allocation quantity "0".

Figure 6 (B) shows the inventory status of the inventory data before the inventory reallocation process. In Figure 6 (B), the first line shows the product "Product C", lot number "L11", inventory quantity "100", expiration date "2020/12/31", and shipping reference date "2020/11/30", the second line shows the product "Product D", lot number "L12", inventory quantity "100", expiration date "2020/12/31", and shipping reference date "2020/11/30", and the third line shows the product "Product D", lot number "L13", inventory quantity "100", expiration date "2021/1/31", and shipping reference date "2020/12/31".

The order data after the inventory reallocation process will look like that shown in Figure 6 (C). For product "Product C" with order number "J0001" on the first line, the shipping date is greater than the shipping reference date, so the allocation quantity will be "0." For product "Product C" with order number "J0002" on the second line, the shipping date is less than or equal to the shipping reference date, so the allocation quantity will be "30."

For product "Product D" of order number "J0003" on the third line, the shipping date is greater than the shipping reference date, so the allocation quantity is "0". For product "Product D" of order number "J0004" on the fourth line, the shipping date is less than or equal to the shipping reference date, so the allocation quantity is "30".

As explained above, according to the present embodiment, for each product, the product master 106a that defines the shipping standards, and the arrival input unit 10 means for inputting the arrival data including the product, lot number, expiration date, or expiration date. a shipping reference date calculation means for calculating a shipping reference date for each lot number of the product in the shipping data based on the expiration date or expiration date and the shipping standard acquired from the master using the product as a key; When processing, the shipping deadline is automatically calculated from the expiration date/expiration date for each product/lot, and the shipping deadline is set. This makes it possible to prevent shipments that exceed the limit.

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

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

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

Further, regarding the shipping deadline management device 100, each illustrated component is functionally conceptual, and does not necessarily need to be physically configured as illustrated.

For example, the processing functions of the shipping deadline 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 on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the shipping deadline management device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with an OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

Further, 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 may be downloaded as necessary. It is.

Further, a program for executing the processing described in this embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, this "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 EEPR. OM (registration) Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVDs (Digital Versatile Discs), Blu-ray (registered trademark) Discs, etc. shall include any “portable physical medium”.

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

The various databases stored in the memory unit 106 are storage devices 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 used for various processes and providing websites.

Furthermore, 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 any peripheral device is connected. Further, the shipping deadline management device 100 may be realized by installing software (including a program, data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

100 Shipping deadline management device
102 control unit
102a Arrival input section
102b Shipping reference date calculation unit
102c Check section
102d Master Maintenance Department
102e Screen display control unit
104 Communication interface unit
106 Memory unit
106a Product master
106b Data file
108 Input/Output Interface Unit
112 Input device
114 Output device 200 Server 300 Network

Claims (8)

A shipping deadline management device comprising a control unit,
The control unit includes:
A master that defines shipping standards for each product,
Inventory data including inventory number, warehouse, product, lot number, quantity in stock, expiration date or expiry date, shipping reference date,
is configured to be accessible to
Arrival input means for inputting arrival data including product, lot number, expiration date or expiration date;
For each lot number of the product in the above-mentioned loading data, calculate the shipping reference date based on the expiration date or expiration date and the shipping standard obtained from the master using the product as a key, and update the shipping reference date in the inventory data. a shipping reference date calculation means,
A checking means for checking a shipping reference date for each lot number of a product when entering orders or entering sales;
Equipped with
If the shipping date exceeds the calculated shipping reference date when entering the order, the checking means refers to the inventory data in the inventory inquiry in response to an operator's operation, and updates the shipping date calculated by the shipping date. A shipping deadline management device characterized by inquiring the shipping standard date of each lot number of a product whose standard date has exceeded, and changing the shipping target to a lot number whose shipping deadline has not been exceeded. 2. The checking means outputs an error if the shipping date exceeds the calculated shipping reference date for each lot number of the product when inputting orders and sales. shipping deadline management device. When allocating inventory, the checking means refers to the inventory and excludes lot numbers of products whose shipping date exceeds the calculated shipping reference date from being allocated; 2. The shipping deadline management device according to claim 1, wherein the shipping deadline management device allocates lot numbers of products that have not been shipped. 2. The shipping deadline management device according to claim 1, wherein the checking means uses the calculated shipping reference date as one of the extraction or extraction conditions when making an inventory inquiry or outputting an inventory list. 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. The shipping deadline management device according to any one of claims 1 to 5, wherein the product is a drug or a food product. A shipping deadline management method executed by an information processing device including a control unit, the method comprising:
The control unit includes:
A master that defines shipping standards for each product,
Inventory data including inventory number, warehouse, product, lot number, quantity in stock, expiration date or expiry date, shipping reference date,
is configured to be accessible to
executed in the control unit,
an arrival input step of inputting arrival data including products, lot numbers, expiration dates, or expiration dates;
For each lot number of the product in the above-mentioned loading data, calculate the shipping reference date based on the expiration date or expiration date and the shipping standard obtained from the master using the product as a key, and update the shipping reference date in the inventory data. shipping reference date calculation process,
A check process of checking the shipping reference date for each lot number of the product when entering orders or entering sales;
including;
In the checking process, if the shipping date exceeds the calculated shipping reference date when entering the order, the inventory data is referred to in the inventory inquiry according to the operator's operation, and the shipping date calculated is calculated. A shipping deadline management method characterized by inquiring the shipping standard date of each lot number of products whose shipping deadline has exceeded, and changing the shipping target to a lot number whose shipping deadline has not been exceeded. A shipping deadline management program to be executed by an information processing device equipped with a control unit,
The control unit includes:
A master that defines shipping standards for each product,
Inventory data including inventory number, warehouse, product, lot number, quantity in stock, expiration date or expiry date, shipping reference date,
is configured to be accessible to
In the control section,
an arrival input step of inputting arrival data including products, lot numbers, expiration dates, or expiration dates;
For each lot number of the product in the above-mentioned loading data, calculate the shipping reference date based on the expiration date or expiration date and the shipping standard obtained from the master using the product as a key, and update the shipping reference date in the inventory data. shipping reference date calculation process,
A check process of checking the shipping reference date for each lot number of the product when entering orders or entering sales;
This is a shipping deadline management program for executing
In the checking process, if the shipping date exceeds the calculated shipping reference date when entering the order, the inventory data is referred to in the inventory inquiry according to the operator's operation, and the shipping date calculated is calculated. A shipping deadline management program characterized by inquiring the shipping standard date of each lot number of products whose shipping deadline has exceeded, and changing the shipping target to a lot number whose shipping deadline has not been exceeded.

Images