JP7712974B2 - Unit price management device, unit price management method, and unit price management program - Google Patents

Description

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

Patent Document 1 discloses a technology that allows even small retail stores to order products at a purchase price that is competitive with large stores and mass retailers through joint purchasing. With this technology, product orders are received from retail stores, the received order quantities of the same product are added up, a delivery price is determined for each product according to the total quantity by referring to database 23, and products with this determined delivery price and total quantity are ordered from the manufacturer/wholesaler.

JP 2002-298029 A

In the medical industry, the unit price is mainly the incoming price of the product when it is shipped by the manufacturer, and because there are a large number of products handled, unit prices are revised frequently. For this reason, in the medical industry, discrepancies occur at the time of payment because the unit price at the time of ordering the product with the manufacturer differs from the unit price at which the product is shipped by the manufacturer, and it takes a huge amount of time to confirm the cause of the discrepancy and adjust the discrepancy before the closing date each month.

The present invention has been made in consideration of the above, and aims to provide a unit price management device, a unit price management method, and a unit price management program that can prevent discrepancies at the time of payment.

In order to solve the above-mentioned problems and achieve the object, the unit price management device of the present invention is a unit price management device having a control unit, and is capable of accessing a supplier-specific product unit price master in which a supplier code is associated with a product code and a purchase unit price, and the control unit has an order input unit that references the supplier-specific product unit price master and generates order data at the time of ordering in which an order number is associated with a product code, quantity, purchase unit price at the time of ordering, and unit price at the time of ordering based on the input product code and quantity, and places an order with a manufacturer, and an arrival information unit price associated with the order number, and a purchase unit price and an order time unit price associated with the order number, and The system is characterized by comprising: an accepting unit that acquires and accepts from the manufacturer the order data associated with the unit price; an accounting unit that generates purchase data that associates the purchase number, product code, and purchase unit price associated with the arrival unit price with the purchase number based on the arrival information and the order data that associates the purchase unit price linked to the arrival unit price and the unit price at the time of ordering; and an updating unit that, when a difference occurs when comparing the unit price at the time of ordering in the order data at the time of ordering with the purchase unit price linked to the arrival unit price in the purchase data, updates the purchase unit price in the supplier-specific product unit price master to the purchase unit price linked to the arrival unit price.

The unit price management method according to the present invention is a unit price management method executed by a unit price management device having a control unit, the unit price management device being capable of accessing a supplier-specific product unit price master in which a supplier code is associated with a product code and a purchase unit price, and the control unit is capable of executing an order input step of referencing the supplier-specific product unit price master and generating order data at the time of ordering in which an order number is associated with a product code, quantity, purchase unit price at the time of ordering, and unit price at the time of ordering based on the input product code and quantity, and placing an order with a manufacturer, receiving information in which the order number is associated with a receiving unit price, and the order number is associated with a receiving unit price and a receiving unit price and a receiving unit price and a receiving unit price are generated based on the input product code and quantity, and an order input step of generating order data at the time of ordering in which an order number is associated with a receiving unit price and a receiving unit price and a receiving unit price are generated based on the input product code and quantity, and The method includes an acceptance step of acquiring and accepting from the manufacturer the order data associated with the incoming unit price and the order data associated with the incoming unit price, an accounting step of generating purchase data in which the purchase number is associated with the order number, the product code, and the purchase unit price associated with the incoming unit price based on the incoming information and the order data in which the purchase unit price linked to the incoming unit price and the unit price at the time of ordering 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 incoming unit price when a difference is found by comparing the unit price at the time of ordering in the order data at the time of ordering with the purchase unit price linked to the incoming unit price in the purchase data.

The unit price management program according to the present invention is a unit price management program to be executed by a unit price management device having a control unit, the unit price management device being capable of accessing a supplier-specific product unit price master in which a supplier code is associated with a product code and a purchase unit price, and the control unit is provided with an order input step of referencing the supplier-specific product unit price master and generating order data at the time of ordering in which an order number is associated with a product code, quantity, purchase unit price at the time of ordering, and unit price at the time of ordering based on the input product code and quantity, and placing an order with a manufacturer, receiving information in which the order number is associated with a receiving unit price, and ... The method includes an acceptance step of acquiring and accepting from the manufacturer, the order data in which the purchase price and the unit price at the time of ordering are associated with the purchase price linked to the arrival unit price and the unit price at the time of ordering, a calculation step of generating purchase data in which the purchase number is associated with the order number, the product code, and the purchase price linked to the arrival unit price based on the arrival information and the order data in which the purchase price and the unit price at the time of ordering are associated with the order number, and an update step of updating the purchase price in the supplier-specific product unit price master to the purchase price linked to the arrival unit price when a difference occurs when comparing the unit price at the time of ordering in the order data at the time of ordering with the purchase price linked to the arrival unit price in the purchase data.

