JP5108731B2 - Construction management system - Google Patents

Description

  The present invention relates to a construction management system for managing construction, and more particularly to a construction management system capable of preventing omission of billing for construction costs.

  In general, many various members are used for construction. Taking sash construction of a house as an example, various sashes are used in a house, and each sash is composed of various members (components) such as a frame, glass, bolts, nuts, doors, locks, and the like. . The person who performs the construction purchases these members from the manufacturer, assembles the respective sashes, ships them to the site, and attaches them to the building. Then, the construction client is charged for the construction cost including the cost of the parts.

When purchasing parts, it is possible to order the parts by accessing the manufacturer's ordering system via a communication line such as the Internet from a computer and entering the product code and quantity on the displayed screen. Yes. The manufacturer who has received the order usually returns the shipping information including the delivery date to the orderer's computer. As an order receiving system that makes a delivery date reply, for example, there is one described in Patent Document 1 below.
JP 2002-245309 A

  However, it is difficult for a person who undertakes a large number of works to know which work each of the purchased parts is used for. However, there is a problem that the purchase cost of the member is forgotten to be charged to the client of the construction.

  The present invention solves the above-described problems, and an object thereof is to provide a construction management system capable of preventing omission of billing for purchased members.

The construction management system of the present invention is a construction management system capable of communicating via a communication line with an order receiving system that accepts orders for products used for construction. Property information including property identification information is provided for a plurality of construction properties. A property storage means for storing; means for transmitting order information including product identification information, order quantity and property identification information of a construction property for which the product is used, to the order receiving system; Based on the shipping information, the means for receiving shipping information including the product identification information, the shipping quantity, the shipping unit price, and the property identification information included in the ordering information for the transmitted product, and the shipping information Generating purchase information including identification information, purchase quantity and purchase unit price, and associating with the property information including the same property identification information as the property identification information in the shipping information Means for storing in said article storage means, the work done to produce a product from a components products, and property identification information of the construction work property of information and the product indicating the amount of the work is used Means for inputting an operation report including the property information, and generating the in-house operation information including information indicating the amount of the operation based on the operation report, and the property information including the same property identification information as the property identification information in the operation report In relation to the property storage means, and for each construction property, the purchase information and the in-house work information associated with the property information of the construction property and stored in the property storage means based on the all specifications losses of goods purchased for use in the construction property, means for calculating and outputting a Cst including the amount of the work done against the construction property, Characterized in that it has.

The construction management system of the present invention is a construction management system that can communicate with an order receiving system that accepts orders for products used for construction via a communication line, and includes property identification information for a plurality of construction properties. Property storage means for storing information; means for transmitting order information including product identification information, order quantity and property identification information of a construction property for which the product is used, to the order receiving system; Based on the shipment information, the means for receiving shipment information including the product identification information, the shipment quantity, the shipment unit price, and the property identification information included in the ordering information from the order receiving system. Generating purchase information including product identification information, purchase quantity and purchase unit price, and relating to the property information including the same property identification information as the property identification information in the shipment information Only, the means for storing in the property storage means, for items of inventory, and the inventory storage means for storing inventory information including the purchase price per product identification information and inventory quantity, for goods stocking, and product identification information ordering Means for transmitting order information including quantity and not including property identification information to the order receiving system; and for products for which order information not including the property identification information is transmitted, including product identification information, shipment quantity and shipping unit price. Based on the means for receiving shipping information not including the property identification information from the order receiving system and the shipping information not including the property identification information, the same product identification information as the product identification information included in the shipping information is included. A means for updating the inventory information, and for a delivered product, a delivery including product identification information, a delivery quantity, and property identification information of a construction property in which the product is used A means for inputting a notification, a means for updating the inventory information including the same product identification information as the product identification information in the delivery report, based on the delivery report, and based on the delivery report, With reference to the inventory information, issue information including product identification information, output quantity and purchase unit price is generated, and associated with the property information including the same property identification information as the property identification information in the output report, the property It means for storing in the storage means, for each construction properties, based with the purchase information associated with the listing of the construction properties stored in the property memory means and said unloading information, to the construction property having all the specifications losses of goods purchased for use, and means for outputting calculated including original amount of all the specifications losses of product which is goods issue for use in the construction property With features To do.

The program of the present invention is a property storage means for storing property information including property identification information for a plurality of construction properties, a computer that can communicate with an order receiving system that accepts orders for products used for construction via a communication line, for product stocking, the order information including the property identification information of the construction properties of ordered quantity and the product and product identification information is used, a means to transmit to said order receiving system, the product which has transmitted the order information, product identification Means for receiving shipment information including information, shipment quantity, shipment unit price, and property identification information included in the ordering information from the order receiving system; based on the shipment information, product identification information, purchase quantity and purchase The purchase information including the unit price is generated and associated with the property information including the same property identification information as the property identification information in the shipping information, and recorded in the property storage means. To means, the work done to produce a product from a components products, means for inputting a work report including the property identification information of the construction work property of information and the product indicating the amount of the work is used Based on the work report, in-house work information including information indicating the amount of the work is generated, and associated with the property information including the same property identification information as the property identification information in the work report, the property storage means And for each construction property, the construction property is stored on the basis of the purchase information and the in-house work information stored in the property storage means in association with the property information of the construction property. and all specifications losses of goods purchased for use, even for to function as means for calculating and outputting a Cst including the amount of the work done against the construction property It is.

