JPH11203562A - Inventory controller - Google Patents

Abstract

PROBLEM TO BE SOLVED: To control inventory by integrating a master file for inventory control, providing a conversion table to register a merchandise code and a unit to count it and inputting data on stock and sales of a merchandise as a normal control unit. SOLUTION: An inventory controller is provided with a merchandise data storage part 7 to store inventory information of the merchandise, a pack data storage part 8 to register the merchandise code and a quantity unit of the merchandise, a quantity conversion means 6 to convert the merchandise code and the quantity unit of the stock data and the sales data into the merchandise code and the minimum reference unit to be used for stock control, a merchandise data input means as to register the merchandise data, a pack data input means 2 to register the merchandise code and the quantity unit, a stock data input means 4 to input the stock data, a sales data input means 3 to input the sales data and a stock updating means 5 to update stock control information by a conversion result by the quantity conversion means 6.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to inventory management of commodities, and more particularly, to inventory management of commodities having various kinds of commodity codes and quantity units in purchase, sales, and inventory management.

[0002]

2. Description of the Related Art Juices and drinks sold in supermarkets and drugstores are the same product, but have different management units in various situations of product transactions, and are assigned different product codes for each unit. In such products, purchasing is often performed in boxes or packs, and sales are often performed in packs or single items. However, performing purchasing and sales operations while paying attention to the quantity relations in various units will confuse inventory management. In other words, even if the actual purchase is in units of packaging, when it is sold, it is sold individually or in units of sales such as cases or packs. For inventory management, it is necessary to change the units and product codes of purchase data and sales data to the quantity units and product codes for inventory management.

According to Japanese Patent Application Laid-Open No. 5-189264,
The invention of inventory management is disclosed for a pharmaceutical inventory management system. Pharmaceuticals also have the same control unit issues as described above. According to the publication, a stock master file for medicines, a stock master file for each package, and a file for registering a conversion constant of a management unit are provided, respectively, to manage payout and purchase.

[0004]

The first problem is that, in the above-mentioned prior art method, two master files and a file for registering constants for converting units are provided, and between the master files. Measures and management to prevent inconsistency are required.

A second problem is that the capacity of the two master files and the conversion files themselves increases as the number of products and the number of management units increase.

[0006] An object of the present invention is to provide a single master file for inventory management, provide a conversion table for registering configuration information of management units, and input purchase and sales data in a normal management unit. To perform inventory management.

[0007]

Therefore, an inventory management apparatus according to the present invention comprises: a product data storage unit for storing stock information of a product; a pack data storage unit for registering a product code and a unit of quantity of a product; Means for converting product data and sales data into product codes and minimum basic units used for inventory management; product data input means for registering new product data in the product data storage unit; Pack data input means for registering a product code and a quantity unit, purchase data input means for inputting purchase data of a product, sales data input means for inputting sales data of a product, and a product code and a unit of quantity by the quantity conversion means And a stock updating means for updating the stock information based on the conversion result.

Further, the commodity data storage unit stores inventory information including a commodity code used for inventory management of the commodity, a minimum basic unit which is a unit of quantity in the commodity code, and an inventory quantity counted by the minimum basic unit. It is characterized by having.

Still further, the pack data storage unit stores a product code assigned to each product to be managed, a unit name representing a quantity in the product code, a basic unit name constituting the unit name, It is characterized by having a conversion table for registering the quantity in units and the quantity.

Further, the quantity conversion means searches the conversion table based on the product code in the sales data or the purchase data until a product code whose quantity unit is counted in the minimum basic unit is obtained, and The inventory information is updated by converting the product code and quantity of data or purchase data into a product code and quantity managed in the minimum basic unit.

Further, the inventory management device monitors inventory information in the product data storage unit, and when there is a product code whose stock quantity is below a threshold, a stock shortage that warns of a product stock shortage indicated by the product code. It is characterized by having detecting means.

