JP2005060034A - Inventory management system and inventory management method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To facilitate a search process for a delivery instruction in a warehouse operation, to reduce an index area and search logic of inventory data, and to reduce an amount of data to be managed.
SOLUTION: A step of creating a search pattern master by setting an allocation pattern serving as a search condition at the time of delivery for each product type, and an allocation pattern registered in the search pattern master for a received product A step of accepting which one of the items is assigned, a step of accepting input of product information on at least an item necessary for the search condition based on the allocation pattern assigned to the received goods, and creating an inventory master And setting search conditions based on the allocation pattern assigned to the product, searching for product information stored in the inventory master, and registering the delivery information.
[Selection] Figure 1

Description

  The present invention relates to an inventory management system and an inventory management method for managing inventory in warehouse operations.

  When handling a plurality of shippers and a plurality of commodities in a warehouse operation, since the management items are different for each shipper and for each commodities, the search keys for issuing a shipping instruction have various contents. In such a shipping operation, it is necessary to prepare a shipping logic in which a search key for shipping instruction is incorporated for each shipper and each product (or each product group).

Conventionally, this is dealt with by using the following solutions.
(1) It is conceivable to create a delivery index (search key) for each shipper and each product (or each product group) and incorporate a search logic using this delivery index when searching for a delivery product. Creation of such a shipping index is not indispensable, but it is often created to improve search efficiency. Thus, when creating a delivery index, there is a problem that the index area becomes enormous and the data capacity for inventory management becomes enormous. In addition, since it is necessary to incorporate an indexing logic for each shipper and each product (or each product group) and to incorporate a shipping logic for determining a search termination condition, the logic becomes complicated and the amount of system development increases.
(2) It is conceivable to set a general-purpose key item as a delivery condition item for each shipper and product (or product group), and to construct logic as a search key at the time of delivery. In this case, as the general-purpose key item, as shown in Table 1, different items are set for each shipper and each product (or each product group).

このような場合、汎用キーに設定される項目は荷主毎、商品毎（あるいは商品群毎）に異なっており、同一の汎用キーを用いて複数の商品について検索を行うことが困難である。また、固定項目のデータとは独立して汎用キー項目が設定されるため、特定の意味を持つ汎用キー項目だけに限定して集計処理を行うような場合、その荷主毎、商品毎（あるいは商品群毎）に検索ロジックを用意する必要がある。

