JP6979870B2 - Paint management equipment and programs - Google Patents

Description

Embodiments of the present invention relate to paint management devices and programs.

At the factory, a product management system has been introduced to improve the efficiency of work such as ordering and receiving product materials, parts and paints. In particular, proper management of paint, which is one of the materials of products, leads to more efficient manufacturing. In the prior art, in order to solve the loss of residual paint, which is one of the problems for managing paint, a reuse system of residual paint using manufacturing information such as usage status has been proposed. The residual paint reuse system has the purpose of reducing the loss of residual paint by using basic information storage means, lot information storage means, and the like. The basic information storage means stores the paint specific information necessary for specifying the paint, such as the code of the product to be manufactured, the product name, and the paint color, as the basic information of the product. The lot information storage means stores the paint specific information required for the manufacturing lot of the product as lot information. However, for paints used in manufacturing processes, data related to paints such as paint storage locations and disposal information are not clearly managed. For this reason, in the paint management situation, there were cases where the place to store the paint could not be found, the order exceeded the maximum storage amount specified by the Fire Service Act, and it was unclear whether or not the paint could be disposed of.

Japanese Unexamined Patent Publication No. 2004-334250

An object to be solved by the present invention is to provide a paint management device and a program capable of grasping the location of an individual paint in a storage and improving the efficiency of actual working time.

The paint management device of the embodiment has a paint information storage unit, a search collation unit, a warehousing management unit, a warehousing management unit, a disposal management unit, and a specified amount determination unit. The paint information storage unit stores identification information for identifying the paint in can units in association with the location of the paint. The search collation unit searches the paint information storage unit based on the identification number, and outputs the location corresponding to the identification number. At the time of warehousing of the paint, the warehousing management unit registers the storage place after the warehousing of the paint as the place. The delivery management unit registers the place of use of the paint after delivery as the place at the time of delivery of the paint.

The block diagram which shows the system configuration of the paint management system by one Embodiment. The schematic diagram which shows the specific example of the label output in the same embodiment. The data structure diagram which shows the specific example of the paint information table in the same embodiment. A data structure diagram showing a specific example of the product information table in the same embodiment. The flowchart which shows the procedure of the collation search processing in the same embodiment. The flowchart which shows the procedure of the warehousing process in the same embodiment. The flowchart which shows the procedure of the shipping process in the same embodiment. The flowchart which shows the procedure of the shipping process in the same embodiment. The flowchart which shows the procedure of the disposal process in the same embodiment. The flowchart which shows the procedure of the specified amount determination process at the time of ordering a paint in the same embodiment.

Hereinafter, the paint management device and the program of the embodiment will be described with reference to the drawings.

(Embodiment)
FIG. 1 is a block diagram showing a schematic functional configuration of a paint management system. The paint management system is a system that manages paints for each paint can by associating paint information such as an identification number assigned to each paint, an abbreviated number, an ordering state, a warehousing state, and disposal.

The paint management system includes a paint management device 1, a product information management device 2, a network 3, a terminal device 4, a scanner 5, and a label printer 6. The paint management device 1, the product information management device 2, the terminal device 4, and the scanner 5 are communicably connected via the network 3. The network 3 may be constructed by any network. For example, the network 3 may be configured by the Internet, a LAN (Local Area Network), or the like. In the configuration of this system, as an example, the processing unit is described separately for each device, but all the processing units and functions of each device may be mounted in the same device.

The paint management device 1 includes a paint management processing unit 10 and a paint information storage unit 11.
The paint management processing unit 10 manages the search, warehousing, warehousing, and disposal of paint using data representing the attributes of the paint (hereinafter referred to as “attribute data”) such as the location and expiration date of the paint. The paint management processing unit 10 is a functional unit that performs processing such as search and warehousing management based on the data received from the terminal device 4, the scanner 5, and the like.

