JP2022054049A - Device, method, and program for managing product inventory - Google Patents

Abstract

To provide a product inventory management device capable of reducing operational mistakes by operators and the load on the operators by implementing a system which allows an inventory of accessories (second products) to be managed as products in the same way as main products (first product), and allows costs of accessories (second products) to be included in respective costs of main products (first products).SOLUTION: A product inventory management device is provided, having a control unit comprising: product integration instruction reception means configured to receive specification of a first product, specification of a second product, and a target quantity to be attached to the first product; inventory quantity updating means for updating an inventory quantity of the second product; and inventory valuation unit price updating means for updating an inventory valuation unit price of the first product.SELECTED DRAWING: Figure 1

Description

The present invention relates to a product inventory management device, a product inventory management method, and a product inventory management program.

For example, in the product sales industry, in most cases, sales of accessories such as tags, stickers, and packaging for a certain main product are not recorded as a single accessory even if inventory management is performed. Therefore, it was common that accessories were not managed due to the accounting system.

However, in some cases, the cost of accessories is included in the cost of the main product for management. In such a case, the main product is temporarily shipped out by inventory adjustment processing on the accounting system, and the cost is set. It was possible to change the cost price by performing the operation of changing and warehousing.

However, such processing is not only different from the actual practice, but also cost accounting is performed outside the accounting system, so that the operator's work mistakes occur frequently and the load on the operator is large. It was an issue.

Until now, no accounting system has been known to solve such a problem (Patent Document 1).

Japanese Unexamined Patent Publication No. 8-137955

An object of the present invention is to enable inventory management of an accessory (second product) as a product in the same manner as the main product (first product), and then set the cost price of the accessory (second product) as the main product (the main product (second product). By installing a system that can be included in the cost of the first product), it is intended to provide a product inventory management device that can reduce the operator's work mistakes and the load on the operator.

In order to solve the above-mentioned problems and achieve the object, the product inventory management device according to the present invention is a product inventory management device including a control unit, and the control unit determines (1) designation of the first product. , Accept or accept the designation of one or more second products to be attached to the designated first product and the target quantity to be attached to the designated first product for each of the designated second products. Alternatively, (2) the designation of the first product and the object to be attached to the designated first product for each of the designated second products registered in the product master in advance as the second product to be attached to the designated first product. For each of the product integration instruction receiving means that accepts the quantity and the designated second product received by the product integration instruction receiving means or registered in the product master, the designated second product registered in the inventory quantity data. Inventory evaluation of the inventory quantity updating means for updating the inventory quantity of the product to the quantity obtained by subtracting the specified target quantity from the stock quantity and the designated first product received by the product integration instruction receiving means. The inventory to be updated to the unit price obtained by adding the stock valuation unit price of the designated first product registered in the unit price data to the stock valuation unit price and the total valuation price of the second product per the designated first product. A designation obtained by integrating the designated target quantity into the stock valuation unit price of the designated second product registered in the inventory valuation unit price data, comprising the valuation unit price updating means. It is a feature that it is an evaluation price for all the designated second products obtained by summing all the evaluation prices for each of the second products.

Further, in the product inventory management device according to the present invention, the control unit receives the designation of the first product or the second product for inventory inquiry by the inventory inquiry receiving means, and the inventory inquiry receiving means receives the designation of the first product. The product or the second product is further provided with an inventory inquiry means for outputting the inventory quantity of the designated first product or the second product registered in the inventory quantity data.

Further, in the product inventory management device according to the present invention, the control unit accepts the designation of the purchased first product or the second product and the quantity of the purchased first product or the second product. The means is further provided, and the designated first product or the first product registered in the stock quantity data is provided by the inventory quantity updating means for the designated first product or the second product received by the purchase receiving means. (Ii) The inventory quantity of the goods is updated to the quantity obtained by adding the quantity of the first goods or the second goods purchased to the stock quantity.

Further, in the product inventory management device according to the present invention, the control unit receives the designation of the first product or the second product sold and the quantity of the first product or the second product sold. The designated first product or the second product registered in the inventory quantity data for the designated first product or the second product received by the sales receiving means by the inventory quantity updating means. It is characterized in that the stock quantity of the above is updated to the quantity obtained by subtracting the quantity of the first product or the second product sold from the stock quantity.

