JP2019101874A - Data creation device, data creation method, and data creation program - Google Patents

Abstract

Kind Code: A1 A data creation device, data creation method and data creation method capable of creating estimate data or billing data including a balance amount obtained by subtracting the purchase amount of a product purchased from the business partner from the sales amount of the product sold to the business partner. The challenge is to provide a data creation program. In this embodiment, (1) from sales data and purchase data, a sales tax amount and purchase tax amount associated with the same customer code are acquired, and (2) from the acquired sales tax amount, A balance amount is calculated by subtracting the purchase tax-included amount obtained above, and estimate data or billing data including the calculated balance amount is created. [Selection drawing] Fig. 4

Description

  The present invention relates to a data creation device, a data creation method, and a data creation program.

  Patent Document 1 discloses a sales support system and a sales support method that allow a customer to easily make a trade-in request together with a purchase request for a new product and estimate of the trade-in amount (see paragraph 0005 of Patent Document 1). .

Unexamined-Japanese-Patent No. 2002-203145

  As described above, in the field of managing the amount of trade, for example, when selling machines, purchasing may be performed using old machines of customers as the trade-in machines. In this case, it is conventionally possible to automatically create estimated data and billing data including the amount of sales minus the purchase amount (reduction) simultaneously with the sales of machinery and simultaneous acquisition and purchase of the machine. It was not.

  The present invention has been made in view of the above problems, and is estimated data including a deduction amount which is an amount obtained by subtracting the purchase amount of the product purchased from the customer from the sales amount of the product sold to the customer. Or, it is an object of the present invention to provide a data creation device, data creation method and data creation program capable of creating billing data.

  In order to solve the problems described above and achieve the object, a data creation device according to the present invention is a data creation device including a control unit and a storage unit, and the storage unit is used to identify a customer. Sales data including customer identification data and sales amount of goods sold or sold to the business partners; purchase data including customer identification data and purchase amounts of goods purchased or purchased from the business partners; Is stored, and the control unit acquires from the sales data and the purchase data by the amount acquisition means for acquiring the sales amount and purchase amount associated with the same customer identification data, and the amount acquisition means Calculate the deduction amount by deducting the purchase amount acquired by the amount acquisition means from the sales amount calculated, and create estimate data or billing data including the calculated deduction amount That the data creating means, comprise a, wherein.

  Further, in the data creation device according to the present invention, the control unit creates a sales journal including the sales amount acquired by the amount acquisition unit and a purchase journal including the purchase amount acquired by the amount acquisition unit. The method further comprises journalizing means.

  Further, in the data creation device according to the present invention, the purchase data further includes a clearing uncompleted category indicating that clearing of the purchase price is not completed, and the control unit is configured to A purchase data acquisition unit for acquiring purchase data including the uncleared category from the storage unit in response to the instruction; and a purchase price in the purchase data acquired by the purchase data acquisition unit; Deposit data creation means for creating deposit data including deposit amount input on the deposit input screen, purchase amount and deposit amount in the deposit data created by the deposit data creation means, and the above acquired by the amount acquisition means And offsetting journaling means for creating offsetting journals for the journal entries created by the journalizing means, including sales amounts.

  Further, in the data creation device according to the present invention, the product is a machine, and the purchased or purchased product is purchased or sold under the condition that the sales partner purchases the sold or sold commodity. It is characterized by certain things.

  The data creation method according to the present invention is a data creation method executed by an information processing apparatus including a control unit and a storage unit, and the storage unit includes supplier identification data for identifying a supplier. Stores sales data including sales amount of goods sold to the customer or sold goods, and purchase data including customer identification data and purchase amount of goods purchased or purchased from the customer. An amount acquiring step of acquiring a sales amount and a purchase amount associated with the same customer identification data from the sales data and the purchase data, which is executed by the control unit; and the amount acquired in the amount acquisition step A deduction amount is calculated by subtracting the purchase amount acquired in the amount acquisition step from the sales amount, and estimate data or billing data including the calculated deduction amount And a data generation step of generating, include, characterized by.

  Further, a data creation program according to the present invention is a data creation program to be executed by an information processing apparatus including a control unit and a storage unit, and the storage unit includes supplier identification data for identifying a supplier. And sales data including sales amounts of products sold to or sold to the business partners, and purchase data including business partner identification data and purchase amounts of products purchased or purchased from the business partners. From the sales data and the purchase data for performing the control unit, an amount acquisition step of acquiring a sales amount and a purchase amount associated with the same customer identification data, and acquired in the amount acquisition step The deduction amount is calculated by deducting the purchase amount acquired in the amount acquisition step from the sales amount calculated, and the deduction amount is included. A data creation step of creating a product data or billing data, include, characterized by.

  According to the present invention, it is possible to create estimate data or billing data that includes a deduction amount that is the amount obtained by subtracting the purchase price of the product purchased from the customer from the sales price of the product sold to the customer.

