Product management device, product management method, and product management program

Abstract

This invention provides a product management device, a product management method, and a product management program capable of evaluating the inventory of ordered products. [Solution] The product management device according to this embodiment is a product management device equipped with a control unit, which is capable of accessing order data, order data, and delivery date response data, and the control unit is characterized by comprising: a product unit price master registration unit that creates a product unit price master that stores the purchase unit price and standard cost unit price obtained from the delivery date response data; a delivery record registration unit that creates delivery record data after the delivery of the ordered products; a purchase data registration unit that creates purchase data for the ordered products; and an inventory valuation unit price data registration unit that obtains an inventory valuation unit price calculation category from the product master, calculates an inventory valuation unit price according to the obtained inventory valuation unit price calculation category, and registers it as inventory valuation unit price data.

Description

Technical Field

[0001] The present invention relates to a product management device, a product management method, and a product management program.

Background Art

[0002] Custom-order products such as medical wigs need to be managed separately for each order, and the necessity of asset management varies depending on the product attribute of whether it is a purchased product or a contracted product. In the case of purchased products, asset management is necessary, while in the case of contracted products, it is treated as a sample due to the contract with the advertising model, so asset management is not required. The necessity of asset management can be achieved by creating a product master for each order, but registering order information each time an order is placed is very laborious and burdensome to the business.

[0003] Patent Document 1 discloses a custom-order product configuration management device including a storage unit and a control unit. The storage unit includes a prototype master that associates products subject to semi-custom orders and semi-custom order items for each of the products as a template, and a configuration master that sets the delivery quantity of components including the semi-custom order items that make up the product. The control unit includes an order input acquisition means for acquiring order input data in which an ordered product and ordered items are set, a record acquisition means for acquiring an order product record in which the ordered product is set as a product subject to semi-custom order and the ordered items are set as semi-custom order items based on the order input data and the prototype master, and a required quantity calculation means for calculating the required quantity of the components for the ordered product based on the order product record and the configuration master (see, for example, Patent Document 1).

Prior Art Documents

Patent Documents

[0004]

Patent Document 1

Summary of the Invention

[0005] Patent Document 1 does not involve setting inventory valuation unit price calculation categories based on whether ordered goods are purchased goods or contracted goods, performing inventory valuation, or managing assets.

[0006] The present invention has been made in view of the above, and aims to provide a product management device, a product management method, and a product management program that can automatically register a product master that stores product attributes and inventory valuation unit price calculation categories based on ordered product data, and perform inventory valuation after registering the purchase data of ordered products. [Means for solving the problem]

[0007] To solve the above-mentioned problems and achieve the objective, the present invention provides a product management device equipped with a control unit, which is capable of accessing order data created from the order data and delivery response data including the delivery date and purchase price of the ordered goods, and the control unit is equipped with a product price master that stores, for each product, order data created from the order data and delivery response data including the delivery date and purchase price of the ordered goods, and the control unit is equipped with a product price master registration unit that creates a product price master that stores the purchase price and standard cost price obtained from the delivery response data, a delivery record registration unit that creates delivery record data after the ordered goods have been received, a purchase data registration unit that creates purchase data for the ordered goods, and an inventory valuation unit price data registration unit that obtains the inventory valuation unit price from the product master, calculates the inventory valuation unit price according to the obtained inventory valuation unit price calculation unit, and registers it as inventory valuation unit price data.

[0008] Furthermore, the present invention relates to a product management method that is executed by a product management device equipped with a control unit, and is characterized by including a product master that stores for each product order information, product attribute classifications indicating whether the product is purchased or contracted, obtained from the order data, and inventory valuation unit price calculation classifications, and is able to access order data created from the order data and delivery response data including responses from suppliers regarding the delivery date and purchase price of the ordered products, and is executed by the control unit to create a product unit price master that stores the purchase unit price and standard cost unit price obtained from the delivery response data, a delivery record registration step that creates delivery record data after the delivery of the ordered products, a purchase data registration step that creates purchase data for the ordered products, and an inventory valuation unit price data registration step that obtains the inventory valuation unit price calculation classification from the product master, calculates the inventory valuation unit price according to the obtained inventory valuation unit price calculation classification, and registers it as inventory valuation unit price data.