In such a case, items set in the general-purpose key are different for each shipper and each product (or each product group), and it is difficult to search for a plurality of products using the same general-purpose key. In addition, since general-purpose key items are set independently of fixed-item data, when aggregation processing is performed only on general-purpose key items having a specific meaning, for each shipper, product (or product) Search logic must be prepared for each group).

  An object of the present invention is to facilitate search processing for issuing a delivery instruction in a warehouse operation, reduce the index area and search logic of inventory data, reduce the amount of data to be managed, and reduce system development. .

  The inventory management method according to the present invention includes a step of creating a search pattern master by setting an allocation pattern serving as a search condition at the time of delivery for each product type, and a registration pattern registered for the received product in the search pattern master. The process of accepting which of the allocation patterns to be allocated and the input of product information for at least the items necessary for the search condition based on the allocation pattern assigned to the received goods And a step of setting search conditions based on the allocation pattern assigned to the product, searching for product information stored in the inventory master, and registering delivery information.

  In this case, since the product information based on the allocation pattern set for each product is input as an item required for the search condition, the search in the shipping instruction is facilitated, and the product information item for each shipper or product Even if they are different, it is possible to perform a search using the same search logic.

  Here, the inventory master includes a normal item composed of the receipt information of the received goods, and a search key item in which an item necessary for the search condition of the allocated allocation pattern is posted from the normal item. can do.

  In this case, it is possible to set a search key item for search while holding the normal item (fixed item) input as the product information as it is.

  In addition, it may be configured to further include a step of creating a customer product name master in which basic product information, management product name code, and allocation pattern code are associated with each customer.

  In this case, it is possible to collect similar product allocation patterns for each customer (consigner), and the search process at the time of issuing a shipment is facilitated.

  The inventory management system according to the present invention registers an allocation pattern reception unit that receives registration of an allocation pattern serving as a search condition at the time of delivery according to the type of product, and an allocation pattern for each type of product received by the allocation pattern reception unit A search pattern master storage unit to be received, a warehousing information receiving unit for receiving input of product information on at least items required for the search condition, based on an allocation pattern assigned to the input product, and a warehousing information receiving unit The inventory master storage unit that stores the product information received in the item, the search condition reception unit that receives the search condition based on the allocation pattern assigned to the product, and the inventory master storage unit that is based on the search condition received by the search condition reception unit The product information registration part which searches the merchandise information stored in and displays a search result is provided.

  In this case, the product information can be searched based on the allocation pattern stored in the search pattern master storage unit, the search in the shipping instruction is facilitated, and the items of the product information are different for each shipper and each product. Even in such a case, it is possible to perform a search using the same search logic.

  Here, the stock master storage unit includes a normal item composed of warehousing information of the received goods, and a search key item in which an item required for the search condition of the allocated allocation pattern is posted from the normal item. It can be configured to store product information.

  In this case, it is possible to set the search key item for search while holding the normal item (fixed item) input as the product information as it is.

  In addition, a customer product name master reception unit that accepts registration of a customer product name master that associates basic product information, management product name code, and allocation pattern code with each customer, and a customer product name master received by the customer product name master reception unit are stored. A customer product name master storage unit may be further provided.

  In this case, it is possible to collect similar product allocation patterns for each customer (consigner), and the search process at the time of issuing a shipment is facilitated.

  The program according to the present invention includes a step of creating a search pattern master by setting an allocation pattern as a search condition at the time of delivery for each product type, and an allocation registered in the search pattern master for the received product Based on the step of accepting which of the patterns to be assigned and the allocation pattern assigned to the received goods, accept the input of product information for at least the items required for the search condition and create an inventory master And causing the computer to execute an inventory management method including a step of setting a search condition based on an allocation pattern assigned to the product, searching for product information stored in the inventory master, and registering delivery information It is a program for.

  In this case, the inventory management method as described above is executed by a computer such as a personal computer or a workstation, so that inventory management in warehouse operations and retrieval at the time of delivery instruction are facilitated.

  According to the present invention, inventory management can be easily performed in a warehouse operation that handles a plurality of shippers and a plurality of commodities, and a search process at the time of delivery can be reliably and easily performed.

  A schematic configuration of the present invention is shown in FIG.

  In this inventory management system, an allocation pattern reception unit 1, a search pattern master storage unit 2, a customer product name master reception unit 3, a customer product name master storage unit 4, a warehousing information reception unit 5, an inventory master storage unit 6, and a search condition reception unit 7 The delivery information registration unit 8 is provided.

  The allocation pattern reception unit 1 receives registration of an allocation pattern that is a search condition at the time of delivery according to the type of product. The search pattern master storage unit 2 registers the allocation pattern for each product type received by the allocation pattern reception unit 1.

  The customer product name master accepting unit 3 accepts registration of a customer product name master in which basic product information, management product name code, and allocation pattern code are associated with each customer. The customer product name master storage unit 4 stores the customer product name master received by the customer product name master reception unit 3.

  The warehousing information reception part 5 receives the input of the merchandise information about the item required at least as a search condition based on the allocation pattern allocated with respect to the goods received. The stock master storage unit 6 stores the product information received by the warehousing information reception unit 5.

  The search condition receiving unit 7 receives the search condition based on the allocation pattern assigned to the product. The delivery information registration unit 8 searches the product information stored in the inventory master storage unit 6 based on the search condition received by the search condition reception unit 7 and displays the search result, or delivers the search result to the allocation process.

  As shown in FIG. 2, the search pattern master 20 received by the allocation pattern reception unit 1 is composed of a table including the allocation pattern code and search item 1 to search item N items. Each search item 1 to search item N is configured so that a management item name serving as a search key and a search condition for each management item can be set. For example, a table capable of setting conditions as shown in FIG. It has. Here, an allocation pattern code field 21 in which an allocation pattern code is input, a management item name field 22 in which an item name necessary for the search is set, and a delivery time designation classification field 23 that indicates whether or not an entry is an indispensable item , An allocation order column 24 for designating an allocation order when no search item is input, an ascending order / descending order column 25 for designating the ascending order / descending order of the allocation order designation items, and the like.

  As shown in FIG. 4, the customer product name master 40 received by the customer product name master receiving unit 3 is composed of a table having items such as affiliation code, depositor code, product name code, product name, inventory management item, and allocation code. The In the customer product name master reception unit 3, for example, a customer product name master registration screen 41 as shown in FIG. 5 is displayed, and the affiliation code column 42, depositor code column 44, product name code column 46, product name column 47, and storage fee column 48 are displayed. Data input to each input column such as the cargo handling fee column 49 and the allocation pattern code column 50 is accepted. According to the input affiliation code and depositor code, the affiliation name and depositor name corresponding to the affiliation display column 43 and depositor name display column 45 are displayed.

  Of the customer product name master 40, in the inventory management item column, as shown in FIG. 6, for example, business request No., Ref. No., brand, product code, destination, securities No., symbol, as shown in FIG. Items such as EST, miscellaneous bean summary, type, date of receipt, insurance number, etc. can be selected.

  In the warehousing information reception part 5, the warehousing information registration screen 51 as shown in FIG. 7 is displayed, for example, and the input of warehousing information is received. Here, by inputting the product name code registered in the customer product name master 40, a search item name based on the corresponding allocation pattern is displayed, and necessary product information can be input. In this example, for the product name 6300301 of the depositor ABC, it is possible to accept input of search key items of product code, BRAND, and expiration date, and to register necessary information according to the number and other products. . Similarly, for the depositor ABC product name 6300401, the product code, BRAND, and the search key item of the date of manufacture are accepted, and the number and other information can be registered.

  In this way, the warehousing information received by the warehousing information receiving unit 5 is managed as a warehousing file for managing warehousing details, and is stored in the inventory master storage unit 6 as an inventory master. As shown in FIG. 8, the inventory master 60 includes an inventory management No. column, a depositor column, a receipt date column, a receipt No. column, a product name 1 column, a product name 2 column, a quantity received, a production date column, and a shelf life column. It consists of a provision remaining (number) column, an inventory management item column, a shipper designation KEY column, and the like. The inventory management item column is configured to register data input based on the inventory management item set in the customer product name master 40 in the input product information. The contents of the search items 1 to N based on the pattern are registered.

  The search condition receiving unit 7 displays an exit information registration screen 70 as shown in FIG. 9 and receives an input of search conditions. The delivery information registration screen 70 is configured to display search key items based on the allocation pattern set for the product and to input search conditions for the search key items. For example, for the product with the product name code 63000301, the product code input field 72, the BRAND input field 73, and the expiration date input field 74 are displayed to accept data input as a search condition. Similarly, for the product with the product name code 6300401, the product code input field 75, the BRAND input field 76, and the manufacture date input field 77 are displayed to accept data input as a search condition. As a result of the search using the search conditions entered on the shipping registration screen 70, an allocation confirmation screen 80 as shown in FIG. 10 is displayed. Here, a case where no search condition is input to the expiration date column 74 and the manufacturing date column 77 is taken as an example.

