Unit price management device, unit price management method, and unit price management program

The unit price management device aligns order and purchase unit prices by updating supplier-specific product unit price masters, addressing discrepancies and reducing errors and adjustment time in the medical industry.

JP7712974B2Active Publication Date: 2025-07-24OBIC CO LTD
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
JP2023051668
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2023-03-28
Publication Date
2025-07-24
Estimated Expiration
2043-03-28

AI Technical Summary

Technical Problem

In the medical industry, discrepancies occur between the order unit price and the purchase unit price due to frequent unit price revisions, leading to time-consuming discrepancy adjustment work and potential arithmetic errors at the time of payment.

Method used

A unit price management device and method that associates product codes with supplier codes, generates order data, and updates purchase unit prices based on received unit prices to align with order unit prices, using a control unit to manage and update supplier-specific product unit price masters.

Benefits of technology

Prevents arithmetic errors at the time of payment by aligning order and purchase unit prices, reducing the time required for discrepancy adjustment, and enhancing business efficiency.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007712974000001
    Figure 0007712974000001
  • Figure 0007712974000002
    Figure 0007712974000002
  • Figure 0007712974000003
    Figure 0007712974000003
Patent Text Reader

Abstract

To provide a unit price management device, a unit price management method, and a unit price management program capable of carrying out flexible as well as accurate computer-assisted name identification.SOLUTION: A unit price management device: carries out a first determination process for determining whether a total number of points is a cutback bar value or less for every credit ID by referring to a transfer remittance control master; carries out second determination process for determining whether a total number of points for every credit ID is a cutback bar value or more by referring to the transfer payment control master; and generates computer-assisted name identification data corresponding to an own execution date, a record sequence and computer-assisted name identification result, the credit ID, payment date, and payment day sequence to an own company account code based on the results of the first determination process and the second determination process.SELECTED DRAWING: Figure 1
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

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

Background Art

[0002] Patent Document 1 discloses a technique that enables even a small-scale retail store to order goods at a purchase price sufficient to compete with large stores and mass retailers through joint purchasing. In this technique, an order for goods is received from a retail store, and for the received goods, the order quantities for the same goods are aggregated. Referring to the database 23, the delivery unit price corresponding to the aggregated quantity is determined for each good, and an order is placed with the manufacturer / wholesaler for the goods with the determined delivery unit price and aggregated quantity.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] By the way, in the medical industry and the like, the manufacturer mainly treats the incoming unit price of the goods when the goods are shipped as the purchase unit price. In addition, the number of items handled is large and the frequency of unit price revisions is high. For this reason, in the medical industry and the like, due to the difference between the order unit price at the time of placing an order for goods with the manufacturer and the purchase unit price based on the incoming unit price of the goods when the manufacturer ships the goods, a discrepancy occurs at the time of payment, and a huge amount of time is required to confirm the cause of the discrepancy and perform the discrepancy adjustment work before the end of each month.

[0005] The present invention has been made in view of the above, and an object thereof is to provide a unit price management device, a unit price management method, and a unit price management program that can prevent the occurrence of discrepancies at the time of payment.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, the unit price management device according to the present invention is a unit price management device including a control unit, which can access a supplier-by-product unit price master in which a product code and a purchase unit price are associated with a supplier code. The control unit refers to the supplier-by-product unit price master and generates order data at the time of order in which a product code, a quantity, a purchase unit price at the time of order, and an order unit price are associated with an order number based on the input product code and quantity, and places an order with a manufacturer. A receiving and order input unit; receiving information in which a received unit price is associated with the order number; and order data in which a purchase unit price associated with the received unit price and an order unit price at the time of order are associated with the order number, from the manufacturer. A receiving unit that receives and accepts; a calculation unit that generates purchase data in which the order number, the product code, and the purchase unit price associated with the received unit price are associated with a purchase number based on the received information and the order data in which the purchase unit price associated with the received unit price and the order unit price at the time of order are associated with the order number; When a difference occurs by comparing the order unit price of the order data at the time of order with the purchase unit price associated with the received unit price of the purchase data, an update unit that updates the purchase unit price of the supplier-by-product unit price master to the purchase unit price associated with the received unit price. It is characterized by comprising.