The paint information storage unit 11 stores a data table of paint information (hereinafter referred to as “paint information table”). The paint information table is a table in which data of paint cans related to paint management are registered. In the paint information table as data of paint cans related to paint management, information on identification number, abbreviated number, order status, warehousing status, label printing, disposal status, location label reading, location, delivery date, expiration date and capacity is registered. Has been done. The paint information storage unit 11 associates identification information for identifying the paint on a can-by-can basis, a warehousing state, a disposal state, information on the location of the paint, the capacity of the paint can, and the expiration date of the paint. Remember. The warehousing state indicates whether or not the paint has been warehousing, and the disposal state indicates whether or not the paint has been discarded.

The paint management device 1 outputs information such as the location, abbreviated number, and expiration date of each paint from the paint information table stored in the paint information storage unit 11 and a two-dimensional code converted from an identification number to the label printer 6. do. Further, in the following, the identification number is used as the identification information of the paint can, but an abbreviated number or a two-dimensional code may be used instead of the identification number.

Next, a specific configuration of the paint management processing unit 10 will be described. The paint management processing unit 10 includes a search collation unit 101, a warehousing management unit 102, a warehousing management unit 103, a disposal management unit 104, and a specified amount determination unit 105.

The search collation unit 101 searches the paint information table using the identification number as the data of the search key, and acquires the information of the storage location corresponding to the identification number. Then, the search collation unit 101 acquires the paint data of the individual paint can including the identification number and the abbreviated number of the paint from the paint information table of the paint information storage unit 11, and passes the acquired paint data to another functional unit. In addition, the search collation unit 101 may use another attribute data existing in the database such as an abbreviated number and a paint number instead of using the identification number as the data of the search key at the time of the search.

The warehousing management unit 102 registers the storage location after warehousing of the paint at the time of warehousing of the paint. Then, the warehousing management unit 102 updates the location information and the warehousing state of the paint information table of the paint information storage unit 11 based on the two-dimensional code of the location label received from the terminal device 4 or the scanner 5. Further, the warehousing management unit 102 notifies the label printer 6 of the code information corresponding to the identification information. Specifically, first, the warehousing management unit 102 notifies the search collation unit 101 of the search processing command. Next, the warehousing management unit 102 acquires data such as a warehousing state and a storage location from the search collation unit 101. Then, the warehousing management unit 102 generates a two-dimensional code from the identification number and outputs it to the label printer 6 together with the acquired data. Further, the warehousing management unit 102 updates the warehousing state of the paint after updating the location information of the paint. At this time, the location label used as the location information is installed in the place where the paint is stored, and the location information is printed as a two-dimensional code.

The delivery management unit 103 displays the location information acquired from the search collation unit 101. Further, the delivery management unit 103 registers the place of use after the paint is delivered when the paint is delivered. Then, the delivery management unit 103 updates the location information and the location label reading information in the paint information table of the paint information storage unit 11 based on the two-dimensional code of the label L1 and the location label. Specifically, first, the delivery management unit 103 notifies the search collation unit 101 of the search processing command. Next, the delivery management unit 103 acquires the location information of the paint can from the search collation unit 101. Then, the delivery management unit 103 displays the acquired location information to the user. The output method may be any output method such as audio output, video output, and image output. Further, the delivery management unit 103 updates the location information of the paint information table of the paint information storage unit 11 to the information of the place of use at the time of delivery.

The disposal management unit 104 determines whether or not to dispose of the paint by referring to the expiration date stored in the paint information storage unit 11. The expiration date is the date when the production of the product ends or the expiration date of the stored paint. Specifically, first, the disposal management unit 104 notifies the search collation unit 101 of the search processing command. Next, the search collation unit 101 searches the paint information storage unit 11 using the identification number as a key, and acquires the disposal information of the corresponding paint can. When the corresponding paint can meets the expiration date determination criterion, the disposal management unit 104 registers the location information of the disposal site in the location information of the paint data. If the disposal determination criteria are not satisfied, the disposal management unit 104 cancels the disposal process of the corresponding paint.

