JP2004203498A - Inventory management method of warehouse - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an inventory management system efficiently managing the goods inventory of the warehouse with a convenient method. <P>SOLUTION: The goods inventory in the warehouse is not actually divided into lots for each purchaser, but virtually divided into lots on the inventory management system, thereby reducing the load for the actual goods inventory management. <P>COPYRIGHT: (C)2004,JPO&NCIPI

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a server-client type warehouse inventory management system, and more particularly to an inventory management system including a database for virtually managing product inventory stored in a warehouse.
[0002]
[Prior art]
Various manufacturers (also referred to as vendors and manufacturers) provide products manufactured in factories and the like to deliver them to retailers (including department stores, stores, supermarkets, and various other sellers) nationwide. Products are stored in warehouses scattered around. Normally, a retailer issues a required quantity of a required product from a nearby warehouse so that a sales transaction of the product is completed between a manufacturer on the seller side and a retailer on the buyer side. Has become.
[0003]
In this specification, the “warehouse” means a general distribution base for temporarily storing luggage, and has various sizes and forms such as a distribution service center, a collection center, and a distribution center. Includes
While warehouses in various locations store a variety of products from a variety of manufacturers, there are many retailers that issue these products. Generally, manufacturers manage the inventory of their products in each warehouse, and when there are multiple buyers (delivery destinations) of products, the inventory of products is managed in lots for each buyer. are doing.
[0004]
FIG. 13 is a diagram illustrating an example of a method of managing the product inventory for each buyer by the manufacturer as described above. In FIG. 13, XXX Fisheries, a manufacturer, stores a total of 950 cases of goods at the Logistics Service Center (LSC) in the Sendai south area. This product is sold to retailers A, B, C and D on the buyer side, and the product inventory is divided for each company according to the size of the transaction with each company. Managing.
That is, at present, 200 cases are stored for company A, 150 cases for company B, 300 cases for company C, and 100 cases for company D. The manufacturer also keeps 200 cases of its own inventory that does not specify a sales destination.
[0005]
When purchasing merchandise from the distribution service center managed as described above, each retailer can issue only the merchandise inventory allocated to the company.
While each retailer issues the required quantity of goods from the product inventory allocated to the company at the required time, the manufacturer monitors the status of each retailer's purchase of goods and distributes them to the distribution service center. We always replenish the stock of goods so that the appropriate amount of goods is kept in the store.
[0006]
By the way, as a means for a manufacturer to manage the inventory of goods in such warehouses, the inventory information of warehouses in various places is managed on a computer having a database function and the like. A reference and management system has been proposed.
The inventory management system described in Patent Literature 1 is a system characterized by referring to an inventory database based on order data from a shipper, and allocating and shipping inventory items according to the result.
[0007]
The inventory management system described in Patent Literature 2 includes a database that stores inventory information and a database that stores customer information. The inventory management system stores inventory information such as inventory based on customer-side data provided by each customer. A system for adjusting information.
The inventory management system described in Patent Literature 3 includes a computer that can communicate with an integrated inventory management server in each stage from when a product purchase order is placed to when the product is delivered, so that the inventory status at each stage is maintained. This is a system characterized in that it is possible to accurately grasp the information.
[0008]
[Patent Document 1]
JP-A-2002-251552.
[Patent Document 2]
JP-A-2002-334250.
[Patent Document 3]
JP-A-2002-205818.
[0009]
[Problems to be solved by the invention]
As described above, in the conventional inventory management method in a warehouse, inventory of each product is managed by allocating it to a plurality of buyers. For example, in the example shown in FIG. 13, XXX Fisheries, a manufacturer, individually manages replenishment of merchandise inventory for Company A, Company B, Company C, and Company D. Since each retailer freely issues the inventory of goods allocated to the company, the timing of replenishing the allocated inventory for each retailer is different.
[0010]
For this reason, even for the same product, there is a possibility that the stock will be excessive or too small depending on the allocation destination, and thus the product will be frequently out of stock. In addition, it becomes difficult to manage the expiration date and the like of the product, which results in an increase in defective stock and disposal.
[0011]
In addition, as described above, when there are many buyers for the same product, it is necessary to individually manage the inventory allocated to each buyer, and the management of the product inventory performed by the manufacturer is a very complicated operation. Had become. Further, the manufacturer stores a large number of commodities in a warehouse, and it is necessary to perform the above-described inventory management for each of the commodities, and management of the commodities inventory requires a great deal of labor and cost.
[0012]
Further, in the warehouse, since it is necessary to actually sort and store the commodities for each assigned stock, use of space in the warehouse is wasteful.
SUMMARY OF THE INVENTION The present invention has been made in view of the above circumstances, and aims to provide an inventory management system capable of efficiently managing the inventory of goods in a warehouse by a simple method.
[0013]
[Means for Solving the Problems]
As a result of earnest research in view of the above-mentioned solution, the present inventor did not divide the actual product inventory in the warehouse into lots for each buyer, but virtually divided the lots on the inventory management system into actual lots. I came up with the idea of reducing the burden of inventory management.
[0014]
That is, the present invention is an inventory management system that includes a database that stores inventory information of commodities, wherein, on the database, at least one allocation frame that can identify each buyer of the commodities, It is an object of the present invention to provide an inventory management system comprising an inventory allocating means for allocating and storing a predetermined quantity of inventory.
[0015]
This makes it possible to allocate and manage a predetermined quantity of each product to each buyer on the database without having to divide the actual product stock in the warehouse into lots for each buyer. Therefore, in an actual warehouse, only the total stock amount of each product needs to be managed, so that complicated operations such as lot sorting of stock can be omitted.
[0016]
The present invention is also an inventory management system including a database that stores inventory information of products, wherein the database stores, on the database, at least one allocation frame capable of identifying each delivery destination of the product. The present invention provides an inventory management system including inventory allocation means for allocating and storing a predetermined quantity in the inventory.
[0017]
This makes it possible to allocate and manage a predetermined quantity of each product to each delivery destination on the database without having to divide the actual product stock in the warehouse into lots for each delivery destination. Therefore, in an actual warehouse, only the total stock amount of each product needs to be managed, so that complicated operations such as lot sorting of stock can be omitted.
[0018]
In the inventory management system according to the present invention, the inventory allocating means is further configured to allocate and store a predetermined quantity in the inventory of the product to an allocation frame in which a seller can be identified.
This allows the seller to own company inventory that has not been assigned to the buyer or destination.
[0019]
In the inventory management system of the present invention, on the database, while reducing the quantity of inventory of the product assigned to any one of the allocation frames, the amount of inventory of the product allocated to another allocation frame , And further comprises inventory replenishment means for increasing the number by the reduced quantity.
[0020]
By moving the stock quantity between the allocation frames on the database, it is possible to prevent a temporary excess or shortage of stock. Since this movement of the stock quantity only changes the data relating to each allocation frame on the database, there is no need to perform any operation on the actual stock of goods in the warehouse.
[0021]
The inventory replenishing means is configured to allocate, on the database, a quantity reduced from the stock of the product allocated to the allocation frame for identifying the seller to any of the allocation frames for identifying the buyer or the delivery destination. In addition, it is added to the stock quantity of the product.
Thereby, when the stock of goods assigned to the buyer or the delivery destination on the database becomes insufficient, a certain quantity of stock of goods can be replenished from the seller's own stock.
[0022]
The inventory management system of the present invention further includes a display screen generation unit that generates a screen that displays inventory information of the product stored in the database. A screen displaying the inventory quantity of the product assigned to the allocation frame for identifying each buyer or the delivery destination and the inventory quantity of the product allocated to the allocation frame for identifying the seller. It is characterized by generating.
This enables the seller to display, on the client device, information on the company stock and the product stock assigned to each buyer or delivery destination.
[0023]
The inventory management system of the present invention further includes a display screen generation unit that generates a screen that displays inventory information of the product stored in the database, wherein the display screen generation unit includes the buyer or the buyer. For the delivery destination, a screen for displaying only the quantity of the stock of the product assigned to the allocation frame for identifying each buyer or the delivery destination is generated.
As a result, it is possible for each buyer or delivery destination to display only the information on the stock of the goods assigned to each buyer or delivery destination.
[0024]
The inventory management system of the present invention, also, in response to an operation from the seller, stored in the database, the number of inventory of the product assigned to the allocation frame for identifying each buyer or delivery destination, It is characterized by further comprising a user operation processing means for changing the quantity of stock of the product allocated to the allocation frame for identifying the seller.
Thus, the seller can operate the client device to freely change the in-house stock and the allocation frame of each product to each buyer or delivery destination.
[0025]
The inventory management system of the present invention may further include an inventory of the product assigned to an allocation frame for identifying the buyer or the delivery destination stored in the database, in response to an operation from the buyer or the delivery destination. Characterized by further comprising a user operation processing means for changing the number of items.
Accordingly, each buyer or delivery destination can operate the client device to change the allocation frame of each product assigned to each buyer or delivery destination as necessary.
[0026]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings.
FIG. 1 is a diagram schematically showing an overall configuration of an inventory management system according to the present invention.
In FIG. 1, the inventory management system of the present invention includes a server 100, a seller device 110, a buyer device 120, a warehouse device 130, and a shipping company device 140.
[0027]
The inventory management system of the present invention takes the form of a server client, and the seller-side device 110, the buyer-side device 120, the warehouse-side device 130, and the transportation company-side device 140 request services from the server 100 as clients.
The server 100 is formed of, for example, a UNIX machine, and has a three-layer configuration of a database server that provides a database function, a Web server that provides a Web function, and an application server that provides an application function.
[0028]
The seller-side device 110, the buyer-side device 120, the warehouse-side device 130, and the transport company-side device 140 are general personal computers, and can access the server 100 via the Internet by a modem or the like. All operations on these client-side devices can be performed by a Web browser.
[0029]
As shown in FIG. 1, the server 100 includes an inventory management program 101. The inventory management program 101 includes a host I / F 102, a VAN (Virtual Area Network) I / F 103, and a Web I / F 104 for communicating with each client device, and a logical inventory management for managing inventory information. Contains database 105.
[0030]
The Host I / F 102 is an interface for the inventory management program 101 to communicate with each client device on a TCP / IP basis, and the VAN I / F 103 establishes a virtual network between the server 100 and each client device. The Web I / F 104 is an interface for providing a service on the Web to each client device.
Next, the functions of the inventory management program 101 implemented on the server 100 in the inventory management system of the present invention will be described.
[0031]
FIG. 2A is a functional block diagram schematically showing each function included in the inventory management program 101 shown in FIG. 2A, the inventory management program 101 includes a control unit 201, an inventory allocation unit 202, an inventory replenishment unit 203, a display screen generation unit 204, a user operation processing unit 205, a communication interface 206, and a logical inventory management database. Includes 105 and.
[0032]
The control unit 201 is configured by an arithmetic processing unit such as a CPU or an MPU, and can control other components. The inventory allocating unit 202, the inventory replenishing unit 203, the display screen generating unit 204, and the user operation processing unit 205 respectively perform logical inventory management database 105 according to information input through the network or information included in the logical inventory management database 105. This is a means for changing the information in the server or transmitting predetermined information to the client-side device through the network, which will be described later in detail. The interface 206 is a network interface for the inventory management program 101 to communicate with the client device via the network.
[0033]
In the inventory management system of the present invention, the logical inventory management database 105 includes a database management system such as a DBMS (Database Management System) or an RDBMS (Relational Database Management System). Preferably, the system is configured to operate the logical inventory management database 105 via the system.
[0034]
FIG. 2B is a diagram partially showing an example of the internal configuration of the logical inventory management database 105 shown in FIGS. 1 and 2A.
In FIG. 2B, the stock management table includes a base code, a shipper code, a shipper product code, and an allocation frame ID as primary keys, and includes in-stock quantity information as other keys. Here, the base code is a code for identifying a plurality of warehouses, the shipper code is a code for identifying a manufacturer, and the shipper product code is a code for a plurality of products stored by each manufacturer. This is a code for identification. The allocation frame ID indicates information on a frame for virtually allocating the inventory described above.
By referring to this inventory management table, it is possible to obtain information on the stock quantity of a specific product (shipper product) stored by a specific manufacturer (shipper) in a specific warehouse (base).
[0035]
In FIG. 2B, the logical inventory management database 105 further includes an allocation frame master. The allocation frame master includes an allocation frame ID, a base code, and a shipper code as primary keys, and includes a retail group code, an allocation destination code, and an authority class as other keys.
[0036]
Here, the allocation frame ID, the base code, and the shipper code are the same as above. The retail group code is a code for identifying a retailer, and the assignee code is a code for identifying an assignee corresponding to the assignment frame ID. For example, if the inventory of a certain product is assigned to the retailer X company's S district store, the code for identifying the retailer X is included in the retail group code, and the retailer X's A code to identify the S district store will be included.
The authority category is information that sets the authority to refer to and update the inventory allocation frame for each client, which will be described in detail later.
[0037]
Therefore, by referring to the quota master associated with the quota ID together with the above-mentioned inventory management table, it is possible to further determine which inventory of a specific product is stored by a specific manufacturer in a specific warehouse. Can be obtained.
[0038]
FIGS. 2C and 2D show configuration examples of tables actually created according to the inventory management table and the allocation frame master shown in FIG. 2B. In the figure, the values included in the table are replaced with words for explanation.
In FIG. 2C, the inventory of the goods P of the vendor A (seller manufacturer) stored in the warehouse called the base J is allocated to each of the allocation frames 001 to 004 by a predetermined quantity. For each of these allocation frames, the table shown in FIG. 2D can be referred to based on the allocation frame ID.
[0039]
By referring to the table shown in FIG. 2D, the allocation frames 001 to 004 respectively correspond to the retailer X's S district store, the retailer X's T district store, the retailer Y's U district store, and the vendor A's company A. It can be seen that it corresponds to own stock.
Next, a method of managing inventory by the inventory management system of the present invention configured as described above will be specifically described.
[0040]
FIG. 3 is a diagram showing a stock management method by the stock management system of the present invention. In the inventory management system of the present invention, actual inventory is not allocated to buyers as in the example shown in FIG. Therefore, in FIG. 3, the Sendai Minami Logistics Service Center of XXX Fisheries actually stores the stock of this product as 950 cases per lot.
However, in the inventory management program 101 of the present invention, the inventory allocation means 202 allocates the inventory quantity to each company on the buyer side, and information on this allocation is stored in the logical inventory management database 105.
[0041]
By performing such an inventory management method, the seller can keep the inventory of each product stored in the warehouse on the logical inventory management database 105 as before, without actually sorting and storing and managing the inventory according to the allocation. It is possible to manage the stock by allocating stock to each buyer side.
Next, an example of a method of using the inventory management system of the present invention on the seller side (manufacturer or the like) and on the buyer side (retailer or the like) will be described.
[0042]
FIG. 4 is a diagram schematically illustrating a display example of inventory management information in the seller device 110 in FIG. 1 by the inventory management system of the present invention.
In the example shown in FIG. 4, the inventory quantity of each of the bases (synonymous with the warehouse) J, the base K, and the base L is displayed for a certain product of the vendor A, which is the seller side. As the breakdown of the allocation, the stock quantity and the own stock quantity for each of the buyers X and Y are displayed. Here, the in-house inventory is inventory in which the buyer is not specified, and can be handled freely by the vendor A.
[0043]
According to the inventory management information shown in FIG. 4, the vendor A can determine the inventory quantity for each location, the inventory quantity for each location and each supplier, the inventory quantity for each supplier (including own inventory), and the inventory quantity for all locations. It is possible to obtain information on the total stock (that is, the total stock of the product).
[0044]
5 and 6 are diagrams schematically showing examples of display of inventory management information in the buyer-side device 120 in FIG. 1 by the inventory management system of the present invention.
In the example shown in FIG. 5, the stock quantity allocated to the retailer X, which is the buyer, is displayed for each location and for each seller. With such inventory management information, the retailer X can obtain information on the inventory quantity for each location, the inventory quantity for each seller, and the inventory quantity for each location and each seller.
[0045]
Further, in the example shown in FIG. 6, the stocks allocated by the vendor A at the locations J, K, and L are displayed by allocating the locations to each of the sub-districts. With such inventory management information, the retailer X can obtain detailed information on inventory quantity for each location and for each location.
Next, a description will be given of a method of carrying in and out of goods by the inventory management system of the present invention.
[0046]
FIG. 7 is a diagram schematically showing a method in which the seller operates the inventory management system of the present invention to store (supplement) stock items.
In the example shown in FIG. 7, the vendor A, which is the seller, stores the assigned inventory and the in-house inventory for the retailers X and Y. These stocks are allocated and distinguished on the logical stock management database 105 by the stock allocating means 202 of the present invention, but are assumed to be stored as one lot in an actual warehouse. .
[0047]
In the state shown in FIG. 7 (a), when the retailers X and Y release goods as needed, the state becomes as shown in FIG. 7 (b), and the inventory for the companies X and Y is obtained. Need to be replenished. At this time, the inventory replenishment means 203 of the inventory management system of the present invention, as shown in FIG. Transfer the quantity to quota inventory for Company X and Company Y. Note that this transfer only updates the stock allocation information on the stock management system of the present invention, and does not require the stock items in the actual warehouse to be moved.
[0048]
In this way, if the stock for company X and company Y, which is issued at any time, is allocated and replenished from the company stock, the company stock decreases, and as shown in FIG. It is sufficient to manage so that the stock is automatically replenished when the price falls below the level.
[0049]
According to the above-mentioned stocking / removing method by the stock management system of the present invention, it is not necessary to individually replenish the stock according to the stocking of each buyer side company, and efficient stock management can be performed. In addition, since the change of the allocation to each of the buyer-side companies is only performed virtually on the management system of the present invention, there is no need to perform a complicated operation in the actual warehouse.
Next, FIG. 8 is a diagram schematically showing a method in which the buyer operates the inventory management system of the present invention to issue stock items.
[0050]
In the example shown in FIG. 8, a retailer J, which is a buyer, is assigned a certain amount of inventory for each of the districts A and B. These stocks are virtually allocated and distinguished in the logical stock management database 105 by the stock allocating means 202 of the present invention, but are stored as one lot in an actual warehouse. I do.
[0051]
In the state shown in FIG. 8A, when the retailer J issues each of the stocks for the district A and the stock for the district B as necessary, the state shown in FIG. Needs to be replenished for each of the B and District B stocks. At this time, the inventory replenishment means 203 of the inventory management system of the present invention, as shown in FIG. 8 (c), converts the necessary quantity from the in-house inventory held by the buyer (bender) as buffer inventory in the warehouse. , And automatically transfer to each of the allocation stock for retailer J's A district and B district. Note that this transfer only updates the stock allocation information on the stock management system of the present invention, and does not require the stock items in the actual warehouse to be moved.
[0052]
In this way, when the quota inventory for the A district and the B district of the retailer J that is issued at any time from the in-house inventory is replenished from the in-house inventory, the in-house inventory decreases, and as shown in FIG. What is necessary is just to manage so that when the company stock falls below a predetermined amount, the company stock is automatically replenished.
[0053]
According to the above-mentioned stocking / removing method by the stock management system of the present invention, it is not necessary to replenish the stock individually according to the stocking by the buyer side, and efficient stock management can be performed. In addition, since the change of the allocation to each of the buyer-side companies is only performed virtually on the management system of the present invention, there is no need to perform a complicated operation in the actual warehouse.
[0054]
In addition, when the inventory management system of the present invention performs inventory entry (replenishment) or inventory exit as described above, in FIG. 1, the seller-side device 110 or the buyer-side device 120, and the transport company-side device 140, respectively. The information of the replenishment request or the delivery request is transmitted to the server. According to this information, the transportation company receives goods specified in the warehouse from the manufacturer on the seller side, or takes out the specified goods from the warehouse and transports the goods to the destination specified by the retailer on the buyer side.
[0055]
Next, an example of the configuration of a user interface displayed on the display screen of each user when the inventory management system of the present invention is operated from the client device will be described.
As shown in FIG. 1, each user accesses the server 100 via the Internet to use the inventory management program 101 of the present invention. It is also assumed that data communicated between the server and the client is encrypted even after login.
[0056]
When a user logs in to the inventory management system of the present invention, the inventory management program 101 uses the display screen generation means 204 to generate a display screen corresponding to each user based on the information included in the logical inventory management database 105. Sent to the user's client device.
Also, on this display screen, each user is permitted to perform a predetermined operation on the displayed inventory information. When the user performs such an operation, the inventory management program 101 performs a predetermined process on the logical inventory management database 105 by the user operation processing unit 205.
[0057]
FIGS. 9 to 12 respectively show a stocker system according to the present invention, in which a shipper rep on the seller side, a delivery rep on the buyer side, a rep on the retailer headquarters on the buyer side, and a warehouse management rep. It is a figure showing an example of a display screen at the time.
In the example shown in FIGS. 9 to 12, the seller LP Demo Suisan stores 950 cases of the product "Natural Teriyaki" at the base in Hokkaido. These inventories are sold to the buyer-side retailer LP Demo Super, and there are Kushiro Center, Sapporo Center and Nemuro Center as delivery destinations. The inventory of the 950 cases is virtually allocated by the inventory management system of the present invention to the company's own side frame, the LP demo super common frame, the Kushiro center frame, the Sapporo center frame and the Nemuro center frame.
[0058]
In FIG. 9, the shipper person in charge of the seller can refer to and update all the inventory allocations of the seller's own company frame, the LP demo super common frame, the Kushiro center frame, the Sapporo center frame and the Nemuro center frame. Therefore, the seller can freely change the stock allocation according to the transaction volume with each center of the buyer-side retailer.
[0059]
In FIG. 10, the person in charge of the Kushiro Center, which is one of the delivery destinations on the buyer side, can refer to and update the stock allocation for the Kushiro Center frame, and can also refer to the stock allocation for the LP Demo Super common frame. Only renewal is possible. This allows the inventory management system of the present invention to be operated so as to transfer and replenish the required amount of inventory from the allocated inventory of the LP demo super common frame when the allocated inventory of the Kushiro center frame is insufficient. Because. Therefore, the person in charge of the Kushiro Center can freely change only the allocation of stock to the own center.
[0060]
In FIG. 11, the person in charge of the retailer headquarters on the buyer side can only refer to the inventory allocated to the company, that is, to the inventory allocation of the LP Demo Super common frame, Kushiro center frame, Sapporo center frame and Nemuro center frame. It is possible.
[0061]
In FIG. 12, the warehouse manager can refer to and update all inventory allocations of the seller's own company frame, LP demo super common frame, Kushiro center frame, Sapporo center frame and Nemuro center frame. Accordingly, when the virtual inventory information on the inventory management system of the present invention conflicts with the actual inventory status of the warehouse, the warehouse clerk rewrites the virtual inventory information on the inventory management system, and Can be dealt with.
[0062]
The embodiment of the warehouse inventory management system according to the present invention has been described above, but the present invention is not limited thereto. Those skilled in the art can make various changes to the warehouse inventory management system of the present invention without departing from the gist of the present invention.
[0063]
【The invention's effect】
As described above, according to the warehouse inventory management system of the present invention, while the product inventory in the warehouse is actually managed as one lot, it is individually allocated to each sales destination and delivery destination on the inventory management system. By managing the inventory, the inventory of goods in the warehouse can be efficiently managed by a simple method.
[Brief description of the drawings]
FIG. 1 is a diagram schematically showing an overall configuration of an inventory management system of the present invention.
FIG. 2A is a functional block diagram schematically showing each function included in the inventory management program 101 shown in FIG. 1;
FIG. 2B is a diagram partially showing an example of the internal configuration of the logical inventory management database 105 shown in FIGS. 1 and 2A;
FIG. 2C is a diagram showing a configuration example of a table actually created according to the inventory management table and the allocation frame master shown in FIG. 2B.
FIG. 2D is a diagram showing a configuration example of a table actually created according to the inventory management table and the allocation frame master shown in FIG. 2B.
FIG. 3 is a diagram showing a stock management method by the stock management system of the present invention.
FIG. 4 is a diagram schematically showing a display example of inventory management information in a seller device 110 in FIG. 1 by the inventory management system of the present invention.
FIG. 5 is a diagram schematically showing a display example of inventory management information in the buyer-side device 120 in FIG. 1 by the inventory management system of the present invention.
FIG. 6 is a diagram schematically showing a display example of inventory management information in the buyer-side device 120 in FIG. 1 by the inventory management system of the present invention.
FIG. 7 is a diagram schematically showing a method in which a seller operates a stock management system of the present invention to store (replenish) stock items.
FIG. 8 is a diagram schematically illustrating a method in which a buyer operates a stock management system of the present invention to carry out and outgoing stock items.
FIG. 9 is a diagram showing an example of a display screen when a shipper in charge on the seller side introduces the inventory management system of the present invention.
FIG. 10 is a diagram showing an example of a display screen when a buyer's delivery person in charge introduces the inventory management system of the present invention.
FIG. 11 is a diagram showing an example of a display screen when a person in charge of the retailer headquarters on the buyer side introduces the inventory management system of the present invention.
FIG. 12 is a diagram showing an example of a display screen when a warehouse manager introduces the inventory management system of the present invention.
FIG. 13 is a diagram showing a conventional method in which a manufacturer manages product inventory for each buyer.
[Explanation of symbols]
100 servers
101 Inventory Management Program
102 Host interface
103 VAN interface
104 Web Interface
105 Logical Inventory Management Database
110 Seller-side equipment
120 Buyer Equipment
130 Warehouse side equipment
140 Transportation company equipment
201 control unit
202 Inventory allocation method
203 Inventory replenishment means
204 Display screen generation means
205 User operation processing means
206 Communication Interface

