JP6215157B2 - Inventory cycle management device - Google Patents

Description

  The present invention relates to a technique for managing an inventory cycle.

  In the inventory, a shelf number is set for each shelf, and an inventory cycle is set for each shelf number. For example, when the inventory cycle is one month, the inventory is performed every month. Since normal inventory is performed on the parts in the shelf, if the parts to be delivered are different for each shelf, the inventory cycle for each part can be managed by setting the inventory cycle for each shelf. As a technique related to the inventory cycle, for example, Patent Document 1 discloses a technique for automatically specifying the inventory time. Management of parts for each shelf is common, but a technique for managing a stocktaking cycle for each part by putting a plurality of parts in the shelf is desired.

JP 2010-222098

  If there are different parts on the shelf, the inventory cycle is managed for each shelf in the past, so if the parts span other shelves, managing the inventory cycle for each shelf does not match the inventory cycle for each part There is a problem that will occur. For example, the part a of the shelf A and the part a of the shelf B are the same parts, but there is a problem that the inventory cycle changes.

  In order to solve the above-mentioned problems, the present invention solves the above-mentioned problem by taking an inventory cycle data DB for storing an item and an inventory cycle in association with each other, an inventory performance DB for storing the previous inventory date for each item, and an item in the inventory cycle data DB. The inventory cycle calculation processing unit that identifies the inventory cycle from the identified previous inventory date and the above inventory cycle by identifying the inventory cycle, identifying the item in the inventory history DB, identifying the previous actual inventory date And have.

  As described above, the present invention can manage the inventory cycle for each item.

