JP2020134976A - Charging data generation device, charging data generation method and charging data generation program - Google Patents

Abstract

To provide a charging data generation device and the like that can generate charging data corresponding to sponsor merit.SOLUTION: The present embodiment (1) acquires a JV field site code associated with a field site code in sales data referring to a field site master associating a field site code and the JV field site code to hold, on the basis of sales data including the field site code; (2) acquires a JV unit price associated with a commodity code and a customer code, and the acquired JV field site code in sales data referring to a unit price master holding a unit price of a commodity for each commodity, for each customer, and for each field site being one holding the JV unit price, when the JV field site code can be acquired; (3) calculates a JV money amount on the basis of the acquired JV unit price and the sales data; (4) calculates a money amount which is obtained by subtracting the calculated JV money amount from a sales main body money amount in the sales data; and (5) generates charging data which includes the acquired JV unit price and the calculated JV money amount, and which includes the money amount calculated by subtracting, as a discount money amount.SELECTED DRAWING: Figure 5

Description

The present invention relates to a billing data generator, a billing data generation method and a billing data generation program.

Patent Document 1 discloses an accounting treatment method for the construction industry and an accounting treatment program for the construction industry when a joint venture (JV) is formed by a plurality of companies and construction is carried out as the joint venture. (See paragraph 0001).

Japanese Unexamined Patent Publication No. 2006-20125

However, in the above-mentioned Patent Document 1, when a company that provides materials, etc. is requested by a JV management company (sponsor) to issue an invoice corresponding to the so-called "sponsor merit", the business related to the issuance. Since the general sales management system (application software) does not have a function to support the business, it has to be dealt with manually, which is a heavy burden on the company.

The present invention has been made in view of the above problems, and an object of the present invention is to provide a billing data generation device, a billing data generation method, and a billing data generation program capable of generating billing data corresponding to sponsor merits.

In order to solve the above-mentioned problems and achieve the object, the billing data generation device according to the present invention is a billing data generation device including a control unit, and the control unit is based on sales data including site identification data. In addition, referring to the site master that holds the site identification data and that can hold the JV site identification data, which is the site identification data for the construction site performed by the joint venture, in association with the site identification data. If the JV site acquisition means for acquiring the JV site identification data associated with the site identification data included in the sales data and the JV site acquisition means can acquire the JV site identification data, the unit price of the product is used as the product. The product identification data and customer identification data included in the sales data and the JV site acquisition means are referred to, which are unit price masters held for each customer and each site and which hold the unit price for a joint venture. JV unit price acquisition means that acquires the unit price associated with the JV site identification data acquired in, and JV amount calculation that calculates the amount to be charged to the joint venture based on the unit price acquired by the JV unit price acquisition means and the sales data. Calculated by means, a difference calculation means that calculates an amount obtained by subtracting an amount calculated by the JV amount calculation means from the sales amount included in the sales data, a unit price acquired by the JV unit price acquisition means, and the JV amount calculation means. It is characterized by including a generation means for generating billing data including the amount of money and the amount calculated by the difference calculation means as a discount amount.

Further, in the billing data generation device according to the present invention, when the unit price master sells the daily unit price, which is the unit price for the joint venture when the product is rented for one day, or the product. A rental transaction category that further includes the main unit price, which is a unit price for the joint venture, and the sales data is a category that means that the product is traded by rental, or a category that means that the product is traded by product sales. When the JV unit price acquisition means further includes the product sales transaction category and the category included in the sales data is the rental transaction category, the daily unit price is acquired by referring to the unit price master, and the sales When the category included in the data is the product sales transaction category, it is characterized in that the unit price of the main body is acquired by referring to the unit price master.

Further, the billing data generation device according to the present invention is a business in which a person who charges an amount to the joint venture rents or sells the product related to the construction to the joint venture, and the joint venture The company composed of a plurality of companies involved in the construction work and having the highest investment ratio in the joint venture among the plurality of companies manages the ordering of the product to the contractor and the discount amount. It is characterized by making the profit of the company.

