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

Abstract

To provide a product management device, a product management method, and a product management program that can manage new and old products and register an internal code for defining identical products in a product master for product management. [Solution] The product management device according to this embodiment includes a product master in which a product code, an internal code for defining the same product, and a supplier code are registered in association with each other, a numbering master in which a supplier code and a numbered number are registered in association with each other, and a master maintenance means for updating the product master and the numbering master based on product data including the fields for product code, supplier code, and old product code.

Description

Technical Field

[0004] ,

[0006] , , , ,

[0005] , , , , ,

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

Background Art

[0002] For example, in a company engaged in the wholesale business of products, in the order receiving business, when receiving an order for a new product with only the package of an old product changed, if there is no stock of the new product and there is stock of the old product, the old product is shipped.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, conventionally, there has been no code that can manage new and old products (for example, the products have the same content but different packages), so the proper management of new and old products has been insufficient.

[0005] The present invention has been made in view of the above, and an object thereof is to provide a product management device, a product management method, and a product management program capable of managing new and old products and registering an internal code for defining the same product in a product master for managing products.

Means for Solving the Problems

[0006] To solve the above-mentioned problems and achieve the objective, a product management device equipped with a control unit is provided, wherein the control unit is configured to access a product master in which a product code, an internal code for defining the same product, and a supplier code are registered in association with each other, a numbering master in which a supplier code and a numbered number are registered in association with each other, and product data including items for product code, supplier code, and old product code, and is equipped with master maintenance means for updating the product master and the numbering master based on the product data.

[0007] Furthermore, according to one aspect of the present invention, the master maintenance means may, if the supplier code of the product data is not registered in the numbering master, add a record of the supplier code and the newly assigned numbered number to the numbering master, and add a record of the product code of the product data, the newly assigned numbered number, the internal code generated based on the supplier code, and the supplier code to the product master; if the supplier code of the product data is registered in the numbering master and the old product code is not registered in the product data, update the assigned number of the supplier code in the numbering master, and add a record of the product code, the updated assigned number, the internal code assigned based on the supplier code, and the supplier code to the product master; and if the old product code is registered in the product data, obtain the internal code and supplier code associated with the old product code from the product master, and add a record of the product code, the obtained internal code, and the supplier code to the product master.

[0008] Furthermore, according to one aspect of the present invention, the product code may be a sales packaging unit code.

[0009] Furthermore, according to one aspect of the present invention, the control unit is further configured to access inventory, including product code, internal code, supplier code, expiration date, current stock quantity, and available quantity, and order data, including order number, order date, line number, product code, product name, order quantity, sales price, and sales amount. The control unit may also be provided with inventory processing means that, with respect to the inventory data, allocates the order quantity of the order data in order from the oldest product's inventory, among the products with the product code of the order data and products having the same internal code as the internal code of the product in question.

[0010] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention provides a product management method executed by an information processing device equipped with a control unit, wherein the control unit is configured to access a product master registered by associating a product code, an internal code for defining the same product, and a supplier code; a numbering master registered by associating a supplier code and a numbered number; and product data including items for product code, supplier code, and old product code, and the method includes a master maintenance step executed by the control unit to update the product master and the numbering master based on the product data.

[0011] Furthermore, in order to solve the above-mentioned problems and achieve the objectives, the present invention is a product management program to be executed by an information processing device equipped with a control unit, wherein the control unit is configured to be able to access a product master in which a product code, an internal code for defining the same product, and a supplier code are registered in association with each other, a numbering master in which a supplier code and a numbered number are registered in association with each other, and product data including items for product code, supplier code, and old product code, and the product management program is characterized in that it causes the control unit to execute a master maintenance process to update the product master and the numbering master based on the product data. [Effects of the Invention]

[0012] According to the present invention, it is possible to manage new and old products and register an internal code for defining identical products in a product master for managing products. [Brief explanation of the drawing]