It is a block diagram of the present invention. It is an item master data block diagram of this invention. It is an inventory cycle data block diagram of this invention. It is an inventory information data block diagram of this invention. It is an inventory performance data block diagram of this invention. It is an inventory request | requirement data block diagram of this invention. It is a flowchart of the item master registration process of this invention. It is a flowchart of the stock entering / exiting process of this invention. It is a flowchart of the circulation counting process for every item of this invention.

  A method for correctly calculating the inventory cycle for each item will be described as an embodiment of the present invention.

  FIG. 1 is a configuration diagram of an inventory cycle management device which is the device of the present invention. The inventory management system server 101 includes an inventory category registration processing unit 102 for registering an inventory category determined for each item, a shelf number registration processing unit 103 for registering a fixed shelf number determined for each item, and inventory category information registered for each item. And an item master DB 109 for storing fixed storage number information, an inventory cycle DB 110 for storing the actual number of inventory for each inventory category, an inventory receipt processing unit 104 for registering the number of inventory receipts when inventory receipt occurs, Inventory issue processing unit 105 that registers the number of inventory issues when it occurs, inventory information DB 111 that stores the number of inventory items for each item that accompanies receipt and receipt of inventory, and the inventory results that have been inventoried in a cycle with the correct inventory cycle for each item Stored inventory record DB 112, inventory cycle calculation processing unit 106 for correctly calculating the inventory cycle for each item, inventory count registration processing unit 107 for registering the inventory result, inventory counting It consists of inventory differences settlement processing unit 108 to settle differences fruit and inventory information. Further, the inventory cycle is calculated for each item by the inventory cycle calculation processing unit 106 from the inventory classification for each item that can be acquired from the item master DB 109, the number of inventory for each item that can be acquired from the inventory information DB 111, and the actual inventory for each item that can be acquired from the inventory performance DB 112. The result calculated correctly is written in the inventory request DB 113 and an inventory instruction is issued. Next, the data structure of the present invention will be described.

  FIG. 2 is an item master data configuration diagram of the present invention. As the data configuration of the item master DB 109 of the inventory management system server 101, an inventory classification and a shelf number for each item are managed as shown in the table shown in the item master DB 109. The item 201 of the item master DB 109 is managed with a name that can be identified for each item. The inventory category 202 of the item master DB 109 manages a category for determining an inventory cycle for each item. The inventory classification is defined by inventory cycle data described later. The shelf number 203 of the item master DB 109 manages the fixed shelf number when the item is managed at a fixed location. An item whose item and shelf number are determined on a one-to-one basis is defined as a fixed location, and an item whose item and shelf number are not determined on a one-to-one basis is a free location. Since the item of the fixed location can be determined with a fixed shelf number, it is managed as a fixed shelf number in the shelf number 203 of the item master DB 109. Since it is difficult to determine a fixed shelf number for a free location item, the shelf number 203 in the item master DB 109 is blank. Thereby, it can be understood which shelf number each item is in and the inventory classification is classified into it.

  FIG. 3 is an inventory cycle data configuration diagram of the present invention. As the data structure of the inventory cycle DB 110 of the inventory management system server 101, the number of inventory executions for each inventory category is managed as shown in the table of the inventory cycle DB 110. The inventory category 301 of the inventory cycle DB 110 manages the category that determines the inventory cycle. The number of inventory executions 302 in the inventory cycle DB 110 manages the number of times inventory is executed for one year for each inventory category. The detailed content 303 of the inventory cycle DB 110 is managed as the detailed content of the cycle for performing the inventory for each inventory category. For example, when the inventory classification is A, the detailed content 303 is monthly, indicating that the inventory is performed monthly. In addition, the inventory execution count 302 is 12, which indicates that the implementation is performed 12 times per year. In the case of inventory category A, inventory is executed once a month. In this embodiment, information on how many times the inventory is performed per year is stored. However, the present invention is not limited to this, and any information can be used as long as the period when inventory is performed can be known. The inventory cycle DB 110 is used to read the inventory category 301 of the inventory cycle DB 110 from the inventory category 202 of the item master DB 109 in which the inventory cycle of each item is managed, and to obtain the number of inventory implementations for each item. It is also used to calculate the inventory cycle for each item from the number of inventory executions for each item. The detailed content 303 includes information about when the inventory timing will occur. For example, if the detailed content 303 is monthly, it means that inventory is performed every month.

  FIG. 4 is a configuration diagram of inventory information data according to the present invention. As the data structure of the inventory information DB 111 of the inventory management system server 101, the shelf number and the number of inventory are managed as inventory information for each item as shown in the table shown in the inventory information DB 111. As a result, it is possible to grasp how many items are in stock in which shelf number.

  The shelf number 401 of the inventory information DB 111 is managed as the inventory information for each item. In the item 402 of the inventory information DB 111, the item for each shelf number in stock is managed as the inventory information for each item. The stock number 403 of the stock information DB 111 is managed as a stock number for each item as a stock information for each item, and a stock number for each item. For example, the storage number TANA-01 stores that there is an item a with 100 in stock. The stock number 403 increases when stock is received and decreases when stock is delivered. The lock flag 404 of the inventory information DB 111 is 1 when the stock entry / exit is locked, and the stock entry / exit is disabled. When the stock entry / exit is not locked, the value is 0, and the stock can be entered / exited. The lock flag 404 is used to make it impossible to enter and leave stock when starting inventory. The inventory information DB 111 is used as inventory information for calculating an inventory cycle for each item.

  FIG. 5 is an inventory record data configuration diagram of the present invention. As the data structure of the inventory record DB 112 of the inventory management system server 101, the previous inventory record is managed as the inventory record for each item as shown in the table in the inventory record DB 112. The item 501 of the inventory record DB 112 is managed as an inventory record for each item. The previous inventory date 502 of the inventory performance DB 112 manages the previous inventory date for each item for which inventory has been performed as the inventory performance for each item. The inventory record DB 112 manages the inventory record, and stores, for example, that the previous inventory of the item a was on September 1, 2013. The inventory result DB 112 is used to calculate the number of inventory executions for each item obtained by reading the inventory category 301 of the inventory cycle DB 110 from the inventory category 202 of the item master DB 109 into the KEY and calculating the inventory cycle for each item. In addition, the previous inventory date 502 in the inventory performance DB 112 is updated with the date of inventory as the actual inventory when the inventory is completed.

  FIG. 6 is an inventory request data configuration diagram of the present invention. The inventory request is managed as a result of correctly calculating the inventory cycle for each item as shown in the table shown in the inventory request DB 113 as the data configuration of the inventory request DB 113 of the inventory management system server 101. The shelf number 601 in the inventory request DB 113 manages the shelf number requested for the inventory as a result of correctly calculating the inventory cycle for each item. In the item 602 of the inventory request DB 113, an item for each shelf number requested for inventory is managed as a result of correctly calculating the inventory cycle for each item. The inventory quantity 603 of the inventory request DB 113 manages the inventory number requested for inventory and the inventory quantity for each item as a result of correctly calculating the inventory cycle for each item. The previous inventory date 604 of the inventory request DB 113 manages the previous inventory date for each item requested for inventory as a result of correctly calculating the inventory cycle for each item. The scheduled inventory date 605 of the inventory request DB 113 manages the scheduled inventory date for each item requested for inventory as a result of correctly calculating the inventory cycle for each item. For example, the item “a” of the shelf number TANA-01 is managed with information such as the last inventory date of 2013/9/1 and the next inventory scheduled date of 2013/10/01 for the inventory number 100. The inventory count 606 of the inventory request DB 113 manages the actual inventory count that has received the inventory result from the inventory request for each item.

  The flowchart of the present invention will be described.

  FIG. 7 is a flowchart of the item master registration process of the present invention. The item master registration process is a flowchart of master management for determining the inventory cycle for each item of the cycle inventory for each item. In the item master registration process, information on items, storage bins corresponding to the items, and inventory classifications are received from the user and system and registered in the item master DB.

  For example, the item a is stored in the item master DB 109 of the inventory management system server 101 in step S1 of the item master registration process. In step S2, the inventory classification A is stored in the item a stored in the item master DB 109 of the inventory management system server 101. In step S3, the item a stored in the item master DB 109 of the inventory management system server 101 is an item whose fixed location is managed, and the fixed location TANA-01 of the item a is stored as the storage bin TANA-01. Since the relationship between item a and storage bin TANA-01 is determined on a one-to-one basis, it is defined as a fixed location, so the storage bin of the fixed location is TANA-01. In addition, since it is difficult to determine a fixed shelf number for a free location item, the shelf number is blank.

  FIG. 8 is a flowchart of the stock entry / exit processing of the present invention. The stock entering / exiting process is a flowchart of stock management by stock change of the stock quantity due to stocking / shipping. The inventory information for each item stored in the inventory information DB 111 of the inventory management system server 101 in step S4 of the inventory entry / exit process is increased and stored.

  For example, when the inventory number of the item a is 10 in the storage number TANA-01 when the inventory number of the item a of the storage number TANA-01 is 100, the inventory number of the item a of the storage number TANA-01 is 110 is stored. In step S5, the inventory information for each item stored in the inventory information DB 111 of the inventory management system server 101 is reduced and stored. When the inventory number of the item a of the storage bin TANA-01 is 100 and the inventory of the item a of the storage bin TANA-01 occurs in the storage bin TANA-01, the inventory number of the item a of the storage bin TANA-01 is 90. Remembered.

  FIG. 9 is a flowchart of the cycle counting process for each item according to the present invention. The cycle counting process for each item is a flowchart of the inventory management in which the inventory is cyclically performed at the inventory cycle for each item. Inventory for each item can be managed for each item based on the actual inventory count that can be acquired from the inventory category determined for each item and the planned inventory date calculated from the previous inventory date for each item.

  In step S6, the inventory cycle calculation processing unit identifies the inventory category and the shelf number of the item stored in the item master DB 109 of the inventory management system server 101, compares the identified inventory category with the inventory cycle DB, and determines the inventory cycle. Is identified. Specifically, for example, the inventory category A and the shelf number TANA-01 of the item a are acquired, the inventory cycle DB 109 of the inventory management system server 101 is read from the inventory category A, the inventory category A is read as KEY, and stored in the inventory cycle DB 109. The inventory count 12 is acquired. The inventory count 12 indicates that the detailed content 303 is monthly, and the inventory is performed monthly. The number of inventory executions is information on how many times the inventory is performed in the year, and the number of inventory executions 12 means that the inventory is performed 12 times a year. In this embodiment, the inventory cycle is controlled by specifying the inventory cycle from the item and specifying from the inventory cycle. However, the present invention is not limited to this, and the item and the inventory cycle are associated with each other in the inventory cycle DB. The inventory cycle may be specified from the item.

  The identified item is collated with the inventory information DB 111, and the shelf number (including the case where there are a plurality of items) and the number of inventory of the item are identified. Thus, it is possible to specify how many stocks each item has in which shelf number. Specifically, for example, the inventory information DB 111 of the inventory management system server 101 is read with the item a as KEY, and the inventory number 100 of the storage bin TANA-01 and the inventory of the storage bin TANA-02 stored in the inventory information DB 111 are stored. The number 50 is acquired. In consideration of a case where stocks exist in a plurality of storage bins as stock information, the number of stocks is acquired by searching for item a as KEY.

  The identified item is collated with the inventory record DB 112 to identify the previous inventory date. Specifically, for example, the inventory record DB 112 of the inventory management system server 101 is read with the item a as KEY, and the previous inventory date 2013/9/1 of the item a stored in the inventory record DB 112 is acquired.

  Specify the next scheduled inventory date from the previous inventory date of the acquired item. Specifically, for example, the inventory cycle of the item a is calculated from the previous inventory date 2013/9/1 of the acquired item a. The inventory count 12 indicates that the detailed content 303 is monthly, and the inventory is performed monthly. In this embodiment, since information on how many times the inventory is performed per year is stored, since one year is 12 months, the inventory is performed every month by twelve times of inventory execution 12 times 12. That can be acquired. The planned inventory date 2013/10/1 is calculated by adding the acquired inventory execution period to the previous inventory date 2013/9/1.

  Here, the inventory cycle is calculated from the number of times the inventory has been performed. However, the present invention is not limited to this, and since the cycle information is stored in the detailed contents 303 of the inventory cycle DB 110, the cycle period is calculated from here. Information may be acquired and control may be performed so as to specify the planned inventory date by adding to the inventory date.

  Information on the scheduled inventory date, the shelf number, and the inventory quantity of each shelf number of the identified item is stored in the inventory request DB. Specifically, for example, in the inventory request DB 113 of the inventory management system server 101, the scheduled inventory date 2013/10/1 of the previous inventory date 2013/9/1 of the inventory number 100 of the item a with the storage number TANA-01 and the storage bin number. The scheduled inventory date 2013/10/1 of the previous inventory date 2013/9/1 of the inventory number 50 of the item a of TANA-02 is stored. From the inventory cycle DB, specify that the cycle of the shelf numbers TANA-01 and TANA-02 is once a month, and set 2013/10/1 one month after the previous inventory date 2013/9/1 as the planned inventory date. Set.

  In step S7, inventory request data for each item is created as a result of calculating the inventory cycle for each item. Specifically, an inventory record of item a is created from the inventory request DB 113 of the inventory management system server 101. The inventory record is inventory request data for each item. Based on this inventory request data, inventory of each item is executed.

  In step S8, when executing inventory, it is necessary to physically lock the warehouse for the item to be inventoried, and the lock status is registered in the inventory information DB. Specifically, for example, the shelf number TANA-01 of the item a and the TANA-02 of the item a cannot be loaded / unloaded and are locked. Specifically, the lock flag of the item a of the storage bins TANA-01 and TANA-01 in the inventory information DB is changed from 0 to 1, and information indicating that entry / exit is impossible is registered.

  In step S9, an inventory list for actually counting the actual items from the inventory request data calculated for each item is printed, and an inventory list in which the inventory request data is listed is printed according to the request. The inventory list is a list to be referred to when the person in charge of the inventory actually executes the inventory. In this embodiment, printing is performed on paper, but the present invention is not limited to this, and control may be performed such that the information is displayed on the information display terminal. In the inventory list, the necessary information specified, for example, information such as items, shelf numbers, the number of stocks in each shelf number, the previous inventory date, the scheduled inventory date, and the like are printed in the inventory list. Specifically, for example, in the case of the inventory list of the item a, the planned inventory date 2013/10/1 of the previous inventory date 2013/9/1 of the inventory number 100 of the item a of the storage number TANA-01 and the storage number TANA. Information such as the planned inventory date 2013/10/1 of the previous inventory date 2013/9/1 for the inventory number 50 of the item a of −02 is printed.

  In step S10, the result of inventory by the person in charge is received. In this embodiment, the person in charge inputs the actual inventory information confirmed based on the output inventory list to the system. However, the present invention is not limited to this, and the inventory list is stored in an information terminal such as a tablet. It is good also as displaying and accepting directly from the information terminal. Specifically, for example, the person in charge counts the actual stock of the item a with reference to the inventory list to which the item a is output. The result of counting the actual stock of item a is entered in the inventory list of item a. The actual stock quantity of each shelf number for each item listed in the inventory list is input to this system. The actual inventory of the item a is manually counted in the actual storage bins TANA-01 and TANA-02. The inventory result of the item a is registered in the present system with reference to the inventory list of the item a in which the result of counting the actual inventory of the item a is described. It is registered as an inventory result in the inventory count 606 of the inventory request DB 113. Specifically, the lock flag for the item a of the storage bins TANA-01 and TANA-01 in the inventory information DB is changed from 1 to 0, and information indicating that entry / exit is possible is registered.

  In step S11, the inventory difference settlement processing unit compares the received actual stock information with the number of stocks to confirm whether there is a difference and performs settlement processing. Specifically, the difference in the inventory result of the item a is referred to the inventory number 100 of the item a of the shelf number TANA-01 in the inventory information DB 107 of the inventory management system server 101 and the inventory number 50 of the item a of the shelf number TANA-02. And make a payment. The difference between the inventory quantity 603 and the inventory quantity 606 in the inventory request DB 101 is checked for any difference between the inventory quantity on the system and the actual inventory. If there is no difference, settlement is completed, and if a difference occurs, the number of inventory is corrected to match the actual stock and settlement is completed.

  In step S12, the lock of the shelf number TANA-01 of the item a and the shelf number TANA-02 of the item a is released, and entry / exit becomes possible. The lock flag of the inventory information DB 111 is changed from 1 to 0. Specifically, in the case of item a, the lock flags of TANA-01 and TANA-02 are changed from 1 to 0.

  In step S13, the previous inventory date is updated in the inventory record DB 112. Specifically, for example, in the inventory record DB 112 of the inventory management system server 101, the date when inventory is executed when the item a is invented is updated as the previous inventory date. When the stocktaking is performed on 2013/10/1, the previous stocktaking date is updated on 2013/10/1.

  The feature of the present invention is that the inventory cycle can be managed for each item that could not be performed when the inventory performance was managed for each shelf number by managing the inventory performance for each item. Another feature is that an inventory request is created for each item. The management man-hours can be reduced by abolishing the manual management of inventory results. For inventory, it is possible to quickly identify inventory differences for items with the highest value by determining the period of inventory based on the value of each item, so that the difference in inventory value can be reduced. There was a concern that the stock price difference would increase due to the occurrence of inventory, and it was necessary to carry out inventory based on the track record of manual management.