Further, the billing data generation method according to the present invention is a billing data generation method executed by an information processing apparatus including a control unit, and is based on sales data including site identification data executed by the control unit. The sales data is referred to by referring to the site master that holds the site identification data and that can hold the JV site identification data, which is the site identification data for the construction site performed by the joint venture, in association with the site identification data. If the JV site acquisition step for acquiring the JV site identification data associated with the site identification data included in the above and the JV site identification data can be acquired in the JV site acquisition step, the unit price of the product is determined by product. Acquired by the product identification data and customer identification data included in the sales data and the JV site acquisition step with reference to the unit price master held by customer and site and holding the unit price for the joint venture. A JV unit price acquisition step for acquiring the unit price associated with the JV site identification data, and a JV amount calculation step for calculating the amount to be charged to the joint venture based on the unit price acquired in the JV unit price acquisition step and the sales data. , The difference calculation step for calculating the amount obtained by subtracting the amount calculated in the JV amount calculation step from the sales amount included in the sales data, the unit price acquired in the JV unit price acquisition step, and the amount calculated in the JV amount calculation step. It is characterized by including a generation step of generating billing data including the above and including the amount calculated in the difference calculation step as a discount amount.

Further, the billing data generation program according to the present invention is a billing data generation program for being executed by an information processing apparatus including a control unit, and is based on sales data including site identification data for being executed by the control unit. In addition, referring to the site master that holds the site identification data and that can hold the JV site identification data, which is the site identification data for the construction site performed by the joint venture, in association with the site identification data. If the JV site acquisition step for acquiring the JV site identification data associated with the site identification data included in the sales data and the JV site identification data can be acquired in the JV site acquisition step, the unit price of the product is used as the product. The product identification data and customer identification data included in the sales data, and the JV site acquisition step, with reference to the unit price master held for each customer and each site and holding the unit price for the joint venture. JV amount calculation to calculate the amount to be charged to the joint venture based on the JV unit price acquisition step to acquire the unit price associated with the JV site identification data acquired in step 1 and the unit price acquired in the JV unit price acquisition step and the sales data. Calculated by the step, the difference calculation step that calculates the amount obtained by subtracting the amount calculated in the JV amount calculation step from the sales amount included in the sales data, the unit price acquired in the JV unit price acquisition step, and the JV amount calculation step. It is characterized by including a generation step of generating billing data including the calculated amount and including the amount calculated in the difference calculation step as a discount amount.

According to the present invention, there is an effect that billing data corresponding to the sponsor merit can be generated.

FIG. 1 is a block diagram showing an example of the configuration of the billing data generation device. FIG. 2 is an image diagram showing an example of billing data generation corresponding to the sponsor merit. FIG. 3 is a diagram showing an example of the correlation of each data. FIG. 4 is a diagram showing an example of the billing details View and the billing details View (discount). FIG. 5 is a diagram showing an example of specific contents in each data. FIG. 6 is an image diagram showing an example of the relationship between the rental company and the JV constituent company.

Hereinafter, embodiments of a billing data generation device, a billing data generation method, and a billing data generation program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1. Overview]
In the business format of leasing temporary materials and other goods to construction sites, there are cases where an invoice corresponding to the sponsor's merit is required when delivering to a joint venture (JV). In the past, in order to meet this industry requirement, it was necessary to deal with any of the following three patterns, but there were problems with each method. A joint venture (JV) is, for example, an organization formed by a plurality of contractors for one construction work. In addition, the sponsor merit is, for example, the company with the highest investment ratio in JV becomes the sponsor (secretary company), manages the order of materials, etc., and at that time, the discount at the time of purchase is the profit of the company. That is.

The first measure in the past is to register the unit price (amount) for JV as the sales unit price (amount) and separately discount the difference. However, in the case of this measure, there is a problem that the sales amount and the sales discount amount are excessively recorded, which hinders the appropriate analysis of the sales information.

The second measure in the past is to manage the unit price (amount) for JV as a separate item from the sales unit price (amount). However, in the case of this correspondence, there is a problem that customization (also large-scale customization) is almost always required because it is a function that is not implemented in a general sales management system.

The third measure in the past is to manage the unit price (amount) for JV outside the system. However, in the case of this response, there is a problem that the work of issuing an invoice becomes complicated and the work load on the site increases.

Therefore, in the present embodiment, for example, a mechanism for virtually generating billing data corresponding to the sponsor merit has been realized without significantly customizing the system. The outline is as follows.

For example, as shown in FIGS. 2 and 6, the rental company is Z rental, the JV constituent companies are A construction (sponsor), B civil engineering and C construction shop, and the transaction between Z rental and each JV constituent company. It is assumed that the unit price is as shown in Table 1 of FIG. In Table 1 of FIG. 2, the rental unit price is the unit price when one product is rented for one day, and the sales unit price is the unit price when one product is sold.