[0007] Further, the unit price management method according to the present invention is a unit price management method executed by a unit price management device including a control unit. The unit price management device can access a supplier-by-product unit price master that associates a product code and a purchase unit price with a supplier code. The control unit executes a receiving and placing order input step of referring to the supplier-by-product unit price master, generating order data at the time of order that associates a product code, quantity, purchase unit price at the time of order, and order unit price with an order number based on the input product code and quantity, and placing an order with a manufacturer; a receiving step of receiving and accepting, from the manufacturer, receiving information that associates a receiving unit price with the order number, and order data that associates the purchase unit price and the order unit price associated with the receiving unit price with the order number; a recording step of generating accounting data that associates the order number, product code, and purchase unit price associated with the receiving unit price with a purchase number based on the receiving information and the order data that associates the purchase unit price and the order unit price associated with the receiving unit price with the order number; and an update step of updating the purchase unit price in the supplier-by-product unit price master to the purchase unit price associated with the receiving unit price when a difference occurs by comparing the order unit price in the order data at the time of order with the purchase unit price associated with the receiving unit price in the accounting data.

[0008] Also, the unit price management program according to the present invention is a unit price management program to be executed on a unit price management device including a control unit. The unit price management device can access a supplier-specific product unit price master in which a product code and a purchase unit price are associated with a supplier code. A purchase input step of referring to the supplier-specific product unit price master for execution by the control unit, generating order data at the time of order in which a product code, quantity, purchase unit price at the time of order, and order unit price at the time of order are associated with an order number based on the input product code and quantity, and placing an order with a manufacturer; A receiving step of receiving and accepting, from the manufacturer, receiving information in which a received unit price is associated with the order number, and order data in which the purchase unit price and the order unit price associated with the received unit price are associated with the order number; A posting step of generating posting data in which the order number, the product code, and the purchase unit price associated with the received unit price are associated with a purchase number based on the received information and the order data in which the purchase unit price and the order unit price associated with the received unit price are associated with the order number; And an update step of updating the purchase unit price in the supplier-specific product unit price master to the purchase unit price associated with the received unit price when a difference occurs by comparing the order unit price in the order data at the time of order with the purchase unit price associated with the received unit price in the posting data.

Effect of the Invention

[0009] According to the present invention, there is an effect that it is possible to prevent the occurrence of an arithmetic error at the time of payment.

Brief Description of the Drawings

[0010]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Embodiments for Carrying Out the Invention

[0011] Hereinafter, embodiments of the unit price management device, unit price management method, and unit price management program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited by this embodiment.

[0012] [1. Configuration] An example of the configuration of the unit price management device according to this embodiment will be described with reference to FIG. 1 and the like. FIG. 1 is a schematic diagram showing an overview of an example of the configuration of the unit price management device in a block diagram.

[0013] The unit price management device 100 shown in FIG. 1 is a commercially available desktop personal computer. Note that the unit price 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, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer.

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

[0015] The communication interface unit 104 communicably connects the unit price 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 via another device and a communication line. Here, the network 300 has a function of communicably connecting the unit price management device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network). Note that the data stored in the storage unit 106 may be stored in the server 200, for example.

[0016] An input / output interface unit 108 is connected to an input device 112 and an output device 114. As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, 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, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

[0017] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving commands 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, and an optical disk can be used. The storage unit 106 stores a purchase destination-specific product unit price master 106a.

[0018] The purchase destination-specific product unit price master 106a stores the product code and the purchase unit price in association with the product destination CD (code).

[0019] FIG. 2 is a diagram showing an example of a purchase destination product unit price master table in the purchase destination-specific product unit price master 106a. In the purchase destination product unit price master table T1 shown in FIG. 2, the product code "SH00001" and the purchase unit price "150" are stored in association with the product destination CD "S0001".

[0020] Returning to FIG. 1, the description of the configuration of the unit price management device 100 will be continued. The control unit 102 is a CPU or the like that comprehensively controls the unit price management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs defining various processing procedures, and required data, and executes various information processes based on these stored programs. The control unit 102 includes a receiving / issuing input unit 102a, a cooperation unit 102b, a receiving unit 102c, a totaling unit 102d, a display control unit 102e, and an update unit 102f.

[0021] The receiving / issuing input unit 102a performs receiving input / issuing input processing for receiving and registering order data based on the operation content input by the user via the input device 112.

