JP2002099597A - Warehouse management system and warehouse management method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a warehouse management system that can unitarily the manage periods and standards for an expiration date as well a transportation times even if they varry for every commodity, and can assign each commodity to the end customer with reliability by taking the delivery time into consideration. SOLUTION: The warehouse management system, which manages the reception, storage, and shipment of the commodities, has a commodity management means that stores data on a predetermined expiration date for every commodity shipment, which are used for calculating the expiration date for the arrived commodities, an incoming product management means that stores the data with control dates for arrived commodities their quantities, their appreciation expired dates, and their manufactured dates or their arrived dates, a commodity shipment management means that stores the data for commodities to be shipped, their quantities, and their shipping dates, an inventory management means that stores the data including information of the shipment expiration dates for the arrived commodities a shipment expiration date calculation means that calculates the dates of expiration on the basis of the shipment expiration dates and the above mentioned management dates, and a shipping assignment means that assigns the commodities that do not exceed the time limit of the shipment expiration, the data of which are extracted from the inventory management means, to the commodity shipment dates in responding to requests for shipment orders.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to the distribution of goods, and in particular, in a warehouse business for temporarily storing goods, for example, when goods are lined up at a storefront, the expiration date is set so that the expiration date has not already occurred. The present invention relates to a warehouse management system and a warehouse management method capable of centrally managing various products with different time limit management methods so that only appropriate products are delivered to a warehouse.

[0002]

2. Description of the Related Art In the warehousing business, first-in first-out is basically used as primary storage of products from customers. In accordance with an order for delivery, products are simply allocated in ascending order of the date of manufacture or storage of stored products. However, those whose expiry date has expired were excluded by the allocation operator. However, the products to be kept are diversified, and simply putting out all the products on a first-in first-out basis may result in the expiration date of a product having a shelf life expiration date, such as food, when it is displayed at a store. Also, if a store that can sell products has a contract to deliver only items that have a period of at least one week or six months before the expiration date, for example, There is a case where it runs out. And, depending on the product, there are products managed by the expiration date, those managed by the consumption period based on the date of manufacture, and those managed by the receipt date of the day when the product was received The standard and period for managing the deadline are different. In addition, the period required for delivery differs depending on the product, such as when the goods are taken out of the warehouse, through an intermediary company, or when transportation time is required depending on the delivery area.

[0003]

Therefore, even if it is different for each product, such as the standard and period of time limit management, and the period for delivery, it can be managed in a unified manner, without the need for confirmation work by the allocation operator. Provided is a warehouse management system and a warehouse management method that can reliably perform allocation in consideration of the point of delivery to a final customer.

[0004]

A warehouse management system according to the present invention is a warehouse management system for managing (1) goods receipt, storage, and delivery of goods, and calculates a delivery deadline date of the received goods. A merchandise management means for storing data of a delivery expiration date set in advance for each product, and data of management date such as a stored product, an amount, and a shelf life date, a manufacturing date or a storage date of the received product. Warehousing management means, merchandise to be issued, quantity, and warehousing management means for storing data on the warehousing date of the goods to be issued, and inventory management means for storing inventory data including information on the expiration date of the warehousing goods, A delivery deadline date calculating means for calculating a delivery deadline date of a received product from the delivery deadline and the management date; and, in accordance with an order for product delivery, a delivery date on which a product delivery is specified, Not exceeded Goods and, characterized by having a, a goods issue provision means Hikiateru from inventory management means.

[0005] The warehouse management system of the present invention comprises:
(1) In the warehouse management system described in (1), the outgoing allocation means allocates goods from the inventory management means in the order of the oldest management date.

A warehouse management method according to the present invention is a warehouse management method for managing receipt, storage, and delivery of goods by a computer, wherein a delivery deadline for calculating a delivery deadline date of the received goods is defined by: A step of setting in advance for each product; a step of creating data of a received product, an amount, and a management date such as a shelf life date, a manufacturing date, or a storage date of the received product; and Calculating the delivery deadline date of the goods received, and creating inventory management data including the information on the delivery deadline; data on the goods to be delivered, the quantity, and the delivery date according to the order for the delivery of the goods. Creating a shipping target list by associating, from the inventory management data, products that do not exceed a shipping expiration date on the specified shipping date of the shipping of the products, A step of subtracting the determined items from the inventory control data, characterized by comprising a step of unloading the product in accordance with the unloading target list.