The present invention has the effect of preventing discrepancies at the time of payment.

FIG. 1 is a schematic diagram showing an overview in a block diagram of an example of the configuration of a unit price management device according to an embodiment. FIG. 2 is a diagram showing an example of a supplier product unit price master table in the supplier-specific product unit price master of the unit price management device according to the embodiment. FIG. 3 is a sequence diagram showing an overview of the processing executed by the unit price management device and the manufacturer device according to the embodiment. FIG. 4 is a diagram showing an example of an order data table in the order data. FIG. 5 is a diagram showing an example of a receipt information table in the receipt information at the time of EDI linkage. FIG. 6 is a diagram showing an example of an order data table in order data at the time of EDI linkage. FIG. 7 is a diagram showing an example of a receipt data table in the receipt data. FIG. 8 is a diagram showing an example of a purchase data table in the purchase data. FIG. 9 is a diagram showing a schematic overview of a method for generating purchase data by the accounting section of the unit price management device according to the embodiment. FIG. 10 is a diagram showing an example of an order data table in the order data. FIG. 11 is a diagram showing an example of the unit price difference inquiry screen. FIG. 12 is a diagram showing an example of a product table for a product code selected by a user. FIG. 13 is a diagram showing an example of a supplier-specific product unit price master table after updating in the supplier-specific product unit price master in the unit price management device according to the embodiment. FIG. 14 is a diagram showing an example of the order data table in the updated order data.

Below, an embodiment of a unit price management device, a unit price management method, and a 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 to the present embodiment.

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

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, but may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

The unit price management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input/output interface unit 108. Each unit included in the unit price management device 100 is connected to be able to communicate with each other via any communication path.

The communication interface unit 104 communicatively 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 with other devices via the communication line. Here, the network 300 has a function of connecting the unit price management device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input/output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that works with a mouse to provide a pointing device function. 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 the mouse 112.

The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs that work with the OS (Operating System) to give instructions to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 stores a supplier-specific product unit price master 106a.

The supplier-specific product price master 106a stores product codes and purchase prices in association with product supplier CD (code).

Figure 2 shows an example of a supplier product unit price master table in the supplier product unit price master 106a. The supplier product unit price master table T1 shown in Figure 2 stores the product CD "S0001" in association with the product code "SH00001" and the purchase price "150".

Returning to FIG. 1, the description of the configuration of unit price management device 100 will continue.
The control unit 102 is a CPU or the like that performs overall control of the unit price management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. The control unit 102 includes an order input unit 102a, a linking unit 102b, an acceptance unit 102c, an accounting unit 102d, a display control unit 102e, and an update unit 102f.

The order entry unit 102a performs order entry and order entry processing to accept and register order data based on the operation contents entered by the user via the input device 112.

The linking unit 102b transmits the order data registered by the order input unit 102a to the manufacturer's device and performs linking processing for EDI linking.

The receiving unit 102c acquires arrival information in which the arrival unit price is associated with the order number, and order data in which the purchase price and the unit price at the time of ordering linked to the order number are associated with the order number.

The accounting unit 102d executes a bulk purchasing accounting process to generate purchasing data based on the incoming data and the order data.

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 ordering based on the order data and the purchase price.

The update unit 102f updates the purchase price in the supplier-specific product unit price master 106a according to the user's operation on the input device 112.

[2. Order processing executed by the unit price management device and the manufacturer device]
Next, an order processing executed by unit price management device 100 and a manufacturer device will be described with reference to Fig. 3, which is a sequence diagram showing an outline of the processing executed by unit price management device 100 and a manufacturer device.

As shown in FIG. 2, first, the order entry unit 102a performs an order entry/order entry process that accepts and registers order data at the time of placing an order, based on the operation content entered by the user via the input device 112 (step S1).

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