Further, the product inventory management method according to the present invention is a product inventory management method executed by a product inventory management device including a control unit, which is executed by the control unit (1) designation of a first product and Accept or accept the designation of one or more second products to be attached to the designated first product and the target quantity to be attached to the designated first product for each of the designated second products. (2) Designation of the first product and the target quantity to be attached to the designated first product for each of the designated second products registered in the product master in advance as the second product to be attached to the designated first product. And the designated second product registered in the inventory quantity data for each of the designated second product received by the product integration instruction receiving step or registered in the product master. The inventory valuation unit price for the specified first product received by the product integration instruction reception step and the inventory quantity update step to be updated to the quantity obtained by subtracting the specified target quantity from the stock quantity. Inventory valuation to update the inventory valuation unit price of the specified first product registered in the data to the unit price obtained by adding the second product total valuation price per specified first product to the inventory valuation unit price. A designation obtained by integrating the designated target quantity into the stock valuation unit price of the designated second product registered in the inventory valuation unit price data, including the unit price update step. It is characterized in that it is an evaluation price for all the designated second products obtained by summing all the evaluation prices for each of the second products.

Further, the product inventory management program according to the present invention is a product inventory management program for being executed by a product inventory management device provided with a control unit, and (1) designation of the first product to be executed by the control unit. And whether to accept the designation of one or more kinds of second products to be attached to the designated first product and the target quantity to be attached to the designated first product for each of the designated second products. Or (2) designation of the first product and attachment to the designated first product for each of the designated second products registered in the product master in advance as the second product to be attached to the designated first product. The designated first product registered in the stock quantity data for each of the target quantity, the product integration instruction reception step that accepts the product integration instruction reception step, and the designated second product that the product integration instruction reception step has received or registered in the product master. (Ii) The inventory quantity of the product is updated to the quantity obtained by subtracting the specified target quantity from the stock quantity, and the stock quantity of the designated first product received by the product integration instruction receiving step is in stock. The inventory valuation unit price of the designated first product registered in the valuation unit price data is updated to the unit price obtained by adding the second product total valuation price per designated first product to the inventory valuation unit price. The second product total valuation price, including the inventory valuation unit price update step, is obtained by integrating the specified target quantity into the designated inventory valuation unit price of the second product registered in the inventory valuation unit price data. It is characterized in that it is an evaluation price for all the designated second products obtained by summing up all the evaluation prices for each of the designated second products.

According to the present invention, the accessory (second product) can be inventory-managed as a product in the same manner as the main product (first product), and at the same time, the cost price of the accessory (second product) can be used as the main product (first product). ) Can be included in the cost price. As a result, it is possible to reduce the operator's work mistakes and the load on the operator.

FIG. 1 is a block diagram showing an example of the configuration of the PC 100. FIG. 2 is a diagram showing an example of an information processing flow by the product integration instruction receiving unit 102a, the inventory quantity updating unit 102e, and the inventory evaluation unit price updating unit 102f in one embodiment. FIG. 3 is a diagram showing an example of a product integration instruction screen for inputting information received by the product integration instruction reception unit 102a in one embodiment. FIG. 4 is a diagram showing an example of inventory quantity data in one embodiment. FIG. 5 is a diagram showing an example of inventory valuation unit price data in one embodiment. FIG. 6 is a diagram showing an example of inventory quantity data in one embodiment. FIG. 7 is a diagram showing an example of inventory valuation unit price data in one embodiment.

Embodiments of the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Constitution]
Here, an example of the configuration of the PC (personal computer) 100 according to the present embodiment including the product inventory management device of the present invention will be described with reference to FIG. The configuration of the present embodiment is merely an example, and the present invention is not limited to the realization of the configuration of the present embodiment. In addition, duplicate description may be omitted in the following description of the configuration.

FIG. 1 is a block diagram showing an example of the configuration of the PC 100. The PC 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108, and is a server 200 that stores various data (for example, each data stored in the storage unit 106, which may be described later). It is communicably connected to (for example, a Web server or the like) via a network 300 (for example, the Internet, an intranet, a LAN (Local Area Network), or the like).

Each part of the PC 100 is communicably connected via an arbitrary communication path.

The PC 100 may be a stationary type such as a desktop personal computer, or a portable type such as a notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be.

The control unit 102 is a CPU or the like that comprehensively controls the PC 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run.

