JP5152552B2 - Invoice (or estimate or invoice) creation system - Google Patents

Description

  The present invention relates to an invoice (or estimate or invoice) creation system, and in particular, an arbitrary invoice (or estimate) from a plurality of pre-patterned invoice (or estimate or invoice) patterns. (Invoice or invoice)) relates to a device designed to automatically select a pattern and automatically create a desired invoice (or estimate or invoice).

For example, issuance of invoices for lease / rental operations of construction machinery was generally performed as follows. First, since the format of the designated invoice is different for each customer, a plurality of types of formats are prepared so that each customer can handle them. Then, an arbitrary format is selected from among them, and items and amounts are entered in the selected format.
These operations may be performed by hand, or may be created using a computer in accordance with a program created in advance. When creating with a computer, a plurality of types of invoice creation programs are prepared in advance so as to correspond to different forms of designated invoices for each customer, and an arbitrary invoice creation program is selected and created. Is.

Here, an example of the customer specified invoice will be described with reference to FIGS. FIG. 31 shows the format of the designated invoice based on the total consumption tax calculation, and FIG. 32 shows the format of the designated invoice based on the detailed consumption tax calculation. FIGS. 31 (a) and 32 (a) show a bill book sheet, and FIGS. 31 (b) and 32 (b) show a bill specification sheet. The designated bill may or may not have the bill book paper shown in FIGS. 31 (a) and 32 (a).

In addition, the designated invoice may or may not exist for each item in the subtotal column E, the consumption tax column F, and the total column G. Even if a customer does not have a subtotal column E, consumption tax column F, or total column G, it is necessary to display the subtotal, consumption tax, total, or grand total on the detail line. Need to be displayed with the title changed to the subtotal, the total in the subtotal column E, and the grand total in the subtotal column E or total column G.

Further, as shown in FIG. 32, the consumption tax column F does not exist in the notation for customers of detailed consumption tax calculation. In addition, the number of lines in the detail line C of the invoice book sheet A and the detail line D in the invoice detail sheet B differ depending on the customer, and there are some customers who do not have the detail line C in the invoice book sheet A. The presence / absence of the subtotal column E, the consumption tax column F, and the total column G of the bill book paper A and the subtotal column E, the consumption tax column F, and the total column G of the bill specification sheet B are always the same for each customer.

Further, the details of the format of the designated invoice include rental sales and sales sales. Rental sales are the amount of the lending period (number of days) from the delivery date of the construction machine to the return date multiplied by the quantity and the unit price. During the lending period, unused days due to holidays and rain (in units of 0.5 days) ), Calculate the amount by subtracting the number of unused days from the lending period. On the other hand, sales revenue (sales other than rental sales, product sales, machine repair fee, product delivery fee, etc.) is calculated by multiplying the quantity by the unit price. In addition, the consumption tax is calculated only for the taxable product data, and it is necessary to calculate the taxable amount separately before and after the consumption tax rate change date. If there is a consumption tax rate change date during the rental period for rental sales, the consumption tax It is necessary to calculate the consumption tax by dividing the taxable amount before and after the tax rate change date.

For example, Patent Literature 1, Patent Literature 2 and the like are disclosed as technologies relating to the issuance of this type of bill.
JP 2004-318309 A JP 2006-281701 A

The conventional configuration has the following problems.
First, there is a problem that the creation of the invoice is troublesome because the format of the designated invoice is different for each customer. In particular, when creating an invoice by information processing using a computer, it is necessary to prepare multiple types of invoice creation programs in advance so that it can handle different designated invoices for each customer. There was a problem of requiring development man-hours.
It is conceivable to deal with this by unifying the invoice format, but in fact, most of the invoices are not accepted by the company's invoice. Submissions for each site are required, and eventually the problems described above will occur.
In addition, the lead time from the request closing date to the submission of the invoice is usually short, and there are many requests for correction after the submission, which requires a great deal of labor for invoicing.
Such a problem can be said not only in the creation of an invoice but also in the creation of an estimate and an invoice.

The present invention has been made based on such points, and the purpose of the present invention is to create an invoice (or estimate or invoice) with a designated invoice (or estimate or invoice) that differs for each customer. It is an object of the present invention to provide an invoice (or estimate or invoice) creation system that can be simplified and thereby rationalize the paperwork.

In order to achieve the above purpose, the invoice (or estimate or invoice) creation system according to claim 1 of the present application has a consumption tax calculation classification indicating whether it is a total consumption tax calculation or a detailed consumption tax calculation, and whether or not there is an invoice Customer category, number of detail lines, number of detail lines, subtotal field classification indicating presence / absence of subtotal field, consumption tax field indicating presence / absence of consumption tax, and total field indicating presence / absence of total field Whether the consumption tax calculation pattern is the total consumption tax calculation by extracting the information of the consumption tax calculation category corresponding to the customer from the customer master based on the customer information entered and stored in advance, and the customer master. Or the consumption tax calculation pattern discrimination means for discriminating whether it is a detailed consumption tax calculation, and the total of the subtotal column information and the consumption tax column information corresponding to the customer from the customer master based on the input customer information Information of column division Details line pattern setting means that sets a preset value in the memory work according to the combination of the presence / absence of the subtotal field classification, the presence / absence of the consumption tax field classification and the presence / absence of the total field classification, and the input customer information Based on the customer master information corresponding to the customer, information on the number of detail lines and information on the number of detail lines based on the customer master, the result of determination by the consumption tax calculation pattern determining means and the detail line pattern The number of lines that can be output in detail is calculated in consideration of the set value by the setting means, and the number of print lines set on the memory work is set in the memory work, and the work 1 set by the print line number setting means. Processing to determine whether the total number of pages ends in one page or covers multiple pages by comparing the number of page end print lines and the number of work details Based on the discrimination result by the pattern discrimination means and the consumption tax calculation pattern discrimination means, the set value by the detail line pattern setting means, the number of printed lines at the end of one page of the work by the print line number setting means, and the discrimination result by the processing pattern discrimination means And a bill (or estimate or delivery note) data creating means for creating bill (or estimate or delivery note) data.
Further, the invoice (or estimate or invoice) creation system according to claim 2 is the invoice (or estimate or invoice) creation system according to claim 1, wherein the printed line number setting means is one page of work. In addition to the number of finished print lines, the number of work book print lines, the number of work detail print lines, the number of work final print lines, and the number of work added 1-page print lines are also set in the memory work. is there.

As described above, according to the invoice creation system according to claim 1 of the present invention, a bill (or an estimate or an invoice) that stores a plurality of types of invoice (or estimate or invoice) patterns that have been patterned in advance. ) Appropriate from the multiple types of invoice (or quotation or delivery note) patterns stored in the pattern storage means and the invoice (or estimate or delivery note) pattern storage means based on the input information Invoice (or estimate or delivery note) pattern selection means for selecting a valid invoice (or estimate or delivery note) pattern, and the invoice selected by the above invoice (or estimate or delivery note) pattern selection means (Or an estimate or delivery note) Invoice creation means for creating an invoice (or estimate or delivery note) based on a pattern Easily And quickly in response it is possible to create a predetermined bill, it has become possible to rationalize paperwork.
For example, once a customer's pattern item is set, anyone can easily create designated invoice data, which dramatically improves work efficiency and saves paperwork.
Moreover, it can be used not only for invoices but also for quotations, delivery notes, etc., and can be widely used not only in the construction machine leasing / rental industry but also in other industries.
In addition, the invoice (or estimate or invoice) creation system according to claim 2 is the same as the above invoice (or estimate or invoice) in the invoice (or estimate or invoice) creation system according to claim 1. The pattern storage means is configured to store multiple types of invoice (or estimate or invoice) patterns divided based on the consumption tax calculation pattern, detail line pattern, and processing pattern. It is possible to effectively cope with a plurality of types of designated invoices having different patterns, detail line patterns, and processing patterns.
In addition, the invoice (or estimate or invoice) creation system according to claim 3 is the invoice (or estimate or invoice) creation system according to claim 2, wherein the consumption tax calculation pattern is the total consumption tax calculation. Alternatively, since it is configured to be divided into two patterns by the detailed consumption tax calculation, it is possible to effectively cope with both the total consumption tax calculation and the detailed consumption tax calculation.
In addition, the invoice (or estimate or invoice) creation system according to claim 4 is the same as the invoice (or estimate or invoice) creation system according to claim 2, wherein the above detailed line pattern indicates whether there is a subtotal column Therefore, the above line pattern shows whether there is a subtotal column category, a consumption tax column category, and a total column category. It is possible to effectively cope with any case.
Further, an invoice (or estimate or invoice) creation system according to claim 5 is the invoice (or estimate or invoice) creation system according to claim 2, wherein the processing pattern has a total number of one page. Since it is configured to be divided into two patterns depending on whether it ends with a plurality of pages, the above processing pattern is effective even when the total number of pages ends with one page or covers a plurality of pages. Can respond.

