Business support device, business support method, and business support program

Abstract

This invention provides a business support device, a business support method, and a business support program that enable the simultaneous adjustment of unit prices for each customer whose unit price revision reference date differs. [Solution] The business support device according to this embodiment is a business support device comprising a control unit, which has access to a customer master, a customer-specific product unit price master, and order data, and the control unit comprises: a product unit price update means that receives revisions to sales unit prices for each customer and product and updates the customer-specific product unit price master; a data acquisition means that obtains the product number, sales unit price, and unit price revision date of products whose sales unit prices have been updated from the customer-specific product unit price master, and also obtains the customer unit price acquisition criteria from the customer master; and a unit price replacement means that extracts detailed data of customers and products whose sales unit prices have been updated from the order data, and replaces the sales unit price of detailed data whose reference date for the unit price acquisition criteria is after the unit price revision date and which has not been delivered.

Description

Technical Field

[0001] The present invention relates to a business support device, a business support method, and a business support program.

Background Art

[0002] In trading companies and the like, price revisions for customers and suppliers occur frequently, and corresponding measures are required. Since the reference date for price revisions varies for each transaction, individual corresponding measures have been necessary.

[0003] In Patent Document 1, an acquisition unit acquires transaction information corresponding to a specified period from a storage unit that stores transaction information including at least date information, customer information, and pre-revision amount information for each business transaction target for which a business transaction has been conducted. A determination unit refers to a rewrite target storage unit that stores target customer information including customers subject to amount information rewrite, and determines business transaction information including customers subject to amount information rewrite among the acquired business transaction information. A rewrite processing unit performs rewrite processing on each business transaction information corresponding to the acquired specified period into business transaction information including pre-price revision amount information, post-revision amount information stored in an amount storage unit, and rewrite target information indicating whether or not it is a target for amount information rewrite as a determination result of the determination unit (see, for example, Patent Document 1).

Prior Art Documents

Patent Documents

[0004]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0005] In Patent Document 1, since price revisions are based only on the order date, when the revision date of a customer is other than the order date, manual corresponding measures are required, and also when the goods have been delivered, manual corresponding measures are required.

[0006] The present invention has been made in view of the above, and aims to provide a business support device, a business support method, and a business support program that enable a batch price adjustment for each customer whose base date for price revision differs. [Means for solving the problem]

[0007] To solve the above-mentioned problems and achieve the objective, the present invention provides a business support device equipped with a control unit, which is able to access a customer master including customer code and unit price acquisition reference date, a customer-specific product unit price master including unit price revision date, customer code, product number and sales unit price, and order data storing order information including order date, planned sales date, order delivery date, customer, product number, number of orders, sales unit price and number of sold, wherein the control unit is equipped with a product unit price update means that accepts sales unit price revisions for each customer and product and updates the customer product unit price master, and a user The system is characterized by comprising: a data acquisition means that, for a specified customer, obtains the product number, sales price, and price revision date of products whose sales price has been updated from the customer-specific product unit price master, and also obtains the customer's unit price acquisition criteria from the customer master; and a unit price replacement means that extracts detailed data of customers and products whose sales price has been updated, obtained by the data acquisition means, from the order data, and replaces the sales price of detailed data that has not been delivered, where the reference date for the unit price acquisition criteria is after the unit price revision date among the extracted detailed data.

[0008] Furthermore, the business support device of the present invention is able to access a supplier master including a supplier code and a unit price acquisition reference date, a supplier-specific product unit price master including a unit price revision date, supplier code, product number, and purchase unit price, and order data that stores purchase information including the order date, planned purchase date, supplier, product number, order quantity, purchase unit price, and purchased quantity, and the product unit price update means receives purchase unit price revisions for each customer and product and updates the supplier-specific product unit price master, and the data acquisition means receives the specifications specified by the user. Regarding suppliers, the system obtains the product number, purchase price, and price revision date of products whose purchase price has been updated from the supplier-specific product unit price master, and also obtains the supplier's unit price acquisition criteria from the supplier master. The unit price recalculation means extracts detailed data of customers and products whose purchase price has been updated, obtained by the data acquisition means, from the order data, and recalculates the purchase price of detailed data that has not been delivered and whose reference date for the unit price acquisition criteria is after the unit price revision date among the extracted detailed data.

[0009] Furthermore, the business support device of the present invention is characterized in that it can access order history data including order data before the unit price update and order data after the unit price update, and, at the user's request, it includes updated unit price display means that obtains and displays information including the sales unit price before the update and the sales unit price after the update from the order history data.

[0010] Furthermore, the business support device of the present invention is characterized in that it can access order history data including order data before the unit price update and order data after the unit price update, and, at the user's request, it includes updated unit price display means that acquires and displays information including the purchase unit price before the update and the purchase unit price after the update from the order history data.

[0011] Furthermore, the business support method of the present invention is a business support method to be executed by a business support device equipped with a control unit, and is capable of accessing a customer master including customer code and unit price acquisition reference date, a customer-specific product unit price master including unit price revision date, customer code, product number and sales unit price, and order data storing order information including order date, planned sales date, order delivery date, customer, product number, number of orders, sales unit price and number of sold, and is to be executed by the control unit, a product unit price update step to receive a revision of the sales unit price for each customer and product and update the customer-specific product unit price master, and The system is characterized by including a data acquisition step of obtaining the product number, sales price, and price revision date of products whose sales price has been updated from the customer-specific product unit price master for customers specified by the system, and obtaining the customer's unit price acquisition criteria from the customer master; and a unit price replacement step of extracting detailed data of customers and products whose sales price has been updated from the order data obtained by the data acquisition means, and replacing the sales price of detailed data that has not been delivered and whose reference date for the unit price acquisition criteria is after the unit price revision date among the extracted detailed data.

[0012] Furthermore, the business support program of the present invention is a business support program to be executed by a business support device equipped with a control unit, and is able to access a customer master including customer code and unit price acquisition reference date, a customer-specific product unit price master including unit price revision date, customer code, product number and sales unit price, and order data storing order information including order date, planned sales date, order delivery date, customer, product number, number of orders, sales unit price and number of sold, and the control unit receives a product unit price update step to receive a sales unit price revision for each customer and product and update the customer-specific product unit price master. The system is characterized by the following steps: a data acquisition step in which, for a customer specified by the user, the system obtains the product number, sales price, and price revision date of products whose sales price has been updated from the customer-specific product unit price master, and also obtains the customer's unit price acquisition criteria from the customer master; and a unit price replacement step in which the system extracts detailed data of customers and products whose sales price has been updated from the order data obtained by the data acquisition means, and replaces the sales price of detailed data that has not been delivered and whose reference date for the unit price acquisition criteria is after the unit price revision date among the extracted detailed data. [Effects of the Invention]

[0013] According to the present invention, it is possible to perform a single unit price adjustment for each customer whose unit price revision reference date differs. [Brief explanation of the drawing]

[0014] [Figure 1] Figure 1 is a block diagram showing an example of the configuration of a business support device. [Figure 2] Figure 2 shows an example of a customer master data. [Figure 3] Figure 3 shows an example of a supplier master data. [Figure 4] Figure 4 shows an example of a customer-specific product unit price master chart. [Figure 5] Figure 5 shows an example of a supplier-specific product unit price master. [Figure 6] Figure 6 shows an example of the order unit price update processing screen. [Figure 7] FIG. 7 is a diagram for explaining the update process of the selling unit price. [Figure 8] FIG. 8 is a diagram showing an example of the purchase unit price update processing screen. [Figure 9] FIG. 9 is a diagram for explaining the update process of the purchase unit price. [Figure 10] FIG. 10 is a diagram showing an example of the order unit price update inquiry screen. [Figure 11] FIG. 11 is a diagram for explaining the order unit price update inquiry process. [Figure 12] FIG. 12 is a diagram showing an example of the purchase unit price update inquiry screen. [Figure 13] FIG. 13 is a diagram for explaining the purchase unit price update inquiry process.

Embodiment for Carrying Out the Invention

[0015] Embodiments of the present invention will be described in detail based on the drawings. Note that the present invention is not limited to these embodiments.

[0016] [1. Configuration] Referring to FIG. 1, an example of the configuration of the business support device 100 according to the present embodiment will be described. FIG. 1 is a block diagram showing an example of the configuration of the business support device 100.

[0017] The business support device 100 is a commercially available desktop personal computer. Note that the business support device 100 is not limited to a stationary information processing system such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer. [[ID=三十六]]

[0018] The business support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each unit included in the business support device 100 is communicably connected via an arbitrary communication path.

[0019] The communication interface unit 104 connects the business support device 100 to the network 300 via communication devices such as routers and wired or wireless communication lines such as dedicated lines, enabling communication between them. The communication interface unit 104 has the function of communicating data with other devices via communication lines. Here, the network 300 has the function of connecting the business support 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).

[0020] The input / output interface unit 108 is connected to an input device 400 and an output device 500. The output device 500 can be a monitor (including a home television), a speaker, or a printer. The input device 400 can be a keyboard, a mouse, a microphone, or a monitor that works in conjunction with the mouse to provide pointing device functionality. In the following, the output device 500 may be referred to as the monitor 500, and the input device 400 as the keyboard 400 or mouse 400. Also, the display of information on the monitor 500 and the user's operation of the input device 400 may be referred to as "user operation via UI".

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

[0022] The memory unit 106 stores, for example, customer master data 106a, supplier master data 106b, customer-specific product unit price master data 106c, supplier-specific product unit price master data 106d, order data 106e, order history data 106f, purchase order data 106g, purchase order history data 106h, and so on.

[0023] As shown in Figure 2 as an example, customer master 106a stores customer codes and unit price acquisition criteria.

[0024] As shown in Figure 3 as an example, the supplier master 106b stores the supplier code and the unit price acquisition criteria.

[0025] The customer-specific product unit price master 106c stores the unit price revision date, customer (code), product part number, and sales unit price, as shown in an example in Figure 4.

[0026] As shown in Figure 5 as an example, the supplier-specific product unit price master 106d stores the unit price revision date, supplier (code), product part number, and purchase unit price.

[0027] As shown in Figure 7 as an example, order data 106e stores order number, order date, customer (code), product number, delivery date, planned sales date, quantity ordered, sales price, sales amount (order price), gross profit amount, quantity sold, and update processing date.

[0028] Order history data 106f includes order data before the unit price update and order data after the unit price update, and shows the history of sales unit price updates. As shown in Figure 7 as an example, for each unit price update of a single product, order history data 106f registers detail data with processing category "10: New" created when the order was placed, detail data with processing category "20: Before Modification" created when the unit price was updated, and detail data with processing category "21: After Modification" created when the unit price was updated. The number of orders, sales amount, and gross profit amount in the detail data with processing category "20: Before Modification" are set to the same values ​​as the number of orders, sales amount, and gross profit amount in the detail data with processing category "10: New," and when these are totaled, the number of orders, sales amount, and gross profit amount in the detail data with processing category "21: After Modification" remain.

[0029] Order data 106g stores order number, order date, supplier (code), product number, planned purchase date, order quantity, purchase unit price, purchase amount, purchased quantity, and update processing date, as shown in an example in Figure 9.

[0030] Order history data 106h includes order data before the unit price update and order data after the unit price update, and shows the history of purchase unit price updates. As shown in Figure 9 as an example, for the details of a unit price update for one product, order history data 106h is registered with the processing category "10: New" created when the order was placed, the processing category "20: Before Modification" created, and the processing category "21: After Modification" created when the unit price was updated. The number of orders and purchase amount in the processing category "20: Before Modification" details are set to the number of orders and purchase amount in the processing category "10: New" details, and when totaled, the number of orders and purchase amount in the processing category "21: After Modification" details remain.

[0031] The control unit 102 is a CPU or similar component that comprehensively controls the business support device 100. The control unit 102 has internal memory for storing control programs such as the OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs.

[0032] Functionally, the control unit 102 includes a product unit price update unit 102a, a data acquisition unit 102b, a unit price replacement unit 102c, an updated unit price display unit 102d, and the like.

[0033] The product unit price update unit 102a receives revisions to sales unit prices for each customer and product and updates the customer-specific product unit price master 106c. In addition, the product unit price update unit 102a receives revisions to purchase unit prices for each supplier and product and updates the supplier-specific product unit price master 106d.

[0034] The data acquisition unit 102b retrieves the product number, sales price, and price revision date of products whose sales price has been updated from the customer-specific product unit price master 106c for customers specified by the user, and also retrieves the customer's unit price acquisition criteria from the customer master 106a. In addition, the data acquisition unit 102b retrieves the product number, purchase price, and price revision date of products whose purchase price has been updated from the supplier-specific product unit price master 106d, and also retrieves the customer's unit price acquisition criteria from the supplier master 106b.

[0035] The unit price adjustment unit 102c extracts detailed customer and product data with updated sales unit prices acquired by the data acquisition unit 102b from the order data 106e, and adjusts the sales unit prices of the detailed data that have not been delivered and whose unit price acquisition date is after the unit price revision date. The unit price adjustment unit 102c also extracts detailed supplier and product data with updated purchase unit prices acquired by the data acquisition unit 102b from the order data 106g, and adjusts the purchase unit prices of the detailed data that have not been delivered and whose unit price acquisition date is after the unit price revision date.

[0036] The updated unit price display unit 102d retrieves and displays information including the sales unit price before and after the update from the order history data 106f, based on user specifications via the order unit price update inquiry screen MC. Furthermore, the updated unit price display unit 102d retrieves and displays information including the sales unit price before and after the update from the order history data 106h, based on user specifications via the order unit price update inquiry screen MD.

[0037] [2. Processing] Here, specific examples of processes executed by the business support device 100 will be explained with reference to Figures 2 to 13.

[0038] In the business support device 100, the unit price revision reference date for each customer is registered in the customer master 106a. In the customer master 106a, which is shown as an example in Figure 2, it is registered that for each customer, for example, customer code "T0001" has a unit price acquisition criterion of "1: Order date", customer code "T0002" has a unit price acquisition criterion of "2: Scheduled sales date", and customer code "T0003" has a unit price acquisition criterion of "3: Order delivery date".

[0039] Furthermore, the business support device 100 has a customer-specific product unit price master 106c, and when the sales unit price and / or purchase unit price are updated, the product unit price update unit 102a updates the customer-specific product unit price master 106c and / or the supplier-specific product unit price master 106d. In the customer-specific product unit price master 106c shown as an example in Figure 4, for product number "ZH001" of customer (code) "T0001", the sales unit price was updated to "1,000" yen on "5 / 1" and then to "1,200" yen on "7 / 1".

[0040] Figure 6 shows an example of the MA screen for updating order unit prices. When a user wants to perform a bulk unit price update (re-calculation) for products of a customer whose sales unit price has been updated, they enter the customer (code) on the MA screen for updating order unit prices. The data acquisition unit 102b acquires the product number, sales unit price, and unit price revision date of the products whose sales unit price has been updated from the customer-specific product unit price master 106c for the customer specified by the user, and also acquires the customer's unit price acquisition criteria from the customer master 106a.

[0041] Figure 7 illustrates the process of updating the sales price. When the user specifies customer "T0001" in the order price update processing screen MA in Figure 6, the data acquisition unit 102b acquires the product number "ZH001", the sales price "1,200" yen, and the price revision date "7 / 1" for the product whose sales price has been updated for customer "T0001" from the customer-specific product price master 106c. It also acquires the price acquisition criterion "1: Order Date" for customer "T0001" from the customer master 106a.

[0042] The unit price adjustment unit 102c extracts product details data for customer "T0001" whose sales unit price has been updated, as acquired by the data acquisition unit 102b, from the order data 106e. Among the extracted detail data, the unit price acquisition criterion "1: Order Date" is set to "7 / 1" or later, and the unit price adjustment unit price is adjusted for detail data that has not been delivered. In the order data 106e in Figure 7, the order Nos. "J002" and "J003" are the details where the unit price acquisition criterion "1: Order Date" is set to "7 / 1" or later. For order No. "J003", the number of sold (delivered) items is "8" out of an order quantity of "10". Details that have not been delivered, i.e., the number of sold items is "0", are subject to the sales unit price adjustment. This is because it is not possible to register products with different unit prices for the same detail. Therefore, the unit price adjustment unit 102c updates the sales unit price for order No. "J002" to the sales unit price "1,200" yen obtained from the customer-specific product unit price master 106c. In addition, the sales amount and gross profit amount are also calculated based on the updated sales unit price. The sales amount is the amount obtained by multiplying the number of orders by the sales unit price, and the gross profit amount is the amount obtained by adding the updated sales amount to the gross profit amount before the sales unit price update and subtracting the sales amount before the update. After updating the sales unit price, etc., the unit price adjustment unit 102c also registers the update processing date in the order data 106e.

[0043] After the sales price is updated, order history data 106f is created for order No. "J002" whose sales price has been updated. This data includes processing categories "10: New" (details data before update), "20: Before Correction" (order quantity, sales amount, and gross profit amount in the details data before update are negative), and "21: After Correction" (details data after update). Note that although the order history data 106f in Figure 7 shows only order No. "J002", the order history data 106f also includes details data for other order Nos whose sales prices have not been updated.

[0044] After the creation of the order history data 106f, it becomes possible to inquire about updated order unit prices using the order unit price update inquiry screen. Figure 10 shows an example of the order unit price update inquiry screen MC. When a user wants to inquire about the sales unit price for a customer's product that has undergone a sales unit price update process, they enter the customer (code) into the order unit price update inquiry screen MC. The updated unit price display unit 102d retrieves information including the sales unit price before and after the update from the order history data 106f and displays it on the order unit price update inquiry screen MC.

[0045] Figure 11 is a diagram illustrating the order unit price update inquiry process. In the order history data 106f shown in Figure 11, the detailed data of order No. whose sales unit price has been updated, that is, data where the update processing date is not "Null", is determined to have been updated and extracted as the target for processing. In the order history data 106f of Figure 11, screen acquisition data is created based on the detailed data of order No. "J002", processing category "20: Before correction" and order No. "J002", processing category "21: After correction", where the update processing date is entered as "7 / 10".

[0046] The updated unit price display unit 102d obtains the sales unit price, sales amount, and gross profit amount from the "20: Before Correction" data, and obtains the updated sales unit price, updated sales amount, and updated gross profit amount from the "21: After Correction" data. Note that the sales amount and gross profit amount are displayed as negative inverted amounts.

[0047] In this embodiment, the business support device 100 can perform a batch price adjustment for each customer whose price revision reference date differs. Furthermore, it can display the sales amount and gross profit amount before and after the price revision process for the revised invoice, making it easy to check the situation.

[0048] The above explains the process for updating sales unit prices, but the process for updating order unit prices can be carried out in a similar manner.

[0049] In the business support device 100, the unit price revision reference date for each supplier is registered in the supplier master 106b. In the supplier master 106b, which is shown as an example in Figure 3, for each supplier, for example, it is registered that the unit price acquisition criterion for supplier code "S0001" is "1: Order date", and for supplier code "S0002" the unit price acquisition criterion is "2: Scheduled purchase date".

[0050] Furthermore, the business support device 100 has a supplier-specific product unit price master 106d, and when the purchase unit price is updated, the product unit price update unit 102a updates the supplier-specific product unit price master 106d. In the supplier-specific product unit price master 106d shown as an example in Figure 5, for product number "ZH001" of supplier (code) "S0001", the purchase unit price was updated to "500" yen on "5 / 1" and then updated to "600" yen on "7 / 1".

[0051] Figure 8 shows an example of the order unit price update processing screen MB. When a user wants to perform a bulk unit price update process (replacement process) for products from a supplier whose order unit price has been updated, the user enters the supplier (code) on the order unit price update processing screen MB. The data acquisition unit 102b acquires the product number, purchase unit price, and unit price revision date of the products whose purchase unit price has been updated from the supplier-specific product unit price master 106d for the supplier specified by the user, and also acquires the supplier's unit price acquisition criteria from the supplier master 106b.

[0052] Figure 9 illustrates the process for updating order unit prices. When the user specifies supplier "S0001" on the order unit price update screen MB in Figure 8, the data acquisition unit 102b retrieves the product number "ZH001", the purchase unit price "600" yen, and the unit price revision date "7 / 1" for the product whose purchase unit price has been updated at supplier "S0001" from the supplier-specific product unit price master 106d. It also retrieves the unit price acquisition criterion "1: Order Date" for supplier "S0001" from the supplier master 106b.

[0053] The unit price adjustment unit 102c extracts detailed product data for supplier "S0001" whose purchase unit price has been updated by the data acquisition unit 102b from the order data 106g. Among the extracted detailed data, the unit price acquisition criterion "1: Order Date" is set to "7 / 1" or later, and the unit price adjustment unit price is adjusted for detailed data that has not been delivered. In the order data 106g shown in Figure 9, the detailed data for which the unit price acquisition criterion "1: Order Date" is set to "7 / 1" or later are order Nos "H002" and "H003". For order No. "H003", the number of purchased (delivered) items is "8" out of an ordered quantity of "10". Details that have not been delivered, i.e., the number of sold items is "0", are subject to the sales unit price adjustment. This is because it is not possible to register products with different unit prices for the same detail. Therefore, the unit price adjustment unit 102c updates the purchase unit price for order No. "H002" to the purchase unit price of "600" yen obtained from the supplier-specific product unit price master 106d. In addition, the purchase amount is also calculated based on the updated purchase unit price. The purchase amount is the amount obtained by multiplying the order quantity by the purchase unit price. After updating the purchase unit price, etc., the unit price adjustment unit 102c registers the update processing date in the order data 106g.

[0054] After the purchase price is updated, order history data 106h is created for the details of order No. "H002" with the updated purchase price, including processing category "10: New" (details data before update), processing category "20: Before Correction" (order quantity and purchase amount in the details data before update are negative), and processing category "21: After Correction" (details data after update).

[0055] After the creation of order history data 106h, it becomes possible to inquire about updated order unit prices using the order unit price update inquiry screen. Figure 12 shows an example of the order unit price update inquiry screen MD. When a user wants to inquire about the purchase unit price for a supplier's product that has undergone a purchase unit price update process, they enter the supplier (code) into the order unit price update inquiry screen MD. The updated unit price display unit 102d retrieves information including the purchase unit price before and after the update from the order history data 106h and displays it on the order unit price update inquiry screen MD.

[0056] Figure 13 is a diagram illustrating the purchase price update inquiry process. In the order history data 106h shown in Figure 13, the detailed data of order No. for which the purchase price has been updated, that is, data where the update processing date is not "Null", is determined to have been updated and extracted as the target for processing. In the order history data 106h in Figure 13, screen acquisition data is created based on the detailed data of order No. "H002", processing category "20: Before correction" and order No. "H002", processing category "21: After correction", for which the update processing date is entered as "7 / 10".

[0057] The updated unit price display unit 102d obtains the purchase unit price and purchase amount from the "20: Before Correction" data, and the updated purchase unit price and updated purchase amount from the "21: After Correction" data. The purchase amount is displayed as a negative value.

[0058] In the business support device 100 according to this embodiment, unit price adjustments can be performed in a batch for each supplier with different reference dates for unit price revisions. Furthermore, for invoices that have undergone unit price revisions, it is possible to display the sales amount and gross profit amount before and after the revision process, making it easy to check the situation.

[0059] [3. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving operational efficiency and promoting appropriate management decisions within companies, thereby enabling contributions to SDGs Goals 8 and 9.

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

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

[0062] [4. Other Embodiments] In addition to the embodiments described above, the present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims.

[0063] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically by known methods.

[0064] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registration data and search conditions for each process, screen examples, and database configuration shown in this specification and in the drawings may be changed at will unless otherwise specified.

[0065] Furthermore, with respect to the business support device 100, each component shown in the diagram is a functional concept and does not necessarily need to be physically configured as shown.

[0066] For example, the processing functions of the business support device 100, particularly those performed by the control unit, may be implemented in whole or in part by a CPU and a program interpreted and executed by the CPU, or they may be implemented as wired logic hardware. The program is recorded on a non-temporary computer-readable recording medium containing programmed instructions for the information processing device to execute the processing described in this embodiment, and is mechanically read by the business support device 100 as needed. That is, a storage unit such as ROM or HDD (Hard Disk Drive) contains a computer program that works in cooperation with the OS to give instructions to the CPU and perform various processing tasks. This computer program is executed by being loaded into RAM and works in cooperation with the CPU to constitute the control unit.

[0067] Furthermore, this computer program may be stored on an application program server connected to the business support device 100 via any network, and it is possible to download all or part of it as needed.

[0068] Furthermore, the program for executing the processing described in this embodiment may be stored on a non-temporary computer-readable recording medium, or it may be configured as a program product. Here, "recording medium" includes any "portable physical medium" such as memory cards, USB (Universal Serial Bus) memory, SD (Secure Digital) cards, flexible disks, magneto-optical disks, ROMs, EPROMs (Erasable Programmable Read Only Memory), EEPROMs (Registered Trademark) (Electrically Erasable and Programmable Read Only Memory), CD-ROMs (Compact Disk Read Only Memory), MOs (Magneto-Optical disks), DVDs (Digital Versatile Disks), and Blu-ray (Registered Trademark) Discs.

[0069] Furthermore, "program" refers to a data processing method described in any language or writing method, regardless of its format, such as source code or binary code. Note that "program" is not necessarily limited to a single, monolithic structure; it also includes distributed structures consisting of multiple modules or libraries, and those that work in cooperation with other programs, such as an operating system, to achieve their functions. Regarding the specific configuration and reading procedures for reading the recording medium in each device shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0070] The various databases stored in the memory unit are storage means such as RAM, ROM, other memory devices, hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0071] Furthermore, the business support device 100 may be configured as a known personal computer or workstation or other information processing device, or as an information processing device to which any peripheral devices are connected. Alternatively, the business support device 100 may be implemented by installing software (including programs or data, etc.) that realizes the processing described in this embodiment on the device.

[0072] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the illustration, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit according to various additions or functional loads. In other words, the embodiments described above may be implemented in any combination, or the embodiments may be implemented selectively. [Industrial applicability]

[0073] This invention is particularly useful for trading companies that handle multiple customers, suppliers, and multiple products. [Explanation of Symbols]

[0074] 100 Business support equipment 102 Control Unit 102a Product Unit Price Update Section 102b Data acquisition unit 102c Unit price replacement section 102d Updated Unit Price Display Section 104 Communication Interface Section 106 Storage section 106a Customer Master 106b Supplier Master 106c Customer-Specific Product Unit Price Master 106d Supplier-Specific Product Unit Price Master 106e Order Data 106f Order History Data 106g Order Data 106h Order History Data 108 Input / Output Interface Section 200 servers 300 Networks 400 Input Devices 500 Output Device

Claims