Consider the case where there is sales shown in Table 2 of FIG. 2 from Z rental to JV. In the sales data 106c in Table 2 of FIG. 2, sales are recorded at the transaction unit price with A construction (sponsor). Specifically, the sales amount of 30,000 yen for SHOHIN01 is calculated by calculating the rental unit price of SHOHIN01 for A construction as 10 yen x quantity 100 x 30 days, and the sales amount of 50,000 yen for SHOHIN01 is for SHOHIN01 for A construction. The sales unit price of 5,000 yen x quantity 10 is calculated, and the sales amount of SHOHIN 02 is 30,000 yen, which is calculated by the rental unit price of SHOHIN 02 for construction A x quantity 200 x number of days 10.

Then, when there is sales shown in Table 2 of FIG. 2, the billing data 106f shown in Table 3 of FIG. 2 is generated in the present embodiment. The billing data in Table 3 of FIG. 2 is generated based on the transaction unit price with non-sponsored civil engineering B and construction company C, and the difference from the sales amount is discounted. Specifically, the JV amount of 39,000 yen for SHOHIN01 is calculated by calculating the rental unit price of SHOHIN01 for B civil engineering and C construction shop as 13 yen x quantity 100 x 30 days, and the JV amount of 55,000 yen for SHOHIN01 is The unit price of SHOHIN01 sold to B civil engineering and C construction shop is 5,500 yen x quantity 10, and the JV amount of 30,000 yen for SHOHIN02 is the rental unit price of SHOHIN02 to B civil engineering and C construction shop 15 yen x quantity 200. It is calculated by the calculation of × number of days 10. The discount amount of -14,000 yen in Table 3 of FIG. 2 is the total amount of sales amount in the sales data 106c of Table 2 of FIG. 2 (30,000 yen + 50,000 yen + 30,000 yen) -in FIG. It is calculated by the calculation of the total amount of JV amount (39,000 yen + 55,000 yen + 30,000 yen) = 110,000 yen-124,000 yen in the billing data 106f in Table 3. Then, 124,000 yen, which is the total amount of JV, is borne by three companies, A construction, B civil engineering and C construction shop, and is collected on behalf of A construction, but the actual burden is the total sales amount. Since the amount is 110,000 yen, the difference of 14,000 yen (= 14,000 yen of the discount) will be the profit of the sponsor A construction. Hereinafter, a specific configuration and operation will be described.

[2. Constitution]
An example of the configuration of the billing data generation device 100 according to the present embodiment will be described with reference to FIG. FIG. 1 is a block diagram showing an example of the configuration of the billing data generation device 100.

The billing data generation device 100 is a commercially available desktop personal computer. The billing data generation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, or the like on the market. It may be a type information processing device.

The billing data generation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the billing data generation device 100 is communicably connected via an arbitrary communication path.

The communication interface unit 104 connects the billing data generation device 100 to the network 300 so as to be communicable 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 another device via a communication line. Here, the network 300 has a function of connecting the billing data generation device 100 and the server 200 so as to be communicable with each other, and is, for example, the Internet or a LAN (Local Area Network). Data of various masters and the like, which will be described later, may be stored in the server 200, for example.

An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). In addition to the keyboard, mouse, and microphone, the input device 112 can use a monitor that cooperates with the mouse to realize the pointing device function. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112.

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

The storage unit 106 may, for example, include a billing file 106a, a collection schedule data 106b, sales header data 106c1 as sales data, sales detail data 106c2, a site master 106d, and a customer site-specific product unit price master 106e as a unit price master. (Hereinafter, simply referred to as "unit price master 106e") and billing data 106f.

As shown in FIGS. 3 and 5, for example, the billing file 106a includes the billing number, the current sales amount, the current return amount, the current discount amount, the current sales consumption tax amount, and the current return consumption tax amount. And this time, the discounted consumption tax amount, etc. will be retained.

As shown in FIGS. 3 and 5, the collection schedule data 106b holds, for example, a slip number, a slip line number, a data classification, the billing number, and the like. Examples of the data category include "40: sales" and the like.

As shown in FIGS. 3 and 5, the sales header data 106c includes, for example, a sales number, billing destination identification data (billing destination code), customer identification data (customer code), and site identification data (site code). ), Sales date, etc.

As shown in FIGS. 3 and 5, the sales detail data 106d includes, for example, the sales number, the sales line number, the data classification, the product identification data (product code), and the unit identification data (unit code). , System contract classification, number of sales, number of days billed, unit price of sales, amount of sales, etc. are retained.

The system contract category is an item for storing a transaction contract (transaction content) of each sales item. The system contract category is, for example, a rental transaction category (“1: Nichigoku”), which means that the product is traded by rental, or a category, which means that the product is traded by product sales. A certain product sales transaction category (“10: sale” or “11: rental exhibition sale”) and the like can be mentioned. For details, see [3. Specific example of processing], the unit price setting location (sales daily unit price or sales main unit price) of the unit price master 106e is specified for each type of the system contract category.