The specified amount determination unit 105 executes the specified amount determination process when the ordering process is performed by the order management unit 201, which will be described later. The specified amount determination unit 105 refers to the paint information storage unit 11 and the product information storage unit 21, which will be described later, at the time of ordering the paint, and the capacity of the paint whose warehousing state has been warehousing and whose disposal state has not been discarded. It is determined whether or not the sum of the sum of the paints and the ordered amount of the paint is equal to or less than the predetermined maximum storage amount. Specifically, first, the specified amount determination unit 105 notifies the search collation unit 101 of the search processing command. Next, the specified amount determination unit 105 acquires the storage amount information of the paint can from the search collation unit 101. The specified amount determination unit 105 does not acquire the capacity of all the individual paint cans as the capacity data, but acquires the total capacity of the paint cans whose warehousing state is "completed" and whose disposal state is "not yet". do. When the total storage amount of the ordered and undisposed paint and the paint amount to be ordered exceeds the maximum specified storage amount specified by the Fire Service Act, the specified amount determination unit 105 orders the paint. The order management unit 201, which will be described later, is notified of the order for canceling the processing. If the total storage amount of the ordered and undisposed paint and the amount of the paint to be ordered do not exceed, the specified amount determination unit 105 notifies the order management unit 201 of an order to continue the paint ordering process. ..

The product information management device 2 manages information on the paint used for the product and information on the order, and performs order processing and acceptance processing. The product information management device 2 includes a product management processing unit 20 and a product information storage unit 21. The product information storage unit 21 stores a product information table (hereinafter referred to as “product information table”). The product information table is a table in which data on paint cans related to paint ordering and product management are registered.

The product management processing unit 20 is a functional unit that processes data transmitted from the terminal device 4, the scanner 5, and the like, and includes an order management unit 201 and an acceptance management unit 202.
The order management unit 201 stores data such as a paint order number and a paint color number in the product information storage unit 21 and performs an order processing. At this time, the order management unit 201 issues an identification number to each paint can to be ordered, and stores the data in association with the order number, the abbreviated number, and the like. Further, the order management unit 201 requests the specified amount determination unit 105 to determine the specified amount each time the order processing is performed, and waits for the notification of the determination result. Then, when the order management unit 201 is notified of the continuation order from the specified amount determination unit 105, the order management unit 201 restarts the paint order processing. On the other hand, when the order to stop is notified from the specified amount determination unit 105, the order management unit 201 cancels the paint ordering process.
When the paint is delivered, the acceptance management unit 202 prints an acceptance slip on which an order number, abbreviated number, etc. are described, and performs acceptance processing for each paint. Since the acceptance management unit 202 may acquire information such as an order number and an abbreviated number from the product information storage unit 21 stored in the order management unit 201, the acceptance management unit 202 performs the acceptance process without printing the acceptance slip. You may.

The paint management processing unit 10 not only refers to the data stored in the paint information storage unit 11 existing in the same device, but also refers to the data stored in the product information storage unit 21 via the network 3. do. Similarly, the product management processing unit 20 also refers to the paint information storage unit 11 and the product information storage unit 21 via the network 3.

The terminal device 4 is a device that receives an instruction input of data such as a search key and displays an output result. As the terminal device 4, for example, an information processing device such as a PC (personal computer) or a tablet terminal can be used. Further, as a method of inputting a search instruction to the terminal device 4, manual input, voice, a button, or the like can be used. Further, the terminal device 4 transmits the code information output from the scanner 5 to the paint management device 1 via the network 3. The search instruction data may be sent to the paint management device 1 and the product information management device 2 as needed. Then, the output data from each device and each processing unit may be displayed on the terminal device 4 as needed.

The scanner 5 is a device that optically reads a two-dimensional code from a location label installed at a place where paint is placed and a label L1 printed by a label printer 6. Then, the scanner 5 outputs the read code information to the terminal device 4. The input data read by the scanner 5 may be sent not only to the terminal device 4 but also to the paint management device 1 and the product information management device 2 via the network 3 as needed.