[0012] The present invention provides a method for managing inventory of products having different product codes, such as a single product, a plurality of single products in a single pack, and a plurality of packs packed in a box. To provide. Usually, purchasing is done in the largest unit, for example, in boxes,
Sales are often made in smaller units, such as packs or single items. For each product code of a product managed in various units, a unit name for counting the quantity, a basic unit of the unit, and a quantity in the basic unit are registered. A product code managed in the minimum basic unit is searched for in the basic unit, and the product is managed in the product code and its minimum basic unit.

[0013]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described with reference to the drawings. Referring to FIG. 1 showing a first embodiment of the present invention, an inventory management device includes a product data input unit 1 for inputting product data, and a pack data input unit 2 for inputting a product code and pack data in unit of quantity. Purchase data input means 3 for inputting purchase data, sales data input means 4 for inputting sales data, inventory update means 5 for updating stock quantities, and product codes for managing products and their quantities in stock. The system includes a quantity conversion unit 6 for converting the data into the minimum basic unit, a product data storage unit 7, and a pack data storage unit 8. In the product data storage unit 7, inventory information 40 shown in FIG. 4 is registered in addition to product data (not shown), and a product code 41 used for inventory management for each product and a minimum basic number in a basic unit of the quantity in the product code 41 are stored. Unit 42
And the stock quantity 43 counted by the minimum basic unit 42 are stored. In the pack data storage unit 8, a conversion table 50 relating to constants for converting quantity units is registered, and is represented by a product code 51, a unit name 52 thereof, a basic unit name 53 constituting the unit name 52, and a basic unit 53. The quantity 54 is stored. The product data input means 1 inputs a product name, a product code 41 used for inventory management, and a minimum basic unit name 42 of a counting unit. The pack data input means 2 includes a product code 51 in a product management unit, a unit name 52 in the product code 51, a basic unit name 53 constituting the unit name 52, and a quantity 54 counted in the basic unit 53;
Is input for each product code of the management target and registered in the conversion table 50 of the pack data storage unit 8. The purchase data input means 3 inputs purchase data such as a purchase date, a product code, and a purchase quantity in the product code. Based on the product code and the quantity, the quantity conversion means 6 searches the conversion table 50 and performs inventory management. Product code 41
And its minimum basic unit 42. The quantity conversion means 6 adds the quantity to the stock quantity 43 of the product data storage unit 7 by the stock updating means 5. The sales data input means 4 inputs sales data such as a sales date, a product code, and a quantity, and based on the product code and the quantity,
The quantity conversion means 7 converts the product code 41 of the inventory management target and the quantity of the minimum basic unit 42. The quantity conversion means 6
Using the stock updating means 5, the quantity is subtracted from the stock quantity 43 in the product data storage unit 7, and the stock information of the product is updated.

Next, the input of product data by the product data input means 1 will be described with reference to FIGS. The product data input by the product data input means 1 is stored in the product data storage unit 7. The product data storage unit 7 stores the stock quantity of the product in the stock information 40 in addition to the input product data (not shown). When a product is newly registered, the stock quantity 43 of the stock information 40 is stored as “0”. In this way, the product code 41, the basic unit 42, and the stock quantity 43 of the stock management target are
All are registered in the stock information 40 of the product data storage unit 7.

Next, referring to FIG. 2, which describes a case where a product has a different product code for each management object and is counted in different quantity units, the product 23 of the product code 003A is
The merchandise 22 of the merchandise code 002A is counted in the basic unit “pack”, and “20 packs” is defined as “1 box”. Further, “1 pack” of the product 22 of the product code 002A is configured with “10” products 21 of the product code 001A as a basic unit. The product code input by the pack data input means 2 and the unit for counting the product code will be described with reference to FIG. The pack data input unit 2 configures a product code for each management target, a unit name for counting the management target, and one unit in the unit name for the product data stored in the product data storage unit 7. The basic unit and the quantity of the basic unit constituting one unit are input and registered in the conversion table 50 of the pack data storage unit 8.