[0022] The cooperation unit 102b performs cooperation processing for transmitting the order data registered by the receiving / issuing input unit 102a to the manufacturer device and performing EDI cooperation.

[0023] The receiving unit 102c acquires incoming goods information associating the incoming unit price with the order number, and order data associating the purchase unit price and the order time unit price linked to the incoming unit price with the order number.

[0024] The totaling unit 102d executes a batch totaling process for purchase data based on the incoming goods data and the order data.

[0025] The display control unit 102e displays on the monitor 114 a unit price difference inquiry screen for each product code where there is a difference between the unit price at the time of order and the purchase unit price based on the order data.

[0026] The update unit 102f updates the purchase unit price of the purchase destination-by-product unit price master 106a according to the operation content input to the input device 112 by the user.

[0027] [2. Ordering Process Executed by Unit Price Management Device and Manufacturer Device] Next, the ordering process executed by the unit price management device 100 and the manufacturer device will be described. FIG. 3 is a sequence diagram showing an overview of the processes executed by the unit price management device 100 and the manufacturer device.

[0028] As shown in FIG. 2, first, the order receiving / sending input unit 102a performs an order receiving / order sending input process of receiving and registering order data at the time of ordering based on the operation content input by the user via the input device 112 (step S1).

[0029] FIG. 4 is a diagram showing an example of an order data table in the order data. In the order data table T2 at the time of ordering shown in FIG. 4, an order number, an order line number, a product code, a quantity, a purchase unit price, an order unit price, and an update flag are stored in association with each other. Specifically, in the first row of the order data table T2, the order number "H00001" is associated with the order line number "1", the product code "SH00001", the quantity "5", the purchase unit price "150", the order unit price "150", and the update flag "0" and stored.

[0030] Subsequently, the cooperation unit 102b performs a cooperation process of sending the order data registered by the order receiving / sending input unit 102a to the manufacturer device and performing EDI cooperation (step S2).

[0031] Thereafter, the manufacturer device performs an order receiving data reception process based on the order data transmitted from the unit price management device 100 (step S3), generates cooperation information including the incoming shipment information and the order data of the shipment, and transmits it to the unit price management device 100 to execute a shipment data cooperation process of performing EDI cooperation (step S4).

[0032] Subsequently, the receiving unit 102c executes an incoming shipment data reception process based on the cooperation information transmitted from the manufacturer device (step S5). Specifically, the receiving unit 102c acquires, from the manufacturer device of the manufacturer, the incoming shipment information associating the incoming shipment unit price with the order number, and the order data associating the purchase unit price and the order unit price associated with the incoming shipment unit price with the order number.

[0033] FIG. 5 is a diagram showing an example of an incoming shipment information table in the incoming shipment information at the time of EDI cooperation. FIG. 6 is a diagram showing an example of an order data table in the order data at the time of EDI cooperation.

[0034] In the receipt information data table T3 shown in FIG. 5, the order number is associated with the order line number, product code, quantity, and receipt unit price and stored. Specifically, in the first row of the receipt information data table T3, the order number "H000001" is associated with the order line number "1", product code "SH00001", quantity "5", and receipt unit price "160" and stored.

[0035] Similarly, in the order data table T4 shown in FIG. 6, the order number is associated with the order number, product code, quantity, purchase unit price, order unit price, and update flag and stored. Specifically, in the order data table T4, the order number "H000001" is associated with the order number "1", product code "SH00001", quantity "5", purchase unit price "160", order unit price "150", and update flag "0" and stored.

[0036] As shown in the receipt information data table T3 and the order data table T4, the purchase unit price in the order data table T4 stores the receipt unit price "160" in the receipt information data table T3. Therefore, the receiving unit 102c holds the purchase unit price "150" at the time of order (refer to the order data table T2 in FIG. 4) in the storage unit 106 as a separate item.

[0037] Subsequently, the receiving unit 102c performs a receipt input process for receiving the input of receipt data based on the operation information input by the user via the input device 112 (step S6).

[0038] FIG. 7 is a diagram showing an example of a receipt data table in receipt data. In the receipt data table T5 shown in FIG. 7, the receipt number is associated with the receipt line number, product code, and quantity and stored. Specifically, in the first row name of the receipt data table T5, the receipt number "N000001" is associated with the receipt line number "1", product code "SH00001", and quantity "5" and stored.

