Order Receiving and Ordering Management Device, Order Receiving and Ordering Management Method, and Order Receiving and Ordering Management Program

Abstract

To obtain efficiency in intracompany order and receiving work by a structure of a master job occurring from a contract specification and a slave job to be ordered to another department derived from the master job.SOLUTION: An ordering and ordering reception management device includes: a contract work processing means for creating a contract detail data including a contract detail number, an order receiving department, and a master Job data including the contract detail number, the Job number an initial cost department; a budget work processing means for creating a contract detail number, the Job number, original cost department which is the order destination within a company initial amount, and slave Job data including issue source Job number with is the Job number of the master Job data; an order processing means for creating an order data including an order number, a contract detail number, a Job number, an outside company order destination, and order amount; and a sales processing means for creating sales data including the sales number, the contract detail number, the sales department, and the sales data.SELECTED DRAWING: Figure 2

Description

Technical Field

[0001] The present invention relates to an order receiving and issuing management device, an order receiving and issuing management method, and an order receiving and issuing management program.

Background Art

[0002] Conventionally, when placing and receiving orders within a company, claims and sales inevitably flow to subsequent processes, often resulting in a complex management where internal transactions are intertwined with external transactions, making it difficult to propose operations in many cases. Also, it was difficult to accurately grasp the revenue and expenditure for each project because the data of internal transactions was mixed. Conventionally, as a system for managing internal order receiving and issuing, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, Patent Document 1 does not describe anything regarding streamlining the internal order receiving and issuing operations and capturing the correct project revenue and expenditure based on the structure of the parent job generated from the contract details and the child jobs for orders issued by other departments derived from the parent.

[0005] The present invention has been made in view of the above, and an object of the present invention is to provide an order receiving and issuing management device, an order receiving and issuing management method, and an order receiving and issuing management program that can streamline the internal order receiving and issuing operations based on the structure of the parent job generated from the contract details and the child jobs for orders issued by other departments derived from the parent.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, the present invention is an order receiving and issuing management apparatus including a control unit, and the control unit includes, for a target project, contract detail number, order receiving department, contract detail data including the order receiving amount, and contract business processing means for creating parent Job data including the contract detail number, Job number, and cost department; for the parent Job data, budget business processing means for creating child Job data including the contract detail number, Job number, cost department which is the internal order destination, cost amount, and the source Job number which is the parent Job number of the parent Job data; for the target project, order issuing processing means for creating order issuing data including the order issuing number, contract detail number, Job number, external order destination, and order issuing amount; and sales processing means for creating sales data including the sales number, contract detail number, sales department, and sales amount based on the contract detail data.

[0007] Further, according to one aspect of the present invention, the control unit may further include balance creating means for creating job-by-job balance data including the order receiving department, order receiving amount, internal order receiving amount, cost department, cost amount, internal cost amount, and gross profit for each Job number based on the contract detail data, the parent Job data, the child Job data, the order issuing data, and the sales data.

[0008] Further, according to one aspect of the present invention, the balance creating means may create contract detail-by-contract detail balance data including the order receiving department, order receiving amount, internal order receiving amount, cost department, cost amount, and gross profit for each contract detail unit based on the job-by-job balance data.

[0009] Further, according to one aspect of the present invention, the balance creating means may create department-by-department balance data including the order receiving department, order receiving amount, cost amount, and gross profit for each department unit based on the job-by-job balance data.

[0010] In addition, in order to solve the above-described problems and achieve the object, the present invention is an order receiving and issuing management method executed by an information processing apparatus including a control unit, and includes, in the control unit, for a target project, a contract business processing step of creating contract detail data including a contract detail number, an order receiving department, and an order receiving amount, and parent Job data including a contract detail number, a Job number, and a cost department; a budget business processing step of creating child Job data including a contract detail number, a Job number, a cost department which is an in-house order destination, a cost amount, and a transfer source Job number which is the parent Job number of the parent Job data, for the parent Job data; an order issuing processing step of creating order issuing data including an order issuing number, a contract detail number, a Job number, an external order destination, and an order issuing amount, for the target project; and a sales processing step of creating sales data including a sales number, a contract detail number, a sales department, and a sales amount, based on the contract detail data.