<Management of customer product name master and search pattern master>
A specific example of management of the customer product name master and the search pattern master will be described with reference to FIG.

  For example, if the goods handled by the depositor ABC are all issued with a product code and BRAND specified, the search item 1 of the allocation pattern for the depositor ABC product is set as the product code, and the search item 2 Is set to BRAND. Here, it is assumed that the expiration date of the product with the product code 30301 needs to be managed, and the date of manufacture of the product with the product code 30401 needs to be managed. In this case, the search item 3 is set to the expiration date for the product with the product code 30301, and the allocation pattern code is registered as ABC. In addition, for the product with the product code 30401, the search item 3 is set to the date of manufacture and the allocation pattern code is registered as ABD. As a result, in the customer product name master 40, the allocation pattern code ABC is assigned to the product name code 6300301 (product code 30301), and the allocation pattern code ABD is assigned to the product name code 6300401 (product code 30401). Registered data is registered. In addition, for the allocation pattern ABC of the search pattern master 20, a product code and BRAND that are required to be input at the time of delivery are set in the search items 1 and 2, respectively, and an expiry date that is arbitrarily specified at the time of delivery is set in the search item 3. Is done. Similarly, for the allocation pattern ABD of the search pattern master 20, the product code and BRAND that are required to be input at the time of delivery are set in the search items 1 and 2, respectively, and the manufacturing date that is arbitrarily specified at the time of delivery in the search item 3 The day is set.