Next, input of purchase data and update of stock information by the purchase data input means 3 will be described with reference to FIG. The data input as purchase data includes a purchase date, a supplier, a product code, a quantity, and the like. When the stocking is performed, the stock quantity increases, so the stock quantity 43 of the stock information 40 stored in the product data storage unit 7 is stored.
Need to be updated. When the purchase data is input, the purchase data input means 3 uses the quantity conversion means 6 to input the product code of the purchase data and the quantity thereof (step 31), and stores the product code 41 of the stock management object and the corresponding product code. Is converted to the quantity of the minimum basic unit 42. The quantity conversion means 6 searches the conversion table 50 of the pack data storage unit 8 and determines whether there is a corresponding product code (step 32). If the product code does not exist (step 32
N), the given product code and quantity are returned to the purchase data input means 3 as they are. If there is the product code (Y in step 32), the product code is replaced with a product code in units of its basic unit, and the quantity is converted into the quantity of the basic unit (step 33). For example, the quantity of a given product code is “5” units, and the “1” unit is “2”.
If the basic unit is “0”, the converted quantity is “20 × 5”.
= 100 ". Further, the conversion table 50 is searched again, and it is determined whether or not there is a product code whose unit name is the basic unit of the corresponding product code (step 32). By repeating this process until a product code having the minimum basic unit as a unit name is found, the counting unit of the product code is the minimum basic unit, and a quantity converted to the minimum basic unit is obtained.
In the search of the conversion table 50 described above, for example, data indicating that the product 23 having the product code 003A is “5 boxes”
First, it becomes “100 packs” (= 20 packs × 5 boxes) of the product 22 of the product code 002A, and the conversion table 50 is searched by the basic unit “piece” of the unit “pack”.
The product 21 having the product code 001A having the unit name of “unit” is found, the unit name of the product 21 is determined to be the minimum basic unit, and “100 packs” is changed to “1000 units” (=
10 packs x 100 packs). The purchase data input means 3 gives “1000 pieces” converted by the quantity conversion means 6 to the stock updating means 5 and adds it to the stock quantity 43 of the corresponding product code 41 in the stock information 40.

Next, the sales data input means 4
Input of sales data of a product will be described. The data input as the sales data includes a sales date, a product code, a quantity, and the like. If there is a sale, the stock quantity decreases, so the stock quantity 43 stored in the stock information 40 of the product data storage unit 7 is updated. When the sales data is input, the sales data input means 4 uses the quantity conversion means 6 to input the product code and the quantity of the sales data,
The product code to be subjected to inventory management and the quantity of the minimum basic unit thereof are converted and provided to the inventory updating means 6, and the product data storage unit 7
Is subtracted from the stock quantity 43. The operation of the quantity conversion means 6 is the same as in the case of inputting sales data.

Next, a second embodiment will be described with reference to FIG. Referring to FIG. 6, a stock shortage detecting means 9 is added to the embodiment shown in FIG. The stock shortage detecting means 9 detects a product code 41 whose stock quantity 43 is insufficient from the stock information 40 stored in the product data storage unit 7. Further, product data input means 1
Inputs the threshold value of the detected quantity of the stock shortage referred to by the stock shortage detecting means 9 and stores it in the product data storage unit 7 as the product data.

FIG. 7 shows the operation of the stock shortage detecting means 9.
This will be described with reference to FIG. First, for each product code 41 of the stock information 40 in the product data storage unit 7, it is determined whether or not the product of the product code 41 is the product code of the minimum basic unit of inventory management (step 71). This decision
The determination can be made based on whether or not there is a corresponding product code in the pack data storage unit 8. If it is not the minimum basic unit, it is not processed and the next search is continued (step 72). If the product code 41 is the minimum basic unit 42 (Y in step 73), the stock quantity 43 stored in the stock information 40 is compared with the threshold of the detected quantity of stock shortage, and the stock quantity is lower than the threshold quantity. (Y in step 74), it is necessary to perform the purchase, but the purchase is often performed in a large unit such as a box. For this reason, when the product that has run out of stock is stored as a component of another product in the pack data storage unit 8 (Y in step 75), the product is replaced with the product with the product code of the largest unit (step 75). 7
6). When all products have been searched (Y in step 71),
Output a list of products that have run out of stock (Step 7)
8).