The label printer 6 is connected to the paint management device 1 as an output device, and prints the output result of the paint management device 1 on the label L1. Further, the output result printed on the label L1 includes a paint information table of the paint information storage unit 11, a product information table of the product information storage unit 21, and a two-dimensional code based on the identification information. The label printer 6 is an example of an output device. As the output result, the data stored in the paint information storage unit 11 may be output from another output device such as a display.

FIG. 2 is a schematic diagram showing a specific example of the output label L1. The paint information output from the paint management device 1 and the two-dimensional code generated based on the identification number are printed on the label L1. As an example, the paint information printed on the label L1 includes an identification number, an expiration date, a drawing number, a location, an acceptance date, an abbreviated number, and a two-dimensional code. The material of the label L1 is not limited to paper, stickers, etc., and the display format is not limited.

FIG. 3 is a data configuration diagram showing an example of a schematic configuration of a paint information table stored by the paint information storage unit 11. The data items registered in the paint information table are the identification number, abbreviated number, order status, warehousing status, label printing, disposal status, location label reading, location, delivery date, and expiration date. And the capacity.

The identification number is a number issued to identify the paint can as an individual. Since the identification number is also included in the product information table of FIG. 4 to be described later, it is used as a primary key in the paint information table of the paint information storage unit 11. The abbreviated number is information having a one-to-one correspondence with the above-mentioned identification number, and is a number expressed in a format more simplified than the identification number.

The order status indicates whether or not the paint has been ordered. As for the data item in the order status, "finished" data is registered when the paint is ordered. After that, the order status data item is updated from "completed" to "not yet" when the goods receipt status becomes "completed".
The warehousing state indicates whether or not the paint can has been warehousing. Once the paint has been received, the "finished" data is registered in the data item in the warehousing state regardless of whether or not the paint has been warehousing. After that, the data item in the warehousing state is updated from "finished" to "not yet" in the warehousing state after the disposal state becomes "finished".

Label printing indicates whether or not a label has been printed during the warehousing process of paint. As for the data item of label printing, when the label is printed, the label printing is updated from "not yet" to "finished". The disposal state indicates whether or not the paint can has been discarded. When the paint is discarded, the data item of the disposal status is updated from "not yet" to "finished". After that, the data item in the disposal status is updated from "completed" to "not yet" in the disposal status after the warehousing status is changed to "completed".

The location label reading indicates whether or not the location label installed at the place where the paint can is placed is read. For the data item of location label reading, when the location label is read, the location label reading is updated from "not yet" to "done". After that, the data item of the location label read is updated from "done" to "not" after the discard state is changed to "done".

The location represents the place where the paint was last registered. The location data item represents the shelf number generated from the location label installed at the paint can storage location. Although the shelf number is used as an example for the data item of the place, it may be represented by the latitude and longitude, the corresponding area, or the like.

The delivery date represents the date when the paint can was delivered and the acceptance process was performed.
The expiration date represents the date after a predetermined period from the date of delivery. As an example, the expiration date of the paint is set to 6 months, but the expiration date may be arbitrarily determined for each paint can. In addition, the expiration date is updated on the production end date when the production of the product in which the paint is used is completed.
The capacity represents the storage amount of each paint can.

FIG. 4 is a data configuration diagram showing a schematic configuration of a product information table stored in the product information storage unit 21. As an example, the data items stored in the product information storage unit 21 are the product number, the order number, the identification number, the abbreviated number, the paint number, the order status, the acceptance slip printing, and the design notification printing. And include.

The product number represents a number assigned to each product in the process of manufacturing each product, which is a number that uniquely identifies the type of the product to be manufactured. Further, in the product information table of the product information storage unit 21, the product number is used as the primary key for the purpose of product management.
The order number is a number assigned to uniquely identify each order of the paint can when the order is processed.

The identification number represents a number issued to identify the paint can as an individual.
The abbreviated number is information having a one-to-one correspondence with the above-mentioned identification number, and is a number expressed in a format more simplified than the identification number.