[0011] In addition, in order to solve the above-described problems and achieve the object, the present invention is an order receiving and issuing management program for execution by an information processing apparatus including a control unit, and causes the control unit to execute, for a target project, a contract business processing step of creating contract detail data including a contract detail number, an order receiving department, and an order receiving amount, and parent Job data including a contract detail number, a Job number, and a cost department; a budget business processing step of creating child Job data including a contract detail number, a Job number, a cost department which is an in-house order destination, a cost amount, and a transfer source Job number which is the parent Job number of the parent Job data, for the parent Job data; an order issuing processing step of creating order issuing data including an order issuing number, a contract detail number, a Job number, an external order destination, and an order issuing amount, for the target project; and a sales processing step of creating sales data including a sales number, a contract detail number, a sales department, and a sales amount, based on the contract detail data.

Effects of the Invention

[0012] According to the present invention, by means of the structure of a parent job generated from a contract details and child jobs for orders placed by other departments derived from the parent, it is possible to achieve the effect of streamlining the internal order receiving and placing operations.

Brief Description of the Drawings

[0013]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Embodiments for Carrying Out the Invention

[0014] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to these embodiments.

[0015] [1. Overview] Conventionally, when placing and receiving orders within a company, claims, sales, etc. inevitably flow to subsequent processes, often resulting in a complex and cumbersome management where internal transactions and external transactions are intertwined, making it difficult to propose operations in many cases. Also, it was difficult to grasp the exact profit and loss by project because data on internal transactions was mixed in.

[0016] Therefore, in this embodiment, the structure of a parent job generated from contract details and child jobs for orders placed by other departments derived from the parent is used to streamline the internal order placement and reception operations and enable accurate capture of the profit and loss of each project.

[0017] More specifically, (1) conventionally, in the case of internal order placement and reception within a company, many companies often operated by separating contract details. Although there was only one contract with a customer, the amount had to be reallocated for each department within the company for internal reasons. Therefore, it was necessary to process contracts for internal order placement and reception as sales, etc., but in this embodiment, this has been made unnecessary.

[0018] (2) In this embodiment, by associating the Job linked to contract data with the link between the amount item and the parent Job (transfer source JobNO), it has become possible to operate by separating Jobs for internal order placement and reception. That is, in this embodiment, Jobs are separated by department, and the amount can be managed, and the transfer amount by department can be confirmed on internal documents, etc.

[0019] (3) In this embodiment, it has become possible to manage the profit and loss of the department or Job without complexity.

[0020] By (1) to (3), this embodiment has a mechanism with a data structure that can accurately capture the profit and loss of each project while streamlining the registration operations for internal order placement and reception.

[0021] According to this embodiment, it is possible to perform in-company order receiving and issuing management, which is common in the IT industry and the construction industry, and reflect it in the execution budget and balance of payments. In addition, since sales processing as in-company order receiving and issuing is unnecessary, it can be operated without affecting the essential administrative work. Furthermore, the exchanges within many companies can be centrally managed by the system.

[0022] FIG. 1 is a diagram showing a processing image of the order receiving and issuing management apparatus according to this embodiment. Hereinafter, a case where Department A receives an order for "1 million yen", issues an in-company order to Department B at a cost of "300,000 yen", issues an in-company order to Department C at a cost of "100,000 yen", issues an out-company order to Company P at a cost of "300,000 yen", Department B further issues an in-company order to Department D at a cost of "50,000 yen", and issues an out-company order to Company Q at a cost of "200,000 yen" will be described.

[0023] First, in project registration T1, project registration is performed. In contract operation T2, contract detail registration (for example, Department A receives an order for "1 million yen") and Job registration (1) (the planned cost of Department A is "700,000 yen") are performed.

[0024] In budget operation (parent Job) T3, Job registration (2) for in-company order (the cost of Department B is "300,000 yen"), Job registration (3) for in-company order (the cost of Department C is "100,000 yen"), and order input for normal order (the cost of Company P is "300,000 yen") are performed.

[0025] In budget operation (parent Job) T4, for Job registration (2), Job registration (4) for in-company order (the cost of Department D is "50,000 yen") and order input for normal order (the cost of Company Q is "200,000 yen") are performed.

[0026] [2. Configuration] With reference to FIG. 2, an example of the configuration of the order receiving and issuing management apparatus 100 according to this embodiment will be described. FIG. 2 is a block diagram showing an example of the configuration of the order receiving and issuing management apparatus 100.

[0027] The order receiving and issuing management device 100 is a commercially available desktop personal computer. Note that the order receiving and issuing management device 100 is not limited to a stationary information processing device such as a desktop personal computer, and may be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), smartphone, or tablet personal computer.

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

[0029] The communication interface unit 104 communicably connects the order receiving and issuing management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line. Here, the network 300 has a function of communicably connecting the order receiving and issuing management device 100 and the server 200, and is, for example, the Internet or a LAN (Local Area Network).

