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

Abstract

This enables the accurate and easy execution of justified estimated cost reductions. [Solution] A business support device comprising a control unit that supports the automatic reduction of unordered estimated costs, wherein the control unit has access to estimated cost accounting header data, estimated cost accounting detail data, purchase header data, and purchase detail data, and the control unit, after acquiring the unordered estimated cost accounting data, acquires the PJ number, order number, and order line number from the estimated cost accounting header data based on the estimated cost accounting number, extracts the corresponding purchase header data and purchase detail data from the purchase header data and purchase detail data using the order number, order line number, PJ number, and supplier as keys, and performs estimated cost reduction processing means to reduce the estimated cost amount based on the PJ cost account, PJ type, and supplier.

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 the month when construction is completed and sales are recorded, invoices from suppliers often do not arrive, so it is often impossible to record purchases such as material costs. Therefore, for example, in large-scale construction projects, an estimated cost amount (estimated cost) is generated by cost transfer, and when the actual cost corresponding to the estimated cost occurs after the next month, the estimated cost is written off.

[0003] Patent Document 1 discloses a business support device including: an estimated cost input screen display control unit that displays, on a display unit, an estimated cost input screen including an input field for an outstanding order balance indicating an amount that has been ordered but not yet purchased and an estimated cost amount to be recorded based on the order data; a purchase input screen display control unit that displays, on the display unit, a purchase input screen for recording a purchase amount based on the order data; and a data generation unit that generates write-off data for writing off the estimated cost amount input via the estimated cost input screen with the recorded purchase amount when the purchase amount is recorded via the purchase input screen.

[0004] Further, Patent Document 2 discloses a business support device including: an estimated cost input screen display control unit that displays, on a display unit, an estimated cost input screen for recording an estimated cost for unrecorded costs; an estimated cost write-off input screen display control unit that displays, on the display unit, an estimated cost write-off input screen displaying write-off target data used for writing off the estimated cost; and a data generation unit that generates estimated cost write-off data for writing off the estimated cost recorded via the estimated cost input screen with the write-off target data selected on the estimated cost write-off input screen.

Prior Art Documents

Patent Documents

[0005] [Patent Document 1] Japanese Patent Publication No. 2024-17370 [Patent Document 2] Japanese Patent Publication No. 2024-22224 [Overview of the project] [Problems that the invention aims to solve]

[0006] In Patent Document 1, after registering the purchased amount in the order data based on the recorded purchase amount, the purchased amount is used as the amount to be reduced from the estimated cost using the order number and estimated cost accounting number as keys, and the reduction is performed in the estimated cost accounting details data and estimated cost reduction data. However, the reduction of estimated costs for which orders have not been placed cannot be performed automatically, and it is necessary to compare the remaining estimated cost with the amount on the invoice, which makes management complicated.

[0007] Patent Document 2 describes a method for reducing the estimated cost of unordered goods using cost data such as purchases, but it requires operator input via an estimated cost reduction input screen, which is time-consuming and prone to input errors.

[0008] This invention has been made in view of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that enable easy and error-free execution of justified estimated cost reduction. [Means for solving the problem]

[0009] To solve the above-mentioned problems and achieve the objective, the business support device according to the present invention is a business support device that includes a control unit and supports the automatic write-off of unordered estimated costs, and comprises estimated cost header data including estimated cost accounting number, PJ number, order number, order line number, and estimated cost accounting amount; estimated cost accounting detail data including estimated cost accounting number, line number, PJ cost account, PJ type, supplier, estimated cost accounting amount, written-off amount, and write-off completion flag; purchase header data including purchase number, supplier, PJ number, order line number, and purchase amount; and purchase number, purchase line number, purchased product, PJ number, order number, order line number The system is characterized by having access to purchase detail data including PJ cost account, PJ type, purchase amount, and amount already withdrawn, and the control unit, after obtaining the unordered estimated cost detail data, obtains the PJ number, order number, and order line number from the estimated cost header data based on the estimated cost number, extracts the corresponding purchase header data and purchase detail data from the purchase header data and purchase detail data using the order number, order line number, PJ number, and supplier as keys, and withdraws the estimated cost amount based on the PJ cost account, PJ type, and supplier, and includes an estimated cost amount withdrawal processing means.

[0010] Furthermore, in the business support device according to the present invention, the estimated cost amount reduction means sets the amount already reduced as the purchase amount if the estimated cost amount is equal to or greater than the purchase amount, and sets the amount already reduced as the estimated cost amount if the estimated cost amount is less than the purchase amount.

[0011] Furthermore, the business support method according to the present invention is a business support method to be executed by a business support device equipped with a control unit that supports the automatic write-off of unordered estimated costs, comprising: estimated cost accounting header data including estimated cost accounting number, PJ number, order number, order line number, and estimated cost accounting amount; estimated cost accounting detail data including estimated cost accounting number, line number, PJ cost account, PJ type, supplier, estimated cost accounting amount, written-off amount, and write-off completion flag; purchase header data including purchase number, supplier, PJ number, order line number, and purchase amount; purchase number, purchase line number, purchased product, PJ number, order number, order line number, and PJ cost account The system is characterized by having access to purchase detail data including item, project type, purchase amount, and amount already withdrawn, and by having the control unit execute a step to withdraw the estimated cost amount, which involves obtaining the unordered estimated cost detail data, obtaining the project number, order number, and order line number from the estimated cost header data based on the estimated cost number, extracting the corresponding purchase header data and purchase detail data from the purchase header data and purchase detail data using the order number, order line number, project number, and supplier as keys, and withdrawing the estimated cost amount based on the project cost account, project type, and supplier.

[0012] Furthermore, the business support program according to the present invention is a business support program to be executed by a business support device equipped with a control unit that supports the automatic write-off of unordered estimated costs, and includes estimated cost accounting header data including estimated cost accounting number, PJ number, order number, order line number, and estimated cost accounting amount; estimated cost accounting detail data including estimated cost accounting number, line number, PJ cost account, PJ type, supplier, estimated cost accounting amount, written-off amount, and write-off completion flag; purchase header data including purchase number, supplier, PJ number, order line number, purchase amount; and purchase number, purchase line number, purchased product, PJ number, order number, order line number, P The system is capable of accessing purchase detail data including cost account, project type, purchase amount, and amount already repaid, and the control unit is instructed to perform a provisional cost repayment processing step, in which it obtains provisional cost accounting detail data for unordered items, obtains project number, order number, and order line number from provisional cost accounting header data based on provisional cost accounting number, extracts the corresponding purchase header data and purchase detail data from the purchase header data and purchase detail data using the order number, order line number, project number, and supplier as keys, and repays the provisional cost amount based on the cost account, project type, and supplier. [Effects of the Invention]

[0013] This invention has the effect of enabling the easy and error-free execution of justified estimated cost reductions. [Brief explanation of the drawing]

[0014] [Figure 1] Figure 1 is a block diagram showing the configuration of the business support device according to the embodiment. [Figure 2] Figure 2 is a diagram illustrating the processing flow in the business support device of the embodiment. [Figure 3] Figure 3 shows an example of order data. [Figure 4] Figure 4 shows an example of the estimated cost entry screen and estimated cost data. [Figure 5] Figure 5 shows an example of the sales entry screen and sales data. [Figure 6] FIG. 6 is a diagram showing an example of a purchase input screen and purchase data. [Figure 7] FIG. 7 is a diagram showing an example of data used for the estimated cost breakdown process. [[ID=⑤]] [[ID=⑥]] [Figure 8] [[ID=⑦]]FIG. 8 is a diagram showing an example of the estimated cost breakdown process. [[ID=⑧]] [[ID=⑨]] [Figure 9] [[ID=⑩]]FIG. 9 is a diagram showing an example of estimated cost breakdown data and the like. [[ID=⑪]] [[ID=⑫]] [Figure 10] [[ID=⑬]]FIG. 10 is a diagram showing an example of data used for the estimated cost breakdown process. [[ID=⑭]] [[ID=⑮]] [Figure 11] [[ID=⑯]]FIG. 11 is a diagram showing an example of the estimated cost breakdown process. [[ID=⑰]] [[ID=⑱]] [Figure 12] [[ID=⑲]]FIG. 12 is a diagram showing an example of estimated cost breakdown data and the like. [[ID=⑳]] [[ID=㉑]] [Figure 13] [[ID=㉒]]FIG. 13 is a diagram showing an example of estimated cost accounting data and the like. [[ID=㉓]] [[ID=㉔]] [[ID=㉕]]

BEST MODE FOR CARRYING OUT THE INVENTION

[0015] [[ID=㉙]] [[ID=㉚]]Hereinafter, a business support apparatus, a business support method, and a business support program according to an embodiment to which the present invention is applied will be described in detail based on the drawings. Note that the present invention is not limited to such an embodiment. [[ID=㉛]] [[ID=㉜]]

[0016] [[ID=㉝]] [[ID=㉞]][1. Configuration][[ID=㉟]] [[ID=㊱]]Referring to FIG. 1, an example of the configuration of a business support apparatus 100 according to an embodiment will be described. FIG. 1 is a block diagram showing the configuration of the business support apparatus 100 of the embodiment. [[ID=㊲]] [[ID=㊳]]

[0017] [[ID=㊴]] [[ID=㊵]] [[ID=㊶]]The business support apparatus 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 apparatus 100 is communicably connected via an arbitrary communication path. [[ID=㊷]]

[0018] [[ID=㊸]] 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).

[0019] 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 112 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 114 and the user's operation of the input device 400 may be referred to as "user operation via UI".

[0020] 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.

[0021] The memory unit 106 stores, for example, order data 106a, estimated cost accounting data 106b, sales data 106c, purchase data 106d, estimated cost reduction data 106e, and so on.

[0022] Order data 106a is data related to the construction work that has been ordered. As shown in Figure 3 as an example, order data 106a consists of basic construction information 106a-1, order header 106a-2, and order details 106a-3. Basic construction information 106a-1 includes information such as project number, project name, direct / intermediate classification, and construction site. Order header 106a-2 includes information such as project number, order number, and project name. Order details 106a-3 includes information such as project number, order number, order line number, and order amount. The project number, order number, and order line number are automatically assigned numbers.

[0023] The estimated cost accounting data 106b is data recorded by the operator when an invoice has not yet been received from the supplier, and although the goods have been delivered or the services have been completed, the amount is not yet determined and therefore the cost cannot be recorded. As shown in Figure 4 as an example, the estimated cost accounting data 106b consists of estimated cost accounting header data 106b-1 and estimated cost accounting detail data 106b-2. The estimated cost accounting header data 106b-1 includes the estimated cost accounting number, estimated cost accounting date, project number, order number, order line number, estimated cost accounting amount, etc. The estimated cost accounting detail data 106b-2 includes the estimated cost accounting number, line number, project cost account, supplier, estimated cost accounting amount, amount already repaid, repayment completion flag, input category, etc. In this embodiment, the estimated cost accounting data 106b consists of estimated cost accounting header data 106b-1 and estimated cost accounting detail data 106b-2, but it may also be a single estimated cost accounting data 106b. Note that the estimated cost accounting number and line number are automatically assigned numbers.

[0024] Sales data 106c is data relating to sales for contracted construction work and is recorded in the month in which the work is completed. As shown in Figure 5 as an example, sales data 106c consists of sales header data 106c-1 and sales detail data 106c-2. Sales header data 106c-1 includes sales number, estimated cost recording date, project number, order number, order line number, sales amount, etc. Sales detail data 106c-2 includes sales number, line number, sales amount, etc. The sales number and line number are automatically assigned numbers.

[0025] Purchase data 106d is data relating to purchased goods or services and is recorded when the invoice is received. As shown in Figure 6 as an example, purchase data 106d consists of purchase header data 106d-1 and purchase detail data 106d-2. Purchase header data 106d-1 includes purchase number, purchase date, supplier, project number, order number, order line number, purchase amount, etc. Purchase detail data 106d-2 includes purchase number, purchase line number, purchased goods, project number, order number, order line number, project cost account, project type, and purchase amount. In this embodiment, purchase data 106d consists of purchase header data 106d-1 and purchase detail data 106d-2, but it may also be a single purchase data 106d. Note that the purchase number and line number are automatically assigned numbers.

[0026] The estimated cost reduction data 106e is data related to the reduction of estimated costs. As shown in Figure 9 as an example, the estimated cost reduction data 106e consists of estimated cost reduction header data 106e-1 and estimated cost reduction detail data 106e-2. The estimated cost reduction header data 106e-1 includes the estimated cost reduction number, estimated cost accounting number, estimated cost reduction date, estimated cost reduction amount, etc. The estimated cost reduction detail data 106e-2 includes the estimated cost reduction number, line number, voucher number (purchase number, purchase line number), estimated cost accounting number, estimated cost reduction amount, occurrence pattern classification, etc. The estimated cost reduction number and line number are automatically assigned numbers.

[0027] Functionally, the control unit 102 includes an order data creation unit 102a, a deemed cost accounting data creation unit 102b, a sales data creation unit 102c, a purchase data creation unit 102d, a deemed cost reduction processing unit 102e, and the like.

[0028] The order data creation unit 102a creates the order data 106a shown in Figure 3 based on the information entered by the operator via an order data creation screen (not shown).

[0029] The estimated cost accounting data creation unit 102b creates estimated cost accounting data 106b based on the information entered by the operator via the estimated cost accounting input screen MA, which is shown as an example in Figure 4.

[0030] The sales data creation unit 102c creates sales data 106c based on the information entered by the operator via the sales input screen MB, which is shown as an example in Figure 5.

[0031] The procurement data creation unit 102d creates procurement data 106d based on information entered by the operator via the procurement input screen MC, which is shown as an example in Figure 6.

[0032] The provisional cost reduction processing unit 102e retrieves provisional cost accounting detail data 106b-2 for unordered items, and then retrieves the project number, order number, and order line number from the provisional cost accounting header data 106b-1 based on the provisional cost accounting number. Using the project number, order number, order line number, and supplier from the provisional cost accounting detail data 106b-2 as keys, it extracts the corresponding purchase header data 106d-1 and purchase detail data 106d-2 from the purchase header data 106d-1 and purchase detail data 106d-2, and then reduces the provisional cost amount based on the project cost account, project type, and supplier. The provisional cost reduction processing unit 102e also creates provisional cost reduction data 106e, which includes the provisional cost reduction amount.

[0033] [2. Processing] A specific example of the processing of the business support device 100 of this embodiment will be described with reference to Figures 2 to 13.

[0034] Figure 2 is a diagram illustrating the processing flow in the business support device 100 of the embodiment. First, the operator calculates the estimated cost via the estimated cost input screen MA, shown as an example in Figure 4, and inputs sales via the sales input screen MB, shown as an example in Figure 5. Subsequently, the operator inputs purchases via the purchase input screen MC, shown as an example in Figure 6, and the business support device 100 performs the estimated cost reduction process based on the created estimated cost calculation data and purchase data. Note that purchase input should be processed in the month following the month of sale of the construction work. Furthermore, the data for the estimated cost reduction process may be not only purchase data, but also construction cost data such as expense calculations.

[0035] Figure 4 shows an example of the estimated cost accounting input screen MA and estimated cost accounting data 106b. In the month of sales for a construction project, the operator enters the estimated cost accounting date, project number, order number, and order line number into the estimated cost accounting input screen MA. They also input the project cost account, project type, supplier, and estimated cost accounting amount, referring to the budget and estimates from subcontractors, to account for the estimated cost. After inputting the information, pressing the "Register" button causes the estimated cost accounting data creation unit 102b to create estimated cost accounting header data 106b-1 and estimated cost accounting detail data 106b-2 based on the entered information. The estimated cost accounting detail data 106b-2 includes a column for the completion of the reduction flag. If the estimated cost reduction is not complete, "0: Not completed" is registered, and if it is completed, "1: Completed" is registered. Furthermore, the input category item identifies whether an item has not been ordered or not. If an item has not been ordered, it is registered as "0: Not ordered," and if an order has been placed, it is registered as "1: Ordered." The present invention aims to reduce the estimated cost of unordered items and targets items marked "0: Not ordered." However, items marked "1: Ordered" are linked to order data (not explicitly stated here) for reduction. Here, the project type and project cost account are used to manage the breakdown of incurred costs. The project type manages classification, and the project cost account manages both classification and account.

[0036] Figure 5 shows an example of the sales input screen MB and sales data 106c. In the month that the construction is completed, the operator enters the sales date, project number, order number, order line number, and sales amount into the sales input screen MB to record the sales. After entering the information, the operator presses the "Register" button, and the sales data creation unit 102c generates sales header data 106c-1 and sales detail data 106c-2 based on the entered sales date, project number, order number, order line number, sales amount, etc.

[0037] Figure 6 shows an example of the purchase entry screen MC and purchase data 106d. The operator enters expenses such as purchases when the invoice arrives and in the month following the month of sale for the construction work. The operator enters the purchase date, supplier, project number, order number, order line number, purchased item, project cost account, project type, and purchase amount on the purchase entry screen MC. After entering the information, the operator presses the "Register" button, and the purchase data creation unit 102d generates purchase header data 106d-1 and purchase detail data 106d-2 based on the entered purchase date, supplier, project number, order number, order line number, purchased item, project cost account, project type, purchase amount, etc.

[0038] When construction costs such as purchase data 106d are entered, the estimated cost reduction processing unit 102e retrieves details with a reduction completion flag of "0: Incomplete" from the estimated cost calculation detail data 106b-2. Furthermore, based on the estimated cost calculation detail number "MI001" in the estimated cost calculation detail data 106b-2 obtained from the estimated cost calculation header data 106b-1, it retrieves the PJ number "PJ001", order number "JU001", and order line number "001" from the estimated cost calculation header data 106b-1. The deemed cost reduction processing unit 102e uses the obtained PJ number "PJ001", order number "JU001", order line number "001", and the supplier from the deemed cost accounting detail data 106b-2 as keys to extract the corresponding purchase header data 106d-1 and purchase detail data 106d-2 from the purchase header data 106d-1 and purchase detail data 106d-2.

[0039] Figure 7 shows an example of data used in the estimated cost reduction process. The estimated cost detail data 106b-2 shown in Figure 7 is an item with a reduction completion flag of "0: Incomplete," and the estimated cost header data 106b-1 with the same estimated cost detail number "MI001" is also obtained. In addition, the purchase header data 106d-1 and purchase detail data 106d-2 shown in Figure 7 are extracted using the PJ number "PJ001," order number "JU001," order line number "001," and the suppliers "M Construction," "S Industry," "T Materials," "Z Construction," and "G Civil Engineering" from the estimated cost detail data 106b-2, and the purchase detail data 106d-2 for suppliers "M Construction" and "S Industry" is extracted as the corresponding details.

[0040] After obtaining the estimated cost header data 106b-1, estimated cost detail data 106b-2, purchase header data 106d-1, and purchase detail data 106d-2 used for the estimated cost reduction processing, the estimated cost reduction processing is performed on the estimated cost detail data 106b-2 in the order of estimated cost detail number and line number. The estimated cost reduction processing unit 102e first obtains the purchase detail data 106d-2 with the same PJ cost account, PJ type, and supplier as the detail with the lowest estimated cost detail number and line number.

[0041] Figure 8 shows an example of the process for reducing deemed costs. In Figure 8, the deemed cost accounting detail data 106b-2 with the lowest row number in the deemed cost accounting detail data 106b-2 of Figure 7 is extracted and shown, along with the corresponding deemed cost accounting header data 106b-1. In addition, the purchase header data 106d-1 and purchase detail data 106d-2, which have the same PJ cost account, PJ type, and supplier, are shown. As shown in Figure 8, the estimated cost accounting detail data 106b-2 (estimated cost accounting number "MI001", line number "001"), which has the lowest row number, has the project cost account "Purchased Goods Expense", the project type "General Construction Work", and the supplier "M Construction". Therefore, the purchase header data 106d-1 and purchase detail data 106d-2 corresponding to the project cost account "Purchased Goods Expense", project type "General Construction Work", and supplier "M Construction" have been obtained.

[0042] The estimated cost reduction processing unit 102e performs automatic cost reduction processing on the acquired data. Figure 9 shows an example of estimated cost reduction data 106e, etc. The estimated cost reduction processing unit 102e compares the estimated cost amount in the estimated cost accounting details data 106b-2 with the purchase amount in the purchase details data 106d-2. If the estimated cost amount is greater than or equal to the purchase amount, it sets the purchase amount and the amount already reduced. If the estimated cost amount is less than the purchase amount, it sets the estimated cost amount as the amount already reduced, and rewrites the estimated cost accounting details data 106b-2 and the purchase details data 106d-2. In Figure 9, since the estimated cost amount (200,000 yen) is greater than or equal to the purchase amount (150,000 yen), the purchase amount (150,000 yen) is registered as the amount already withdrawn. The estimated cost withdrawal processing unit 102e also obtains the estimated cost number, estimated cost withdrawal date (purchase date), estimated cost withdrawal amount (amount already withdrawn), and voucher number (purchase number, purchase line number) from the purchase details data 106d-2 and estimated cost calculation details data 106b-2, and creates the estimated cost withdrawal header data 106e-1 and estimated cost withdrawal details data 106e-2. The occurrence pattern classification included in the estimated cost reduction details data 106e-2 classifies the type of reduction. "Reduction Input" is used when reducing estimated costs that have not yet been ordered, while "Purchase Input" is used when reducing estimated costs that have already been ordered. In the case of Figure 9, since the reduction is for estimated costs that have not yet been ordered, "Reduction Input" is registered.

[0043] Next, the deemed cost reduction processing unit 102e performs the reduction process. The deemed cost reduction processing unit 102e retrieves details with a reduction completion flag of "0: Incomplete" from the deemed cost accounting detail data 106b-2, and uses the corresponding deemed cost accounting header data 106b-1, PJ number, order number, order line number, and supplier from the deemed cost accounting detail data as keys to extract the corresponding purchase header data 106d-1 and purchase detail data 106d-2 from the purchase header data 106d-1 and purchase detail data 106d-2.

[0044] The estimated cost accounting details data 106b-2 shown in Figure 10 is data after the write-off process has been performed for the details with estimated cost accounting number "MI001" and line number "001". However, since the written-off amount for estimated cost accounting number "MI001" and line number "001" is "150,000" against an estimated cost accounting amount of "200,000", the write-off completion flag remains "0: Incomplete", and therefore it is extracted.

[0045] Figure 11 shows an example of the process for reducing deemed costs. In Figure 11, the deemed cost accounting detail data 106b-2 with deemed cost accounting number "MI001" and line number "002" from the deemed cost accounting detail data 106b-2 in Figure 10 is extracted and shown, along with the corresponding deemed cost accounting header data 106b-1. In addition, the purchase header data 106d-1 and purchase detail data 106d-2 with the same PJ cost account, PJ type, and supplier are shown. As shown in Figure 11, the project cost account for the deemed cost accounting number "MI001" and line number "002" is "Purchased Goods Expense," the project type is "General Construction Work," and the supplier is "S Industries." Therefore, the purchase header data 106d-1 and purchase detail data 106d-2 corresponding to the project cost account "Purchased Goods Expense," project type "General Construction Work," and supplier "S Industries" have been obtained.

[0046] Figure 12 shows an example of the estimated cost reduction data 106e, etc. As shown in Figure 12, the estimated cost amount "300,000 yen" in the estimated cost accounting details data 106b-2 and the purchase amount "300,000 yen" in the purchase details data 106d-2 are the same amount, so the estimated cost reduction processing unit 102e registers 300,000 yen as the amount already reduced. Also, since the estimated cost accounting amount and the amount already reduced are the same amount, the estimated cost reduction processing unit 102e rewrites the reduction completion flag to "1: Completed". Furthermore, the deemed cost reduction processing unit 102e obtains the deemed cost accounting number, deemed cost reduction date (purchase date), deemed cost reduction amount (amount already reduced), and voucher number (purchase number, purchase line number) from the purchase details data 106d-2 and the deemed cost accounting details data 106b-2, and creates the deemed cost reduction header data 106e-1 and the deemed cost reduction details data 106e-2.

[0047] As described above, the estimated cost reduction process is performed for all items in the unordered estimated cost accounting details data 106b-2. After the estimated cost reduction process, the estimated cost accounting details data 106b-2 and the purchase details data 106d-2 are updated with the reduced amount and the reduction completion flag. Figure 13 shows the estimated cost accounting header data 106b-1, estimated cost accounting details data 106b-2, purchase header data 106d-1, and purchase details data 106d-2 after the estimated cost reduction process.

[0048] In the business support device 100 according to this embodiment, even for unordered estimated costs, the estimated cost reduction process is performed automatically using the PJ number, PJ cost account, PJ type, and supplier from the purchase data as keys, making it possible to easily and accurately reduce justified estimated costs.

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

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

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

[0052] [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.

[0053] 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.

[0054] 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.

[0055] 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.

[0056] 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 system 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.

[0057] 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.

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

[0059] 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 system shown in the embodiments, as well as the installation procedures after reading, well-known configurations and procedures can be used.

[0060] The various databases stored in the memory unit include memory systems such as RAM and ROM, fixed disk systems such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and website provision.

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

[0062] Furthermore, the specific forms of system distribution and integration are not limited to those shown in the diagram, and all or part of it can be configured by functionally or physically distributing and integrating it 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]

