Partner company support system, partner company support method, and partner company support program
The cooperating company support system addresses the challenge of managing daily reports and billing by using a control unit to access a contractor-by-job-type unit price master, ensuring fair payment to subcontractors based on actual work hours, thus enhancing cost management and protecting their interests.
Patent Information
- Application Number
- JP2023098569
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2023-06-15
- Publication Date
- 2026-01-27
- Estimated Expiration
- 2043-06-15
AI Technical Summary
Existing systems do not adequately support ordering parties in managing daily reports and billing processes for cooperating companies, particularly in the construction industry, leading to potential underpayment and poor cost management for subcontractors.
A cooperating company support system that includes a control unit to manage daily reports and billing processes by accessing a contractor-by-job-type unit price master, inputting daily report data, and creating assessment tables to calculate and output payment requests, inspection notices, and invoices.
Enables accurate and efficient management of daily reports and billing, ensuring fair payment to cooperating companies based on actual work hours, thereby improving cost management and protecting the interests of both ordering parties and subcontractors.
Smart Images

Figure 0007807412000001 
Figure 0007807412000002 
Figure 0007807412000003
Abstract
Description
[Technical Field]
[0001] The present invention relates to a cooperating company support system, a cooperating company support method, and a cooperating company support program. [Background technology]
[0002] For example, in the construction industry, an ordering party (an ordering company) may order construction work (services) from a subcontractor, and employees of the subcontractor may work together with employees of the ordering company. Typically, the subcontractor creates an invoice and sends it to the ordering party to claim the work fee. For example, Patent Document 1 is a conventional technique in which a subcontractor that has been requested to perform work invoices the ordering party for the work fee. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Japanese Patent Application Publication No. 2022-79589 Summary of the Invention [Problem to be solved by the invention]
[0004] However, Patent Document 1 does not describe anything about the support that an ordering party provides to a cooperating company in managing daily reports when the ordering party places an order with the cooperating company.
[0005] The present invention has been made in consideration of the above, and aims to provide a cooperating company support system, a cooperating company support method, and a cooperating company support program that enable an ordering party to support a cooperating company in managing its daily reports when the ordering party orders work from the cooperating company. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides a cooperating company support system for an ordering party that includes a control unit and supports a cooperating company in making a payment request to the ordering party when the ordering party places an order with a cooperating company, wherein the control unit is configured to be able to access a contractor-by-job-type unit price master that associates and registers the contractor identification information, contract type, job type, and work unit price of the cooperating company, and order data that includes order number, order date, project identification information, contractor identification information, and order amount, and is characterized by comprising: a cooperating company daily report input means for inputting cooperating company daily report data that includes voucher number, work date, order number, project identification information, contractor identification information, job type, contract type, and work hours; and an acceptance table output means for aggregating the cooperating company daily report data monthly for each project identification information, obtaining the work unit price from the contractor-by-job-type unit price master using the contractor identification information, job type, and contract type of the cooperating company daily report data as keys, and creating and outputting an acceptance amount assessment table that includes the project identification information, order number, contractor identification information, job type, contract type, and an acceptance amount calculated by multiplying the obtained unit price by work hours.
[0007] According to another aspect of the present invention, the control unit may further include a purchase import processing means for creating purchase data including a purchase number, a purchase date, an order number, project identification information, contractor identification information, a quantity which is the work time, an order amount, and a purchase amount which is the inspection amount, by referring to the inspection amount assessment table and the order data.
[0008] According to another aspect of the present invention, the control unit may further include a payment settlement processing means for creating and outputting an inspection notice for inspection by the cooperating company based on the purchase data.
[0009] According to another aspect of the present invention, the payment settlement processing means may include a payment settlement processing means that creates and outputs an invoice to the ordering party of the cooperating company on behalf of the cooperating company based on the purchase data.
[0010] In order to solve the above-mentioned problems and achieve the object, the present invention provides a method for supporting a cooperating company from an ordering party, which is executed by an information processing device having a control unit, and which supports a cooperating company in making a payment request to the ordering party when the ordering party places an order with the cooperating company, wherein the control unit stores a contractor-by-job-type unit price master in which the contractor identification information, contract type, job type, and work unit price of the cooperating company are associated and registered, order data including an order number, order date, project identification information, contractor identification information, and order amount, and is characterized by comprising: a cooperating company daily report input step executed by the control unit, which inputs cooperating company daily report data including slip number, work date, order number, project identification information, contractor identification information, job type, contract type, and work hours; and an acceptance table output step which aggregates the cooperating company daily report data monthly for each project identification information, acquires work unit prices from the contractor-by-job-type unit price master using the contractor identification information, job type, and contract type of the cooperating company daily report data as keys, and creates and outputs an acceptance amount assessment table including the project identification information, order number, contractor identification information, job type, contract type, and an acceptance amount calculated by multiplying the acquired unit price by work hours.
[0011] In order to solve the above-mentioned problems and achieve the object, the present invention provides a cooperating company support program for execution by an information processing device having a control unit, which supports a cooperating company in making a payment request to a cooperating company when the ordering party places an order with the cooperating company, wherein the control unit is configured to be able to access a contractor-by-job-type unit price master in which the contractor identification information, contract type, job type, and work unit price of the cooperating company are associated and registered, and order data including an order number, order date, project identification information, contractor identification information, and order amount, and the control unit is configured to access a voucher number, work date, order number, project identification information, and an inspection table output step of aggregating the cooperating company daily report data by project identification information on a monthly basis, acquiring a work unit price from the unit price master by contractor and job type using the cooperating company daily report data's contractor identification information, job type, and contract type as keys, and creating and outputting an inspection amount assessment table including the project identification information, order number, cooperating company identification information, job type, contract type, and an inspection amount calculated by multiplying the acquired unit price by the work time. [Effects of the Invention]
[0012] According to the present invention, when an ordering party places an order with a cooperating company, the ordering party can support the cooperating company in managing daily reports. [Brief explanation of the drawings]
[0013] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a cooperating company support system according to this embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of the configuration of the cooperating company master. [Figure 3] FIG. 3 is a diagram illustrating an example of the configuration of the contract type classification master. [Figure 4] FIG. 4 is a diagram illustrating an example of the configuration of the job type master. [Figure 5] FIG. 5 is a diagram showing an example of the structure of the trader-type and job-type unit price master. [Figure 6]FIG. 6 is a flowchart illustrating the overall processing flow of the control unit of the cooperating company support system according to the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the processing of the control unit of the cooperating company support system according to the present embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the process of the control unit of the cooperating company support system according to the present embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the process of the control unit of the cooperating company support system according to the present embodiment. DETAILED DESCRIPTION OF THE INVENTION
[0014] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to this embodiment.
[0015] [1. Overview] For example, in the construction industry, a client (an ordering company) may order construction work (services) from a partner company (a subcontractor, subsidiary, etc.), and employees of the partner company may work together with employees of the ordering company. Normally, the partner company prepares an invoice and sends it to the client to claim the work fee.
[0016] However, if the subcontractor has poor management skills (for example, if the subcontractor is a one-man contractor), the client may tally up the work hours and prepare invoices on behalf of the subcontractor.
[0017] In this case, the unit price of work and inspection amount stated on the invoice would normally be presented by the cooperating company, but in the case of the relationship described above, the ordering company may present the amount and payment may be made upon confirmation by the cooperating company, a practice unique to the construction industry that can be disadvantageous to the cooperating company.
[0018] Therefore, in this embodiment, when an ordering party orders work from a cooperating company, the ordering party will support the cooperating company in managing its daily reports, thereby helping the cooperating company to make billing requests to the ordering party easily and appropriately.
[0019] Specifically, in this embodiment, unit prices are determined by rank, and based on the dispatch industry, where attendance records are the basis for providing services, the following functions are implemented: (1) clarifying the inspection basis by managing the daily report time of partner companies, and creating inspection notices based on this; (2) establishing a unit price master by contractor and job type, which enables cost management in conjunction with the daily report information submitted by partner companies, thereby ensuring appropriate cost management and protecting partner companies.
[0020] This allows the ordering party and the partner company to mutually confirm the basis for payment and billing, although payments are based on daily report information. Furthermore, based on the partner company's inspection of completed work, etc., it provides a clear accounting standard for subcontracting law measures and partner companies, and as a result, it can also be used as evaluation information for the partner company's productivity, etc.
[0021] The cooperating company support system of the present invention is not limited to cases in the construction industry where an ordering party orders work from a cooperating company, but can also be widely applied to other industries, such as when managing the work of cooperating companies when employees of the cooperating company are stationed at the company's own factory or office.
[0022] [2. Configuration] An example of the configuration of a cooperating company support system according to this embodiment will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the configuration of an information processing device. The cooperating company support system according to this embodiment can be suitably used, for example, when an ordering party (ordering company) in the construction industry orders work from a cooperating company.
[0023] The cooperating company support system 100 is a commercially available desktop personal computer. Note that the cooperating company support system 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0024] The cooperating company support system 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the cooperating company support system 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0025] The communication interface unit 104 communicably connects the cooperating company support system 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of communicably connecting the cooperating company support system 100 with the terminals 400, etc. and the server 200, and is, for example, the Internet or a LAN (Local Area Network).
[0026] The terminals 400 are terminals used by the technical department, sales department, accounting department, etc. of the ordering company, and are configured to be able to communicate data with the cooperating company support system 100 via the network 300 .
[0027] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0028] The memory unit 106 stores various databases, tables, files, etc. The memory unit 106 stores computer programs that cooperate with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The memory unit 106 may be, for example, a memory device such as RAM (Random Access Memory) or ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The memory unit 106 also stores a cooperating company master 106a, a contract type classification master 106b, a job type master 106c, a contractor-by-job type unit price master 106d, order data, cooperating company daily report data, an inspection amount assessment table, purchase data, inspection notices, and invoices.
[0029] Fig. 2 is a diagram showing an example of the configuration of the cooperating company master 106a. Fig. 3 is a diagram showing an example of the configuration of the contract type classification master 106b. Fig. 4 is a diagram showing an example of the configuration of the job type master 106c. Fig. 5 is a diagram showing an example of the configuration of the contractor-by-job-type unit price master 106d.
[0030] As shown in Fig. 2, the cooperating company master 106a can be configured as a table or the like in which the contractor code, contractor name, address, telephone number, etc. of the cooperating company are registered in association with each other. The cooperating company master 106a is referenced for the destination (address), for example, when converting the contractor code and contractor name, or when sending an inspection notifier / invoice to a cooperating company. In the example shown in the same figure, the third line contains the contractor code "G20001", contractor name "XX Paint", address "Shinagawa-ku, Tokyo", and telephone number "03-XXXX-XXXX".
[0031] The contract type classification master 106b can be configured as a table in which contract type codes and contract type names are registered in association with each other, as shown in Fig. 3. The contract type classification master 106b is referenced, for example, when converting contract type codes and contract type names. In the example shown in the figure, the first line has the contract type code "1" and the contract type name "contract," and the second line has the contract type code "2" and the contract type name "regular."
[0032] The job type master 106c can be configured as a table in which job type codes and job type names are registered in association with each other, as shown in Fig. 4. The job type master 106c is referenced, for example, when converting job type codes and job type names. In the example shown in the figure, the second line has the job type code "20" and the job type name "welder," and the third line has the job type code "30" and the job type name "finisher."
[0033] As shown in Figure 5, the contractor-by-job-type unit price master 106d can be configured as a table or the like that associates and registers contractor identification information (contractor code and / or contractor name), contract type (contract type code and / or contract type name), job type (job type code and / or job type name), and unit price of work for each contractor. The contractor-by-job-type unit price master 106d is a master that sets the unit price of work for each contractor according to the contract type and job type. When calculating the unit price of work, an assumed unit price of work is set in-house by dividing the total contract amount by the total man-hours. Therefore, the amount obtained by multiplying the unit price by the work hours is set so that it ultimately matches the total contract amount.
[0034] In the example shown in the same figure, the 8th line has the contractor code "G20001," the contract type code "1: Contract," the job type code "20: Welder," and the unit price "2,000," while the 9th line has the contractor code "G20001," the contract type code "1: Contract," the job type code "30: Finisher," and the unit price "2,300."
[0035] The order data may include an order number, an order date, project identification information (project number and / or project name), vendor identification information (vendor code and / or vendor name), quantity, and order amount (see FIG. 7(A)).
[0036] The partner company daily report data may include the invoice number, work date, order number, project identification information (project number and / or project name), contractor identification information (contractor code and / or contractor name), job type, contract type, and work hours (see Figure 7(B)).
[0037] The inspection amount assessment table may include project identification information (project number and / or project name), order number, contractor identification information (contractor code and / or contractor name), job type, contract type, working hours, and inspection amount (see Figure 7(C)).The inspection amount is calculated by working hours x unit price, referring to the contractor-by-job-type unit price master 106d.
[0038] The purchase data may include a purchase number, a purchase date, an order number, project identification information (project number and / or project name), vendor identification information (vendor code and / or vendor name), quantity, order amount, and purchase amount (see Figure 7(D)).
[0039] The inspection notice may include the notification recipient (vendor: partner company), the inspection amount for the current month, and a breakdown (order number, project number, contract type, job type, time, inspection amount) (see FIG. 8(B)).
[0040] The invoice may include the billing destination (ordering party), the amount billed for the current month, the billing party (vendor: partner company), and details (order number, project number, contract type, job type, hours, billing amount) (see Figure 8(C)).
[0041] The control unit 102 is a CPU or the like that performs overall control of the cooperating company support system 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing operations based on these stored programs.
[0042] The control unit 102 is configured to be able to access the cooperating company master data 106a, contract type classification master data 106b, job type master data 106c, contractor-by-job-type unit price master data 106d, order data, cooperating company daily report data, inspection amount assessment table, purchase data, inspection notices, and invoices stored in the storage unit 106. Note that the cooperating company master data 106a, contract type classification master data 106b, job type master data 106c, contractor-by-job-type unit price master data 106d, order data, cooperating company daily report data, inspection amount assessment table, purchase data, inspection notices, and invoices may be stored elsewhere (for example, in the server 200) as long as they are accessible by the control unit 102.
[0043] In terms of functional concept, the control unit 102 comprises an order input unit 102a, a partner company daily report input unit 102b, an appraisal table output unit 102c, a purchase import processing unit 102d, a payment settlement processing unit 102e, a master maintenance unit 102f, and a screen display control unit 102g.
[0044] The order input unit 102a provides an order input screen in response to a request from, for example, the technical department terminal 400, and in response to operations on the order input screen by the operator of the technical department terminal 400, inputs order data including the order number, order date, project identification information, contractor identification information, and order amount, and registers the data in the memory unit 106.
[0045] The cooperating company daily report input unit 102b provides a cooperating company daily report input screen in response to a request from the business department terminal 400, for example, and inputs cooperating company daily report data including the slip number, work date, order number, project identification information, contractor identification information, job type, contract type, and work hours in response to operations on the cooperating company daily report input screen by the operator of the business department terminal 400, and registers the data in the memory unit 106.
[0046] The assessment table output unit 102c aggregates the cooperating company daily report data stored in the memory unit 106 on a monthly basis for each project identification information, acquires the unit price from the contractor-by-job-type unit price master 106d using the contractor identification information, job type, and contract type of the cooperating company daily report data as keys, and registers in the memory unit 106 an acceptance amount assessment table including the project identification information, order number, contractor identification information, job type, contract type, and the acceptance amount calculated by multiplying the acquired unit price by working time.
[0047] The purchase import processing unit 102d, for example, provides a purchase input screen in response to a request from the accounting department terminal 400, and in response to operations on the purchase input screen by the operator of the accounting department terminal 400, refers to the inspection amount assessment table and order data stored in the memory unit 106, inputs purchase data including the purchase number, purchase date, order number, project identification information, contractor identification information, quantity which is the working time, order amount, and purchase amount which is the inspection amount, and registers it in the memory unit 106.
[0048] The payment settlement processing unit 102e, for example, provides an output screen in response to a request from the accounting department terminal 400, and in response to operations on the output screen by the operator of the accounting department terminal 400, creates an inspection notice for inspection by the cooperating company based on the purchase data registered in the memory unit 106, registers it in the memory unit 106, and displays and / or prints it out, and also creates an invoice on behalf of the cooperating company's orderer, registers it in the memory unit 106, and displays and / or prints it out.
[0049] The master maintenance unit 102f performs editing such as registering, deleting, and updating data in the cooperating company master 106a, the contract type classification master 106b, the job type master 106c, and the contractor-by-job type unit price master 106d, in response to, for example, an operator's operation on the master maintenance screen displayed on the monitor 114.
[0050] The screen display control unit 102g controls the display and input reception of various screens (e.g., master maintenance screen, etc.) displayed on the monitor 114 and various screens (e.g., order input screen, partner company daily report input screen, purchase input screen, output screen, etc.) provided to the terminals 400, etc.
[0051] [3. Specific Examples] A specific example of the processing performed by the control unit 102 of the cooperating company support system 100 according to this embodiment will be described with reference to FIGS.
[0052] (3-1. Overall processing) 6 is a diagram showing a flow for explaining the overall processing flow of the control unit 102 of the cooperating company support system 100 according to this embodiment. The overall processing flow of the cooperating company support system 100 according to this embodiment will be described with reference to FIG.
[0053] 2, the engineering department inputs order data, and if the order data is approved, sends (by email, fax, mail, etc.) a purchase order based on the order data to the cooperating company. Specifically, the order input unit 102a executes order input processing (step S1). In the order input processing, the order input unit 102a provides an order input screen in response to a request from the engineering department terminal 400, for example, and inputs order data including the order number, order date, project identification information, contractor identification information, and order amount in response to operations on the order input screen by the operator of the engineering department terminal 400, and registers the data in the storage unit 106.
[0054] The business department, for example, inputs the daily reports of the employees of the business partner company on behalf of the business partner based on the business partner's contractor daily reports (handwritten), and outputs an inspection amount assessment table that aggregates the daily reports on a monthly basis. Specifically, the business partner daily report input unit 102b executes a business partner daily report input process (step S2). In the business partner daily report input process, the business partner daily report input unit 102b provides a business partner daily report input screen in response to a request from the business partner's terminal 400, and inputs business partner daily report data including the slip number, work date, order number, project identification information, business partner identification information, job type, contract type, and work hours in response to operations on the business partner's terminal 400 by the operator, and registers the data in the storage unit 106.
[0055] Next, the assessment table output unit 102c executes an acceptance table output process (step S3). In the acceptance table output process, the assessment table output unit 102c aggregates the cooperating company daily report data stored in the memory unit 106 on a monthly basis for each project identification information, acquires the work unit price from the contractor-by-job-type unit price master 106d using the contractor identification information, job type, and contract type of the cooperating company daily report data as keys, and registers in the memory unit 106 an acceptance amount assessment table including the project identification information, order number, contractor identification information, job type, contract type, and the acceptance amount calculated by multiplying the acquired work unit price by work time.
[0056] The accounting department creates journal data based on the inspection amount assessment table, and then creates inspection notices and invoices based on the journal data and sends them to the cooperating companies. Specifically, the purchase import processing unit 102d executes purchase import processing (step S4). In the purchase import processing, the purchase import processing unit 102d provides a purchase input screen in response to a request from the accounting department's terminal 400, for example, and, in response to operations on the purchase input screen by the operator of the accounting department's terminal 400, refers to the inspection amount assessment table and order data stored in the memory unit 106, inputs purchase data including the purchase number, purchase date, order number, project identification information, contractor identification information, quantity which is work time, order amount, and purchase amount which is the inspection amount, and registers the data in the memory unit 106.
[0057] The payment settlement processing unit 102e also executes the payment settlement processing (step S5). In the payment settlement processing, the payment settlement processing unit 102e provides an output screen in response to a request from the accounting department terminal 400, and in response to operations on the output screen by the operator of the accounting department terminal 400, creates an inspection notice and an invoice based on the purchase data registered in the storage unit 106, registers them in the storage unit 106, and displays and / or prints them out.
[0058] (3-2. Specific examples) 7 to 9 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the cooperating company support system 100 according to the present embodiment. A specific example of the processing by the control unit 102 of the cooperating company support system 100 according to the present embodiment will be explained with reference to FIGS. 7 to 9. In the following explanation, examples of data of the cooperating company master 106a, the contract type classification master 106b, the job type master 106c, and the trader and job type unit price master 106d shown in FIGS. 2 to 5 will be used.
[0059] (S1: Order entry process) A specific example of order input processing will be described with reference to Fig. 7. The order input unit 102a provides an order input screen in response to a request from the terminal 400 of the engineering department, for example, and inputs order data including the order number, order date, project identification information, contractor identification information, and order amount in response to operations on the order input screen by the operator of the terminal 400 of the engineering department, and registers the data in the storage unit 106. In the order input processing, order information for a cooperating company is registered.
[0060] 7A is a diagram showing an example of order data. The order data has fields for order number, order date, project number, project name, contractor code, quantity, and order amount. In the example shown in the figure, the first line contains order number "HA230401," order date "2023 / 4 / 3," project number "PJ0001," project name "Construction A," contractor code "G20001: XX Painting," quantity "complete set," and order amount "120,000." The second line contains order number "HA230402," order date "2023 / 443," project number "PJ0002," project name "Construction B," contractor code "G20001: XX Painting," quantity "complete set," and order amount "50,000."
[0061] (S2: Subcontractor daily report input processing) A specific example of the cooperating company daily report input process will be described with reference to Figure 7. The cooperating company daily report input unit 102b provides a cooperating company daily report input screen in response to a request from the business department terminal 400, for example, and inputs cooperating company daily report data including the slip number, work date, order number, project identification information, contractor identification information, job type, contract type, and work hours in response to operations on the cooperating company daily report input screen by the operator of the business department terminal 400, and registers the data in the storage unit 106. In the cooperating company daily report input process, information such as job type, contract type, and work hours is registered on the system based on the daily reports received from the cooperating companies.
[0062] FIG. 7(B) is a diagram showing an example of the subcontractor daily report data. The subcontractor daily report data includes the following fields: slip number, work date, order number, project number, project name, contractor code, job type, contract type, and work hours. In the example shown in the figure, the first line includes slip number "NP2304G101," work date "4 / 4 / 2023," order number "HA230401," project number "PJ0001," project name "Construction A," contractor code "G20001: XX Painting," job type "20: Welder," contract type "1: Contract," and work hours "7:30." The second line includes slip number "NP2304G102," work date "4 / 5 / 2023," order number "HA230401," project number "PJ0001," project name "Construction A," contractor code "G20001: XX Painting," job type "20: Welder," contract type "1: Contract," and work hours "7:30." 1", project name "Construction A", contractor code "G20001: ○○ Painting", job type "20: Welder", contract type "1: Contract", working hours "5.00", the third line is document number "NP2304G102", work date "2023 / 4 / 5", order number "HA230402", project number "PJ0002", project name "Construction B", contractor code "G20001: ○○ Painting", job type "30: Finishing worker", contract type "1: Contract", working hours "2.30".
[0063] (S3: Assessment sheet output process) A specific example of the assessment table output process will be described with reference to Fig. 7. The assessment table output unit 102c aggregates the cooperating company daily report data stored in the storage unit 106 on a monthly basis for each project identification information, acquires unit prices from the contractor-by-job-type unit price master 106d using the contractor identification information, job type, and contract type of the cooperating company daily report data as keys, and registers an acceptance amount assessment table in the storage unit 106, which includes the project identification information, order number, contractor identification information, job type, contract type, and the acceptance amount calculated by multiplying the acquired unit price by working hours. The assessment table output process outputs working hours by job type and contract type aggregated monthly based on the input cooperating company daily report data.
[0064] 7(C) is a diagram showing an example of data in the inspection amount assessment table. The inspection amount assessment table has the following fields: project number, project name, order number, contractor code, job type, contract type, time, and inspection amount. The detection time is calculated by obtaining the work unit price from the contractor-by-job-type unit price master 106d using the contractor code, job type, and contract type as keys, and multiplying the work time by the work unit price.
[0065] In the example shown in the figure, the first line contains the project number "PJ0001," project name "Construction A," contractor code "G20001: XX Painting," job type "20: Welder," contract type "1: Contract," work hours "12:30 (= 7:30 + 5:00)," and inspection amount "25,000." The inspection time is calculated by using the contractor code "G20001: XX Painting," job type "20: Welder," and contract type "1: Contract" as keys to obtain the work unit price "2,000" from the contractor-by-job-type unit price master 106d in Figure 5, and then calculating the unit price "2,000" x time "12:30" = 25,000.
[0066] The second line contains the order number "HA230402," order date "2023 / 443," project number "PJ0002," project name "Construction B," contractor code "G20001: XX Painting," "30: Finishing Work," contract type "1: Contract," time "2.30," and inspection amount "5,750." The inspection time is calculated by using the contractor code "G20001: XX Painting," "30: Finishing Work," and contract type "1: Contract" as keys to obtain the unit price "2,300" from the contractor-by-job-type unit price master 106d in Figure 5, and then calculating the unit price "2,300" x time "2.30" = 5,750.
[0067] (S4: Purchase import processing) A specific example of the purchase import process will be described with reference to Figure 7. The purchase import processing unit 102d provides a purchase input screen in response to a request from the accounting department terminal 400, for example, and, in response to operations on the purchase input screen by the operator of the accounting department terminal 400, references the inspection amount assessment table and order data stored in the storage unit 106, inputs purchase data including the purchase number, purchase date, order number, project identification information, contractor identification information, quantity which is work time, order amount, and purchase amount which is the inspection amount, and registers the data in the storage unit 106. In the purchase import process, the inspection amount assessment table is imported using cost accounting functions such as purchase import, and cost accounting and purchase data are created.
[0068] 7 is a diagram showing an example of purchase data. The purchase data includes the following fields: purchase number, purchase date, order number, project number, vendor code, quantity, order amount, and purchase amount. In the example shown in the same figure, the first line has the purchase number "SI230401", purchase date "2023 / 4 / 30", order number "HA230401", project number "PJ0001", vendor code "G20001: ○○ painting", quantity "12:30 hours", order amount "120,000", and purchase amount "25,000". The second line has the purchase number "SI230402", purchase date "2023 / 4 / 30", order number "HA230402", project number "PJ0002", vendor code "G20001: ○○ painting", quantity "2:30 hours", order amount "50,000", and purchase amount "5,750".
[0069] (S5: Payment settlement processing) A specific example of payment settlement processing will be described with reference to Figure 8. The payment settlement processing unit 102e provides an output screen in response to a request from the accounting department terminal 400, for example, and creates an inspection notice and an invoice based on the purchase data registered in the memory unit 106 in response to operations on the output screen by the operator of the accounting department terminal 400, and registers them in the memory unit 106 and displays and / or prints them out. The inspection notice and invoice are submitted to the cooperating company. The cooperating company checks the inspection notice and invoice and sends the invoice to the ordering party.
[0070] FIG. 8(A) shows an example of purchase data (same as FIG. 7(D)), FIG. 8(B) shows an example of an inspection notice, and FIG. 8(C) shows an example of an invoice.
[0071] As shown in Figure 8(B), the inspection notice includes the following fields: recipient (vendor: partner company), inspection amount for the current month, and breakdown (order number, project number, contract type, job type, time, inspection amount).
[0072] As shown in Figure 8(C), the invoice includes the following fields: billing destination (our company), billing amount for the current month, billing source (vendor: partner company), and breakdown (order number, project number, contract type, job type, hours, billing amount).
[0073] (Industry Issues) The industry problem will be explained with reference to Figure 9. Figure 9 is a diagram for explaining the industry problem, in which (A) shows an example of the conventional monthly working hours, cumulative working hours, and payment amount, (B) shows a graph of (A), (C) shows an example of the monthly working hours, cumulative working hours, and payment amount when improved by the present invention, and (D) shows a graph of (C). These examples show the payment amount when the cumulative working hours are 80 hours and the contract amount is 320,000 yen for a contract with a construction period of 3 months.
[0074] Normally, the compensation for work (= payment) and cost accounting for a contract should be based on the actual work performance, but with this invention, by managing the working time and work content of the cooperating company on the system, compensation can be determined based on the actual work performance for that month with a basis.
[0075] When there is a hierarchical relationship between the client and the partner company, such as when the client has a stronger position, it is possible to arbitrarily under-report payment amounts and costs that do not correspond to the working hours.
[0076] In the past, for example, as shown in Figure 9(A) and (C), in the first month, the working hours were "30" and the payment amount was "70,000," and in the third month, the working hours were "20" and the payment amount was "150,000." One issue was that, even though the working hours in the third month were fewer than those in the first month, the payment amount for the third month could be made higher at the discretion of the client. In other words, there was a problem that the timing of payment could be decided at the client's discretion.
[0077] This invention aims to solve the above-mentioned industry problems, while also aiming to protect the ideal form of cost management and partner companies. That is, as described above, this invention aggregates the partner company daily report data entered by the client on a monthly basis for each project, and calculates the inspection amount (payment amount) by multiplying the work unit price by the work hours, so that the payment amount corresponds to the work hours each month.
[0078] For example, in the present invention, as shown in Figures 9(B) and (D), in the first month the working hours are "30" and the payment amount is "120,000", and in the third month the working hours are "20" and the payment amount is "80,000", so that the payment amount corresponds to the working hours each month. In this way, it is desirable for the payment amount to be proportional to the working hours, and it is desirable for it to change at equal intervals when viewed over a single month.
[0079] As described above, according to this embodiment, there are provided a contractor-by-job-type unit price master 106d in which the contractor identification information, contract type, job type, and work unit price of cooperating companies are registered in association with each other, a cooperating company daily report input unit 102b for inputting cooperating company daily report data including invoice number, work date, order number, project identification information, contractor identification information, job type, contract type, and work hours, and an assessment table output unit 102c for aggregating the cooperating company daily report data monthly for each project identification information, acquiring work unit prices from the contractor-by-job-type unit price master using the contractor identification information, job type, and contract type of the cooperating company daily report data as keys, and creating and outputting an acceptance inspection amount assessment table including the project identification information, order number, contractor identification information, job type, contract type, and the acceptance inspection amount calculated by multiplying the acquired unit price by work hours, thereby enabling the ordering party to support the daily report management of the cooperating companies.
[0080] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.
[0081] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0082] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.
[0083] 5. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0084] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0085] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.
[0086] Furthermore, with regard to the cooperative company support system 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.
[0087] For example, all or any part of the processing functions of the cooperating company support system 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the cooperating company support system 100 as needed. That is, a computer program for providing instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into RAM, and cooperates with the CPU to form the control unit.
[0088] This computer program may also be stored in an application program server connected to the partner company support system 100 via any network, and all or part of it may be downloaded as needed.
[0089] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.
[0090] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.
[0091] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.
[0092] The cooperating company support system 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The cooperating company support system 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processing described in this embodiment.
[0093] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Explanation of symbols]
[0094] 100 Partner Company Support System 102 Control section 102a Order input section 102b Subcontractor daily report input section 102c Assessment sheet output section 102d Purchase Import Processing Unit 102e Payment settlement processing unit 102f Master Maintenance Department 102g Screen display control unit 104 Communication interface unit 106 Storage section 106a Partner company master 106b Contract type classification master 106c Occupation Master 106d Master of unit price by trader and occupation 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network 400 terminals
Claims
1. A cooperating company support system for an ordering party that includes a control unit and supports a cooperating company in making a payment request to the ordering party when the ordering party places an order with the cooperating company, The control unit A master of unit prices by trader and occupation that associates and registers the trader identification information, contract type, occupation, and work unit price of the partner company, purchase order data including a purchase order number, a purchase order date, project identification information, vendor identification information, and a purchase order amount; It is configured to be accessible to a subcontractor daily report input means for inputting subcontractor daily report data including a slip number, a work date, an order number, project identification information, contractor identification information, a job type, a contract type, and work hours in response to an operator's operation on a subcontractor daily report input screen; an inspection table output means for aggregating the cooperating company daily report data by project identification information monthly, acquiring work unit prices from the contractor-by-job-type unit price master using the contractor identification information, job type, and contract type of the cooperating company daily report data as keys, and creating and outputting an inspection amount assessment table including the project identification information, order number, contractor identification information, job type, contract type, and the inspection amount calculated by multiplying the acquired unit price by work time; A partner company support system characterized by the following:
2. The control unit further 2. The cooperative company support system according to claim 1, further comprising a purchase import processing means for inputting a purchase number and a purchase date in response to an operator's operation on a purchase input screen, and for creating purchase data including the purchase number, purchase date, order number, project identification information, contractor identification information, quantity which is work time, order amount, and purchase amount which is inspection amount by referring to the inspection amount assessment table and the order data.
3. The control unit further 3. A cooperating company support system according to claim 2, further comprising a payment settlement processing means for creating and outputting an inspection notice for inspection by said cooperating company based on said purchase data.
4. 4. The cooperating company support system according to claim 3, wherein the payment settlement processing means comprises a payment settlement processing means for creating and outputting an invoice to the ordering party of the cooperating company on behalf of the cooperating company based on the purchase data.
5. A method for supporting a cooperating company of an ordering party, which is executed by an information processing device having a control unit, when the ordering party places an order with a cooperating company, and supports a cooperating company in making a payment request to the ordering party, The control unit A master of unit prices by trader and occupation that associates and registers the trader identification information, contract type, occupation, and work unit price of the partner company, purchase order data including a purchase order number, a purchase order date, project identification information, vendor identification information, and a purchase order amount; It is configured to be accessible to Executed in the control unit: a subcontractor daily report input step for inputting subcontractor daily report data including a slip number, a work date, an order number, project identification information, contractor identification information, job type, contract type, and work hours; an acceptance table output step of aggregating the cooperating company daily report data by project identification information on a monthly basis in response to an operator's operation on the cooperating company daily report input screen, acquiring a work unit price from the cooperating company and job type unit price master using the cooperating company daily report data's contractor identification information, job type, and contract type as keys, and creating and outputting an acceptance amount assessment table including the project identification information, order number, contractor identification information, job type, contract type, and an acceptance amount calculated by multiplying the acquired unit price by work time; A method for supporting a partner company, comprising:
6. A cooperating company support program to be executed by an information processing device having a control unit, the program supporting a cooperating company in making a payment request to an ordering party when the ordering party places an order with the ordering party, The control unit A master of unit prices by trader and occupation that associates and registers the trader identification information, contract type, occupation, and work unit price of the partner company, purchase order data including a purchase order number, a purchase order date, project identification information, vendor identification information, and a purchase order amount; It is configured to be accessible to In the control unit, a subcontractor daily report input step for inputting subcontractor daily report data including a slip number, a work date, an order number, project identification information, contractor identification information, job type, contract type, and work hours; an acceptance table output step of aggregating the cooperating company daily report data by project identification information on a monthly basis in response to an operator's operation on the cooperating company daily report input screen, acquiring a work unit price from the cooperating company and job type unit price master using the cooperating company daily report data's contractor identification information, job type, and contract type as keys, and creating and outputting an acceptance amount assessment table including the project identification information, order number, contractor identification information, job type, contract type, and an acceptance amount calculated by multiplying the acquired unit price by work time; A support program for partner companies to help them achieve this.
Citation Information
Patent Citations
Integrated job management system
JP2005216013A
Recruitment management system
JP2012104079A
Balance management device, balance management method, and balance management program
JP2022061423A
Project management device, project detail output method, and project detail output program
JP2022079589A
JPP6830792B