FIG. 1 is a block diagram showing an example of the configuration of a data creation apparatus. FIG. 2 is a diagram showing an example of a data configuration in sales estimate data and purchase estimate data and an example of an estimate. FIG. 3 is a view showing an example of the data configuration of order receipt data and order receipt data. FIG. 4 is a diagram showing an example of the data configuration of sales data, purchase data and billing data, and an example of invoices and journals. FIG. 5 is a diagram showing an example of how to search for purchase data from the deposit input screen. FIG. 6 is a view showing an example of the data configuration of the receipt data, the updated purchase data, and the next month billing data, and an example of the next month journal and the next month bill.

  Hereinafter, embodiments of a data creation device, a data creation method, and a data creation program according to the present invention will be described in detail based on the drawings. The present invention is not limited by the present embodiment.

[1. Overview]
When selling machines, there are cases where purchasing is performed using the old machine of the customer (customer) as a trade-in machine, but simultaneous sales and purchases are made simultaneously with machine sales, and the sales amount (for example, 3.24 million yen In the past, it was not possible to print the difference (2.16 million yen), which is the amount obtained by reducing the amount of trade-in (for example, 1.80 million yen), from the estimate) on the estimate and invoice. Therefore, in the present embodiment, for example, it is possible to print the difference (2.16 million yen) on a quote or a bill. The trade-in machine is not a sales discount but a purchase, so in the conventional sales management, the difference (2.16 million yen) was not printed on the estimate and the bill.

  In addition, at the time of payment, the difference is paid with respect to the sales amount. For this reason, it is necessary to offset the sales amount (3.24 million yen) with the difference (2.16 million yen) and the accounts payable (1.08 million yen) generated by the trade-in and purchase. It is necessary to do collation. Therefore, in the present embodiment, for example, it is possible to retrieve the accounts payable generated by the above-mentioned trade-in and purchase by search and make the above-mentioned offset.

  As described above, in the present embodiment, for example, it is possible to smoothly carry out a series of transactions in which a trade-in machine associated with machine sales is present, while keeping in mind the accounting-linked journal. The specific configuration and operation will be described below.

[2. Constitution]
An example of the configuration of the data creation 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 data creation apparatus 100. As shown in FIG.

  The data creation device 100 is a commercially available desktop personal computer. The data creating apparatus 100 is not limited to a stationary information processing apparatus such as a desktop personal computer, but may be a portable personal computer such as a commercially available notebook personal computer, PDA (Personal Digital Assistants), a smartphone, a tablet personal computer, etc. It may be an information processing apparatus.

  The data creation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the data creation device 100 are communicably connected via any communication path.

  The communication interface unit 104 communicably connects the data creation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of communicably connecting the data creation device 100 and the server 200, and is, for example, the Internet, a local area network (LAN), or the like. Note that data of various masters and the like 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. For the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. The input device 112 can be a keyboard, a mouse, a microphone, and a monitor that implements a pointing device function in cooperation with the mouse. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving instructions to a central processing unit (CPU) in cooperation with an operating system (OS) to perform various processes. As the storage unit 106, for example, a memory device such as a random access memory (RAM) or a read only memory (ROM), a fixed disk device such as a hard disk, a flexible disk, an optical disk or the like can be used.

  For example, the storage unit 106 includes sales estimate data 106a, purchase estimate data 106b, estimate data 106c, order receipt data 106d, order data 106e, sales data 106f, purchase data 106g, and billing data 106h. , Deposit data 106i.

  Here, each term is defined. The “sales amount” in the claims of this application is a concept that includes both the estimated sales amount of the product sold to the customer and the sales amount of the product sold to the customer. The “sales data” in the claims of this application is a concept that includes both the sales estimate data 106 a and the sales data 106 f. The “purchase amount” in the claims of this application is a concept that includes both the planned purchase amount of the product purchased from the customer and the purchase price of the product purchased from the customer. “Purchase data” in the present claim is a concept including both purchase quotation data 106 b and purchase data 106 g. The "subtract amount" in the claims of this application is a concept that includes both a deduction amount which is an amount obtained by subtracting a planned purchase amount from a planned sales amount and a deduction amount which is an amount obtained by subtracting the purchase amount from the sales amount. .

  In the present embodiment, the goods are preferably machines. Preferably, the purchased product or the purchased product is a purchased product (so-called trade-in product) on the condition that the customer purchases the sold product or the sold product.

  The outline of each data will be described below. For the data configuration example of each data, see [3. Specific Example of Processing] will be described in detail.

  The sales estimate data 106 a is data for managing an estimated sales amount and the like of products sold to customers. The purchase quotation data 106 b is data for managing a planned purchase price of a product purchased from a business partner.

  The estimate data 106c is created from the sales estimate data 106a and the purchase estimate data 106b, and is the data that is the source of the preparation of the estimate.

  The order receipt data 106 d is data for managing the order receipt amount and the like of the product ordered from the supplier. The order data 106 e is data for managing the order amount and the like of the product ordered to the customer.

  The sales data 106 f is data for managing the sales amount and the like of products sold to customers. The purchase data 106g is data for managing the purchase price and the like of the product purchased from the customer.

  The billing data 106 h is data that is created from the sales data 106 f and the purchase data 106 g and is the source of billing.

  The deposit data 106i is data for managing a deposit amount from a business partner.

  The control unit 102 is a CPU or the like that controls the data creation apparatus 100 in an integrated manner. The control unit 102 has an internal memory for storing control programs such as the OS, programs defining various processing procedures, required data, etc., and performs various information processing based on the stored programs. Run.

  The control unit 102 functionally acquires, for example, (1) the amount of money acquired as an amount acquisition unit that acquires a sales amount and a purchase amount associated with the same customer identification data from the sales data and the purchase data. (2) Calculate the deduction amount by deducting the purchase amount acquired by the amount acquisition means from the sales amount acquired by the amount acquisition means; estimate data or billing including the calculated deduction amount A data creation unit 102b as a data creation unit that creates data, and (3) a quote creation unit 102c as a quote creation unit that creates a quote based on the quote data created by the data creation unit, 4) a bill creation unit 102d as bill creation means for creating a bill based on the billing data created by the data creation means, and (5) the amount of money From a sales journal entry including the sales amount acquired by acquisition means and a journal entry creation unit 102e as a journal entry preparation means for creating a purchase journal entry including the purchase amount acquired by the amount acquisition means; (6) From a deposit input screen A purchase data acquisition unit 102f as purchase data acquisition means for acquiring purchase data including the incomplete clearing category from the storage unit in response to the instruction of (7) by the purchase data acquisition means Deposit data creation unit 102g as deposit data creation means for creating deposit data including the purchase price in the obtained purchase data and the deposit amount input on the deposit input screen; (8) the deposit data creation means The purchase amount and deposit amount in the received payment data and the sales amount acquired by the amount acquisition unit And canceling journal creation unit 102h as offset journal creating means for creating offset journal that has a. In addition, about the detail of the process which each part performs, below [3. Specific Example of Processing].