<Search pattern master settings>
Each item of the search pattern master 20 is set in the table as shown in FIG. 3, and a specific example is shown in FIG.

  When searching at the time of delivery, the product code and BRAND are usually specified, and the product with the expiration date and date of manufacture specified when there is an instruction is issued. FIG. 12 shows an allocation pattern in the case where goods are issued by BRAND in order of near expiration date and in order of date of manufacture.

  In this case, the allocation pattern code is A16, the product code is set in the search item 1, BRAND is set in the search item 2, the expiration date is set in the search item 3, and the date of manufacture is set in the search item 4. Since the product code and BRAND are indispensable items at the time of delivery, “1” indicating that they are indispensable is entered in the delivery time designation section 23. In addition, since the expiry date and the date of manufacture are arbitrarily designated at the time of delivery, “0” indicating that the expiry date and the date of manufacture are arbitrarily designated is entered in the delivery time designation category field 23, and the expiration date is produced in the provisioning order field 24. In order to prioritize the date, the expiry date is set to '1', the production date is set to '2', and the ascending / descending order column 25 displays both the expiry date and the production date in ascending order. 'A' indicating that there is an input.

  A case is assumed where warehousing information as shown in FIG. 13 is registered using such a search pattern master. Here, it is shown that 1000 products with the product code 30301 are received at the expiration date 20061010, and 3500 products with the product expiration date 20061111 are received. For the inventory master based on such warehousing information registration, using the allocation pattern code A16 of FIG. 12, the product code: 30301, BRAND: BRAND-A, expiration date: not specified, date of manufacture: not specified Consider the case of specifying. In this case, the input screen is shown as a delivery information registration screen as shown in FIG.

  In FIG. 14, after the depositor code and the product name code are entered, a delivery information input screen is displayed based on the allocation pattern associated with the entered product name code, and the product code, BRAND, and delivery of the product to be delivered. The desired number is entered. The confirmation screen output as a result of the execution is configured as shown in FIG. Since the product code 30301 is allocated from the associated allocation pattern in the order of oldest expiration date, 1000 items with a goods receipt No. 001-01 net expiration date of 20061010 and a shelf life expiration date of warehousing No. 001-02 This shows that 200 were for 20061111, a total of 1200 were allocated.

<Consigner specified key>
The customer product name master and the search pattern master can be set for each depositor (customer) as a shipper and for each product (product group).

  For example, as shown in FIG. 16, for the depositor ABC product, the search key items for the product with the product name codes 61000001 and 65000001 are (1) product code, (2) BRAND, When the product code and the expiration date are such, a customer product name master 401 for the depositor ABC as shown in FIG. 17 is created. Similarly, for the product of depositor XYZ, the search key items for the product with product name code 6300101 are (1) product code, (2) expiration date, and for other product name codes, the product code and date of manufacture are used. In such a case, a customer product name master 402 for the depositor XYZ shown in FIG. 17 is created. When all the allocation patterns for the products of the depositor NNN are the production date regardless of the product name code, the customer product name master 403 for the depositor NNN of FIG. 17 is set.

  For the allocation pattern codes set in each customer product name master 401, 402, 403, a search pattern master 201 as shown in FIG. 18 is created and registered.