[0007]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, typical embodiments of the present invention will be described with reference to the drawings.

FIG. 1 is a conceptual diagram showing a configuration of a warehouse management system to which the present invention is applied. This system comprises a warehouse management server 1 connected to a network via a public line, the Internet, a dedicated line, a LAN cable, etc., a plurality of terminals 2 and, if necessary, customer terminals 3. . The terminal device 2 is usually installed in each warehouse where the management of goods receipt, storage and delivery is actually performed, and an instruction for input work and delivery is output. Data input from the terminal 2 is stored in the warehouse management server 1 via the network. The calculation of the allocation work for the outgoing
It may be performed by either the warehouse management server 1 or the terminal 2. Entry and exit information can be directly input at the terminal 2, but data input at the customer terminal 3 can be received as electronic information via a network and the data can be reflected in the present system. In this way, the work of inputting twice can be omitted, and input errors can be prevented. In addition, since input, data management, calculation, and dispatch instruction work can be performed only by the warehouse management server 1 without installing the terminal device 2, the system can be operated only by the warehouse management server 1 in a small scale. it can.

FIG. 2 conceptually shows a file configuration of the warehouse management server 1. The warehouse management server 1 has a program file 4 and a data file 5. The program file 4 includes at least a delivery expiration date calculating means for calculating a delivery expiration date, and a delivery expiration date in accordance with an order for shipping a product. There is a delivery allocation means for reserving inventory items that have not exceeded. The data file 5 includes at least
Commodity management means for storing agreement items for calculating the delivery expiration date of received goods, storage management means for storing data of goods received and received, and storing data of goods received and managed as inventory. Management means for storing the data of products to be delivered in response to a delivery order.

The product management means will be described in detail.
Product management master data 1 shown in FIG. 2 as product management means
3 includes at least information for specifying a product and information on conditions for calculating a delivery deadline date of the product.
The information for specifying the product may be arbitrarily set such as a product code, a product name, a handler name, a handler code, and the like. The conditions for calculating the delivery deadline date include a criterion,
A “delivery deadline” is provided so as to be able to deal with various products managed by deadlines having different periods. The delivery deadline is a period that is subtracted from a certain expiration date in order to calculate the delivery deadline date. The delivery deadline is set in advance to take into account the period required for logistics, or to leave a certain period of time until the expiration date, to arrange in stores, or to hand over to consumers. This is the period to be set. The delivery deadline is, for example, 0 days to 365 days in consultation with the customer who leaves the product.
It can be arbitrarily set for each product in days or more, or in units of hours or years, in consideration of how much grace period until the expiration date. By setting the expiration date, it is possible to allow the computer to allocate the items to be retrieved for the stored products, so that it is not necessary for the allocation operator to check whether the expiration date has passed a certain reference date or not, and When the product reaches the consumer's hand, it is possible to reliably allocate products that do not exceed the expiration date. The expiration date is generally used for food,
In the case of merchandise other than food, for example, it may be replaced with the expiration date or the like.

FIG. 3 shows a representative example of the product management master data 13. The information includes a customer code, a product code, a delivery deadline (unit: day), and a consumption period (unit: day). Here, a customer code and a product code are used as primary keys. The merchandise of the merchandise codes 1 and 2 has a delivery deadline of 10 days, and indicates that a date obtained by subtracting 10 days from a certain reference date is the delivery deadline date. Commodity code 3 is the delivery deadline =
Since it is 0 and the consumption period is 0 days, here, it means that the product is not subjected to the delivery deadline management.
Here, the consumption period is a period set by the customer of the deposited merchandise as a period preferably consumed within a certain period from the date of manufacture or receipt. Generally set for food and seasonal products. In addition, since the product of the product code 1 is managed based on the expiration date as described below,
Consumption period is not set, here "not set"
"-" Sign is input.