[3. Specific example of processing]
Hereinafter, specific examples of the process according to the present embodiment will be described in detail with reference to FIGS. In this item, machine A of 3 million yen (tax included 3.24 million yen) was sold on June 28, 2017 to T which is a business partner, and 1 million on June 28, 2017 from T company An example is also described in which the foreign exchange machine B is purchased by the yen (tax included: 1,080,000 yen) and recorded, and there is a payment of 2,216,000 yen, which is the difference, from T company on July 20, 2017. In the following, the example will be described in the order of estimate input, order input, etc., sales input etc. and deposit input.

[3-1. Quote input]
The estimate input will be described in detail with reference to FIG.

  First, sales estimate data 106a shown in FIG. 2 is created for the machine A sold to the T company.

  As shown in FIG. 2, the sales estimate data 106a includes, for example, an estimate number (MIT 0100 0001), an estimate row number (1), customer identification data for identifying a customer (customer code: T000000001 and customer name: T company), estimated sales date (2017/06/28), estimate division (01: machine estimate), product identification data (product code: T000000001 and product name: machine A), product quantity (1) And unit code (01: unit), an estimated sales price of the product sold to the customer (3 million yen), an estimated sales amount of the product sold to the customer (3 million yen), and the like.

  Further, for the machine B purchased from the company T, purchase quotation data 106b shown in FIG. 2 is created.

  As shown in FIG. 2, the purchase quotation data 106b includes, for example, a quotation number (MIT 0100 0001), a quotation row number (2), supplier identification data (customer code: T000000001 and customer name: T company), purchasing Expected date (2017/06/28), Quotation classification (02: Trade-in quotation), Product identification data (Product code: S000000002 and Product name: Machine B), Product quantity (1), Unit code (01: Unit), Vendor identification data (vendor code: T000000001 and vendor name: T company) for identifying a vendor, scheduled purchase price (1 million yen) of goods purchased from the supplier, and the supplier Includes the planned purchase price (one million yen) of the products purchased from.

  Then, based on the sales estimate data 106a and the purchase estimate data 106b, (amount acquisition processing), (data creation processing) and (estimate creation processing) are executed as described below.

(Amount acquisition process)
The amount acquiring unit 102a acquires, from the sales estimate data 106a and the purchase estimate data 106b, a planned sales amount and a planned purchase amount associated with the same customer identification data (customer code).

  Specifically, it is assumed that "T000000001" is specified as the customer code by the operator. Referring to the sales estimate data 106 a of FIG. 2, since the estimated sales amount associated with “T000000001” is 3 million yen, the amount acquiring unit 102 a acquires 3 million yen as the estimated sales amount. On the other hand, referring to the purchase quotation data 106b in FIG. 2, the planned purchase price associated with "T000000001" is 1,000,000 yen, so the money acquisition unit 102a acquires 1,000,000 yen as the planned purchase price. Do.

