JP5053536B2 - Warehouse management apparatus and method, and computer program - Google Patents

Description

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

There are distribution companies that take care of products from manufacturers such as commercial electric products, pack them, and deliver them to designated destinations. In such a distribution company, a warehouse management system conventionally used generates a receipt slip data record when a product is received from a manufacturing company. The receipt slip data record includes information on the product item number and the production number. The production number is a number used to specify a manufactured product such as a production lot number of the product, and the item number is a number used to specify a commodity to be traded. In the warehouse management system, each distribution stage of a product is managed by an item number. For example, a delivery slip data record is generated based on an item number registered when a product is delivered or when a receipt slip data record is input. Therefore, in the warehouse management system, it has been necessary to input an item number from the time when the receipt slip data record is generated.
On the other hand, in the technology of Patent Document 1, drug data in which a drug name, a drug code, and a merchandise distribution code are associated with each other is stored. The warehousing process is performed using the merchandise distribution code, and the warehousing process is performed using the pharmaceutical code, the merchandise distribution code, or an intermediate code associated with these codes. In addition, inventory management is performed using a pharmaceutical code, a merchandise distribution code, or an intermediate code associated with these codes.
JP 2005-115878 A

  When the product is received, the item number may not be determined depending on the type of industry of the manufacturing company. In the conventional warehouse management system, if the item number is not determined, the receipt slip data record cannot be generated, and there is a problem that the warehouse management of the product cannot be performed. However, in the above-described prior art, it is not assumed that the warehousing process is performed without determining the item number.

  The present invention has been made in view of such circumstances, and it is an object of the present invention to provide a warehouse management apparatus and method, and a computer program, which can perform a product warehousing process while items are undetermined. .

  In order to solve the above-described problems, the present invention provides a storage means (12) for storing a warehousing slip data record including product number and product number information of a received product and association data for associating the product number and product number. ) And the product number of the received product, and the receipt slip data record including the dummy product number and the entered product number information is generated and written to the storage means (12). Upon receiving information on the generation means (14), the product number, and the confirmed product number, information that associates the received product number with the product number is added to the association data in the storage means (12). The linking data writing means (16) and the linking data writing means (16) specify the receipt slip data record in the storage means (12) by the product number received. In response to the product number in the received receipt slip data record, information indicating that the product number is confirmed is written in the storage means (12), and a dummy corresponding to the product number in the specified receipt slip data record is written. A slip regenerating means (17) for newly generating a warehousing slip data record in which the product number is changed to the product number received by the association data writing means (16) and writing it in the storage means (12). And a warehouse management device (1).

  Moreover, this invention is the warehouse management apparatus (1) mentioned above, Comprising: The said receipt slip data record further contains the information which shows the status of the goods received, The said slip regeneration means (17) specified Information indicating that the product number is confirmed is written by rewriting the status corresponding to the product number in the warehousing slip data record to information indicating that the product has been delivered.

  Further, the present invention is a warehouse management method used in a warehouse management device (1) for managing the distribution of products in a warehouse, and includes a warehousing slip data record including product number and product number information of a received product, A storage means (12) for storing the product number and the association data for associating the product number is provided, receives the product number of the received product, and includes the dummy product number and the input product number information. The receipt slip generation process (S110, S130, S140) for generating the receipt slip data record and writing it in the storage means (12), the product number, and the information of the confirmed product number are input and received. A linking data writing process (S210, S220) for adding information associating the product number and the product number to the linking data in the storage means (12), and the linking data The goods receipt slip data record in the storage means (12) is specified by the product number received in the writing process (S210), and the product number is determined corresponding to the product number in the specified goods receipt slip data record. Information indicating that the product has been written is stored in the storage means (12), and a dummy product number corresponding to the product number in the specified receipt slip data record is received in the associating data writing process (S210). And a slip regenerating process (S230, S240) for newly generating a receipt slip data record changed to the product number and writing it in the storage means (12).

  Further, the present invention is the above-described warehouse management method, wherein the warehousing slip data record further includes information indicating a status of a warehousing product, and in the slip regeneration process (S230), the specified warehousing slip Information indicating that the product number is confirmed is written by rewriting the status corresponding to the product number in the data record to information indicating that the product has been delivered.

  The present invention also provides a computer used in the warehouse management apparatus (1) for managing the distribution of products in a warehouse, a warehousing slip data record including the product number and product number information of the received product, and the product number and product. The storage means (12) for storing the associating data for associating the number, receiving the product number of the received product, and receiving the receipt slip data record including the dummy product number and the entered product number information The receipt slip generation means (14) that generates and writes the information to the storage means (12), receives information on the product number and the confirmed product number, and associates the received product number with the product number. The association data writing means (16) to be added to the association data in the storage means (12), and the storage by the product number received by the association data writing means (16). The warehousing slip data record in the stage (12) is specified, and information indicating that the product number is confirmed is written in the storage means (12) in correspondence with the product number in the specified warehousing slip data record, A new warehousing slip data record is generated by replacing the dummy product number corresponding to the product number in the specified warehousing slip data record with the product number received by the linking data writing means (16). A computer program which functions as a slip regenerating means (17) to be written in the storage means (12).

