Commodity purchase price floating calculation device and method based on ERP (Enterprise Resource Planning)

Abstract

The invention discloses a commodity purchase price floating calculation device and method based on ERP, and relates to the field of material purchase. The device comprises a data acquisition module used for acquiring daily prices of bulk raw materials and recording protocol reference prices, price difference thresholds and price floating thresholds of the bulk raw materials; the price calculation module is used for calculating the price of the bulk raw material according to the size relation between the difference value between the daily price of the bulk raw material and the protocol reference price of the corresponding bulk raw material and the price difference threshold value and / or the size relation between the price floating between the daily price and the protocol reference price and the price floating threshold value. Determining the types of bulk raw materials for commodity price calculation, and calculating the latest price of the commodity according to the determined types of the bulk raw materials; and the price tracing module is used for providing a query interface and feeding back the historical price of the commodity and the price calculation process according to the input information. The technical problems that in the prior art, a calculation formula for agreed execution prices is large in calculation amount, low in efficiency and incapable of tracing to the source are solved.

Description

Technical Field

[0001] This invention relates to the field of material procurement technology, and in particular to an ERP-based device and method for calculating commodity procurement price fluctuations. Background Technology

[0002] In the procurement of power industry, for certain important materials such as cables, in order to ensure the stability of procurement, the purchaser and the supplier often sign long-term procurement agreements. During the execution period of the agreement, the purchased materials are greatly affected by the price fluctuations of bulk raw materials such as iron, copper and aluminum, which causes trouble for both parties on how to implement the procurement agreement price when actually placing orders.

[0003] To address these issues, sales personnel typically specify the calculation formula for the execution price when signing procurement agreements. However, this approach introduces several challenges. Specifically, as business grows and the number of procurement agreements increases, the inconsistent calculation formulas used by different suppliers create a significant workload for sales personnel when placing orders, increasing the probability of errors. Furthermore, if the execution price of a procurement agreement involves multiple stages, such as procurement planning and purchase orders, sales personnel must calculate the price at each stage, leading to unnecessary duplication of work. Finally, for completed procurement prices, if sales personnel need to trace the basis for the price calculation, they often cannot find the entry point. Summary of the Invention

[0004] This invention provides an ERP-based device and method for calculating commodity procurement price fluctuations, which solves the technical problems of existing technologies where the calculation formula for agreed execution prices involves large computational loads, low efficiency, and lack of traceability. The technical solution is as follows:

[0005] In a first aspect, embodiments of the present invention provide an ERP-based commodity procurement price fluctuation calculation device, comprising:

[0006] Data acquisition module: Used to acquire the daily prices of bulk raw materials and record the agreed benchmark price, price difference threshold, and price fluctuation threshold of bulk raw materials;

[0007] Price calculation module: used to determine the types of bulk raw materials to be included in the commodity price calculation based on the relationship between the difference between the daily price of bulk raw materials and the agreed benchmark price of the corresponding bulk raw materials and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold, and to calculate the latest commodity price based on the determined types of bulk raw materials;

[0008] Price traceability module: This module provides a query interface and, based on preset input information, provides feedback on the historical price of the product and the price calculation process.

[0009] In some embodiments of the present invention, the data acquisition module includes a price recording unit, a data updating unit, and a commodity information recording unit;

[0010] The price recording unit is used to record the agreement benchmark price, price difference threshold, price fluctuation threshold, and daily prices of bulk raw materials.

[0011] The data update unit is used to update the benchmark price, price difference threshold, and price fluctuation threshold of the agreement in a timely manner according to changes in the content of the preset agreement, and to update the daily price in a timely manner according to the daily price changes of bulk raw materials.

[0012] The commodity information recording unit is used to record commodity name, commodity code, unit of measurement, raw materials, raw material code, raw material specifications and unit of measurement according to the preset protocol.

[0013] In some embodiments of the present invention, the price calculation module includes a bulk raw material type determination unit and a calculation unit;

[0014] The bulk raw material type determination unit is used to determine the type of bulk raw material to be included in the commodity price calculation based on the relationship between the difference between the daily price of the bulk raw material and the agreed benchmark price of the corresponding bulk raw material and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold.

[0015] The calculation unit is used to determine the latest price of a commodity based on a preset algorithm according to the type of bulk raw material.

[0016] In some embodiments of the present invention, the preset algorithm of the computing unit is determined by the following formula:

[0017]

[0018] Where: P is the latest price of the product; P0 is the preset agreed price of the product; A i A is the agreed benchmark price for the i-th bulk raw material in the agreement; i0 K represents the daily price of the i-th bulk raw material in the agreement; i This is the coefficient for raw material A.

[0019] In some embodiments of the present invention, the calculation unit calculates the latest price of a commodity by at least the following methods: using the price of the most recent date, using the price of the first natural day of the month, or using the average price of the month.

[0020] In some embodiments of the present invention, the bulk raw material type determination unit includes:

[0021] When the difference between the daily price of a bulk raw material and the agreed benchmark price of the corresponding bulk raw material is greater than the price difference threshold, and / or when the price fluctuation between the daily price of a bulk raw material and the agreed benchmark price is greater than the price fluctuation threshold, the bulk raw material is determined to be included in the calculation of the latest commodity price.

[0022] In some embodiments of the present invention, the query interface of the price tracing module includes an input condition field and an output result field;

[0023] The input conditions include the agreement number, product name, target date, and the calculation method for the latest product price;

[0024] The output includes agreement information, the benchmark price of the product agreement, the latest price of the product, the calculation process formula, and the raw material details.

[0025] In some embodiments of the present invention, a unified interface module is also included, which is used to encapsulate the latest price calculation result of the product and send the latest price calculation result of the product to the procurement execution module.

[0026] In some embodiments of the present invention, the input parameters of the unified interface module include protocol ID, product code, date, and the latest price calculation method for the product;

[0027] The output parameters include the latest price of the commodity and the agreed benchmark price of related raw materials, the latest price of bulk raw materials, the price difference threshold, and the price fluctuation threshold.

[0028] Secondly, the present invention also provides a method for calculating commodity purchase price fluctuations based on ERP, comprising:

[0029] Obtain the daily prices of bulk raw materials and record the agreed benchmark price, price difference threshold, and price fluctuation threshold of bulk raw materials;

[0030] Based on the relationship between the difference between the daily price of a bulk raw material and the agreed benchmark price of the corresponding bulk raw material and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold, the types of bulk raw materials to be included in the commodity price calculation are determined.

[0031] Calculate the latest commodity price based on the identified bulk raw material type.

[0032] The beneficial effects of the technical solutions provided by some embodiments of the present invention include at least the following: A data acquisition module acquires daily prices of bulk raw materials and records the agreed benchmark price, price difference threshold, and price fluctuation threshold of these raw materials. A price calculation module, based on the relationship between the difference between the daily price of the bulk raw materials and the corresponding agreed benchmark price and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold, determines the types of bulk raw materials to be included in the commodity price calculation. The latest commodity price is calculated based on the determined bulk raw material types, achieving automatic real-time calculation of the latest commodity price in the agreement, improving the efficiency of price calculation, and providing more reasonable prices to suppliers and purchasers, thus avoiding losses for both parties. Finally, a price traceability module allows for real-time viewing of the price calculation process, improving the transparency of commodity procurement pricing. Attached Figure Description

[0033] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0034] Figure 1 This is an exemplary system architecture for the ERP-based commodity procurement price fluctuation calculation device or the ERP-based commodity procurement price fluctuation calculation method provided by the present invention.

[0035] Figure 2 A schematic diagram of an embodiment of the ERP-based commodity procurement price fluctuation calculation device provided by the present invention;

[0036] Figure 3 A schematic diagram of the raw material coefficient maintenance interface for a commodity in the ERP-based commodity procurement price fluctuation calculation device provided by the present invention;

[0037] Figure 4 This is a schematic diagram of an embodiment of the ERP-based commodity procurement price fluctuation calculation method provided by the present invention. Detailed Implementation

[0038] To make the objectives, technical solutions, and advantages of this application clearer, the embodiments of this application will be described in further detail below with reference to the accompanying drawings.

[0039] It should be noted that the ERP-based commodity purchase price fluctuation calculation device provided in this application is generally executed by the terminal device, and correspondingly, the ERP-based commodity purchase price fluctuation calculation device is generally installed in the terminal device.

[0040] Figure 1 An exemplary system architecture is shown that can be applied to the ERP-based commodity purchase price fluctuation calculation device or the ERP-based commodity purchase price fluctuation calculation method of this application.