1. A business support device comprising a control unit, Customer master data including customer code and unit price acquisition date, A customer-specific product unit price master including the unit price revision date, customer code, product number, and sales unit price, Order data stores order information including order date, planned sales date, order delivery date, customer, product number, order quantity, sales unit price, and number of items sold. Accessible, The control unit, A product unit price update means that accepts revisions to sales unit prices for each customer and product and updates the customer-specific product unit price master, A data acquisition means that, for a customer specified by the user, retrieves the product number, sales price, and price revision date of products whose sales price has been updated from the customer-specific product unit price master, and also retrieves the customer's unit price acquisition criteria from the customer master. From the aforementioned order data, a unit price recalculation means extracts customer and product detail data for which the sales unit price acquired by the data acquisition means has been updated, and recalculates the sales unit price of detail data that has not been delivered and whose base date for unit price acquisition is after the unit price revision date among the extracted detail data, A business support device characterized by being equipped with the following features.

2. Supplier master data including supplier code and unit price acquisition date, A supplier-specific product unit price master including the unit price revision date, supplier code, product number, and purchase unit price, Order data that stores purchase information including order date, planned purchase date, supplier, product number, order quantity, purchase unit price, and number of items purchased, Accessible, The aforementioned product unit price update means receives revisions to the purchase unit price for each customer and product and updates the supplier-specific product unit price master. The data acquisition means acquires the product number, purchase price, and price revision date of products whose purchase price has been updated from the supplier-specific product unit price master for customers specified by the user, and also acquires the purchase price and price revision date for each customer and product updated by the product unit price update means which acquires the supplier unit price acquisition criteria from the supplier master. The unit price adjustment means extracts detailed customer and product data from the order data for which the purchase unit price acquired by the data acquisition means has been updated, and adjusts the purchase unit price of the detailed data among the extracted detailed data for which the reference date for the unit price acquisition basis is after the unit price revision date and which has not been delivered. The business support device according to feature 1.

3. Order history data including order data before the unit price update and order data after the unit price update, Accessible, A price update display means that, at the user's request, retrieves and displays information including the sales price before and after the update from the order history data. The business support device according to claim 1, characterized by comprising the above.

4. Order history data including order data before the unit price update and order data after the unit price update. Accessible, A price update display means that, upon user specification, retrieves and displays information including the purchase price before and after the update from the order history data. The business support device according to claim 2, characterized by comprising:

5. A business support method to be executed by a business support device equipped with a control unit, Customer master data including customer code and unit price acquisition date, A customer-specific product unit price master including the unit price revision date, customer code, product number, and sales unit price, Order data stores order information including order date, planned sales date, order delivery date, customer, product number, order quantity, sales unit price, and number of items sold. Accessible, To be executed by the control unit, A product unit price update step that accepts revisions to sales unit prices for each customer and product and updates the customer-specific product unit price master, A data acquisition step which retrieves the product number, sales price, and price revision date of products whose sales price has been updated from the customer-specific product unit price master for a customer specified by the user, and also retrieves the customer's unit price acquisition criteria from the customer master. From the aforementioned order data, the following steps are performed: extract detailed customer and product data for which the sales unit price acquired by the data acquisition means has been updated; and among the extracted detailed data, the sales unit price of detailed data for which the base date for unit price acquisition is after the unit price revision date and which has not been delivered is replaced; A business support method characterized by including the following.

6. A business support program to be executed by a business support device equipped with a control unit, Customer master data including customer code and unit price acquisition date, A customer-specific product unit price master including the unit price revision date, customer code, product number, and sales unit price, Order data stores order information including order date, planned sales date, order delivery date, customer, product number, order quantity, sales unit price, and number of items sold. Accessible, The control unit, A product unit price update step that accepts revisions to sales unit prices for each customer and product and updates the customer-specific product unit price master, A data acquisition step which retrieves the product number, sales price, and price revision date of products whose sales price has been updated from the customer-specific product unit price master for a customer specified by the user, and also retrieves the customer's unit price acquisition criteria from the customer master. From the aforementioned order data, the following steps are performed: extract detailed customer and product data for which the sales unit price acquired by the data acquisition means has been updated; and among the extracted detailed data, the sales unit price of detailed data for which the base date for unit price acquisition is after the unit price revision date and which has not been delivered is replaced; A business support program characterized by its ability to execute tasks.

Images