(Data creation process)
The data preparation unit 102b calculates a deduction amount by deducting the planned purchase amount acquired by the amount acquisition unit 102a from the estimated sales amount acquired by the amount acquisition unit 102a, and estimates data 106c including the calculated estimated amount of deduction. Create

  Specifically, if 1 million yen, which is the planned purchase price acquired by the money acquisition unit 102a, is subtracted from the planned sales amount of 3 million yen acquired by the money acquisition unit 102a, 3,000,000-1,000,000 yen = 200 Although it is 10,000 yen, in consideration of the consumption tax, the data creating unit 102b calculates the deduction amount as 3.24 million yen to 1.80 million yen = 2.16 million yen. Then, the data creation unit 102b creates estimated data 106c including the estimated amount of 2.16 million yen.

  The estimate data 106c is not shown, but for example, the purchase price (3 million yen), the consumption tax on the purchase price (240,000 yen), the current estimate (32.4 million yen), the trade-off amount (1 million yen), Includes consumption tax (80,000 yen) and estimated deduction (2,160,000 yen) for the amount of proceeds.

(Estimate creation process)
The estimate creation unit 102c creates an estimate as shown in (B) of FIG. 2 based on the estimate data 106c created by the data creation unit 102b. In the estimate book in Fig. 2 (B), the purchase price (3 million yen), the consumption tax on the purchase price (240,000 yen), the estimated amount (2.42 million yen), and the trade-off amount (1 million yen) And the consumption tax (80,000 yen) and the deducted estimated amount (2,160,000 yen) for the trade-in amount are information based on the estimated data 106c.

  The estimate creation unit 102c may include the information included in the sales estimate data 106a and the purchase estimate data 106b in the estimate as shown in (B) of FIG. In the estimate book of (B) in Fig. 2, sales classification (sales), product name (machine A), quantity (1), unit (unit), unit price (3 million yen) and amount (3 million yen) It is information based on the estimate data 106a. On the other hand, in the written estimate in FIG. 2B, sales classification (trade-in), product name (machine B), quantity (1), unit (unit), unit price (-1 million yen) and amount (-100) 10,000 yen is information based on the purchase quotation data 106b.

  As shown in the estimate in FIG. 2B described above, if there is a trade-in estimate, the purchase price (-1 million yen) and the purchase price (-1 million yen) are printed as negative. In the total column, the total amount of trade-in amount (1 million yen) and the estimated amount of deduction (2.16 million yen) are printed.

  As a reference, an estimate when there is no trade-in estimate is shown in FIG. 2 (A). As shown in the written estimate of (A) of FIG. 2, when there is no trade-in estimate, the total amount of trade-in amount (1 million yen) and the estimated amount of deduction (2.16 million yen) are not printed.

[3-2. Order entry etc.]
The order entry and the order entry will be described in detail with reference to FIG.

  When the order and order are confirmed, the “estimate category” in the sales estimate data 106a and the purchase estimate data 106b is determined, and the order data 106d and the order data 106e are separately called. That is, the order receipt data 106d is created based on the sales estimate data 106a having the estimate category "01: machine estimate", while it is based on the purchase estimate data 106b having the estimate category "02: trade-in estimate". Order data 106e is created.

  As shown in FIG. 3, the order data 106d includes, for example, order number (JUC01000002), order line number (1), estimate number (MIT01000001), estimate line number (1), customer identification data (customer code: T000000001). And customer name: T company), scheduled sales date (2017/06/28), order classification (1: machine order), product identification data (product code: T000000001 and product name: machine A), product quantity (1) , Unit code (01: unit), the planned sales price of the product sold to the customer (3 million yen), the expected sales amount for the product sold to the customer (3 million yen), and the product sold to the customer Includes sales forecast including tax (¥ 3.24 million).

  As shown in FIG. 3, the order data 106e includes, for example, order number (HAC01000003), order line number (1), estimate number (MIT01000001), estimate line number (2), vendor identification data (vendor code). : T 00000 0001 and supplier name: T company, scheduled purchase date (2017/06/28), order classification (2: trade-in order), product identification data (product code: S000000002 and product name: B product (machine B) Synonymous with B), quantity of goods (1), unit code (01: unit), planned purchase price of goods purchased from the customer (1 million yen), estimated amount of tax excluded from goods purchased from the customer (1 million yen) and the planned purchase tax amount of goods purchased from the business partners (1,080,000 yen), etc. are included.