[0041] like Figure 1 As shown, the system architecture may include: terminal device 101 and server 102. Terminal device 101 and server 102 can communicate via a network, which serves as the medium for providing communication links between the various units. The network may include various types of wired or wireless communication links, such as: wired communication links including fiber optic cables, twisted-pair cables, or coaxial cables; and wireless communication links including Bluetooth communication links, Wi-Fi communication links, or microwave communication links.

[0042] It should be noted that the terminal device 101 and the server 102 can be either hardware or software. When the terminal device 101 and the server 102 are hardware, they can be implemented as a distributed server cluster consisting of multiple servers, or as a single server. When the terminal device 101 and the server 102 are software, they can be implemented as multiple software programs or software modules (e.g., used to provide distributed services), or as a single software program or software module; no specific limitations are made here.

[0043] The terminal device of this application can be equipped with various communication client applications, such as video recording applications, video playback applications, voice interaction applications, search applications, instant messaging tools, email clients, social platform software, etc.

[0044] A terminal device can be either hardware or software. When the terminal device is hardware, it can be various terminal devices with a display screen, including but not limited to smartphones, tablets, laptops, and desktop computers. When the terminal device is software, it can be installed on the terminal devices listed above. It can be implemented as multiple software programs or software modules (e.g., used to provide distributed services) or as a single software program or software module; no specific limitation is made here.

[0045] When the terminal device is hardware, it can also be equipped with a display device and a camera. The display device can be any device capable of displaying information, and the camera is used to capture video streams. For example, the display device can be a cathode ray tube display (CR), a light-emitting diode display (LED), an e-ink screen, a liquid crystal display (LCD), or a plasma display panel (PDP). Users can use the display device on the terminal device to view displayed text, images, videos, and other information.

[0046] It should be understood that Figure 1 The number of terminal devices, networks, and servers shown is for illustrative purposes only. Depending on implementation needs, there can be any number of terminal devices, networks, and servers.

[0047] The following will be combined with the appendix Figure 2 This application provides a detailed description of the ERP-based commodity procurement price fluctuation calculation device provided in its embodiments. Specifically, the ERP-based commodity procurement price fluctuation calculation device in this application embodiment can be... Figure 1 The terminal device shown includes:

[0048] Data acquisition module 21: Used to acquire the daily prices of bulk raw materials and record the agreed benchmark price, price difference threshold and price fluctuation threshold of bulk raw materials;

[0049] It should be noted that the daily prices of raw materials can be automatically obtained / manually maintained / imported based on publicly available daily price information. The agreed benchmark price for bulk raw materials refers to the initial price stipulated when both parties sign the purchase agreement. The price difference threshold and price fluctuation threshold can be set according to market demand and financial expenditure, etc., and are not limited here. Among them, the price difference is the difference between the daily price and the agreed benchmark price, and the price fluctuation is the ratio of the price difference to the latest price.

[0050] In one specific embodiment, the data acquisition module includes a price recording unit 211, a data updating unit 212, and a commodity information recording unit 213;

[0051] The price recording unit is used to record the agreement benchmark price, price difference threshold, price fluctuation threshold, and daily prices of bulk raw materials.

[0052] The data update unit is used to update the benchmark price, price difference threshold, and price fluctuation threshold of the agreement in a timely manner according to changes in the content of the preset agreement, and to update the daily price in a timely manner according to the daily price changes of bulk raw materials.

[0053] The commodity information recording unit is used to record commodity name, commodity code, unit of measurement, raw materials, raw material code, raw material specifications and unit of measurement according to the preset protocol.

[0054] In this embodiment, in each agreement, the price recording unit maintains the threshold of raw materials for each commodity, including the floating percentage threshold and the absolute value threshold of the floating difference, and performs version control on the threshold. When the agreement changes, the data update unit resets the value according to the changed price.

[0055] In a specific interface, please refer to Figure 3 The interface is divided into two parts: the left side records raw materials, and the right side automatically retrieves / manually maintains / imports prices for each raw material on different dates. Only one price is allowed per raw material on the same date. Specifically, it includes:

[0056] Raw material name: Select the raw materials to be maintained by the system, such as iron, copper, etc.

[0057] Price Dates: Based on the agreed-upon publicly available bulk raw material data, daily price dates and prices are entered into the system.

[0058] Price: The system automatically retrieves publicly available bulk raw material data from the server, or inputs / imports daily price dates and prices into the system.