[0030] An input device 112 and an output device 114 are connected to the input / output interface unit 108. For the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. For the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112. Also, displaying information on the monitor 114 and the user operating the input device 112, etc. may be described as "user operation via the UI".

[0031] The storage unit 106 stores various databases, tables, files, and the like. In the storage unit 106, a computer program for giving instructions to the CPU (Central Processing Unit) in cooperation with the OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used. The storage unit 106 includes a data table 106a and the like.

[0032] The data table 106a is a table for storing project data, contract details data, Job data, order data, sales data, and the like.

[0033] The project data may include a project NO and a project name. The contract details data may include a project NO, a contract details NO, an order receiving department, and an order receiving amount. The Job data may include a project NO, a contract details NO, a Job NO, a cost department, a cost amount, and a transfer source Job NO. The order data may include order number, line NO, project NO, contract details NO, Job NO, order destination, and order amount data. The sales data may include a sales slip, a project NO, a contract details NO, a Job NO, a sales department, and sales amount data.

[0034] The control unit 102 is a CPU or the like that comprehensively controls the order receiving and issuing management device 100. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, and the like, and executes various information processes based on these stored programs. Conceptually in terms of functions, the control unit 102 includes a project registration unit 102a, a contract business processing unit 102b, a budget business processing unit 102c, an order issuing processing unit 102d, a sales processing unit 102e, a revenue and expenditure creation unit 102f, and a screen display control unit 102g.

[0035] The case registration department 102a inputs project data according to, for example, the operations of an operator on a case input screen (not shown) displayed on the monitor 114, and registers it in the data table 106a.

[0036] The contract business processing department 102b creates contract detail data including a contract detail number, an order receiving department, and an order receiving amount for a target project according to, for example, the operations of an operator on an input screen (not shown) displayed on the monitor 114, and registers it in the data table 106a. Also, the contract business processing department 102b creates parent Job data including a contract detail number, a Job number, and a cost department for a target project according to, for example, the operations of an operator on an input screen (not shown) displayed on the monitor 114, and registers it in the data table 106a.

[0037] The budget business processing department 102c creates sub-Job data including a contract detail number, a Job number, a cost department which is an in-house order destination, a cost amount, and a remittance source Job number which is the Job number of the parent Job data for the parent Job data according to, for example, the operations of an operator on an input screen (not shown) displayed on the monitor 114, and registers it in the data table 106a.

[0038] The order placement processing department 102d creates order placement data including an order placement number, a contract detail number, a Job number, an external order destination, and an order placement amount for a target project according to, for example, the operations of an operator on an input screen (not shown) displayed on the monitor 114 based on the parent Job data and the sub-Job data, and registers it in the data table 106a.

[0039] The sales processing department 102e creates sales data including a sales number, a contract detail number, a sales department, and a sales amount based on the contract detail data according to, for example, the operations of an operator on an input screen (not shown) displayed on the monitor 114, and registers it in the data table 106a.

[0040] Based on contract detail data, parent Job data, child Job data, order data, and sales data, the revenue and expenditure creation unit 102f creates and outputs job-by-job revenue and expenditure data including the order-receiving department, order-receiving amount, in-house order amount, cost department, cost amount, in-house cost amount, and gross profit for each job number.

[0041] Also, based on the job-by-job revenue and expenditure data, the revenue and expenditure creation unit 102f creates and outputs contract-detail-by-contract revenue and expenditure data including the order-receiving department, order-receiving amount, in-house order amount, cost department, cost amount, and gross profit for each contract detail.

[0042] Also, based on the job-by-job revenue and expenditure data, the revenue and expenditure creation unit 102f creates and outputs department-by-department revenue and expenditure data including the order-receiving department, order-receiving amount, cost amount, and gross profit for each department.

[0043] The screen display control unit 102g controls the display and input of various screens (for example, various input screens, etc.) to be displayed on the monitor 114.

[0044] [3. Specific Example] With reference to FIGS. 2 to 11, a specific example of the processing of the control unit 102 of the order-receiving and order-issuing management device 100 in the present embodiment will be described.

[0045] (3-1. Overall Processing) FIG. 3 is a diagram showing a flow for explaining the outline of the overall processing of the control unit 102 of the order-receiving and order-issuing management device 100 in the present embodiment.

[0046] With reference to FIG. 3, the outline of the overall processing of the control unit 102 of the order-receiving and order-issuing management device 100 in the present embodiment will be described. In FIG. 3, the project registration unit 102a executes project registration processing (step S1). Specifically, in the project registration processing, the project registration unit 102a inputs project data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114 and registers it in the data table 106a.