[0009] Furthermore, the product management program of the present invention is a product management program to be executed by a product management device equipped with a control unit, and is characterized in that it can access order data created from the order data and delivery response data including the delivery date and purchase price of the ordered goods, and causes the control unit to execute a product unit price master registration step to create a product unit price master that stores the purchase price and standard cost price obtained from the delivery response data, a delivery record registration step to create delivery record data after the delivery of the ordered goods, a purchase data registration step to create purchase data for the ordered goods, and an inventory valuation unit price data registration step to obtain the inventory valuation unit price data from the product master, calculate the inventory valuation unit price according to the obtained inventory valuation unit price calculation category and register it as inventory valuation unit price data. [Effects of the Invention]

[0010] According to the present invention, a product master containing product attributes and inventory valuation unit price calculation categories can be automatically registered, and inventory valuation can be performed after the purchase data of ordered items is registered. [Brief explanation of the drawing]

[0011] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of a product management device. [Figure 2] Figure 2 shows an example of order data for custom-made products. [Figure 3] Figure 3 shows an example of a product master. [Figure 4] Figure 4 shows an example of order header data and order detail data. [Figure 5] Figure 5 shows an example of delivery date response data. [Figure 6] Figure 6 shows an example of a product unit price master. [Figure 7] Figure 7 shows an example of incoming shipment data. [Figure 8] Figure 8 shows an example of procurement data. [Figure 9] Figure 9 illustrates the creation of inventory valuation unit price data. [Modes for carrying out the invention]

[0012] Embodiments of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to these embodiments.

[0013] [1. Structure] Referring to Figure 1, an example of the configuration of the product management device 100 according to this embodiment will be described. Figure 1 is a block diagram showing an example of the configuration of the product management device 100.

[0014] The merchandise management device 100 is a commercially available desktop personal computer. Note that the merchandise management device 100 is not limited to a stationary information processing system such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

[0015] The merchandise management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the merchandise management device 100 is communicably connected via an arbitrary communication path.

[0016] The communication interface unit 104 communicably connects the merchandise management device 100 to the network 300 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 other devices via a communication line. Here, the network 300 has a function of communicably connecting the merchandise management device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).

[0017] An input device 400 and an output device 500 are connected to the input / output interface unit 108. As the output device 500, in addition to a monitor (including a household television), a speaker or a printer can be used. As the input device 400, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, there are cases where the output device 500 is described as the monitor 500, and the input device 400 is described as the keyboard 400 or the mouse 400. Also, displaying information on the monitor 500 and the user operating the input device 400, etc. may be described as "user operation via the UI".

[0018] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving instructions to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes. 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, etc. can be used.

[0019] The storage unit 106 stores, for example, ordered item order data 106a, product master 106b, order data 106c, delivery date response data 106d, product unit price master 106e, incoming goods actual performance data 106f, purchasing data 106g, inventory evaluation unit price data 106h, etc.

[0020] The ordered item order data 106a is order information for ordered items and is, for example, data input from a store POS system. In the ordered item order data 106a, as shown by an example in FIG. 2, order number, order date, scheduled installation date, store code, store name, supplier code, supplier name, warehouse code, warehouse name, product code, product name, customer number, product number, order quantity, order main body price, product attributes are stored. Here, the product code is a code uniquely determined for each product, and "0" of the product attribute is a purchased item and "1" is a contracted item.

[0021] The product master 106b stores the product attribute classification and the inventory evaluation unit price calculation classification for each product. In the product master 106b, as shown by an example in FIG. 3, product code, product name, product attribute classification, inventory evaluation unit price calculation classification are stored. The inventory evaluation unit price calculation classification is determined by the product attribute classification and is used when calculating the unit price of inventory in the cost calculation process of the product.

