JP4890860B2 - Shelf management apparatus and method, and computer program - Google Patents

Description

  The present invention relates to a shelf management apparatus and method, and a computer program.

A distribution center of a wholesaler has a distribution warehouse having an automatic warehouse composed of storage shelves for storing inventories and shipping shelves for temporarily storing products to be shipped, and a work space for loading and unloading packages. There is a place using. Conventionally, in such a distribution warehouse, when a product is received from a manufacturer or the like, the received product is moved and stored in a storage shelf, and the stored product is shipped from the storage shelf when the product is shipped. It has moved to the shelf.
On the other hand, Patent Document 1 describes that when a warehouse worker performs a warehousing operation, the warehousing is instructed to collect products on the same shelf for the same shipping date and the same shipping destination.
JP 11-1116012 A

  Conventionally, even when an out-of-stock product is received when an order is received, the received product is temporarily moved to the storage shelf, and then the product is moved from the storage shelf to the shipping shelf. Therefore, if the goods receipt date and the goods delivery date are the same day, even if the ordered product that was out of stock is received and once stored in the storage shelf, the product must be immediately moved to the shipping shelf for shipment. The work efficiency was not good.

  The present invention has been made in view of such circumstances, and a shelf management apparatus and method capable of efficiently performing warehousing work when an out-of-stock item is received, and a computer program The purpose is to provide.

  In order to solve the above-described problems, the present invention stores a shipping schedule slip data record including slip identification information, product identification information of a shipping schedule product, and information on the quantity sold out with respect to the order quantity of the shipping schedule product. Shelf management information storage means for storing the shipment schedule slip storage means (22) to be associated with the slip identification information and the identification information of the shipping shelf, and storing the product identification information and the storage shelf identification information in association with each other. (23), the warehousing schedule information storage means (24) for storing the warehousing schedule information including the merchandise identification information and the warehousing quantity information of the warehousing goods, and the product identification information of the warehousing goods in the warehousing schedule information. The out-of-stock slip storage means (22) is searched, and the out-of-stock slip selection means (34) for selecting the out-of-stock slip data record whose stock quantity corresponding to the product identification information is other than 0, The allocation quantity for each shipping schedule slip data record selected by the vote selecting means (34) is determined, and the shelf management information storage means (23) is selected corresponding to the slip identification information in each shipping schedule slip data record. The read shipping shelf identification information and the determined quantity stored in the shipping shelf, which is the reserved quantity for the shipping schedule slip data record, are output, and the shelf corresponding to the product identification information of the goods to be stored Calculated by subtracting the total of the allocation quantity to each shipment schedule slip data record from the storage shelf identification information read from the management information storage means (23) and the receipt quantity of the goods scheduled to be stored in the storage schedule information A shelf management device (10) comprising shelf allocation means (32) for outputting the quantity stored in the storage shelf.

  Moreover, this invention is the shelf management apparatus (10) mentioned above, Comprising: The said shelf allocation means (32) calculates the out-of-stock quantity in the said shipping schedule slip data record corresponding to the merchandise identification information of the said warehousing planned goods. It is characterized by the quantity allocated to the shipping schedule slip data record.

  Further, the present invention is the shelf management device (10) described above, wherein the shipping schedule slip data record further includes information on a shipping schedule date, and the warehousing schedule information further includes information on a scheduled warehousing date, The out-of-stock slip selection means (34) obtains from the scheduled receipt date indicated by the scheduled receipt date or the scheduled receipt date when the sold-out quantity corresponding to the product identification information is other than 0 and the planned shipment date is indicated by the scheduled receipt date. The shipping schedule slip data record which is a predetermined date to be selected is selected.

  Moreover, this invention is the shelf management method mentioned above, Comprising: It is a shelf management method used for the shelf management apparatus (10) which determines the shelf used as the movement destination of a goods scheduled to be received, Comprising: The said shelf management apparatus (10) A shipment schedule slip storage means (22) for storing a shipment schedule slip data record including slip identification information, product identification information of a shipment schedule product, and information on a quantity sold out with respect to an order quantity of the shipment schedule product; The shelf management information storage means (23) for storing the slip identification information and the shipping shelf identification information in association with each other and storing the product identification information and the storage shelf identification information in association with each other, Warehousing schedule information storage means (24) for storing warehousing schedule information including identification information and warehousing quantity information, and the shelf management device (10) is configured to identify the goods scheduled for warehousing in the warehousing schedule information. By information The out-of-stock slip storage means (22) is searched, a out-of-stock slip selection process (S1) for selecting a out-of-stock slip data record whose stock quantity corresponding to the product identification information is other than 0, and the out-of-stock slip selection The allocation quantity for each shipping schedule slip data record selected in the step (S1) is determined and read from the shelf management information storage means (23) corresponding to the slip identification information in each shipping schedule slip data record. The shipping shelf identification information and the storage quantity stored in the shipping shelf, which is the allocated quantity for the determined shipping schedule slip data record, are output, and the shelf management information corresponding to the product identification information of the goods scheduled to be received The storage shelf identification information read from the storage means (23), and the number of provisions to each shipping schedule slip data record from the warehousing quantity of the warehousing goods in the warehousing schedule information A shelf allocation process outputs the stored quantity total to-holding tube rack which is calculated by subtracting the (S2), a shelf managing method characterized in that it comprises a.

  Further, the present invention is the shelf management method described above, wherein in the shelf allocation process (S2), the out-of-stock quantity in the shipping schedule slip data record corresponding to the product identification information of the goods scheduled to be stored is the shipping quantity. It is characterized in that it is the quantity allocated to the scheduled slip data record.

  Further, the present invention is the shelf management method described above, wherein the shipping schedule slip data record further includes information on a shipping schedule date, the receiving schedule information further includes information on a scheduled shipping date, In the slip selection process (S1), the out-of-stock quantity corresponding to the product identification information is other than 0, and the scheduled delivery date is indicated by the scheduled receipt date indicated by the scheduled receipt date or the predetermined receipt date. The shipment schedule slip data record which is the day of the day is selected.

  Further, the present invention provides a computer used in the shelf management apparatus (10) for determining a shelf to which the goods scheduled for warehousing are moved, using slip identification information, product identification information for the goods scheduled for shipment, and A shipping schedule slip storage means (22) for storing a shipping schedule slip data record including information on the quantity sold out with respect to the order quantity, stores the slip identification information and the shipping shelf identification information in association with each other, and stores the product identification information Shelf management information storage means (23) for storing the storage shelf identification information in association with each other, warehousing schedule information storage means (24) for storing warehousing schedule information including product identification information and warehousing quantity information of the warehousing goods. The shipment schedule slip storage means (22) is searched based on the product identification information of the scheduled product in the receipt schedule information, and the shipping schedule slip data whose stock quantity corresponding to the product identification information is other than 0 is searched. Out-of-stock slip selection means (34) for selecting a record, the allocation quantity for each shipping-schedule slip data record selected by the out-of-stock slip selection means (34) is determined, and slips in the respective scheduled shipping slip data records Corresponding to the identification information, the shipping shelf identification information read from the shelf management information storage means (23) and the determined storage quantity on the shipping shelf, which is the allocated quantity for the shipping schedule slip data record, are output. And each shipment based on the storage shelf identification information read from the shelf management information storage means (23) corresponding to the product identification information of the goods scheduled to be received and the quantity of the goods scheduled to be stored in the goods arrival schedule information. It is made to function as a shelf allocation means (32) for outputting the storage quantity on the storage shelf calculated by subtracting the total of the allocated quantity in the scheduled slip data record. A-menu data program.

  Further, the present invention is the above-described computer program, wherein the shelf allocation means (32) determines the out-of-stock quantity in the shipping schedule slip data record corresponding to the product identification information of the goods scheduled to be received. It is characterized by the amount allocated to the data record.