[0047] The contract business processing unit 102b executes contract business processing (step S2). Specifically, in the contract business processing, the contract business processing unit 102b creates contract detail data including a contract detail number, an order receiving department, and an order receiving amount for the target project in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data table 106a. Also, in the contract business processing, the contract business processing unit 102b creates parent Job data including a contract detail number, a Job number, and a cost department for the target project in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data table 106a.

[0048] The budget business processing unit 102c executes budget business processing (step S3). Specifically, in the budget business processing, the budget business processing unit 102c creates sub-Job data including a contract detail number, a Job number, a cost department which is an in-house order destination, a cost amount, and a transfer source Job number which is the Job number of the parent Job data for the parent Job data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data table 106a.

[0049] The order placement processing unit 102d executes order placement business processing (step S4). Specifically, in the order placement business processing, the order placement processing unit 102d creates order placement data including an order placement number, a contract detail number, a Job number, an external order destination, and an order placement amount for the target project based on the parent Job data and the sub-Job data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data table 106a.

[0050] The sales processing unit 102e executes sales business processing (step S5). The sales processing unit 102e creates sales data including a sales number, a contract detail number, a sales department, and a sales amount based on the contract detail data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data table 106a.

[0051] The revenue and expenditure creation unit 102f executes revenue and expenditure management processing (step S6). Specifically, in the revenue and expenditure management processing, the revenue and expenditure creation unit 102f creates job-by-job revenue and expenditure data including the order receiving department, order receiving amount, in-house order receiving amount, cost department, cost amount, in-house cost amount, and gross profit for each job number based on the contract detail data, parent Job data, child Job data, order data, and sales data.

[0052] Also, in the revenue and expenditure management processing, the revenue and expenditure creation unit 102f creates contract detail-by-contract detail revenue and expenditure data including the order receiving department, order receiving amount, in-house order receiving amount, cost department, cost amount, and gross profit for each contract detail based on the job-by-job revenue and expenditure data.

[0053] Also, in the revenue and expenditure management processing, the revenue and expenditure creation unit 102f creates department-by-department revenue and expenditure data including the order receiving department, order receiving amount, cost amount, and gross profit for each department based on the job-by-job revenue and expenditure data.

[0054] (3-2. Sample Data) Figures 4 to 11 are diagrams showing sample data for explaining a specific example of the processing of the control unit 102 of the order receiving and placing management apparatus 100 in the present embodiment. With reference to Figures 4 to 11, a specific example of the processing of the control unit 102 of the order receiving and placing management apparatus 100 in the present embodiment will be described.

[0055] (S1: Project Registration Processing) With reference to Figure 4, a specific example of the project registration processing will be described. The project registration unit 102a inputs project data and registers it in the data table 106a, for example, in response to an operator's operation on an input screen (not shown) displayed on the monitor 114.

[0056] Figure 4 is a diagram showing an example of project data. In the project data, the project NO is the primary key. In the example of the project data shown in Figure 4, the first row has the project NO "PJ0001" and the project name "Project ○○", the second row has the project NO "PJ0002" and the project name "Project △△", and the third row has the project NO "PJ0003" and the project name "Project ××".

[0057] In the following description, for project No. "PJ0001", Department A received an order from outside the company for "1 million yen", placed internal orders with Department B for "300,000 yen" and Department C for "100,000 yen", placed an external order with Company P for "300,000 yen", and furthermore, Department B placed an external order with Company Q for "200,000 yen" will be described.

[0058] (Conventional processing) With reference to FIGS. 5 and 6, the processing of conventional contract operations, order placement operations, and sales operations will be described.

[0059] In the order receiving department, for the order received by Section A, normal contract detail data is registered, and Job data is also registered. FIG. 5(A) is a diagram showing an example of contract detail data. In the contract detail data, the project No. and the contract detail No. are used as the primary keys. In the example of the contract detail data shown in FIG. 5(A), the project No. is "PJ0001", the contract detail No. is "0001", the order receiving section is "Section A", and the order receiving amount is "1,000,000".

[0060] FIG. 5(B) is a diagram showing an example of Job data. The Job data uses the project No., the contract detail No., and the Job No. as the primary keys. In the example of the Job data shown in FIG. 5(B), the project No. is "PJ0001", the contract detail No. is "0001", the Job No. is "0001", and the cost section is "Section A".