[0020]

The first effect of the present invention is that, for the same product, which is traded in a variety of product codes and units, the product is normally handled in a business such as purchasing, sales, or inventory. Even if the product code and the unit are used, the conversion table is searched, and inventory management can be performed with one product code and the minimum basic unit for each product.

Further, the second effect is that sales, purchase, and inventory management of products having various product codes and units are managed by one master file, so that a problem of inconsistency of a plurality of master files does not occur. .

A third effect is that since there is only one master file, the file capacity does not become larger than in the conventional technique of a plurality of master files.

A fourth effect is that inventory management and detection of inventory shortage can be performed only by monitoring the inventory quantity of one master file, and can be performed by simple means.

[Brief description of the drawings]

FIG. 1 is a diagram showing a first embodiment of the present invention.

FIG. 2 is a diagram for explaining that management units are different when a product is handled.

FIG. 3 is a diagram showing an operation in which a quantity conversion unit in FIG. 1 searches for a product code and a basic unit.

FIG. 4 is a diagram showing a configuration of stock information in a product data storage unit in FIG. 1;

FIG. 5 is a diagram showing a configuration of a conversion table in a pack data storage unit in FIG. 1;

FIG. 6 is a diagram showing a second embodiment of the present invention.

FIG. 7 is a diagram showing an operation of a stock shortage detection unit in FIG. 6;

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 1 Product data input means 2 Pack data input means 3 Purchasing data input means 4 Sales data input means 5 Inventory update means 6 Quantity conversion means 7 Product data storage unit 8 Pack data storage unit 9 Inventory shortage detection means

────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission date] November 27, 1998

[Procedure amendment 1]

[Document name to be amended] Statement

[Correction target item name] Claims

[Correction method] Change

[Correction contents]

[Claims]

[Procedure amendment 2]

[Document name to be amended] Statement

[Correction target item name] 0007

[Correction method] Change

[Correction contents]

[0007]

Therefore SUMMARY OF THE INVENTION, conversion the inventory management system, which registers the product data storage unit for storing inventory information of the product, the product code and unit of measure products of the present invention
Pack data storage unit for storing the calculation table, quantity conversion means for converting purchase data and sales data into a product code and a minimum basic unit used for inventory management, and product data for registering new product data in the product data storage unit Input means for identifying the same kind of product in the pack data storage unit
A pack data input unit for registering a product code and a unit of quantity to which a child is assigned, a purchase data input unit for inputting purchase data of the product, a sales data input unit for inputting sales data of the product, and the product by the quantity conversion unit And a stock updating means for updating the stock information based on the code and the conversion result of the quantity unit.

[Procedure amendment 3]

[Document name to be amended] Statement

[Correction target item name] 0008

[Correction method] Change

[Correction contents]

Furthermore, the stock information, features and product code used for inventory management of goods, the minimum basic unit is a unit of measure in the product code, and a-law including and a stock quantity for counting by the minimum basic unit And

[Procedure amendment 4]

[Document name to be amended] Statement

[Correction target item name] 0009

[Correction method] Change

[Correction contents]

Still further, the conversion table may be a product of the same type.
A product code provided with an identifier indicating the product name, a unit name representing the quantity in the product code, a basic unit name constituting the unit name, and a quantity in the basic unit.
And wherein and Turkey.

[Procedure amendment 5]

[Document name to be amended] Statement

[Correction target item name] 0011

[Correction method] Deleted

[Procedure amendment 6]