Further, the present invention is the above-described computer program, wherein the shipping schedule slip data record further includes information on a scheduled shipping date, and the shipping schedule information further includes information on a scheduled shipping date, The selection means (34) has a stock out quantity corresponding to the product identification information other than 0, and a scheduled delivery date indicated by the scheduled delivery date or a predetermined date obtained from the scheduled delivery date. The shipping schedule slip data record is selected.
It should be noted that “(sign)” referred to in this column only exemplifies a corresponding configuration in a column (the best mode for carrying out the invention) to be described later, and does not indicate any claim in the claims. The interpretation is not limited.

According to the above-described invention, when goods that are out of stock are received into the warehouse of the distribution center, the quantity that has received an order but has not been allocated is directly moved to the shipping shelf assigned to each slip. It can be instructed to store and move the remaining quantity to the storage shelf for storage.
As a result, the work process from warehousing to shipment of out-of-stock items is called "arrival->picking-> shipping storage->packing->shipping" from the conventional "arrival->palletization->storage->picking->packing->shipping" It becomes a process and the work process can be made efficient.
In addition, since the products scheduled to be shipped are stored on the shipping shelves assigned to each slip, there are only workplaces that load and unload trucks, etc., and automatic warehouses that consist of storage shelves and shipping shelves. However, it is possible to efficiently use the space in a warehouse that does not have a temporary storage place for goods. In addition, it is possible to safely store the products scheduled to be shipped from among the received products, and even if multiple types of products are ordered by one voucher, the product can be stored for each voucher. Easy packing.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
A distribution center of a wholesaler having a shelf management apparatus 10 according to an embodiment of the present invention includes an automatic warehouse composed of a storage shelf for storing inventory products and a shipping shelf for temporarily storing products to be shipped, A distribution warehouse having a work space for loading and unloading is used.