Next, the linking unit 102b transmits the order data registered by the order input unit 102a to the manufacturer's device and performs linking processing to establish EDI linkage (step S2).

Then, the manufacturer device performs an order data acceptance process based on the order data sent from the unit price management device 100 (step S3), generates linkage information including arrival information and shipping order data, sends it to the unit price management device 100, and executes a shipping data linkage process for EDI linkage (step S4).

Next, the receiving unit 102c executes a receiving data receiving process based on the linkage information transmitted from the manufacturer's device (step S5). Specifically, the receiving unit 102c acquires, from the manufacturer's device, receiving information in which the receiving unit price is associated with the order number, and order data in which the purchase unit price and the unit price at the time of ordering linked to the receiving unit price are associated with the order number.

Figure 5 shows an example of a receipt information table for receipt information when EDI is linked. Figure 6 shows an example of an order data table for order data when EDI is linked.

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

Similarly, in the order data table T4 shown in FIG. 6, the order number, product code, quantity, purchase price, order price, and update flag are stored in association with the order number. Specifically, the order data table T4 stores the order number "H000001" in association with the order number "1," product code "SH00001," quantity "5," purchase price "160," order price "150," and update flag "0."

As shown in the arrival information data table T3 and the order data table T4, the purchase price in the order data table T4 is stored as the arrival price "160" in the arrival information data table T3. Therefore, the receiving unit 102c stores the purchase price "150" at the time of ordering (see the order data table T2 in Figure 4) as a separate item in the memory unit 106.

Next, the receiving unit 102c performs an arrival input process to receive arrival data based on the operation information input by the user via the input device 112 (step S6).

Figure 7 is a diagram showing an example of an arrival data table in arrival data. In the arrival data table T5 shown in Figure 7, the arrival number is stored in correspondence with the arrival line number, product code, and quantity. Specifically, the name of one line in the arrival data table T5 stores the arrival number "N000001" in correspondence with the arrival line number "1," product code "SH00001," and quantity "5."

Then, the accounting unit 102d executes a purchasing lump-sum accounting process to generate purchasing data based on the incoming data and the order data (step S7).

Figure 8 shows an example of a purchase data table in the purchase data. Figure 9 shows a schematic overview of the method for generating purchase data generated by the accounting unit 102d.

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

Next, the unit price management device 100 executes a unit price difference inquiry process in which the display control unit 102e displays on the monitor 114 a unit price difference inquiry screen for each product code for which there is a difference between the unit price at the time of ordering based on the order data and the purchase unit price, and the update unit 102f updates the purchase unit price in the supplier-specific product unit price master 106a according to the user's operation on the input device 112 (step S8).

Figure 10 shows an example of an order data table in the order data. Figure 11 shows an example of a unit price difference inquiry screen.

The order data table T7 shown in FIG. 11 stores each product code (record) for which there is a difference between the purchase price and the unit price at the time of ordering. 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 from which multiple product codes for which there is a difference between the purchase price and the unit price at the time of ordering based on the order data table T7 can be selected.

The unit price difference inquiry screen P1 includes order date cells K1, K2 into which an order date can be input, order number cells K3, K4 into which an order number can be input, and supplier code K5 into which a supplier code can be input. In addition, the unit price difference inquiry screen P1 includes a product code selection table Q1 that allows the user to select a desired product code from product codes for which there is a difference between the purchase price and the unit price at the time of ordering, and an update button B1 that can accept input of an instruction signal to update the unit price at the time of ordering of the selected product code to the purchase price.

In the case shown in FIG. 11, the display control unit 102e may extract product codes corresponding to order data that corresponds to the extraction information input from the memory unit 106 and in which there is a difference between the purchase price and the unit price at the time of ordering, based on the extraction information input into the order date cells K1, K2, the order number cells K3, K4, and the supplier code K5, and display them on the unit price difference inquiry screen P1. In this case, the display control unit 102e excludes product codes in which the update flag in the order data is set to "1" from the screen to the unit price difference inquiry screen P1, even if they correspond to the information input into the order number cells K3, K4, and the supplier code K5.

When the user selects a product code for which there is a difference between the purchase price and the unit price at the time of ordering via the input device 112 and presses the update button B1, the update unit 102f updates the unit price at the time of ordering of the selected product code to the purchase price.

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