The present invention is the above-described computer program, wherein the warehousing slip data record further includes information indicating the status of the product received, and the slip regenerating means (17) The information corresponding to the product number is rewritten to information indicating that the product has been delivered, thereby writing information indicating that the product number has been confirmed.
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 said invention, a receipt slip can be produced also about the product in which a product number is undetermined, and a receipt process can be performed. Moreover, since the same warehousing slip as usual is generated using the dummy product number, distribution management similar to usual can be performed after warehousing. In addition, when a formal product number is determined, a distribution history from the receipt of the product must be maintained in order to generate a new receipt slip of the official product number while maintaining a receipt slip using a dummy product number. Can do.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram showing a configuration of a warehouse management system according to an embodiment of the present invention. A warehouse management device 1 owned by a distribution company is connected to a portable terminal 2 of a warehouse worker and a terminal 3 of an office worker via a network N. The network N is an IP network constituted by a LAN (Local Area Network), a wireless LAN, or the like. The portable terminal 2 of the warehouse worker is a portable computer terminal having a reading function such as a bar code reader or an IC tag reader for reading an IC (Integrated Circuit) tag such as an RFID (Radio Frequency Identification) tag. The office worker's terminal 3 is a personal computer.

FIG. 2 is a block diagram showing the interior of the warehouse management apparatus 1 in an expanded manner. The warehouse management apparatus 1 includes a control unit 10, a communication unit 11, a storage unit 12, and a slip generation unit 13.
The control means 10 comprises a central processing unit (CPU) and various memories, and controls each part, temporarily stores data, transfers data, and the like. The communication means 11 transmits and receives data via the network N.

  The storage unit 12 stores a slip data record in which various slips such as a receipt slip, a transfer order, an order receipt slip, and a shipping slip are converted into data. The storage unit 12 further stores association data that is data for associating the product number with the product number. Here, the production number is used as the product number, and the item number is used as the product number. The item number is a number that uniquely identifies a product to be traded and managed, and the warehouse management device 1 manages the product by this item number. The production number is, for example, a number for specifying a produced product, such as a production lot number. That is, even if the item is the same as the product, the production number may be different if the production date or production line is different.

The slip generation unit 13 includes a receipt slip generation unit 14, a transfer instruction generation unit 15, a linking data writing unit 16, a slip regeneration unit 17, an order slip generation unit 18, and a shipping slip generation unit 19.
The receipt slip generation unit 14 generates a receipt slip data record and writes it in the storage unit 12. The receipt slip generation means 14 generates a receipt slip data record using a dummy item number when the item of the receipt product has not been determined. The transfer instruction generation unit 15 generates a transfer instruction record and writes it in the storage unit 12. The linking data writing means 16 receives the product manufacturing number and the information of the official item number corresponding to the manufacturing number, and adds the information to the linking data in the storage means 12. The slip regeneration means 17 generates a new receipt slip data record using the confirmed item number from the receipt slip data record generated using the dummy item number when the data is added to the association data. Then, the data is written in the storage unit 12. The order slip generation means 18 generates an order slip data record and writes it in the storage means 12. The shipping slip generation means 19 generates a shipping slip data record and writes it in the storage means 12.

FIG. 3 is a diagram illustrating a configuration example of the warehousing slip data record.
The receipt document data record includes the document number for uniquely identifying the receipt document data record, the document date indicating the date when the receipt document was issued, the receipt date indicating the date when the product was received, and the received product The company code for specifying the manufacturing company and the data of the details indicating the information of the received product are included. Each line of the detailed data includes data of the item number, the manufacturing number, the received quantity, and the quantity in each status of the received product. The status includes received, allocated, shipped, and the like.

FIG. 4 is a diagram illustrating a configuration example of the association data.
The association data indicates data for associating the product item number with the production number. Only the officially used item number is registered here, and the dummy item number used when the official item number is not confirmed is not registered.