FIG. 1 is a block diagram showing a configuration of the shelf management apparatus 10, and only functional blocks related to the present invention are extracted and shown.
The shelf management apparatus 10 includes a control unit 11, an input unit 12, an output unit 13, a storage unit 14, and a shelf management processing unit 15. The control unit 11 includes a CPU (central processing unit) and various memories, and controls each unit, temporarily stores data, transfers data, and the like. The input unit 12 is a keyboard, a mouse, or the like, and has a function for acquiring information input by the operator. Alternatively, information may be read from an information storage medium or information may be received from a computer device connected via a network. The output unit 13 has a function of printing information by a printer or the like and displaying an image on a display such as a CRT (cathode ray tube) or an LCD (liquid crystal display). Alternatively, information may be written to an information recording medium or output to a computer device connected via a network.

The storage unit 14 includes an inventory database (hereinafter referred to as “DB”) 21, a shipping schedule slip DB 22, a shelf management information DB 23, and a warehousing schedule DB 24.
The stock DB 21 stores stock information indicating the stock quantity of each product. The shipping schedule slip DB 22 stores shipping schedule slip information indicating the shipping schedule of products to the shipping destination and the allocation status of the products. The shelf management information DB 23 stores storage shelf management information indicating storage shelves assigned to products, and shipping shelf management information for managing shipping shelves assigned to shipping schedule slips. The warehousing schedule DB 24 stores warehousing schedule information, which is information related to warehousing scheduled products.

The shelf management processing means 15 includes an order slip processing means 31, a shelf allocation means 32, a warehousing schedule processing means 33, an out-of-stock slip selection means 34, and a shipping processing means 35.
When the order slip processing means 31 receives the data of the order slip, the order slip processing unit 31 refers to the inventory DB 21 to reserve the product, generates a shipping schedule slip, and adds the data to the shipping schedule slip DB 22. The shelf allocation means 32 assigns the shipping shelves to the shipping schedule slips, and outputs the shipping shelves and storage shelves in which the goods to be stored are to be stored and their quantities. The warehousing schedule processing means 33 updates the warehousing schedule DB 24 in response to the input of the warehousing schedule information regarding the goods scheduled to be warehousing. The out-of-stock voucher selection means 34 selects data of a shipping scheduled voucher in which the goods scheduled to be received are out of stock. The shipping processing means 35 outputs a shipping instruction at the time of shipping products from the warehouse.

FIG. 2 is a diagram illustrating a configuration example of shipping schedule slip information stored in the shipping schedule slip DB 22.
The shipping schedule slip information includes a plurality of shipping schedule slip data records. Each shipping schedule slip data record indicates the data of the shipping schedule slip generated from one order receipt slip, the slip number for uniquely identifying the shipping schedule slip, the name and address of the shipping company, etc., shipping It includes information on the scheduled date, the product identification of the product to be shipped, the order quantity, and the out-of-stock quantity for the order quantity. In this example, the slip number is the same as the slip number of the sales order slip from which the shipping schedule slip information is generated. However, a new slip number is assigned to the shipping schedule slip, and the shipping schedule is recorded in the shipping schedule slip data record. It is also possible to hold the slip number of the slip and the slip number of the order slip that has been generated.
In the figure, the shipping schedule slip of the slip number “100” has a shipping destination name “XX”, a shipping destination address “XX prefecture XX city ...”, a shipping scheduled date “200X / XX / XX”, and a product identification. The order quantity of the product scheduled for shipment of “A” is “30”, the in-stock quantity is “30”, the order quantity of the product to be shipped of product identification “B” is “3”, and the in-stock quantity is It is “3”.

FIG. 3 is a diagram illustrating a configuration example of storage shelf management information stored in the shelf management information DB 23.
The storage shelf management information includes information that associates the product identification with the shelf number of the storage shelf.
The storage shelf management information shown in the figure is that the shelf number of the storage shelf of the product with the product identification “A” is “F12”, the shelf number of the storage shelf of the product with the product identification “B” is “G34”,. Is shown.

FIG. 4 is a diagram illustrating a configuration example of the shipping shelf management information stored in the shelf management information DB 23.
The shipping shelf management information includes information on the slip number of the shipping schedule slip, the shelf number of the shipping rack, the product identification of the shipping schedule product, and the stored quantity.
In the shipping shelf management information shown in the figure, the shelf number of the shipping shelf for temporarily storing the product shipped by the shipping scheduled slip with the slip number “100” is “T56”, and the product identification “A”, This indicates that the shipping scheduled product with the product identification “B” is not currently stored in the storage shelf (“0” items are stored).