[3-3. Sales entry etc]
Sales input and purchase input will be described in detail with reference to FIG.

  When the sales and purchase are confirmed, sales data 106f is created based on the order data 106d, while purchase data 106g is created based on the order data 106e.

  As shown in FIG. 4, the sales data 106f includes, for example, sales number (URI01000004), sales line number (1), order number (JUC01000002), order line number (1), customer identification data (customer code: T000000001). And customer name: T company), sales date (2017/06/28), sales division (01: machine sales), product identification data (product code: T000000001 and product name: machine A), product quantity (1), Unit code (01: unit), unit price of goods sold to the customer (3 million yen), sales tax excluded goods sold to the customer (3 million yen), and goods sold to the customer Includes sales tax included (3,240,000 yen), etc.

  As shown in FIG. 4, for example, the purchase data 106g includes a purchase number (SIR01000005), a purchaser number (1), an order number (HAC01000003), an order line number (1), and vendor identification data (purchase). Destination code: T000000001 and vendor name: T company, purchase date (2017/06/28), purchase category (02: trade-in purchase), product identification data (product code: S000000002 and product name: B Product (synonym with machine B), product quantity (1), unit code (01: unit), purchase unit price of the product purchased from the customer (1 million yen), purchase of the product purchased from the customer The tax exclusion amount (1 million yen), the purchase tax amount (1,080,000 yen) of the goods purchased from the business partners, the cleared payment amount (0 yen) and the purchase tax amount have not been cleared Inclusion of the uncompleted category (0: Uncleared) etc.

  Then, based on the sales data 106f and the purchase data 106g, (amount acquisition processing), (data creation processing), (bill creation processing) and (journalization creation processing) are executed as described below. .

(Amount acquisition process)
The amount acquisition unit 102a acquires, from the sales data 106f and the purchase data 106g, the sales amount and the purchase amount associated with the same customer identification data (customer code).

  Specifically, it is assumed that "T000000001" is specified as the customer code by the operator. Referring to the sales data 106f of FIG. 4, the sales tax amount associated with "T000000001" is 3.24 million yen, so the amount acquisition unit 102a acquires 3.24 million yen as the sales amount. On the other hand, referring to the purchase data 106g in FIG. 2, the purchase tax amount associated with "T000000001" is 1,080,000 yen, so the amount acquisition unit 102a acquires 1,080,000 yen as the purchase amount.

(Data creation process)
The data preparation unit 102b calculates the deduction request amount by subtracting the purchase amount acquired by the amount acquisition unit 102a from the sales amount acquired by the amount acquisition unit 102a, and prepares the invoice data 106h including the calculated deduction amount Do.

  Specifically, the data preparation unit 102 b subtracts the amount of claim for deduction 324 by subtracting the purchase amount of 1.08 million yen acquired by the amount acquisition unit 102 a from the amount of sales of 3.24 million yen acquired by the amount acquisition unit 102 a. Calculated as 10,000 yen-1,080,000 yen = 2,160,000 yen. Then, the data creation unit 102b creates the invoice data 106h including the required amount for the deduction of 2.16 million yen.

  The billing data 106h may be, for example, customer identification data (customer code: T000000001 and customer name: T company), billing closing date (2017/2017), as shown on the right side of the quotation shown in FIG. 06/30), Last billed amount (0 yen), amount paid (0 yen), amount carried forward (0 yen), purchased amount (3 million yen), consumption tax for purchased amount (240,000 yen), this time Amount billed (2.42 million yen), last trade-off offset unpaid amount (0 yen), trade-off amount (0 yen), trade-off offset carry forward (0 yen), trade-in amount (1 million yen), down This includes consumption tax (80,000 yen) for the amount to be paid, unpaid amount of the current trade-off offset amount (1,080,000 yen), and request amount for the business transaction (2,160,000 yen).

(Invoice creation process)
The bill creation unit 102d creates a bill as shown in (B) of FIG. 4 based on the billing data 106h created by the data creation unit 102b. In the bill shown in FIG. 4B, the previous billed amount (0 yen), the amount paid (0 yen), the amount carried forward (0 yen), the purchase amount (3 million yen), and the consumption amount for the purchase amount Tax (240,000 yen), current billed amount (3,240,000 yen), trade-in amount (1 million yen), consumption tax (80,000 yen) on trade-in amount, and deduction request amount (2.16 million yen) Information based on

  The invoice creation unit 102d may include the information included in the sales data 106f and the purchase data 106g in the invoice as illustrated in (B) of FIG. 4. In the invoice in (B) of Fig. 4, sales category (sales), product name (machine A), quantity (1), unit (unit), unit price (3 million yen) and amount (3 million yen) are sales. It is information based on the data 106f. On the other hand, in the bill shown in FIG. 4B, sales classification (trade-in), product name (machine B), quantity (1), unit (unit), unit price (-1 million yen) and amount (-100) 10,000 yen is information based on the purchase data 106g.

  As shown in the invoice in FIG. 4B described above, if there is a trade-in purchase, the purchase price (-1 million yen) and the purchase price (-1 million yen) are printed as negative. In the total column, the total amount of trade-in amount (1 million yen) and the deduction amount (2.16 million yen) are printed.

  As a reference, an estimate when there is no trade-in estimate is shown in FIG. 4 (A). As shown in the quotation of FIG. 4A, if there is no trade-in quotation, the total amount of trade-in amount (1 million yen) and the amount of claim for deduction (2.16 million yen) are not printed.