The control unit 102 is functionally conceptually composed of a product integration instruction reception unit 102a, a purchase reception unit 102b, a sales reception unit 102c, an inventory inquiry reception unit 102d, an inventory quantity update unit 102e, an inventory evaluation unit price update unit 102f, and an inventory inquiry unit. It is equipped with 102 g and the like.

In the first embodiment, the product integration instruction receiving unit 102a designates the first product, designates one or more types of second products attached to the designated first product, and designates each of the designated second products. We accept the target quantity to be attached to the specified first product.

In the second embodiment, the product integration instruction receiving unit 102a designates the first product and designates each of the designated second products registered in the product master in advance as the second product attached to the designated first product. We accept the target quantity to be attached to the first product of.

The relationship between the first product and the second product for which the product integration instruction reception unit 102a accepts the designation is not particularly limited, and the products are purchased and received individually and can be one set at the time of sale. possible. In particular, the case where the first product is the main product and the second product is its accessory is targeted.

In one embodiment, the product integration instruction receiving unit 102a may accept not only the designation of the product and the target quantity, but also an identifier for distinguishing the integration, the date of integration, and the like. The identifier can be, for example, a number, an alphabet (including uppercase and lowercase letters), a symbol, or a combination thereof.

The designation of the first product and the designation of the second product received by the product integration instruction receiving unit 102a are not particularly limited as long as the product can be specified, and even if the designation is based on the product identifier, the designation is based on the product name. May be.

The merchandise master contains information about the merchandise such as the identifier of the first merchandise or the second merchandise, the classification of the first merchandise or the second merchandise, the merchandise name of the first merchandise or the second merchandise, and in the second embodiment, the first. The combination of one product and the second product attached to the first product is registered for each product.

The purchase receiving unit 102b receives the designation of the purchased first product or the second product and the quantity of the purchased first product or the second product.

The sales receiving unit 102c receives the designation of the first product or the second product sold and the quantity of the first product or the second product sold.

The inventory inquiry receiving unit 102d receives the designation of the first product or the second product for inventory inquiry.

The inventory quantity update unit 102e sets the inventory quantity of the designated second product registered in the inventory quantity data for each of the designated second products received by the product integration instruction reception unit 102a or registered in the product master. Update to the quantity obtained by subtracting the specified target quantity from the quantity.

In the inventory quantity data, information about the product such as the identifier of the first product or the second product, the product name of the first product or the second product, and the stock quantity of the first product or the second product are registered for each product. There is.

The inventory quantity update unit 102e determines the inventory quantity of the designated first product or second product registered in the inventory quantity data for the designated first product or second product received by the purchase reception unit 102b. The quantity is updated to the quantity obtained by adding the quantity of the first product or the second product purchased in.

The inventory quantity update unit 102e obtains the inventory quantity of the designated first product or the second product registered in the inventory quantity data from the inventory quantity for the designated first product or the second product received by the sales reception unit 102c. Update to the quantity obtained by subtracting the quantity of the first or second product sold.

The inventory valuation unit price update unit 102f designates the inventory valuation unit price of the designated first product registered in the inventory valuation unit price data as the inventory valuation unit price for the designated first product received by the product integration instruction reception unit 102a. Update to the unit price obtained by adding the total evaluation price of the second product per first product.

In the inventory valuation unit price data, information about the product such as the identifier of the first product or the second product, the product name of the first product or the second product, and the inventory valuation unit price of the first product or the second product are registered for each product. Has been done.

The total valuation price of the second product is the total of all the valuation prices for each of the designated second products obtained by adding the specified target quantity to the stock valuation unit price of the designated second product registered in the inventory valuation unit price data. It is the evaluation price for all the designated second products obtained.

The second product total evaluation price per designated first product is a price obtained by dividing the second product total evaluation price calculated by the following formula by the stock quantity of the designated first product.

Total evaluation price of the second product per designated first product = {(inventory evaluation unit price of the designated second product A) x (target quantity of the designated second product A) + (of the designated second product B) Inventory valuation unit price) x (Target quantity of designated second product B) + (Inventory valuation unit price of designated second product C) x (Target quantity of designated second product C) + ...} / (Specified Stock quantity of the first product)