[0059] And through the commodity information recording unit, the corresponding raw material coefficients of the commodity are statistically analyzed and recorded, specifically including:

[0060] Product Name: Required. Select the product to be maintained in the pop-up window.

[0061] Product code: Automatically populated after selecting a product;

[0062] Units of measurement: Automatically provided after selecting a product;

[0063] Raw materials: Required. Select the raw materials in the pop-up window.

[0064] Raw material codes: Automatically populated after selecting a raw material;

[0065] Raw material specifications and models: These will be automatically displayed after selecting the raw material;

[0066] Raw material unit of measurement: Automatically populated after selecting the raw material;

[0067] Coefficient: Required. Enter a number between 0 and 1.

[0068] Price calculation module 22: is used to determine the type of bulk raw material to be included in the commodity price calculation based on the relationship between the difference between the daily price of the bulk raw material and the agreed benchmark price of the corresponding bulk raw material and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold, and to calculate the latest commodity price based on the determined type of bulk raw material.

[0069] It should be noted that the purpose of determining the types of bulk raw materials to be included in commodity price calculation is to ignore the impact of bulk raw materials with small price changes or small price fluctuations on commodity pricing, thereby reducing the frequency of commodity price calculation. This is based on the relationship between the difference between the daily price of bulk raw materials and the corresponding agreed benchmark price and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold.

[0070] Recalculating commodity prices using the latest prices of bulk raw materials with large price fluctuations or large price ranges can provide suppliers and buyers with more reasonable prices, avoiding losses for both parties.

[0071] In one specific embodiment, the price calculation module includes a bulk raw material type determination unit 221 and a calculation unit 222;

[0072] The bulk raw material type determination unit is used to determine the type of bulk raw material to be included in the commodity price calculation based on the relationship between the difference between the daily price of the bulk raw material and the agreed benchmark price of the corresponding bulk raw material and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold.

[0073] It should be noted that when the difference between the daily price of a bulk raw material and the corresponding agreed benchmark price of the bulk raw material is greater than the price difference threshold, and / or when the price fluctuation between the daily price of the bulk raw material and the agreed benchmark price is greater than the price fluctuation threshold, the bulk raw material is determined to be included in the calculation of the latest commodity price.

[0074] The calculation unit is used to determine the latest price of a commodity based on a preset algorithm according to the type of bulk raw material.

[0075] In a preferred embodiment, the preset algorithm of the computing unit is determined by the following formula:

[0076]

[0077] Where: P is the latest price of the product; P0 is the preset agreed price of the product; A i A is the agreed benchmark price for the i-th bulk raw material in the agreement; i0 K represents the daily price of the i-th bulk raw material in the agreement; i This is the coefficient for raw material A.

[0078] It should be noted that the weighting coefficient K between commodities and raw materials... i It is a key parameter determining the extent to which fluctuations in raw material prices affect commodity prices, and can be quantified and allocated through cost / impact. No further limitations are specified here.

[0079] In a specific embodiment, if the absolute value of the price difference of a certain raw material is greater than or equal to a price difference threshold, or the absolute value of the price fluctuation ratio is greater than or equal to a price fluctuation ratio threshold, then it is included in the calculation. The absolute value of the price difference threshold = |A i -A i0 |; Absolute value of price fluctuation ratio = |A i -A i0 | / A i0 *100%.

[0080] For example: P1 = 120, A i0 =100, A i The price difference threshold is 30, and the fluctuation ratio threshold is 30%. (B) i0 =120, B i =100, B price difference threshold =10, fluctuation ratio threshold =30%, since the absolute value of the price difference of raw material B >10, therefore P = P0 + (B i -B i0 )*K B .

[0081] In a preferred embodiment of the present invention, the calculation unit calculates the latest price of the commodity by at least the following methods: using the price of the most recent date, using the price of the first natural day of the month, or using the average price of the current month.

[0082] It should be noted that the latest price is the price on the raw material price maintenance interface that is closest to the target date; the first day of the current month is the 1st of the month in which the target date is located, as shown in the raw material price maintenance interface; the monthly average price is the arithmetic mean of all prices in the month in which the target date is located, as shown in the raw material maintenance interface. When calculating the latest price of a product, if the parameter "Latest Price Calculation Method" = "Latest Price", then the latest price = the raw material price with the largest update date; if not found, it will look for the raw material price under the latest agreement. If the parameter "Latest Price Calculation Method" = "First Day of the Current Month", then the latest price = the price updated on the first working day of the current month; if not found, it will look for the raw material price under the latest agreement. If the parameter "Latest Price Calculation Method" = "Monthly Average Price", then the latest price = the average of all raw material prices in the current month; if no raw material price is available in the current month, it will look for the raw material price under the latest agreement.