In addition, the program of the present invention stores a property information including property identification information for a plurality of construction properties by using a computer that can communicate with an order receiving system that accepts orders for products used for construction via a communication line. Means, means for sending the order information including the product identification information, the order quantity, and the property identification information of the construction property used for the goods to be purchased; Means for receiving shipment information including identification information, shipment quantity, shipment unit price, and property identification information included in the ordering information from the order receiving system; based on the shipment information, product identification information and purchase quantity; Generating purchase information including a purchase unit price, and associating with the property information including the same property identification information as the property identification information in the shipping information, It means to be stored in, for items of inventory, inventory storage means for storing the inventory information including the input specifications and product identification information and inventory quantity unit price, about the product stocking, included the property identification information and a purchase order quantity and product identification information Means for transmitting no ordering information to the order receiving system, and for the product for which the ordering information not including the property identification information is transmitted, shipping information including the product identification information, the shipping quantity and the shipping unit price, but not including the property identification information Means for receiving from the order receiving system; means for updating the inventory information including the same product identification information as the product identification information included in the shipping information based on the shipping information not including the property identification information; Means for inputting a delivery report including product identification information, a delivery quantity, and property identification information of a construction property in which the product is used, Based on the means for updating the inventory information including the same product identification information as the product identification information in the delivery report, based on the delivery report, referring to the inventory information as necessary, the product identification information and the delivery Means for generating delivery information including quantity and purchase unit price, storing in the property storage means in association with the property information including the same property identification information as the property identification information in the delivery report, and each construction property for, on the basis of said purchase information and the unloading information associated with the listing of the construction properties stored in the property storage unit, specification of all purchases products for use in the construction property and losses, is intended to function and all the specifications losses of product which is goods issue for use in the construction property including original value to calculate the output to means as.

  According to the construction management system of the present invention, the order information including the property identification information of the construction property in which the product is used is transmitted to the supplier's order receiving system for the purchased product, and the shipment including the property identification information is transmitted. Property information that includes the same property identification information as the property identification information in the shipment information, that is, the property information of the construction property where the product is used. Store it in association with. For each construction property, based on the purchase information, a cost amount including the purchase amount of all the products purchased for use in the construction property is calculated and output. Therefore, by referring to the output cost amount and making a charge to the construction requester, even if the product used for the work is purchased, the billing forgetting to charge the part is prevented. Is possible.

  Hereinafter, an embodiment of the present invention will be described with reference to the drawings.

  As shown in FIG. 1, the construction management system S is a server-client type computer system provided in a company that undertakes construction work such as building sashes and entrances, and is connected to the server 1 and the server 1 via a LAN. A plurality of client devices (hereinafter abbreviated as “clients”) 2. The server 1 and each client 2 are each composed of a computer, an input unit composed of a keyboard, a mouse, etc., a control unit composed of a CPU, RAM, ROM, etc., and a memory composed of a semiconductor memory, a hard disk device, a compact disk device, etc. And a display unit including a liquid crystal display or the like. Each client 2 is connected to a printer (not shown) and includes an output unit for outputting print data to the printer. Both the display unit and the output unit in the client 2 are means for outputting the cost amount and the like.

  Each client 2 is connected to a plurality of order receiving systems 3A, 3B, 3C,... Via the Internet, and the construction management system S can communicate with the order receiving systems 3A, 3B, 3C,. Each of the order receiving systems 3A, 3B, 3C,.

  The server 1 includes a property database 5 corresponding to property storage means. As shown in FIG. 2, the property database 5 stores property information, budget information, purchase information, delivery information, outsourced work information, and in-house work information for each construction property by property number (hereinafter referred to as “Property No.”). Are stored in association with each other. The property number is property identification information that differs for each construction property, and consists of a 6-digit property code and a 2-digit branch number. The branch number represents a classification of main construction, additional construction, etc., and if the branch code is different even if the property code is the same, it is different from the construction property. Property information, budget information, purchase information, delivery information, outsourced work information, and in-house work information all include property numbers, and the same property number information is mutually connected via property numbers. It can be said that they are related.

  The server 1 also includes an inventory file corresponding to inventory storage means. The inventory file stores inventory information for each member (product) in stock. The inventory information includes a product name, a product code (corresponding to product identification information), a stock quantity, and a purchase unit price.

  Each client 2 includes a product master file (hereinafter, “master file” is abbreviated as “master”). In the product master, for each product, a product name, a product code, and a category “purchase” or “receipt” are stored. As described later, products with the category “Purchase” are ordered based on the construction property to be used. However, products with “Receiving” are ordered without any purpose, Once it is stored in the warehouse as inventory, it is discharged after its usage is decided.

  Each client 2 is provided with a customer master, and a customer code and a customer name are stored in the customer master in association with each other.

  Each client 2 includes a product master downloaded in advance from each manufacturer's site. The product master stores the product name for each product, and the component name (corresponding to the product name), the product code, and the quantity of the component (corresponding to the member and the product) constituting the product. In addition, a work name, work code, and quantity of work necessary for creating the product from the components are stored. Taking a sash as an example, the sash corresponds to a product, and members such as a frame and glass constituting the sash correspond to a component.

  Each client 2 includes a data file for estimation downloaded in advance from each manufacturer's site. The estimation data file includes a component name, a product code, an estimated unit price (corresponding to a planned sales unit price for the user), an original unit price (corresponding to a planned purchase unit price for the user), and a cost rate. And the work name, work code, and estimated unit price (corresponding to the scheduled work unit price for the user) of each work.

  The operation of the construction management system S configured as described above will be described with reference to FIG. Since any client 2 performs the same operation with respect to the same operation, one client 2 will be described as a representative here.

  <Property Registration> First, the construction management system S performs property registration in accordance with a user operation (step S101). Specifically, when the user performs a predetermined operation on the client 2, the client 2 displays a property registration screen as shown in FIG. When the user inputs a customer code in the customer code column 11 on the screen, the client 2 acquires a customer name corresponding to the input customer code from the customer master and stores it in the customer name column 14. indicate.

  When the server 1 displays the property registration screen on the client 2, the property code column 12 displays a new property code, that is, a property code other than the property code of the property information already registered in the property database 5. (Ie, input), and enter “00” in the branch number column 13. The user inputs the property name in the property name column 10, inputs the construction site address, etc. as basic information, and the order date, delivery date, order contents, etc., as order information.

  For example, when the property information of the main construction is already registered and the property information of the additional construction is to be registered, the user inputs the property number of the main construction in the property code column 12 and the branch number column 13. Then, the client 2 transmits the property number to the server 1, acquires property information having the property number from the property database 5, and inputs the content on the property registration screen. For example, “01” is input in the field, and necessary input is performed such as changing the order contents.

  When the user clicks a registration button (not shown) on the screen after inputting necessary information on the property registration screen, the client 2 transmits the information input to the server 1, and the server 1 receives the customer code, The property information including the customer name, property number, property name, basic information, and order information is registered (stored) in the property database 5.

  <Creation of Budget Accumulation / Budget Allocation> Next, the construction management system S creates a budget integration and budget allocation according to the user's operation (S102). Specifically, when the user performs a predetermined operation on the client 2, the client 2 displays a property information inquiry screen (not shown) on which property information registered in the property database 5 is displayed as a list. When the user selects the property information on the property information inquiry screen and clicks the estimate import button on the screen, the client 2 determines the manufacturer name of the estimate data file and the location (downloaded location) of the estimate data file. A dialog box (not shown) for designating is displayed. The reason for specifying the manufacturer name is to indicate which manufacturer the estimation data file to be imported belongs to, because the configuration of the estimation data file differs depending on the manufacturer.

  When the user specifies the manufacturer name and the location of the estimate data file in the above dialog box and performs a predetermined operation, the client 2 reads the estimate data from the estimate data file at the specified location, A budget input screen as shown in FIG. 5 for creating an integrated book is displayed. On the budget input screen, the customer code, customer name, property number, and property name of the selected property information are displayed, and the product input unit 21 is displayed. Note that FIG. 5 shows a state in which information has been input to the product input unit 21 partway, but when displayed for the first time, the product input unit 21 is blank.

  The user inputs the product classification, the window number (information indicating which opening of the building is attached), the product name, the quantity, and the like of each product necessary for the construction property in the row of the product input unit 21. When the user selects a row of the product input unit 21, the client 2 refers to the product master and the estimation data, and selects information on each component constituting the product in the selected row, and the product. Information on the work necessary for creation is displayed on the component input unit 22. The displayed component information includes the component name (product name), quantity, estimated unit price, estimated amount (= estimated unit price × quantity), original unit price, cost amount (= original unit price × quantity), and cost rate. The work information includes the work name, quantity, estimated unit price, and estimated amount. The user looks at the displayed component and work information, increases / decreases the quantity and deletes unnecessary component rows if necessary, and inputs and confirms the budget classification defined by the user. Click the button 23. Then, the client 2 calculates the estimated amount and the cost amount of the product from the estimated amount and the cost amount of each component and the estimated amount of each work, and displays them on the selected line of the product input unit 21. The next line of the product input unit 21 is automatically selected. For components and operations for which budget classification has been input, the client 2 stores the correspondence between the product name and product code (in the case of work, work name and operation code) and the budget classification in the product master. Since the budget classification is displayed on the component input unit 22, no re-input is necessary.

  As described above, the user inputs a product name and the like for each product necessary for the construction into the product input unit 21 and inputs information about the component and work in the component input unit 22 (displayed information is displayed). In this case, the client 2 calculates and displays the estimated amount and the cost amount of each product, and displays the estimated amount and the sum of the cost amount of each product on the total display unit 24, respectively. Displayed as product cost, product cost, and based on the design cost, transportation cost, various expenses, etc. in the estimate data, the necessary design cost, transportation cost, various expenses etc. added to the product cost, product cost They are displayed as grand totals and total costs, respectively. The user determines the order amount with the construction requester by looking at the grand total and the like.

  When the user completes the input on the budget input screen and performs a predetermined operation such as clicking a predetermined button, the client 2 transmits the information input on the budget input screen to the server 1, and the server 1 The above information input in is stored in the property database 5 as budget information.

  Further, when the user performs a predetermined operation after creating the budget integration report, the server 1 creates a budget allocation report based on the budget information and displays a budget allocation screen as shown in FIG. On the budget allocation screen, the customer code, customer name, property number, and property name are displayed. In addition, the budget allocation report section 16 displays the planned sales amount, purchase amount, and assembly for each budget category. The planned amount and the final purchase amount are displayed. The planned sales amount is the sum of the estimated amounts of the components belonging to that budget category, the planned purchase amount is the sum of the cost amounts of the components belonging to that budget category, and the scheduled assembly amount is included in that budget category. The final purchase amount is the sum of the planned purchase amount and the planned assembly amount (subtracting the amount if there is a property discount). The cost displayed in the cost column 19 of the budget apportionment section 16 is the total for each budget classification of the purchase amount calculated by the execution unit price described later, and the budget has been created but not yet purchased. It is “0” when there is no stage. When the user selects a line in the budget allocation report section 16 and performs a predetermined operation, the client 2 performs the above-described component information and work information for each component and each work belonging to the budget classification of the selected line. Is displayed.

  In addition, when the user inputs the order amount, the scheduled sales date, and the planned sales amount in the predetermined sales input unit 15, the client 2 displays the input order amount as the planned order amount in the planned order amount display unit 17. The final purchase amount (equivalent to the above total cost) is displayed, and the planned gross profit amount and the planned gross profit rate are calculated and displayed. The execution sales amount displayed on the execution sales amount display unit 18 is the amount that the invoice is issued, and the execution cost amount is the total purchase amount calculated by the execution unit price described later. Gross margin and effective gross margin are the gross margin and gross margin calculated from the actual sales and actual cost, but they are both “0” when the budget has been created but not yet purchased. is there.

  Information input (displayed) on the above budget distribution screen is stored in the property database 5 in association with property information having the same property number as budget information.

  <Parts Ordering> Next, the client 2 places a part order in accordance with a user operation (S103). Specifically, the client 2 accesses the order receiving systems 3A, 3B, 3C,. Although the ordering screen varies depending on the manufacturer and is not shown, the ordering screen of each manufacturer is configured so that the product name, product code, quantity, and articles (comments, notes, etc.) can be entered for each product to be purchased. . Hereinafter, the case where the client 2 accesses the order receiving system 3A will be described by using a construction property example having the contents as shown in FIG. In the example of FIG. 7, there are “XX sash” and “△△ sash” as products necessary for the construction property, and the former is the product “XX frame”, “XX glass”, and “XX bolt”. The latter is created by assembling the products “ΔΔ frame”, “ΔΔ glass”, and “xx bolt”. In addition, assembly processing of “XX sash” and “△△ sash” shall be done in-house and on-site installation will be outsourced.

  Based on the budget information, the user can copy the information from the budget report displayed on the budget entry screen and the budget allocation screen, and copy the information as appropriate. Enter the code and order quantity on the order screen. In addition, for products purchased with a category of “Purchased” (ie, products that have already been used), enter the customer code and property number as an article, and products with a category of “Inventory” (ie, For products that have not yet been used, enter the order code as an article and do not enter the customer code and property number. When the user performs a predetermined operation, the client 2 transmits ordering information including information input on the ordering screen to the order receiving system 3A. That is, the construction management system S receives ordering information including product identification information (product code), order quantity, and property identification information (property number) of the construction property in which the product is used, for the purchased product. And means for transmitting, to the order receiving system 3A, order information that includes product identification information and order quantity but does not include property identification information.

  The order receiving system 3A adds the delivery date, the shipment quantity, and the shipping unit price to the product name, the product code, and the article received from the client 2, and returns them to the client 2 as shipping information in a predetermined format. The shipping information is returned to the client 2 as a file in a predetermined format such as CSV format. That is, the construction management system S receives the shipping information including the product identification information, the shipment quantity, the shipping unit price, and the property identification information included in the ordering information for the product for which the ordering information including the property identification information is transmitted. Means for receiving from 3A, and means for receiving shipment information including product identification information, shipment quantity and unit price, and not including property identification information, from the order receiving system 3A for a product for which order information not including property identification information is transmitted. And have. The shipment quantity is usually the same as the order quantity, but becomes smaller than the order quantity when, for example, shipments are made in two days.

  <Fetching information fetching> The client 2 reads the shipping information from the shipping information file in which the shipping information is stored according to the user's operation (S104). Specifically, when the user performs a predetermined operation, the client 2 displays a shipping information fetch screen as shown in FIG. 8, and the user specifies the manufacturer name of the order receiving system 3A and the location of the shipping information file on this screen. When designation is made and the import button 26 is clicked, the client 2 reads the shipment information according to the configuration of the shipment information file of the designated manufacturer, and displays it on the shipment information display unit 27 as shown in FIG.

  Next, the client 2 refers to the product master to check whether the product category of each shipment information is “purchase” or “inventory”, and determines the shipment information (that is, the property number) of the product “purchase”. The purchase information including the customer code, the property number, the product name, the product code, the purchase quantity, and the purchase unit price is generated and transmitted to the server 1. The server 1 stores purchase information in the property database 5. That is, the construction management system S generates purchase information including product identification information, a purchase quantity, and a purchase unit price based on the shipment information (including the property identification information in the shipment information in the purchase information). And a means for storing in the property storage means in association with the property information including the same property identification information as the property identification information in the shipping information. The purchase quantity and the purchase unit price are the same as the shipment quantity and the shipment unit price in the shipment information, respectively. The purchase unit price is a unit price at the time of actual purchase (execution unit price). Further, the server 1 stores the purchase unit price and the purchase amount (= purchase unit price × quantity) in the information of the corresponding product (information on the component) in the budget information based on the purchase information.

  FIG. 9 shows an example in which the purchase information of the construction property No.000460-00 shown in FIG. FIG. 9 is a property balance inquiry screen displayed on the client 2 by a predetermined operation of the user. When the purchase button 31 is clicked, purchase information is displayed in a list. The value displayed in the cost column 30 of FIG. 9 is a purchase unit price (execution unit price), and may be different from the original unit price (planned purchase unit price) on the budget input screen.

  On the other hand, client 2 generates warehousing information including a product name, a product code, a purchased quantity, and a purchase unit price from the shipping information (that is, shipping information that does not have a property number) of the “warehousing” product. To the server 1. The server 1 updates the inventory information having the same product code in the inventory file based on the receipt information. That is, the construction management system S has means for updating inventory information including the same product identification information as the product identification information included in the shipment information based on the shipment information not including the property identification information. In addition, if there is inventory information having the same product code and purchase unit price as the product code and purchase unit price in the receipt information, the server 1 increases the stock quantity by the purchase quantity in the receipt information. If the purchase unit price is not the same even if there is inventory information for the product code, the purchase quantity and purchase unit price in the receipt information are stored in the continuation of the inventory information for the same product code as the inventory quantity and purchase unit price, respectively. Or new inventory information is created with the product code, purchase quantity, and purchase unit price in the receipt information as the product code, inventory quantity, and purchase unit price, respectively. If there is no inventory information of the same product code, new inventory information is created with the product code, purchase quantity, and purchase unit price in the warehousing information as the product code, inventory quantity, and purchase unit price, respectively.

  Note that some suppliers do not have an order receiving system capable of receiving orders on the Internet. In such a case, the user displays a purchase input screen as shown in FIG. 10 on the client 2, and for the purchased product, the category, customer code, property number, product name, product code, purchase quantity, Then, the purchase unit price is input, and the client 2 generates purchase information from the input information and stores it in the property database 5 of the server 1. In the case of a product with the category “Receiving”, enter “Receiving” in the category and do not enter the customer code and property number. Then, the client 2 generates warehousing information from the input information and stores it in the property database 5 of the server 1.

  <Creation of Work Request Form> The user creates a work request form for assembling “XX sash” in the client 2 by appropriately copying information from the budget integrated form displayed on the budget input screen (S105). In the work request form, as shown in FIG. 11, the request date, customer code, customer name, property number, property name, property name, work number (hereinafter referred to as “work number”) and the person in charge. The name of the worker is written, the name of the work to be performed (contents), quantity, standard work time (standard time for work per unit quantity), budget classification, classification of parts used, product The name, product code, quantity, purchase unit price, purchase amount, and budget classification are described. The client 2 searches the product master and the purchase information or the inventory information based on the property number and the product code, thereby inputting the product category and the purchase unit price in the work request.

  <Work report / output report input> The worker who receives the output work request form uses the parts purchased for the construction property for the parts whose category is "Purchase", and the category whose status is "Receive" About a member, it requests delivery and uses the delivered member. When the work is completed, a work report as shown in FIG. 12 is input to the client 2 (S106). The work report includes the work date, customer code, customer name, property number, property name, work number, and worker name, as well as the work name, quantity, standard work time, Budget classification, work time (actual time taken for work), unit price, and amount (= unit price x quantity), product name, product code, quantity, purchase unit price, purchase price, Includes budget classification. The unit price is input to the work report by the client 2 by, for example, multiplying the standard work time by the amount per unit time stored in the client 2.

  The client 2 transmits a work report to the server 1, and the server 1 generates in-house work information including the above information included in the work report based on the work report and stores it in the property database 5. The in-house work information is displayed as a list by clicking the in-house button 34 on the property balance inquiry screen shown in FIG.

  Further, the worker inputs a delivery report as shown in FIG. 13 to the client 2 for the delivered members (S106). The delivery report includes the customer code, customer name, property number, and property name, as well as the product name, product code, delivery quantity, purchase unit price, and purchase price of the delivered parts. It is. That is, the construction management system S has means for inputting a delivery report including product identification information, a delivery quantity, and property identification information of a construction property in which the product is used for the delivered product. The client 2 transmits a delivery report to the server 1, and the server 1 updates the inventory information including the same product code as the delivery report to reduce the stock quantity based on the delivery report. That is, the construction management system S has means for updating stock information including the same product identification information as the product identification information in the delivery report based on the delivery report.

  Further, the server 1 generates delivery information including a property number, a product code, a delivery quantity, a purchase unit price, and a purchase price based on the delivery report, and stores the delivery information in the property database 5. That is, the construction management system S generates stock information including product identification information, a stock quantity, and a purchase unit price based on the stock report as necessary, and generates a stock report in the stock information. Means for storing in the property database 5 in association with property information including the same property identification information as the property identification information being reported. In this embodiment, since the purchase unit price is included in the issue report, it is sufficient to use the purchase unit price when generating the issue information, and it is not necessary to refer to the inventory information. If the purchase price does not include the purchase price, the purchase price may be included in the delivery information with reference to the inventory information. Moreover, the server 1 stores the purchase unit price and the purchase amount as information on the corresponding product in the budget information (information on the component) based on the delivery information. The delivery information is displayed as a list in the same manner as the purchase information shown in FIG. 9 by clicking the delivery button 32 on the property balance inquiry screen shown in FIG.

  In addition, for the assembly of “ΔΔ sash”, a work request form is created and a work report is input as in the case of “XX sash” described above, and a shipping report is input for “XX bolt”.

  <Creation of Shipment Guide> The user creates a shipping guide (not shown) in the client 2 when “XX sash” and “ΔΔ sash” are completed (S107). The shipping guide includes the delivery date, customer code, customer name, property number, property name, product name and quantity of the product to be shipped.

  <Creation of subcontracting work request document> Next, the user shall request the subcontractor to install “XX sash” and “△△ sash” on the building in the field, and the subcontracting work request document is sent to the client 2. Create (S108). The subcontract work request form is not shown, but the request date, customer code, customer name, property number, property name, and work number are listed, and the work name, quantity, and budget classification of the work to be performed Is described.

  <Subcontracting work report input> When the worker who has received the subcontracting work request form finishes the work, he / she sends a report to that effect to the requesting user, that is, the user of the construction management system S, and the user sends the subcontracting work report to the client 2. Input (S109). The subcontracting work report is not shown, but it contains the work date, customer code, customer name, property number, property name, property name, work number, and worker name as well as the work report shown in FIG. Work name, quantity, cost (unit price), amount (= cost × quantity), and budget classification. The cost is determined by the subcontractor, and the budget classification is determined by the user. The client 2 transmits a subcontracting work report to the server 1, and the server 1 generates subcontracting work information including the above information included in the subcontracting work report based on the subcontracting work report and stores it in the property database 5. .

  When the user clicks the subcontract button 33 on the property balance inquiry screen shown in FIG. 9, as shown in FIG. 14, the client 2 has the construction property (the construction property of property No. 000464-00 in FIG. 14). Displays a list of outsourced work information. The outsourced work information includes the worker name, work date, contents (work name), cost, quantity, amount, and budget classification. As for the in-house work information, the in-house work information is similarly displayed as a list by clicking the in-house button 34.

  <Invoice Creation> When the user designates a property number in the client 2 and performs a predetermined operation, the server 1 uses the information in the property database 5 to show the construction property of the designated property number in FIG. A property ledger as shown is generated and displayed on the client 2. FIG. 15 is an example in which the client 2 outputs and prints the property ledger to a printer.

  The property ledger displays the customer code, customer name, property number, and property name for each construction property, as well as the worker name for all work performed on the construction property, Work date, contents, cost (unit price), quantity, and amount, and supplier name, purchase date, product name, unit price, quantity, and quantity for all parts purchased for the construction property , The purchase amount, and the supplier name, delivery date, product name, purchase unit price, quantity (shipment quantity), and purchase price for all parts issued for the construction property are displayed. The Then, the amount of all work performed on the construction property, the purchase amount of all materials purchased for the construction property, and the purchase of all materials issued for the construction property. The total amount of the deposit amount is displayed as the cost amount of the property branch total. In the example of FIG. 15, the cost amount is “474,594”. The user sees the cost amount, determines the amount to be charged to the customer, and creates a bill including the customer code, billing date, property number, and billed amount in the client 2 and bills the customer. (S110). Note that when a plurality of properties are requested by a customer, invoices are included for the plurality of properties, so the invoice includes a plurality of property numbers and billing amounts for each property. The customer code, billing date, property number, and billing amount entered in the bill are stored in the server 1 as billing data.

  <Payment creation> When there is a deposit from a customer, the user sorts the deposit for each property and inputs the data from the client 2 (S111). Specifically, the user performs a predetermined operation on the client 2 to display a deposit input screen (not shown). The payment input screen is configured so that the customer code, payment date, and payment amount can be entered. When the user inputs them on the payment input screen and clicks the application input button provided on the screen, the client 2 displays a consumption input screen as shown in FIG.

  On the application input screen, the customer code entered on the deposit input screen and the customer name for the customer code are displayed, the deposit amount in the total deposit amount column 41 and the deposit amount in the consumption tax column 42. The calculated consumption tax amount is displayed in the application amount column 43, and the application target amount obtained by subtracting the consumption tax amount from the deposit amount is displayed, and a property list section 44 is provided. Then, the client 2 refers to the property information and billing data stored in the server 1, and sends the property number, property name, and previous billing to the property list section 44 for each property requested by the customer. Displays the date and amount charged, and the applied amount that has already been applied to the invoice. The user determines an amount (that is, an application amount) to be applied to the billing for each property from the application amount, and inputs it to the application amount column 45 of each property. The input data of the application amount is stored in the property database 5 in association with the property information of the corresponding property number.

  In addition, the budget cost and the estimated gross profit in the property ledger of the property ledger shown in FIG. 15 are the final purchase planned amount and the planned gross profit displayed on the planned order amount display section 17 (see FIG. 6), respectively. Same as forehead. The sales amount is the amount charged to the customer, and the current gross profit is the gross profit calculated from the sales amount and the cost amount. The amount of money received and the amount not yet collected are the amount charged to the customer (ie, the amount that has been applied) and the amount that has not been received (ie, Amount not done).

  In addition, the property code total in FIG. 15 has the same property code, for example, if there is a construction property with property number 000464-00 and a construction property with 00464-01, the total of the order amount is displayed. The total order amount of the construction property is displayed, but in the example of FIG. 15, since there is only one construction property having the property code 000464, the content is the same as the property branch number total.

  Note that the cost is calculated by the server 1 based on the purchase information, the delivery information, the in-house work information, and the outsourced work information in the property database 5, and the client 2 outputs the cost. That is, the construction management system S, for each construction property, has purchased all the properties purchased for use in the construction property based on the purchase information associated with the property information of the construction property and stored in the property storage means. Used for construction properties based on the means to calculate and output the cost including the purchase price of the product, and for each construction property, the delivery information stored in the property storage means associated with the property information of the construction property And a means for calculating and outputting a cost amount including the purchase amount of all goods delivered. Other sales amounts are also calculated by the server 1 and output by the client 2.

  As described above, in the construction management system S, the property number of the construction property is attached to the information (purchase information) of the parts purchased for use with the construction property (that is, It is associated with the property information including the property number). Therefore, it is possible to calculate the cost amount including the purchase amount of all the products purchased for use in the construction property. Therefore, if the customer is billed with reference to the cost amount, it is possible to prevent omission of billing forgetting to bill for that amount even though the goods used for the construction property are purchased.

  In addition, in the construction management system S, when a member is delivered to a construction property, the property number of the construction property is attached to information on the member (delivery information). Therefore, it is possible to calculate the cost amount including the purchase amount of all the goods delivered for use in the construction property. Therefore, if the customer is billed with reference to the cost amount, it is possible to prevent omission of billing due to forgetting to bill for the product even though the goods used for the construction property have been issued. .

  Furthermore, in the construction management system S, when a work is performed on a construction property, the property number of the construction property is attached to the work information (in-house work information, subcontracting work information). Therefore, it is possible to calculate the cost including the amount of all work performed on the construction property. Therefore, if the customer is billed with reference to the cost amount, it is possible to prevent omission of billing forgetting to bill for that work despite the work on the construction property. .

  In addition, even when billing in the middle of the construction, since the amount of the member used so far and the amount of work performed can be known, for example, the order amount is 1 million yen, but the member used so far and Since the total amount of work performed is 520,000 yen, it is possible to make a charge commensurate with the progress of the construction, such as charging 500,000 yen, assuming that it is almost half finished.

  In the above embodiment, the client 2 is configured to communicate with the order receiving system 3A via the Internet. However, the server 1 is configured to communicate with the order receiving system 3A via the Internet. Ordering, shipping information fetching, etc. may be performed. Further, the product master or the like may be provided in either the server 1 or the client 2, and the cost amount or the like may be calculated by the client 2.

  In addition, it is not displayed externally like the property number, but it is like an internal code, and information related to the same construction property (property information, purchase information, outgoing information, etc.) may be associated with each other. Good.

  Also, instead of referring to the product category in the product master, determine whether the article in the shipping information for each product contains the article number from the composition of the data in the article. Purchase information may be generated from the shipping information including, and warehousing information may be generated from the shipping information not including the property number. In addition, when the server 1 captures shipping information, inventory information may be directly updated with shipping information that does not include the property number without generating warehousing information.

  Alternatively, the server 1 or the client 2 may be provided with a work master that stores the work name, work code, and unit price for each work, and the work amount may be calculated using the unit price.

  Furthermore, the construction management system S may not be a server / client system, but may be a single computer.

It is a system configuration figure of the construction management system concerning one embodiment of the present invention. It is a figure which shows the content of a property database. It is a flowchart for demonstrating operation | movement of a construction management system. It is an example of a property registration screen. It is an example of a budget input screen. It is an example of a budget allocation screen. It is a figure which shows the construction property example. It is an example of a shipping information capture screen. It is an example of a property balance inquiry screen. It is an example of a purchase input screen. It is an example of a work request form. It is an example of a work report. It is an example of a shipping report screen. It is an example of a subcontracting work information list screen. It is an output example of a property ledger. It is an example of a consumption input screen.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Server 2 ... Client 3A, 3B, 3C ... Order receiving system 5 ... Property database (property storage means)

Claims (4)

An order management system that accepts orders for products used in construction and a construction management system that can communicate via a communication line.
Property storage means for storing property information including property identification information for a plurality of construction properties;
Means for transmitting order information including product identification information, order quantity, and property identification information of a construction property used for the product to the order receiving system,
Means for receiving, from the order receiving system, shipping information including the product identification information, the shipping quantity, the shipping unit price, and the property identification information included in the ordering information for the product that has transmitted the ordering information;
Based on the shipment information, generate purchase information including product identification information, purchase quantity, and purchase unit price, and associate with the property information including the same property identification information as the property identification information in the shipment information, Means for storing in the property storage means;
A means for inputting a work report including information indicating the amount of the work and property identification information of a construction property in which the product is used for work performed to produce a product from a component product;
Based on the work report, in-house work information including information indicating the amount of the work is generated, and associated with the property information including the same property identification information as the property identification information in the work report, the property storage means Means for storing;
For each construction property, all items purchased for use in the construction property based on the purchase information and the in-house work information associated with the property information of the construction property and stored in the property storage means Means for calculating and outputting a cost amount including the purchase amount of the product and the amount of the work performed on the construction property ;
The construction management system characterized by having. An order management system that accepts orders for products used in construction and a construction management system that can communicate via a communication line.
Property storage means for storing property information including property identification information for a plurality of construction properties;
Means for transmitting order information including product identification information, order quantity, and property identification information of a construction property used for the product to the order receiving system,
Means for receiving, from the order receiving system, shipping information including the product identification information, the shipping quantity, the shipping unit price, and the property identification information included in the ordering information for the product that has transmitted the ordering information;
Based on the shipment information, generate purchase information including product identification information, purchase quantity, and purchase unit price, and associate with the property information including the same property identification information as the property identification information in the shipment information, Means for storing in the property storage means;
Inventory storage means for storing inventory information including product identification information, inventory quantity, and purchase unit price for products in stock;
Means for transmitting order information including product identification information and order quantity, not including property identification information, to the order receiving system for the product to be purchased;
Means for receiving, from the order receiving system, shipping information that includes the product identification information, the shipping quantity, and the shipping unit price but does not include the property identification information for the product for which the order information not including the property identification information is transmitted;
Means for updating the inventory information including the same product identification information as the product identification information included in the shipping information, based on the shipping information not including the property identification information;
A means for inputting a delivery report including the product identification information, the quantity to be delivered, and the property identification information of the construction property in which the product is used,
Means for updating the inventory information including the same product identification information as the product identification information in the output report based on the output report;
Based on the delivery report, referring to the inventory information as necessary, generating delivery information including product identification information, delivery quantity and purchase unit price, and the same property identification as the property identification information in the delivery report Means for storing in the property storage means in association with the property information including information;
For each construction properties, based on said purchase information and the unloading information associated with the listing of the construction properties stored in the property storage unit, all of which purchased for use in the construction property and specifications losses of goods, and means for calculating the including original value output and all of the specifications losses of goods that have been issuing for use in the construction property,
The construction management system characterized by having. A computer that can communicate with an order receiving system that receives orders for products used in construction and a communication line.
Property storage means for storing property information including property identification information for a plurality of construction properties,
For product stocking, hand stage ordering information including the property identification information of the construction properties of the product identification information and order quantity and the product is used, is transmitted to the order receiving system,
Means for receiving shipping information including the product identification information, the shipping quantity, the shipping unit price, and the property identification information included in the ordering information from the order receiving system for the product for which the ordering information has been transmitted;
Based on the shipment information, generate purchase information including product identification information, purchase quantity, and purchase unit price, and associate with the property information including the same property identification information as the property identification information in the shipment information, Means for storing in the property storage means;
A means for inputting a work report including information indicating the amount of the work and property identification information of a construction property in which the product is used for work performed to produce a product from a component product;
Based on the work report, in-house work information including information indicating the amount of the work is generated, and associated with the property information including the same property identification information as the property identification information in the work report, the property storage means Means for storing,
as well as,
For each construction property, all items purchased for use in the construction property based on the purchase information and the in-house work information associated with the property information of the construction property and stored in the property storage means Means for calculating and outputting a cost amount including the purchase amount of the product and the amount of the work performed on the construction property ,
Program to function as. A computer that can communicate with an order receiving system that receives orders for products used in construction and a communication line.
Property storage means for storing property information including property identification information for a plurality of construction properties,
Means for transmitting order information including product identification information, order quantity, and property identification information of a construction property used for the product to the order receiving system,
Means for receiving shipping information including the product identification information, the shipping quantity, the shipping unit price, and the property identification information included in the ordering information from the order receiving system for the product for which the ordering information has been transmitted;
Based on the shipment information, generate purchase information including product identification information, purchase quantity, and purchase unit price, and associate with the property information including the same property identification information as the property identification information in the shipment information, Means for storing in the property storage means;
Inventory storage means for storing inventory information including product identification information, inventory quantity, and purchase unit price for products in stock,
Means for transmitting, to the order receiving system, order information that includes product identification information and an order quantity and does not include property identification information for the purchased product;
Means for receiving, from the order receiving system, shipping information that includes the product identification information, the shipment quantity, and the shipping unit price but does not include the property identification information for the product for which the order information that does not include the property identification information is transmitted;
Means for updating the inventory information including the same product identification information as the product identification information included in the shipping information, based on the shipping information not including the property identification information;
A means for inputting a delivery report including the product identification information, the quantity to be delivered, and the property identification information of the construction property where the product is used,
Means for updating the inventory information including the same product identification information as the product identification information in the delivery report based on the delivery report;
Based on the delivery report, referring to the inventory information as necessary, generating delivery information including product identification information, delivery quantity and purchase unit price, and the same property identification as the property identification information in the delivery report Means for storing in the property storage means in association with the property information including information;
as well as,
For each construction properties, based on said purchase information and the unloading information associated with the listing of the construction properties stored in the property storage unit, all of which purchased for use in the construction property and specifications losses of goods, all items of specification losses and means for calculating the output including original price a which has been issuing for use in the construction property,
Program to function as.

Images