The inventory inquiry unit 102g outputs the inventory quantity of the designated first product or second product registered in the inventory quantity data for the designated first product or second product received by the inventory inquiry reception unit 102d.

The communication interface unit 104 connects the PC 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line.

Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) / ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

The storage unit 106 conceptually includes an inventory quantity data storage unit 106a, an inventory evaluation unit price data storage unit 106b, a product master storage unit 106c, and the like.

The inventory quantity data storage unit 106a stores the inventory quantity data. The inventory valuation unit price data storage unit 106b stores the inventory valuation unit price data. The product master storage unit 106c stores the product master.

An input device 400 and an output device 500 are connected to the input / output interface unit 108. The output device 400 includes a display device such as a display and a projector, an acoustic device such as a speaker, a printing device such as a printer, and a device that can be downloaded in a data file format. As the data file file format, a file format known in the art such as PDF, CSV, document file, spreadsheet software file, text file, etc. can be adopted. In addition to the keyboard, mouse, and microphone, the input device 500 can use a monitor that realizes a pointing device function in cooperation with the mouse.

[2. Concrete example]
Here, using a specific example, FIGS. 2 to 5 are shown with respect to information processing by the product integration instruction receiving unit 102a, the inventory quantity updating unit 102e, and the inventory evaluation unit price updating unit 102f in the product inventory management device according to the present invention. It will be explained with reference to.

FIG. 2 is a diagram showing an example of the flow of information processing by the product integration instruction receiving unit 102a, the inventory quantity updating unit 102e, and the inventory valuation unit price updating unit 102f in this specific example. In this specific example, as shown in FIG. 2, first, the product integration instruction receiving unit 102a receives the designation of the first product and the second product and the target quantity (S01), and the inventory quantity updating unit 102e receives the inventory quantity data. The inventory quantity of each of the designated second products registered in is updated to the quantity obtained by subtracting the specified target quantity from the inventory quantity (S02), and the inventory valuation unit price update unit 102f is added to the inventory valuation unit price data. The inventory valuation unit price of the registered designated first product is updated to the unit price obtained by adding the total valuation price of the second product per designated first product to the inventory valuation unit price (S03).

FIG. 3 is a diagram showing an example of a product integration instruction screen for inputting information received by the product integration instruction reception unit 102a in this specific example. As shown in FIG. 3, on the product integration instruction screen of this specific example, from the top, the input unit X11 for the processing number (identifier for distinguishing the integration) and the input unit X21 for the processing date (date of integration). , Input display unit for the product (first product) (input unit X31 for the product code (product identifier) of the first product, display unit X32 for the product name of the first product displayed along with the input, first product Display unit X33 for the stock quantity of the product, and display unit X34 for the inventory evaluation unit price of the first product) One stage, input display unit for the stored goods / accessories (second product) (product code of the second product (product identifier) ) Input unit X41, the product name display unit X42 of the second product displayed along with the input, the stock quantity display unit X43 of the second product, the inventory evaluation unit price display unit X44 of the second product, the first Input unit X45) of the target number (target quantity) of the second product attached to the product, display unit of the updated inventory valuation unit price (integrated inventory valuation unit price) scheduled to be updated by the inventory valuation unit price update unit 102f. An X51, a confirm button X61, and a cancel button X62 are included.

FIG. 4 is a diagram showing an example of inventory quantity data before update by the inventory quantity update unit 102e in this specific example, and FIG. 6 is an example of inventory quantity data after update by the inventory quantity update unit 102e in this specific example. It is a figure which shows. As shown in FIGS. 4 and 6, the inventory quantity data of this specific example includes items of product code (product identifier) A01, product name A02, and inventory quantity A03, and the information including these items is the first. It is registered by product without distinction between the product and the second product.

FIG. 5 is a diagram showing an example of inventory evaluation unit price data before update by the inventory evaluation unit price update unit 102f in this specific example, and FIG. 7 is a diagram showing inventory evaluation after update by the inventory evaluation unit price update unit 102f in this specific example. It is a figure which shows an example of unit price data. As shown in FIGS. 5 and 7, the inventory valuation unit price data of this specific example includes items of product code (product identifier) B01, product name B02, and inventory valuation unit price B03, and information including these items is included. It is registered by product without distinction between the first product and the second product.

First, the product integration instruction receiving unit 102a receives the processing number "ST00000001" from the input unit X11 and the processing date "2019/10/01" from the input unit X21 via the product integration instruction screen of FIG.

Next, the product integration instruction receiving unit 102a receives the product code "070320201" from the input unit X31 for the product (first product) via the product integration instruction screen of FIG.

When the product integration instruction receiving unit 102a receives the product code "070320201" from the input unit X31, the product name of the product corresponding to the product code "070320201" is registered in advance, and the correspondence between the product code and the product name is registered. Based on the master (not shown), "T-shirt" is displayed on the display unit X32, and the stock quantity thereof is displayed on the display unit X33 based on the information A4 having the product code "070320201" in the stock quantity data shown in FIG. "10,000" is displayed on the display unit X34, and the inventory valuation unit price is displayed on the display unit X34 as "1,500" (yen) based on the information B4 having the product code "070320201" in the inventory valuation unit price data shown in FIG. Is displayed.

Next, the product integration instruction receiving unit 102a receives the product code "070320001" from the input unit X41 for the first possession / accessory (second product) attached to the first product.

When the product integration instruction receiving unit 102a receives the product code "070320001" from the input unit X41, the product name of the product corresponding to the product code "070320001" is displayed on the display unit X42 based on the product master (not shown). "Tag" is displayed, and the stock quantity is displayed as "15,000" on the display unit X43 based on the information A1 having the product code "070320001" in the stock quantity data shown in FIG. 4, and the stock evaluation unit price is displayed. , "50" (yen) is displayed on the display unit X44 based on the information B1 having the product code "070320001" in the inventory valuation unit price data shown in FIG.

Next, the product integration instruction receiving unit 102a receives the target number (target quantity) "5,000" of the second product "tag" attached to the first product from the input unit X45.

The product integration instruction receiving unit 102a has the product code "070320002" from the input units of the second and third stages, as in the case of the second product "tag" (product code "070320001") in the first stage described above. And "070320003" are accepted, and for each, the product name "sticker" and "button" (based on the product master (not shown)), inventory quantity "20,000" and "10,000" (inventory quantity data in FIG. 4). (Based on information A2 and A3), inventory valuation unit price "120" (yen) and "100" (yen) (based on information B2 and B3 of inventory valuation unit price data in FIG. 5) are displayed, and the target number "5" is displayed. 000 "is accepted.

Up to this point, the first embodiment in which the product integration instruction receiving unit 102a individually receives the product code of each second product has been described, but instead, the "first" registered in advance in the product master (not shown). When the product integration instruction reception unit 102a receives the product code of the first product based on "a combination of one product and the second product attached to the first product", the product code and product name of all the second products , The inventory quantity, and the inventory evaluation unit price may be displayed respectively, and the second embodiment may be used in which the target number of each of the displayed second products is accepted. In the case of this specific example, one first product "T-shirt" (product code "070320201") and three second product "tags" (product code "tag") to be attached to the product master (not shown) are stored in advance. A combination of "070320001"), a "sticker" (product code "070320002") and a "button" (product code "070320003") is registered.

When the product integration instruction receiving unit 102a receives the target number for all the second products, the inventory evaluation unit price updating unit 102f displays the updated inventory evaluation unit price (integrated inventory evaluation unit price) scheduled to be updated on the display unit X51. , Displays the unit price obtained by adding the total evaluation price of the second product per first product "T-shirt" to the inventory evaluation unit price "1,500" (yen) of the first product "T-shirt" at the present time. ..

The total evaluation price of the second product referred to here is the evaluation of all the second products obtained by summing up the evaluation prices of each of the second products obtained by adding the target number to the inventory evaluation unit price of the second product. Means price. The total evaluation price of the second product per one first product "T-shirt" is "135" (yen) as calculated from the following formula.

Total evaluation price of the second product per first product "T-shirt" = {50 (yen) (inventory evaluation unit price of the second product "tag") x 5,000 (number of items subject to the second product "tag") +120 (yen) (stock evaluation unit price of the second product "sticker") x 5,000 (number of targets for the second product "sticker"} +100 (yen) (inventory evaluation unit price of the second product "button") x 5, 000 (number of items targeted for the second product "button")} / 10,000 (stock quantity of the first product "T-shirt")

Therefore, the product integration instruction receiving unit 102a displays the inventory evaluation unit price "1,500" (yen) of the first product "T-shirt" at the present time on the display unit X51 of the inventory evaluation unit price after integration, and the first product "T-shirt". The unit price "1,635" (yen) obtained by adding the total evaluation price "135" (yen) of the second product per piece is displayed.

Next, the product integration instruction receiving unit 102a receives that the product is designated and the target quantity is confirmed via the confirmation button X61 (S01).

The inventory quantity update unit 102e receives information on the second product "tag" registered in the inventory quantity data shown in FIG. 4 after the product integration instruction reception unit 102a receives that the product designation and the target quantity are confirmed. As shown in FIG. 6, the inventory quantity “15,000” in A1 is updated to the quantity “10,000” obtained by subtracting the target quantity “5,000” from the inventory quantity, and at the same time, in FIG. The inventory quantity "20,000" in the information A2 of the second product "sticker" registered in the indicated inventory quantity data is subtracted from the inventory quantity "5,000" as shown in FIG. The quantity "15,000" obtained is updated, and at the same time, the inventory quantity "10,000" in the information A3 of the second product "button" registered in the inventory quantity data shown in FIG. 4 is shown in FIG. As shown, the inventory quantity is updated to the quantity "5,000" obtained by subtracting the target quantity "5,000" (S02).

The inventory valuation unit price update unit 102f receives the product integration instruction reception unit 102a to confirm the product designation and the target quantity, and then the first product "T-shirt" registered in the inventory valuation unit price data shown in FIG. As shown in FIG. 7, the inventory valuation unit price "1,500" (yen) in the information B1 is added to the inventory valuation unit price as the second product total valuation price "135" per one first product "T-shirt". ”(Yen) is added to the unit price“ 1,635 ”(yen), which is updated (S03).

By using the above system, the inventory of the second product (accessory) can be managed as a product in the same way as the first product (main product), and at the same time, the cost of the second product (accessory) can be set as the first product. It can be included in the cost of (main product). Therefore, it is possible to reduce the work mistake of the operator and the load on the operator.

Although the embodiments of the present invention have been described so far, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments. Is.

For example, among the processes described in the above-described embodiment, all or part of the processes described as being automatically performed can be manually performed, or the processes described as being manually performed. It is also possible to automatically perform all or part of the above by a known method.

In addition, processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each processing, screen examples, and database configurations shown in the above documents and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the PC 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in each device constituting the PC 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and is recorded in each apparatus as necessary. It is read mechanically. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and constitutes a control unit in cooperation with a CPU.

Further, this computer program may be stored in an application program server connected to the PC 100 via an arbitrary network, and it is also possible to download all or a part thereof as needed.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as the program first product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Program Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Protocol Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as multiple modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. It should be noted that well-known configurations and procedures can be used for specific configurations and reading procedures for reading the recording medium in each apparatus shown in the embodiment, installation procedures after reading, and the like.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the PC 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the PC 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the PC 100.

Furthermore, the specific form of distribution / integration of the device is not limited to that shown in the figure, and all or part of the device may be functionally or physically in any unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is useful for accounting operations in various industries such as the product sales industry, which manages accessories such as tags, stickers, and wrapping paper at the same time as the main product.

100 PC
102 Control unit 102a Product integration instruction reception unit 102b Purchase reception unit 102c Sales reception unit 102d Inventory inquiry reception unit 102e Inventory quantity update unit 102f Inventory evaluation unit price update unit 102g Inventory inquiry unit 104 Communication interface unit 106 Storage unit 106a Inventory quantity data storage Unit 106b Inventory evaluation unit price data storage unit 106c Product master storage unit 108 Input / output interface unit 200 Server 300 Network 400 Input device 500 Output device

Claims (6)

It is a product inventory management device equipped with a control unit.
The control unit
(1) Designation of the first product, designation of one or more types of second products to be attached to the designated first product, and attachment to the designated first product for each of the designated second products. Accept the target quantity to be made, or (2) specify the first product and specify each of the designated second products registered in the product master in advance as the second product attached to the designated first product. The target quantity to be attached to the first product, the product integration instruction receiving means for receiving, and
For each of the designated second products received by the product integration instruction receiving means or registered in the product master, the inventory quantity of the designated second product registered in the inventory quantity data is designated from the inventory quantity. An inventory quantity update means for updating to the quantity obtained by subtracting the target quantity, and
For the designated first product received by the product integration instruction receiving means, the inventory valuation unit price of the designated first product registered in the inventory valuation unit price data is set as the inventory valuation unit price of one of the first products. Inventory valuation unit price update means to update to the unit price obtained by adding the total valuation price of the second product per
Equipped with
Evaluation of each of the designated second products obtained by integrating the designated target quantity into the stock valuation unit price of the designated second product registered in the inventory valuation unit price data. It is an evaluation price for all the designated second products obtained by summing all the prices.
A product inventory management device characterized by this. The control unit
An inventory inquiry receiving means that accepts the designation of the first product or the second product for inventory inquiry,
With respect to the designated first product or the second product received by the inventory inquiry receiving means, an inventory inquiry means for outputting the stock quantity of the designated first product or the second product registered in the inventory quantity data. ,
The product inventory management device according to claim 1, further comprising. The control unit
Further provided with a purchase receiving means for accepting the designation of the purchased first product or the second product and the quantity of the purchased first product or the second product.
The inventory quantity update means
With respect to the designated first product or the second product received by the purchase receiving means, the inventory quantity of the designated first product or the second product registered in the inventory quantity data is purchased in the inventory quantity. The quantity is updated to the quantity obtained by adding the quantity of the first product or the quantity of the second product.
The product inventory management device according to claim 1 or 2. The control unit
Further provided with a sales receiving means for accepting the designation of the first product or the second product sold and the quantity of the first product or the second product sold.
The inventory quantity update means
With respect to the designated first product or the second product received by the sales receiving means, the inventory quantity of the designated first product or the second product registered in the inventory quantity data is sold from the inventory quantity. Update to the quantity obtained by subtracting the quantity of the first product or the second product.
The product inventory management device according to any one of claims 1 to 3, wherein the product inventory management device is characterized by the above. It is a product inventory management method executed in a product inventory management device provided with a control unit.
Executed by the control unit,
(1) Designation of the first product, designation of one or more types of second products to be attached to the designated first product, and attachment to the designated first product for each of the designated second products. Accept the target quantity to be made, or (2) specify the first product and specify each of the designated second products registered in the product master in advance as the second product attached to the designated first product. The target quantity to be attached to the first product, the product integration instruction reception step that accepts, and
For each of the designated second products received by the product integration instruction receiving step or registered in the product master, the inventory quantity of the designated second product registered in the inventory quantity data is designated from the inventory quantity. The inventory quantity update step to be updated to the quantity obtained by subtracting the target quantity, and
For the designated first product received by the product integration instruction receiving step, the inventory valuation unit price of the designated first product registered in the inventory valuation unit price data is set as the inventory valuation unit price of one of the first products. The inventory valuation unit price update step to be updated to the unit price obtained by adding the total valuation price of the second product per
Including
Evaluation of each of the designated second products obtained by integrating the designated target quantity into the stock valuation unit price of the designated second product registered in the inventory valuation unit price data. It is an evaluation price for all the designated second products obtained by summing all the prices.
A product inventory management method characterized by that. It is a product inventory management program to be executed by a product inventory management device equipped with a control unit.
To make the control unit execute
(1) Designation of the first product, designation of one or more types of second products to be attached to the designated first product, and attachment to the designated first product for each of the designated second products. Accept the target quantity to be made, or (2) specify the first product and specify each of the designated second products registered in the product master in advance as the second product attached to the designated first product. The target quantity to be attached to the first product, the product integration instruction reception step that accepts, and
For each of the designated second products received by the product integration instruction receiving step or registered in the product master, the inventory quantity of the designated second product registered in the inventory quantity data is designated from the inventory quantity. The inventory quantity update step to be updated to the quantity obtained by subtracting the target quantity, and
For the designated first product received by the product integration instruction receiving step, the inventory valuation unit price of the designated first product registered in the inventory valuation unit price data is set as the inventory valuation unit price of one of the first products. The inventory valuation unit price update step to be updated to the unit price obtained by adding the total valuation price of the second product per
Including
Evaluation of each of the designated second products obtained by integrating the designated target quantity into the stock valuation unit price of the designated second product registered in the inventory valuation unit price data. It is an evaluation price for all the designated second products obtained by summing all the prices.
A product inventory management program that features that.

Images