As shown in Figures 12 to 14, the update unit 102f updates the unit price at the time of ordering of the selected product code to the purchase unit price, and updates the unit price in the supplier-specific product unit price master 106a from "150" to "160". Furthermore, the update unit 102f updates the update flag indicating that the unit price in the order data table T12 has been updated to "1". As a result, even if the unit price at the time of ordering the product with the manufacturer differs from the unit price based on the product's arrival unit price when the manufacturer shipped the product, the unit price at the time of ordering can be updated to the purchase unit price based on the product's arrival unit price when the manufacturer shipped the product, preventing discrepancies from occurring at the time of payment.

Returning to FIG. 3, the description of step S9 and subsequent steps will be continued.
In step S9, the unit price management device 100 performs a payment input process for accepting payment input according to the order, in accordance with the operation contents input by the user via the input device 112. After step S9, this process ends.

According to the embodiment described above, if there is a difference between the unit price at the time of ordering based on the order data and the purchase unit price, the update unit 102f updates the purchase unit price in the supplier-specific product unit price master 106a to the purchase unit price linked to the arrival unit price. Therefore, even if the unit price at the time of ordering the product with the manufacturer differs from the purchase unit price based on the arrival unit price of the product when the manufacturer ships the product, the unit price at the time of ordering can be updated to the purchase unit price based on the arrival unit price of the product when the manufacturer ships the product, thereby preventing discrepancies from occurring at the time of payment.

In addition, according to the embodiment, the update unit 102f updates the update flag indicating that the purchase price in the order data table T12 has been updated to "1", so that the product code can be managed separately from other unupdated product codes.

In addition, according to the embodiment, the display control unit 102e displays on the monitor 114 product codes for which there is a difference between the unit price at the time of ordering based on the order data and the purchase price, so that the user can intuitively grasp the product codes for which there is a difference between the unit price at the time of ordering and the purchase price.

In addition, according to the embodiment, the update unit 102f updates the unit price at the time of ordering of the selected product code to the purchase unit price and updates the purchase unit price in the supplier-specific product unit price master 106a, so that the user can update while checking the difference between the unit price at the time of ordering and the purchase unit price, thereby reducing the time required to check the cause of discrepancies and adjust discrepancies before the closing date each month.

[3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)]
This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby making it possible to contribute to goals 8 and 9 of the SDGs.

In addition, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, which can contribute to the achievement of SDGs goals 12, 13, and 15.

In addition, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

4. Other embodiments
The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

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 using a known method.

In addition, the processing procedures, control procedures, specific names, registered data for each process, information including parameters such as search conditions, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

Furthermore, with regard to the unit price management device 100, each component shown in the figure is a functional concept, and does not necessarily have to be physically configured as shown in the figure.

For example, the processing functions of the unit price management device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded on a non-transient computer-readable recording medium that contains programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the unit price management device 100 as necessary. That is, a computer program is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive) for working with the OS to give instructions to the CPU and perform various processes. This computer program is executed by being loaded into RAM, and works with the CPU to form the control unit.

This computer program may also be stored in an application program server connected to the unit price management device 100 via any network, and all or part of it may be downloaded as needed.

In addition, the program for executing the processing described in this embodiment may be stored on a non-transitory computer-readable recording medium, and may also be configured as a program product. Here, the term "recording medium" refers to a memory card, a USB (Universal Serial Bus) memory, a 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 This includes any "portable physical media" such as a Blu-ray (registered trademark) Disc, and a Blu-ray (registered trademark) Disc.

A "program" is a data processing method written in any language or description method, and may be in any format, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration consisting of multiple modules or libraries, and a program that works in conjunction with a separate program, such as an OS, to achieve its function. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

The various databases stored in the memory unit are storage devices such as RAM, ROM, etc., 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 providing websites.

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. The unit price management device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.

Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the figures, and all or part of them can be functionally or physically distributed and integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively.

The present invention is useful for businesses in industries that use delivery data from companies or manufacturers with a large number of invoices to carry out payment operations, such as businesses in the medical industry.

REFERENCE SIGNS LIST 100 Unit price management device 102 Control unit 102a Order input unit 102b Link unit 102c Receiving unit 102d Accounting 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 (6)