FIG. 5 is a diagram illustrating a configuration example of the warehousing schedule information stored in the warehousing schedule DB 24.
The warehousing schedule information includes information on the product identification of the warehousing scheduled product, the scheduled warehousing date, and the warehousing quantity. In the warehousing schedule information shown in the figure, the warehousing scheduled date of the warehousing scheduled product with the product identification “A” is “200X / XX / XX”, the scheduled warehousing quantity is “100”, and the product identification “B”. It shows that the scheduled arrival date of the planned receipt item is “200X / XX / XX”, the scheduled receipt quantity is “10”, and so on.

FIG. 6 shows a procedure from warehousing to shipping using the shelf management apparatus 10.
Upon receipt of the product identification of the goods scheduled to be received, the expected date of goods storage, and the quantity of goods received via the input means 12, the warehousing schedule processing means 33 of the shelf management apparatus 10 receives these information in the warehousing schedule DB 24. Register in the warehousing schedule information. When the out-of-stock slip selection means 34 reads the warehousing schedule information registered from the warehousing schedule DB 24, the product identification of each warehousing commodity indicated by the read warehousing schedule information is referred to the shipping schedule slip DB 22 and the warehousing is performed. A shipment schedule slip data record is selected in which the out-of-stock quantity corresponding to the product identification of the scheduled product is not 0, and the scheduled delivery date is the same as the scheduled receipt date (step S1).

  Next, the shelf allocation means 32 of the shelf management apparatus 10 refers to the storage shelf management information in the shelf management information DB 23, and performs the following for each product identification of each warehousing scheduled product indicated by the warehousing scheduled information read in step S1. Do. That is, the shelf allocation means 32 reads the shelf number of the storage shelf corresponding to the product identification of the goods scheduled to be stored, and executes any one of the following processes (1) to (3) (step S2).

  (1) If there is no shipping schedule slip data record selected for the product identification of the warehousing scheduled product in step S1, the shelf allocation means 32 of the shelf management apparatus 10 identifies the product identification of the warehousing scheduled product, The output means 13 outputs the storage number corresponding to the product identification and the storage quantity that is the same quantity as the warehousing quantity.

  (2) There is a shipping schedule slip data record selected for the product identification of the goods scheduled to be received in step S1, and the total out-of-stock quantity of the goods scheduled to be received obtained from the selected shipping schedule slip data record is received. When the quantity is the same as or less than the quantity (total of out-of-stock quantity ≦ stock quantity), the shelf allocation means 32 allocates the quantity for the out-of-stock quantity for all selected shipping schedule slip data records. Specifically, the shelf allocation means 32 reads out and sums out the out-of-stock quantity corresponding to the product identification of the goods scheduled to be received from all the selected shipping-scheduled slip data records, and the total of this out-of-stock quantity is the received quantity. By subtracting from, the quantity stored in the storage shelf is calculated. Further, the shelf allocation means 32 refers to the shipping shelf management information in the shelf management information DB 23 and reads the shelf number of the shipping shelf corresponding to the slip number of each selected shipping schedule slip data record. Then, the following processing is performed for each selected shipping schedule slip data record. That is, the shelf allocation means 32 uses the slip number of the shipping schedule slip data record and the stored quantity in the shipping shelf management information corresponding to the product identification of the goods scheduled to be received as the product identification of the goods scheduled to be stored in the shipping schedule slip data record. It is updated to the quantity obtained by adding the out-of-stock quantity corresponding to. Further, the shelf allocation means 32 updates the out-of-stock quantity corresponding to the product identification of the goods scheduled to be stored in the shipping schedule slip data record to 0. The shelf allocation means 32 identifies the product to be received, the shelf number of the storage shelf of the product to be stored and the storage quantity in the storage shelf, the shelf number of the shipping shelf corresponding to the selected shipping schedule slip data record, and the shipping shelf. The quantity stored in is output. The stored quantity in the shipping shelf is the allocated quantity, that is, the out-of-stock quantity before allocating the goods scheduled to be received.

  (3) There is a shipping schedule slip data record selected for the product identification of the goods scheduled to be received in step S1, and the total out-of-stock quantity of the goods scheduled to be received obtained from the selected shipping schedule slip data record is received. When the quantity is larger than the quantity (total of out-of-stock quantities> receipt quantity), the shelf allocation means 32 may temporarily store all receipt quantities of the goods scheduled to be received on the storage shelf, and the goods scheduled to be received are scheduled to be shipped in order of priority. You may make it reserve in a slip data record. As the priority, for example, the order in which the order slip that is the basis for generating the shipping schedule slip is registered in order, the shipping destination in which the transaction amount or the transaction amount is large, the order of importance of the shipping destination registered in advance is used. . In addition, if the quantity scheduled to be received is 50% of the total out-of-stock quantity, 50% of the out-of-stock quantity may be allocated for each shipping schedule slip. The shelf allocation means 32 updates the storage number in the shipping shelf management information corresponding to the slip identification of the shipping schedule slip data record to be allocated and the product identification of the goods scheduled to be received, to the quantity obtained by adding the allocated quantity, The out-of-stock quantity corresponding to the product identification of the goods scheduled to be received in the shipping schedule slip data record is updated to a quantity obtained by subtracting the allocated quantity. The shelf allocation unit 32 outputs the product identification of the goods scheduled to be received, the shelf number and storage quantity of the storage shelf, the shelf number of the shipping shelf, and the storage amount (allocation amount) in the shipping shelf. The quantity stored in the storage shelf is a quantity obtained by subtracting the total of the reserved quantity from the quantity received.