[0013] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of the product management device according to this embodiment. [Figure 2] Figure 2 shows an example of the structure of a product master. [Figure 3] Figure 3 shows an example of a numbering master configuration. [Figure 4] Figure 4 is a diagram illustrating a specific example of the processing performed by the control unit of the product management device according to this embodiment. [Figure 5] Figure 5 is a diagram illustrating a specific example of the processing performed by the control unit of the product management device according to this embodiment. [Figure 6] Figure 6 is a diagram illustrating a specific example of the processing performed by the control unit of the product management device according to this embodiment. [Figure 7] Figure 7 is a diagram illustrating a specific example of the processing performed by the control unit of the product management device according to this embodiment. [Modes for carrying out the invention]

[0014] Embodiments of the product management device, product management method, and product management program according to the present invention will be described in detail below with reference to the drawings. However, the present invention is not limited to these embodiments.

[0015] [1. Overview] For example, a company engaged in the pharmaceutical distribution business daily links information on pharmaceutical products with the system (external system) of a pharmaceutical information service company (e.g., Medicode Co., Ltd.) that provides pharmaceutical information. In the operation of a company engaged in the pharmaceutical distribution business, in the case of receiving an order for a new product (ex. only the package is changed) during the order receiving process, when there is no inventory of the new product but there is inventory of the old product, the old product is shipped. However, regarding the handled pharmaceutical products linked from the pharmaceutical information service company (e.g., Medicode Co., Ltd.), there is no code that can manage new and old products (the products inside are the same but the packages are different), so it is necessary to hold an "internal code" for each product for the management of new and old products.

[0016] In the present invention, when importing product data from a pharmaceutical manufacturer, based on the supplier code (the code for managing the pharmaceutical manufacturer), for each pharmaceutical product, new and old products are managed, and an internal code that defines the identity of the product is automatically numbered and registered in the product master. By using this product master to manage the inventory and shipping of new and old products, appropriate management of new and old products becomes possible.

[0017] Also, in the present invention, when creating shipping instruction data, regarding the inventory reservation of inventory data, usually only the inventory reservation of the target product is carried out, but the inventory reservation is carried out based on the numbered internal code. Specifically, for the number of orders received, referring to the internal code of the target product, the inventory reservation of the oldest old product is carried out starting from the expiration date. As a result, it becomes possible to reduce excess inventory, grasp the inventory available for shipping, and suppress unnecessary orders.

[0018] In the following description, the case where the product management device of the present invention is applied to a company engaged in the pharmaceutical distribution business will be described, but the present invention is not limited to this, and it is also applicable to other industries such as the food industry.

[0019] [2. Configuration] An example of the configuration of the product management device 100 according to this embodiment will be described with reference to FIG. 1. FIG. 1 is a block diagram showing an example of the configuration of the product management device 100. Hereinafter, a case where the product management device 100 according to this embodiment is applied to a company engaged in the pharmaceutical wholesaling business will be described as an example.

[0020] The product management device 100 is a commercially available desktop personal computer. Note that the product management device 100 is not limited to a stationary information processing device 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.

[0021] The product 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 product management device 100 is communicably connected via an arbitrary communication path.

[0022] The communication interface unit 104 communicably connects the product 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 enabling mutual communication between the product management device 100 and the server 200, a system (not shown) of a pharmaceutical information providing service company (for example, Medicode Co., Ltd.), a system (not shown) of a customer, a system (not shown) of a pharmaceutical manufacturer, etc., and is, for example, the Internet or a LAN (Local Area Network). Note that data such as various masters described later may be stored in the server 200, for example.

[0023] The input / output interface unit 108 is connected to an input device 112 and an output device 114. The output device 114 can be a monitor (including a home television), a speaker, or a printer. The input device 112 can be a keyboard, mouse, microphone, or a monitor that works in conjunction with a mouse to provide pointing device functionality. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or mouse 112.