[0039] Thereafter, the accounting unit 102d executes a batch accounting process for generating purchase data based on the receipt data and the order data (step S7).

[0040] FIG. 8 is a diagram showing an example of a purchase data table in purchase data. FIG. 9 is a diagram schematically showing an outline of a method for generating purchase data generated by the upper calculator 102d.

[0041] In the purchase data table T6 shown in FIG. 8, a purchase number is associated with a purchase line number, a receipt number, a receipt line number, an order number, an order line number, a product code, a quantity, and a purchase unit price and stored. Specifically, in the first row of the purchase data table T6, the purchase number "S000001" is associated with the purchase line number "1", the receipt number "N000001", the receipt line number "1", the order number "H000001", the order line number "1", the product code "SH00001", the quantity "5", and the purchase unit price "160" and stored. In this case, as shown in FIG. 9, the upper calculator 102d stores and generates the purchase unit price "160" in the purchase data table T6 based on the purchase unit price in the receipt information data table T3 and the purchase unit price in the order data table T4.

[0042] Subsequently, the unit price management device 100 causes the display control unit 102e to display on the monitor 114 a unit price difference inquiry screen for each product code in which a difference occurs between the order unit price based on the order data and the purchase unit price, and the update unit 102f executes a unit price difference inquiry process for updating the purchase unit price in the product unit price master 106a by supplier according to the operation content of the user to the input device 112 (step S8).

[0043] FIG. 10 is a diagram showing an example of an order data table in order data. FIG. 11 is a diagram showing an example of a unit price difference inquiry screen.

[0044] In the order data table T7 shown in FIG. 11, it is stored for each product code (record) in which a difference occurs between the purchase unit price and the order unit price. In this case, as shown in FIG. 11, the display control unit 102e displays a unit price difference inquiry screen P1 including a product code selection table Q1 in which a plurality of product codes in which a difference occurs between the order unit price and the purchase unit price based on the order data table T7 can be selected.

[0045] The unit price difference inquiry screen P1 includes order date cells K1 and K2 where the order date can be input, order number cells K3 and K4 where the order number can be input, and a supplier code cell K5 where the supplier code can be input. Further, the unit price difference inquiry screen P1 includes a product code selection table Q1 where the user can select a desired product code from product codes with a difference between the purchase unit price and the order unit price at the time of order, and an update button B1 that can accept the input of an instruction signal to update the order unit price of the selected product code to the purchase unit price.

[0046] In the case shown in FIG. 11, the display control unit 102e may extract product codes corresponding to order data that match the extraction information input from the storage unit 106 based on the extraction information input to each of the order date cells K1 and K2, the order number cells K3 and K4, and the supplier code cell K5, and that have a difference between the purchase unit price and the order unit price at the time of order, and display them on the unit price difference inquiry screen P1. At this time, even when the information input to each of the order number cells K3 and K4 and the supplier code cell K5 matches, the display control unit 102e excludes product codes in which the update flag in the order data stores "1" from the target for the unit price difference inquiry screen P1.

[0047] When the user selects a product code with a difference between the purchase unit price and the order unit price at the time of order via the input device 112 and presses the update button B1, the update unit 102f updates the order unit price of the selected product code to the purchase unit price.

[0048] FIG. 12 is a diagram showing an example of a product table for the product code selected by the user. FIG. 13 is a diagram showing an example of an updated supplier-specific product unit price master table in the supplier-specific product unit price master 106a. FIG. 14 is a diagram showing an example of an order data table in the updated order data.

[0049] As shown in FIGS. 12 to 14, the update unit 102f updates the ordering unit price of the selected product code to the purchase unit price, and updates the purchase unit price in the product unit price master 106a by supplier from "150" to "160". Further, the update unit 102f updates the update flag indicating that the purchase unit price in the order data table T12 has been updated to "1". As a result, even if there is a difference between the ordering unit price at the time of placing an order for the product with the manufacturer and the purchase unit price based on the incoming unit price of the product when the manufacturer ships the product, the ordering unit price can be updated to the purchase unit price based on the incoming unit price of the product when the manufacturer ships the product, so that it is possible to prevent an arithmetic error from occurring at the time of payment.

[0050] Returning to FIG. 3, the description after step S9 will be continued. In step S9, the unit price management device 100 performs a payment input process for accepting a payment input corresponding to an order according to the operation content input by the user via the input device 112. After step S9, this process ends.