As shown in FIGS. 3 and 5, for example, the site master 106d includes the site identification data (site code), the site official subject 1, the site official subject 2, and the site for the construction site performed by the joint venture. The JV site identification data (JV site code), which is the identification data, and the like are linked and held. As shown in FIG. 5, in the case of JV site construction, a JV site code is separately provided, and the JV site code is set in the site master 106d. Then, in the following unit price master 106e, the JV unit price is set for the set JV site code.

The unit price master 106e is a feature of the present invention, and holds the unit price of a product for each product, each customer, and each site. As shown in FIGS. 3 and 5, for example, the unit price master 106e includes the customer identification data (customer code), the site identification data (site code), the product identification data (product code), and the product code. Unit identification data (unit code), application start date, daily unit price (sales daily unit price 13 yen), which is the unit price for a joint venture when renting one product for one day, and one product The main unit price (sales main unit price of 5,500 yen), which is the unit price for the joint venture in the case of selling the product, and the like are retained. The 13 yen and the 5,500 yen are so-called JV unit prices.

Since the billing data 106f is information generated by the billing data generation device 100, the detailed contents are described in the following [3. Specific example of processing] will be described.

The control unit 102 is a CPU or the like that collectively controls the billing data generation device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Execute.

The control unit 102 is a site master that holds the site identification data based on (1) sales data including the site identification data, and the site identification data for the construction site performed by the joint venture. The JV site as a JV site acquisition means for acquiring the JV site identification data associated with the site identification data included in the sales data by referring to the JV site identification data that can be held in association with the site identification data. When the acquisition unit 102a and (2) the JV site acquisition means can acquire the JV site identification data, it is a unit price master that holds the unit price of the product for each product, each customer, and each site. JV unit price to acquire the product identification data and customer identification data included in the sales data and the unit price associated with the JV site identification data acquired by the JV site acquisition means with reference to the one holding the unit price for the corporate entity. JV amount calculation as a JV amount calculation means for calculating the amount to be charged to the joint venture based on the JV unit price acquisition unit 102b as the acquisition means and (3) the unit price acquired by the JV unit price acquisition means and the sales data. Unit 102c, (4) Difference calculation unit 102d as a difference calculation means for calculating the amount obtained by subtracting the amount calculated by the JV amount calculation means from the sales amount included in the sales data, and (5) Acquisition of the JV unit price. The generation unit 102e as a generation means for generating billing data including the unit price acquired by the means and the amount calculated by the JV amount calculation means and including the amount calculated by the difference calculation means as a discount amount is provided. ..

Based on the sales data 106c including the site code, the JV site acquisition unit 102a refers to the site master 106d that holds the site code and can hold the JV site code in association with the site code, and refers to the sales data. Acquire the JV site code associated with the site code included in 106c.

The JV unit price acquisition unit 102b is a unit price master 106e that holds the unit price of the product by product, customer, and site when the JV site acquisition unit 102a can acquire the JV site code, and is a JV unit price. Obtain the product code and customer code included in the sales data 106c and the JV unit price associated with the JV site code acquired by the JV site acquisition unit 102a by referring to the one that holds (daily unit price of sales or unit price of sales body). To do.

When the system contract category included in the sales data 106c is "1: daily pole", the JV unit price acquisition unit 102b acquires the daily sales daily pole unit price with reference to the unit price master 106e, and the sales data is obtained. When the system contract category included in 106c is "10: sale" or "11: rental listing sale", the unit price of the sales body may be acquired by referring to the unit price master 106e.

The JV amount calculation unit 102c calculates the JV amount (amount to be charged to the joint venture) based on the JV unit price and the sales data 106c acquired by the JV unit price acquisition unit 102b.

The difference calculation unit 102d calculates an amount obtained by subtracting the JV amount calculated by the JV amount calculation unit 102c from the sales main amount included in the sales data 106c.

The generation unit 102e generates billing data 106f including the JV unit price acquired by the JV unit price acquisition unit 102b and the JV amount calculated by the JV amount calculation unit 102c and the amount calculated by the difference calculation unit 102d as a discount amount.

[3. Specific example of processing]
In this item, a specific example of the process according to the present embodiment will be described. In this item, the person who charges the amount to the joint venture is a trader (Z rental) who rents or sells the product related to the construction to the joint venture, and the joint venture is involved in the construction. The business (A construction), which is composed of a plurality of companies involved (A construction, B civil engineering, and C construction company) and has the highest investment ratio in the joint venture among the plurality of companies, is the business of the product to the contractor. The explanation will proceed on the premise that the sponsor manages the order and uses the discount amount as the profit of the company. FIG. 6 is an image diagram showing the premise.