The paint number is a number used when ordering a paint associated with the color and capacity of the paint.
The order status indicates whether or not the paint has been ordered. The order status data item updates the order status from "not yet" to "finished" when the paint is ordered. After that, the order status data item is updated from "completed" to "not yet" when the goods receipt status becomes "completed".
The acceptance slip printing indicates whether or not the paint acceptance process and the acceptance slip have been printed. As for the data item of the acceptance slip printing, when the acceptance slip is printed, the acceptance slip printing is updated from "not yet" to "completed". The order management unit 201 stores data of acceptance slips such as identification numbers and abbreviated numbers. Therefore, when the acceptance slip is paperless, the data item of the acceptance slip printing is updated from "not yet" to "completed" when the stored acceptance slip data is used in the acceptance process. The design notice printing indicates whether or not the design notice has been printed. The data item for printing the design notice is updated from "not yet" to "finished" when the design notice is printed. Even when the design notice is paperless, the data item for printing the design notice is "Not yet" when the stored design notice data is used in the warehousing process, as in the case of printing the acceptance slip mentioned above. Is updated to "Done".

However, the paint information table of the paint information storage unit 11 and the product information table of the product information storage unit 21 described above are listed as specific examples. Therefore, when each processing unit needs other attribute data at the time of execution, each processing unit adds the necessary data to the data table of the paint information storage unit 11 or the product information storage unit 21. May be good. In this embodiment, as an example, the paint information table and the product information table referred to by the search collation unit 101 are divided into two storage units, but the present embodiment may be implemented in one storage unit or a plurality of storage units.

FIG. 5 is a flowchart showing a processing procedure by the search collation unit 101. The search collation unit 101 performs a data search with reference to the data in the paint information table of the paint information storage unit 11 and the product information table of the product information storage unit 21. Then, when the data associated with the data of the instructed search key such as the identification number exists, the search collation unit 101 outputs the data associated with the instructed search key. Further, if the data associated with the data of the instructed search key does not exist, the search collation unit 101 outputs an error and ends the search process. The search collation unit 101 is issued by each processing unit when any of the processing units of the warehousing management unit 102, the warehousing management unit 103, the disposal management unit 104, and the specified amount determination unit 105 is executed. Receive notification of processing instructions. Therefore, in the processing procedure of the warehousing management unit 102, the warehousing management unit 103, the disposal management unit 104, and the specified amount determination unit 105, which will be described later, the procedure of issuing a processing command notification to the search collation unit 101 will be described and searched. The description of the processing procedure of the collation unit 101 will be omitted.

In step S1, the search collation unit 101 notifies the paint information storage unit 11 or the product information storage unit 21 of the search key data notified from the terminal device 4 or the scanner 5.

Next, in step S2, the search collation unit 101 searches for the instructed data from the paint information table and the product information table using data that is a search key such as an identification number and a product number. If the searched data exists, the process proceeds to step S3, and if the searched data does not exist, an error is displayed and the search process is stopped.

Next, in step S3, the search collation unit 101 outputs the data of the search key notified from the terminal device 4 or the scanner 5, and the data associated with the data of the search key.

FIG. 6 is a flowchart showing a processing procedure by the warehousing management unit 102. The warehousing management unit 102 updates the location information of the paint can to the warehousing location based on the data acquired from the search collation unit 101, and updates the location information of the paint can used by the warehousing management unit 103 to the original storage location. do. Further, when updating the location information, the warehousing management unit 102 prints a label corresponding to each storage place for each paint can.

In step S11, the warehousing management unit 102 notifies the search collation unit 101 of the search processing command, and acquires the location information corresponding to the identification number as the search result. Then, the warehousing management unit 102 notifies the label printer 6 of the label printing command corresponding to each storage place.

Next, in step S12, the warehousing management unit 102 uses the paint data corresponding to the identification number acquired from the search collation unit 101 and the location information notified from the terminal device 4 or the scanner 5, and uses the paint information table. To update. Then, the warehousing management unit 102 updates the location information of the paint information table to the location information of the storage location, updates the warehousing status to "finished", and updates the disposal status to "not yet".