(Journaling process)
The journal creation unit 102e creates a sales journal including the sales amount acquired by the amount acquisition unit 102a and a purchase journal including the purchase amount acquired by the amount acquisition unit 102a.

  Concretely, it demonstrates using the journal of June shown in FIG. As shown in the upper row of <Registration> in FIG. 4, the journalizing section 102 e describes, as a debit, accounts receivable of ¥ 32.4 million as sales tax and a credit of ¥ 3 million as sales tax withdrawal amount and Create a sales journal entry containing the sales tax of 240,000 yen. On the other hand, as shown in the line under <Journal entry> in FIG. 4, the journal entry preparation unit 102e describes 1 million yen, which is the purchase tax withdrawal amount, and 80,000 yen, which is the consumption tax, as the debit. Create a purchase journal entry with accounts payable of 1.08 million yen, including the amount of tax included.

[3-4. Payment input]
The deposit input will be described in detail with reference to FIGS. 5 and 6.

  This item [3. As explained at the beginning of the processing example], on July 20, 2017 from T Company, the difference (2.26 million yen) after subtracting the purchase tax amount (1.08 million yen) from the sales tax amount (3.24 million yen) In order to receive the payment), it is necessary to create an offsetting journal entry (shown in FIG. 6) for the June journal entry (shown in FIG. 4) created in the above [3-3] as a July journal entry.

  Here, at the time of preparation of the offsetting journal entry shown in FIG. 6, although the information on the accounts receivable amount of ¥ 3.24 million and the actual deposit amount of ¥ 2.16 million is usually at the operator's hand, the amount of purchased taxes is at hand. Since it is possible that the information on the payables of ¥ 10.8 million is not in the hand of the operator, it is necessary to obtain information on the payables of ¥ 10.8 million by searching or the like.

  Therefore, in this item, when the deposit input in July is performed, the operator inputs the amount of 2.16 million yen actually transferred (deposited) on the deposit input screen MA shown in FIG. We will explain how to confirm that there is an unopened amount for and that the unopened amount is ¥ 1,080,000 for the amount of trade-in and purchase tax included. Furthermore, a method of displaying details of accounts payable offset at the same time as payment is described by activating the search screen MB shown in FIG. Hereinafter, a flow of acquiring information on accounts payable of 1.08 million yen by search and creating the offsetting journal shown in FIG. 6 based on the acquisition will be described.

  First, when the billing address code "T000000001" and the payment date "2017/07/20" are input on the payment input screen MA shown in FIG. The included deposit data 106i is acquired and displayed in the area indicated by MA1 in FIG. The operator inputs the deposit amount of 2.16 million yen which can be grasped by the display in the "currently cleared amount" in the area of MA2 of FIG. When the input is performed, the input amount of 2.12 million is automatically subtracted from the billed amount of 3.24 million yen, and the difference of 1.08 million yen is displayed in the "amount of tax-included trade-in purchase" in the area of MA2 in FIG. Be done.

  Then, when "Trade-Offset Search" is selected on the deposit input screen MA of FIG. It can be acquired as described in (Purchased data acquisition processing).

(Purchasing data acquisition process)
In response to the instruction from the deposit input screen, the purchase data acquisition unit 102 f acquires the purchase data 106 g including the incomplete clearing category from the storage unit 106.

  Specifically, the purchase data acquisition unit 102 f is configured to store the trade-in purchase tax amount of 1.08 million yen from the storage unit 106, purchase classification = 02: trade-in purchase and payment cleared FLG = 0: not cleared The purchase data 106g meeting the conditions of is acquired as shown in the screen MB of FIG. Based on the acquired purchase data 106g, payment data 106i can be created as described in the following (payment data creation process).

(Payment data creation process)
The deposit data creation unit 102g creates deposit data 106i including the purchase amount in the purchase data 106g acquired by the purchase data acquisition unit 102f and the deposit amount input on the deposit input screen.

  Specifically, when the acquired purchase data 106g shown in the screen MB of FIG. 5 is selected and "set" is selected, the payment data creation unit 102g acquires the specifications acquired by the purchase data acquisition unit 102f. Payment data 106i (shown in FIG. 6) including the purchase tax amount (1.08 million yen) in deposit data 106g (shown in screen MB in FIG. 5) and the deposit amount (2.16 million yen) entered in deposit input screen MA create.

  As shown in FIG. 6, for example, the payment data 106i includes customer identification data (customer code: T000000001 and customer name: T company), payment date (2017/07/20), payment category (01: transfer and 02: accounts payable offset), vendor identification data (vendor code: T000000001 and vendor name: T company), deposit amount (2.16 million yen and 1.08 million yen), etc. are included.

  Referring back to FIG. 5, when “set” is selected on the screen MB, details of payables cancellation are displayed in the area of MA 3 of the screen MA of FIG. 5. As a result, since the total amount of payment displayed in the area of MA3 will be 2.16 million yen + 1.08 million yen = 3.24 million yen, as shown in the area of MA4, the "currently cleared amount" is 2.16 million yen It will be updated to 3.24 million yen. As shown in the area of MA4 due to the update, the “claimed amount” and the “currently cleared amount” will be the same amount at ¥ 3.24 million, so the “open amount” is ¥ 1.08 million to ¥ 0,000. Updated to yen.

  Further, returning to the screen MB of FIG. 5, when “set” is selected, “payment cleared amount” in the purchase data 106 g acquired by the purchase data acquisition unit 102 f is 0, as shown in FIG. 6. Update from 10,000 yen to 1.08 million yen, and "Payment cleared FLG" indicates that clearing of the purchase price has not been completed. It is updated to a clearing completion category (1: cleared) indicating that clearing is complete.

  Then, based on the created payment data 106i, as described in the following (settlement journal creation processing), it is possible to create a setback journal shown in FIG.