[0024] The memory unit 106 stores various databases, tables, and files. The memory unit 106 also stores computer programs that work in cooperation with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. As the memory unit 106, for example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used.

[0025] The storage unit 106 stores the product master 106a, the numbering master 106b, product data, inventory data, order data, etc. Figure 2 shows an example of the configuration of the product master 106a. Figure 3 shows an example of the configuration of the numbering master 106b.

[0026] As shown in Figure 2, the product master 106a can consist of tables that associate and register product codes, internal codes, and supplier codes. The product code is, for example, a sales packaging unit code. The internal code is a code used to manage new and old products and to define the same product. The supplier code is a code used to manage pharmaceutical manufacturers.

[0027] As shown in Figure 3, the numbering master 106b can be composed of tables that associate and register supplier codes, assigned numbers, etc.

[0028] Product data may be obtained, for example, from a pharmaceutical manufacturer's system, and may include product codes, supplier codes, and old product codes.

[0029] Inventory data may include product code, internal code, supplier code, expiration date, current stock quantity, and available quantity. The internal code and supplier code are obtained from product master 106a using the product code as the key.

[0030] Order data may include order number, order date, line number, product code, product name, quantity, unit price, and total sales amount.

[0031] 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.

[0032] The control unit 102 is configured to access the product master 106a, numbering master 106b, product data, inventory data, order data, etc., which are stored in the storage unit 106. The product master 106a, numbering master 106b, product data, inventory data, order data, etc. may be stored in another location (for example, server 200), as long as the control unit 102 can access them.

[0033] Functionally, the control unit 102 comprises a master maintenance unit 102a, a product data acquisition unit 102b, an order processing unit 102c, an inventory processing unit 102d, and a screen display control unit 102e.

[0034] The product data acquisition unit 102b acquires product data from, for example, the system of a pharmaceutical information provision service company (for example, Medicode Co., Ltd.) and stores it in the storage unit 106.

[0035] The master maintenance unit 102a performs editing such as data input, addition, modification, and updating on the product master 106a and numbering master 106b in response to operator operations on a master maintenance screen (not shown) displayed on the monitor 114.

[0036] Furthermore, the master maintenance unit 102a updates the product master 106a and the numbering master 106b based on the product data stored in the storage unit 106.

[0037] Specifically, the master maintenance unit 102a (1) adds a record of the supplier code and the newly assigned number to the numbering master 106b if the supplier code of the product data is not registered in the numbering master 106b, and adds a record of the product code of the product data, the newly assigned number, the internal code generated based on the supplier code, and the supplier code to the product master 106a, and (2) if the supplier code of the product data is already registered in the numbering master 106b, the old product code in the product data If not registered, update the numbered number for the supplier code in the numbering master 106b, add a record to the product master 106a containing the product code, the updated numbered number, the internal code assigned based on the supplier code, and the supplier code. If the old product code is registered in the product data, retrieve the internal code and supplier code associated with the old product code in the product master 106a, and add a record to the product master 106a containing the product code, the retrieved internal code, and the supplier code.

[0038] The order processing unit 102c, for example, receives an order from the customer's system, inputs the order data, and stores it in the storage unit 106.

[0039] The inventory processing unit 102d generates and updates inventory data stored in the memory unit 106, updating the inventory data, for example, when goods are received or shipped.

[0040] Furthermore, the inventory processing unit 102d allocates the number of orders from the oldest inventory item among the items with the same internal code as the product code in the order data.

[0041] The screen display control unit 102e controls the display of various screens (for example, master maintenance screen, order entry screen, inventory entry screen, etc.) displayed on the monitor 114, and the acceptance of input on the screen.

[0042] [3. Specific examples of processing] A specific example of the processing of the control unit 102 of the product management device 100 according to this embodiment will be described with reference to Figures 1 to 7.

[0043] The following will explain the process in the order of [3-1. Updating the product master and numbering master] and [3-2. Inventory allocation process].