When the goods scheduled to be received are received, the worker works to store the specified quantity of the goods scheduled to be stored in the storage shelf or the shipping shelf of the specified shelf number according to the information output by the shelf management apparatus 10. (Step S3).
Subsequently, the person in charge of the shipping instruction inputs the shipping information such as the shipping date and the slip number of the slip to be shipped, and the shipping instruction to the shelf management apparatus 10 (step S4). When the shipping processing means 35 of the shelf management apparatus 10 receives the shipping information and the shipping instruction via the input means 12, the shipping schedule slip data record specified by the slip number input in step S4 is sent to the shipping schedule slip DB22. And the shelf number of the shipping shelf corresponding to the slip number is read from the shipping shelf management information in the shelf management information DB 23. Then, the shipping processing means 35 generates a shipping instruction from the read shelf number of the shipping shelf and the read shipping schedule slip data record, and causes the output means 13 to output it (step S5). The shipping order includes information on the slip number in the shipping scheduled slip data record, the product identification and shipping quantity of the shipping scheduled product, and the shelf number of the storage shelf. Based on the shipping instruction output from the shelf management device 10, the worker packs the goods stored in the storage shelf with the designated shelf number for each slip, and loads them on a truck for shipment (step S6).

  In step S1, the shipping schedule slip data record whose shipping date is the same as the scheduled receipt date is selected, but the shipping schedule slip whose scheduled shipping date is within a predetermined number of days from the scheduled delivery date. A data record may be selected.