<Shipping information registration screen>
The exit information registration screen can be changed as shown in FIGS.

  As shown in FIG. 19, the initial screen 800 displays an initial screen including a depositor input field 801. Here, it is assumed that the allocation pattern A16 of FIG. 12 is set as the default search pattern of the depositor in the customer product name master. When the depositor code is entered in the depositor input field 801 on the initial screen 800, a screen 810 after depositor input as shown in FIG. 20 is displayed. On the post-depositor input screen 810, an input waiting state for the product name input field 811 is entered.

  When a product name code is input to the product name input field 811 on the depositor input screen 810, a first product name input screen 820 as shown in FIG. 21 is displayed. Here, the customer product name master is referred to based on the entered product name code, the item name of the corresponding search key item is displayed in the item name display column 821, and the state of waiting for input to the search condition input column 822 is entered. .

  When an input to the search condition input field 822 is made on the screen 820 after the first product name is input, the state shifts to a waiting state for input to the outgoing value field 823. When an entry is made in the delivery value field 823 (in this example, only the number entry field is entered), the screen moves to a first exit information input screen 830 as shown in FIG.

  When the product name code is input to the second product name code input field 812 on the first post-shipping information input screen 830, the screen moves to the second post-product name input screen 840. On the second post-product name input screen 840, the customer product name master is referred to based on the input product name code, the item name of the corresponding search key item is displayed in the item name display column 841, and the search condition input column 842 is displayed. Move to the input wait state.

  When an input to the search condition input field 842 is made on the second item name input screen 840, the state shifts to an input waiting state to the exit value field 843. When entry into the exit value column 843 is made, the screen shifts to a second exit information input screen 850 as shown in FIG.

  When the delivery information is confirmed, the process proceeds to an allocation confirmation screen 860 as shown in FIG. 25, and a delivery information confirmation process is performed.

  As described above, for a plurality of shippers and a plurality of commodities, the search logic can be facilitated by sharing search logic and inventory management can be ensured.

<Appendix>
(Appendix 1)
A step of creating a search pattern master by setting an allocation pattern as a search condition at the time of delivery for each type of product;
Accepting which of the allocation patterns registered in the search pattern master is assigned to the goods received;
Based on the allocation pattern assigned to the received goods, at least accepting the input of product information about items required for the search condition, and creating an inventory master;
Setting a search condition based on an allocation pattern assigned to the product, searching for product information stored in the inventory master, and registering delivery information;
Including inventory management methods.

(Appendix 2)
The inventory master includes a normal item composed of warehousing information of a received product, and a search key item in which an item necessary for a search condition of the allocated allocation pattern is posted from the normal item. The inventory management method described in 1.

(Appendix 3)
The inventory management method according to appendix 1 or 2, further including a step of creating a customer product name master in which basic information on products, managed product name codes, and allocation pattern codes are associated with each customer.

(Appendix 4)
An allocation pattern reception unit that receives registration of an allocation pattern that is a search condition at the time of delivery according to the type of product;
A search pattern master storage unit for registering an allocation pattern for each type of product received by the allocation pattern reception unit;
Based on the allocation pattern assigned to the input product, a warehousing information receiving unit that receives input of product information for at least an item required for the search condition;
An inventory master storage unit for storing product information received by the warehousing information reception unit;
A search condition receiving unit for receiving a search condition based on an allocation pattern assigned to the product;
A shipping information registration unit that searches for product information stored in the inventory master storage unit based on the search conditions received by the search condition reception unit and displays search results;
An inventory management system comprising.

(Appendix 5)
The stock master storage unit includes a normal item composed of warehousing information of a received product, and a search key item in which an item required for a search condition of the allocated allocation pattern is posted from the normal item The inventory management system according to appendix 4, which stores information.

(Appendix 6)
A customer product name master accepting unit that accepts registration of a customer product name master corresponding to the basic information of the product, management product name code and allocation pattern code for each customer;
A customer product name master storage unit for storing the customer product name master received by the customer product name master reception unit;
The inventory management system according to appendix 4 or 5, further comprising:

(Appendix 7)
Creating a search pattern master by setting an allocation pattern as a search condition at the time of delivery for each type of product;
Accepting which of the allocation patterns registered in the search pattern master is assigned to the goods received;
Based on the allocation pattern assigned to the received goods, at least accepting the input of product information about items required for the search condition, and creating an inventory master;
Setting a search condition based on an allocation pattern assigned to the product, searching for product information stored in the inventory master, and registering delivery information;
A program for causing a computer to execute an inventory management method including:

  ADVANTAGE OF THE INVENTION According to this invention, it becomes possible to reduce the amount of data which makes a shipping operation easy and needs to be managed.

The block diagram which shows schematic structure of this invention. Explanatory drawing of a search pattern master. Explanatory drawing which shows the table of an allocation pattern. Explanatory drawing of a customer product name master. Explanatory drawing of a customer product name master registration screen. Explanatory drawing of an inventory management item. Explanatory drawing of a warehousing information registration screen. Explanatory drawing of stock master. Explanatory drawing of the delivery information registration screen. Explanatory drawing of an allocation confirmation screen. Explanatory drawing which shows the specific example of a customer product name master and a search pattern master. Explanatory drawing which shows the specific example of the detailed item setting of an allocation pattern. Explanatory drawing which shows the example of an input screen of warehousing information registration. Explanatory drawing which shows the example of an input screen of warehousing information registration. Explanatory drawing which shows the example of a confirmation screen of warehousing information registration. Explanatory drawing which shows the specific example of the allocation pattern setting for every customer. Explanatory drawing which shows the specific example of a customer product name master. Explanatory drawing which shows the specific example of a search pattern master. Explanatory drawing which shows the specific example of the leaving information registration screen. Explanatory drawing which shows the specific example of the leaving information registration screen. Explanatory drawing which shows the specific example of the leaving information registration screen. Explanatory drawing which shows the specific example of the leaving information registration screen. Explanatory drawing which shows the specific example of the leaving information registration screen. Explanatory drawing which shows the specific example of the leaving information registration screen. Explanatory drawing which shows the specific example of the leaving information registration screen.

Claims (5)

A step of creating a search pattern master by setting an allocation pattern as a search condition at the time of delivery for each type of product;
Accepting which of the allocation patterns registered in the search pattern master is assigned to the goods received;
Based on the allocation pattern assigned to the received goods, at least accepting the input of product information about items required for the search condition, and creating an inventory master;
Setting a search condition based on an allocation pattern assigned to the product, searching for product information stored in the inventory master, and registering delivery information;
Including inventory management methods.   The inventory master includes a normal item composed of warehousing information of a received product, and a search key item in which an item necessary for a search condition of an allocated allocation pattern is posted from the normal item. The inventory management method according to 1. An allocation pattern reception unit that receives registration of an allocation pattern that is a search condition at the time of delivery according to the type of product;
A search pattern master storage unit for registering an allocation pattern for each type of product received by the allocation pattern reception unit;
Based on the allocation pattern assigned to the received goods, a warehousing information receiving unit that receives input of product information for at least items required for the search condition;
An inventory master storage unit for storing product information received by the warehousing information reception unit;
A search condition receiving unit for receiving a search condition based on an allocation pattern assigned to the product;
A shipping information registration unit that searches for product information stored in the inventory master storage unit based on the search conditions received by the search condition reception unit and displays search results;
An inventory management system comprising.   The stock master storage unit includes a normal item composed of warehousing information of a received product, and a search key item in which an item required for a search condition of the allocated allocation pattern is posted from the normal item The inventory management system according to claim 3, wherein information is stored. Creating a search pattern master by setting an allocation pattern as a search condition at the time of delivery for each type of product;
Accepting which of the allocation patterns registered in the search pattern master is assigned to the goods received;
Based on the allocation pattern assigned to the received goods, at least accepting the input of product information about items required for the search condition, and creating an inventory master;
Setting a search condition based on an allocation pattern assigned to the product, searching for product information stored in the inventory master, and registering delivery information;
A program for causing a computer to execute an inventory management method including:

Images