[0051] According to the embodiment described above, when there is a difference between the ordering unit price based on the order data and the purchase unit price, since the update unit 102f updates the purchase unit price in the product unit price master 106a by supplier to the purchase unit price associated with the incoming unit price, even if there is a difference between the ordering unit price at the time of placing an order for the product with the manufacturer and the purchase unit price based on the incoming unit price of the product when the manufacturer ships the product, the ordering unit price can be updated to the purchase unit price based on the incoming unit price of the product when the manufacturer ships the product, so that it is possible to prevent an arithmetic error from occurring at the time of payment.

[0052] Also, according to the embodiment, since the update unit 102f updates the update flag indicating that the purchase unit price in the order data table T12 has been updated to "1", it can be managed separately from other unupdated product codes.

[0053] Further, according to the embodiment, since the display control unit 102e displays the product codes with a difference between the ordering unit price based on the ordering data and the purchase unit price on the monitor 114, the user can intuitively grasp the product codes with a difference between the ordering unit price and the purchase unit price.

[0054] Further, according to the embodiment, since the update unit 102f updates the ordering unit price of the selected product code to the purchase unit price and updates the purchase unit price in the purchase unit price master 106a by supplier, the user can update while confirming the difference between the ordering unit price and the purchase unit price. Therefore, it is possible to reduce the time required for confirming the cause of the variance and the variance adjustment work before the end of each month.

[0055] [3. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] According to the present embodiment, since it can contribute to improving business efficiency and promoting appropriate business judgment of the enterprise, it is possible to contribute to Goals 8 and 9 of the SDGs.

[0056] Further, according to the present embodiment, since it can contribute to reducing waste loss and promoting paperless and digitization, it is possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0057] Further, according to the present embodiment, since it can contribute to strengthening control and governance, it is possible to contribute to Goal 16 of the SDGs.

[0058] [4. Other Embodiments] 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.

[0059] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed may be manually performed, or all or part of the processes described as being manually performed may be automatically performed by a known method.

[0060] Also, regarding the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and the drawings, they can be arbitrarily changed unless otherwise specified.

[0061] Also, regarding the unit price management device 100, each illustrated component is a functional concept and does not necessarily have to be physically configured as shown in the figure.

[0062] For example, regarding the processing functions provided by the unit price management device 100, especially each processing function performed by the control unit, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may also be realized as hardware by wired logic. The program is recorded in a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processing described in this embodiment, and is mechanically read by the unit price management device 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into the RAM and constitutes the control unit in cooperation with the CPU.

[0063] Also, this computer program may be stored in an application program server connected to the unit price management device 100 via an arbitrary network, and it is also possible to download all or part of it as necessary.

[0064] Further, a program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as 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 Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0065] Also, the "program" is a data processing method described in any language or description method, and is not limited to a form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with another program represented by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0066] The various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0067] Further, the unit price management device 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 any peripheral device is connected. Further, the unit price management device 100 may be realized by installing software (including programs or data, etc.) that realizes the processing described in this embodiment in the device.

[0068] Furthermore, the specific form of the distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Industrial Applicability

[0069] The present invention is useful for businesses that perform payment operations using delivery data from companies or manufacturers with a large number of invoices, such as operators in the medical industry.

Explanation of Signs

[0070] 100 Unit price management device 102 Control unit 102a Sending / receiving input unit 102b Cooperation unit 102c Receiving unit 102d Counting unit 102e Display control unit 102f Update unit 104 Communication interface unit 106 Storage unit 106a Supplier-specific product unit price master 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims

1. A unit price management device comprising a control unit, which is capable of accessing a supplier-specific product unit price master that associates a product code and a purchase unit price with a supplier code, wherein the control unit refers to the supplier-specific product unit price master and generates order data at the time of order that associates a product code, quantity, purchase unit price at the time of order, and order unit price with an order number based on the input product code and quantity, and places an order with a manufacturer; a receiving and placing input unit, a receiving unit that acquires and accepts, from the manufacturer, the receiving information that associates a receiving unit price with the order number, and the order data that associates the purchase unit price and the order unit price linked to the receiving unit price with the order number, a calculation unit that generates purchase data associating the order number, the product code, and the purchase unit price linked to the receiving unit price with a purchase number based on the receiving information and the order data that associates the purchase unit price and the order unit price linked to the receiving unit price with the order number, an update unit that updates the purchase unit price in the supplier-specific product unit price master to the purchase unit price linked to the receiving unit price when a difference occurs between the order unit price in the order data at the time of order and the purchase unit price linked to the receiving unit price in the purchase data, characterized by comprising a unit price management device.