(Offset journal creation process)
The offsetting journal creation unit 102h performs offsetting journalization for the journal entry created by the journal entry creating unit 102e, including the purchase amount and deposit amount in the deposit data 106i created by the deposit data creating unit 102g, and the sales amount acquired by the amount obtaining unit 102a. create.

  More specifically, as shown in the <Journal> in July in FIG. 6, the offsetting journal creation unit 102h debites the accounts payable amount of 10.8 million, which is the purchase tax amount in the deposit data 106i created by the deposit data creation unit 102g. An offsetting journal entry is written in which the yen and the amount of the current account, 2.16 million, are listed, and as a credit, accounts receivable of 2.24 million, which is the sales tax included in the amount acquisition unit 102a of [3-3]. The offsetting journal entry is an offsetting journal entry (shown in FIG. 4) created by the journalizing section 102 e of [3-3].

  As described in the previous paragraph, against the journal entry created in June, the offset journal can be created in July of the following month, but for reference, the bill for July is the invoice data for July 106h. It can be created as described in the next paragraph.

  As shown in the <Invoice> of July in FIG. 6, from the "previous invoice amount (2.42 million yen)" of the invoice data 106h to the "previous offset amount not yet paid out (1.08 million yen)" The deducted amount is the “previous invoice amount (2.16 million yen)” printed on the invoice, and the “submission offset amount (1.08 million) of the invoice data 106h from the“ payment amount (32.4 million yen) ”of the invoice data 106h. The amount obtained by subtracting “yen)” is the “payment amount (2.16 million yen)” printed on the invoice, and “debiting balance carry forward of the invoice data 106h” from the “forward amount (0,000 yen)” of the billing data 106h. The amount obtained by subtracting the amount (0,000 yen) is the amount carried forward (0,000 yen) printed on the bill. As described above, the “previously charged amount”, the “payment amount”, and the “retention amount” in the invoice are printed an amount that does not include the trade-off amount (the trade-off amount is subtracted).

[3-5. Summary]
As described above, as described in [3-1] to [3-3], according to the data creating apparatus 100 according to the present embodiment, from the sales amount of the product sold to the customer, the product purchased from the customer Estimate data or billing data can be created that includes a deduction amount that is the amount obtained by subtracting the purchase amount. Thereby, it is possible to easily create a quote or a bill in which the said deduction amount is written.

  In addition, as described in [3-3], if the data creation device 100 according to the present embodiment includes the journalizing unit 102e, as shown in the journalizing of FIG. It is possible to create a journal entry in which 3.24 million yen) and the purchase price (1.08 million yen) of the product purchased from the customer are described.

  Then, as described in [3-4], if the data creation device 100 according to the present embodiment includes the purchase data acquisition unit 102f, the payment data creation unit 102g, and the offsetting journal creation unit 102h, the clearing is not completed It is possible to easily search for the purchase data 106g including the classification, thereby creating an offsetting journal entry and clearing the unsettled amount (¥ 1,080,000).