The billing data generation device 100 according to the present embodiment is used by, for example, the above-mentioned trader (Z rental).

Further, in this item, the contents of the billing file 106a, the collection schedule data 106b, the sales header data 106c1 and the sales detail data 106c2 are input in advance as shown in FIG. 5, and the contents of the site master 106d and the unit price master 106e. Will be described as how the billing data 106f shown in FIG. 5 is generated on the premise that is set in advance as shown in FIG.

[3-1. JV site acquisition process]
First, as shown in FIG. 5, the JV site acquisition unit 102a acquires the JV site code GENBA01JV associated with the site code GENBA01 included in the sales detail header data 106c1 with reference to the site master 106d. In this way, when the JV site acquisition unit 102a can acquire the JV site code, the JV unit price acquisition unit 102b sets the unit price for the joint venture as described in [3-2] below. get.

[3-2. JV unit price acquisition process]
Next, the processing performed by the JV unit price acquisition unit 102b will be described separately for the three sales details of the sales line numbers 1 to 3 of the sales detail data 106c2.

(1) Processing for Sales Details of Sales Line Number 1 As shown in FIG. 5, referring to the unit price master 106e, the product code SHOHIN01 included in the sales details of sales line number 1 and the customer included in the sales header data 106c1. The unit price associated with the JV site code GENBA01JV acquired by the code TOKISAKI01 and the JV site acquisition unit 102a is the daily sales daily unit price of 13 yen and the sales main unit price of 5,500 yen. Here, as shown in FIG. 5, the system contract classification in the sales statement of the sales line number 1 is "1: daily pole". In this case, as shown in FIG. 5, the JV unit price acquisition unit 102b acquires the daily sales daily unit price of 13 yen out of the daily sales daily unit price of 13 yen and the sales main unit price of 5,500 yen.

In other words, as shown in the item of "JV unit price" in "1. Billing details View" of FIG. 4, the system contract category included in the sales details data 106c2 is "1: daily pole" and the unit price master 106e. If the daily sales daily unit price included in is not 0, the JV unit price acquisition unit 102b acquires the daily sales daily unit price from the unit price master 106e.

(2) Processing for sales details of sales line number 2 As shown in FIG. 5, referring to the unit price master 106e, the product code SHOHIN01 included in the sales details of sales line number 2 and the customer included in the sales header data 106c1. The unit price associated with the JV site code GENBA01JV acquired by the code TOKISAKI01 and the JV site acquisition unit 102a is the daily sales daily unit price of 13 yen and the sales main unit price of 5,500 yen. Here, as shown in FIG. 5, the system contract category in the sales statement of the sales line number 2 is "11: Rental listing sales". In this case, as shown in FIG. 5, the JV unit price acquisition unit 102b acquires the sales main unit price of 5,500 yen out of the daily sales daily unit price of 13 yen and the sales main unit price of 5,500 yen.

In other words, as shown in the item of "JV unit price" in "1. Billing details View" of FIG. 4, the system contract category included in the sales details data 106c2 is "10: Sales" or "11: Rental listing sales". If there is, and the sales body unit price included in the unit price master 106e is not 0, the JV unit price acquisition unit 102b acquires the sales body unit price from the unit price master 106e.

In the above (1) and (2), the JV unit price acquisition unit 102b is the latest record among the records satisfying "sales date in sales header data 106c1 ≥ application start date in unit price master 106e" from the unit price master 106e. A record with the application start date of is to be acquired.

(3) Processing for Sales Details of Sales Line Number 3 As shown in FIG. 5, referring to the unit price master 106e, the product code SHOHIN02 included in the sales details of sales line number 3 and the customer included in the sales header data 106c1. There is no unit price associated with the JV site code GENBA01JV acquired by the code TOKISAKI01 and the JV site acquisition unit 102a. In this case, as shown in FIG. 5, the JV unit price acquisition unit 102b acquires the sales main unit price of 15 yen by referring to the sales details of the sales line number 3.

[3-3. JV amount calculation process]
Next, the processing performed by the JV amount calculation unit 102c will be described separately for the three sales details of the sales line numbers 1 to 3 of the sales detail data 106c2.

(1) Processing of Sales Details of Sales Line Number 1 The unit price acquired by the JV unit price acquisition unit 102b in (1) of [3-2] is the daily sales daily unit price of 13 yen acquired from the unit price master 106e. Further, as shown in FIG. 5, in the sales statement of the sales line number 1, the number of sales is 100 and the number of billing sales days is 30 days. Here, as shown in FIG. 5, the system contract classification in the sales statement of the sales line number 1 is "1: daily pole". In this case, the JV amount calculation unit 102c calculates the amount to be charged to the joint venture by the JV unit price acquisition unit 102b at a daily sales price of 13 yen x 100 sales x 30 days of billing sales = 39,000 yen. Is calculated.

In other words, as shown in the item of "JV amount" in "1. Billing details View" of FIG. 4, the system contract category included in the sales details data 106c2 is "1: daily" and the unit price master 106e. If the daily sales daily unit price included in is not 0, the JV amount calculation unit 102c calculates the amount to be charged to the joint venture by the daily sales daily unit price included in the unit price master 106e × the number of sales included in the sales detail data 106c2. × Calculated by the formula of billing sales days included in sales detail data 106c2.

(2) Processing of Sales Details of Sales Line Number 2 The unit price acquired by the JV unit price acquisition unit 102b in (2) of [3-2] is the sales unit price of 5,500 yen acquired from the unit price master 106e. Further, as shown in FIG. 5, the number of sales is 10 in the sales statement of the sales line number 2. Here, as shown in FIG. 5, the system contract category in the sales statement of the sales line number 2 is "11: Rental listing sales". In this case, the JV amount calculation unit 102c calculates the amount to be charged to the joint venture as the sales main unit price of 5,500 yen acquired by the JV unit price acquisition unit 102b x the number of sales of 10 = 55,000 yen.

In other words, as shown in the item of "JV amount" in "1. Billing details View" of FIG. 4, the system contract classification included in the sales details data 106c2 is "10: Sales" or "11: Rental listing sales". If there is, and the sales unit price included in the unit price master 106e is not 0, the JV amount calculation unit 102c sets the amount to be charged to the joint venture by the sales unit price included in the unit price master 106e × the sales statement data 106c2. It is calculated by the formula of the number of sales included in.

(3) Processing for Sales Details of Sales Line Number 3 The unit price acquired by the JV unit price acquisition unit 102b in (3) of [3-2] is not acquired from the unit price master 106e, but is acquired from the sales details data 106c2. It was done. In this case, the JV amount calculation unit 102c sets the amount to be charged to the joint venture as the sales main amount of 30,000 yen of the sales item of the sales line number 3 in the sales item data 106c2.

[3-4. Difference calculation process]
Next, the difference calculation unit 102d is the JV amount calculation unit of [3-3] from the total amount of the sales body amount (30,000 yen + 50,000 yen + 30,000 yen) included in the sales detail data 106c2 of FIG. -14,000 yen is calculated as the amount obtained by subtracting the total amount (39,000 yen + 55,000 yen + 30,000 yen) of the amount calculated in 102c.

More specifically, as shown in the items of "JV unit price" and "JV amount" in "2. Billing details View (discount)" of FIG. 4, the difference calculation unit 102d of the billing data 106f of FIG. 5 From the total amount of the sales body amount included in the billing details (= billing details View) of the slip line numbers 1 to 3, it is included in the billing details (= billing details View) of the billing data 106f of FIG. Calculate the amount obtained by subtracting the total amount of JV amount.

[3-5. Generation process]
Finally, the generation unit 102e has the unit price (13 yen, 5,500 yen, and 15 yen) acquired by the JV unit price acquisition unit 102b of [3-2] as shown in the billing data 106f of FIG. 5 surrounded by a thick frame. ) And the amount calculated by the JV amount calculation unit 102c of [3-3] (39,000 yen, 55,000 yen and 30,000 yen) and the amount calculated by the difference calculation unit 102d of [3-4]. Billing data 106f including (-14,000 yen) as a discount amount is generated. As shown in the billing data 106f of FIG. 5 surrounded by a thick frame, by including the JV unit price and the JV amount in the billing data 106f, it is possible to respond to the sponsor merit.

The item included in the billing data 106f and the derivation source of the item will be described in detail. In the billing data 106f of FIG. 5, the billing details of the slip line numbers 1 to 3 are the billing details View, and the billing details of the slip line numbers NULL are the billing details View (discount). Hereinafter, the billing details View and the billing details View (discount) will be described separately.

The items and the derivation source included in the billing details View are as shown in "1. Billing details View" of FIG. 4, but specifically, they are as follows. The derivation source of the billing number included in the billing detail View is the billing number included in the billing file 106a. The derivation source of the slip number included in the billing detail View is the slip number included in the collection schedule data 106b. The derivation source of the slip line number included in the billing detail View is the slip line number included in the collection schedule data 106b. The derivation source of the data category included in the billing statement View is the data category included in the scheduled collection data 106b. The derivation source of the sales body unit price included in the billing detail View is the sales body unit price included in the sales detail data 106c2. The derivation source of the sales body amount included in the billing detail View is the sales body amount included in the sales detail data 106c2. The derivation source of the JV unit price and the JV amount included in the billing statement View is as described at the beginning of this item [3-5].

The items and the derivation source included in the billing details View (discount) are as shown in "2. Billing details View (discount)" of FIG. 4, but specifically, they are as follows. The derivation source of the billing number included in the billing statement View (discount) is the billing number included in the billing statement View. The slip number, slip line number, and data classification in the billing details View (discount) are NULL. The unit price of sales and the amount of sales in the billing details View (discount) are 0 yen. The derivation source of the JV unit price and the JV amount included in the billing statement View (discount) is as described at the beginning of this item [3-5].

As described above, as described in this item [3-5], the billing data 106f shown in FIG. 5 corresponding to the sponsor merit could be generated. The discount amount of 14,000 yen in the generated billing data 106f will be the profit of the sponsor A construction.

[4. Summary of this embodiment]
As described above, according to the billing data generation device 100 according to the present embodiment, billing data corresponding to the sponsor merit can be generated.

Further, in the present embodiment, for example, in the goods leasing business such as temporary materials, attention is paid to the fact that the transaction unit price is determined for each site, and only the master management of the JV unit price is performed for the construction site that requires sponsor merit. Made it possible to issue invoices. As a result, for example, when inputting a slip, it is not necessary to be aware of the JV unit price. In other words, in the present embodiment, for example, if the JV unit price in the unit price master 106e is set once at the beginning, after that, only the slip input such as the sales slip is input, and the JV unit price is conscious each time. It can be said that it is very convenient because it can automatically generate billing data corresponding to the sponsor's merit.

Then, in the present embodiment, for example, in the goods leasing business such as temporary materials, it is common to calculate the consumption tax at the time of billing in order to record the period sales, so that the operation can be supported. .. As a result, for example, it is possible to eliminate an error on the invoice that occurs when the consumption tax for each item is accumulated.

Here, in the past, there were the following three problems, but in the present embodiment, the three problems could be solved by the solution means shown below.

The first issue is "I want to issue a sponsor merit response invoice." In order to solve the problem, in the present embodiment, when the JV unit price exists, the JV unit price (amount) is expressed on the billing statement, and the difference between the sales amount and the JV amount is used as the discount statement (1). I made it possible to express (collectively in the details). The total billing amount and the total sales amount match.

The second issue is "I want to keep the sales information (sales amount, discount amount) unchanged". In order to solve this problem, in this embodiment, it is possible to virtually generate invoice data from sales information (sales amount, discount amount) and JV unit price.

The third issue is "I want to reduce the workload associated with issuing invoices for sponsor merit (sponsor merit itself does not lead to profits for the company (= rental company), so additional costs are minimized. I want to) ". In order to solve this problem, in the present embodiment, it is possible to issue an invoice only by managing the JV unit price (= only by setting the unit price in the unit price master 106e once at the beginning).