FIG. 7 is a flowchart showing a processing procedure by the delivery management unit 103. The delivery management unit 103 displays the storage location of the paint can based on the data acquired from the search collation unit 101.

In step S21, the delivery management unit 103 notifies the search collation unit 101 of the search processing command, and acquires the paint data corresponding to the identification number as the search result.

Next, in step S22, the delivery management unit 103 outputs the location information of the paint acquired in step S21 on the screen.

FIG. 8 is a flowchart showing a processing procedure by the delivery management unit 103. The delivery management unit 103 updates the location information of the paint can from the storage location to the usage location based on the data acquired from the search collation unit 101.

In step S31, the delivery management unit 103 notifies the search collation unit 101 of the search processing command, and acquires the data of the paint corresponding to the identification number as the search result. Then, the delivery management unit 103 acquires the information on the place of use notified from the terminal device 4 or the scanner 5 that has read the location label.

Next, in step S32, the delivery management unit 103 updates the location information of the paint information table acquired from the search collation unit 101 with the information of the usage location.

FIG. 9 is a flowchart showing a processing procedure by the disposal management unit 104. The waste management unit 104 determines whether or not to dispose of the paint based on the date when the production of the product is completed or the data of the expiration date.

In step S41, the disposal management unit 104 notifies the search collation unit 101 of the search processing command, and acquires the data of the paint corresponding to the identification number as the search result. Then, the disposal management unit 104 uses the acquired paint data to determine whether or not the date on which the disposal process is performed exceeds the date on which the production of the product is completed. If the production end date is not exceeded, the process proceeds to step S42 described later, and if the production end date is exceeded, the process proceeds to step S43 described later.

In step S42, the disposal management unit 104 uses the acquired paint data to determine whether or not the date on which the disposal process is performed exceeds the expiration date of the paint. If the expiration date has been exceeded, the process proceeds to step S43 described later, and if the expiration date has not been exceeded, the process proceeds to step S44 described later.

In step S43, the disposal management unit 104 updates the location information of the paint can to be disposed of to the location information of the disposal site, and proceeds to step S45.

In step S44, the disposal management unit 104 displays an error indicating that disposal is not possible, and ends the disposal process.

In step S45, the disposal management unit 104 determines the paint cans registered as the disposal site based on the location information from the data of all the paint cans, and displays the disposal. Then, the disposal management unit 104 updates the disposal state of the paint can data to "finished", and updates the warehousing state, the ordering state, and the location label reading to "not yet".

FIG. 10 is a flowchart showing a processing procedure by the specified amount determination unit 105. The specified amount determination unit 105 receives the specified amount determination notification issued when the order processing unit 201 performs the order processing via the network 3, and performs the determination processing. In the specified amount determination unit 105, the total amount of the capacity of the paint cans whose warehousing state is "finished" and the disposal state is "not yet" and the total amount of the ordered amount of paint exceed the maximum specified storage amount stipulated by the Fire Service Act. Judge whether or not. Then, the specified quantity determination unit 105 notifies the order management unit 201 of an order based on the determination result.

In step S51, the specified amount determination unit 105 notifies the search collation unit 101 of the search processing command and acquires the paint can data. Then, the specified amount determination unit 105 determines the ordered amount of paint, the current storage amount of the paint can whose warehousing state is "finished" and the disposal state is "not yet", and the maximum specified storage amount specified for each factory by the Fire Service Act. Register the quantity and.

Next, in step S52, the specified amount determination unit 105 compares the data registered in step S51, and determines whether or not the sum of the ordered amount of the paint and the current stored amount exceeds the maximum specified storage amount. If the sum of the ordered amount of the paint and the current storage amount exceeds the maximum specified storage amount, the process proceeds to step S53, and if not, the process proceeds to step S54. In this embodiment, the determination is made based on the maximum storage amount specified by the Fire Service Act as an example, but the determination may be made based on the maximum storage amount of the warehouse or the like.

In step S53, the specified quantity determination unit 105 displays an error that the order cannot be placed. Then, the specified quantity determination unit 105 notifies the order management unit 201 of an order to cancel the order processing.