[4. Other embodiments]
The present invention may be practiced in various different embodiments within the scope of the technical idea described in the claims in addition to the embodiments described above.

  For example, among the processes described in the embodiment, all or part of the process described as being automatically performed may be manually performed, or all the processes described as being manually performed. Alternatively, some of them can be performed automatically by known methods.

  In addition, information including processing procedures, control procedures, specific names, registered data of each processing, parameters such as search conditions, screen examples, and database configurations shown in the present specification and the drawings are described unless otherwise specified. Can be changed arbitrarily.

  Further, with regard to the data creation device 100, each component shown in the drawings is functionally conceptual, and does not necessarily have to be physically configured as shown.

  For example, even if all or any part of the processing functions included in the data creation apparatus 100, in particular each processing function performed by the control unit, are realized by a CPU and a program interpreted and executed by the CPU, Well, it may be realized as wired logic hardware. The program is stored in a non-temporary computer-readable recording medium that includes programmed instructions for causing the information processing apparatus to execute the processing described in the present embodiment, and the data creation apparatus as necessary. Mechanically read to 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). The computer program is executed by being loaded into the RAM, and cooperates with the CPU to configure the control unit.

  Also, this computer program may be stored in an application program server connected to the data creation apparatus 100 via any network, and it is possible to download all or a part of the computer program as needed. is there.

  Further, the program for executing the processing 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" means a memory card, a universal serial bus (USB) memory, a secure digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an erasable programmable read only memory (EPROM), and an EEPROM (registration). Trademarks (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magneto-Optical disk), DVD (Digital Versatile Disk), and Blu-ray (registered trademark) Disc etc. Any "portable physical media It is intended to include.

  The “program” is a data processing method described in any language or description method, and may be in any format such as source code or binary code. Note that the “program” is not necessarily limited to one that is configured in a single way, and achieves its function in cooperation with a separate program represented by a plurality of modules or libraries or a separate program represented by the OS. Including things. In addition, as 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, a known configuration and procedure can be used.

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

  Further, the data creating apparatus 100 may be configured as an information processing apparatus such as a known personal computer or a workstation, or may be configured as the information processing apparatus to which any peripheral device is connected. Also, the data creation device 100 may be implemented by mounting software (including a program or data) that causes the device to realize the processing described in the present embodiment.

  Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them may be functionally or physically in any unit in accordance with various additions or according to functional load. It can be distributed and integrated. That is, the embodiments described above may be implemented in any combination, and the embodiments may be implemented selectively.

  The present invention is useful in all industries and industries, but is particularly useful in the machine selling industry.

100 data creation device 102 control unit
102a amount acquisition part
102b Data creation unit
102c Quotation Writing Department
102d Invoice preparation department
102e Journalizing department
102f Purchase Data Acquisition Department
102g payment data creation department
102h offsetting journal creation unit 104 communication interface unit 106 storage unit
106a Sales estimate data
106b Purchase Quotation Data
106c Estimated data
106d Order data
106e Ordering data
106f Sales data
106g purchase data
106h Billing data
106i payment data 108 input / output interface unit 112 input device 114 output device 200 server 300 network

Claims (6)

A data creation apparatus comprising a control unit and a storage unit, the data creation apparatus comprising:
The storage unit
Sales data including business partner identification data for identifying business partners and sales amounts of products sold to or sold to the business partners;
Purchase data including customer identification data and purchase amount of goods purchased or purchased from the business partners;
Is stored,
The control unit
An amount acquisition unit for acquiring a sales amount and a purchase amount associated with the same customer identification data from the sales data and the purchase data;
A data creation means for calculating a deduction amount by subtracting the purchase amount acquired by the amount acquisition means from the sales amount acquired by the amount acquisition means, and creating estimated data or billing data including the calculated deduction amount When,
To provide
Data creation device characterized by The control unit
It further comprises: a sales journal entry including the sales amount acquired by the amount acquisition unit; and a journalizing unit for preparing a purchase journal including the purchase amount acquired by the amount acquisition unit.
The data creation device according to claim 1, characterized in that The purchase data further includes a clearing uncompleted section indicating that clearing of the purchase price has not been completed,
The control unit
Purchase data acquisition means for acquiring purchase data including the uncleared category from the storage unit in response to an instruction from a deposit input screen;
Deposit data creation means for creating deposit data including the purchase amount of the purchase data acquired by the purchase data acquisition means and the deposit amount input on the deposit input screen;
An offsetting journal entry for creating an offsetting journal entry for the journal entry created by the journal entry creating means, including the purchase amount and deposit amount in the deposit data created by the deposit data creation means, and the sales amount obtained by the price acquisition means Means,
Further comprising
The data creation device according to claim 2, characterized in that The product is a machine,
The purchased or purchased product is a product purchased or purchased on condition that the sales or sold product is purchased by the business partner,
The data creation device according to any one of claims 1 to 3, characterized in that It is a data creation method executed by an information processing apparatus including a control unit and a storage unit,
The storage unit
Sales data including business partner identification data for identifying business partners and sales amounts of products sold to or sold to the business partners;
Purchase data including customer identification data and purchase amount of goods purchased or purchased from the business partners;
Is stored,
Executed by the controller
An amount acquisition step of acquiring a sales amount and a purchase amount associated with the same customer identification data from the sales data and the purchase data;
A data creation step of calculating a deduction amount by subtracting the purchase amount acquired in the amount acquisition step from the sales amount acquired in the amount acquisition step, and creating estimated data or billing data including the calculated deduction amount When,
Including
A method of creating data characterized by A data creation program for causing an information processing apparatus including a control unit and a storage unit to execute the program.
The storage unit
Sales data including business partner identification data for identifying business partners and sales amounts of products sold to or sold to the business partners;
Purchase data including customer identification data and purchase amount of goods purchased or purchased from the business partners;
Is stored,
For the control unit to execute
An amount acquisition step of acquiring a sales amount and a purchase amount associated with the same customer identification data from the sales data and the purchase data;
A data creation step of calculating a deduction amount by subtracting the purchase amount acquired in the amount acquisition step from the sales amount acquired in the amount acquisition step, and creating estimated data or billing data including the calculated deduction amount When,
Including
A data creation program characterized by