Hereinafter, an embodiment of the present invention will be described with reference to FIGS. This embodiment shows an example in which the present invention is applied to the issuance of a bill in a construction machine lease / rental business.
First, an outline of the bill creation system according to the present embodiment will be described with reference to FIGS. In the case of this embodiment, first, “calculation information” that automates billing calculation and “created” that automatically creates designated invoice data by arranging and patterning the format of different designated invoices for each customer. Information "is set

In the company information master 1 shown in FIG. 1A, the consumption tax rate change date 118, the pre-tax rate 119, and the post-tax rate 120 are provided as common information. In addition, as shown in FIG. 1B, in the customer master 2, the consumption tax calculation classification 206 of whether the consumption tax calculation is the total consumption tax calculation or the detailed consumption tax calculation is rounded off in the information for each customer, and the round of the consumption tax calculation is rounded down. A consumption tax rounding section 213 of rounding, rounding up or rounding up is provided. Further, as shown in FIG. 1 (d), in the invoice data 4, a tax classification 422 indicating whether taxable or non-taxable is provided for each item of information.

As for the following creation information, in the customer master 2 shown in FIG. 1 (b), the consumption tax calculation category 206, the identification category 207 for presence / absence of invoice sheet, the number of identification lines 208, the number of description lines 209, a subtotal column section 210 with / without subtotal column, a consumption tax column section 211 with / without consumption tax column, and a total column section 212 with / without total column. Based on the creation information and the number of details of each invoice data 4 shown in FIG. 1 (d), the format of the designated invoice that differs for each customer is organized and patterned as follows.

First, the consumption tax calculation pattern is divided into patterns depending on whether it corresponds to “total consumption tax calculation” shown in FIG. 3 or “detailed consumption tax calculation” shown in FIG.
Next, for the detail line pattern (5-A in FIG. 3, 6-A in FIG. 4), “subtotal column” (E in FIG. 31 used in the description of the conventional example, FIG. 32 used in the description of the conventional example) E), “consumption tax column” (F in FIG. 31), and “total column” (G in FIG. 31, G in FIG. 32) are divided and patterned.
Next, the total consumption tax calculation is divided into seven patterns 1, 2, 4 to 8 in FIG.
Next, the detailed consumption tax calculation is divided into four patterns 1, 2, 5, and 6 in FIG.
Furthermore, the processing pattern (5-B in FIG. 3, 6-B in FIG. 4) is “processing pattern I” when the total number of pages is one page, and “processing pattern” when the total number of pages is multiple pages. II ".
However, regarding the processing pattern, when the book classification 207 shown in FIG. 1B is “Yes” and the book description row number 208 is “0”, the statement is output on the bill specification sheet B on the second page. Therefore, even if it is the 2nd page, it is necessary to process it as the 1st page.