[0083] Price traceability module 23: It provides a query interface and, based on preset input information, provides feedback on the historical price of the product and the price calculation process.

[0084] It should be noted that the price traceability module provides an interface for users to input product information, target date, etc., and query the prices of different products on different dates, as well as information on the price calculation process, thereby providing a transparent pricing model.

[0085] As shown in Table 1, the query interface of the price traceability module includes input condition fields and output result fields; wherein, the input conditions include agreement number, product name, target date, and the calculation method of the latest product price;

[0086] Table 1: List of Query Conditions for Traceability Units

[0087]

[0088] As shown in Table 2, the output results include agreement information, the benchmark price of the product agreement, the latest price of the product, the calculation process formula, and the raw material details.

[0089] Table 2: List of Query Results

[0090]

[0091]

[0092] In some embodiments of the present invention, please refer to Figure 2 It also includes a unified interface module 24, which is used to encapsulate the latest price calculation result of the product and send the latest price calculation result of the product to the procurement execution module.

[0093] The input parameters for the unified interface module include protocol ID, product code, date, and the method for calculating the latest product price.

[0094] The output parameters include the latest price of the commodity and the agreed benchmark price of related raw materials, the latest price of bulk raw materials, the price difference threshold, and the price fluctuation threshold.

[0095] The latest product prices are encapsulated into a unified interface through a unified interface module, which can be called by procurement execution modules such as procurement plans to improve procurement efficiency.

[0096] This invention offers the following advantages: By constructing a data acquisition module to obtain daily prices of bulk raw materials and recording their agreed-upon benchmark prices, price difference thresholds, and price fluctuation thresholds, and by constructing a price calculation module to determine the types of bulk raw materials to be included in commodity price calculations based on the relationship between the difference between the daily price of a bulk raw material and its corresponding agreed-upon benchmark price and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed-upon benchmark price and the price fluctuation threshold, the latest commodity price is calculated based on the determined bulk raw material types. This achieves automatic, real-time calculation of the latest commodity price in the agreement, improving the efficiency of price calculation and providing more reasonable prices to suppliers and purchasers, thus avoiding losses for both parties. Finally, the price traceability module allows for real-time monitoring of the price calculation process, improving the transparency of commodity procurement pricing.

[0097] Secondly, this invention also provides a method for calculating commodity procurement price fluctuations based on ERP systems. Please refer to [link / reference]. Figure 4 ,include:

[0098] S401. Obtain the daily price of bulk raw materials and record the agreed benchmark price, price difference threshold, and price fluctuation threshold of bulk raw materials.

[0099] S402. Based on the relationship between the difference between the daily price of a bulk raw material and the agreed benchmark price of the corresponding bulk raw material and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold, determine the type of bulk raw material to be included in the commodity price calculation.

[0100] S403. Calculate the latest price of the commodity based on the determined bulk raw material type.

[0101] In this embodiment, by acquiring the daily prices of bulk raw materials and recording the agreed benchmark price, price difference threshold, and price fluctuation threshold of the bulk raw materials, and based on the relationship between the difference between the daily price of the bulk raw materials and the corresponding agreed benchmark price and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold, the types of bulk raw materials to be included in the commodity price calculation are determined. The latest commodity price is calculated based on the determined bulk raw material types, realizing automatic real-time calculation of the latest commodity price in the agreement, improving the efficiency of price calculation, providing more reasonable prices to suppliers and purchasers, and avoiding losses for both parties.

[0102] Those skilled in the art will understand that all or part of the processes in the above embodiments can be implemented by a computer program instructing related hardware. The program can be stored in a computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. The storage medium can be a magnetic disk, optical disk, read-only memory, or random access memory, etc.

[0103] The above description discloses only preferred embodiments of the present invention and should not be construed as limiting the scope of the present invention. Therefore, equivalent variations made in accordance with the claims of the present invention are still within the scope of the present invention.

Claims