[0044] [3-1. Update process for product master and number master] Referring to Figures 4 and 5, the update process for the product master and numbering master will be explained. The master maintenance unit 102a updates the product master 106a and numbering master 106b based on product data obtained from the system of a pharmaceutical information provision service company (for example, Medicode Co., Ltd.). Here, the automatic numbering of internal codes for pharmaceuticals will be explained. The internal code is numbered using the supplier code (a code that manages pharmaceutical manufacturers) of the product data as the key. However, if an existing product is registered for the old product code, which is a retained item in the product data, the internal code of the old product will be inherited.

[0045] Figure 4(A) shows an example of the data in the product master 106a before the update. Figure 4(B) shows an example of the data in the numbering master 106b before the update. Figure 4(C) shows an example of the acquired product data. Figure 4(D) shows an example of the data in the product master 106a after the update. Figure 4(E) shows an example of the data in the numbering master 106b after the update. Figure 5 shows the processing flow of the product master and numbering master update process executed by the master maintenance unit 102a.

[0046] As shown in Figure 4(A), the product master 106a includes fields for product code, internal code, and supplier code. In the example shown in the figure, the first row contains product code "SHO2-00", internal code "MA000056", supplier code "MA", product code "SHO3-00", internal code "MU000260", and supplier code "MU".

[0047] As shown in Figure 4(B), the numbering master 106b includes fields for supplier code and assigned number. In the example shown in the figure, the first row contains supplier code "MA", assigned number "56", supplier code "MU", and assigned number "260".

[0048] As shown in Figure 4(C), the product data includes fields for product code, supplier code, and old product code. In the example shown in the figure, the first row (1) has product code "SHO1-00", supplier code "MX", and old product code "None", the second row (2) has product code "SHO2-01", supplier code "MA", and old product code "None", and the third row (3) has product code "SHO3-01", supplier code "MU", and old product code "SHO3-00".

[0049] The following section explains the update process for the product master and numbering master using the product data shown in Figure 4(C). The following section describes the following patterns for automatic numbering for the first row (1) to the third row (3) of the product data.

[0050] Line 1 (1): Since the supplier code is not set for the numbering master 106b, an internal code is automatically assigned. Second line (2): Since the old product does not exist for product master 106a, an internal code is automatically assigned from the supplier code. Line 3 (3): Since an old product exists for product master 106a, the internal code of the old product is inherited.

[0051] Referring to Figure 5, the processing flow for updating the product master and numbering master is explained. In Figure 5, it is determined whether the supplier code of the product data is already registered in the numbering master 106b (step S1). If the supplier code of the product data is not already registered in the numbering master 106b, a new supplier code is added to the numbering master 106b (step S2). Specifically, a record for the target supplier code is added to the numbering master 106b, and an available numbered number is set in ascending order to the numbered number. In the example of the first row (1) of the product data in Figure 4(C), a record for the target supplier code "MX" is added to the numbering master 106b, and the numbered number "1" is set.

[0052] Next, a new product code is added to product master 106a (step S3). A record for the target product code is added to product master 106a, and the internal code is set to "supplier code + assigned number from numbering master 106b (lead zero padding to make it 6 digits)". In the example of the first row (1) of the product data in Figure 4(C), a record for the target product code "SHO1-00" is added to product master 106b, and the internal code is set to "supplier code "MX" + assigned number from numbering master 106b (000001 (6 digits))" = "MX000001", and the supplier code "MX".

[0053] In step S1 above, if the supplier code of the product data is already registered in the numbering master 106b, it is determined whether or not the old product code is registered in the product data (step S4). If it is not registered, the numbered number is updated in the numbering master 106b (step S5). The record of the target supplier code in the numbering master 106b is updated by adding 1 to the numbered number. In the example of the second row (2) of the product data in Figure 4(C), the record of the supplier code "MA" in the numbering master 106b is updated to "57" by adding 1 to the numbered number "56".