FIG. 5 is a diagram illustrating a configuration example of a transfer instruction record.
The transfer order record includes the slip number for uniquely identifying the transfer order record, the slip date indicating the date when the transfer order was issued, the transfer date indicating the date of transfer, the company code, and the product information to be transferred The data of the specification which shows is included. Each line of the details includes data on the item number, serial number, transfer quantity, transfer source location, and transfer destination location of the product to be transferred.

Next, the operation procedure of the warehouse management system will be described.
FIG. 6 is a diagram illustrating a warehousing process flow in the warehouse management apparatus 1.
First, when a product to be received by a truck or the like is conveyed to the warehouse, the warehouse worker transmits warehousing information and a warehousing slip generation request from the portable terminal 2 to the warehouse management device 1. The warehousing information includes information such as the warehousing date of the product, the company code of the manufacturing company, the manufacturing number, and the warehousing quantity. When the item number has already been determined, information on the item number associated with the production number can be included in the warehousing information. The warehousing date may be acquired from a clock provided in the portable terminal 2 or may be input by a warehouse worker using an input means such as a key. Further, the serial number of the product to be received is read by the portable terminal 2 from a barcode or RFID tag attached or printed on a product packaging material or the like. The quantity received can be counted according to how many times the same serial number has been read.

  When the receipt slip generation means 14 of the warehouse management device 1 receives the receipt information and the receipt slip generation request transmitted from the mobile terminal 2 via the communication means 11 (step S110), the receipt slip generation means 14 assigns a new slip number, It is determined whether the item number corresponding to the production number is included in the warehousing information (step S120). Alternatively, the association data may be searched by the production number in the warehousing information to determine whether the item number is registered. If there is no item number corresponding to the production number (step S120: NO), the warehousing slip generation means 14 uses a dummy item number, that is, an item number that is temporarily used until a formal item number is determined (hereinafter referred to as “dummy”). (Item number ") is assigned (step S130). This is done by registering dummy item numbers that can be used in the storage means 12 in advance and assigning one of them.

  The receipt slip generation means 14 generates a receipt slip data record based on the receipt information. That is, the slip number, slip date, receipt date, company code, production number and receipt quantity of each detail line, the assigned slip number, the current date, the receipt date included in the receipt information, the manufacturer's Set company code, serial number and receipt quantity. Further, in the detail line of the receipt slip data record, if there is no official item number, the dummy item number assigned in step S130 is associated with the production number, and if there is an official item number, the item number is assigned. And set the received quantity to the quantity with the received status. The official item number is included in the warehousing information or is read from the association data using the product number included in the warehousing information as a key. The receipt slip generation means 14 writes the generated receipt slip data record in the storage means 12 (step S140).

  Next, the transfer instruction generation unit 15 assigns a transfer instruction slip number, determines a transfer destination of each product, and generates a transfer instruction record based on the receipt slip data record generated in step S140 (step S140). S150). Specifically, the transfer order record slip number, slip date, company code, item number of each line, production number, transfer quantity, assigned slip number, current date, in the receipt slip data record of the origin Write the company code, item number of each line, production number, and receipt quantity. Here, the same date as the warehousing date is set as the transfer date. Information indicating the place where the warehousing is performed is set in the transfer source of each detail line. The place where the warehousing is performed is, for example, a wireless network that configures the network N and is wirelessly connected to the mobile terminal 2. This can be determined by the location of the device. In addition, the transfer destination is determined in advance by registering data indicating the storage location in association with the planned shipping date and the production number in the storage unit 12 and referring to the data. The transfer instruction generation unit 15 additionally registers the generated transfer instruction record in the storage unit 12.