[0063] The present invention is particularly suitable for application to industries that use deemed cost management, such as the construction industry. [Explanation of Symbols]

[0064] 100 Business support equipment 102 Control Unit 102a Order Data Creation Department 102b Deemed Cost Accounting Data Creation Department 102c Sales Data Creation Department 102d Procurement Data Creation Department 102e Cost reduction processing unit (deemed to be cost reduction processing unit) 104 Communication Interface Section 106 Storage section 106a Order Data 106b Data for calculating deemed costs 106c Sales Data 106d Purchase Data 106e Data for deeming cost reduction 108 Input / Output Interface Section 200 servers 300 Networks 400 Input Devices 500 Output Device

Claims

1. A business support device equipped with a control unit that assists in the automatic reduction of estimated costs for unordered items, The estimated cost header data includes the estimated cost accounting number, project number, order number, order line number, and estimated cost accounting amount, The estimated cost accounting details data includes the estimated cost accounting number, line number, project cost account, project type, supplier, estimated cost accounting amount, amount already revoked, and revocation completion flag, Purchase header data including purchase number, supplier, PJ number, order line number, and purchase amount, Purchase details data including purchase number, purchase line number, purchased item, project number, order number, order line number, project cost account, project type, purchase amount, and amount already repaid, Accessible, The control unit, After obtaining the provisional cost accounting details data for unordered items, the provisional cost accounting header data is obtained from the provisional cost accounting header data based on the provisional cost accounting number, and the corresponding purchase header data and purchase detail data are extracted from the purchase header data and purchase detail data using the purchase number, purchase detail number, PJ number, and supplier as keys, and the provisional cost amount is reduced based on the PJ cost account, PJ type, and supplier. A business support device characterized by being equipped with the following features.

2. The business support device according to claim 1, wherein the means for reducing the estimated cost amount sets the reduced amount as the purchase amount if the estimated cost amount is equal to or greater than the purchase amount, and sets the reduced amount as the estimated cost amount if the estimated cost amount is less than the purchase amount.

3. A business support method to be executed by a business support device equipped with a control unit that supports the automatic reduction of estimated costs for unordered items, The estimated cost header data includes the estimated cost accounting number, project number, order number, order line number, and estimated cost accounting amount, The estimated cost accounting details data includes the estimated cost accounting number, line number, project cost account, project type, supplier, estimated cost accounting amount, amount already revoked, and revocation completion flag, Purchase header data including purchase number, supplier, PJ number, order line number, and purchase amount, Purchase details data including purchase number, purchase line number, purchased item, project number, order number, order line number, project cost account, project type, purchase amount, and amount already repaid, Accessible, To be executed by the control unit, After obtaining the provisional cost accounting details data for unordered items, the following steps are performed to reduce the provisional cost amount: The provisional cost accounting header data is obtained from the provisional cost accounting header data based on the provisional cost accounting number; the corresponding purchase header data and purchase detail data are extracted from the purchase header data and purchase detail data using the purchase number, purchase detail number, PJ number, and supplier as keys; and the provisional cost amount is reduced based on the PJ cost account, PJ type, and supplier. A business support method characterized by including the following.

4. A business support program to be executed by a business support device equipped with a control unit that supports the automatic reduction of estimated costs for unordered items, The estimated cost header data includes the estimated cost accounting number, project number, order number, order line number, and estimated cost accounting amount, The estimated cost accounting details data includes the estimated cost accounting number, line number, project cost account, project type, supplier, estimated cost accounting amount, amount already revoked, and revocation completion flag, Purchase header data including purchase number, supplier, PJ number, order line number, and purchase amount, Purchase details data including purchase number, purchase line number, purchased item, project number, order number, order line number, project cost account, project type, purchase amount, and amount already repaid, Accessible, The control unit, After obtaining the provisional cost accounting details data for unordered items, the PJ number, order number, and order line number are obtained from the provisional cost accounting header data based on the provisional cost accounting number. Using the order number, order line number, PJ number, and supplier as keys, the corresponding purchase header data and purchase detail data are extracted from the purchase header data and purchase detail data. A provisional cost amount reduction processing step is performed to reduce the provisional cost amount based on the PJ cost account, PJ type, and supplier. A business support program characterized by its ability to execute certain actions.

Images