[0061] The department of the internal order recipient also performs contract registration. Thus, conventionally, contract registration for internal orders was necessary. FIG. 5(C) shows an example of the contract detail data of the internal order recipient. In the example of the contract detail data shown in FIG. 5(C), in the first row, the project No. is "PJ0001", the contract detail No. is "0002", the order receiving department is "Department B", and the order receiving amount is "300,000", and in the second row, the project No. is "PJ0001", the contract detail No. is "0003", the order receiving department is "Department C", and the order receiving amount is "100,000".

[0062] Register the Job data for this contract. Figure 5(D) is a diagram showing an example of the Job data for in-house order destinations. In the example of the Job data shown in Figure 5(D), the first row shows project NO "PJ0001", contract detail NO "0002", Job NO "0001", cost department "Department B", and the second row shows project NO "PJ0001", contract detail NO "0003", Job NO "0001", cost department "Department C". The cost of the work is incurred for this Job.

[0063] In the ordering business, register the order data. Figure 6(A) shows an example of the order data. The order data uses the order number and line NO as the primary keys. In the example of the order data shown in Figure 6(A), the first row shows order number "H0001", line NO "001", project NOP "J0001", contract detail NO "0001", Job NO "0001", order destination "Company P", order amount "300,000", and the second row shows order number "H0002", line NO "001", project NOP "J0001", contract detail NO "0002", Job NO "0001", order destination "Company Q", order amount "200,000".

[0064] In the sales business, register the sales data. Figure 6(B) is a diagram showing an example of the sales data. In the example of the sales data shown in Figure 6(B), the first row shows sales slip "U0001", project NO "PJ0001", contract detail NO "0001", sales department "Department A", sales amount "1,000,000", the second row shows sales slip "U0002", project NO "PJ0001", contract detail NO "0002", sales department "Department B", sales amount "300,000", and the third row shows sales slip "U0003", project NO "PJ0001", contract detail NO "0003", sales department "Department C", sales amount "100,000".

[0065] Conventionally, sales processing had to be carried out in accordance with the timing of the respective accounting months (recognition of cost of sales). That is, since two sales journal entries would occur, it was necessary to control the accounting recognition of sales by separating the accounts.

[0066] Conventionally, in order to view the project profit and loss, it is necessary to summarize two contracts, and the internal sales invoices (U0002, U0003) must be excluded.

[0067] As described above, conventionally, when placing and receiving orders within the company, the data of internal transactions flows to subsequent processes such as sales, resulting in a complicated management mixed with external processing. Therefore, in this embodiment, as follows, the structure of a parent job generated from contract detail data and child jobs for orders from other departments derived from the parent is used to streamline the internal order placement and reception operations.

[0068] (S2: Contract business process) Referring to FIG. 7, the contract business process will be described. The contract business processing unit 102b creates contract detail data including a contract detail number, an order receiving department, and an order receiving amount for a target project in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers it in the data table 106a.

[0069] In the order receiving department, normal contract detail data is registered for the order received by Department A. FIG. 7(A) is a diagram showing an example of contract detail data. In the contract detail data, the project NO and the contract detail NO are used as the primary keys. In the example of the contract detail data shown in FIG. 7(A), the project NO is "PJ0001", the contract detail NO is "0001", the order receiving department is "Department A", and the order receiving amount is "1,000,000".

[0070] The contract business processing unit 102b creates parent job data including a contract detail number, a job number, and a cost department for a target project in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers it in the data table 106a.

[0071] Figure 7(B) is a diagram showing an example of parent Job data. The parent Job data has the project NO, contract detail NO, and Job NO as the primary key. In the example of the parent Job data shown in Figure 7(B), the project NO is "PJ0001", the contract detail NO is "0001", the Job NO is "0001", and the cost department is "Department A". Outsource ￥300,000 from this parent Job.

[0072] (S3: Budget business process) Referring to Figure 8, the budget business process will be described. The budget business processing unit 102c creates sub-Job data including the contract detail number, Job number, cost department which is the internal order destination, cost amount, and the transfer source Job number which is the Job number of the parent Job data, and registers it in the data table 106a for the parent Job data. For the parent Job, a budget is registered and an internal order (sub-Job registration) is performed.

[0073] Figure 8 is a diagram showing an example of sub-Job data for internal order. The sub-Job data has the project NO, contract detail NO, and Job NO as the primary key. In the example of the sub-Job data for Department B shown in Figure 8, the project NO is "PJ0001", the contract detail NO is "0001", the Job NO is "0002", the cost department is "Department B", the cost amount is "300,000", and the transfer source Job NO is "0001". Outsource 200,000 from this Job. The cost amount (internal order amount) and the Job NO of the transfer source (ordering source) can be selected. Control is set so that it can be selected from the Job group of its own contract details during selection.