[0054] Next, a new product code is added to product master 106a using an internal code based on the numbered number updated in step S5 (step S6). A record for the target product code is added to product master 106a, and the internal code is set to "supplier code + numbered number from numbering master 106b updated in S5 (lead zero padding to make it 6 digits)". In the example of the second row of product data in Figure 4(C), a record for the target product code "SHO2-01" is added to product master 106a, and the internal code is set to "supplier code "MA" + numbered number from numbering master 106b updated in S5 (000057 (6 digits))" = "MA000057", and supplier code "MA".

[0055] In step S4 above, if the old product code is registered in the product data, the existing internal code is used to add the new product code to the product master 106a (step S7). Specifically, a record for the target product code is added to the product master 106a, and the internal code is set to be the same as the internal code of the registered old product code. In the example of the third row (3) of the product data in Figure 4(C), a record for the target product code "SHO3-01" is added to the product master 106a, and the internal code is set to "MU000260", the same internal code as the product code "SHO3-00", and the supplier code is set to "MU".

[0056] As a result of the above process, the product master 106a is updated as shown in Figure 4(D), and the numbering master 106b is updated as shown in Figure 4(E).

[0057] [3-2. Inventory Allocation Process] The inventory allocation process will be explained with reference to Figures 6 and 7. The inventory processing unit 102d allocates inventory data from the oldest product among the products with the same internal code as the product code in the order data. In the inventory allocation process, the allocation is made from the oldest product among the products with the same internal code as the target product (a group of products with the same internal code).

[0058] Figure 6(A) shows an example of inventory data before updating. Figure 6(B) shows an example of order data. Figure 6(C) shows an example of inventory data after updating. Figure 7 shows the processing flow of the inventory allocation process executed by the inventory processing unit 102d.

[0059] As shown in Figure 6(A), the inventory data includes the following fields: product code, internal code, supplier code, expiration date, current inventory quantity, and available quantity. In the example shown in the figure, the first row contains the product code "SHO3-00", internal code "MU000260", supplier code "MU", expiration date "2024 / 9 / 7", current inventory quantity "150", and available quantity "150". The second row contains the product code "SHO3-00", internal code "MU000260", supplier code "MU", expiration date "2024 / 10 / 1", current inventory quantity "30", and available quantity "30". The third row contains the product code "SHO3-01", internal code "MU000260", supplier code "MU", expiration date "2024 / 10 / 7", current inventory quantity "100", and available quantity "100".

[0060] As shown in Figure 6(B), the order data includes the following fields: order number, order date, line number, product code, product name, quantity, unit price, and sales amount. In the example shown in the figure, the order number is "A0001", the order date is "6 / 11", the line number is "1", the product code is "SHO3-01", the product name is "Mukosta", the quantity is "200", the unit price is "11", and the sales amount is "2,200". The following explains how to allocate inventory using the order data shown in Figure 6(B).

[0061] Refer to Figure 7 to explain the inventory allocation process. In Figure 7, it is determined whether or not inventory exists in the inventory data for a product code that has the same internal code as the product code in the order data (step S11). If it does not exist, an allocation is made in the inventory data for the product code in the order data (step S12).

[0062] In step S11, if available, inventory is allocated from the inventory with the oldest expiration date within the inventory of the same internal code in the inventory data (step S13). If the inventory allocation is sufficient for the number of orders (step S14), the process ends. On the other hand, if the inventory allocation is not sufficient for the number of orders (step S15), then the allocation is made to the inventory of the next oldest product (step S16).

[0063] In the example order data shown in Figure 6(B), the product code is "SHO3-01" and the order quantity is "200". The internal code "MU000260" associated with product code "SHO3-01" also has product code "SHO3-00" in the inventory data, as shown in Figure 6(C). Therefore, for product codes "SHO3-00" and "SHO3-01", the current inventory of "150", "30", and "20" is allocated to the expiration dates in chronological order: "2024 / 9 / 7", "2024 / 10 / 1", and "2024 / 10 / 7", respectively, and the available allocation quantities are updated to "0", "0", and "80".