In step S54, the specified quantity determination unit 105 associates the product number using the paint with the order number, and notifies the order management unit 201 of the order processing continuation order.

According to at least one embodiment described above, the paint management device 1 has a search collation unit 101 that searches for a target paint from the paint information table of the paint information storage unit 11 including location information, disposal deadline information, and the like. , The warehousing management unit 102 that prints labels from the product number and identification number and updates the location information, and the warehousing management department that displays the storage location of paint and updates the location information from information such as design notices and abbreviated numbers. 103, the disposal management department 104 that makes a disposal decision based on the disposal deadline and the end date of product production, and the regulation that compares the total of the maximum specified storage amount, paint order amount, and current storage amount stipulated by the Fire Service Law. By having the amount determination unit 105, it is possible to manage and control the paint in the storage.

It should be noted that at least a part of the functions of the paint management system in the above-described embodiment may be realized by a computer. In that case, a program for realizing this function may be recorded on a computer-readable recording medium, and the program recorded on the recording medium may be read by a computer system and executed. The term "computer system" as used herein includes hardware such as an OS and peripheral devices. The "computer-readable recording medium" is a portable medium such as a flexible disk, a magneto-optical disk, a ROM, a CD-ROM, a DVD-ROM, or a USB memory, or a storage device such as a hard disk built in a computer system. That means. Further, a "computer-readable recording medium" is a communication line for transmitting a program via a network such as the Internet or a communication line such as a telephone line, and dynamically holds the program for a short period of time. It may also include a program that holds a program for a certain period of time, such as a volatile memory inside a computer system that is a server or a client in that case. Further, the above-mentioned program may be for realizing a part of the above-mentioned functions, and may be further realized for realizing the above-mentioned functions in combination with a program already recorded in the computer system.

Although some embodiments of the present invention have been described, these embodiments are presented as examples and are not intended to limit the scope of the invention. These embodiments can be implemented in various other embodiments, and various omissions, replacements, and changes can be made without departing from the gist of the invention. These embodiments and variations thereof are included in the scope of the invention described in the claims and the equivalent scope thereof, as are included in the scope and gist of the invention.

1 ... Paint management device, 2 ... Product information management device, 3 ... Network, 4 ... Terminal device, 5 ... Scanner, 6 ... Label printer, 10 ... Paint management processing unit, 11 ... Paint information storage unit, 20 ... Product management processing Department, 21 ... Product information storage unit, 101 ... Search collation unit, 102 ... Goods receipt management department, 103 ... Goods issue management department, 104 ... Disposal management department, 105 ... Regulation amount judgment unit, 201 ... Order management department, 202 ... Acceptance management Department

Claims (4)

The identification information for identifying the paint on a can-by-can basis is stored in association with the location of the paint, and the warehousing state indicating whether or not the paint has been received and whether or not the paint has been discarded. A paint information storage unit that stores the disposal state indicating the above and the capacity of the can of the paint in association with the identification information.
A search collation unit that searches for the paint information storage unit based on the identification information and outputs the location corresponding to the identification information.
At the time of warehousing of the paint, the warehousing management unit that registers the storage place after the warehousing of the paint as the place, and
When the paint is delivered, the delivery management unit that registers the place of use after the paint is delivered as the location,
At the time of ordering the paint, referring to the paint information storage unit, the sum of the total capacity of the paint whose warehousing state is already received and whose disposal state is not discarded and the order quantity of the paint are calculated. A specified amount determination unit that determines whether or not it is less than or equal to a predetermined maximum specified storage amount,
A paint management device equipped with. The warehousing management unit prints code information corresponding to the identification information.
The paint management device according to claim 1. The paint information storage unit further stores the expiration date of the paint in association with the identification information.
A disposal management unit that determines whether or not to dispose of the paint by referring to the expiration date stored in the paint information storage unit.
The paint management device according to claim 1 or 2. Computer,
A program for functioning as the paint management device according to any one of claims 1 to 3.

Images