[0074] Also, the sub-Job data for Department C has the project NO "PJ0001", the contract detail NO "0001", the Job NO "0003", the cost department "Department C", the cost amount "100,000", and the transfer source Job NO "0001". Outsource 50,000 from this Job.

[0075] (S4: Ordering business process) Referring to FIG. 9, the order processing operation will be described. The order processing section 102d creates order data including an order number, a contract detail number, a Job number, an external order destination, and an order amount based on the parent Job data and the child Job data for the target project, and registers the data in the data table 106a.

[0076] FIG. 9 shows an example of order data. The order data has the order number and the row NO as the primary key. In the example of the order data shown in FIG. 9, the first row has the order number "H0001", the row NO "001", the project NOP "J0001", the contract detail NO "0001", the Job NO "0001", the order destination "Company P", and the order amount "300,000". The second row has the order number "H0002", the row NO "001", the project NOP "J0001", the contract detail NO "0002", the Job NO "0001", the order destination "Company Q", and the order amount "200,000".

[0077] (S5: Sales business processing) Referring to FIG. 9, the sales business processing will be described. The sales processing section 102e creates sales data including a sales number, a contract detail number, a sales department, and a sales amount based on the contract detail data in response to an operator's operation on an input screen (not shown) displayed on the monitor 114, and registers the data in the data table 106a.

[0078] FIG. 9 shows an example of sales data, which includes the sales invoice "U0001", the project NO "PJ0001", the contract detail NO "0001", the sales department "Department A", and the sales amount "1,000,000". The sales journal entry is debit: accounts receivable "1,000,000" / credit: sales "1,000,000", and only one sales journal entry is generated. Since the timings of each month-end closing are aligned, there is no need to perform sales processing, resulting in a simple process. To view the project revenue and expenditure, it can be viewed within one contract.

[0079] (S6: Revenue and expenditure management processing) Referring to FIGS. 10 and 11, the revenue and expenditure management process will be described. FIG. 10 is a diagram for explaining conventional revenue and expenditure management. FIG. 10 shows the conventional revenue and expenditure by job. The first row shows Project No. "PJ0001", Contract Detail No. "0001", Job No. "0001", Order Receiving Department "Department A", Order Receiving Amount "1,000,000", Cost Department "Department A", Cost Amount "700,000", Gross Profit "300,000". The second row shows Project No. "PJ0001", Contract Detail No. "0002", Job No. "0001", Order Receiving Department "Department B", Order Receiving Amount "300,000", Cost Department "Department B", Cost Amount "250,000", Gross Profit "50,000". The third row shows Project No. "PJ0001", Contract Detail No. "0003", Job No. "0001", Order Receiving Department "Department C", Order Receiving Amount "100,000", Cost Department "Department C", Cost Amount "0", Gross Profit "100,000". The amount of internal company transactions is difficult to grasp.

[0080] FIG. 11 is a diagram for explaining the revenue and expenditure management of the present embodiment. The revenue and expenditure creation unit 102f creates job-by-job revenue and expenditure data including order receiving department, order receiving amount, internal order receiving amount, cost department, cost amount, internal cost amount, and gross profit for each job number based on contract detail data, parent job data, child job data, purchase order data, and sales data.

[0081] FIG. 11(A) is a diagram showing an example of job-by-job revenue and expenditure data. The first row shows Project No. "PJ0001", Contract Detail No. "0001", Job No. "0001", Order Receiving Department "Department A", Order Receiving Amount "1,000,000", Internal Order Receiving Amount "0", Cost Department "Department A", Cost Amount "300,000", Internal Cost Amount "400,000", Gross Profit "300,000". The internal cost amount "400,000" is calculated as the sum of the cost amounts "300,000" + "100,000" of the child job data of the transfer destination jobs "0002" and "0003" of the transfer source Job No. "0001". The gross profit amount is calculated as (order receiving amount + internal order receiving amount) - (cost amount + internal cost amount).

[0082] The second line shows Project No. "PJ0001", Contract Detail No. "0001", Job No. "0002", Order Receiving Department "Department B", Order Receiving Amount "0", Internal Order Amount "300,000", Cost Department "Department B", Cost Amount "250,000", Internal Cost Amount "0", and Gross Profit "50,000". The Internal Order Amount "300,000" is the cost amount "300,000" of the child job data of Job "0002" which is the transfer destination of the transfer source Job No. "0001".