Next, a specific processing example in the shelf management apparatus 10 will be described.
FIG. 7 is a diagram illustrating a processing flow in the shelf management apparatus 10.
The shelf management information DB 23 of the shelf management apparatus 10 indicates that the shelf number of the storage shelf of the product with the product identification “A” is “F12”, and the shelf number of the storage shelf of the product with the product identification “B” is “G34”. It is assumed that storage shelf management information shown is stored in advance. The stock DB 21 stores stock information indicating that the stock quantity of the product with the product identification “A” and the product with the product identification “B” is “0”.

  Order receiving slip information including information on the order quantity “30” of the product with the product number “100”, the product identification “A”, and the order quantity “3” of the product with the product identification “B” is input to the shelf management apparatus 10. (Step S110). When the order slip processing means 31 of the shelf management apparatus 10 receives the input of order slip information via the input means 12, the order slip processing means 31 refers to the stock information in the stock DB 21 and performs the allocation process. The order slip processing means 31 has an inventory of “0” for the products with the product identifications “A” and “B”, so the out-of-stock quantity of the product with the product identification “A” is “30” and the product identification “B”. The out-of-stock quantity of the product is “3”. The order slip processing means 31 creates a shipping schedule slip data record from the order slip information and the out-of-stock quantity and registers it in the shipping schedule slip DB 22.

  Subsequently, the shelf management unit 34 assigns a shipping shelf to the registered shipping schedule slip data record, and adds data to the shipping shelf management information in the shelf management information DB 23 (step S120). In this case, the shipping shelf management information stores the assigned shelf number “T56”, the product identifications “A” and “B” in the shipping schedule slip data record, and the quantities allocated to these products. Quantity is set. Here, since the inventory of the products with the product identifications “A” and “B” has not been allocated, “0” is set as the stored quantity.

  At a later date, warehousing slip information including information that the warehousing scheduled quantity of the warehousing scheduled product with the product identification “A” is “100” is input to the shelf management apparatus 10 (step S130). The receipt schedule processing means 33 of the shelf management apparatus 10 updates the receipt information in the receipt schedule DB 24 when receiving the receipt slip information via the input means 12. Subsequently, the out-of-stock slip selection means 34 is out of stock when the product with the product identification “A” in the inbound voucher information is out of stock, that is, the out-of-stock quantity is other than 0 and the planned delivery date is the same as the scheduled delivery date. Select the scheduled slip data record. Here, it is assumed that only the shipping schedule slip data record with the slip number “100” is selected.

  Since the stockout quantity of the product identification “A” in the shipping schedule slip data record selected by the stockout slip selection means 34 is “30”, the shelf allocation means 32 is “30” out of the quantity “100” scheduled to be received. ”And the storage quantity on the storage shelf is“ 70 ”obtained by subtracting the provision quantity“ 30 ”from the receipt quantity“ 100 ”. The shelf allocation means 32 updates the out-of-stock quantity in the shipping schedule slip data record corresponding to the product identification “A” to “0” obtained by subtracting the provisioned quantity “30” from the current “30”, and the slip number The stored quantity in the shipping shelf management information corresponding to “100” and the product identification “A” is updated to “30” obtained by adding the allocated quantity “30” to the current stored quantity “0”. Subsequently, the shelf allocation unit 32 refers to the shelf management information DB 23, determines the shelf number “T56” of the shipping shelf corresponding to the slip number “100” from the shipping shelf management information, and the product identification “A” from the storage shelf management information. The shelf number “F12” of the storage shelf corresponding to is read. The shelf allocation means 32 moves the allocation amount “30” of the product with the product identification “A” to the shelf number “T56” of the shipping shelf and moves the storage amount “70” to the shelf number “F12” of the storage shelf. The instruction is output by the output means 13. Further, the warehousing schedule processing means 33 adds the stock quantity corresponding to the product identification “A” in the stock information stored in the stock DB 21 to “70” obtained by adding the storage quantity “70” to the current stock quantity “0”. (Step S140).

  At a later date, warehousing slip information including information that the warehousing planned quantity of the warehousing scheduled product with the product identification “B” is “10” is input to the shelf management apparatus 10 (step S150). The receipt schedule processing means 33 of the shelf management apparatus 10 updates the receipt information in the receipt schedule DB 24 when receiving the receipt slip information via the input means 12. Subsequently, the out-of-stock slip selection means 34 is out of stock for the product with the product identification “B” in the inbound receipt information, that is, the out-of-stock quantity is other than 0, and the scheduled delivery date is the same as the scheduled delivery date. Select the scheduled slip data record. Here, it is assumed that only the shipping schedule slip data record with the slip number “100” is selected.

  Since the out-of-stock quantity of the product identification “B” in the shipping schedule slip data record selected by the out-of-stock slip selection means 34 is “3”, the shelf allocation means 32 is “3” out of the quantity “10” scheduled to be received. And the storage quantity on the storage shelf is “7” obtained by subtracting the provision quantity “3” from the receipt quantity “10”. The shelf allocation means 32 updates the out-of-stock quantity in the shipping schedule slip data record corresponding to the product identification “A” to “0” obtained by subtracting the provisioned quantity “3” from the current “3”, and the slip number The stored quantity in the shipping shelf management information corresponding to “100” and the product identification “B” is updated to “3” obtained by adding the allocated quantity “3” to the current stored quantity “0”. Subsequently, the shelf allocation unit 32 refers to the shelf management information DB 23, and determines the shelf number “T56” of the shipping shelf corresponding to the slip number “100” from the shipping shelf management information, and the product identification “B” from the storage shelf management information. The shelf number “G34” of the storage shelf corresponding to is read. The shelf allocation means 32 moves the allocation quantity “3” of the product with the product identification “B” to the shelf number “T56” of the shipping shelf, and moves the storage amount “7” to the shelf number “B34” of the storage shelf. The instruction is output by the output means 13. Further, the warehousing schedule processing means 33 adds the stock quantity corresponding to the product identification “B” in the stock information stored in the stock DB 21 to “7” obtained by adding the storage quantity “7” to the current stock quantity “0”. (Step S160).

  Thereafter, shipping information such as a shipping date and a slip number of a slip to be shipped, and a shipping instruction are input to the shelf management apparatus 10 (step S170). When the shipping processing unit 35 of the shelf management apparatus 10 receives the shipping information and the shipping instruction via the input unit 12, the shipping processing unit 35 uses the slip number “100” of the shipping plan slip data record included in the shipping information to store the shipping plan slip DB 22. And the shelf number “T56” of the shipping shelf corresponding to the slip number “100” is read from the shipping shelf management information in the shelf management information DB 23. Then, the merchandise identification “100” read from the shipping shelf management information corresponding to the slip number “100”, the shipping destination, the shipping shelf shelf number “T56”, and the shipping shelf shelf number “T56” in the specified shipping slip data record. A shipping instruction including information such as a shipping quantity “30” that is a stored quantity of “A”, a shipping quantity “3” that is a stored quantity of product identification “B”, and the like is output (step S180).

According to the above embodiment, when a product that is out of stock is received into the warehouse of the distribution center, the quantity that has received an order but has not been allocated is directly moved to the shipping shelf assigned to each slip. The remaining quantity can be instructed to be moved to a storage shelf for storage.
As a result, the work process from warehousing to shipment of out-of-stock items is called "arrival->picking-> shipping storage->packing->shipping" from the conventional "arrival->palletization->storage->picking->packing->shipping" It becomes a process and the work process can be made efficient.
In addition, since the products scheduled to be shipped are stored on the shipping shelves assigned to each slip, there are only workplaces that load and unload trucks, etc., and automatic warehouses that consist of storage shelves and shipping shelves. However, it is possible to efficiently use the space in a warehouse that does not have a temporary storage place for goods. In addition, it is possible to safely store the products scheduled to be shipped from among the received products, and even if multiple types of products are ordered by one voucher, the product can be stored for each voucher. Easy packing. Further, by storing the allocated product in the shipping shelf in this way, it is possible to clearly recognize whether or not the allocated product has been allocated. Further, when the ordered product is in stock, it can be reserved from the stock in advance.

  In addition, the above-described shelf management apparatus 10 has a computer system therein. The operation process of each means in the shelf management processing means 15 of the shelf management apparatus 10 described above is stored in a computer-readable recording medium in the form of a program, and this program is read and executed by the computer system. Thus, the above process is performed. The computer system here includes an OS and hardware such as peripheral devices.