Claims (9)

An inventory management system including a database for storing inventory information of products,
An inventory management system comprising: an inventory allocating unit configured to allocate and store a predetermined quantity of inventory of the product to one or more allocation frames capable of identifying each buyer of the product on the database. An inventory management system including a database for storing inventory information of products,
An inventory management system, comprising: a stock allocating means for allocating a predetermined quantity of stock of the product to one or more allocation frames capable of identifying each delivery destination of the product on the database, and storing the quota. 3. The warehouse inventory management system according to claim 1, wherein the inventory allocating unit further allocates a predetermined quantity in the inventory of the product to an allocation frame that allows a seller to be identified and stores the allocated quantity. . On the database, reduce the inventory quantity of the product assigned to any one of the allocation slots, and increase the inventory quantity of the product assigned to another allocation slot by the reduced quantity. 4. The inventory management system for a warehouse according to claim 3, further comprising an inventory replenishing means for causing the inventory to be replenished. The inventory replenishing means is configured to allocate, on the database, a quantity reduced from the stock of the product allocated to the allocation frame for identifying the seller to any of the allocation frames for identifying the buyer or the delivery destination. 5. The warehouse inventory management system according to claim 4, wherein the inventory is added to the quantity of the inventory of the product. Further comprising a display screen generating means for generating a screen for displaying the stock information of the product stored in the database,
The display screen generation means, for the seller, the quantity of inventory of the product assigned to the allocation frame for identifying each buyer or delivery destination and the allocation frame for identifying the seller. The warehouse inventory management system according to any one of claims 1 to 5, wherein a screen for displaying a stock quantity of the product is generated. Further comprising a display screen generating means for generating a screen for displaying the stock information of the product stored in the database,
The display screen generating unit generates a screen for each buyer or delivery destination, which displays only the quantity of stock of the product assigned to an allocation frame for identifying each buyer or delivery destination. The warehouse inventory management system according to any one of claims 1 to 5, wherein In response to an operation from the seller, stored in the database, the quantity of the inventory of the product allocated to the allocation frame for identifying each buyer or delivery destination, and allocated to the allocation frame for identifying the seller. 7. The inventory management system for a warehouse according to claim 6, further comprising a user operation processing means for changing the quantity of the stock of the product. In response to an operation from each of the buyers or delivery destinations, stored in the database, the user operation processing means for changing the inventory quantity of the product assigned to an allocation frame for identifying each of the buyers or delivery destinations 8. The warehouse inventory management system according to claim 7, further comprising:

Images