[0083] The third line shows Project No. "PJ0001", Contract Detail No. "0001", Job No. "0003", Order Receiving Department "Department C", Order Receiving Amount "0", Internal Order Amount "100,000", Cost Department "Department C", Cost Amount "0", Internal Cost Amount "0", and Gross Profit "100,000". The Internal Order Amount "100,000" is the cost amount "100,000" of the child job data of Job "0003" which is the transfer destination of the transfer source Job No. "0001".

[0084] Based on the job-by-job revenue and expenditure data, the revenue and expenditure creation section 102f creates contract detail-by-contract revenue and expenditure data including the order receiving department, order receiving amount, internal order amount, cost department, cost amount, and gross profit in contract detail units.

[0085] Figure 11(B) is a diagram showing an example of contract detail-by-contract revenue and expenditure data. In the example of contract detail unit revenue and expenditure data in Figure 11(B), it shows Project No. "PJ0001", Contract Detail No. "0001", Job No. "0001", Order Receiving Department "Department A", Order Receiving Amount "1,000,000", Cost Department "Department A", Cost Amount "550,000", and Gross Profit "450,000". The "Order Receiving Amount" is the total amount of the order receiving amounts in the job-by-job revenue and expenditure data. The "Cost Amount" is the total amount of the cost amounts in the job-by-job revenue and expenditure. The "Gross Profit" is the total amount of the gross profits in the job-by-job revenue and expenditure data.

[0086] Based on the job-by-job revenue and expenditure data, the revenue and expenditure creation section 102f creates department-by-department revenue and expenditure data including the order receiving department, order receiving amount, cost amount, and gross profit in department units.

[0087] Figure 11(C) is a diagram showing an example of departmental income and expenditure data. The first row shows the order-receiving department "Department A", the order-receiving amount "1,000,000", and the cost amount "700,000". The second row shows the order-receiving department "Department B", the order-receiving amount "300,000", the cost amount "250,000", and the gross profit "50,000". The third row shows the order-receiving department "Department C", the order-receiving amount "300,000", the cost amount "0", and the gross profit "100,000". The cost amount is calculated as the cost amount in the Job-by-Job income and expenditure data + the in-company cost amount.

[0088] In this way, it becomes possible to grasp the income and expenditure by contract details, by Job, and by department. It is easy to adjust the control so that the income and expenditure of other departments cannot be seen.

[0089] As described above, according to this embodiment, for the target project, a contract business processing unit 102b that creates contract detail data including a contract detail number, an order-receiving department, and an order-receiving amount, and parent Job data including a contract detail number, a Job number, and a cost department; for the parent Job data, a budget business processing unit 102c that creates child Job data including a contract detail number, a Job number, a cost department that is an in-company order destination, a cost amount, and a remittance source Job number that is the Job number of the parent Job data; for the target project, an order-issuing processing unit 102d that creates order-issuing data including an order-issuing number, a contract detail number, a Job number, an external order destination, and an order-issuing amount; Since it is provided with a sales processing unit 102e that creates sales data including a sales number, a contract detail number, a sales department, and a sales amount based on the contract detail data, it is possible to improve the efficiency of the in-company order-receiving and order-issuing operations by the structure of the parent job generated from the contract details and the child jobs for order-issuing to other departments derived from the parent.

[0090] [4. Contribution to the Sustainable Development Goals (SDGs) Led by the United Nations] According to this embodiment, since it can contribute to promoting business efficiency and appropriate management judgment of the enterprise, it becomes possible to contribute to Goals 8 and 9 of the SDGs.

[0091] In addition, according to this embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitalization, and thus it is possible to contribute to SDGs Goals 12, 13, and 15.

[0092] In addition, according to this embodiment, it is possible to contribute to strengthening control and governance, and thus it is possible to contribute to SDGs Goal 16.

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

[0094] For example, among the processes described in the embodiment, all or part of the processes described as being automatically performed can be manually performed, or all or part of the processes described as being manually performed can be automatically performed by a known method.

[0095] In addition, regarding the order receiving and issuing management device 100, each component shown in the figure is a functional concept, and it is not necessarily physically configured as shown in the figure.

[0096]

[0097] ​For example, regarding the processing functions provided by the order receiving and issuing management device 100, particularly each processing function performed by the control unit, all or any part thereof may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processing described in the present embodiment, and is mechanically read by the order receiving and issuing management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS to perform various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into the RAM, and constitutes the control unit in cooperation with the CPU.

[0098] In addition, this computer program may be stored in an application program server connected to the order receiving and issuing management device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