Further, the “computer system” includes a homepage providing environment (or display environment) if a WWW system is used.
The “computer-readable recording medium” refers to a storage device such as a flexible medium, a magneto-optical disk, a portable medium such as a ROM and a CD-ROM, and a hard disk incorporated in a computer system. Furthermore, the “computer-readable recording medium” dynamically holds a program for a short time like a communication line when transmitting a program via a network such as the Internet or a communication line such as a telephone line. In this case, a volatile memory in a computer system serving as a server or a client in that case, and a program that holds a program for a certain period of time are also included. The program may be a program for realizing a part of the functions described above, and may be a program capable of realizing the functions described above in combination with a program already recorded in a computer system.

It is a block diagram which shows the structure of the shelf management apparatus by one Embodiment of this invention. It is a figure which shows the example of the shipping schedule slip information which the shelf management apparatus shown in FIG. 1 hold | maintains. It is a figure which shows the example of the storage shelf management information which the shelf management apparatus shown in FIG. 1 hold | maintains. It is a figure which shows the example of the shipping shelf management information which the shelf management apparatus shown in FIG. 1 hold | maintains. It is a figure which shows the example of the warehousing schedule information which the shelf management apparatus shown in FIG. 1 hold | maintains. It is a figure which shows the flow from the warehousing to the leaving using the shelf management apparatus shown in FIG. It is a figure which shows the processing flow in the shelf management apparatus shown in FIG.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 ... Shelf management apparatus 11 ... Control means 12 ... Input means 13 ... Output means 14 ... Storage means 15 ... Shelf management processing means 21 ... Inventory DB
22 ... Shipment schedule slip DB
23 ... Shelf management information DB
24 ... Warehouse plan DB
31 ... Order slip processing means 32 ... Shelf allocation means 33 ... Receiving schedule processing means 34 ... Out of stock slip selection means 35 ... Shipping processing means

Claims (9)