1. A commodity procurement price fluctuation calculation device based on ERP, characterized in that, include: Data acquisition module: Used to acquire the daily prices of bulk raw materials and record the agreed benchmark price, price difference threshold, and price fluctuation threshold of bulk raw materials; Price calculation module: used to determine the types of bulk raw materials to be included in the commodity price calculation based on the relationship between the difference between the daily price of bulk raw materials and the agreed benchmark price of the corresponding bulk raw materials and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold, and to calculate the latest commodity price based on the determined types of bulk raw materials; Price traceability module: This module provides a query interface and, based on preset input information, provides feedback on the historical price of the product and the price calculation process.

2. The ERP-based commodity procurement price fluctuation calculation device according to claim 1, characterized in that, The data acquisition module includes a price recording unit, a data update unit, and a product information recording unit; The price recording unit is used to record the agreement benchmark price, price difference threshold, price fluctuation threshold, and daily prices of bulk raw materials. The data update unit is used to update the benchmark price, price difference threshold, and price fluctuation threshold of the agreement in a timely manner according to changes in the content of the preset agreement, and to update the daily price in a timely manner according to the daily price changes of bulk raw materials. The commodity information recording unit is used to record commodity name, commodity code, unit of measurement, raw materials, raw material code, raw material specifications and unit of measurement according to the preset protocol.

3. The ERP-based commodity procurement price fluctuation calculation device according to claim 1, characterized in that, The price calculation module includes a bulk raw material type determination unit and a calculation unit; The bulk raw material type determination unit is used to determine the type of bulk raw material to be included in the commodity price calculation based on the relationship between the difference between the daily price of the bulk raw material and the agreed benchmark price of the corresponding bulk raw material and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold. The calculation unit is used to determine the latest price of a commodity based on a preset algorithm according to the type of bulk raw material.

4. The ERP-based commodity procurement price fluctuation calculation device according to claim 3, characterized in that, The preset algorithm of the computing unit is determined by the following formula: Where: P is the latest price of the product; P0 is the preset agreed price of the product; A i A is the agreed benchmark price for the i-th bulk raw material in the agreement; i0 K represents the daily price of the i-th bulk raw material in the agreement; i This is the coefficient for raw material A.

5. The ERP-based commodity procurement price fluctuation calculation device according to claim 3, characterized in that, The calculation unit calculates the latest price of a commodity in at least the following ways: using the price of the most recent date, using the price of the first natural day of the month, or using the average price of the current month.

6. The ERP-based commodity procurement price fluctuation calculation device according to claim 3, characterized in that, The bulk raw material type determination unit includes: When the difference between the daily price of a bulk raw material and the agreed benchmark price of the corresponding bulk raw material is greater than the price difference threshold, and / or when the price fluctuation between the daily price of a bulk raw material and the agreed benchmark price is greater than the price fluctuation threshold, the bulk raw material is determined to be included in the calculation of the latest commodity price.

7. The ERP-based commodity procurement price fluctuation calculation device according to claim 3, characterized in that, The query interface of the price tracing module includes input condition fields and output result fields; The input conditions include the agreement number, product name, target date, and the calculation method for the latest product price; The output includes agreement information, the benchmark price of the product agreement, the latest price of the product, the calculation process formula, and the raw material details.

8. The ERP-based commodity procurement price fluctuation calculation device according to claim 1, characterized in that, It also includes a unified interface module, which is used to encapsulate the latest price calculation result of the product and send the latest price calculation result of the product to the procurement execution module.

9. The ERP-based commodity procurement price fluctuation calculation device according to claim 8, characterized in that, The input parameters of the unified interface module include protocol ID, product code, date, and the latest price calculation method for the product; The output parameters include the latest price of the commodity and the agreed benchmark price of related raw materials, the latest price of bulk raw materials, the price difference threshold, and the price fluctuation threshold.

10. A method for calculating fluctuations in commodity procurement prices based on ERP, characterized in that, include: Obtain the daily prices of bulk raw materials and record the agreed benchmark price, price difference threshold, and price fluctuation threshold of bulk raw materials; Based on the relationship between the difference between the daily price of a bulk raw material and the agreed benchmark price of the corresponding bulk raw material and the price difference threshold, and / or the relationship between the price fluctuation between the daily price and the agreed benchmark price and the price fluctuation threshold, the types of bulk raw materials to be included in the commodity price calculation are determined. Calculate the latest commodity price based on the identified bulk raw material type.

Images