Information generation device, information generation method, and information generation program
The information generation device accurately tracks material costs and inventory at construction sites by inputting product details and generating journal entries, addressing incorrect cost management due to transported materials.
Patent Information
- Application Number
- JP2021151488
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2021-09-16
- Publication Date
- 2025-01-21
- Estimated Expiration
- 2041-09-16
AI Technical Summary
In construction work, materials transported to the site, including unused materials, are often recorded as costs for unfinished construction, leading to incorrect cost management.
An information generation device and method that directly inputs product names, quantities, and unit prices of materials to the construction site, calculating amounts and setting credit or debit accounts based on their status, generating journal entries to accurately track inventory and usage, distinguishing between materials brought from a warehouse and those directly delivered.
Enables accurate cost management of materials at the construction site, ensuring proper inventory tracking and recording of unfinished construction expenditures.
Smart Images

Figure 0007618523000001 
Figure 0007618523000002 
Figure 0007618523000003
Abstract
Description
[Technical field]
[0001] The present invention relates to an information generating device, an information generating method, and an information generating program. [Background technology]
[0002] An example of an invention for cost management in the field of construction work, such as the construction industry, is an information generating device disclosed in Patent Document 1. This information generating device generates cost information for materials and equipment received for construction work, and generates journal entry information in which a debit account item related to stored goods and a credit account item corresponding to a specified cost item are set for each piece of cost information. This information generating device also generates cost information for materials and equipment issued for construction work, and generates journal entry information in which a debit account item corresponding to a specified cost item and a credit account item related to stored goods are set for each piece of cost information. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] Patent Publication No. 2021-51475 Summary of the Invention [Problem to be solved by the invention]
[0004] In construction and other works, when materials are transported to the construction site, if the materials at the construction site, including unused materials, are recorded as uncompleted construction expenditures, proper cost management becomes impossible.
[0005] The present invention has been made in consideration of the above, and aims to provide an information generating device, an information generating method, and an information generating program that can properly manage the costs of materials at a construction site. [Means for solving the problem]
[0006] In order to solve the above problems and achieve the object, an information generating device according to the present invention comprises: The name, quantity and unit price of materials directly delivered to the construction site without going through the warehouse, or materials delivered from the warehousea first data generating means for generating first data including the names, quantities and unit prices of materials moved to a construction site; The materials directly delivered to the construction site or moved from the warehouse to the construction site Calculating the amount of the material based on the quantity and unit price of the material of the item name included in the first data; In the case of materials directly input to a construction site, the construction payable for the materials is set as a credit item, and in the case of materials moved from a warehouse to the construction site, the materials are set as a credit item; a first journal information generating means for generating first journal information in which the material is set as a debit item for the inventory of the construction site and the amount is journalized; and a second data generating means for generating second data including the name, quantity, and unit price of the material used at the construction site. At the construction site Calculating the amount of the material used based on the quantity and unit price of the material of the item name included in the second data; The materials used at the construction site out of the inventory at the construction site are credited as an item, and a second journal entry information generating means for generating second journal entry information in which the materials are set as uncompleted construction expenditures and the amount is entered.
[0008] Further, an information generating method according to the present invention is an information generating method executed by a control unit of an information generating device including a control unit, The name, quantity and unit price of materials directly delivered to the construction site without going through the warehouse, or materials delivered from the warehouse a first data generation step of generating first data including the names, quantities, and unit prices of materials moved to the construction site; The materials directly delivered to the construction site or moved from the warehouse to the construction site Calculating the amount of the material based on the quantity and unit price of the material of the item name included in the first data; In the case of materials directly input to a construction site, the construction payable for the materials is set as a credit item, and in the case of materials moved from a warehouse to the construction site, the materials are set as a credit item; A first journal information generation step of generating first journal information in which the material is set as inventory at the construction site and the amount is journalized; and a second data generation step of generating second data including the name, quantity, and unit price of the material used at the construction site. At the construction site Calculating the amount of the material used based on the quantity and unit price of the material of the item name included in the second data; The materials used at the construction site out of the inventory at the construction site are credited as an item, and a second journal entry information generating step of generating second journal entry information in which the materials are set as uncompleted construction expenditures and the amount is entered.
[0009] The information generating program according to the present invention is configured to execute the following steps on a computer: The name, quantity and unit price of materials directly delivered to the construction site without going through the warehouse, or materials delivered from the warehouse a first data generation step of generating first data including the names, quantities, and unit prices of materials moved to the construction site; The materials directly delivered to the construction site or moved from the warehouse to the construction siteCalculating the amount of the material based on the quantity and unit price of the material of the item name included in the first data; In the case of materials directly input to a construction site, the construction payable for the materials is set as a credit item, and in the case of materials moved from a warehouse to the construction site, the materials are set as a credit item; A first journal information generation step of generating first journal information in which the material is set as inventory at the construction site and the amount is journalized; and a second data generation step of generating second data including the name, quantity, and unit price of the material used at the construction site. At the construction site Calculating the amount of the material used based on the quantity and unit price of the material of the item name included in the second data; The materials used at the construction site out of the inventory at the construction site are credited as an item, and generating second journal entry information in which the materials are set as uncompleted construction expenditures as a debit item and second journal entry information is generated in which the amount is entered. Effect of the Invention
[0010] According to the present invention, it is possible to appropriately manage the costs of materials at a construction site. [Brief description of the drawings]
[0011] [Figure 1] FIG. 1 is a block diagram illustrating an example of a configuration of a task assistance device according to an embodiment. [Diagram 2] FIG. 2 is a diagram showing an example of a product master, a construction type master, a transaction type and product type item master, a project cost item category master, and a project cost item category breakdown master according to the embodiment. [Diagram 3] FIG. 3 is a diagram illustrating an example of contract data according to the embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of purchase data, inventory data, and journal information according to the embodiment. [Diagram 5] FIG. 5 is a diagram illustrating an example of the transfer process data, the transfer data, the inventory data, and the journal information according to the embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a display screen according to the embodiment. [Figure 7] FIG. 7 is a diagram illustrating an example of the transfer process data, the transfer data, the inventory data, and the journal information according to the embodiment. [Figure 8]FIG. 8 is a diagram illustrating an example of journal information according to the embodiment. [Figure 9] FIG. 9 is a diagram illustrating an example of purchase data and accounting information according to the embodiment. [Figure 10] FIG. 10 is a diagram showing an example of a display screen according to the embodiment. [Figure 11] FIG. 11 is a diagram illustrating an example of the transfer process data, the transfer data, and the journal information according to the embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0012] Hereinafter, an embodiment of an information generating device, an information generating method, and an information generating program according to the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to the embodiment.
[0013] [1. Configuration] An example of the configuration of a task support device, which is an example of an information generating device according to the present embodiment, will be described with reference to Fig. 1. Fig. 1 is a block diagram showing an example of the task support device according to the embodiment.
[0014] The business support device 100 is a device that supports cost management and accounting in the construction industry. The business support device 100 is installed, for example, in the business premises of a construction company that carries out the construction business.
[0015] The business support device 100 is, for example, a commercially available desktop personal computer. However, the business support 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, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0016] The business support device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the business support device 100 are connected to each other so as to be able to communicate with each other via any communication path.
[0017] The communication interface unit 104 communicatively connects the business support device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 is, for example, the Internet or a LAN (Local Area Network), and has a function of communicatively connecting the business support device 100 and the server 200 to each other.
[0018] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 serving as an output means 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 cooperates with a mouse to realize a pointing device function. 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.
[0019] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. For example, the storage unit 106 stores a product master 106a, a construction type master 106b, a transaction category-specific product item master 106c, a project cost item category master 106d, and a project cost item category breakdown master 106e. The storage unit 106 also stores contract data 106f, purchase data 106g, inventory data 106h, transfer processing data 106i, and transfer data 106j. The master and data stored in the storage unit 106 may be stored in the server 200, for example, and the master and data processed by the control unit 102 may be obtained from the server 200.
[0020] FIG. 2 is a diagram showing an example of the product master 106a, the work type master 106b, the transaction category product item master 106c, the project cost item category master 106d, and the project cost item category breakdown master 106e. The product master 106a is a master for managing information on materials used in construction work, such as construction work, on a material-by-material basis, and includes, for example, the material product code, the material product name, and the project cost item category. The work type master 106b is a master for managing contracts related to construction work, and includes the work type code, the work type name, and the business category. The transaction category product item master 106c is a master for managing account items according to material transactions, and includes the input category, the transaction category, the product code, and the account item. The project cost item category master 106d is a master for managing account items related to construction work, and includes the project cost item category, the project cost item category name, and the account item. The project cost item category breakdown master 106e is a master for managing the account items of materials related to the construction work, and includes project cost item categories, business categories, and account items.
[0021] The contract data 106f is data for managing information on the contract for the construction work contracted by the construction company. The contract data 106f includes a PJ number, a contract number, a contract line number, a construction type, and a contract name.
[0022] The purchase data 106g is data for managing information on materials used in construction work contracted by the construction company. The purchase data 106g includes a purchase number, a purchase line number, a purchase category, a product, a quantity, a unit price, an amount, a project number, a contract number, and a contract line number.
[0023] The inventory data 106h is data for managing the inventory of materials used in construction work. The inventory data 106h includes warehouses, products, and quantities.
[0024] The transfer process data 106i is data that manages the transfer origin and transfer destination of materials used in construction. The transfer process data 106i includes a transfer process number, a transfer process line number, a transfer process category, a product, a quantity, a unit price, an amount, a transfer number 1, a transfer number 2, a transfer origin (warehouse, project number, contract number, contract line number), and a transfer destination (warehouse, project number, contract number, contract line number).
[0025] The movement data 106j is data for managing the movement of materials used in construction work. The movement data 106j includes a movement number, a movement line number, a movement category, a warehouse, a product, a quantity, a unit price, an amount, a project number, a contract number, and a contract line number.
[0026] The control unit 102 is a CPU or the like that performs overall control of the business support device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. The control unit 102 conceptually includes a first data generation unit 102a, a first journalization information generation unit 102b, a second data generation unit 102c, and a second journalization information generation unit 102d.
[0027] The first data generating unit 102a as a first data generating means generates purchase data 106g and movement data 106j as first data including the name, quantity, and unit price of the materials moved to the construction site.
[0028] The first journal information generating unit 102b as a first journal information generating means generates journal information 502 and journal information 507, which will be described later, as first journal information, based on the purchase data 106g or the transfer data 106j.
[0029] The second data generating unit 102c as a second data generating means generates movement processing data 106i and movement data 106j as second data including the name, quantity, and unit price of the materials that have been moved to and used at the construction site.
[0030] A second journal information generating unit 102d serving as a second journal information generating means generates journal information 503 and journal information 508, which will be described later, as second journal information based on the transfer data 106j.
[0031] [2. Specific examples of processing] Here, a specific example of the process executed by the business support device 100 will be described with reference to Fig. 3 to Fig. 11. In the following description, a process performed by the business support device 100 when a construction company signs a contract for a construction project and materials are input from the construction company's warehouse to a construction site for the construction project, and a process performed by the business support device 100 when materials are input directly to the construction site without going through the warehouse will be described.
[0032] First, a process performed by the business support device 100 when materials are input from a construction contractor's warehouse to a construction site will be described. When a construction contractor signs a contract for construction work, an operator operates the input device 112 to generate contract data 106f for managing the contract.
[0033] For example, when an operator operates the input device 112 to register the contract name of a construction contract on a screen for registering a construction contract displayed on the monitor 114, the business support device 100 stores the contract name "XX construction contract", the construction type "construction", the PJ number "PJ00000001", the contract number "PJJUC00001", and the contract line number "001" in the first line of the contract data 106f, as shown in FIG. 3. The data in the first line of the contract data 106f is data corresponding to the contract to be registered. For convenience of explanation, the data in the first line of the contract data 106f may be referred to as a contract for construction management. The PJ number "PJ00000001" in the first line of the contract data 106f is a number uniquely assigned to the contract to be registered. The contract number "PJJUC00001" in the first line of the contract data 106f is a number uniquely assigned to the contract for construction management.
[0034] Furthermore, the business support device 100 stores the contract name "XX construction contract (site inventory management)", construction type "site inventory", PJ number "PJ00000001", contract number "PJJUC00002", and contract line number "001" in the second line of the contract data 106f. The data in the second line of the contract data 106f is data used to manage the on-site inventory of materials used in the construction work related to the contract. For ease of explanation, the data in the second line of the contract data 106f may be referred to as a contract for on-site inventory management. The contract number "PJJUC00002" is a number uniquely assigned to a contract for on-site inventory management.
[0035] When materials are to be delivered from a warehouse to a construction site for a construction project related to a contract, the operator registers the materials to be used in the construction project in the task support device 100, and generates purchase data 106g and inventory data 106h. Specifically, when delivering materials from the construction contractor's warehouse to the construction site, the operator operates the input device 112, specifies "warehouse purchase" as the purchase category on a screen for registering materials to be used in the construction project displayed on the monitor 114, and inputs the name of the warehouse where the materials are stored, the product name, quantity, and unit price of the materials.
[0036] For example, when "warehouse purchase" is specified as the purchase category, "warehouse A" as the warehouse name, "material A" as the product name, "500" as the quantity, and "100 yen" as the unit price are input, the business support device 100 stores the purchase number "SII0000001", purchase line number "001", purchase category "warehouse purchase", product "material A", quantity "500", unit price "100", and amount "50,000" in the purchase data 106g, as shown in Fig. 4. The amount "50,000" is calculated by multiplying the quantity "500" by the unit price "100". The business support device 100 also stores the warehouse "warehouse A", product "material A", and quantity "500" in the inventory data 106h in association with each other. In addition, when "warehouse purchase" is specified as the purchase category, "warehouse A" is input as the warehouse name, "material B" as the product name, "500" as the quantity, and "200 yen" as the unit price, the business support device 100 stores the purchase number "SII0000001", the purchase line number "002", the purchase category "warehouse purchase", the product "material B", the quantity "500", the unit price "200", and the amount "100,000" in the purchase data 106g, as shown in Fig. 4. The amount "100,000" is calculated by multiplying the quantity "500" by the unit price "200". In addition, the business support device 100 stores the warehouse "warehouse A", the product "material B", and the quantity "500" in the inventory data 106h in association with each other. At this point, since the construction work to be used for materials A and B has not been decided, the project number, contract number, and contract line number of the purchase data 106g are not registered.
[0037] Here, when the operator performs accounting operations for the "XX construction contract" on the business support device 100, the business support device 100 determines the debit account by referring to the product master 106a and the transaction category-specific product account master 106c, because the purchase data 106g does not contain the project number and contract number at this point.
[0038] For example, the business support device 100 refers to the product master 106a for the product "material A" from the first line of the purchase data 106g, acquires the product code "S001" of "material A", and acquires the account item "material (inventory)" by referring to the transaction category-specific product item master 106c with the input category "purchase", the transaction category "warehouse purchase" of the first line, and the acquired product code "S001". Also, the business support device 100 refers to the product master 106a for the product "material B" from the second line of the purchase data 106g, acquires the product code "S002" of "material B", and acquires the account item "material (inventory)" by referring to the transaction category-specific product item master 106c with the input category "purchase", the transaction category "warehouse purchase" of the second line, and the acquired product code "S002". The business support device 100 generates the journal information 501 shown in FIG. 4 based on the purchase data 106g and the acquired account items.
[0039] Next, when materials A and B are sent from warehouse A to the construction site for a construction project with a contract name "XX Construction Project Contract", the operator operates input device 112 to register the movement of materials A and B in the task support device 100. Here, the operator operates input device 112 to input the contract name of the construction project, the material movement processing category, the product name of the material to be moved from the warehouse to be used in the construction project, and the quantity of the material to be moved on the screen for registering the movement of materials displayed on monitor 114.
[0040] For example, when an operator inputs "XX construction contract" as the contract name, "on-site input" as the transfer processing category, "material A" as the product name, and "100" as the quantity through the input device 112, the business support device 100 stores the transfer processing number "IDS0000001", the transfer processing row number "001", the transfer processing category "on-site input", the product "material A", the quantity "100", the unit price "100", the amount "10,000", and the transfer number 1 "IDO0000001" in the transfer processing data 106i as shown in FIG. 5. In addition, since 100 units of material A are transferred from warehouse A, the business support device 100 updates the quantity of the product "material A" to "400" in the inventory data 106h. In addition, the business support device 100 updates the first row of the transfer source column of the transfer processing data 106i to "warehouse A" where the material was stored. In addition, the business support device 100 references the contract data 106f with the input contract name "XX construction contract" to obtain the PJ number "PJ00000001" and the contract number "PJJUC00002", and stores the obtained PJ number and contract number in the PJ number column and contract number column in the first row of the destination column of the transfer processing data 106i.
[0041] In addition, when the operator inputs "XX construction contract" as the contract name, "on-site input" as the transfer processing category, "material B" as the product name, and "200" as the quantity, the business support device 100 stores the transfer processing number "IDS0000001", the transfer processing row number "002", the transfer processing category "on-site input", the product "material B", the quantity "200", the unit price "200", the amount "40,000", and the transfer number "IDO0000001" in the transfer processing data 106i as shown in FIG. 5. In addition, since 200 units of material B are transferred from warehouse A, the business support device 100 updates the quantity of the product "material B" to "300" in the inventory data 106h. In addition, the business support device 100 updates the second row of the transfer source column of the transfer processing data 106i to "warehouse A" where the material was stored. In addition, the business support device 100 references the contract data 106f with the input contract name "XX construction contract" to obtain the PJ number "PJ00000001" and the contract number "PJJUC00002", and stores the obtained PJ number and contract number in the PJ number column and contract number column in the second row of the destination column of the transfer processing data 106i.
[0042] The business support device 100 determines the transfer number 1 and transfer number 2 of the transfer process data 106i according to the transfer process category designated by the operator. When "on-site input" is designated as the transfer process category, the business support device 100 determines one transfer number for one voucher, updates the column for transfer number 1 with the same transfer number, and generates transfer data 106j for journal entry generation that transfers materials from the warehouse, which is the transfer source, to the inventory management contract, which is the transfer destination, for the updated transfer number 1. As described above, when "on-site input" is entered as the transfer process category, the business support device 100 generates the transfer data 106j shown in FIG. 5.
[0043] Here, when the operator performs the accounting operation for the "XX construction contract" on the business support device 100, the business support device 100 first determines the credit account. For example, the business support device 100 acquires the product code "S001" of "material A" from the first line of the movement data 106j by referring to the product master 106a for the product "material A", and acquires the account item "material (inventory)" by referring to the transaction category-specific product account master 106c for the input category "movement", transaction category "contract input", and acquired product code "S001". In addition, the business support device 100 acquires the product code "S002" of "material B" from the second line of the movement data 106j by referring to the product master 106a for the product "material B", and acquires the account item "material (inventory)" by referring to the transaction category-specific product account master 106c for the input category "movement", transaction category "contract input", and acquired product code "S002".
[0044] Next, the business support device 100 determines the debit item. For example, the business support device 100 acquires the project cost item category "G001" of the item "material A" from the first line of the movement data 106j by referring to the product master 106a for the item "material A". The business support device 100 acquires the construction type "site inventory" from the first line of the movement data 106j by referring to the contract data 106f for the contract number "PJJUC00002", and acquires the business category "Z002" from the acquired construction type "site inventory" by referring to the construction type master 106b. The business support device 100 determines the account category "material (site inventory)" from the acquired project cost item category "G001" and the acquired business category "Z002" by referring to the project cost item category breakdown master 106e.
[0045] The business support device 100 also references the product master 106a for the product "materials B" from the second line of the movement data 106j to acquire the project cost item category "G002" for "materials B". The business support device 100 references the contract data 106f for the contract number "PJJUC00002" from the second line of the movement data 106j to acquire the construction type "site inventory", and references the construction type master 106b for the acquired construction type to acquire the business category "Z002". The business support device 100 references the project cost item category breakdown master 106e for the acquired project cost item category "G002" and the acquired business category "Z002" to determine the account category "materials (site inventory)". The business support device 100 generates the journal information 502 shown in FIG. 5 based on the movement data 106j and the acquired account category.
[0046] Next, for a construction project with a contract name "XX Construction Project Contract", when materials A and B sent to the construction site are used at the construction site, the operator operates the input device 112 to register the movement of materials A and B in the business support device 100. Note that, on the screen for registering the use of materials at the construction site, when the purchase category of the purchase data 106g is "warehouse purchase", for example, a display screen 601 shown in FIG. 6, which displays the stock of the material's source based on the movement processing data 106i, is displayed on the monitor 114, and the stock of materials not used at the construction site can be confirmed.
[0047] Here, the operator operates the input device 112 to input the construction contract name, the material transfer processing category, the product name of the material used in the construction, and the quantity of the material to be transferred on the screen for registering the material transfer displayed on the monitor 114. For example, when the operator inputs "XX Construction Contract" as the contract name, "Cost Input" as the transfer processing category, "Material A" as the product name, and "50" as the quantity, the business support device 100 updates the record of the transfer processing row number "001" in the transfer processing data 106i to "Cost Input", quantity "50", amount "5,000", transfer number 1 "IDO0000002", and transfer number 2 "IDO0000003", as shown in Fig. 7. The business support device 100 also refers to the data of the contract for on-site inventory management in the contract data 106f related to the input contract name "XX construction contract", acquires the PJ number "PJ00000001" and the contract number "PJJUC00002", and stores the acquired PJ number and contract number in the PJ number column and the contract number column of the first row of the source column of the transfer processing data 106i. The business support device 100 also refers to the data of the contract for construction management in the contract data 106f related to the input contract name "XX construction contract", acquires the PJ number "PJ00000001" and the contract number "PJJUC00001", and stores the acquired PJ number and contract number in the PJ number column and the contract number column of the first row of the destination column of the transfer processing data 106i.
[0048] Also, when the operator inputs "XX construction contract" as the contract name, "cost input" as the transfer processing category, "material B" as the product name, and "100" as the quantity, the business support device 100 updates the record of the transfer processing row number "002" in the transfer processing data 106i to "cost input", quantity "100", amount "20,000", transfer number 1 "IDO0000004", and transfer number 2 "IDO0000005" as shown in Fig. 7. Also, the business support device 100 acquires the PJ number "PJ00000001" and the contract number "PJJUC00002" by referring to the data of the contract for on-site inventory management in the contract data 106f related to the input contract name "XX construction contract", and stores the acquired PJ number and contract number in the PJ number column and the contract number column of the second row of the transfer source column of the transfer processing data 106i. In addition, the business support device 100 references the data of the construction management contract in the contract data 106f related to the input contract name "XX Construction Contract" to obtain the PJ number "PJ00000001" and the contract number "PJJUC00001", and stores the obtained PJ number and contract number in the PJ number column and contract number column in the second row of the destination column of the transfer processing data 106i.
[0049] The business support device 100 determines the transfer number 1 and the transfer number 2 of the transfer processing data 106i according to the transfer processing category designated by the operator. When "cost input" is designated as the transfer processing category, the business support device 100 determines two transfer numbers for one slip, stores one in the transfer number 1 column, and stores the other in the transfer number 2 column.
[0050] As shown in Figure 7, the business support device 100 generates transfer data 106j that includes data for generating an accounting entry to transfer materials from the source contract to the dummy warehouse for the updated transfer number 1, and data for generating an accounting entry to transfer materials from the dummy warehouse to the destination contract for the updated transfer number 2.
[0051] Here, when the operator performs the accounting operation for the "XX construction contract" on the business support device 100, the business support device 100 first determines the credit account. For example, the business support device 100 acquires the product code "S001" of "material A" by referring to the product master 106a for the product "material A" from the first line of the movement data 106j, and acquires the account item "material (inventory)" by referring to the transaction category-specific product account master 106c with the input category "movement", transaction category "contract input", and the acquired product code "S001". Also, the business support device 100 acquires the product code "S001" of "material A" by referring to the product master 106a for the product "material A" from the second line of the movement data 106j, and acquires the account item "material (inventory)" by referring to the transaction category-specific product account master 106c with the input category "movement", transaction category "contract input", and the acquired product code "S001".
[0052] The business support device 100 references the product master 106a for the product "material B" from the third line of the movement data 106j, acquires the product code "S002" of "material B", and acquires the account item "materials (inventory)" by referencing the transaction category-by-product-item master 106c with the input category "movement", transaction category "contract input", and the acquired product code "S002". Also, the business support device 100 references the product master 106a for the product "material B" from the fourth line of the movement data 106j, acquires the product code "S002" of "material B", and acquires the account item "materials (inventory)" by referencing the transaction category-by-product-item master 106c with the input category "movement", transaction category "contract input", and the acquired product code "S002".
[0053] Next, the business support device 100 determines the debit item. From the first line of the movement data 106j, the business support device 100 references the product master 106a for the product "material A" to obtain the project cost item category "G001" for "material A". From the first line of the movement data 106j, the business support device 100 references the contract data 106f for the contract number "PJJUC00002" to obtain the construction type "site inventory", and references the construction type master 106b for the obtained construction type to obtain the business category "Z002". The business support device 100 references the project cost item category breakdown master 106e for the obtained project cost item category "G001" and the obtained business category "Z002" to determine the account category "materials (site inventory)".
[0054] The business support device 100 references the product master 106a for the product "materials B" from the third line of the movement data 106j to obtain the project cost item category "G002" for "materials B". The business support device 100 references the contract data 106f for the contract number "PJJUC00002" from the third line of the movement data 106j to obtain the work type "site inventory", and references the work type master 106b for the obtained work type to obtain the business category "Z002". The business support device 100 references the project cost item category breakdown master 106e for the obtained project cost item category "G002" and the obtained business category "Z002" to determine the account category "materials (site inventory)".
[0055] The business support device 100 acquires the project cost item category "G001" of the item "material A" from the second line of the movement data 106j by referring to the product master 106a for the item "material A". The business support device 100 acquires the construction type "construction" from the second line of the movement data 106j by referring to the contract data 106f for the contract number "PJJUC00001", and acquires the business category "Z001" from the construction type acquired by referring to the construction type master 106b. The business support device 100 acquires the project cost item category "G001" acquired and the business category "Z001" acquired by referring to the project cost item category breakdown master 106e. Here, since the project cost item category breakdown master 106e does not have a combination of the project cost item category "G001" and the business category "Z001", the project cost item category "G001" is acquired by referring to the project cost item category master 106d.
[0056] The business support device 100 acquires the project cost item category "G002" of the item "material B" from the fourth line of the movement data 106j by referring to the product master 106a for the item "material B". The business support device 100 acquires the construction type "construction" from the fourth line of the movement data 106j by referring to the contract data 106f for the contract number "PJJUC00001", and acquires the business category "Z001" from the construction type acquired by referring to the construction type master 106b. The business support device 100 acquires the project cost item category "G002" acquired and the business category "Z001" acquired by referring to the project cost item category breakdown master 106e. Here, since the project cost item category breakdown master 106e does not have a combination of the project cost item category "G002" and the business category "Z001", the project cost item category "G002" is acquired by referring to the project cost item category master 106d and the project cost item category "G002" is acquired.
[0057] The business support device 100 generates the journal information 503 shown in FIG. 7 based on the transfer data 106j and the acquired account item. Specifically, the business support device 100 generates the journal information 504 shown in FIG. 8 for the acquired account item "materials (inventory)" and the account item "materials (site inventory)" based on the first line (first detail) and the third line (third detail) of the transfer data 106j, and generates the journal information 505 by reversing the debit and credit of the journal information 504. In addition, the business support device 100 generates the journal information 506 shown in FIG. 8 for the acquired account item "materials (inventory)" and the account item "uncompleted construction expenditure" based on the second line (second detail) and the fourth line (fourth detail) of the transfer data 106j. The business support device 100 combines the journal information 505 and the journal information 506 to offset the amount of materials (inventory) and generates the journal information 503.
[0058] Next, a process performed by the task support device 100 when materials are directly input to a construction site without going through a warehouse will be described. When a construction contractor signs a contract for construction work, the operator generates contract data 106f for managing the contract by operating the input device 112. Here, the contract data 106f shown in FIG. 3 is generated in the same manner as when materials are input from the construction contractor's warehouse to the construction site.
[0059] For construction work related to a contract, when materials are directly input to the construction site without going through a warehouse, the operator registers the materials to be used in the construction work in the task support device 100 and generates purchase data 106g. Specifically, when materials are directly input to the construction site, the operator operates the input device 112 to specify the name of the construction work on a screen for registering materials to be used in the construction work displayed on the monitor 114, specify "direct purchase from site" as the purchase category, and input the product name, quantity, and unit price of the materials to be input.
[0060] For example, when "XX Construction Contract" is specified as the construction name, "Direct on-site purchase" is specified as the purchase category, "Material A" as the product name, "500" as the quantity, and "100 yen" as the unit price are input, the business support device 100 stores the purchase number "SII0000001," purchase line number "001," purchase category "Direct on-site purchase," product "Material A," quantity "500," unit price "100," and amount "50,000" in the purchase data 106g, as shown in Fig. 9. The amount "50,000" is calculated by multiplying the quantity "500" and the unit price "100."
[0061] In addition, when "XX Construction Contract" is specified as the construction name, "On-site Direct Purchase" is specified as the purchase category, "Material B" as the product name, "500" as the quantity, and "200 yen" as the unit price are input, the business support device 100 stores the purchase number "SII0000001", the purchase line number "002", the purchase category "On-site Direct Purchase", the product "Material B", the quantity "500", the unit price "200", and the amount "100,000" in the purchase data 106g as shown in FIG. 9. The amount "100,000" is calculated by multiplying the quantity "500" and the unit price "200". The business support device 100 acquires the PJ number and the contract number of the purchase data 106g by referring to the contract data 106f using the construction name "XX Construction Contract", and stores the acquired numbers.
[0062] Here, when an operator performs accounting operations for the "XX construction contract" on the business support device 100, if the PJ number and contract number are stored in the purchase data 106g, the business support device 100 determines the debit item by referring to the product master 106a, construction type master 106b, project cost item category master 106d, and project cost item category breakdown master 106e.
[0063] For example, the business support device 100 acquires the project cost item category "G001" of the product "material A" from the first line of the purchase data 106g by referring to the product master 106a for "material A". Also, the business support device 100 acquires the construction type "site inventory" from the first line of the purchase data 106g by referring to the contract data 106f for the project number "PJ00000001" and the contract number "PJJUC00002", and acquires the business category "Z002" by referring to the construction type master 106b for the acquired construction type. Next, the business support device 100 acquires the account category "material (site inventory)" by referring to the project cost item category breakdown master 106e for the acquired project cost item category "G001" and the acquired business category "Z002".
[0064] The business support device 100 acquires the project cost item category "G002" of the product "material B" from the second line of the purchase data 106g by referring to the product master 106a for the product "material B". Also, the business support device 100 acquires the construction type "site stock" from the second line of the purchase data 106g by referring to the contract data 106f for the PJ number "PJ00000001" and the contract number "PJJUC00002", and acquires the business category "Z002" by referring to the construction type master 106b for the acquired construction type. Next, the business support device 100 acquires the account category "material (site stock)" by referring to the project cost item category breakdown master 106e for the acquired project cost item category "G002" and the business category "Z002". The business support device 100 generates the journal information 507 shown in FIG. 9 based on the purchase data 106g and the acquired account category.
[0065] Next, for a construction project with a contract name "XX Construction Project Contract", when materials A and B sent to the construction site are used at the construction site, the operator operates the input device 112 to register the movement of materials A and B in the business support device 100. Note that, on the screen for registering the use of materials at the construction site, when the purchase category of the purchase data 106g is "direct purchase from site", a display screen 602 shown in FIG. 10, which displays, for example, the inventory of the material's source based on the purchase data 106g, is displayed on the monitor 114, and the operator can check the inventory of materials not used at the construction site.
[0066] Here, the operator operates the input device 112 to input the construction contract name, the material transfer processing category, the product name of the material used in the construction, and the quantity of the material to be transferred on the screen for registering the material transfer displayed on the monitor 114. For example, when the operator inputs "XX Construction Contract" as the contract name, "cost input" as the transfer processing category, "material A" as the product name, and "50" as the quantity, the business support device 100 updates the record of the transfer processing row number "001" in the transfer processing data 106i to "cost input", quantity "50", amount "5,000", transfer number 1 "IDO0000001", and transfer number 2 "IDO0000002", as shown in Fig. 11. The business support device 100 also refers to the data of the contract for on-site inventory management in the contract data 106f related to the input contract name "XX construction contract", acquires the PJ number "PJ00000001" and the contract number "PJJUC00002", and stores the acquired PJ number and contract number in the PJ number column and the contract number column of the first row of the source column of the transfer processing data 106i. The business support device 100 also refers to the data of the contract for construction management in the contract data 106f related to the input contract name "XX construction contract", acquires the PJ number "PJ00000001" and the contract number "PJJUC00001", and stores the acquired PJ number and contract number in the PJ number column and the contract number column of the first row of the destination column of the transfer processing data 106i.
[0067] Also, when the operator inputs "XX construction contract" as the contract name, "cost input" as the transfer processing category, "material B" as the product name, and "100" as the quantity, the business support device 100 updates the record of the transfer processing row number "002" in the transfer processing data 106i with the transfer processing category "cost input", the quantity "100", the amount "20,000", the transfer number 1 "IDO0000003", and the transfer number 2 "IDO0000004" as shown in Fig. 11. Also, the business support device 100 acquires the PJ number "PJ00000001" and the contract number "PJJUC00002" by referring to the data of the contract for on-site inventory management in the contract data 106f related to the input contract name "XX construction contract", and stores the acquired PJ number and contract number in the PJ number column and the contract number column of the second row of the transfer source column of the transfer processing data 106i. In addition, the business support device 100 references the data of the construction management contract in the contract data 106f related to the input contract name "XX construction contract" to obtain the PJ number "PJ00000001" and the contract number "PJJUC00001", and stores the obtained PJ number and contract number in the PJ number column and contract number column in the second row of the destination column of the transfer processing data 106i.
[0068] As shown in FIG. 11 , the business support device 100 generates transfer data 106j including data for generating an accounting entry to transfer materials from the source contract to the dummy warehouse for the updated transfer number 1, and data for generating an accounting entry to transfer materials from the dummy warehouse to the destination contract for the updated transfer number 2.
[0069] Here, when the operator performs an accounting operation for the "XX construction contract" on the business support device 100, the business support device 100 determines the credit and debit items in the same way as when materials are brought from a warehouse to a construction site, and generates the accounting information 508 shown in Fig. 11 based on the movement data 106j and the acquired credit and debit items. The generation of the accounting information 508 is the same as when materials are brought from a warehouse to a construction site, so a description thereof will be omitted.
[0070] [3. Effects of the embodiment] According to the business support device 100 of the embodiment, materials inputted to a construction site are treated as on-site inventory, and when the materials are used at the construction site, they can be recorded as uncompleted construction expenditures from the on-site inventory at cost. Also, if materials at the construction site, including unused materials, are treated as uncompleted construction expenditures, the construction site inventory cannot be managed properly, but according to the business support device 100, the number of materials not used in construction at the construction site can be known, and material inventory management can be performed properly.
[0071] [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 goals 8 and 9 of the SDGs.
[0072] 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.
[0073] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0074] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0075] 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.
[0076] In addition, 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 may be changed as desired unless otherwise specified.
[0077] Moreover, with regard to the task support device 100, each of the components shown in the figures is a functional concept, and does not necessarily have to be physically configured as shown in the figures.
[0078] For example, the processing functions of the business support device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in the present embodiment, and is mechanically read by the business support device 100 as necessary. That is, a computer program for giving 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 a RAM, and constitutes the control unit 102 in cooperation with the CPU.
[0079] In addition, this computer program may be stored in an application program server connected to the task support device 100 via any network, and it is also possible to download all or a part of it as necessary.
[0080] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "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.
[0081] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that works with a separate program, such as an OS, to achieve its function. 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, may use well-known configurations and procedures.
[0082] The various databases etc. stored in the memory unit 106 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 etc. used for various processes and providing websites.
[0083] The business support device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The business support device 100 may be realized by installing software (including programs or data, etc.) that causes the information processing device to realize the processing described in this embodiment.
[0084] Furthermore, the specific form of distribution and integration of the devices is not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or function additions. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0085] The present invention is useful in the construction industry. [Explanation of symbols]
[0086] 100 Business support equipment 102 Control section 102a First data generation unit 102b First journal entry information generation unit 102c Second data generation unit 102d Second journal entry information generation unit 104 Communication interface section 106 Storage section 106a Product Master 106b Construction type master 106c Transaction category and product item master 106d Project Cost Item Classification Master 106e Project Cost Item Classification Master 106f Contract Data 106g Purchase Data 106h Stock Data 106i Mobile Processing Data 106j Movement Data 108 Input / Output Interface Section 112 Input Device (Keyboard) 114 Output device (monitor) 200 Servers 300 Network 501~508 Journal information 601, 602 display screen
Claims
1. An information generating device including a control unit, a first data generating means for generating first data including the name, quantity and unit price of materials directly input to the construction site without going through the warehouse, or the name, quantity and unit price of materials moved from the warehouse to the construction site; a first journal information generating means for calculating the amount of the materials directly input to a construction site or the materials moved from a warehouse to the construction site based on the quantity and unit price of the materials of the item name included in the first data, and for the materials directly input to the construction site, setting the construction payable amount for the materials as a credit item, and for the materials moved from a warehouse to the construction site, setting the materials as a credit item and setting a debit item for the materials as inventory at the construction site to generate first journal information in which the amount is entered; A second data generating means for generating second data including the names, quantities, and unit prices of the materials used at the construction site; a second journal information generating means for generating second journal information in which the amount of the materials used at the construction site is calculated based on the quantity and unit price of the materials of the item names included in the second data, the materials used at the construction site from the inventory of the construction site are set as credit items, and the materials are set as debit items as uncompleted construction expenditures, and the amount is journalized; An information generating device comprising:
2. An information generating method executed by a control unit of an information generating device including a control unit, A first data generation step of generating first data including the name, quantity and unit price of materials directly input to the construction site without going through the warehouse, or the name, quantity and unit price of materials moved from the warehouse to the construction site; a first journal information generation step of calculating the amount of the materials directly input to a construction site or the materials moved from a warehouse to the construction site based on the quantity and unit price of the materials of the item name included in the first data, and in the case of the materials directly input to the construction site, setting the construction payable for the materials as a credit account, and in the case of the materials moved from a warehouse to the construction site, setting the materials as a credit account and setting a debit account for the materials as inventory at the construction site to generate first journal information in which the amount is journalized; A second data generating step of generating second data including the names, quantities, and unit prices of the materials used at the construction site; a second journal information generation step of calculating the amount of the materials used at the construction site based on the quantity and unit price of the materials of the item names included in the second data, and generating second journal information in which the amount is journalized by setting the materials used at the construction site from the inventory of the construction site as a credit item and setting the materials as uncompleted construction expenditure as a debit item; An information generating method comprising:
3. On the computer, A first data generation step of generating first data including the name, quantity and unit price of materials directly input to the construction site without going through the warehouse, or the name, quantity and unit price of materials moved from the warehouse to the construction site; a first journal information generation step of calculating the amount of the materials directly input to a construction site or the materials moved from a warehouse to the construction site based on the quantity and unit price of the materials of the item name included in the first data, and in the case of the materials directly input to the construction site, setting the construction payable for the materials as a credit account, and in the case of the materials moved from a warehouse to the construction site, setting the materials as a credit account and setting a debit account for the materials as inventory at the construction site to generate first journal information in which the amount is journalized; A second data generating step of generating second data including the names, quantities, and unit prices of the materials used at the construction site; a second journal information generation step of calculating the amount of the materials used at the construction site based on the quantity and unit price of the materials of the item names included in the second data, and generating second journal information in which the amount is journalized by setting the materials used at the construction site from the inventory of the construction site as a credit item and setting the materials as uncompleted construction expenditure as a debit item; An information generating program characterized by causing a user to execute the above steps.
Citation Information
Patent Citations
Management method of managed article, and management system of managed article
JP2004062372A
New management accounting system, and implementation method of new management accounting
JP2006107227A
Accounting processing apparatus and its program for construction business
JP2006127295A
Accounting processing program, accounting processing device, and accounting processing method
JP2012203607A
Information generation apparatus, information generation program, and information generation method
JP2021051475A