[0022] Order data 106c consists of order header data 106c-1 and order detail data 106c-2. It stores the inspection results of manufactured products. As shown in an example in Figure 4, order header data 106c-1 stores order number, order date, expected arrival date, store code, store name, supplier code, supplier name, warehouse code, warehouse name, and order number, while order detail data 106c-2 stores order number, order line number, product code, product name, order quantity, order base price, and order unit price consumption tax amount.

[0023] Delivery date response data 106d is response data from the supplier (the factory that received the order) regarding the delivery date and purchase price of the ordered goods. As shown in Figure 5 as an example, delivery date response data 106d stores the order number, warehouse code, warehouse name, product code, customer number, product number, order quantity, expected arrival date, and price.

[0024] The product unit price master 106e stores the purchase unit price and standard cost unit price obtained from the delivery date response data 106d. As shown in an example in Figure 6, the product unit price master 106e stores the product code, product name, effective start date, purchase unit price, and standard cost unit price.

[0025] The receiving record data 106f stores information regarding the arrival of ordered goods. The receiving record data 106f is created based on the order data 106c and the delivery date response data 106d, and as shown in an example in Figure 7, it stores the document number, order number, warehouse code, warehouse name, product code, quantity received, and arrival date.

[0026] Purchase data 106g consists of purchase header data 106g-1 and purchase detail data 106g-2. Purchase data 106g is created based on order data 106c, product unit price master 106e, and actual receipt data 106f. As shown in Figure 8 as an example, purchase header data 106g-1 stores purchase number, receipt date, purchase date, store code, store name, supplier code, supplier name, warehouse code, warehouse name, purchase price, and purchase consumption tax amount, while purchase detail data 106g-2 stores purchase number, purchase line number, product code, product name, purchase quantity, purchase price, and purchase price consumption tax amount.

[0027] Inventory valuation unit price data 106h contains data related to the inventory valuation unit price of ordered items. As shown in Figure 9 as an example, inventory valuation unit price data 106h stores the product code, product name, and inventory valuation unit price.

[0028] The control unit 102 is a CPU or similar component that comprehensively controls the product management device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0029] Functionally, the control unit 102 includes a product master registration unit 102a, an order data registration unit 102b, a product unit price master registration unit 102c, a receiving performance data registration unit 102d, a purchase data registration unit e, an inventory valuation unit price data calculation unit 102f, and the like.

[0030] The product master registration unit 102a retrieves the product attributes of the ordered items from the ordered item data 106a, associates the inventory valuation unit price calculation category identified by the product attributes, and registers it in the product master 106b.

[0031] The order data registration unit 102b registers order data 106c based on the ordered product order data 106a.

[0032] The product unit price master registration unit 102c creates a product unit price master 106e that stores the purchase unit price and standard cost unit price obtained from the delivery date response data 106d.

[0033] The receiving record data registration unit 102d creates receiving record data 106f after the ordered items have arrived at the warehouse.

[0034] The procurement data registration unit 102e creates procurement data 106g based on the order data 106c, the product unit price master 106e, and the actual receipt data 106f.

[0035] The inventory valuation unit price data calculation unit 102f obtains the inventory valuation unit price calculation category from the product master 106b, calculates the inventory valuation unit price according to the obtained inventory valuation unit price calculation category, and registers it as inventory valuation unit price data 106h.

[0036] [2. Processing] Here, specific examples of processes performed by the product management device 100 will be explained with reference to Figures 2 to 9.

[0037] In stores handling apparel or medical products, when an order for a custom-made item is received in-store, the order details are entered into the store's POS system. At that time, customer information and product attributes (purchased item or contracted item) are also registered, and the custom-made item order data 106a shown in Figure 2 is registered.

[0038] After the registration of the order data 106a, the product master 106b and order data 106c are created. When the product master 106b is created, product codes are automatically assigned, and product attributes and inventory valuation unit price calculation categories are linked and stored for each product. In the product master 106b in Figure 3, the men's custom-made wig with product code "PO0000000001" is registered as "0 (purchased item)", and the advertising custom-made wig with product code "PO0000000002" is registered as "1 (contracted item)". In addition, "1 (monthly total average)" is entered as the inventory valuation unit price calculation category for "0 (purchased item)", and "2 (standard cost unit price)" is entered as the inventory valuation unit price calculation category for "1 (contracted item)". For ordered items, inventory levels are managed at the end of each month for both purchased and contracted items. For purchased items, the valuation amount is calculated using the monthly weighted average based on the purchase price. For contracted items, a standard cost unit price (0 yen) is set so that no inventory value is calculated.

[0039] Order data 106c is automatically assigned an order number and is created based on the ordered product order data 106a.

[0040] When the order data 106c is sent to the factory that received the order, the factory sends delivery date response data 106d, which includes the expected arrival date at the warehouse and the purchase price, to the product management device 100.

[0041] After receiving the delivery date response data 106d, a product unit price master 106e is created. The purchase unit price stored in the product unit price master 106e is not the unit price in the order data, but the amount from the delivery date response data 106d. In addition, the product unit price master 106e stores the standard cost unit price of the product, and the standard cost unit price stored is "0" for all products.

[0042] After the ordered items arrive at the warehouse, the arrival record data 106f for the ordered items is created. The arrival date in the arrival record data 106f is the date the ordered items arrived at the warehouse.

[0043] Additionally, purchase data 106g is created to record the purchase. Purchase data 106g is automatically assigned a purchase number and is created based on order data 106c, product unit price master 106e, and actual receipt data 106f. The unit price of the purchase in purchase data 106g uses the unit price of the purchase stored in product unit price master 106e.

[0044] At the end of the month, inventory valuation of ordered items is performed. For purchased items, the monthly weighted average stored in the inventory valuation unit price calculation section of product master 106b is used for calculation, and for contracted items, the standard cost unit price in product unit price master 106e is used. The standard cost unit price for the contracted item, advertising order wig with product code "PO0000000002", is "0" yen in product unit price master 106e, so the inventory valuation unit price for the advertising order wig with product code "PO0000000002" is "0" yen.

[0045] The monthly average inventory valuation cost is calculated using the following formula. Please note that, due to the nature of custom-made items, each item is a one-of-a-kind purchase, and therefore the purchase price of the custom-made item will be used as the inventory valuation unit price for the current month. Inventory valuation cost = Purchase amount for the current month / Number of items purchased for the current month = (Current month's purchase unit price × current month's purchase quantity) / current month's purchase quantity = (Purchase price per ordered item × Number of ordered items purchased) / Number of ordered items purchased = 80,000 (yen) × 1 (point) / 1 (point) = 80,000 (yen)

[0046] According to the product management device 100 of this embodiment, a product master is automatically registered, linking the inventory valuation unit price calculation category to the product attributes stored in the order data. By calculating the inventory valuation unit price based on the inventory valuation unit price calculation category, asset management becomes easier. Furthermore, since purchase data with updated purchase unit prices is automatically registered based on delivery date response data from suppliers, the workload is reduced and input errors can be suppressed.

[0047] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions by companies, thereby contributing to SDGs Goals 8 and 9.

[0048] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and digital processes, thereby contributing to SDGs Goals 12, 13, and 15.

[0049] Furthermore, this embodiment can contribute to strengthening control and governance, thereby enabling contributions to SDG Goal 16.

[0050] [4. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

[0051] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.

[0052] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0053] Furthermore, with respect to the product management device 100, each component shown in the illustration is a functional concept and does not necessarily have to be physically configured as shown.

[0054] For example, the processing functions of the product management device 100, particularly those performed in the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processing described in this embodiment, and is mechanically read by the product management device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) stores a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0055] Furthermore, this computer program may be stored on an application program server connected to the product management device 100 via any network, and it is possible to download all or part of it as needed.

[0056] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0057] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0058] The various databases stored in the memory unit are storage means such as RAM, ROM, other memory devices, hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0059] Furthermore, the product management device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the product management device 100 may be implemented by installing software (including programs or data, etc.) on the device that enables the processing described in this embodiment.

[0060] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the illustration, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]

[0061] This invention is useful for companies that handle custom-made products such as apparel and medical products, and for companies where products for sale and products for advertising and promotion are generated within the same commercial flow. [Explanation of Symbols]

[0062] 100 Product management device 102 Control Unit 102a Product Master Registration Section 102b Order Data Registration Section 102c Product Unit Price Master Registration Section 102d Inventory Record Data Registration Department 102e Purchase Data Registration Department 102f Inventory Valuation Unit Price Data Calculation Unit 104 Communication Interface Section 106 Storage section 106a Order Data for Custom-Made Items 106b Product Master 106c Order Data 106d Delivery date response data 106e Product Unit Price Master 106f Inventory Data 106g Purchase Data 106h Inventory Valuation Unit Price Data 108 Input / Output Interface Section 200 servers 300 Networks 400 Input Devices 500 Output Device

Claims

1. A product management device equipped with a control unit, Order data for custom-made items, which is order information for custom-made items, A product master that stores, for each product, a product attribute classification indicating whether it is a purchased item or a contracted item obtained from the aforementioned order data, and an inventory valuation unit price calculation classification, Order data created from the aforementioned order data, Delivery date response data including the response from the supplier regarding the delivery date and purchase price of the aforementioned ordered items, Accessible, The control unit, A product unit price master registration unit creates a product unit price master that stores the purchase unit price and standard cost unit price obtained from the delivery date response data, After the aforementioned ordered items arrive, the system includes an arrival record registration unit that creates arrival record data, A purchase data registration unit that creates purchase data for the aforementioned ordered items, An inventory valuation unit price data registration unit obtains the inventory valuation unit price calculation category from the aforementioned product master, calculates the inventory valuation unit price according to the obtained inventory valuation unit price calculation category, and registers it as inventory valuation unit price data. A product management device characterized by being equipped with the following features.

2. The aforementioned inventory valuation unit cost calculation category is either the monthly weighted average, which is the calculation category for purchased goods, or the standard cost unit price for contracted goods. The product management device according to feature 1.

3. The aforementioned product master is automatically created and registered based on the aforementioned order data. The product management device according to feature 1.

4. A product management method to be executed by a product management device equipped with a control unit, Order data for custom-made items, which is order information for custom-made items, A product master that stores, for each product, a product attribute classification indicating whether it is a purchased item or a contracted item obtained from the aforementioned order data, and an inventory valuation unit price calculation classification, Order data created from the aforementioned order data, Delivery date response data including the response from the supplier regarding the delivery date and purchase price of the aforementioned ordered items, Accessible, To be executed by the control unit, A product unit price master registration step creates a product unit price master that stores the purchase unit price and standard cost unit price obtained from the delivery date response data, After the aforementioned ordered items arrive, a step is taken to register the arrival record, which creates arrival record data. A purchase data registration step to create purchase data for the aforementioned ordered items, The inventory valuation unit price calculation category is obtained from the aforementioned product master, the inventory valuation unit price is calculated according to the obtained inventory valuation unit price calculation category, and the inventory valuation unit price data is registered in the inventory valuation unit price data registration step. A product management method characterized by including the following.

5. A product management program to be executed by a product management device equipped with a control unit, Order data for custom-made items, which is order information for custom-made items, A product master that stores, for each product, a product attribute classification indicating whether it is a purchased item or a contracted item obtained from the aforementioned order data, and an inventory valuation unit price calculation classification, Order data created from the aforementioned order data, Delivery date response data including the response from the supplier regarding the delivery date and purchase price of the aforementioned ordered items, Accessible, The control unit, A product unit price master registration step creates a product unit price master that stores the purchase unit price and standard cost unit price obtained from the delivery date response data, After the aforementioned ordered items arrive, a step is taken to register the arrival record, which creates arrival record data. A purchase data registration step to create purchase data for the aforementioned ordered items, The inventory valuation unit price calculation category is obtained from the aforementioned product master, the inventory valuation unit price is calculated according to the obtained inventory valuation unit price calculation category, and the inventory valuation unit price data is registered in the inventory valuation unit price data registration step. A product management program characterized by its ability to execute certain actions.

Images