[Document name to be amended] Statement

[Correction target item name] 0013

[Correction method] Change

[Correction contents]

[0013]

DESCRIPTION OF THE PREFERRED EMBODIMENTS The present invention will be described with reference to the drawings. Referring to FIG. 1 showing a first embodiment of the present invention, an inventory management device includes a product data input unit 1 for inputting product data, and a pack data input unit 2 for inputting a product code and pack data in unit of quantity. Purchase data input means 3 for inputting purchase data, sales data input means 4 for inputting sales data, inventory update means 5 for updating stock quantities, and product codes for managing products and their quantities in stock. The system includes a quantity conversion unit 6 for converting the data into the minimum basic unit, a product data storage unit 7, and a pack data storage unit 8. In the product data storage unit 7, inventory information 40 shown in FIG. 4 is registered in addition to product data (not shown), and a product code 41 used for inventory management for each product and a minimum basic number in a basic unit of the quantity in the product code 41 are stored. Unit 42
And the stock quantity 43 counted by the minimum basic unit 42 are stored. Pack data storage unit 8, the conversion table 50 about the constant for converting the unit of measure is registered, the same kind products
A product code 51 provided with an identifier indicating the unit name, a unit name 52 thereof, a basic unit name 53 constituting the unit name 52,
The quantity 54 represented by the basic unit 53 is stored. The product data input means 1 inputs a product name, a product code 41 used for inventory management, and a minimum basic unit name 42 of a counting unit. The pack data input means 2 is the same as the input product code.
A product code 51 provided with an identifier indicating a product, a unit name 52 in the product code 51, a basic unit name 53 constituting the unit name 52, and a quantity 54 counted by the basic unit 53, Is registered in the conversion table 50 of the pack data storage unit 8. The purchase data input means 3 inputs purchase data such as a purchase date, a product code, and a purchase quantity in the product code. Based on the product code and the quantity, the quantity conversion means 6 searches the conversion table 50 and performs inventory management. Of the product code 41 and its minimum basic unit 42. The quantity conversion means 6 adds the quantity to the stock quantity 43 of the product data storage unit 7 by the stock updating means 5. The sales data input means 4 inputs sales data such as a sales date, a product code, and a quantity, and outputs a product code 51 and a quantity.
Based on 54 , the quantity conversion means 7 converts the product code 41 of the stock management target into the quantity of the minimum basic unit 42. The quantity converting means 6 uses the stock updating means 5 to subtract the quantity from the stock quantity 43 in the product data storage unit 7 to update the stock information of the product.

[Procedure amendment 7]

[Document name to be amended] Statement

[Correction target item name] 0015

[Correction method] Change

[Correction contents]

Next, referring to FIG. 2, which describes a case where a product has a different product code for each management target and is counted in different quantity units, an identifier A indicating the same type of product is assigned.
The product 23 with the product code 003A is the product code 002
The product 22 of A is counted in the basic unit “pack” and “20”
The “pack” is defined as “one box” in units. Further, “1 pack” of the product 22 of the product code 002A is the product code 0
The product 21 of 01A is configured with “10” as a basic unit. FIG. 5 shows a product code input by the pack data input unit 2 and a unit for counting the product code.
This will be described with reference to FIG. The pack data input means 2 stores, for the product data stored in the product data storage unit 7, a product code 51 for each management target, a unit name 52 for counting the management target, and one unit in the unit name. The basic unit 53 constituting the unit and the quantity 54 of the basic unit constituting the one unit
And the conversion table 5 in the pack data storage 8
Register to 0.

[Procedure amendment 8]

[Document name to be amended] Statement

[Correction target item name] 0016

[Correction method] Change

[Correction contents]