The reference date of the product of the product code 1 is the expiration date, that is, the delivery expiration date is 10 days before the expiration date. Therefore, for convenience, this kind of product management form is hereinafter referred to as “expiration date management”. The reference date of the product of the product code 2 is the date of “manufacturing date (or storage date) + consumption period”, and the delivery deadline date is 10 days before this date. Therefore, this type of product management form is hereinafter referred to as “consumption period management”. A product that does not carry out the delivery time limit management, such as the product code 3, is referred to as “no delivery time limit management”.

Next, the storage management means will be described.
As the storage management means, the storage management data 14 shown in FIG. 2 includes at least information for specifying a product, a storage amount, and a management date as a reference for calculating a delivery expiration date of this product. Is done. Here, the management date is the expiration date, the manufacturing date, the storage date, or the like, and serves as a reference for calculating the delivery expiration date, and also as a reference for determining the order of allocation for delivery. Here, the management date is, for example, the expiration date in the case of the expiration date management, and the manufacturing date or the storage date in the case of no consumption period management or delivery expiration date management. Whether the management date is input by the expiration date, the manufacturing date, or the storage date may be distinguished by, for example, a “division”. Here, the division = 1 is the expiration date, and the division = 2 is the production date or the storage date. For the classification, the above-mentioned product management master data 1
3 can be set in advance for each product. FIG. 4 shows a typical example of a warehouse transaction that is the basis of warehouse management data. Here, the management date is "manufacturing date,
Alternatively, the goods input with the “storage date (section = 2)” and the consumption period = 0 are assigned as the first-in first-out order from the oldest management date without the management of the delivery period.

Next, the inventory management means will be described.
Inventory management master data 1 shown in FIG. 2 as inventory management means
5 includes at least information for specifying a product, a management date, a stock amount, and information on a calculated delivery expiration date of the product. The delivery deadline date is calculated from the management date of the above-mentioned storage management means and the delivery deadline of the product management means.
FIG. 5 shows a typical example of the inventory management master data. Here, the customer key, the product code, and the management date are used as primary keys. FIGS. 5 and 3 correspond to each other. For the product with the product code 1, the management date is entered as the expiration date (category = 1), and three types with different management dates are stocked. ". For the product with the product code 2, the management date is entered as the date of manufacture or the date of receipt (class = 2), indicating that it is "consumption period management". For the product with product code 3, the management date is the date of manufacture or the date of receipt (class =
2), and the delivery deadline date = 0,
Indicates that the product is "without delivery period management".

The delivery management data 16 shown in FIG. 2 as a delivery management means includes at least information for specifying a product, a scheduled delivery date, and information on a scheduled delivery number. FIG. 6 shows a typical example of a leaving transaction which is the basis of the leaving management data.

Next, the delivery deadline calculation program 11 shown in FIG. 2 as the delivery deadline calculation means determines when the delivery deadline date of the goods received and received is received by the storage management means and the product management. Calculate based on the expiration date and consumption period of the means, and update the data of the inventory management means regarding the product, the management date, the expiration date, and the stock amount.

FIG. 7A shows a typical example of a delivery deadline date calculation logic. Here, as shown in FIG.
Various symbols S01 to S used in the following flowcharts
04 indicates processing, judgment, display, and data, respectively.

In step S33, the storage transaction shown in FIG. 4 is created, and the product, management date, number of storage,
Enter an indicator to indicate what the control date is. Here, the division = 1 means “management date = expiration date”, and the division = 2 means “management date = manufacturing date or storage date”. Then, in step S34.1, the merchandise management master data of the product for which the receipt transaction has been created is read, and in step S34.2, it is determined whether the consumption period of the product is "consumption period = 0". If it is positive, "delivery date = 0", which means "no delivery date management", and if not, further step S34.4.
Is determined as “expiration date management” or “consumption period management”. In the case of “expiration date management”, “delivery date = management date−delivery date” is set, and in the case of “consumption period management”, “delivery date = (management date + consumption period) −delivery date”. It should be noted that the determination in step S34.4 may be, for example, a determination as to whether the classification is “1” or not, and it suffices to determine whether or not the management date is entered as the expiration date.
The management date, delivery deadline,
The expiration date is calculated based on the consumption period, and the master data of the inventory management unit is updated in step S35.