FIG. 7 is a diagram showing an item transfer process flow in the warehouse management apparatus 1.
The office worker inputs to the terminal 3 a file including data of a set of the product production number and the confirmed formal item number, and an instruction to send an item transfer request. The association data writing unit 16 of the warehouse management device 1 receives the file and item transfer request transmitted by the terminal 3 via the communication unit 11 (step S210). The associating data writing means 16 reads out the data of the combination of the production number and the item number from the received file and adds it to the associating data in the storage means 12 (step S220).

  Subsequently, the slip regenerating unit 17 internally performs a payout process on the warehousing slip generated using the dummy item number, and performs a warehousing process again with the confirmed item number. Specifically, the slip regeneration means 17 specifies the receipt slip data record in the storage means 12 by the manufacturing number additionally registered in the association data in step S220, and the product in the specified receipt slip data record is identified. Rewrite the status to “issued”. That is, the quantity in the “Received” status is moved to the quantity in the “Received” status, and the quantity in the “Received” status is set to “0” (step S230).

  Next, the slip regeneration means 17 generates a new receipt slip data record (payout data) from the receipt slip data record whose status has been rewritten in step S230 (hereinafter referred to as “original receipt slip data record”). . The newly assigned slip number is set as the slip number of the new warehousing slip data record, and the current date is set as the slip date and the warehousing date. Further, among the detail lines of the original receipt slip data record, those that do not use the production number registered in step S230 are copied and set as they are in the detail line of the new receipt slip data record. On the other hand, for the details of the original receipt slip data record that use the production number registered in step S230, the dummy item number is rewritten to the official item number that has been confirmed, and the quantity in the “Received” status is changed. The detail line is set with the quantity in the “issued” status in the original receipt slip data record and the quantity in the “issued” status set to “0”. The slip regeneration means 17 writes the generated receipt slip data record in the storage means 12 (step S240).

  As described above, the subsequent work after registration of a new warehousing slip data record in which an official item number is set is performed with reference to the new warehousing slip data record. Hereinafter, a shipping process will be described as an example of the subsequent work.

FIG. 8 is a diagram showing a shipping process flow in the warehouse management apparatus 1.
The office worker inputs order information including the company code of the ordering company, the order date, the item number and quantity information of the ordered product, and the order slip generation request transmission instruction to the terminal 3. The order receipt generation means 18 of the warehouse management apparatus 1 receives the order information and the order entry generation request transmitted by the terminal 3 via the communication means 11 (step S310). The order slip generation means 18 assigns a new order slip number and generates an order slip data record based on the order information. Specifically, the order number included in the order slip data record, the date of the order, the order date, the company code, the item number of each line and the order quantity assigned, the current date, and the order received in the order slip information Set the date, company code, item number of the ordered product and order quantity. The order slip generation means 18 writes the generated order slip data record in the storage means 12 (step S320).

  When it is determined that the registered order slip is to be shipped, the office worker inputs the order slip number to be shipped and an instruction to send a shipping slip generation request to the terminal 3. The shipping slip generation means 19 of the warehouse management apparatus 1 receives the order slip number and the shipping slip generation request transmitted by the terminal 3 via the communication means 11 and receives the order slip data in the storage means 12 based on the received order slip number. Identify the record. The shipping slip generation means 19 reads out the item number from the identified order-receiving slip data record to be shipped, and performs an allocation process for each item number. That is, the receipt slip data record having the read item number and in a status that can be allocated, for example, the received quantity is greater than the order quantity is specified. Then, for the line of the product in the specified receipt slip data record, the quantity in the “Received” status is subtracted from the order quantity, and the quantity in the “Allocated” status is added to the order quantity. rewrite.

When the allocation process is completed, the shipping slip generation unit 19 generates a shipping slip data record for the product that has been allocated based on the specified order slip data record, and writes it in the storage unit 12 (step S340). The shipping date is a date according to a rule predetermined for each company, such as every Monday or Thursday. Further, the transfer instruction generating unit 15 generates a transfer instruction record from the generated shipping slip data record and writes it in the storage unit 12 (step S350). The transfer source reads and sets the data of the current storage location of the product from the storage unit 12. Further, the forwarding destination is a place determined in advance for each shipping date or each shipping company.
After the shipping slip data record and transfer instruction record are registered, the shipping slip indicating the contents of the shipping slip data record and the transfer instruction indicating the contents of the generated transfer order record are printed and delivered to the warehouse worker. The warehouse worker performs the shipment while looking at the shipping slip and the transfer instruction.

  According to the above-described embodiment, a warehousing slip data record can be created for a product whose item number has not been determined, and the warehousing process can be performed. Further, since the same warehousing slip data record as usual is generated using the dummy item number, the slip data record can be generated by the same processing as usual after warehousing and distribution management can be performed. In addition, when the official item number is decided, in order to generate a new receipt document data record of the official item number while rewriting and holding the receipt document data record using the dummy item number to the shipped status, Distribution history from product receipt can be maintained.

  In this embodiment, the combination data of the product number and the dummy product number needs to be unique. However, if this condition is satisfied, a combination of a plurality of other numbers may be used. Is possible. For example, a number other than the manufacturing number, for example, a serial number of the product can be used as the product number. Moreover, the item type which shows the classification of the item of goods can be used as a goods number.

  In addition, the above-mentioned warehouse management apparatus 1, the portable terminal 2, and the terminal 3 have a computer system inside. The operation process of the slip generation means 13 of the warehouse management apparatus 1 and the portable terminal 2 and the terminal 3 is stored in a computer-readable recording medium in the form of a program. The above processing is performed by the system reading and executing. 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.