A unit price management device including a control unit,
It is possible to access the supplier-specific product price master that corresponds the supplier code with the product code and the purchase price.
The control unit is
an order input unit which refers to the supplier-specific product unit price master, and generates order data at the time of ordering in which the order number is associated with the product code, the quantity, the purchase price at the time of ordering, and the unit price at the time of ordering based on the input product code and quantity, and places an order with a manufacturer;
an accepting unit that acquires and accepts from the manufacturer, arrival information in which the order number is associated with an arrival unit price, and order data in which the order number is associated with a purchase unit price and an order time unit price linked to the arrival unit price;
an accounting unit that generates purchase data in which a purchase number is associated with a purchase unit price linked to the arrival unit price, a product code, and a purchase unit price linked to the arrival unit price, based on the arrival information and order data in which the order number is associated with a purchase unit price and an order time unit price;
an updating unit that updates the purchase price in the supplier-specific product unit price master to the purchase price linked to the receiving unit price when a difference occurs between the unit price at the time of ordering in the order data and the purchase price linked to the receiving unit price in the purchase data;
To have
A unit price management device comprising: 2. The unit price management device according to claim 1,
The update unit is
updating a flag indicating whether or not an update has been performed on the order data at the time of the order in which the purchase unit price in the supplier-specific product unit price master has been updated to a purchase unit price linked to the incoming unit price;
A unit price management device comprising: 3. The unit price management device according to claim 2,
The control unit is
a display control unit that displays on a monitor a product code for which there is a difference between the unit price at the time of ordering in the order data at the time of ordering and a purchase unit price linked to the receiving unit price in the purchase data;
A unit price management device comprising: The unit price management device according to claim 3,
The display control unit is
When there are a plurality of product codes for which there is a difference between the unit price at the time of ordering in the order data at the time of the order and the purchase unit price linked to the receiving unit price in the purchase data, displaying on the monitor the plurality of product codes for which there is a difference between the unit price at the time of ordering in the order data at the time of the order and the purchase unit price linked to the receiving unit price in the purchase data;
The update unit is
updating the purchase unit price in the supplier-specific product unit price master linked to a product code selected by a user from among the multiple product codes displayed on the monitor to a purchase unit price linked to the incoming unit price;
A unit price management device comprising: A unit price management method executed by a unit price management device having a control unit,
The unit price management device includes:
It is possible to access the supplier-specific product price master that corresponds the supplier code with the product code and the purchase price.
Executed by the control unit,
an order input step of generating order data at the time of ordering in which an order number is associated with a product code, a quantity, a purchase price at the time of ordering, and a unit price at the time of ordering based on an input product code and quantity by referring to the supplier-specific product price master, and placing an order with a manufacturer;
an accepting step of acquiring and accepting from the manufacturer receiving information in which the order number is associated with a receiving unit price and ordering data in which the order number is associated with a purchase unit price and an ordering unit price linked to the receiving unit price;
a recording step of generating purchase data in which a purchase number is associated with a purchase price, a product code, and a purchase price associated with the arrival price, based on the arrival information and order data in which the purchase price and the unit price at the time of ordering are associated with the order number;
an updating step of updating 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 unit price at the time of ordering in the order data and the purchase unit price linked to the receiving unit price in the purchase data;
containing,
A unit price management method characterized by the above. A unit price management program to be executed by a unit price management device having a control unit,
The unit price management device includes:
It is possible to access the supplier-specific product price master that corresponds the supplier code with the product code and the purchase price.
To cause the control unit to execute
an order input step of generating order data at the time of ordering in which an order number is associated with a product code, a quantity, a purchase price at the time of ordering, and a unit price at the time of ordering based on an input product code and quantity by referring to the supplier-specific product price master, and placing an order with a manufacturer;
an accepting step of acquiring and accepting from the manufacturer receiving information in which the order number is associated with a receiving unit price and ordering data in which the order number is associated with a purchase unit price and an ordering unit price linked to the receiving unit price;
a recording step of generating purchase data in which a purchase number is associated with a purchase price, a product code, and a purchase price associated with the arrival price, based on the arrival information and order data in which the purchase price and the unit price at the time of ordering are associated with the order number;
an updating step of updating 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 unit price at the time of ordering in the order data and the purchase unit price linked to the receiving unit price in the purchase data;
containing,
A unit price management program featuring: