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

The unit price inquiry device simplifies the process of accessing unit price sources, reducing operational burdens and ensuring accurate pricing by integrating a control unit and memory unit for order and sales data management.

JP7748353B2Active Publication Date: 2025-10-02OBIC CO LTD
View PDF 5 Cites 0 Cited by

Patent Information

Application Number
JP2022194477
Authority / Receiving Office
JP · JP
Patent Type
Patents
Current Assignee / Owner
Filing Date
2022-12-05
Publication Date
2025-10-02
Estimated Expiration
2042-12-05

AI Technical Summary

Technical Problem

Existing systems fail to provide a mechanism for easily inquiring about the source of unit prices during sales transactions, leading to increased burden in checking and potential unintended pricing decisions.

Method used

A unit price inquiry device and method equipped with a control unit and memory unit that allows inputting and registering order and sales data, including the source of unit prices, and displaying inquiry data to facilitate easy access to unit price information.

Benefits of technology

Reduces the burden of checking unit prices by enabling easy inquiry into their sources, preventing unintended pricing, and ensuring accurate billing and payment operations.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure 0007748353000001
    Figure 0007748353000001
  • Figure 0007748353000002
    Figure 0007748353000002
  • Figure 0007748353000003
    Figure 0007748353000003
Patent Text Reader

Abstract

To reduce a load of checking unit prices by making it easy to inquire an acquisition source of the unit prices in sales inquiry.SOLUTION: A unit price inquiry device according to an embodiment comprises: order reception input means which inputs order reception data including an order reception identification number, an order reception classification, an order reception date, a customer, a delivery destination, a supplier, a commodity, a quantity, a unit price, an order reception amount, and an acquisition unit price information source indicating an acquisition source of a unit price depending on an operator's operation on an order reception input screen, and registers them in a storage unit; sales input means which inputs sales data including a sales identification number, a sales classification, an order reception identification number, a sales date, a customer, a delivery destination, a supplier, a commodity, a quantity, a unit price, a sales amount, and an acquisition unit price information source indicating an acquisition source of a unit price depending on an operator's operation on a sales input screen, and registers them in the storage unit; and inquiry means which refers to sales data and order reception data registered in the storage unit and displays sales inquiry data including an acquisition unit price information source of order reception and sales depending on an operator's operation on a sales inquiry screen.SELECTED DRAWING: Figure 2
Need to check novelty before this filing date? Find Prior Art

Description

[Technical Field]

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

[0002] For example, in a transaction of a commodity, the unit price of the commodity is decided in advance with the customer and the transaction is carried out. However, in the actual transaction after the price is decided, there are cases where the transaction does not necessarily proceed according to the decided unit price. For example, Patent Document 1 is a conventional system for inquiring about the unit price of a commodity. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2011-22764 Summary of the Invention [Problem to be solved by the invention]

[0004] However, Patent Document 1 does not state anything about inquiring about the source of unit prices when inquiring about sales.

[0005] The present invention has been made in consideration of the above, and aims to provide a unit price inquiry device, a unit price inquiry method, and a unit price inquiry program that can reduce the burden of checking unit prices by making it possible to easily inquire about the source of unit prices when making sales inquiries. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a unit price inquiry device equipped with a control unit and a memory unit, wherein the control unit is characterized by comprising: an order input means for inputting order data including an order identification number, order category, order date, customer, delivery destination, supplier, product, quantity, unit price, order amount, and an acquired unit price information source indicating the source of the unit price in response to an operator's operation on an order input screen, and registering the same in the memory unit; a sales input means for inputting sales data including a sales identification number, sales category, order identification number, sales date, customer, delivery destination, supplier, product, quantity, unit price, sales amount, and an acquired unit price information source indicating the source of the unit price in response to an operator's operation on a sales input screen, and registering the same in the memory unit; and an inquiry means for displaying sales inquiry data including the acquired unit price information source for orders and sales by referring to the sales data and order data registered in the memory unit in response to an operator's operation on the sales inquiry screen.

[0007] According to another aspect of the present invention, the source of the acquired unit price information may include a unit price master, an estimate, or manual input.

[0008] According to another aspect of the present invention, the storage unit stores a unit price control transaction category master in which transaction categories subject to unit price control are registered, a product master in which products are registered in association with unit price control categories specifying whether or not they are subject to unit price control, and a unit price master in which at least customers, delivery destinations, application periods, products, quantities as units of unit prices, and unit prices are associated with each other, the order data and the sales data include unit price control target information indicating whether or not they are subject to unit price control, the sales inquiry data includes unit price control target information for orders and sales, and the order input means is configured to input order data and sales data. If the category is registered in the transaction category of the unit price control transaction category master, and the product's unit price control category is subject to unit price control by referring to the product master, unit price control is performed, and the sales input means performs unit price control if the sales category is registered in the transaction category of the unit price control transaction category master, and the product's unit price control category is subject to unit price control by referring to the product master, and in the unit price control, the screen may be controlled so that the unit price obtained from the unit price master and the amount calculated by multiplying the obtained unit price by the quantity cannot be entered or changed on the input screen.

[0009] According to another aspect of the present invention, in the unit price control, if there is no target unit price in the unit price master on the input screen, an error message may be displayed.

[0010] According to one aspect of the present invention, the unit price master includes a customer-delivery-destination commodity unit price master in which a customer, a delivery destination, an application period, a commodity, a quantity which is a unit of the unit price, and a unit price are associated and registered, and a customer-delivery-destination-supplier commodity unit price master in which a customer, a delivery destination, a supplier, an application period, a commodity, a quantity which is a unit of the unit price, and a unit price are associated and registered, and the order input means uses the commodity, the customer, the delivery destination, and the order date as keys to register the customer-delivery-destination commodity unit price master. The sales input means may acquire the unit price from the master, and may also acquire the unit price from the customer-delivery-supplier-specific product unit price master using the product, customer, delivery destination, supplier, and order date as keys, and the sales input means may acquire the unit price from the customer-delivery-supplier-specific product unit price master using the product, customer, delivery destination, supplier, and sales date as keys, and may also acquire the unit price from the customer-delivery-supplier-specific product unit price master using the product, customer, delivery destination, supplier, and sales date as keys.

[0011] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides a unit price inquiry method executed by an information processing device equipped with a control unit, comprising: an order input process executed by the control unit, which inputs order data including an order identification number, order category, order date, customer, delivery destination, supplier, product, quantity, unit price, order amount, and an acquired unit price information source indicating the source of the unit price in accordance with operator operations on an order input screen, and registers the input data in a memory unit; a sales input process which inputs sales data including a sales identification number, sales category, order identification number, sales date, customer, delivery destination, supplier, product, quantity, unit price, sales amount, and an acquired unit price information source indicating the source of the unit price in accordance with operator operations on a sales input screen, and registers the input data in the memory unit; and a inquiry process which displays sales inquiry data including the acquired unit price information source for orders and sales by referring to the sales data and order data registered in the memory unit in accordance with operator operations on the sales inquiry screen.

[0012] In addition, in order to solve the above-mentioned problems and achieve the object, the present invention provides a unit price inquiry program to be executed by an information processing device having a control unit, the unit price inquiry program being characterized by executing the following steps executed by the control unit: an order input process for inputting order data including an order identification number, order category, order date, customer, delivery destination, supplier, product, quantity, unit price, order amount, and an acquired unit price information source indicating the source of the unit price in accordance with operator operations on an order input screen, and registering the input in a memory unit; a sales input process for inputting sales data including a sales identification number, sales category, order identification number, sales date, customer, delivery destination, supplier, product, quantity, unit price, sales amount, and an acquired unit price information source indicating the source of the unit price in accordance with operator operations on a sales input screen, and registering the input in a memory unit; and a inquiry process for displaying sales inquiry data including the acquired unit price information source for orders and sales by referring to the sales data and order data registered in the memory unit in accordance with operator operations on the sales inquiry screen. [Effects of the Invention]

[0013] According to the present invention, by making it possible to easily inquire about the source of unit prices when inquiring about sales, it is possible to reduce the burden of checking unit prices. [Brief explanation of the drawings]

[0014] [Figure 1] FIG. 1 is a diagram for explaining the appropriate unit price inquiry function and the appropriate unit price control function of this embodiment. [Figure 2] FIG. 2 is a block diagram showing an example of a unit price inquiry device according to this embodiment. [Figure 3] FIG. 3 is a diagram showing an example of the configuration of the customer / delivery destination / supplier-specific product unit price master. [Figure 4] FIG. 4 is a diagram showing an example of the configuration of the customer delivery destination-specific product unit price master. [Figure 5] FIG. 5 is a diagram showing an example of the configuration of the unit price control transaction classification master. [Figure 6] FIG. 6 is a diagram illustrating an example of the configuration of the product master. [Figure 7]FIG. 7 is a flowchart for explaining an outline of the overall processing flow of the control unit of the unit price inquiry device. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the processing of the control unit of the unit price inquiry device. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the process of the control unit of the unit price inquiry device. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the processing of the control unit of the unit price inquiry device. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the processing of the control unit of the unit price inquiry device. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the processing of the control unit of the unit price inquiry device. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the processing of the control unit of the unit price inquiry device. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the processing of the control unit of the unit price inquiry device. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the processing of the control unit of the unit price inquiry device. [Figure 16] FIG. 16 is a diagram for explaining a specific example of the processing of the control unit of the unit price inquiry device. DETAILED DESCRIPTION OF THE INVENTION

[0015] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.

[0016] [1. Overview] In actual transactions after price determination, there are cases where transactions do not necessarily proceed according to the determined unit price (e.g., when returning goods, issuing red slips, discounts, etc.). As a result, pricing decisions that managers did not intend may occur even before sales are recorded, and the complicated checking work involved in billing and payment operations is a common operational issue in the industry.

[0017] Therefore, in this embodiment, the burden of checking unit prices is reduced by making it possible to easily inquire about the source of unit prices when inquiring about sales.

[0018] Specifically, the unit price inquiry device of this embodiment has (1) a fair unit price inquiry function and (2) a unit price control function. Figure 1 shows the unit price inquiry device of this embodiment, which has (1) a fair unit price inquiry function and (2) a unit price control function. Figure 1 is a diagram for explaining the (1) fair unit price inquiry function and (2) unit price control function.

[0019] (1) The appropriate unit price inquiry function allows you to check the details of the invoice after it has been recorded in the sales inquiry / purchase inquiry, etc., from the following two perspectives: (A) Unit price control possibility: You can check whether the details were subject to unit price control, and (B) Acquisition unit price: You can check whether the acquisition unit price was obtained from the unit price master.

[0020] (2) The unit price control function links the unit price for each trade that the sales representative agreed upon at the contract stage of the transaction according to the conditions at the time of receiving an order / placing an order / sales / purchasing, etc. to the accounting screen after receiving an order. Specifically, at the time of receiving an order / placing an order / sales / purchasing, depending on the trade and product, screen control is entered that prevents changes on the screen in the unit price and amount items, and if the unit price has not been obtained, it is controlled so that it cannot be recorded, but if the unit price master is available, it is controlled so that it can be recorded.

[0021] According to this embodiment, it is possible to prevent, check, and determine whether unit prices have been omitted due to operation or whether unintended unit prices have been acquired due to master setting errors. It is also possible to realize system assistance for early understanding of accurate unit prices and amounts, prevention of erroneous billing and payment operations, and speeding up billing operations. This also leads to the independence of users, without relying on inquiries and investigations to vendors.

[0022] The unit price inquiry device of this embodiment can be widely applied to any business type or industry that requires unit price estimates, and is useful, for example, when the prices of chemical products and the like fluctuate greatly, to confirm whether work is being carried out accurately based on the unit price agreed upon with the customer.

[0023] [2. Configuration] An example of the configuration of the unit price inquiry device according to this embodiment will be described with reference to the drawings.

[0024] 2 is a block diagram showing an example of a unit price inquiry device according to this embodiment. The unit price inquiry device 100 is a workstation, a commercially available desktop personal computer, or the like.

[0025] The unit price inquiry device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units comprised in the unit price inquiry device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0026] The communication interface unit 104 communicably connects the unit price inquiry 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 inquiry 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). As a result, the communication interface unit 104 is configured to be able to communicate data with the server 200 via the network 300.

[0027] 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 functions as a pointing device in cooperation with a mouse. 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.

[0028] Various databases, tables, files, etc. are stored in the storage unit 106. Computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes are recorded in the storage unit 106. 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, an optical disk, etc.

[0029] The storage unit 106 also includes a customer-delivery-supplier-specific product unit price master 106a, a customer-delivery-supplier-specific product unit price master 106b, a unit price control transaction category master 106c, a product master 106d, and a data table 106e. Fig. 3 is a diagram showing an example of the configuration of the customer-delivery-supplier-specific product unit price master 106a. Fig. 4 is a diagram showing an example of the configuration of the customer-delivery-supplier-specific product unit price master 106b. Fig. 5 is a diagram showing an example of the configuration of the unit price control transaction category master 106c. Fig. 6 is a diagram showing an example of the configuration of the product master 106d.

[0030] The customer, delivery destination, and supplier-specific product unit price master 106a can be composed of a table or the like that associates and registers customer, delivery destination, supplier, application period (application start date, application end date), product, quantity, and unit price, as shown in Figure 3.

[0031] The customer delivery destination-specific product unit price master 106b can be composed of a table or the like that associates and registers customer, delivery destination, application period (application start date, application end date), product, quantity less than, and unit price, as shown in Figure 4.

[0032] The unit price control transaction category master 106c is a master for setting the data category and transaction category that are subject to unit price control, and can be composed of a table or the like in which data categories and transaction categories are registered in association with each other, as shown in Figure 5.

[0033] The product master 106d is a master for setting whether or not to perform unit price control for each product, and can be configured as a table or the like in which product codes, product names, and unit price control classifications that specify whether or not to perform unit price control ("0: Yes" for unit price control, "0: No" for unit price control not) are associated and registered, as shown in Figure 6.

[0034] The data table 106e is a table for storing various data such as quotation data, order data, and sales data.

[0035] The quotation data may include a quotation identification number (quote number, line number), quotation category, business establishment, quotation date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, and unit price information source indicating the source of the unit price.

[0036] The order data may include an order identification number (order number, line number), order category, business establishment, order date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, quotation identification number (quote number, quotation line number), unit price control target information indicating whether the item is subject to unit price control, and acquired unit price information source indicating the source from which the unit price was obtained.

[0037] Sales data may include a sales identification number (sales number, line number), sales category, business establishment, sales date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, order identification number (order number, order line number), unit price control target information indicating whether or not the item is subject to unit price control, and acquired unit price information source indicating the source from which the unit price was obtained.

[0038] The control unit 102 is a CPU or the like that comprehensively controls the unit price inquiry 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.

[0039] The control unit 102 is configured to be able to access the customer-delivery-supplier-specific product unit price master 106a, the customer-delivery-specific product unit price master 106b, the unit price control transaction category master 106c, the product master 106d, the data table 106e, and the like, which are stored in the memory unit 106. Note that the customer-delivery-supplier-specific product unit price master 106a, the customer-delivery-specific product unit price master 106b, the unit price control transaction category master 106c, the product master 106d, and the data table 106e may be provided in another location (for example, the server 200) as long as they are accessible by the control unit 102.

[0040] The control unit 102 has an appropriate unit price inquiry function and a unit price control function, and functionally comprises an estimate input unit 102a, an order input unit 102b, a sales input unit 102c, an inquiry unit 102d, a screen display control unit 102e, and a master maintenance unit 102f.

[0041] The quotation input unit 102a inputs quotation data including quotation number, line number, quotation category, business establishment, quotation date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, and acquisition unit price information source in response to, for example, an operator's operation on the quotation input screen displayed on the monitor 114, and registers the input data in the data table 106e.

[0042] The order input unit 102b inputs order data including the order identification number, order classification, order date, customer, delivery destination, supplier, product, quantity, unit price, order amount, and unit price information source indicating the source of the unit price in response to, for example, an operator's operation on the order input screen displayed on the monitor 114, and registers the data in the data table 106e.

[0043] The sales input unit 102c inputs sales data including the sales identification number, sales category, order identification number, sales date, customer, delivery destination, supplier, product, quantity, unit price, sales amount, and unit price information source indicating the source of the unit price, in response to, for example, an operator's operation on the sales input screen displayed on the monitor 114, and registers the data in the data table 106e.

[0044] For example, in response to an operator's operation on the sales inquiry screen displayed on the monitor 114, the inquiry unit 102d refers to the sales data and order data registered in the data table 106e and displays sales inquiry data including the source of acquisition price information at the time of order and sale.

[0045] The source of the acquired unit price information may include a unit price master, an estimate, or manual input.

[0046] The order data and sales data may include unit price control target information indicating whether or not the data is subject to unit price control, and the sales inquiry data may further include unit price control target information for the orders and sales. The order input unit 102b performs unit price control if the order category is registered in the transaction category of the unit price control transaction category master 106c and the product unit price control category is subject to unit price control by referring to the product master 106d, and the sales input unit 102c performs unit price control if the sales category is registered in the transaction category of the unit price control transaction category master 106c and the product unit price control category is subject to unit price control by referring to the product master 106d, and the unit price control screen may be controlled so that the unit price obtained from the unit price master and the amount calculated by multiplying the obtained unit price by the quantity cannot be input or changed on the input screen.

[0047] In addition, in the unit price control, if there is no target unit price in the unit price master on the input screen, an error message may be displayed.

[0048] The unit price master may include a customer-delivery-specific product unit price master 106b and a customer-delivery-supplier-specific product unit price master 106a, and the order input unit 102b may acquire the unit price from the customer-delivery-specific product unit price master 106b using the product, customer, delivery destination, and order date as keys, and may also acquire the unit price from the customer-delivery-supplier-specific product unit price master 106a using the product, customer, delivery destination, supplier, and order date as keys. The sales input unit 102c may acquire the unit price from the customer-delivery-specific product unit price master 106b using the product, customer, delivery destination, and sales date as keys, and may also acquire the unit price from the customer-delivery-supplier-specific product unit price master 106a using the product, customer, delivery destination, supplier, and sales date as keys.

[0049] The screen display control unit 102e controls the display of various screens (for example, a master maintenance screen, an estimate input screen, an order input screen, a sales input screen, a sales inquiry screen, etc.) displayed on the monitor 114 and the reception of inputs.

[0050] The master maintenance section 102f is used to input, add, change, update, etc. data to the customer delivery destination / supplier product unit price master 106a, the customer delivery destination / supplier product unit price master 106b, the unit price control transaction category master 106c, and the product master 106d in response to operator operations on a master maintenance screen (not shown).

[0051] [3. Specific Examples] A specific example of the processing of the control unit 102 of the unit price inquiry device 100 according to this embodiment will be described with reference to FIGS.

[0052] (3-1. Overall processing) 7 is a flowchart for explaining an outline of the overall processing flow of the control unit 102 of the unit price inquiry device 100. The outline of the overall processing flow of the control unit 102 of the unit price inquiry device 100 will be explained with reference to FIG.

[0053] The estimate input unit 102a executes estimate input processing (step S1). Specifically, in the estimate input processing, the estimate input unit 102a inputs estimate data including the estimate number, line number, estimate category, business establishment, estimate date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, and unit price information source indicating the source of the unit price in response to, for example, an operator's operation on the estimate input screen displayed on the monitor 114, and registers the data in the data table 106e.

[0054] The order input unit 102b executes an order input process (step S2). Specifically, in the order input process, the order input unit 102b inputs order data including an order identification number, order classification, order date, customer, delivery destination, supplier, product, quantity, unit price, order amount, unit price control target information indicating whether the product is subject to unit price control or not, and acquired unit price information source indicating the source of the unit price, in response to, for example, an operation by an operator on an order input screen displayed on the monitor 114, and registers the input data in the data table 106e.

[0055] The sales input unit 102c executes a sales input process (step S3). Specifically, in the sales input process, the sales input unit 102c inputs sales data including a sales identification number, a sales category, an order identification number, a sales date, a customer, a delivery destination, a supplier, a product, a quantity, a unit price, a sales amount, unit price control target information indicating whether or not the product is subject to unit price control, and an acquired unit price information source indicating the source of the unit price, in response to, for example, an operator's operation on a sales input screen displayed on the monitor 114, and registers the input data in the data table 106e.

[0056] The inquiry unit 102d executes a sales inquiry process (step S4). Specifically, in the sales inquiry process, the inquiry unit 102d, for example, in response to an operator's operation on a sales inquiry screen displayed on the monitor 114, references the sales data and order data registered in the data table 106e, and displays sales inquiry data including unit price control target information and acquisition unit price information source at the time of order receipt and sale.

[0057] (3-2. Sample data) Specific examples of processing by the control unit 102 of the unit price inquiry device 100 will be described with reference to Fig. 8 to Fig. 16. Fig. 8 to Fig. 16 are diagrams for explaining specific examples of processing by the control unit 102 of the unit price inquiry device 100. In the following explanation, for the sake of convenience, NO is attached to the master and data.

[0058] (Prerequisite data) It is assumed that the master data shown in FIG. 8 is registered in advance in the storage unit 106.

[0059] 8(A) is a diagram showing an example of the configuration of the customer-delivery-supplier-specific product unit price master 106a. The customer-delivery-supplier-specific product unit price master 106a has the following fields: customer, delivery destination, supplier, application period (application start date, application end date), product, quantity, and unit price. In the example shown in the figure, the first line contains customer "TK001," delivery destination "NOU001," supplier "SR001," application start date "2022 / 5 / 1," application end date "2022 / 12 / 31," product "SH01 (ammonia)," quantity "1 case," and unit price "¥1,200."

[0060] 8(B) is a diagram showing an example of the configuration of the customer delivery destination-specific product unit price master 106b. The customer delivery destination-specific product unit price master 106b has the following fields: customer, delivery destination, application period (application start date, application end date), product, quantity less than, and unit price. In the example shown in the figure, the first line contains customer "TK001," delivery destination "NOU001," application start date "2022 / 5 / 1," application end date "2022 / 7 / 19," product "SH01 (ammonia)," quantity less than "10 cases," and unit price "¥1,000."

[0061] Figure 8(C) is a diagram showing an example of the configuration of the unit price control transaction category master 106c. The unit price control transaction category master 106c has items for data category and transaction category. In the example shown in the figure, the first row has data category "20 (order)" and transaction category "10 (inventory order)", the second row has data category "20 (order)" and transaction category "20 (direct delivery)", the third row has data category "40 (sales)" and transaction category "10 (inventory sales)", and the fourth row has data category "40 (sales)" and transaction category "20 (direct delivery)".

[0062] 8(C) is a diagram showing an example of the configuration of the product master 106d. The product master 106d includes items such as a product code, a product name, and a unit price control category that specifies whether or not to control the unit price ("0: Yes" for unit price control, and "0: No" for unit price control). In the example shown in the figure, the first line has the product code "SH01", the product name "ammonia", and the unit price control category "0 (yes)", the second line has the product code "SH02", the product name "nitric acid", and the unit price control category "0 (yes)", the third line has the product code "SH03", the product name "container", and the unit price control category "1 (no)", the fourth line has the product code "SH04", the product name "container", and the unit price control category "1 (no)", the fifth line has the product code "SH05", the product name "can", and the unit price control category "1 (no)", and the sixth line has the product code "SH06", the product name "soda", and the unit price control category "0 (yes)".

[0063] (Price control function) The unit price control function of the control unit 102 will be described with reference to FIGS.

[0064] If the information entered on the input screen matches the following two conditions, unit price control will be performed. If unit price control is performed, the unit price control target information in the order data and sales data will be marked as "target." On the other hand, if unit price control is not performed, it will be marked as "not target." (1) When the order classification and sales classification to be entered are registered as transaction classifications in the unit price control transaction classification master 106c

[0065] (2) When a product is selected for which the unit price control classification (0: Yes / 1: No) of the product master 106d is "0: Yes"

[0066] When unit price control is performed, screen input control and error control are performed.

[0067] (1) Screen input control controls the input screen so that the unit price and amount items cannot be entered or changed. (2) In error control, if there is no target unit price master when obtaining the unit price, which is processed when entering the quantity on the detail screen, an error message is displayed, such as "There is no unit price master that can be obtained. Please check the unit price master."

[0068] With reference to Figures 9 and 10, a case where unit price control is performed on the order entry screen will be described. Figure 9(A) is a diagram showing an example of data in the unit price control transaction category master 106c. Figure 9(B) is a diagram showing an example of data in the product master 106d. Figure 10(A) is a diagram showing an example of the display of the main screen of the order entry screen. Figure 10(B) is a diagram showing an example of the display of the details screen of the order entry screen. Here, an example will be described where the unit price control conditions are met (where the unit price and amount items are controlled on the details screen).

[0069] As shown in Figure 10(A), the main screen of the order entry screen has a header section for inputting the business establishment, order date, expected sales date, customer, person in charge, and delivery destination, and a details section for displaying order details (line, order category (transaction category), inventory order, quantity, detail summary, product, unit price, supplier). When a registration button (not shown) is pressed, order data according to the input contents is registered in data table 106e.

[0070] In the example shown in the figure, the following information has been entered: business location "T100", order date "2022 / 7 / 10", expected sales date "2022 / 7 / 16", customer "TK001", person in charge "TAN001", and delivery destination "NOU001".

[0071] When you select the details section (for example, by double-clicking), a details screen like the one shown in Figure 10(B) will be displayed. The details screen has fields for entering the following items: line number, order type (transaction type), product, supplier, quantity, unit price, amount, and details summary. After entering data in each field, press the Confirm button (not shown) to set the entered information in the details section of the main screen.

[0072] Here, as shown in Figure 10(B), the row number "1", order type (transaction type) "10 Stock Order", product "SH01 Ammonia", and quantity "2 cases" are entered. In the unit price control transaction type master 106c shown in Figure 9(A), the transaction type "10 (Stock Order)" is set, and in the product master 106d shown in Figure 9(B), the unit price control type "0 (Yes)" is set for the product "SH01 Ammonia", so unit price control is performed. Using the customer "TK001," delivery destination "NOU001," order date "2022 / 7 / 10," and product "SH01 Ammonia" as keys, the unit price "1,000 yen" is retrieved from the customer delivery destination product unit price master 106b in Figure 8(A) (the order date "2022 / 7 / 10" falls within the application period "2022 / 5 / 1 - 2022 / 7 / 19" of the customer delivery destination product unit price master 106b). The amount = unit price "1,000" x quantity "2" = 2,000 yen is calculated, and the unit price "1,000 yen" and amount "2,000 yen" are automatically displayed on the details screen. These unit prices and amounts cannot be changed. In this case, the unit price control target information for the order data is "target," and the source of the retrieved unit price information is the "customer delivery destination product unit price master."

[0073] Unit price control on the sales input screen will be described with reference to Figure 11. Figure 11(A) is a diagram showing example data in the unit price control transaction category master 106c. Figure 11(B) is a diagram showing example data in the product master 106d. Figure 12(A) is a diagram showing an example display of the main screen of the sales input screen. Figure 12(B) is a diagram showing an example display of the details screen of the sales input screen. Here, an example will be described where the unit price control conditions are not met (where control of the unit price and amount items is not performed on the details screen).

[0074] As shown in Figure 12(A), the sales input screen has a header section for inputting the business establishment, sales date, customer, person in charge, and delivery destination, and a details section for displaying order details (line, sales category (transaction category), quantity, summary of details, product, unit price, supplier). When the register button (not shown) is pressed, sales data according to the input contents is registered in data table 106e.

[0075] In the example shown in the figure, the business establishment "T100", sales date "2022 / 7 / 22", customer "TK001", person in charge "TAN001", and delivery destination "NOU001" have been entered.

[0076] When you select the details section (for example, by double-clicking), a details screen like the one shown in Figure 12(B) will be displayed. The details screen has fields for entering the following items: line number, sales category (transaction category), product, supplier, quantity, unit price, amount, and details summary. After entering data in each field, press the Confirm button (not shown) to set the entered information in the details section of the main screen.

[0077] Here, as shown in Figure 12(B), if row number "1", sales category (transaction category) "30 Returned Goods", product "SH01 Ammonia", and quantity "2 cases" are entered, unit price control will not be performed because data transaction category "30 (Returned Goods)" is not set in the unit price control transaction category master 106c shown in Figure 11(A). The unit price "1,000 yen" and amount "-2,000" can be entered by the operator. In this case, the unit price control target information for the sales data will be "Not applicable", and the acquisition unit price information source will be "Manual input".

[0078] (Fair price inquiry function) The appropriate unit price inquiry function of the control unit 102 will be described. The fair unit price inquiry function allows you to check the details of the recorded invoice from the following two aspects (1) and (2). (1) It is possible to check whether the item was subject to unit price control by checking the unit price control target information.

[0079] (2) It is possible to check whether the acquisition unit price was obtained from the unit price master in the acquisition unit price information source. In "Source of acquired unit price information", the acquired unit price master name is displayed.

[0080] For order data and sales data, the source of unit price information is obtained in the following order of priority. (1) Obtained from the unit price master Obtain the matching master name based on the unit price master key information (application start date, application end date, customer, delivery destination, supplier, quantity, product, unit price) stored in the data. The order of retrieving unit price master data is to prioritize the unit price master data with the most key information. In this example, the order is customer delivery destination / supplier-specific product unit price master data 106a > customer delivery destination-specific product unit price master data 106b. Regarding the application start date and application end date, the matching condition is that the recording date of the recording data is greater than or equal to the application start date and less than or equal to the application end date.

[0081] (2) Obtained from unit price master (past unit price) Based on the unit price master key information (accounting date, customer, delivery destination, supplier, quantity, product, unit price) stored in the data, the matching master name that holds the latest application start date in the application period prior to the accounting date is obtained. The unit price master is obtained in order of priority from the unit price master with the most key information. In this example, the order is customer-delivery-destination-supplier-specific product unit price master 106a > customer-delivery-destination-specific product unit price master 106b. If there is no master where the accounting date of the accounting data is greater than or equal to the application start date and less than or equal to the application end date, the matching condition is that the unit price master key information other than the accounting date matches.

[0082] (3) Obtained from order data and quotation data If the unit price of the details matches the document number and line number of the source data held by the data (e.g., for sales, it is quotation → order → sales, for orders, it is quotation → order), the corresponding source document number and line number will be displayed.

[0083] (4) Other (4) The administrator can check the unit price master data for the site.

[0084] 13 to 16, the process from quotation to sales inquiry will be described with reference to sample data.

[0085] (S1: Estimate input processing) The quotation input unit 102a inputs quotation data including quotation number, line number, quotation category, business establishment, quotation date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, and acquisition unit price information source in response to an operator's operation on the quotation input screen displayed on the monitor 114, and registers the input data in the data table 106e.

[0086] Figure 13 is a diagram showing an example of quotation data. The quotation data has the following fields: quotation number, line number, quotation category, business establishment, quotation date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, and unit price information source. In the example shown in the figure, the first line has the quotation number "MM001," line number "1," quotation category "direct delivery," business establishment "T100," quotation date "2022 / 7 / 8," person in charge "TAN001," customer "TK002," delivery destination "NOU02," supplier "SR001," product "SH03 (container)," quantity "30 cases," unit price "¥900," amount "¥27,000," and unit price information source "manual input."

[0087] (S2: Order entry) The order input unit 102b inputs order data including the order number, line number, order category, business establishment, order date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, quotation number, quotation line number, unit price control target information, and acquisition unit price information source in response to the operator's operations on the order input screen displayed on the monitor 114, and registers the data in the data table 106e.

[0088] 14 is a diagram showing an example of order data. The order data includes the following fields: order number, line number, order category, business establishment, order date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, quotation number, quotation line number, unit price control target information, and acquisition unit price information source.

[0089] Order number "JJ001", line number "1", order category "Order", business location "T100", order date "2022 / 7 / 10", person in charge "TAN001", customer "TK001", delivery destination "NOU01", supplier "-", product "SH01 (ammonia)", quantity "2 cases", unit price "¥1,000", amount "¥2,000", quotation number "-", quotation line number "-", unit price control target information "Target", source of unit price information to be obtained "Product unit price master by customer delivery destination".

[0090] (S3: Sales input) The sales input unit 102c inputs order data including sales number, line number, sales category, business establishment, sales date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, order number, order line number, unit price control target, and acquisition unit price information source in accordance with the operator's operations on the sales input screen displayed on the monitor 114, and registers the data in the data table 106e.

[0091] 15 is a diagram showing an example of sales data. The sales data includes the following fields: sales number, line number, sales category, business establishment, sales date, person in charge, customer, delivery destination, supplier, product, quantity, unit price, amount, order number, order line number, unit price control target, and acquisition unit price information source.

[0092] In the example shown in the figure, the first row has the sales number "MT001," row number "1," sales category "inventory sales," business location "T100," order date "2022 / 7 / 10," person in charge "TAN001," customer "TK001," delivery destination "NOU01," supplier "-," product "SH01 (ammonia)," quantity "2 cases," unit price "¥1,000," amount "¥2,000," order number "JJ001," order row number "1," unit price control target information "Target," and acquisition unit price information source "Product unit price master by customer delivery destination."

[0093] (S3: Sales inquiry processing) In response to the operator's operations on the sales inquiry screen displayed on the monitor 114, the inquiry unit 102d refers to the sales data and order data registered in the data table 106e and displays sales inquiry data including unit price control target information and the source of acquisition unit price information at the time of order and sale.

[0094] FIG. 16 is a diagram showing a display example of sales inquiry data. The sales inquiry data is This adds information on the unit price control targets and the source of unit price information at the time of order and sales.

[0095] Explain the key points of sales inquiries. (1) Check the details that are not subject to unit price control in the "Unit Price Control Information" field. (2) The administrator can only check on-site the documents that have the "manual input" setting in the "source of acquisition unit price information" item. (3) The items "Unit Price Control Target Information (Orders)," "Acquired Unit Price Information Source (Orders)," "Unit Price Control Target Information (Sales)," and "Acquired Unit Price Information Source (Sales)" allow you to check the control status and unit price acquisition information at the time of recording on each screen. This takes into account cases where unit price master data is modified or deleted based on the latest information.

[0096] The unit price control target information and the source of acquired unit price information for Nos. 34 to 42 of the sales inquiry data will be explained.

[0097] (Regarding No. 34 / 35) 1. Price control target information (1) The sales category of the sales data No. 34 / 35 is registered as the transaction category of No. 27 in the unit price control transaction category master 106c, so the condition is met. (2) The product in the sales data No. 34 / 35 satisfies the condition because the unit price control classification in the product master 106d of No. 29 / 30 is "0: Yes." ⇒Since the conditions (1) and (2) are met, the "Unit Price Control Target Information" in the sales inquiry is displayed as "Target."

[0098] 2. Source of acquisition cost information (1) Obtained from the unit price master The sales data of No. 34 / 35 does not match No. 19 / 20 in the customer / delivery / supplier-specific product unit price master 106a, but matches No. 21 / 22 in the customer / delivery-specific product unit price master 106b. →From (1), the "Source of Acquisition Price Information" in the sales inquiry is displayed as the acquisition price master name, "Product Unit Price Master by Customer Delivery Destination."

[0099] (Regarding No. 36 / 37) 1. Price control target information (1) The sales category of the sales data No. 36 / 37 is registered as No. 28 in the unit price control transaction category master 106c, so the condition is met. (2) The conditions for the products in the sales data for No. 36 / 37 do not match because the unit price control category in the product master 106d for No. 31 / 32 is 1 (none). →Since the condition (2) is not met, the "Unit Price Control Target Information" in the sales inquiry is displayed as "Not applicable."

[0100] 2. Source of acquisition cost information (1) Obtained from the unit price master The sales data for No. 36 / 37 does not match No. 19 / 20 in the customer delivery destination product unit price master 106a, nor does it match No. 21 to 24 in the customer delivery destination product unit price master 106b. (2) Obtained from unit price master (past unit price) The sales data for No. 36 / 37 does not match No. 19 / 20 in the customer delivery destination product unit price master 106a, nor does it match No. 21-24 in the customer delivery destination product unit price master 106b. (3) Obtained from order data and quotation data You can check order data No. 5 / 6 linked to sales data No. 12 / 13. You can check quotation data No. 1 / 2 linked to order data No. 5 / 6. You can confirm that the unit prices of sales data No. 12 / 13 and quotation data No. 1 / 2 match. →From (3), the "Source of Acquired Unit Price Information" in the sales inquiry is displayed as "Quote (Quote Number) - (Quote Line Number)", which is the source data of the acquired unit price.

[0101] (Regarding No. 41) 1. Information on whether unit price control is possible (1) The sales category of the sales data No. 41 is not registered in the unit price control transaction category master 106c, so it does not match the conditions. (2) The product in the sales data No. 41 matches the condition because the unit price control category in the product master 106d No. 29 is 0 (Yes). →Since the condition (1) is not met, the "Unit Price Control Target Information" in the sales inquiry is displayed as "Not applicable."

[0102] 2. Source of acquisition cost information (1) Obtained from the unit price master The sales data of No. 41 does not match No. 19 / 20 in the customer / delivery destination / supplier-specific product unit price master 106a. Also, the application period does not match No. 21 in the customer / delivery destination-specific product unit price master 106b. (2) Obtained from unit price master (past unit price) The sales data of No. 41 matches the unit price information key of No. 21 in the customer delivery destination-specific product unit price master 106b except for the applicable period. →From (2), the "Source of Acquisition Price Information" in the sales inquiry is displayed as the acquisition price master name, "Product Unit Price by Customer Delivery Destination (Past Unit Price)."

[0103] (Regarding No. 42) 1. Price control target information (1) The sales category of the sales data No. 42 is not registered in the unit price control transaction category master 106c, so it does not match the conditions. (2) The product in the sales data for No. 42 matches the conditions because the unit price control category is 0 (Yes) for No. 30 in the product master. →Since the condition (1) is not met, the "Price control target" in the sales inquiry is displayed as "Not applicable."

[0104] 2. Source of acquisition cost information (1) Obtained from the unit price master The sales data for No. 42 does not match No. 19 / 20 in the customer delivery destination product unit price master 106a. Also, the applicable period does not match No. 23 in the customer delivery destination product unit price master 106b. (2) Obtained from unit price master (past unit price) There is no matching unit price master with unit price master information key other than the applicable period for the sales data of No. 42. It does not match No. 21-24 of the customer delivery destination product unit price master 106b. (3) Obtained from order data and quotation data It can be confirmed that there is no order data or quotation data linked to the sales data of No. 42. (4) Other Since (1) to (3) are not met, condition (4) is met. →(4) As a result, the "Source of Acquired Unit Price Information" in the sales inquiry will be displayed as "Manual Input."

[0105] As described above, according to this embodiment, the system is provided with the order input unit 102b which inputs order data including the order identification number, order category, order date, customer, delivery destination, supplier, product, quantity, unit price, order amount, and an acquired unit price information source indicating the source of the unit price in response to an operator's operation on the order input screen, and registers the data in the data table 106e; the sales input unit 102c which inputs sales data including the sales identification number, sales category, order identification number, sales date, customer, delivery destination, supplier, product, quantity, unit price, sales amount, and an acquired unit price information source indicating the source of the unit price in response to an operator's operation on the sales input screen, and registers the sales data in the data table 106e; and the inquiry unit 102d which references the sales data and order data registered in the data table 106e in response to an operator's operation on the sales inquiry screen, and displays sales inquiry data including the acquired unit price information source for orders and sales. Therefore, by making it possible to easily inquire about the source of unit price in a sales inquiry, it is possible to reduce the workload of checking unit prices.

[0106] [4. 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 contributing to the achievement of SDGs Goals 8 and 9.

[0107] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0108] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

[0109] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0110] 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 known methods.

[0111] Furthermore, 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 drawings can be changed as desired unless otherwise specified.

[0112] Furthermore, with regard to the unit price inquiry device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0113] For example, all or any part of the processing functions of the unit price inquiry device 100, particularly the processing functions performed by the control unit, may be realized 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-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the unit price inquiry device 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.

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

[0115] Furthermore, the 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, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0116] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single program, but also includes programs that are distributed as multiple modules or libraries, or programs that achieve their functions by working together with other programs, such as an OS. Note that the specific configurations and reading procedures for reading a recording medium in each device shown in the embodiments, as well as the installation procedures after reading, can use well-known configurations and procedures.

[0117] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0118] The unit price inquiry 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 inquiry device 100 may also be realized by installing software (including programs or data) that causes the device to perform the processing described in this embodiment.

[0119] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]

[0120] 100 Unit price inquiry device 102 Control section 102a Estimate input section 102b Order entry section 102c Sales input section 102d Enquiry Section 102e Screen display control unit 102f Master Maintenance Department 104 Communication interface unit 106 Storage section 106a Customer delivery destination supplier product unit price master 106b Customer delivery destination product unit price master 106c Unit Price Control Transaction Classification Master 106d Product Master 106e Data Table 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A unit price inquiry device equipped with a control unit and a storage unit, The control unit an order input means for inputting order data including an order identification number, order classification, order date, customer, delivery destination, supplier, product, quantity, unit price, order amount, and unit price information source indicating the source of unit price information in response to an operator's operation on the order input screen, and registering the input data in a storage unit; a sales input means for inputting sales data including a sales identification number, a sales category, an order identification number, a sales date, a customer, a delivery destination, a supplier, a product, a quantity, a unit price, a sales amount, and an acquired unit price information source indicating the source of the unit price in response to an operator's operation on a sales input screen, and registering the input data in a storage unit; a query means for referencing the sales data and order data registered in the storage unit in response to an operator's operation on the sales query screen and displaying sales query data including the source of unit price information for the orders and sales; A unit price inquiry device comprising:

2. 2. The unit price inquiry device according to claim 1, wherein the acquired unit price information source includes a unit price master, an estimate, or manual input.

3. The storage unit includes: a unit price control transaction category master in which transaction categories subject to unit price control are registered; A product master that associates and registers a unit price control category that specifies whether or not a product is subject to unit price control, and At least, a unit price master that associates and stores the customer, delivery destination, applicable period, product, quantity (unit price), and unit price, is stored, the order data and the sales data include unit price control target information indicating whether or not the data is subject to unit price control; The sales inquiry data includes unit price control target information for orders and sales, the order entry means performs unit price control when the order category is registered in the transaction category of the unit price control transaction category master and the unit price control category of the commodity is subject to unit price control by referring to the commodity master; the sales input means performs unit price control when the sales category is registered in the transaction category of the unit price control transaction category master and the unit price control category of the commodity is subject to unit price control by referring to the commodity master; The unit price inquiry device described in claim 1, characterized in that the unit price control controls the screen so that the unit price obtained from the unit price master and the amount calculated by multiplying the obtained unit price by the quantity cannot be input or changed on the input screen.

4. 4. The unit price inquiry device according to claim 3, wherein in the unit price control, an error message is displayed on the input screen if there is no target unit price in the unit price master.

5. The unit price master is A customer delivery destination product unit price master that associates and registers customer, delivery destination, applicable period, product, quantity (unit price), and unit price, A customer, delivery destination, supplier, applicable period, product, quantity (unit price) and unit price are associated and registered as a product unit price master by customer, delivery destination, supplier, Including, The order input means acquires a unit price from the customer-delivery-specific product unit price master using the product, customer, delivery destination, and order date as keys, and also acquires a unit price from the customer-delivery-specific product unit price master using the product, customer, delivery destination, supplier, and order date as keys, The unit price inquiry device according to claim 3, characterized in that the sales input means acquires the unit price from the customer-delivery-destination product unit price master using the product, customer, delivery destination, and sales date as keys, and also acquires the unit price from the customer-delivery-destination product unit price master using the product, customer, delivery destination, supplier, and sales date as keys.

6. A unit price inquiry method executed by an information processing device having a control unit, Executed in the control unit: an order input process for inputting order data including an order identification number, order classification, order date, customer, delivery destination, supplier, product, quantity, unit price, order amount, and unit price information source indicating the source of the unit price in response to an operator's operation on the order input screen, and registering the input data in a storage unit; a sales input process for inputting sales data including a sales identification number, a sales category, an order identification number, a sales date, a customer, a delivery destination, a supplier, a product, a quantity, a unit price, a sales amount, and an acquired unit price information source indicating the source of the unit price in response to an operator's operation on the sales input screen, and registering the input data in a storage unit; a querying step of displaying sales query data including the source of unit price information for the orders and sales by referring to the sales data and order data registered in the storage unit in response to an operator's operation on the sales query screen; A unit price inquiry method comprising:

7. A unit price inquiry program to be executed by an information processing device having a control unit, Executed in the control unit: an order input process for inputting order data including an order identification number, order classification, order date, customer, delivery destination, supplier, product, quantity, unit price, order amount, and unit price information source indicating the source of the unit price in response to an operator's operation on the order input screen, and registering the input data in a storage unit; a sales input process for inputting sales data including a sales identification number, a sales category, an order identification number, a sales date, a customer, a delivery destination, a supplier, a product, a quantity, a unit price, a sales amount, and an acquired unit price information source indicating the source of the unit price in response to an operator's operation on the sales input screen, and registering the input data in a storage unit; a querying step of displaying sales query data including the source of unit price information for the orders and sales by referring to the sales data and order data registered in the storage unit in response to an operator's operation on the sales query screen; A unit price inquiry program to run.

Citation Information

Patent Citations

  • Intake / exhaust structure for heat generation apparatus storage rack, and data center

    JP2011022764A

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

    JP2016170777A

  • Information inquiry device, information inquiry method, and information inquiry program

    JP2020166445A

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

    JP2020181615A

  • Device for generating transaction data in group company, method for generating transaction data in group company, and program for generating transaction data in group company

    JP2022103791A