[0064] As described above, according to this embodiment, a product master 106a is registered by associating a product code, an internal code for defining the same product, and a supplier code; a numbering master 106b is registered by associating a supplier code and an assigned number; and a master maintenance unit 102a updates the product master 106a and the numbering master 106b based on product data including the product code, supplier code, and old product code. Therefore, it is possible to manage new and old products and register an internal code for defining the same product in the product master for managing products.

[0065] [4. 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.

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

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

[0068] [5. 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.

[0069] 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.

[0070] 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.

[0071] 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.

[0072] For example, the processing functions of the product management device 100, particularly those performed by the control unit 102, 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 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) contains 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.

[0073] 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.

[0074] 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.

[0075] 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.

[0076] The various databases stored in the memory unit 106 include memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0077] 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.

[0078] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the figures, 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. [Explanation of Symbols]

[0079] 100 Product management device 102 Control Unit 102a Master Maintenance Department 102b Product Data Import Section 102c Order Processing Unit 102d Inventory Processing Unit 102e Screen display control unit 104 Communication Interface Section 106 Storage section 106a Product Master 106b Numbering Master 108 Input / Output Interface Section 112 Input device 114 Output device 200 servers 300 Networks

Claims

1. A product management device equipped with a control unit, The control unit, A product master is registered by associating the product code, an internal code to define the same product, and a supplier code. The numbering master, which is registered by associating the supplier code and the assigned number, Product data including product code, supplier code, and old product code fields, It is configured to be accessible, A product management device characterized by comprising a master maintenance means for updating the product master and the numbering master based on the aforementioned product data.

2. The master maintenance means is, If the supplier code for the product data is not already registered in the numbering master, a record of the supplier code and the newly assigned number is added to the numbering master, and a record of the product code, the newly assigned number, the internal code generated based on the supplier code, and the supplier code is added to the product master. The product management device according to claim 1, characterized in that, if the supplier code for the product data is already registered in the numbering master, and the old product code is not registered in the product data, the numbering master is updated with the numbered number for the supplier code, and records of the product code, the updated numbered number, the internal code assigned based on the supplier code, and the supplier code are added to the product master, and if the old product code is registered in the product data, the internal code and supplier code associated with the old product code are obtained from the product master, and records of the product code, the obtained internal code, and the supplier code are added to the product master.

3. The product management device according to claim 1, characterized in that the product code is a sales packaging unit code.

4. The control unit further, Inventory data including product code, internal code, supplier code, expiration date, current stock quantity, and available quantity, Order data including order number, order date, line number, product code, product name, order quantity, unit price, and sales amount, It is configured to be accessible, The product management device according to any one of claims 1 to 3, characterized in that, with respect to the inventory data, it is equipped with an inventory processing means that allocates the order quantity of the order data to the product with the product code of the order data and to products having the same internal code as the internal code of the product, in order from the oldest product's inventory.

5. A product management method performed by an information processing device equipped with a control unit, The control unit, A product master is registered by associating the product code, an internal code to define the same product, and a supplier code. The numbering master, which is registered by associating the supplier code and the assigned number, Product data including product code, supplier code, and old product code fields, It is configured to be accessible, The control unit is executed as follows: A product management method characterized by including a master maintenance step that updates the product master and the numbering master based on the aforementioned product data.

6. A product management program to be executed by an information processing device equipped with a control unit, The control unit, A product master is registered by associating the product code, an internal code to define the same product, and a supplier code. The numbering master, which is registered by associating the supplier code and the assigned number, Product data including product code, supplier code, and old product code fields, It is configured to be accessible, The control unit, A product management program for executing a master maintenance process that updates the product master and the numbering master based on the aforementioned product data.

Images