2. The unit price management device according to claim 1, wherein the update unit updates a flag indicating the presence or absence of an update to a flag indicating that the purchase unit price in the supplier-specific product unit price master has been updated to the purchase unit price linked to the receiving unit price in the order data at the time of order, characterized by a unit price management device.

3. The unit price management device according to claim 2, wherein the control unit further comprises a display control unit that causes a monitor to display a product code for which a difference occurs between the order unit price in the order data at the time of order and the purchase unit price linked to the receiving unit price in the purchase data, characterized by a unit price management device.

4. The unit price management device according to claim 3, wherein when there are a plurality of product codes for which a difference occurs between the order unit price in the order data at the time of order and the purchase unit price linked to the receiving unit price in the purchase data, the display control unit causes the monitor to display the plurality of product codes for which a difference occurs between the order unit price in the order data at the time of order and the purchase unit price linked to the receiving unit price in the purchase data, wherein the update unit Updating the purchase unit price in the purchase destination-specific product unit price master associated with the product code selected by the user from among the plurality of product codes displayed on the monitor to the purchase unit price associated with the incoming unit price. A unit price management device characterized by the above.

5. A unit price management method executed by a unit price management device including a control unit, The unit price management device, Can access a purchase destination-specific product unit price master that associates a product code and a purchase unit price with a purchase destination code, Executed by the control unit, Referring to the purchase destination-specific product unit price master, generating order data at the time of order that associates a product code, quantity, purchase unit price at the time of order, and order unit price with an order number based on the input product code and quantity, and placing an order with the manufacturer; a receiving and placing input step; A receiving step of obtaining and accepting, from the manufacturer, incoming information associating an incoming unit price with the order number, and order data associating the order number with the purchase unit price associated with the incoming unit price and the order unit price at the time of order; Based on the incoming information and the order data associating the order number with the purchase unit price associated with the incoming unit price and the order unit price at the time of order, a step of generating accounting data associating the order number, product code, and purchase unit price associated with the incoming unit price with a purchase number; If a difference occurs when comparing the order unit price in the order data at the time of order with the purchase unit price associated with the incoming unit price in the accounting data, an update step of updating the purchase unit price in the purchase destination-specific product unit price master to the purchase unit price associated with the incoming unit price; Including the above, A unit price management method characterized by the above.

6. A unit price management program for execution by a unit price management device including a control unit, The unit price management device, Can access a purchase destination-specific product unit price master that associates a product code and a purchase unit price with a purchase destination code, For execution by the control unit, Referring to the purchase destination-specific product unit price master, generating order data at the time of order that associates a product code, quantity, purchase unit price at the time of order, and order unit price with an order number based on the input product code and quantity, and placing an order with the manufacturer; a receiving and placing input step; A receiving step of obtaining and accepting, from the manufacturer, incoming information associating an incoming unit price with the order number, and order data associating the order number with the purchase unit price associated with the incoming unit price and the order unit price at the time of order; An accounting step of generating purchase data in which a purchase number is associated with the order number, a product code, and a purchase unit price associated with the incoming unit price based on the order data in which the purchase unit price and the order unit price associated with the incoming unit price are associated with the incoming information and the order number; An update step of updating the purchase unit price in the purchase destination-specific product unit price master to the purchase unit price associated with the incoming unit price when a difference occurs by comparing the order unit price of the order data at the time of order with the purchase unit price associated with the incoming unit price of the purchase data; Including; A unit price management program characterized by the above.

Citation Information

Patent Citations

  • System, method and program for receiving and placing order for goods

    JP2002298029A

  • Retroaction unit price correction system and method

    JP2014119821A

  • Selling information device, amount retroaction method and amount retroaction program

    JP2016170777A

  • Retroactive unit price correction device, retroactive unit price correction method, and retroactive unit price correction program

    JP2019061569A

  • Inventory amount adjustment device, inventory amount adjustment method and inventory amount adjustment program

    JP2020052488A