Next, input of purchase data and update of stock information by the purchase data input means 3 will be described with reference to FIG. The data input as purchase data includes a purchase date, a supplier, a product code, a quantity, and the like. When the stocking is performed, the stock quantity increases, so the stock quantity 43 of the stock information 40 stored in the product data storage unit 7 is stored.
Need to be updated. When the purchase data is input, the purchase data input means 3 uses the quantity conversion means 6 to input the product code of the purchase data and the quantity thereof (step 31), and stores the product code 41 of the stock management object and the corresponding product code. Is converted to the quantity of the minimum basic unit 42. The quantity conversion means 6 searches the conversion table 50 of the pack data storage unit 8 and determines whether there is a corresponding product code (step 32). If the product code does not exist (step 32
N), the given product code and quantity are returned to the purchase data input means 3 as they are. If there is the product code (Y in step 32), the product code is replaced with a product code in units of its basic unit, and the quantity is converted into the quantity of the basic unit (step 33). For example, the quantity of a given product code is “5” units, and the “1” unit is “2”.
If the basic unit is “0”, the converted quantity is “20 × 5”.
= 100 ". Further, the conversion table 50 is searched again, and it is determined whether or not there is a product code whose unit name is the basic unit of the corresponding product code (step 32). By repeating this search for identifiers pointing to the same kind of product until finding a product code with the minimum basic unit as the unit name,
The counting unit of the product code is the minimum basic unit, and the quantity converted into the minimum basic unit is obtained. Conversion table 50 described above
Is searched, for example, for the product 2 of the product code 003A.
The data "3" is "5 boxes".
"100 packs" of product 22 of A (= 20 packs x 5
Box), the conversion table 50 is searched by the basic unit “unit” of the unit “pack” to find the product 21 of the product code 001A having “unit” as the unit name, and the unit name of the product 21 is the minimum basic unit. It is determined that the unit is “100” and “100
"Pack" to "1000 pieces" (= 10 pieces x 100 packs)
Convert to The purchase data input means 3 gives “1000 pieces” converted by the quantity conversion means 6 to the stock updating means 5,
The stock quantity 43 of the corresponding product code 41 in the stock information 40
Is added to.

Claims (6)

[Claims] 1. An inventory management apparatus for a commodity which is handled in different commodity codes and quantity units in each case of inventory management, purchase and sales, wherein the commodity code and the commodity using the purchase data and sales data of the commodity for inventory management are provided. An inventory management device, wherein the inventory information is updated by converting into a minimum basic unit of code counting. 2. An inventory management device, comprising: a product data storage unit for storing inventory information of a product; a pack data storage unit for registering a product code and a unit of quantity of a product; and use of purchase data and sales data for inventory management. Quantity conversion means for converting a product code into a minimum basic unit; product data input means for registering new product data in the product data storage unit; and a product code and a quantity unit for each product in the pack data storage unit. Pack data input means, purchase data input means for inputting purchase data of a product, sales data input means for inputting sales data of a product, and the conversion result of the product code and the quantity unit by the quantity conversion means; The inventory management device according to claim 1, further comprising: inventory update means for updating information. 3. The inventory data storage unit includes inventory information including an inventory code used for inventory management of the inventory, a minimum basic unit that is a unit of quantity in the inventory code, and an inventory quantity counted by the minimum basic unit. The inventory management device according to claim 2, comprising: 4. The pack data storage unit includes: a product code assigned to each product to be managed; a unit name indicating a quantity in the product code; a basic unit name constituting the unit name; 3. The inventory management device according to claim 2, further comprising a conversion table for registering the quantity and the number of items. 5. The quantity conversion means searches the conversion table based on a product code in sales data or purchase data until a product code whose quantity unit is counted in the minimum basic unit is obtained, and 3. The inventory information is updated by converting a product code and quantity of data or purchase data into a product code and quantity managed in the minimum basic unit.
Inventory control device as described. 6. The inventory management device monitors inventory information in the product data storage unit, and when there is a product code whose inventory quantity is below a threshold, warns of inventory shortage of the product indicated by the product code. 3. The inventory management device according to claim 2, further comprising a detection unit.