The figure which shows the structure of the warehouse management system by one Embodiment of this invention. The block diagram which shows the internal structure of the warehouse management apparatus shown in FIG. The figure which shows the example of the receipt slip data record which the warehouse management apparatus shown in FIG. 1 hold | maintains. The figure which shows the example of the tied data which the warehouse management apparatus shown in FIG. 1 hold | maintains. The figure which shows the example of the transfer instruction record which the warehouse management apparatus shown in FIG. 1 hold | maintains. The figure which shows the warehousing process flow of the warehouse management apparatus shown in FIG. The figure which shows the item transfer process flow of the warehouse management apparatus shown in FIG. The figure which shows the leaving process flow of the warehouse management apparatus shown in FIG.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Warehouse management apparatus 2 ... Portable terminal 3 ... Terminal 10 ... Control means 11 ... Communication means 12 ... Storage means 13 ... Voucher generation means 14 ... Receipt voucher generation Means 15: Transfer order generating means 16 ... Association data writing means 17 ... Slip regenerating means 18 ... Order slip generating means 19 ... Shipping slip generating means

Claims (3)

A warehouse management device for managing product distribution in a warehouse,
A storage means for storing a receipt slip data record including information on a product number and a product number of a received product, and association data associating the product number and the product number;
A receipt slip generating means for receiving a product number of a received product, generating a receipt slip data record including a dummy product number and information of the entered product number, and writing it to the storage means;
Linked data writing means for receiving information on the product number and the confirmed product number, and adding information for associating the received product number and product number to the linked data in the storage means;
The goods receipt slip data record in the storage means is specified by the product number received by the association data writing means, and the product number is determined corresponding to the product number in the specified goods receipt slip data record. Is stored in the storage means, and the goods receipt slip in which the dummy product number corresponding to the product number in the specified goods receipt slip data record is changed to the product number received by the association data writing means. Slip regenerating means for newly generating a data record and writing it in the storage means;
With
The goods receipt slip data record further includes information indicating the status of the goods received;
The slip regenerating means writes information indicating that the product number has been confirmed by rewriting the status corresponding to the product number in the specified warehousing slip data record to information indicating that the shipment has been completed.
A warehouse management device characterized by that. A warehouse management method used in a warehouse management apparatus for managing the distribution of products in a warehouse,
A storage means for storing a receipt slip data record including information on a product number and a product number of a received product, and association data for associating the product number and the product number;
A receipt slip generation process of receiving a product number of a received product, generating a receipt slip data record including a dummy product number and information of the input product number, and writing it to the storage means;
An association data writing process for receiving information on the product number and the confirmed product number and adding information associating the received product number and the product number to the association data in the storage unit;
The warehousing slip data record in the storage means is specified by the product number received in the associating data writing process, and the product number is determined corresponding to the product number in the specified warehousing slip data record. Is stored in the storage means, and a dummy product number corresponding to the product number in the specified receipt document data record is changed to the product number received in the association data writing process. A slip regeneration process for newly generating a data record and writing it in the storage means;
Have
The goods receipt slip data record further includes information indicating the status of the goods received;
In the slip regeneration process, information indicating that the product number is confirmed is written by rewriting the status corresponding to the product number in the specified receipt slip data record to information indicating that the goods have been issued.
A warehouse management method characterized by that. A computer used in a warehouse management device that manages the distribution of products in the warehouse,
A storage means for storing a receipt slip data record including information on a product number and a product number of a received product, and association data for associating the product number and the product number;
A receipt slip generating means for receiving a product number of a received product, generating a receipt slip data record including a dummy product number and information of the entered product number, and writing it to the storage means;
Linked data writing means for receiving information on the product number and the confirmed product number, and adding information that associates the received product number and product number to the linked data in the storage means,
The goods receipt slip data record in the storage means is specified by the product number received by the association data writing means, and the product number is determined corresponding to the product number in the specified goods receipt slip data record. Is stored in the storage means, and the goods receipt slip in which the dummy product number corresponding to the product number in the specified goods receipt slip data record is changed to the product number received by the association data writing means. Slip regenerating means for newly generating a data record and writing it in the storage means;
Function as
The goods receipt slip data record further includes information indicating the status of the goods received;
The slip regenerating means writes information indicating that the product number has been confirmed by rewriting the status corresponding to the product number in the specified warehousing slip data record to information indicating that the shipment has been completed.
A computer program characterized by the above.

Images