[5. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

For example, of each of the processes described in the embodiments, all or part of the processes described as being performed automatically may be performed manually, or all the processes described as being performed manually. Alternatively, a part can be automatically performed by a known method.

In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

Further, with respect to the billing data generation device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

For example, with respect to the processing functions included in the billing data generation device 100, particularly each processing function performed by the control unit, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and billing data is generated as necessary. It is read mechanically by the device 100. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded. This computer program is executed by being loaded into RAM, and cooperates with a CPU to form a control unit.

Further, this computer program may be stored in an application program server connected to the billing data generator 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. Is.

Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

Further, the "program" is a data processing method described in an arbitrary language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. A well-known configuration and procedure can be used for a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like.

Various databases and the like stored in the storage unit are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

Further, the billing data generation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the billing data generation device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

Further, the specific form of the distribution / integration of the device is not limited to the one shown in the drawing, and all or a part thereof may be functionally or physically in an arbitrary unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

The present invention is, for example, useful in the goods leasing business, and particularly very useful in the goods leasing business for construction sites.

100 Billing data generator 102 Control unit
102a JV Site Acquisition Department
102b JV unit price acquisition department
102c JV amount calculation unit
102d difference calculation unit
102e Generation unit 104 Communication interface unit 106 Storage unit
106a billing file
106b Data to be collected
106c sales data
106c1 Sales header data
106c2 Sales statement data
106d field master
106e Product unit price master by customer site
106f Billing data 108 Input / output interface 112 Input device 114 Output device 200 Server 300 Network

Claims (5)

A billing data generator equipped with a control unit
The control unit
Based on sales data including site identification data, JV site identification data, which is a site master that holds site identification data and is site identification data for construction sites performed by a joint venture, is held in association with site identification data. JV site acquisition means for acquiring JV site identification data associated with the site identification data included in the sales data by referring to possible ones.
When the JV site acquisition means can acquire the JV site identification data, it is a unit price master that holds the unit price of the product by product, customer, and site, and holds the unit price for the joint venture. The JV unit price acquisition means for acquiring the unit price associated with the product identification data and the customer identification data included in the sales data and the JV site identification data acquired by the JV site acquisition means, and the JV unit price acquisition means.
A JV amount calculation means for calculating the amount to be charged to the joint venture based on the unit price acquired by the JV unit price acquisition means and the sales data.
A difference calculation means for calculating the amount obtained by subtracting the amount calculated by the JV amount calculation means from the sales amount included in the sales data, and
A generation means for generating billing data including the unit price acquired by the JV unit price acquisition means and the amount calculated by the JV amount calculation means and including the amount calculated by the difference calculation means as a discount amount.
To prepare
A billing data generator characterized by. The unit price master sets the daily unit price, which is the unit price for the joint venture when renting one product for one day, or the main unit price, which is the unit price for the joint venture when selling one product. Including more
The sales data further includes a rental transaction category, which means that the product is traded by rental, or a product sales transaction category, which is a category that means that the product is traded by product sales.
The JV unit price acquisition means
When the category included in the sales data is the rental transaction category, the daily unit price is acquired with reference to the unit price master, and when the category included in the sales data is the product sales transaction category, the above. To obtain the main unit price by referring to the unit price master,
The billing data generation device according to claim 1. The person who charges the joint venture is a trader who rents or sells the goods related to the construction to the joint venture.
The joint venture is composed of a plurality of companies involved in the construction.
The company having the highest investment ratio in the joint venture among the plurality of companies manages the ordering of the product to the trader and uses the discount amount as its own profit.
The billing data generation device according to claim 1 or 2. A billing data generation method executed by an information processing device provided with a control unit.
Executed by the control unit,
Based on sales data including site identification data, JV site identification data, which is a site master that holds site identification data and is site identification data for construction sites performed by a joint venture, is held in association with site identification data. With reference to what is possible, the JV site acquisition step of acquiring the JV site identification data associated with the site identification data included in the sales data, and
If the JV site identification data can be acquired in the JV site acquisition step, it is a unit price master that holds the unit price of the product by product, customer, and site, and holds the unit price for the joint venture. With reference to the product, the product identification data and the customer identification data included in the sales data, and the JV unit price acquisition step for acquiring the unit price associated with the JV site identification data acquired in the JV site acquisition step.
A JV amount calculation step for calculating the amount to be charged to the joint venture based on the unit price acquired in the JV unit price acquisition step and the sales data.
The difference calculation step for calculating the amount obtained by subtracting the amount calculated in the JV amount calculation step from the sales amount included in the sales data, and
A generation step for generating billing data including the unit price acquired in the JV unit price acquisition step and the amount calculated in the JV amount calculation step and including the amount calculated in the difference calculation step as a discount amount.
Including,
A billing data generation method characterized by. A billing data generation program to be executed by an information processing device equipped with a control unit.
To make the control unit execute
Based on sales data including site identification data, JV site identification data, which is a site master that holds site identification data and is site identification data for construction sites performed by a joint venture, is held in association with site identification data. With reference to what is possible, the JV site acquisition step of acquiring the JV site identification data associated with the site identification data included in the sales data, and
If the JV site identification data can be acquired in the JV site acquisition step, it is a unit price master that holds the unit price of the product by product, customer, and site, and holds the unit price for the joint venture. With reference to the product, the product identification data and the customer identification data included in the sales data, and the JV unit price acquisition step for acquiring the unit price associated with the JV site identification data acquired in the JV site acquisition step.
A JV amount calculation step for calculating the amount to be charged to the joint venture based on the unit price acquired in the JV unit price acquisition step and the sales data.
The difference calculation step for calculating the amount obtained by subtracting the amount calculated in the JV amount calculation step from the sales amount included in the sales data, and
A generation step for generating billing data including the unit price acquired in the JV unit price acquisition step and the amount calculated in the JV amount calculation step and including the amount calculated in the difference calculation step as a discount amount.
Including,
A billing data generation program characterized by.

Images