A shipping schedule slip storage means for storing a shipping schedule slip data record including slip identification information, product identification information of the shipping schedule product, and information on the quantity sold out with respect to the order quantity of the shipping schedule product;
A shelf management information storage means for storing the slip identification information and the shipping shelf identification information in association with each other, and storing the product identification information and the storage shelf identification information in association with each other;
Warehousing schedule information storage means for storing warehousing schedule information including product identification information and warehousing quantity information of the warehousing goods;
The out-of-stock slip selection means for searching the shipment-scheduled slip storage means based on the product identification information of the goods scheduled to be stored in the warehousing-scheduled information, and selecting the shipping-scheduled slip data record whose stock quantity corresponding to the product identification information is other than 0 Means,
The shipment shelf read from the shelf management information storage means corresponding to the slip identification information in each shipment schedule slip data record determined by the stock slip selection means selected by each shipment schedule slip data record And the shelf management information storage means corresponding to the product identification information of the goods scheduled to be received, and the storage quantity on the shipping shelf which is the allocated quantity for the determined shipping schedule slip data record. If the reserved quantity is smaller than the storage quantity and the storage shelf identification information read out from, the total of the reserved quantity in each shipping schedule slip data record is subtracted from the incoming quantity of the planned incoming goods in the incoming scheduled information. Shelf allocation means for outputting the storage quantity calculated in the storage shelf,
Equipped with a,
The shelf allocating means allocates all the scheduled goods to be stored to a storage shelf or allocates the goods to be stored to a shipping schedule slip data record in a predetermined priority order when the reserved quantity is larger than the quantity to be received. Management device. The shelf allocation means uses the out-of-stock quantity in the shipping schedule slip data record corresponding to the product identification information of the goods scheduled to be stored as the allocation quantity to the shipping schedule slip data record,
The shelf management apparatus according to claim 1. The shipping schedule slip data record further includes scheduled shipping date information,
The warehousing schedule information further includes information on a scheduled warehousing date,
The out-of-stock slip selection means has a stock-out quantity corresponding to the product identification information other than 0, and a scheduled delivery date indicated by the scheduled entry date or a predetermined date obtained from the scheduled receipt date. Select a shipping document data record that is a day,
The shelf management apparatus according to claim 1 or 2, characterized in that A shelf management method used in a shelf management device that determines a shelf to which a product to be stored is to be moved,
The shelf management device
A shipping schedule slip storage means for storing a shipping schedule slip data record including slip identification information, product identification information of the shipping schedule product, and information on the quantity sold out with respect to the order quantity of the shipping schedule product;
A shelf management information storage means for storing the slip identification information and the shipping shelf identification information in association with each other, and storing the product identification information and the storage shelf identification information in association with each other;
Warehousing schedule information storage means for storing the warehousing schedule information including the product identification information of the warehousing scheduled goods and the information of the warehousing quantity,
The shelf management device is
The out-of-stock slip selection means for searching the shipment-scheduled slip storage means based on the product identification information of the goods scheduled to be stored in the warehousing-scheduled information, and selecting the shipping-scheduled slip data record whose stock quantity corresponding to the product identification information is other than 0 Process,
Shipment read out from the shelf management information storage means corresponding to the slip identification information in each shipment schedule slip data record determined in the shipment schedule slip data record selected in the stockout slip selection process The shelf identification information and the storage quantity stored in the shipping shelf, which is the allocated quantity for the shipping schedule slip data record determined, are output, and the shelf management information storage is stored corresponding to the product identification information of the goods scheduled to be received If the storage shelf identification information read from the means and the provision quantity is smaller than the receipt quantity, the total of the provision quantity in each shipment schedule slip data record is subtracted from the receipt quantity of the planned receipt goods in the receipt schedule information. A shelf allocation process for outputting the storage quantity calculated in the storage shelf,
I have a,
In the shelf allocation process, when the reserved quantity is larger than the warehousing quantity, all the warehousing scheduled products are allocated to the storage shelves, or the warehousing scheduled products are allocated to the shipping scheduled slip data record in a predetermined priority order. Management method. In the shelf allocation process, the out-of-stock quantity in the shipping schedule slip data record corresponding to the product identification information of the goods scheduled to be stored is set as the allocated quantity in the shipping schedule slip data record.
The shelf management method according to claim 4. The shipping schedule slip data record further includes scheduled shipping date information,
The warehousing schedule information further includes information on a scheduled warehousing date,
In the out-of-stock slip selection process, the out-of-stock quantity corresponding to the product identification information is other than 0, and the scheduled shipment date is indicated by the scheduled receipt date indicated by the scheduled receipt date or the predetermined date obtained from the scheduled receipt date. Select the scheduled delivery slip data record,
The shelf management method according to claim 4 or 5, characterized by the above. A computer used in the shelf management device that determines the shelf to which the goods to be stored will be moved,
A shipping schedule slip storage means for storing a shipping schedule slip data record including slip identification information, product identification information of the shipping schedule product, and information on the out-of-stock quantity for the ordered quantity of the shipping schedule product;
Shelf management information storage means for storing the slip identification information and the shipping shelf identification information in association with each other, and storing the product identification information and the storage shelf identification information in association with each other;
Warehousing schedule information storage means for storing warehousing schedule information including product identification information and warehousing quantity information of the warehousing goods,
The out-of-stock slip selection means for searching the shipment-scheduled slip storage means based on the product identification information of the goods scheduled to be stored in the warehousing-scheduled information, and selecting the shipping-scheduled slip data record whose stock quantity corresponding to the product identification information is other than 0 means,
Shipment read out from the shelf management information storage means corresponding to the slip identification information in each shipping schedule slip data record determined by the shipment slip slip data record selected by the out-of-stock slip selection means The shelf identification information and the storage quantity stored in the shipping shelf, which is the allocated quantity for the shipping schedule slip data record determined, are output, and the shelf management information storage is stored corresponding to the product identification information of the goods scheduled to be received If the storage shelf identification information read from the means and the provision quantity is smaller than the receipt quantity, the total of the provision quantity in each shipment schedule slip data record is subtracted from the receipt quantity of the planned receipt goods in the receipt schedule information. Shelf allocation means for outputting the quantity stored in the storage shelf calculated by
To function as,
The shelf allocation means assigns all the scheduled goods for storage to the storage shelves or allocates the goods scheduled for receipt to the shipping schedule slip data record in a predetermined priority order when the reserved quantity is larger than the quantity received. . The shelf allocation means uses the out-of-stock quantity in the shipping schedule slip data record corresponding to the product identification information of the goods scheduled to be stored as the allocation quantity to the shipping schedule slip data record,
The computer program according to claim 7. The shipping schedule slip data record further includes scheduled shipping date information,
The warehousing schedule information further includes information on a scheduled warehousing date,
The out-of-stock slip selection means has a stock-out quantity corresponding to the product identification information other than 0, and a scheduled delivery date indicated by the scheduled entry date or a predetermined date obtained from the scheduled receipt date. Select a shipping document data record that is a day,
The computer program according to claim 7 or claim 8, characterized by that.

Images