101: Inventory management system server, 102: Inventory classification registration processing unit, 103: Storage number registration processing unit, 104: Inventory entry processing unit, 105: Inventory issue processing unit, 106: Inventory cycle calculation processing unit, 107: Inventory counting Registration processing unit, 108: Inventory difference settlement processing unit, 109: Item master DB, 110: Inventory cycle DB, 111: Inventory information DB, 112: Inventory result DB, 113: Inventory request DB, 201: Item, 202: Inventory classification , 203: storage number, 301: inventory classification, 302: inventory count, 401: storage number, 402: item, 403: inventory number, 501: item, 502: previous inventory date, 601: storage number, 602: item, 603: Inventory quantity, 604: Previous inventory date, 605: Inventory inventory date, 606: Inventory quantity

Claims (4)

An inventory cycle data DB for storing items and inventory cycles in association with each other;
An inventory performance DB for storing the previous inventory date for each item;
And inventory information DB for storing in association with lock flag for controlling the entry and leaving of the corresponding information, and the item in the inventory associating one to one and a number of inventory and storage bin and the item respectively,
The item is collated with the inventory cycle data DB, the inventory cycle of the item is identified, the item is collated with the inventory history DB, the previous inventory actual date of the item is identified, and the identified previous inventory date Identify the planned inventory date of the item from the inventory cycle,
Compare the item with the inventory information DB, specify the inventory number of the shelf number of the item , create the specified inventory scheduled date and the inventory request data of the item having the specified information ,
In the inventory information DB, an inventory cycle calculation processing unit that sets the lock flag associated with the corresponding information including the item of the inventory request data created to be in an unloadable state ;
An inventory cycle management device comprising: The inventory cycle management device according to claim 1,
In addition, it has an item master DB that stores items and inventory categories in association with each other.
The inventory cycle data DB stores the inventory category and the inventory cycle in association with each other,
The inventory cycle calculation processing unit
The item is collated with the item master DB to identify the inventory category, the identified inventory category is collated with the inventory cycle data DB, the inventory cycle is identified, the item is collated with the inventory history DB, and the previous inventory actual date The inventory cycle management device is characterized in that the scheduled inventory date is identified from the identified previous inventory date and the inventory cycle. The inventory cycle management device according to any one of claims 1 to 2,
The inventory cycle management apparatus, wherein the inventory cycle calculation processing unit identifies a planned inventory date by adding the identified inventory cycle to the identified inventory date. Stored in the inventory cycle data DB in association item and inventory cycle, the last inventory date of the each item stored in the inventory record DB, correspondence information which associates one to one the number of stock and the shelf number items respectively, And storing the lock flag for controlling the loading and unloading of the item at the time of inventory in the inventory information DB ;
The item is collated with the inventory cycle data DB, the inventory cycle of the item is identified, the item is collated with the inventory history DB, the previous inventory actual date of the item is identified, and the identified previous inventory date Identifying a planned inventory date for the item from the inventory cycle ;
Collating the item with the inventory information DB, specifying the inventory number of the storage bin of the item, creating the specified inventory scheduled date, and creating the inventory request data of the item having the specified information; ,
In the inventory information DB, setting the lock flag associated with the corresponding information having the item of the created inventory request data to a state in which entry / exit is disabled,
An inventory cycle management method comprising:

Images