Next, a delivery allocation program 12 shown in FIG. 2 as a delivery allocation means,
It has a function of assigning, from the inventory management means, a product that does not exceed the calculated delivery expiration date on the delivery date on which the delivery of the product is specified. Products without delivery deadline management are allocated in ascending order of management date.

FIG. 8 shows an example of the delivery allocation. In step S37, a delivery transaction shown in FIG. 6 is created, and a product, a delivery date, and the number of deliveries are input. Step S
38.1. Ascending order of management date from inventory management means,
That is, the stock data of the product is read in the order of date.
In step S38.2, it is determined whether there is stock data. When there is no inventory data and the end flag is read,
In step S40, a stockout list is created which means that there is no stock to be allocated and that there is not enough merchandise. At this point, the processing can be ended, but further, step S40.5
In step S41, the inventory management master data may be updated so as to display a minus sign on the inventory management master data. In this way, it is possible to refer to the stockout list from the inventory management master data.

If there is inventory data in the determination of step S38.2, it is determined in step S38.3 whether the read inventory data has a delivery deadline set. If the delivery deadline date is not set, that is, if “delivery deadline date = 0”, it is assigned as a delivery target in step S39 as “no delivery deadline management”. If the expiration date is set in step S38.3, that is, if “expiration date = 0” is not set, it is determined in step S38.6 whether the expiration date exceeds the expiration date. . If the delivery date does not exceed the delivery deadline date, it is assigned as a delivery target in step S39, and a picking list indicating that the delivery target is a delivery list is created. In accordance with the picking list, the goods are delivered. Then, in step S40.5, the merchandise to be delivered is subtracted from the inventory management master data, and in step S41, the inventory management master data is updated.

In step S38.6, if the delivery date exceeds the delivery deadline, the process returns to step S38.1, reads the next stock data, and proceeds to the steps from step S38.2.

Next, a warehouse management method by a computer using the above-described warehouse management system will be described with reference to a flowchart of FIG. 9 showing a procedure. First, as step S31, product management master data is created. In the product management master data, a delivery deadline for calculating a delivery deadline date by moving up from a certain reference date such as a best-before date is set in advance for each product. The delivery deadline is a period that can be arbitrarily set according to the customer's request for receiving the product according to the consumption period of the product in consideration of the period required for logistics after delivery, for example, a certain period until the expiration date This period is set in order to leave the period of に in the store or to consider it to reach the consumer's hand.

Next, as step S32, a storage procedure is performed for storing and managing the goods in the warehouse and accepting the goods as stock. The merchandise, the quantity to be received, the management date, and the type of the management date as required are confirmed, and a stocking transaction is created as step S33. It is preferable to provide an item such as “division” for inputting the management date in which format. This is unnecessary when the type of the management date is previously mastered for each product.

According to the creation of the receipt transaction,
In step S34, a delivery deadline date of the received product is calculated. The delivery deadline is calculated based on the management date of the receipt transaction and the delivery deadline of the product management master data. Also, for products that do not require delivery deadline management, it is sufficient to operate without setting a delivery deadline date, use the management date for allocation of goods out of first-in first-out, and perform centralized warehouse management of products Can be.

Then, as step S 35, the stock management master data such as the stock amount of the received product, the delivery deadline date, and the management date is updated.

In response to the order for delivery in step S36,
In step S37, a delivery transaction is created. The data of the product, the date of delivery, and the number of deliveries are designated, and in response to this, in step S38, the product that meets the conditions of the delivery transaction is allocated from the stock product. As a condition, based on the delivery date of the specified product, inventory products that do not exceed the delivery deadline date of the inventory management master data are allocated. If there is an allocation target, step S39
If there is no allocation target, the stock list data is created in step S40, and each data is subtracted from the inventory management master data in step S41 to update the inventory management master data. . When the goods to be dispatched are secured, they will be deducted from the inventory management master data, so that they will not be allocated according to the next order receipt,
If there is a missing item, the missing item amount can be confirmed by referring to the inventory management master data.

If the product is delivered according to the picking list in step S42, only the product that meets the delivery order and does not expire before the product finally reaches the consumer's hand can be delivered. FIG. 10 shows a representative example of the picking list.