Further, the number of lines that can be output in detail from the consumption tax calculation pattern, the detailed line pattern, the processing pattern, the number of lines on the reference sheet (C in FIGS. 31 and 32), and the number of detailed sheet in detail lines (D in FIGS. 31 and 32) ( 5-C in FIG. 3 and 6-C in FIG. 4 are calculated, and the number of print pages 828 of the work 1 page of the memory work 8 shown in FIG. By setting the work final print line number 831 and the work added one page print line number 832, detailed line control for each page is performed, and designated bill data 7 shown in FIG. Then, in the memory work 8, the “processing pattern I” or “processing pattern II” is obtained by comparing the number of printed lines 828 at the end of one page of the work with the number of details of each invoice data 4 shown in FIG. It is determined which one of these.
The above is the outline of the bill creation system according to the present embodiment.

Hereinafter, a detailed description will be given with reference to FIGS. FIG. 5 is a functional block diagram showing a configuration of a control device for performing each master maintenance and invoice data 4 creation. First, as shown in FIG. 5A, the company information master maintenance 13 enables the company information master 1 to be corrected by inputting from the keyboard 9. Further, as shown in FIG. 5B, the customer master maintenance 14 searches the company information master 1 and can add, modify, and delete the customer master 2 by inputting the keyboard 9.

Further, as shown in FIG. 5C, the site master maintenance 15 searches for the customer master 2 by inputting from the keyboard 9 and can add, modify, and delete the site master 3. Then, as shown in FIG. 5 (d), the bill data creation 16 allows the bill data 4 to be added and modified by inputting the bill data from the keyboard 9, and the bill data of the main system is stored in the floppy 11 Or from the network 12, although not shown, can be directly imported in CSV format from an external medium such as a flash memory.

The invoice data 4 created in the invoice data creation 16 is classified according to the product category 409 {(shown in FIG. 1 (d)} rental or sale. First, in the case of rental, the delivery date The amount of money 419 is calculated by multiplying the number of days 415 minus the unused suspension days 414 from the rental period from 412 to the return date 413 by the quantity 416 and the unit price 418. Also, the unused suspension days 414 is 0.5 days. When there is a consumption tax rate change date 118 during the rental period from the delivery date 412 to the return date 413 in the above (half day unit), the display 10 is configured to divide the invoice data 4 before and after the consumption tax rate change date 118. In addition, if the product category 409 {(shown in FIG. 1 (d)} is sales), the amount 419 is calculated by multiplying the quantity 416 and the unit price 418.

Detailed consumption tax 420 {(shown in FIG. 1D) is set to “0” when the consumption tax calculation category 206 {(shown in FIG. 1B) is a total consumption tax calculation. When the category 206 {(shown in FIG. 1 (b)} is a detailed consumption tax calculation and the taxable category 422 {(shown in FIG. 1 (d)} is not taxable, it is set to “0”. Also, the taxable category 422 { (Shown in FIG. 1 (d)} is taxable and the product category 409 {(shown in FIG. 1 (d)} is rental date of delivery 412 {(shown in FIG. 1 (d)}), return date Date 413 {(shown in FIG. 1 (d)} is compared with the consumption tax rate change date 118 {(shown in FIG. 1 (a)}) and the amount before the consumption tax rate change date 118 {(shown in FIG. 1 (a)} And the calculation result is multiplied by the pre-tax rate 119 {(shown in FIG. 1 (a)}) before the previous consumption tax and the consumption tax rate change date 118 {(shown in FIG. 1 (a)}) Calculate the amount and multiply the calculation result by the post-tax rate 120 {(shown in Fig. 1 (a)}) to calculate the post-consumption tax, the sum of the pre-consumption tax and post-consumption tax, the consumption tax rounding category 213 {(Fig. 1 (b) } And set to detailed consumption tax 420 {(shown in FIG. 1 (d)}. Tax classification 422 {(shown in FIG. 1 (d)} is taxable and product category 409 {(FIG. 1 (d )} For sale, if the delivery date 412 is before the consumption tax rate change date 118 {(shown in FIG. 1 (a)}), the amount 419 {(shown in FIG. 1 (d)} Pre-tax rate 119 {(shown in FIG. 1 (a)} is multiplied, consumption tax rounding division 213 {(shown in FIG. 1 (b)}) is rounded and set to detailed consumption tax 420 {(shown in FIG. 1 (d)} If the delivery date 412 {(shown in FIG. 1 (d)} is after the consumption tax rate change date 118 {(shown in FIG. 1 (a)}), the amount 419 { 1} is multiplied by the post-tax rate 120 {(shown in FIG. 1 (d)}, rounded by the consumption tax rounding section 213 {(shown in FIG. 1 (b)}, and set in the detailed consumption tax 420. .

FIG. 6 is a functional block diagram showing the configuration of the control device for creating designated invoice data 7 {(shown in FIG. 1 (g)). Site total work creation 17, field subtotal work creation 18 and designation It consists of three functions of invoice data creation 19. Based on the creation information described above, display of subtotal, consumption tax, total, etc. on different detail lines depending on the customer's designated invoice form, and total column G (conventional 31 and FIG. 32 used for explaining the example) subtotal, subtotal column E (shown in FIG. 31 and FIG. 32 used for explaining the conventional example), total, subtotal column E or total column G If control is performed to display. sales tax calculation segment 206 of total consumption tax calculation, based on the detail line pattern of FIG. 3 (5-a), the processing pattern (5-B), (5 -C ) ~ (5-F) processing control is performed, consumption tax calculation If min 206 item sales tax calculation, detail lines pattern shown in FIG. 4 (6-A), based on the processing pattern (6-B), the processing control (6-C) ~ (6 -F) Done.

（１０）ワーク１頁終了印刷行数８２８

（ａ）消費税計算区分２０６が合計消費税計算
鑑区分２０７が有、鑑明細行数２０８≠０の時
・ワーク明細行パターン８２７＝１
顧客マスタ２の鑑明細行数２０８−３ をセット
・ワーク明細行パターン８２７＝２又は５
顧客マスタ２の鑑明細行数２０８−２ をセット
・ワーク明細行パターン８２７＝７
顧客マスタ２の鑑明細行数２０８−１ をセット
・ワーク明細行パターン８２７＝４又は６又は８
顧客マスタ２の鑑明細行数２０８ をセット
鑑区分２０７が有、鑑明細行数２０８＝０ 又は 鑑区分２０７が無 の時
・ワーク明細行パターン８２７＝１
顧客マスタ２の明細書明細行数２０９−３ をセット
・ワーク明細行パターン８２７＝２又は５
顧客マスタ２の明細書明細行数２０９−２ をセット
・ワーク明細行パターン８２７＝７
顧客マスタ２の明細書明細行数２０９−１ をセット
・ワーク明細行パターン８２７＝４又は６又は８
顧客マスタ２の明細書明細行数２０９ をセット

（ｂ）消費税計算区分２０６が明細消費税計算
鑑区分２０７が有、鑑明細行数２０８≠０の時
・ワーク明細行パターン８２７＝１
顧客マスタ２の鑑明細行数２０８−１ をセット
・ワーク明細行パターン８２７＝２又は５又は６
顧客マスタ２の鑑明細行数２０８ をセット
鑑区分２０７が有、鑑明細行数２０８＝０ 又は 鑑区分２０７が無 の時
・ワーク明細行パターン８２７＝１
顧客マスタ２の明細書明細行数２０９−１ をセット
・ワーク明細行パターン８２７＝２又は５又は６
明細書明細行数２０９ をセット
（１１）ワーク鑑印刷行数８２９

（ａ）消費税計算区分２０６が合計消費税計算
鑑区分２０７が有、鑑明細行数２０８≠０の時
・ワーク明細行パターン８２７＝１又は７
顧客マスタ２の鑑明細行数２０８−１ をセット
・ワーク明細行パターン８２７＝２又は４又は５又は６又は８
顧客マスタ２の鑑明細行数２０８ をセット
鑑区分２０７が有、鑑明細行数２０８＝０ 又は 鑑区分２０７が無 の時
０ をセット

（ｂ）消費税計算区分２０６が明細消費税計算
鑑区分２０７が有、鑑明細行数２０８≠０の時
・ワーク明細行パターン８２７＝１
顧客マスタ２の鑑明細行数２０８−１ をセット
・ワーク明細行パターン８２７＝２又は５又は６
顧客マスタ２の鑑明細行数２０８ をセット
鑑区分２０７が有、鑑明細行数２０８＝０ 又は 鑑区分２０７が無 の時
０ をセット
（１２）ワーク明細印刷行数８３０

（ａ）消費税計算区分２０６が合計消費税計算
ワーク明細行パターン８２７＝１ 又は ７
顧客マスタ２の明細書明細行数２０９−１ をセット
ワーク明細行パターン８２７＝２又は４又は５又は６又は８
顧客マスタ２の明細書明細行数２０９ をセット

（ｂ）消費税計算区分２０６が明細消費税計算
ワーク明細行パターン８２７＝１
顧客マスタ２の明細書明細行数２０９−１ をセット
ワーク明細行パターン８２７＝２又は５又は６
顧客マスタ２の明細書明細行数２０９ をセット
（１３）ワーク最終印刷行数８３１

（ａ）消費税計算区分２０６が合計消費税計算
・ワーク明細行パターン８２７＝１
顧客マスタ２の明細書明細行数２０９−４ をセット
・ワーク明細行パターン８２７＝２又は５
顧客マスタ２の明細書明細行数２０９−３ をセット
・ワーク明細行パターン８２７＝７
顧客マスタ２の明細書明細行数２０９−２ をセット
・ワーク明細行パターン８２７＝４又は８
顧客マスタ２の明細書明細行数２０９−１ をセット
・ワーク明細行パターン８２７＝６
顧客マスタ２の明細書明細行数２０９ をセット

（ｂ）消費税計算区分２０６が明細消費税計算
・ワーク明細行パターン８２７＝１
顧客マスタ２の明細書明細行数２０９−２ をセット
・ワーク明細行パターン８２７＝２又は５
顧客マスタ２の明細書明細行数２０９−１ をセット
・ワーク明細行パターン８２７＝６
顧客マスタ２の明細書明細行数２０９ をセット
（１４）ワーク追加１頁印刷行数８３２

（ａ）消費税計算区分２０６が合計消費税計算
・ワーク明細行パターン８２７＝１
顧客マスタ２の明細書明細行数２０９−３ をセット
・ワーク明細行パターン８２７＝２又は５
顧客マスタ２の明細書明細行数２０９−２ をセット
・ワーク明細行パターン８２７＝７
顧客マスタ２の明細書明細行数２０９−１ をセット
・ワーク明細行パターン８２７＝４又は６又は８
顧客マスタ２の明細書明細行数２０９ をセット

（ｂ）消費税計算区分２０６が明細消費税計算
・ワーク明細行パターン８２７＝１
顧客マスタ２の明細書明細行数２０９−１ をセット
・ワーク明細行パターン８２７＝２又は５又は６
明細書明細行数２０９ をセット Next, information processing by the three functions of on-site total work creation 17, on-site subtotal work creation 18, and designated bill data creation 19 will be described with reference to the flowcharts shown in FIGS.
As shown in FIG. 7, the site total work creation 17 first searches the company information master 1 (step S17-1). Next, the customer master 2 is searched with the sales office code 104 → the sales office code 201 and the customer 9 input with the keyboard 9 → the customer code 202 (step S17-2), and the calculation information, creation information, etc. described above are as shown below. The memory work 8 is set (step S17-3).
(1) Work company name 801 to post-work tax rate 819
Set company name 102 to post-tax rate 120 in company information master 1 (2) Work billing date 820
Set billing date of keyboard 9 input (3) Work customer code 821
Set customer with keyboard 9 input (4) Work customer name 822
Set customer name 204 of customer master 2 (5) Work consumption tax calculation classification 823
Set consumption tax calculation class 206 of customer master 2 (6) Work consumption tax rounding class 824
Set consumption tax rounding classification 213 of customer master 2 (7) Work classification classification 825
Set the signature classification 207 of the customer master 2 (8) Number of work signature details 826
Set the number 208 of detail lines of customer master 2 (9) Work detail line pattern 827
It is as shown in the following Table 1.

(10) Number of print lines 828 at the end of one work page

(A) When the consumption tax calculation section 206 has the total consumption tax calculation book classification 207 and the number of book detail lines 208 ≠ 0. Work detail line pattern 827 = 1
Set the number of detail lines 208-3 of the customer master 2 as the set work detail line pattern 827 = 2 or 5
The number of detail lines 208-2 of the customer master 2 is set as the set work detail line pattern 827 = 7.
The number of manual lines 208-1 of the customer master 2 is set as the set work line pattern 827 = 4, 6 or 8
The number of detail lines 208 in the customer master 2 is the set book classification 207, the number of book details 208 = 0, or the number of the book classification 207 is not. Work detail line pattern 827 = 1
Set the detail line number 209-3 of the customer master 2 to the set work detail line pattern 827 = 2 or 5
Set number of detail lines 209-2 of customer master 2 as set work detail line pattern 827 = 7
Set the detail line number 209-1 of the customer master 2 as the set work detail line pattern 827 = 4 or 6 or 8
Set number 209 of description lines in customer master 2

(B) When the consumption tax calculation category 206 is the detailed consumption tax calculation book category 207 and the number of book details is 208 ≠ 0
・ Work Detail Line Pattern 827 = 1
The number of detail lines 208-1 of the customer master 2 is set as the set work detail line pattern 827 = 2, 5 or 6
The number of detail lines 208 in the customer master 2 is the set book classification 207, the number of book details 208 = 0, or the number of the book classification 207 is not. Work detail line pattern 827 = 1
The number of detail lines 209-1 of the customer master 2 is set to the set work detail line pattern 827 = 2, 5 or 6
Set number 209 of description lines (11) Number of work book print lines 829

(A) When the consumption tax calculation section 206 has the total consumption tax calculation book classification 207 and the number of book detail lines 208 ≠ 0. Work detail line pattern 827 = 1 or 7
The number of details line 208-1 of the customer master 2 is set as the set work detail line pattern 827 = 2, 4 or 5 or 6 or 8
Set the number of detail lines 208 of the customer master 2 when the set book classification 207 is present and the number of book details 208 = 0 or the book classification 207 is not present

(B) When the consumption tax calculation section 206 is the detailed consumption tax calculation book classification 207 and the number of book detail lines 208 is not 0, the work detail line pattern 827 = 1
The number of detail lines 208-1 of the customer master 2 is set as the set work detail line pattern 827 = 2, 5 or 6
Set the number of detail lines 208 of the customer master 2 when the set book classification 207 is present and the number of detail lines 208 = 0 or when the number of classifications 207 is not set. (12) Number of print lines 830

(A) The consumption tax calculation classification 206 is the total consumption tax calculation work detail line pattern 827 = 1 or 7
The number of detail lines 209-1 of the customer master 2 is set to the set work detail line pattern 827 = 2, 4 or 5 or 6 or 8
Set number 209 of description lines in customer master 2

(B) The consumption tax calculation classification 206 is a detailed consumption tax calculation work detail line pattern 827 = 1.
The number of detail lines 209-1 of the customer master 2 is set to the set work detail line pattern 827 = 2, 5 or 6
Set detail line number 209 of customer master 2 (13) Work final print line number 831

(A) Consumption tax calculation classification 206 is total consumption tax calculation / work detail line pattern 827 = 1
Set the detail line number 209-4 of the customer master 2 to the set work detail line pattern 827 = 2 or 5
Set number of detail lines 209-3 of customer master 2 as set work detail line pattern 827 = 7
Set the detail line number 209-2 of the customer master 2 to the set work detail line pattern 827 = 4 or 8
Set the detail line number 209-1 of the customer master 2 as the set work detail line pattern 827 = 6
Set number 209 of description lines in customer master 2

(B) Consumption tax calculation classification 206 is detailed consumption tax calculation / work detail line pattern 827 = 1
Set the detail line number 209-2 of the customer master 2 to the set work detail line pattern 827 = 2 or 5
Set the detail line number 209-1 of the customer master 2 as the set work detail line pattern 827 = 6
Set detail line number 209 of customer master 2 (14) Work added 1 page print line number 832

(A) Consumption tax calculation classification 206 is total consumption tax calculation / work detail line pattern 827 = 1
Set the detail line number 209-3 of the customer master 2 to the set work detail line pattern 827 = 2 or 5
Set number of detail lines 209-2 of customer master 2 as set work detail line pattern 827 = 7
Set the detail line number 209-1 of the customer master 2 as the set work detail line pattern 827 = 4 or 6 or 8
Set number 209 of description lines in customer master 2

(B) Consumption tax calculation classification 206 is detailed consumption tax calculation / work detail line pattern 827 = 1
The number of detail lines 209-1 of the customer master 2 is set to the set work detail line pattern 827 = 2, 5 or 6
Set the number of description lines 209

Next, the work invoice amount 833 (initial value 0), the pre-work tax total 834 (initial value 0), the post-work tax total 835 (initial value 0), the work consumption tax 836 (initial value 0), the number of work items 837 ( Initial values 0), the number of remaining workpiece details 838 (initial value 0), and the number of workpiece repetitions 839 (initial value 1) are initialized (step S17-4), and then the record of the work total workpiece 5 is cleared (step S17-4). Step S17-5).

Also, the extraction conditions of work billing date 820 → billing date 401, work sales office code 803 → business office code 402, work customer code 821 → customer code 403 are set (step S17-6), and then billing is performed. One document data 4 is read in the key order (step S17-7). Next, an EOF determination is performed on the invoice data 4 (step S17-8). If the determination result is “YES”, a message to that effect is displayed (step S17-9), and the above-described step S17-2 is performed. Return. In step S17-8, if the EOF determination is “NO”, the site No. 404 is the work site number. It is set to 840 (step S17-10). Next, the record data of the invoice data 4 is cumulatively set as shown in the memory work 8 (step S17-11).
If the product category 409 is rental, the amount 419 is accumulated in the bill 833 for the current month. If the tax category 422 is taxable, the delivery date 412 and the return date 413 are changed. The amount before the work consumption tax rate change date 817 is calculated while comparing with the day 817, and the calculation result is accumulated in the pre-work tax total 834. Also, the amount after the work consumption tax rate change date 817 is calculated and the calculation result is accumulated in the post-work tax total 835, and the product category 409 also accumulates the amount in the work current month invoice amount 833. Further, in the case where the taxation classification 422 is taxable, when the delivery date 412 is before the work consumption tax rate change date 817, the amount 419 is accumulated in the pre-work tax total 834. When the delivery date 412 is after the work consumption tax rate change date 817, the amount 419 is accumulated in the post-work tax total 835. Further, the detailed consumption tax 420 is accumulated in the work consumption tax 836, and +1 is added to the work specification number 837.

Next, the invoice data 4 is read in the next order in the key order (step S17-12), and then the EOF determination of the invoice data 4 is performed (step S17-13). If the EOF determination in step S17-13 is “NO”, the site No. 404 = work site No. The comparison determination of 840 is performed (step S17-14). If the result of determination is “YES”, the memory work of the same processing as step S17-11 already described is accumulated (step S17-15). Then, the process moves to reading one invoice data 4 in step S17-12. If “NO” in the comparison determination in step S17-14, the on-site total work 5 output subroutine is performed (step S17-16), and the on-site total work 5 record is output.

Next, the on-site total work 5 output subroutine (step S17-16) will be described. First, the work sales office code 803 → the sales office code 301, the work customer code 821 → the customer code 302, the work site No. 840 → No. In step 303, the site master 3 is searched (step S17-20). Next, the billing date 501 to the number of details 512 of the field total work 5 are edited as follows (step S17-21). That is, the work billing date 820 → the billing date 501; the work sales office code 803 → the sales office code 502; the work customer code 821 → the customer code 503; 840 → No. 504, construction code 304 to salesperson 308 of construction site master 3 → construction code 505 to salesperson 509, work monthly billing amount 833 → monthly billing amount 510, number of work details 837 → number of details 512.

Next, a work consumption tax calculation category 823 = total consumption tax calculation or comparison determination is performed (step S17-22). If the result of determination is "YES", the result of multiplying the pre-work tax total 834 by the pre-work tax rate 818 Then, the result obtained by multiplying the post-work tax total 835 by the post-work tax rate 819 is summed, and the result rounded by the work consumption tax rounding section 824 is set in the current month consumption tax 511 (step S17-23). If the comparison determination in step S17-22 is “NO” (detailed consumption tax calculation), the work consumption tax 836 is set to the current month consumption tax 511.

Next, a comparison determination of (work item number 837> work one page end print line number 828) is performed (step S17-25). If the determination result is “YES”, “II” is set in the processing pattern 513. (Step S17-26). Next, the comparison of the work classification 825 = “present” is performed (step S17-27). If the result of the determination is “NO”, the value of the number of work details 837−number of work details print lines 830 is set as the remaining work. The number of details is set to 838, and the workpiece repetition count 839 is incremented by 1 (step S17-28). When the comparison determination in step S17-27 is “YES”, next, a comparison determination is performed with the number of work identification lines 826 = 0 (step S17-29). If the determination result is “YES”, +1 is added to the workpiece repetition count 839 (step S17-30), and then the process proceeds to step S17-28. If “NO” is determined in the comparison determination in step S17-29, the value of (work item number 837−work book print line number 829) is set as the remaining work item number 838, and +1 is added to the number of work repetitions 839 (step). S17-31).

After step S17-28 or step S17-31, a comparison determination of (work remaining specification number 838> work specification print line number 830) is performed (step S17-32), and if the determination result is “YES” ( The number of remaining work details 838-the number of work detail print lines 830) is set as the number of remaining work details 838, and the number of work repetitions 839 is incremented by 1 (step S17-33). Then, the process moves to step S17-32, and the process of step S17-33 is repeated until the comparison determination in step S17-32 becomes “NO”. When the comparison determination in step S17-32 is “NO”, a comparison determination of (number of remaining workpiece details 838 ≦ number of final printed lines 831) is performed (step S17-34). In the case of “YES” as a result of the determination, the workpiece repetition count 839 → total page number 514, “none” → one page addition SW 515 is set (step S17-35), and the field total workpiece 5 record is output. (Step S17-37). Then, the on-site total work 5 output subroutine ends. If “NO” in the comparison determination in step S17-34, the invoice details can be output if the number of current pages is maintained, but subtotals, consumption taxes, totals, grand totals, etc. that must be output to the details line are displayed. Since the page cannot be output, as a process of adding one page, the number of work repetitions 839 + 1 → total number of pages 514, “present” → add one page SW 515 is set (step S17-36). Then, the record output process for the field total work 5 in step 17-37 is performed, and the field total work 5 output subroutine is terminated.

If “NO” in the comparison determination in step S17-25, a comparison determination is made with the work signature classification 825 = “present” and the number of work signature details rows 826 = 0 (step S17-38). “I” → processing pattern 513, 1 → total number of pages 514, “none” → one page addition SW 515 is set (step S17-39). When the comparison determination in step S17-38 is “YES”, “I” → processing pattern 513, 2 → total number of pages 514, “none” → one page addition SW 515 is set (step S17-40). Thereafter, the record output process for the field total work 5 in step S17-37 is performed, and the field total work 5 output subroutine is terminated.

After the on-site total work 5 output subroutine processing in step S17-16, the site No. 404 is the work site number. Set to 840 (step S17-17), bill for work current month 833 (initial value 0), pre-work tax total 834 (initial value 0), post-work tax total 835 (initial value 0), work consumption tax 836 (initial Value 0), number of workpiece details 837 (initial value 0), number of remaining workpiece details 838 (initial value 0), and workpiece repetition count 839 (initial value 1) are initialized (S17-18), and step S17-15 is performed. Move to cumulative processing.

If “YES” is determined in the EOF determination of the invoice data 4 in step S17-13, the on-site total work 5 output subroutine (step S17-19) already described is processed, and the on-site total work creation 17 is completed. .

On-site subtotal work creation 18 first initializes work subtotal 841 (initial value 0), work consumption tax subtotal 842 (initial value 0), work processing number 843 (initial value 0), and work page No. 844 (initial value 1). (Step S18-1) Next, the record of the on-site subtotal work 6 is cleared (Step S18-2).

Next, one field total work 5 is read in the key order (step S18-3). Next, the EOF determination of the work total work 5 is performed (step S18-4). If the determination result is “NO”, the billing date 501 → the billing date 401, business, using the invoice data 4 as the extraction condition Location code 502 → Sales office code 402, customer code 503 → customer code 403, site No. 504 → site No. 404 are set (step S18-5), and one invoice data 4 is read in the key order (step S18-6). .

Next, the work book classification 825 = “Yes”, the number of work book detail lines 826 = 0, and the work page No. 844 = 1 or not (step S18-7). If the determination result is “NO”, the amount 419 is accumulated in the work subtotal 841, the detailed consumption tax 420 is accumulated in the work consumption tax subtotal 842, and the work is subtracted. +1 is added to the processing number 843 (step S18-10). When the comparison determination in step S18-7 is “YES”, a subtotal work 6 output subroutine is performed (step S18-8). 844 is incremented by +1 (step S18-9), and the process moves to the accumulation process (step S18-10).

Next, the subtotal work 6 output subroutine will be described. First, the billing date 601 to the consumption tax subtotal 607 of the site subtotal work 6 are edited as follows (step S).
18-24). Work billing date 820 → billing date 601; work sales office code 803 → work office code 602; work customer code 821 → customer code 603; 504 → No. 604, work page no. 844 → Page No. 605, work subtotal 841 → subtotal 606, work consumption tax subtotal 842 → consumption tax subtotal 607 are set (step S18-24). Then, a record of the on-site subtotal work 6 is output (step S18-25), and the on-site subtotal work 6 output subroutine is terminated.

Next, the invoice data 4 is read in the next order in the key order (step S18-11), and then the EOF determination of the invoice data 4 is performed (step S18-12). Performs the cumulative processing (step S18-13) of the same processing as step S18-10 already described. Next, the work page No. A comparison determination of 844 = 1 is performed (step S18-14). If the determination result is “NO”, a comparison determination of (work processing number 843 <work detail print line number 830) is performed (step S18-15). . In the case of “YES” as a result of the determination, the process moves to reading one case of the invoice data 4 in step S18-11.

If “YES” in the comparison determination in step S18-14, a comparison determination of work classification 825 = “Yes” is performed (step S18-16). If the determination result is “NO”, step S18- The process moves to 15 comparison determinations. If the comparison determination in step S18-16 is “YES”, a comparison determination of (work processing number 843 <work book print line number 829) is performed (step S18-17), and if the determination result is “YES”. Shifts the process to reading one invoice data 4 in step S18-11. If “NO” in the comparison determination in step S18-15 and “NO” in the comparison determination in step S18-17, the already described on-site subtotal work 6 output subroutine processing is performed (step S18-18). Also, work page No. 844 is incremented by 1 (step S18-19), the work subtotal 841 to the work processing number 843 is initialized (step S18-20), and the process is moved to reading one invoice data 4 in step S18-11. To do.

If “YES” in the EOF determination of the invoice data 4 in step S18-12, a comparison determination of (work processing number 843> 0) is performed (step S18-21), and if the determination result is “YES” Performs the on-site subtotal work 6 output subroutine (step S18-22) already described. Also, work subtotal 841 to work page No. 844 initialization (step S18-23) is performed, and the process moves to reading one case of the field total work 5 (step S18-3). When the comparison determination in step S18-21 is “NO”, the work subtotal 841 to the work page No. The processing moves to initialization of step 844 (step S18-23).

In the case where “YES” is determined in the EOF determination of the on-site total work 5 in step S18-4, the on-site subtotal work creation 18 is terminated.

The designated invoice data creation 19 starts with the number of work processes 843 (initial value 0), work page No. 844 (initial value 1), work output order No. 845 (initial value 1) is initialized (step S19-1), and then the record of the designated invoice data 7 is cleared (step S19-2).

One site total workpiece 5 is read in the key order (step S19-3), and EOF determination of the site total workpiece 5 is performed (step S19-4). If “NO” in the comparison determination in step S19-4, the billing date 501 → the billing date 601; the sales office code 602 → the sales office code 602; the customer code 503 → the customer code 603; 504 → No. 604, work page no. 844 → Page No. In step 605, the site subtotal work 6 is searched (step S19-5). Next, the extraction condition of the invoice data 4 is as follows: billing date 501 → billing date 401, sales office code 502 → sales office code 402, customer code 503 → customer code 403, site No. 504 → No. 404 is set (step S19-6), and one invoice data 4 is read in key order (step S19-7).

When the work classification 825 = “presence” (work identification line number 826 = 0) is compared (step S19-8), if the determination result is “NO”, “details” is transferred to the work edit control 846. Set (step S19-13). Also, a designated billing data 7 output subroutine (step S19-14) is performed. If the comparison determination in step S19-8 is “YES”, “space” is set in the work edit control 846 (step S19-9), and the designated billing data 7 output subroutine (step S19-10) is performed. Also, work page No. 844 is incremented by 1 (step S19-11). The billing date 501 → the billing date 601; the sales office code 602 → the sales office code 602; the customer code 503 → the customer code 603; 504 → No. 604, work page no. 844 → Page No. 605 is set to search for the site subtotal work 6 (step S19-12), and the process is moved to step S19-13.

Next, the designated billing data 7 output subroutine will be described. The record items of the designated request data 7 output by the subroutine have the following framework.
(A) Key item Billing date 701 to output order No. 705
(B) Special item identification item Special item classification 706
(C) Common items
Customer name 707-Total number of pages 728
(D) First page item Monthly charge 729 to Total charge 731
(E) Item Item Product category 732-Tax exemption display 746
(F) Page No. Item Page No. 747
(G) Subtotal items Subtotal 748-Subtotal tax included 752
(H) Consumption tax display item Consumption tax 753
(I) Total items Total 754-Total tax included 758
In the designated request data 7 output subroutine, record control is performed by performing editing control for each of the frameworks (a) to (i).

(A) Editing of Key item Work work request date 820 → charge date 701, work sales office code 803 → business office code 702, work customer code 821 → customer code 703, site No. 504 → site No. 704, work output order No. 845 → Output order no. 705 is set (step S19-63).

(B) Editing of work item identification item Work work classification 825 = “Yes” and work page No. A comparison determination of 844 = 1 is performed (step S19-64). If the result of determination is “YES”, “book” → book detail classification 706 is set (step S19-65), and step S19-64. If the comparison determination of “NO” is “NO”, “DETAIL” → DEPLICATION DETAIL 706 is set (step S19-66).

(C) Edit common items Work customer name 822-> customer name 707, construction code 505-salesperson 509-> construction code 708-salesperson 712, work company name 801-> company name 713, work company name Kana 802-> company Name Kana 714, work sales office 804 to work account name Kana 816 → sales office 715 to account name Kana 727, total page number 514 → total page number 728 are set (step 19-67).

(D) Edit work page No. of the first page item. 844 = 1 is compared (step S19-68). If the determination result is “YES”, the current month invoice amount 510 → current month invoice amount 729, current month consumption tax 511 → current month consumption tax 730, current month invoice amount 510+ Current month consumption tax 511 → total billed amount 731 is set (step S19-69). If the comparison determination in step S19-68 is “NO”, blank → current month charged amount 729, blank → current month consumption tax 730, blank → total charged amount 731 are set (step S19-70).

(E) Editing of the item items In addition to editing the invoice data 4, the item items edit the subtotal line, consumption tax line, total line, total line, and space line and continuous display line according to the line pattern. There is a need. The information for performing the edit control is the work edit control 846, and the control in the subroutine is performed by setting the edit control information in the work edit control 846 before calling the designated billing data 7 output subroutine. First, the workpiece edit control 846 = “space” is compared and determined (step S19-71). If the determination result is “NO”, a comparison determination (step S19-72) of work edit control 846 = “subtotal” is performed next. If the determination result is “NO”, next, a comparison determination of work edit control 846 = “total” is performed (step S19-73). If the result of the determination is “NO”, then a comparison determination of work edit control 846 = “consumption tax” is performed (step S19-74). If the result of determination is “NO”, next, a comparison determination of work edit control 846 = “total” is performed (step S19-75). If the result of the determination is “N”, then a comparison determination of work edit control 846 = “continuation” is performed (step S19-76). If the determination result is “NO”, the product category 409 to the detailed consumption tax 420 → the product category 732 to the detailed consumption tax 743, the amount 419 + the detailed consumption tax 420 → the amount including tax 744, and the summary 421 → the summary 745 are set (step). S19-77). Next, the taxation classification 422 = “taxation” is compared (step S19-78). If the determination result is “YES”, the blank → tax exemption display 746 is set (step S19-79). If “NO” in the comparison determination in step S19-78, “tax free” → tax free display 746 is set (step S19-80). If the work edit control 846 = “space” is “YES” in the comparison determination in step S19-71, blank → item name / standard 733, blank → amount 742, blank → details consumption tax 743, blank → amount tax included 744 (Step S19-81), blank → product category 732, blank → management No. 734 to unit price 741, blank → summary 745, blank → tax exemption display 746 is set (step S19-82). If the work edit control 846 = “subtotal” is “YES” in the comparison determination in step S19-72, “subtotal” → item name / standard 733, subtotal 606 → amount 742, consumption tax subtotal 607 → detailed consumption tax 743, Subtotal 606 + consumption tax subtotal 607 → amount including tax 744 is set (step S19-83), and the process proceeds to step S19-82. If the work editing control 846 = “total” is “YES” in the comparison determination in step S19-73, “total” → product name / standard 733, current month invoice amount 510 → amount 742, current month consumption tax 511 → detailed consumption tax 743 Then, the current billing amount 510 + current month consumption tax 511 → the amount including tax 744 is set (step S19-84). Then, the process moves to step S19-82. If the work edit control 846 = “consumption tax” is “YES” in the comparison determination in step S19-74, “consumption tax” → item name / standard 733, current month consumption tax 511 → amount 742, blank → detailed consumption tax 743 Then, blank → amount including tax 744 is set (step S19-85), and the process proceeds to step S19-82. If the work editing control 846 = “total” is “YES” in the comparison determination of step S19-75, “total” → product name / standard 733, current month invoice amount 510 + current month consumption tax 511 → amount 742, blank → Detailed consumption tax 743, blank → amount including tax 744 is set (step S19-86), and the process proceeds to step S19-82. If the work edit control 846 = “Continue” is YES in the comparison determination in step S19-76, “Continue from previous page” → Product name / standard 733, Blank → Amount 742, Blank → Detailed consumption tax 743, Blank → Amount Tax-included 744 is set (step S19-87), and the process proceeds to step S19-82.

(F) Page No. Edit item Next, work page No. 844 → Page No. 747 is set (step S19-88).

Next, (g) Subtotal items will be edited. Subtotal 748 to total tax 758 will be edited differently depending on whether the consumption tax calculation is the total consumption tax calculation or the detailed consumption tax calculation. Because the editing is different depending on whether it is not the final page or not, the total consumption tax calculation ≠ the final page processing, the total consumption tax calculation the final page processing, the detailed consumption tax calculation ≠ the final page processing, or the final consumption tax calculation The process will be described in four pages.

In the total consumption tax calculation ≠ (g) subtotal item edit work consumption tax calculation category 823 = total consumption tax calculation or comparison judgment is performed (step S19-89), and if the result of determination is “YES” Next, the work page No. 844 ≠ Total page number 514 is compared (step S19-90). If the result of determination is “YES”, then whether or not (work detail line pattern 827 = 2 OR 4 OR 6 OR 8) is compared. It performs (step S19-91). As a result of the determination, if “NO”, blank → subtotal 748 to subtotal tax included 752 is set (step S19-92), and if the comparison determination in step S19-91 is “YES”, subtotal 606 → subtotal 748 , Blank → subtotal column line symbol 749 to subtotal tax included 752 are set (step S19-93).

When the total consumption tax calculation is not ≠ last page (h) editing of the consumption tax display item is not the final page, since there is no display in the consumption tax column (indicated by F in FIG. 31), blank → consumption tax 753 is set (step S19-94).

In the total consumption tax calculation, the comparison determination of (i) total item edit work detail line pattern 827 = 5 on the final page is performed (step S19-95). If the determination result is “NO”, blank → total 754 to total Tax-included 758 is set (step S19-96). If the comparison determination in step S19-95 is “YES”, subtotal 606 → total 754, “======” → total column line symbol 755, “subtotal” → total column title 756, blank → Consumption tax total 757 to total tax included 758 are set (step S19-97).

A record of designated invoice data 7 is output (step S19-98). 845 is added to 845 (step S19-99), and the designated billing data 7 output subroutine is terminated.

In the comparison judgment of (g) subtotal item editing step S19-90 on the last page in the total consumption tax calculation, the work page No. If the total number of pages 514 is NO, a comparison determination of the work detail line pattern 827 = 2 is performed (step S19-100). If the result of determination is “NO”, then (work detail line pattern) 827 = 4 OR
The comparison determination of 8) is performed (step S19-101). If the determination result is “NO”, then the comparison of the work detail line pattern 827 = 6 is performed (step S19-102). If the determination result is “NO”, blank → subtotal 748 to subtotal Tax-included 752 is set (step S19-103). If “YES” in the comparison determination in step S19-100, the current billed amount 510 + current consumption tax 511 → subtotal 748, “======” → subtotal column line symbol 749, “total” → subtotal column title 750, blank → consumption tax subtotal 751 to subtotal tax included 752 are set (step S19-104). In the case of “YES” in the comparison determination in step S19-101, the current month bill 510 → subtotal 748, “======” → subtotal column line symbol 749, “total” → subtotal column title 750, blank → The consumption tax subtotal 751 to the subtotal tax 752 are set (step S19-105). If “YES” in the comparison determination in step S19-102, the setting of subtotal 606 → subtotal 748, blank → subtotal column line symbol 749 to subtotal tax included 752 is performed (step S19-106).

(H) Edit consumption tax display item on the last page in total consumption tax calculation (work line pattern 827 = 4 OR
7 OR 8) is compared (step S19-107). If the determination result is “NO”, blank → consumption tax 753 is set (step S19-108). When the comparison determination in step S19-107 is “YES”, the current month consumption tax 511 → consumption tax 753 is set (step S19-109).

(I) Edit total items on the last page in total consumption tax calculation (work detail line pattern 827 = 5 OR7 OR
8) is compared (step S19-110). If the determination result is “NO”, then the comparison determination of (work detail line pattern 827 = 6) is performed (step S19-111). If the determination is “NO”, blank → total 754 to total tax-included 758 are set (steps S19-112). If “YES” in the comparison determination in step S19-110, the current billed amount 510 + current month consumption tax 511 → total 754, “======” → total column line symbol 755, “total” → total column Title 756, blank → consumption tax total 757 to total tax included 758 are set (steps S19-113). If “YES” in the comparison determination in step S19-111, the current billed amount 510 → total 754, blank → total column line symbol 755 to total tax included 758 are set (step S19-114).

The processing is moved to the designated bill data 7 record output in step S19-98, the processing described above is performed, and the designated bill data 7 output subroutine is terminated.

If the work consumption tax calculation category 823 = total consumption tax calculation is “NO” in the comparison determination processing in (g) subtotal item editing step S19-89 in the detailed consumption tax calculation ≠ last page, the work page No. A comparison determination of 844 ≠ total page number 514 is performed (steps S19 to S115). If the determination result is “YES”, a comparison determination of (work detail line pattern 827 = 2 OR 6) is performed (steps S19-116). When the comparison determination is “NO”, the setting of blank → subtotal 748 to subtotal tax included 752 is performed (steps S19 to 117). When the comparison determination in step S19-116 is “YES”, subtotal 606 → subtotal 748, blank → subtotal column line symbol 749 to subtotal column title 750, consumption tax subtotal 607 → consumption tax subtotal 751, subtotal 606 + consumption tax subtotal 607 → Subtotal tax included 752 is set (steps S19-118).

In the detailed consumption tax calculation ≠ (h) editing of the consumption tax display item on the last page Since there is no item in the consumption tax column in the detailed consumption tax calculation, blank → consumption tax 753 is set (steps S19 to 119).

In the detailed consumption tax calculation ≠ (i) edit work detail line pattern 827 = 5 on the last page In the comparison determination (step S19-120) of “5”, if “NO”, blank → total 754 to total tax included 758 is set (Step S19-121). If “YES” in the comparison determination in step S19-120, subtotal 606 → total 754, “======” → total column line symbol 755, “subtotal” → total column title 756, consumption tax subtotal 607 → Consumption tax total 757, subtotal 606 + consumption tax subtotal 607 → total tax included 758 are set (step S19-122).

Next, the process moves to the designated invoice data 7 record output in step S19-98, the process described above is performed, and the designated invoice data 7 output subroutine is terminated.

In the detailed consumption tax calculation, in the comparison judgment of (g) editing of subtotal items (steps S19-115) on the last page, the work page No. If 844 ≠ total page number 514 is “NO”, a comparison determination of the work detail line pattern 827 = 2 is performed (steps S19-123). If the determination result is “NO”, then the comparison of the work detail line pattern 827 = 6 is performed (steps S19-124). If the determination result is “NO”, blank → subtotal 748 to subtotal tax included 752 Is set (steps S19-125). If “YES” in the comparison determination in step S19-123, the current billed amount 510 → subtotal 748, “======” → subtotal column line symbol 749, “total” → subtotal column title 750, current month consumption Tax 511 → consumption tax subtotal 751, current month invoice amount 510 + current consumption tax 511 → subtotal tax included 752 are set (step S19-126). If “YES” in the comparison determination in step S19-124, subtotal 606 → subtotal 748, blank → subtotal column line symbol 749 to subtotal column title 750, consumption tax subtotal 607 → consumption tax subtotal 751, subtotal 606 + consumption tax subtotal 607 → Subtotal tax included 752 is set (step S19-127).

(H) Edit consumption tax display item on the last page in the detailed consumption tax calculation Since there is no item in the consumption tax column in the detailed consumption tax calculation, blank → consumption tax 753 is set (step S19-128).

In the detailed consumption tax calculation, the final page (i) the total item edit (work detail line pattern 827 = 5 OR 6) is compared (step S19-129). If the result of determination is “NO”, it is blank. → A total of 754 to total tax included 758 is set (step S19-130). If “YES” in the comparison determination in step S19-129, the current month billed amount 510 → total 754, blank → total column line symbol 755 to total column title 756, current month consumption tax 511 → current consumption tax total 757, current month charged amount 510 + current consumption tax 511 → total tax included 758 is set (step S19-131).

Next, the process moves to the designated invoice data 7 record output in step S19-98, the process described above is performed, and the designated invoice data 7 output subroutine is terminated.

From here, the process returns to the main routine of the designated bill data creation 19. Next, the invoice data 4 is read again in the next order in the key order (step S19-15). EOF determination of the invoice data 4 is performed (step S19-16). If the determination result is “NO”, “detail” → work edit control 846 is set (step S19-17), and the specified request already described. The data 7 output subroutine (step S19-18) is processed.

Next, the work page No. The comparison determination of 844 = 1 is performed (step S19-19), and if the determination result is “NO”, then the process shifts to the comparison determination (step S19-20) of the work processing number 843 = work detail print line number 830. . If the determination is “NO”, the process moves to reading one invoice data 4 in (step S19-15). If “YES” in the comparison determination in step S19-19, a comparison determination of work classification 825 = “present” is performed (step S19-21). If the determination result is “NO”, step S19- The process moves to 20. If “YES” in the comparison determination in step S19-21, a comparison determination is made such that the number of work processing cases 843 = the number of work book print lines 829 (step S19-22). If the determination result is “NO”, The process moves to a process for reading one invoice data 4 in step S19-15. In the comparison determination in step S19-20, the number of work processing cases 843 = the number of work detail print lines 830 is “YES”, and in the comparison determination of step S19-22, the number of work processing cases 843 = the number of work inspection print lines 829 is “YES”. In this case, a comparison determination of (work consumption tax calculation category 823 = total consumption tax calculation) is performed (step S19-23). If the determination result is “YES”, a comparison determination of (work detail line pattern 827 = 1 OR 7) is performed (step S19-24). If the determination result is “YES”, “subtotal” → work edit control 846. Is set (step S19-25), and the designated billing data 7 output subroutine (step S19-26) already described is performed. Next, 0 → work processing number 843, work page No. 844 is incremented by 1 (step S19-27). In the comparison determination of step S19-23, if (work consumption tax calculation category 823 = total consumption tax calculation) is “NO”, the comparison determination of the work detail line pattern 827 = 1 is performed (step S19-28). If the determination result is “YES”, the process moves to step S19-25. If the comparison determination (step S19-28) is “NO”, the process moves to (step S19-27).

Add one page SW515 = “Yes” and work page No. 844 = Comparison determination of total number of pages 514 (step S19-29). If “NO”, billing date 501 → billing date 601; sales office code 602 → sales office code 602; customer code 503 → customer code 603, site no. 504 → No. 604, work page no. 844 → Page No. In 605, the on-site subtotal work 6 is searched (step S19-30). Then, the process moves to reading one invoice data 4 in step S19-15. In the comparison judgment in step S19-29, one page addition SW515 = “Yes” and the work page No. 844 = If the total number of pages 514 is “YES”, the process proceeds to the process of reading one invoice data 4 in step S19-15 without performing the process in step S19-30.

If the EOF determination of the invoice data 4 in step S19-16 is “YES”, the process pattern 513 = “I” is compared (step S19-31), and the determination result is “YES”. , (Work processing number 843 <work one page end print line number 828) is compared (step S19-32). If the result of determination is “YES”, “Space” → Work edit control 846 is set (step S19-33), and the designated billing data 7 output subroutine (step S19-34) already described is performed. The process moves to step S19-32, and steps S19-33 and S19-34 are repeated until the comparison determination in step S19-32 becomes “NO”. If the comparison determination in step S19-32 is "NO", the final page record control subroutine is executed (step S19-35), and the process is moved to reading one case total work 5 in step S19-3. To do.

Next, the last page record control subroutine already described will be described. In the last page record control subroutine, the “total line”, “consumption tax line”, and “total line” that are output to the detail line according to the detail line pattern are controlled. First, a comparison determination of (work consumption tax calculation category 823 = total consumption tax calculation) is performed (step S19-132). If the determination result is “YES”, (work detail line pattern 827 = 1 OR 2 OR 5 OR 7) is compared (step S19-133). If “YES” as a result of the determination, “total” → work edit control 846 is set (step S19-134), and the designated billing data 7 output subroutine (step S19-135) already described is performed. Next, a comparison determination of (work detail line pattern 827 = 1 OR 2 OR 5) is performed (steps S19-136). If the determination result is “YES”, “consumption tax” → work edit control 846 is set. (Step S19-137), the processing of the designated billing data 7 output subroutine (step S19-138) already described is performed. Next, a comparison determination of (work detail line pattern 827 = 1) is performed (steps S19-139). If “YES” as a result of the determination, “total” → work edit control 846 is set (step S19-140), and the designated billing data 7 output subroutine (step S19-141) already described is performed. Then, the number of workpieces processed 843 (initial value 0), the workpiece page No. 844 (initial value 1), work output order No. 845 (initial value 1) is initialized (step S19-142), and the final page record control subroutine is terminated. If the comparison determination at step S19-133 is “NO”, the process moves to step S19-136. If “NO” in the comparison determination in steps S19 to 136, the process proceeds to steps S19 to 139. If "NO" in the next step S19-139, the step S19-142 already described is processed, and the final page record control subroutine is terminated.

When the work consumption tax calculation category 823 = total consumption tax calculation is “NO” in the comparison determination of step S19-132 (detailed consumption tax calculation), the comparison determination of (work detail line pattern 827 = 1) (step S19— 143). If “YES” as a result of the determination, “total” → work edit control 846 is set (steps S19-144), and the designated billing data 7 output subroutine already described is performed (steps S19-145). The described step S19-142 is processed to end the final page record control subroutine. If “NO” in the comparison determination in steps S19-143, the previously described steps S19-142 are processed, and the final page record control subroutine is terminated.

Then, the process returns to the main routine of designated bill data creation 19 again. If the processing pattern 513 = “I” is “NO” in the comparison determination in step S19-31, a comparison determination (step S19-36) of 1 page addition SW515 = “none” is performed. If “YES”, (work A comparison determination (step S19-37) of the processing number 843 <work final print line number 831) is performed. If “YES”, “space” → work edit control 846 is set (step S19-38), and already. The designated billing data 7 output subroutine (step S19-39) explained is performed. Also, the process moves to step S19-37, and steps S19-38 and S19-39 are repeated until the comparison determination in step S19-37 becomes “NO”. When the comparison determination in step S19-37 is “NO”, the comparison determination of (work consumption tax calculation category 823 = total consumption tax calculation) is performed (step S19-40), and the determination result “YES” ”(Work detail line pattern 827 = 1 OR 2 OR 4 OR 5 OR 7 OR
8) The determination of (Step S19-41) is performed. If “YES” as a result of the determination, “subtotal” → work edit control 846 is set (step S 19-42), and the designated billing data 7 output subroutine (step S 19-43) already described is performed. And the process of the last page record control subroutine (step S19-44) already demonstrated is performed, and a process is moved to 1 case reading of the field total work 5 of step S19-3. If the work consumption tax calculation category 823 = total consumption tax calculation is “NO” in the comparison determination in step S19-40, a comparison determination (S19-45) of (work detail line pattern 827 = 1 OR 2 OR 5) is performed. If the result of determination is “YES”, the process moves to step S19-42. If the comparison determination in step S19-45 is “NO”, the process moves to step S19-44. If the determination in step S19-41 is “NO”, the process moves to step S19-44.

In the comparison determination of step S19-36, when 1 page addition SW515 = “none” is “NO”, the comparison determination of (work page No. 844 = total number of pages 514) is performed (step S19-46). If “NO” as a result of the determination, a comparison determination of (work processing number 843 <work detail print line number 830) is performed (step S19-47). If “YES” as a result of the determination, “space” → work edit control 846 is set (step S 19-48), and the designated billing data 7 output subroutine (step S 19-49) already described is performed. The process moves to step S19-47, and steps S19-48 and S19-49 are repeated until the comparison determination in step S19-47 becomes “NO”. When the comparison determination in step S19-47 is “NO”, (work consumption tax calculation category 823 = comparison determination of total consumption tax calculation) (step S19-50) is performed. If “YES” as a result of the determination, a comparison determination (step S19-51) of (work detail line pattern 827 = 1 OR 7) is performed. As a result, in the case of “YES”, “subtotal” → work edit control 846 is set (step S19-52), and the designated billing data 7 output subroutine (step S19-53) already described is performed. Next, the work page No. 844 is incremented by 1 (step S19-54). In the comparison determination of step S19-50, if (work consumption tax calculation category 823 = total consumption tax calculation) is “NO”, the comparison determination of the work detail line pattern 827 = 1 is performed (step S19-55). If the result of determination is “YES”, the process moves to step S19-52. If the comparison determination in step S19-55 is “NO”, the process moves to step S19-54. If the comparison determination in step S19-51 is “NO”, the process moves to step S19-54. In the comparison judgment in step S19-46, the work page No. 844 = If the total number of pages 514 is “YES”, the process moves to step S19-56 described in the next section.

Next, 0 → work processing number 843 is set (step S19-56), “continue” → work edit control 846 is set (step S19-57), and the designated billing data 7 output subroutine (step S19) already described. -58) is performed. (Work processing number 843 <Work added 1 page print line number 832) is compared (step S19-59). If the result of determination is “YES”, “Space” → Work editing control 846 is set ( Step S19-60). Then, the process of the designated billing data 7 output subroutine (step S19-61) already described is performed, and the process moves to step S19-59. Steps S19-60 and S19-61 are repeated until the comparison determination in step S19-59 becomes “NO”. If the comparison determination in step S19-59 is “NO”, the process of the last page record control subroutine (step S19-62) already described is performed, and one field total work 5 in step S19-3 is processed. Move processing to read.

In step S19-4, if the EOF determination of the on-site total work 5 is “YES”, the designated bill data creation 19 process is terminated.

As described above, according to the present embodiment, the following effects can be obtained. First, it becomes possible to easily and quickly respond to a specified invoice that is different for each customer, thereby making it possible to rationalize paperwork.
For example, once a customer's pattern item is set, anyone can easily create designated invoice data, which dramatically improves work efficiency and saves paperwork.
Moreover, it can be used not only for invoices but also for quotations, delivery notes, etc., and can be widely used not only in the construction machine leasing / rental industry but also in other industries.
In addition, since it is configured to store multiple types of invoice patterns divided based on the consumption tax calculation pattern, detail line pattern, and processing pattern, a plurality of consumption tax calculation patterns, detail line patterns, and processing patterns differ. It is possible to effectively respond to the type of designated invoice.
In addition, since it is configured to be divided into two patterns by total consumption tax calculation or detailed consumption tax calculation, it effectively responds to both the total consumption tax calculation and the detailed consumption tax calculation be able to.
In addition, since it is configured to be classified according to the presence / absence of the subtotal column category, the presence / absence of the consumption tax column category, and the presence / absence of the total column category, the above detailed line pattern has the presence / absence of the subtotal column category and the presence / absence of the consumption tax column category. It is possible to effectively cope with any of the cases where the total column division is present.
In addition, since it is configured to be divided into two patterns depending on whether the number of specifications ends on one page or covers a plurality of pages, the above processing pattern is either one where the number of specifications ends on one page or covers a plurality of pages. It is possible to effectively cope with the case.

The present invention is not limited to the one embodiment.
For example, the present invention is applicable not only to the construction machine leasing / rental industry but also to the creation of bills for other industries.
Further, the items in the invoice are not limited.
In the above-described embodiment, the creation of an invoice has been described as an example. However, the present invention can be similarly applied to the creation of an estimate and an invoice.
Further, the classification factor for patterning the invoice, the estimate, and the delivery note is not particularly limited.

The present invention relates to an invoice (or estimate or invoice) creation system, and more particularly, an arbitrary invoice (or estimate) from a plurality of pre-patterned invoice (or estimate or invoice) patterns. (Invoice or delivery note) patterns that are automatically selected to create a desired invoice (or estimate or delivery note) automatically. It is suitable for making an invoice (or estimate or delivery note).

FIGS. 1A to 1G are views showing an item list of a master file, a work file, and a data file. It is a figure which shows one embodiment of this invention, and is a figure which shows the item list of a memory work. It is a figure which shows one embodiment of this invention, and is a figure which shows the table | surface which patterned the total consumption tax calculation process. It is a figure which shows one embodiment of this invention, and is a figure which shows the table | surface which patterned the detailed consumption tax calculation process. FIG. 5 is a diagram illustrating an embodiment of the present invention, and FIGS. 5A to 5D are functional block diagrams illustrating a configuration of a control device. It is a figure which shows one embodiment of this invention, and is a functional block diagram which shows the structure of a control apparatus. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure which shows one embodiment of this invention, and is a flowchart which shows the procedure of preparation of master maintenance and bill data. It is a figure used for description of a prior art example and description of one embodiment of this invention, and is a figure which shows an example of the designation | designated invoice form of total consumption tax calculation. It is the figure used for description of a prior art example and description of one embodiment of this invention, and is a figure which shows an example of the designation | designated invoice form of detailed consumption tax calculation.

Explanation of symbols

A ... Invoice book sheet B ... Invoice sheet sheet C ... Details sheet line D ... Details sheet line E ... Subtotal field F ... Consumption tax field G ... Total field 101-120 ... Items 201-213 of the company information master 1 ... items 301 to 309 of customer master 2 ... items 401 to 422 of site master 3 ... items 501 to 515 of invoice data 4 ... items 601 to 607 of site total work 5 ... items 701 to 758 of site subtotal work 6 ... designation Invoice data 7 items 801 to 846 ... Memory work 8 item 5-A ... Total consumption tax calculation details pattern 5-B ... Total consumption tax calculation processing pattern 5-C ... Total consumption tax calculation details can be output Number of lines 5-D ... Contents to be output to item name / standard item for total consumption tax calculation 5-E ... Total item to be output to detailed line for total consumption tax calculation 5-F ... Total column / total title for total consumption tax calculation What to output in the column -A ... Detail consumption tax calculation detail line pattern 6-B ... Detail consumption tax calculation processing pattern 6-C ... Detail consumption tax calculation detail output number of lines 6-D ... Detailed consumption tax calculation product name / standard item Content to be output 6-E: Total item 6-F to be output to the detailed line of the detailed consumption tax calculation ... Content 1 to be output to the total column / total title column of the detailed consumption tax calculation 1 ... Company information master 2 ... Customer master 3 ... Site master 4 ... Bill data 5 ... Site total work 6 ... Site subtotal work 7 ... Designated bill data 8 ... Memory work 9 ... Keyboard 10 ... Display 11 ... Floppy 12 ... Network 13 ... In-house information master maintenance 14 ... Customer master maintenance 15 ... Site master maintenance 16 ... Invoice data creation 17 ... Site total work 5 creation 18 ... Site subtotal work 6 creation 19 ... Designated invoice data 7 creation

Claims (2)

Consumption tax calculation classification indicating whether it is total consumption tax calculation or detailed consumption tax calculation, identification classification indicating presence / absence of invoice book paper, number of identification lines, number of specification lines, subtotal column classification indicating presence / absence of subtotal column classification A customer master that stores in advance a consumption tax column that indicates the presence or absence of the consumption tax column, a total column that indicates the presence or absence of the total column for each customer,
Consumption tax calculation to determine whether the consumption tax calculation pattern is the total consumption tax calculation or the detailed consumption tax calculation by taking out the information of the consumption tax calculation category corresponding to the customer from the customer master based on the input customer information Pattern discrimination means;
Based on the entered customer information, subtotal column information, consumption tax column information, and total column information corresponding to the customer are extracted from the above customer master, and subtotal column presence and consumption tax column classification Detailed line pattern setting means for setting a preset value in the memory work by a combination of the presence / absence and the presence / absence of the total column classification,
Discrimination by the consumption tax calculation pattern discriminating means by taking out information on the classification category corresponding to the customer, information on the number of details lines and information on the number of details lines from the customer master based on the inputted customer information Print line number setting means for calculating the number of lines that can be output in detail in consideration of the result and the set value by the above detailed line pattern setting means, and setting the work one page end print line number in the memory work;
A processing pattern discriminating means for comparing the number of printed lines per workpiece and the number of work details set by the print line number setting means and discriminating whether the total number of pages ends in one page or covers a plurality of pages with respect to the processing pattern; ,
The invoice (or estimate) is based on the discrimination result by the consumption tax calculation pattern discrimination means, the set value by the detailed line pattern setting means, the number of printed lines at the end of one page of the work by the print line number setting means, and the discrimination result by the processing pattern discrimination means. Invoice (or invoice or invoice) data creation means for creating data,
An invoice (or estimate or invoice) creation system characterized by comprising: In the invoice (or estimate or invoice) creation system according to claim 1,
The print line number setting means sets not only the work one page end print line number but also the work book print line number, the work detail print line number, the work final print line number, and the work additional one page print line number in the memory work. An invoice (or estimate or invoice) creation system characterized by

Images