[0099] Also, the program for executing the processing described in the present embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, this "recording medium" includes any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0100] In addition, a "program" is a data processing method described in any language or description method, regardless of the form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with separate programs represented by an OS. Regarding the specific configuration, reading procedure, and installation procedure after reading for reading a recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0101] Various databases and the like stored in the storage 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 website provision.

[0102] In addition, the order receiving and issuing management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the order receiving and issuing management device 100 may be realized by installing software (including programs or data, etc.) for realizing the processes described in this embodiment in the device.

[0103] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in arbitrary units according to various additions or functional loads. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Explanation of Reference Numerals

[0104] 100 Order receiving and issuing management device 102 Control unit 102a Project registration unit 102b Contract Business Processing Department 102c Budget Business Processing Department 102d Ordering Processing Department 102e Sales Processing Department 102f Revenue and Expense Creation Department 102g Screen Display Control Department 104 Communication Interface Department 106 Memory Department 106a Data Table 108 Input / Output Interface Department 112 Input Device 114 Output Device 200 Server 300 Network

Claims

1. An order receiving and placing management device including a control unit, The control unit For a target project, contract business processing means for creating contract detail data including a contract detail number, an order receiving department, and an order receiving amount, and parent Job data including the contract detail number, the Job number of the parent Job, and the cost department of the parent Job which is the order receiving department; For the parent Job data, budget business processing means for creating child Job data including the contract detail number, the Job number of the child Job, the cost department of the child Job, the cost amount, and the transfer source Job number which is the Job number of the parent Job for linking the parent Job and the child Job; For a target project, order placing processing means for creating order placing data including an order placing number, the contract detail number, the Job numbers of the parent Job and the child Job, an external order supplier, and an order placing amount; Sales processing means for creating sales data including a sales number, the contract detail number, a sales department, and a sales amount based on the contract detail data; An order receiving and placing management device characterized by comprising the above.

2. The control unit further includes a revenue and expenditure creation means for creating job-by-job revenue and expenditure data including an order receiving department, an order receiving amount, an in-house order receiving amount, a cost department, a cost amount, an in-house cost amount, and a gross profit for each Job number based on the contract detail data, the parent Job data, the child Job data, the order placing data, and the sales data. The order receiving and placing management device according to claim 1.

3. The revenue and expenditure creation means creates contract detail-by-contract detail revenue and expenditure data including an order receiving department, an order receiving amount, an in-house order receiving amount, a cost department, a cost amount, and a gross profit for each contract detail based on the job-by-job revenue and expenditure data. The order receiving and placing management device according to claim 2.

4. The revenue and expenditure creation means creates department-by-department revenue and expenditure data including an order receiving department, an order receiving amount, a cost amount, and a gross profit for each department based on the job-by-job revenue and expenditure data. The order receiving and placing management device according to claim 2.

5. An order receiving and issuing management method executed by an information processing apparatus having a control unit, executed by the control unit, For a target project, a contract business processing step of creating contract detail data including a contract detail number, an order receiving department, and an order receiving amount, and parent job data including the contract detail number, the job number of the parent job, and the cost department of the parent job which is the order receiving department, For the parent job data, a budget business processing step of creating child job data including the contract detail number, the job number of the child job, the cost department of the child job, the cost amount, and the transfer source job number which is the job number of the parent job for linking the parent job and the child job, For a target project, a purchase order processing step of creating purchase order data including a purchase order number, the contract detail number, the job numbers of the parent job and the child job, an external purchase order destination, and a purchase order amount, A sales processing step of creating sales data including a sales number, the contract detail number, a sales department, and a sales amount based on the contract detail data, An order receiving and issuing management method characterized by including the above.

6. An order receiving and issuing management program for causing an information processing apparatus having a control unit to execute, To the control unit, For a target project, a contract business processing step of creating contract detail data including a contract detail number, an order receiving department, and an order receiving amount, and parent job data including the contract detail number, the job number of the parent job, and the cost department of the parent job which is the order receiving department, For the parent job data, a budget business processing step of creating child job data including the contract detail number, the job number of the child job, the cost department of the child job, the cost amount, and the transfer source job number which is the job number of the parent job for linking the parent job and the child job, For a target project, a purchase order processing step of creating purchase order data including a purchase order number, the contract detail number, the job numbers of the parent job and the child job, an external purchase order destination, and a purchase order amount, A sales processing step for creating sales data including a sales number, the contract detail number, a sales department, and a sales amount based on the contract detail data; An order receiving and issuing management program for executing the above.

Images