In step S43, the stock status at that time can be confirmed from the updated stock management master data. FIG. 11 shows a typical example of the inventory inquiry. Then, as step S44, the status of the delivery expiration on a certain specified date can be confirmed from the updated inventory management master data. The delivery expiration date means that on a specified date,
It is a product that satisfies “specified date> delivery date”. FIG. 12 shows a typical example of a delivery expiration inquiry. The return operation due to the expiration of the delivery may be performed while checking the inquiry about the expiration of the delivery. In addition, when performing the return work of expiration date,
What is necessary is just to update the returned goods to the inventory management master data. If the user wants to check the missing items in step S45, a missing item list can be created from the inventory management master data. FIG. 13 shows a typical example of the stockout list inquiry.

[0030]

As described above, according to the warehouse management system and the warehouse management method of the present invention, even if they differ for each product such as the standard and period of time limit management, the period for delivery, etc., it is possible to centrally manage the products. No need for operator confirmation,
By setting the delivery deadline according to the product expiration management in advance for each product, it is possible to reliably allocate products that have a grace period before the expiration date etc. at the time of handing over to the final customer .

[Brief description of the drawings]

FIG. 1 is a conceptual diagram showing the configuration of a warehouse management system to which the present invention has been applied.

FIG. 2 is a conceptual diagram showing a file configuration of a warehouse management server.

FIG. 3 is an explanatory diagram showing a representative example of product management master data.

FIG. 4 is an explanatory diagram showing a typical example of a storage transaction.

FIG. 5 is an explanatory diagram showing a representative example of inventory management master data.

FIG. 6 is an explanatory diagram showing a typical example of a leaving transaction.

FIG. 7 is a flowchart showing a flow of a representative example of a delivery deadline date calculation logic.

FIG. 8 is a flowchart showing a flow of a typical example of a delivery allocation logic.

FIG. 9 is a flowchart showing a procedure of a warehouse management method of the present invention.

FIG. 10 is an explanatory diagram showing a typical example of a picking list.

FIG. 11 is an explanatory diagram showing a typical example of an inventory inquiry.

FIG. 12 is an explanatory diagram showing a representative example of a delivery expiration inquiry.

FIG. 13 is an explanatory diagram showing a typical example of a missing item list inquiry.

[Explanation of symbols]

 1 Warehouse management server 2 Terminal 3 Customer terminal 4 Program file 5 Data file 11 Departure expiration date calculation program 12 Departure allocation program 13 Merchandise management master data 14 Reception management data 15 Inventory management master data 16 Departure management data

Claims (3)

[Claims] 1. A warehouse management system for managing receipt, storage, and delivery of goods, wherein data of a delivery deadline set in advance for each product for calculating a delivery deadline of the received goods is stored. Product management means, goods received, quantity, and expiration date of goods received,
Warehousing management means for storing data of management date such as manufacturing date or warehousing date, warehousing management means for storing data of outgoing goods, quantity, and warehousing date of outgoing goods, and warehousing expiration date of incoming goods Inventory management means for storing inventory data including the information of the above, a delivery deadline date calculating means for calculating a delivery deadline date of a received product from the delivery deadline and the management date, and a product delivery A warehouse management system, comprising: a warehouse allocation unit that allocates, from the inventory management unit, a product that does not exceed the warehouse expiration date on the warehouse day on which the warehouse is specified. 2. The warehouse management system according to claim 1, wherein said outgoing allocation means allocates the goods from the inventory management means in the order of the oldest management date. 3. A warehouse management method for managing receipt, storage, and exit of goods by a computer, the method comprising: preliminarily setting a delivery deadline for calculating a delivery deadline date of received goods for each product. , The goods received, the quantity, and the expiration date of the goods received,
Creating data of a management date such as a manufacturing date or a storage date; calculating a delivery deadline date of the goods received from the delivery deadline and the management date; creating inventory management data including the information of the delivery deadline. And the goods to be delivered, the quantity, and
A step of creating data of a delivery date; a step of assigning, from the inventory management data, products that have not exceeded a delivery deadline date on the delivery date on which the delivery of the product is specified, and creating a delivery target list; A warehouse management method, comprising: a step of subtracting the determined commodity from the inventory management data; and a step of releasing the commodity according to the retrieval target list.