Genuine product purchase device, genuine product purchase method and genuine product purchase program

Abstract

To provide a genuine product purchase device, a genuine product purchase method and a genuine product purchase program that can reduce work man-hours and also reduce errors.SOLUTION: A genuine product purchase device according to an embodiment refers to a billing destination master and a variety master, extracts work data of transactions corresponding to genuine product purchase in a designated month input from sales data, generates purchase details work data in which a manufacturer, a sales unit price, a dealership and a purchase unit price are associated for at least each product based on the variety master, customer master, manufacturer sales unit price master, dealership purchase unit price master, and the work data, and creates transaction data for each manufacturer and dealership based on the purchase details work data.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a genuine product purchasing device, a genuine product purchasing method, and a genuine product purchasing program. [Background technology]

[0002] Patent Document 1 discloses a technique for reducing the burden on sellers caused by online shopping transactions. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent No. 6683319 Summary of the Invention [Problem to be solved by the invention]

[0004] Incidentally, among the products handled by the auto parts wholesaler or machine parts wholesaler, there are products manufactured based on the drawings designed by the manufacturer, drawings approved by the manufacturer, and the manufacturer's specifications. These products are generally called genuine products. The sales rights for these genuine products are owned by the manufacturer. For this reason, genuine products must be sold through the genuine product supply route originating from the manufacturer.

[0005] However, in practice, even genuine products are delivered directly to wholesalers in response to their orders. For this reason, traditionally, workers would compile and extract data on sales transactions with genuine product wholesalers at the end of the month, then manually process this data into sales to manufacturers and purchases from authorized dealers, and input it into systems. As a result, auto parts wholesalers and machine parts wholesalers were reliant on the experience of their workers, which led to inconsistent and incorrect decisions, as well as cumbersome work at the end of the month, leaving room for improvement in reducing work hours.

[0006] The present invention has been made in consideration of the above, and aims to provide a genuine product purchasing device, a genuine product purchasing method, and a genuine product purchasing program that can reduce work hours and reduce errors. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the genuine product buying device according to the present invention is a genuine product buying device equipped with a control unit, and is capable of accessing sales data in which at least a billing destination, a customer, and a product type are associated with each sales number, a billing destination master in which a billing destination classification is associated with each billing destination, a product type master in which a manufacturer and a genuine product classification are associated with each product type, a customer master in which a billing destination and a buying destination are associated with each customer, a manufacturer sales price master in which a manufacturer and a sales price are associated with each product, and a dealer purchase price master in which a dealer and a purchase price are associated with each product, and The control unit is characterized by comprising: an extraction unit that refers to the billing destination master and the product type master and extracts work data for transactions corresponding to the purchase of genuine products for a specified month input from the sales data; a generation unit that generates purchase detail work data that associates, at least for each product, manufacturer, sales price, authorized dealer and purchase price based on the product type master, the customer master, the manufacturer sales price master, the authorized dealer purchase price master and the work data; and a creation unit that creates transaction data for each manufacturer and authorized dealer based on the purchase detail work data.

[0008] Furthermore, the genuine product repurchase method of the present invention is a genuine product repurchase method executed by a genuine product repurchase device equipped with a control unit, and is capable of accessing sales data in which at least a billing address, a customer, and a product type are associated with each sales number, a billing address master in which a billing address classification is associated with each billing address, a product type master in which a manufacturer and a genuine product classification are associated with each product type, a customer master in which a billing address and a repurchase address are associated with each customer, a manufacturer sales price master in which a manufacturer and a sales price are associated with each product, and an authorized dealer purchase price master in which an authorized dealer and a purchase price are associated with each product, and is executed by the control unit. The system is characterized by including an extraction step of referring to the billing destination master and the product type master and extracting work data for transactions corresponding to the purchase of genuine products for a specified month entered from the sales data; a generation step of generating purchase detail work data that associates, at least for each product, manufacturer, sales price, authorized dealer and purchase price based on the product type master, the customer master, the manufacturer sales price master, the authorized dealer purchase price master and the work data; and a creation step of creating transaction data for each manufacturer and authorized dealer based on the purchase detail work data.

[0009] Furthermore, a genuine product buying program according to the present invention is a genuine product buying program to be executed by a genuine product buying device having a control unit, and is capable of accessing sales data in which at least a billing address, a customer, and a product type are associated with each sales number, a billing address master in which a billing address classification is associated with each billing address, a product type master in which a manufacturer and a genuine product classification are associated with each product type, a customer master in which a billing address and a buying address are associated with each customer, a manufacturer sales price master in which a manufacturer and a sales price are associated with each product, and an authorized dealer purchase price master in which an authorized dealer and a purchase price are associated with each product, and when executed by the control unit, The system is characterized by including an extraction step of referring to the billing destination master and the product type master and extracting work data of transactions corresponding to the purchase of genuine products for a specified month input from the sales data in order to perform the above-mentioned operation; a generation step of generating purchase detail work data that associates, at least for each product, the manufacturer, sales price, authorized dealer, and purchase price based on the product type master, the customer master, the manufacturer sales price master, the authorized dealer purchase price master, and the work data; and a creation step of creating transaction data for each manufacturer and authorized dealer based on the purchase detail work data. [Effects of the Invention]

[0010] According to the present invention, it is possible to reduce the number of work steps and also to reduce errors. [Brief explanation of the drawings]

[0011] [Figure 1] FIG. 1 is a schematic diagram showing an overview in a block diagram of an example of the configuration of a genuine product purchasing device according to an embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of a billing destination master table in the billing destination master according to the embodiment. [Figure 3] FIG. 3 is a diagram showing an example of a product type master table in the product type master according to the embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of a customer master table in the customer master according to the embodiment. [Figure 5] FIG. 5 is a diagram illustrating an example of a manufacturer sales unit price master table in the manufacturer sales unit price master according to the embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a dealer sales unit price master table in the dealer purchase unit price master according to the embodiment. [Figure 7] FIG. 7 is a diagram schematically illustrating details of a transaction according to the embodiment. [Figure 8] FIG. 8 is a diagram showing an overall processing flow showing an outline of the overall processing of the genuine product purchasing device according to the embodiment. [Figure 9] FIG. 9 is a flowchart showing details of the process executed by the genuine product purchasing device according to the embodiment. [Figure 10] FIG. 10 is a diagram illustrating an example of a sales data table of sales data according to the embodiment. [Figure 11] FIG. 11 is a diagram showing an example of a journal data table based on the sales data table of FIG. [Figure 12] FIG. 12 is a flowchart showing the detailed contents of genuine product transaction data processing according to the embodiment. [Figure 13] FIG. 13 is a diagram illustrating an example of sales data for a specified month extracted by the extracting unit according to the embodiment. [Figure 14] FIG. 14 is a diagram illustrating an example of a method for the extraction unit according to the embodiment to extract sales data corresponding to purchase of genuine products. [Figure 15] FIG. 15 is a diagram illustrating an example of a work data table generated by the extraction unit according to the embodiment. [Figure 16] FIG. 16 is a diagram illustrating an example of a method for generating a trade-in detail work table generated by the generating unit according to the embodiment. [Figure 17] FIG. 17 is a diagram showing an example of a method for updating the unit price and amount in the trade-in details work table generated by the generating unit according to the embodiment. [Figure 18] FIG. 18 is a diagram illustrating an example of a purchase payment schedule data table in the transaction data generated by the generating unit according to the embodiment. [Figure 19] FIG. 19 is a diagram showing an example of a journal data table based on the purchase payment schedule data table of FIG. [Figure 20] FIG. 20 is a diagram illustrating an example of an expense control schedule data table in transaction data generated by the creating unit according to the embodiment. [Figure 21] FIG. 21 is a diagram showing an example of a journal data table based on the expense control schedule data table of FIG. [Figure 22] FIG. 22 is a diagram illustrating an example of an expense control schedule statement according to the embodiment. [Figure 23] FIG. 23 is a diagram for schematically explaining an overview of the sales analysis process performed by the analysis unit according to the embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0012] Hereinafter, embodiments of a genuine product repurchase device, a genuine product repurchase method, and a genuine product repurchase program according to the present invention will be described in detail with reference to the accompanying drawings. However, the present invention is not limited to these embodiments.

[0013] [1. Configuration] An example of the configuration of a genuine product purchasing device according to this embodiment will be described with reference to Fig. 1 etc. Fig. 1 is a schematic diagram showing an overview in a block diagram of an example of the configuration of a genuine product purchasing device.

[0014] 1 is a commercially available desktop personal computer. The genuine product repurchase device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a commercially available portable information processing device such as a notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0015] The genuine product repurchase device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. The units included in the genuine product repurchase device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0016] The communication interface unit 104 communicably connects the genuine product buyback device 100 to a network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the genuine product buyback device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the memory unit 106 may also be stored in the server 200, for example.

[0017] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that functions as a pointing device in cooperation with a mouse. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0018] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 stores computer programs that work in conjunction with an OS (Operating System) to issue commands to a CPU (Central Processing Unit) to perform various processes. The storage unit 106 may be, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, or an optical disk. The storage unit 106 stores a billing destination master 106a, a product type master 106b, a customer master 106c, a manufacturer sales price master 106d, and an authorized dealer purchase price master 106e.

[0019] The billing destination master 106a stores billing destination classifications in association with each billing destination.

[0020] Figure 2 is a diagram showing an example of a billing destination master table in the billing destination master 106a. In the first row of the billing destination master table T1 shown in Figure 2, the billing destination "Wholesale A" is associated with the billing classification destination "0: Commercial." Here, the billing destination "Wholesale A" and the billing classification destination "0: Commercial" in the billing destination master table T1 indicate a wholesaler, the billing destination "Wholesale A" and the billing classification destination "1: Manufacturer B" indicate a manufacturer, and the billing destination "Authorized Dealer C" and the billing classification destination "0: Commercial" indicate an authorized dealer.

[0021] The product type master 106b stores, for each product type, a car manufacturer code (hereinafter referred to as "car manufacturer CD") and a genuine product classification in association with each other.

[0022] Fig. 3 is a diagram showing an example of a product type master table in the product type master 106b. In the first row of the product type master table T2 shown in Fig. 3, the product type "genuine product" is associated with the car manufacturer CD "manufacturer B" and the genuine product classification "1: genuine product." Similarly, in the second row of the product type master table T2, the product type "commercial product" is associated with the car manufacturer CD being blank and the genuine product classification "0: commercial product."

[0023] The customer master 106c stores, for each customer, a billing destination and a buyer code (hereinafter referred to as "buyer CD") in association with each other.

[0024] 4 is a diagram showing an example of a customer master table in the customer master 106c. In the first row of the customer master table T3 shown in FIG. 4, the customer "Wholesale A" is stored in association with the billing destination "Wholesale A" and the purchase destination CD "Authorized Dealer C."

[0025] The manufacturer sales price master 106d stores the car manufacturer CD and the sales price for each product in association with each other.

[0026] 5 is a diagram showing an example of a manufacturer unit sales price master table in the manufacturer unit sales price master 106d. In the first row of the manufacturer unit sales price master table T4 shown in Fig. 5, the product "SH001" is stored in association with the car manufacturer CD "manufacturer B" and the unit sales price "110".

[0027] The dealer purchase unit price master 106e stores, for each product, a car dealer code (hereinafter referred to as "car dealer CD") and a purchase unit price in association with each other.

[0028] 6 is a diagram showing an example of a dealer sales unit price master table in the dealer purchase unit price master 106e. In the first row of the dealer purchase unit price master table T5 shown in FIG. 6, the product "SH001" is stored in association with the car dealer CD "Dealer C" and the purchase unit price "130."

[0029] Returning to FIG. 1, the description of the configuration of the genuine product purchasing device 100 will continue. The control unit 102 is a CPU or the like that comprehensively controls the genuine product purchasing device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, etc., and executes various information processing based on these stored programs. The control unit 102 includes a sales input unit 102a, an extraction unit 102b, a generation unit 102c, a creation unit 102d, an output unit 102e, and an analysis unit 102f.

[0030] The sales input unit 102 a performs a sales input process for registering sales data according to input by an operator via the input device 112 .

[0031] The extraction unit 102b refers to the billing destination master 106a and the product type master 106b and extracts work data for transactions that correspond to the buy-back of genuine products for the specified month entered from the sales data. Specifically, the extraction unit 102b refers to the billing destination master 106a and the product type master 106b and executes a buy-back detail extraction process to extract work data that extracts transactions that correspond to the buy-back of genuine products for the specified month entered by the worker from the sales data.

[0032] The generating unit 102c generates resale statement work data in which, for at least each product, the manufacturer, sales price, authorized dealer, and purchase price are associated based on the product type master 106b, the customer master 106c, the manufacturer sales price master 106d, the authorized dealer purchase price master 106e, and the work data generated by the extracting unit 102b. Specifically, the generating unit 102c executes a resale statement work generation process to generate resale statement work data in which, for each invoice number, the product, quantity, manufacturer, sales price, sales amount, authorized dealer, purchase price, purchase amount, resale cost, delivery destination, and date are associated based on the product type master 106b, the customer master 106c, the manufacturer sales price master 106d, the authorized dealer purchase price master 106e, and the work data generated by the extracting unit 102b.

[0033] The creating unit 102d executes a transaction data creating process to create transaction data for each of the manufacturer and the authorized dealer based on the trade-in detail work data table created by the creating unit 102c. Here, the transaction data includes planned invoice payment data for the sales of the product to the manufacturer and planned payment data for expenses for purchasing the product from the authorized dealer.

[0034] The output unit 102e executes a trade-in detail output process for outputting to the output device 114 a control expense schedule detail corresponding to the control expense schedule data created by the creation unit 102d.

[0035] The analysis unit 102f executes a sales analysis process including the purchase cost based on the sales data and the purchase detail work data.

[0036] [2. Transaction Details] Next, the details of the commercial flow of the transaction will be explained. Figure 7 is a diagram showing the details of the transaction.

[0037] As shown in FIG. 7, first, the company purchases goods (cost: 100 x 50 units) from a supplier (Step A).

[0038] Next, the company delivers the products (unit price: 140 x 10 units) in response to the order from the wholesaler and records the sales (Step B).

[0039] Then, at the end of the month, a worker at the company extracts the sales (unit sales price: 110 x 10 units) from the transaction in step B described above and records it as a receivable from the manufacturer (step C).

[0040] Next, the manufacturer records the sales (sales price 120 x 10 units) to the dealer (authorized dealer) (Step D) in accordance with the transaction in Step B. In this case, the manufacturer is not directly involved in the transaction.

[0041] After that, the company purchases goods from the dealer (authorized dealer) (purchase price: 130 x 10 units) and at the end of the month, records the receivable from the dealer (authorized dealer) for the transaction in Step B described above (Step E).

[0042] The final commercial flow of the transaction in FIG. 7 is in the order of Step A, Step C, Step D, Step E, and Step B.

[0043] [3. Overview of the overall process using the genuine product purchasing device] Next, an outline of the overall processing of the genuine product repurchase device 100 will be described. Fig. 8 is a diagram showing an overall processing flow showing an outline of the overall processing of the genuine product repurchase device 100.

[0044] As shown in FIG. 8, first, the genuine product buyback device 100 executes a sales input process for accepting input of sales data in response to an input by an operator (step S1).

[0045] Next, the genuine product purchasing device 100 executes genuine product transaction data processing, which is monthly processing of genuine product transaction data, at the end of the month (step S2). This genuine product transaction data processing includes a purchase detail extraction process (step S21), a purchase detail work generation process (step S22), and a transaction data creation process (step S23).

[0046] Specifically, the genuine product purchasing device 100 executes a purchase statement extraction process to extract purchase statement work data for genuine products from sales data and generate work table data (step S21), and then executes a purchase statement work generation process to manage this work table data as separate data (step S22). More specifically, the genuine product purchasing device 100 first executes a purchase statement extraction process to extract data for a specified month designated by the operator from the sales data. Next, the genuine product purchasing device 100 acquires each of the creditor (manufacturer) and debtor (authorized dealer) involved in the interim transaction from the billing destination master 106a, product type master 106b, and customer master 106c stored in the storage unit 106. Thereafter, the genuine product purchasing device 100 executes a purchase statement work generation process to acquire each of the unit prices of the creditor (manufacturer) and debtor (authorized dealer) involved in the interim transaction from the manufacturer sales unit price master 106d and authorized dealer purchase unit price master 106e stored in the storage unit 106, respectively, and generates purchase statement work data.

[0047] Furthermore, if the genuine product purchasing device 100 records the creditor (manufacturer) as sales, it will result in a circular transaction. Therefore, the genuine product purchasing device 100 separates the data of credits (invoice payment schedule data) and debtors (authorized dealers) that are different from sales from the cost calculation, and executes a transaction data creation process to create data of debts (expense payment schedule data) that are different from purchases (step S23).

[0048] Thereafter, the genuine product trade-in device 100 executes a trade-in detail output process for outputting trade-in details corresponding to the billing payment schedule data and the expense payment schedule data to the output device 114 (step S3).

[0049] Next, the genuine product repurchase device 100 executes an analysis process for analyzing the genuine product repurchase transaction by regarding the margin of the intermediate transaction as the cost price (step S4).

[0050] In this way, the genuine product repurchase device 100 can identify genuine product repurchase transactions, identify manufacturers and sales prices, and identify authorized dealers and repurchase prices, and can automatically generate imported data. As a result, workers can reduce the amount of work they do at the end of the month and reduce mistakes.

[0051] [4. Details of the process performed by the genuine product purchase device] Next, a description will be given of details of the processing executed by the genuine product repurchase device 100. Fig. 9 is a flowchart showing details of the processing executed by the genuine product repurchase device 100.

[0052] As shown in FIG. 9, first, the sales input unit 102a performs a sales input process to register sales data according to input by an operator via the input device 112 (step S101).

[0053] Fig. 10 is a diagram showing an example of a sales data table in the sales data, and Fig. 11 is a diagram showing an example of a journal data table based on the sales data table of Fig. 10.

[0054] The sales data table T10 shown in Figure 10 stores, for each sales number, the billing address, customer, line number, type, product, quantity, unit price, amount, cost price, cost amount, gross profit, and sales date in correspondence with each other.

[0055] Specifically, the first row of the sales data table T10 stores the sales number "U001" in association with the billing destination "Wholesale A", customer "Wholesale A", row number "1", type "Genuine product", product "SH001", quantity "10", unit price "140", amount "1,400", cost unit price "100", cost amount "1,000", gross profit "400", and sales date "2022 / 7 / 1".

[0056] In the case of the sales data table T10 shown in FIG. 10, the journalization image becomes the journalization data table T11 shown in FIG.

[0057] Returning to FIG. 9, the description of step S102 and subsequent steps will be continued. In step S102, the genuine product purchasing device 100 performs genuine product transaction data processing in monthly processing at the end of the month. Note that the following describes the content when the genuine product purchasing device 100 performs processing in July 2022.

[0058] 12 is a flowchart showing the detailed contents of the genuine product transaction data processing. As shown in FIG. 12, the extraction unit 102b executes a trade-in detail extraction process to generate work data by referencing the billing destination master 106a and the product type master 106b and extracting transactions corresponding to the trade-in of genuine products for a specified month input by the worker from the sales data (step S201).

[0059] Fig. 13 is a diagram showing an example of sales data for a specified month extracted by the extraction unit 102b. Fig. 14 is a diagram showing an example of a method for the extraction unit 102b to extract sales data corresponding to genuine product purchases. Fig. 15 is a diagram showing an example of a work data table generated by the extraction unit 102b.

[0060] As shown in the sales data table T12 in Figure 13, first, the extraction unit 102b extracts from the sales data records of sales data that correspond to July 2022, which is the specified month entered by the worker, for example, sales numbers "U001" to "U004".

[0061] Next, as shown in FIG. 14, the extraction unit 102b references the genuine classification in the product type master table T2 from the product type in the sales data table T12, extracts sales data records for which the genuine classification corresponds to "1: genuine," and references the invoice classification in the invoice master table T1 from the invoice recipient in the sales data table T12, extracts records for which the invoice classification corresponds to "0: commercially available," such as sales numbers "U0001" and "U002," and generates the work data table T20 shown in FIG. 15.

[0062] Returning to FIG. 12, the description of step S202 and subsequent steps will be continued. In step S202, the generation unit 102c executes a purchase detail work generation process to generate purchase detail work data that associates, for each invoice number, the product, quantity, manufacturer, sales price, sales amount, authorized dealer, purchase price, purchase amount, purchase cost, delivery destination, and date based on the product type master 106b, customer master 106c, manufacturer sales price master 106d, authorized dealer purchase price master 106e, and the work data generated by the extraction unit 102b.

[0063] Fig. 16 is a diagram showing an example of a method for generating a trade-in details worktable generated by the generating unit 102c. Fig. 17 is a diagram showing an example of a method for updating the unit price and amount in the trade-in details worktable generated by the generating unit 102c.

[0064] 16, first, based on the work data table T20, the product type master table T2, and the customer master table T3 generated by the extraction unit 102b, the generation unit 102c generates a trade-in detail work data table T21 that associates, for each invoice number, the line number, product, quantity, manufacturer, sales price, sales amount, authorized dealer, purchase price, purchase amount, trade-in cost, delivery destination, and date. In this case, the generation unit 102c transfers the sales number, delivery destination, and sales date from the items in the work data table T20 to the invoice number, delivery destination, and date, respectively, in the trade-in detail work data table T21. Furthermore, the generation unit 102c references the product type master table T2 and the customer master table T3, and identifies the manufacturer and authorized dealer from each of the customer and product type items in the work data table T20, and transfers them to the trade-in detail work data table T21.

[0065] As a result, as shown in Figure 16, the first row of the purchase detail work data table T21 is generated by associating the invoice number "U001" with the row number "1," product "SH001," quantity "10," manufacturer "Manufacturer B," sales price, sales amount, authorized dealer "Authorized Dealer C," purchase price, purchase amount, purchase cost, delivery destination "Wholesale A," and date "2022 / 7 / 1."

[0066] Next, the generation unit 102c refers to the purchase detail work data table T21 in Figure 16 described above, the manufacturer sales price master table T4, and the authorized dealer purchase price master table T5, identifies the sales price and purchase price of the items in the purchase detail work data table T22, and generates the purchase detail work data table T22. As shown in Figure 17, the first row of the purchase detail work data table T22 is generated by associating the invoice number "U001" with the row number "1," product "SH001," quantity "10," manufacturer "Manufacturer B," sales price "110," sales amount "1,100" (sales amount = sales price × quantity = 110 × 10), authorized dealer "Authorized Dealer C," purchase price "130," purchase amount "1,300" (purchase amount = purchase price × quantity = 130 × 10), purchase cost "200" (purchase cost = purchase amount - sales amount = 1,300 - 1,100), delivery destination "Wholesale A," and date "2022 / 7 / 1."

[0067] Returning to FIG. 12, the description of step S203 and subsequent steps will be continued. In step S203, the creating unit 102d executes a transaction data creating process for creating transaction data for each of the manufacturer and the authorized dealer based on the trade-in detail work data table T22 created by the creating unit 102c.

[0068] Fig. 18 is a diagram showing an example of a purchase and payment schedule data table in the transaction data generated by the creation unit 102d. Fig. 19 is a diagram showing an example of a journal data table based on the purchase and payment schedule data table of Fig. 18.

[0069] As shown in Figure 18, the creation unit 102d generates a billing payment schedule data table T31 as transaction data based on the purchase detail work data table T22 generated by the generation unit 102c. The first row of the billing payment schedule data table T31 stores the billing number "U001," the row number "1," the customer "Manufacturer B," the expense item "Genuine Product Purchase Revenue," the product "SH001," the sales amount "1,100," and the date "2022 / 7 / 31," all associated with each other. Therefore, in the case of the billing payment schedule data table T31 shown in Figure 18, the journalization image becomes the journalization data table T41 shown in Figure 19.

[0070] Fig. 20 is a diagram showing an example of a planned expense control data table in the transaction data generated by the creating unit 102d. Fig. 21 is a diagram showing an example of a journal data table based on the planned expense control data table of Fig. 20.

[0071] As shown in Fig. 20, the creation unit 102d generates an expense payment schedule data table T32 as transaction data based on the purchase detail work data table T22 generated by the generation unit 102c. In the first row of the expense payment schedule data table T32, the payment number "U001" is stored in association with the row number "1," the supplier "Authorized Dealer C," the expense item "Genuine Purchase Expenses," the product "SH001," the sales amount "1,300," the delivery destination "Wholesale A," the quantity "10," the purchase price "130," and the date "7 / 31 / 2022." Therefore, in the case of the expense payment schedule data table T32 shown in Fig. 20, the journalization image is the journalization data table T42 shown in Fig. 21.

[0072] In this way, the creation unit 102d can generate purchase payment schedule data and expense payment schedule data as transaction data for each of the manufacturer and authorized dealer based on the trade-in detail work data table T22 generated by the generation unit 102c. After step S203, the genuine product trade-in device 100 returns to the main routine of FIG.

[0073] Returning to FIG. 9, the description of step S103 and subsequent steps will be continued. In step S103, the output unit 102e executes a trade-in detail output process for outputting to the output device 114 a controlled expense schedule detail corresponding to the controlled expense schedule data created by the creation unit 102d.

[0074] Fig. 22 is a diagram showing an example of an expense payment schedule statement. As shown in Fig. 22, the output unit 102e outputs an expense payment schedule statement P1 corresponding to the expense payment schedule data table T32 created by the creation unit 102d to the output device 114. This allows the worker to automatically create the expense payment schedule statement P1, thereby reducing the number of steps in monthly processing and reducing errors.

[0075] After step S103, the analysis unit 102f executes a sales analysis process including the purchase cost based on the sales data and the purchase detail work data (step S104).

[0076] 23 is a diagram for schematically explaining an overview of the sales analysis process by the analysis unit 102f. As shown in FIG. 23, the analysis unit 102f calculates the cost price and gross profit, including the intermediate margin, for each product based on the sales data table and the purchase detail work data table.

[0077] For example, as shown in the second row of the calculated value table T40, which reflects the purchase cost from the purchase details work table T23, the analysis unit 102f calculates the cost amount as 600 yen for the transaction with sales number "U002" and row number "1" in the second row of the sales data table T12, as this is a genuine product purchase transaction, even though the cost amount is 500 yen, including the purchase cost of 100 yen (intermediate margin) from the purchase details work data table T22.

[0078] In contrast, as shown in the fourth row of the calculated value table T40, which reflects the purchase cost from the purchase details worktable T23, the analysis unit 102f calculates the cost amount as 1,500 yen for the transaction with sales number "U004" and row number "1" in the fourth row of the sales data table T12, as this does not constitute a genuine product purchase transaction, without taking into account the purchase cost from the purchase details worktable T23.

[0079] In this way, the analysis unit 102f performs a sales analysis process including the purchase cost based on the sales data and the purchase detail work data. As a result, the worker can grasp the cost and gross profit, including the intermediate margin, for each product, which can be used for sales analysis. After step S105, the genuine product purchase device 100 ends this process.

[0080] According to the embodiment described above, the creation unit 102d can generate purchase payment schedule data and expense payment schedule data as transaction data for each manufacturer and authorized dealer based on the trade-in detail work data table T22 generated by the generation unit 102c. As a result, workers can reduce the number of work hours and errors at the end of the month.

[0081] According to the embodiment, the transaction data includes scheduled invoice payment data for product sales to the manufacturer and scheduled payment data for expenses for purchasing the product from the authorized dealer. As a result, the worker can manage the scheduled invoice payment data for product sales to the manufacturer and the scheduled payment data for expenses for purchasing the product from the authorized dealer separately.

[0082] Furthermore, according to the embodiment, the output unit 102e outputs a control expense schedule statement corresponding to the control expense schedule data created by the creation unit 102d to the output device 114. As a result, the worker can intuitively understand the control expense schedule data.

[0083] According to the embodiment, the analysis unit 102f performs a sales analysis process including the purchase cost based on the sales data and the purchase detail work data. As a result, the worker can grasp the cost and gross profit including the intermediate margin for each product, and use it for sales analysis.

[0084] [5. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to the achievement of SDGs Goals 8 and 9.

[0085] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0086] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to Goal 16 of the SDGs.

[0087] 6. Other Embodiments The present invention may be implemented in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0088] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0089] Furthermore, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings can be changed as desired unless otherwise specified.

[0090] Furthermore, with regard to the genuine product purchasing device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0091] For example, all or any part of the processing functions of the genuine product purchasing device 100, particularly the processing functions performed by the control unit, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the genuine product purchasing device 100 as needed. That is, a computer program for providing 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). This computer program is executed by being loaded into RAM and cooperates with the CPU to form the control unit.

[0092] In addition, this computer program may be stored in an application program server connected to the genuine product buyback device 100 via any network, and all or part of it may be downloaded as needed.

[0093] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) disc.

[0094] Furthermore, a "program" is a data processing method written in any language or description method, regardless of the format, such as source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0095] The various databases stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files used for various processes and providing websites.

[0096] The genuine product purchasing device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which any peripheral device is connected. The genuine product purchasing device 100 may also be realized by installing software (including programs or data) that causes the device to perform the processing described in this embodiment.

[0097] 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 can be configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0098] The present invention is useful in the automobile parts wholesale industry or the machine parts wholesale industry. [Explanation of symbols]

[0099] 100 Genuine product purchase device 102 Control section 102a Sales input section 102b Extraction part 102c generator 102d Creation Department 102e Output section 102f Analysis Department 104 Communication interface unit 106 Storage section 106a Billing Master 106b Variety Master 106c Customer Master 106d Manufacturer sales price master 106e Authorized Dealer Purchase Unit Price Master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A genuine product purchasing device equipped with a control unit, Sales data that associates at least the billing address, customer, product type, product quantity, and sales date for each sales number; A billing master that associates billing classifications with each billing destination, A product master that associates each product with its manufacturer and genuine product classification, A customer master that associates billing and purchasing destinations for each customer, A manufacturer sales price master that associates the manufacturer and sales price for each product, A master of authorized dealer purchase prices that associates authorized dealers and purchase prices for each product; is accessible to The control unit an extraction unit that, for each row of the product in the sales data, refers to the genuine product classification in the product classification master from the product type in the sales data, and extracts records for which the genuine product classification corresponds to genuine and which refer to the billing destination classification in the billing destination master from the billing destination in the sales data, as work data for transactions corresponding to the purchase of genuine products in the specified month to be input; a generation unit that generates purchase detail work data that calculates the sales amount, purchase amount, and purchase cost by using the product type master, the customer master, the manufacturer sales unit price master, the authorized dealer purchase unit price master, and the work data to set the sales number and sales date in the work data as a division number and date, and specifying from the customer master the authorized dealer that is a purchase destination corresponding to the customer in the work data and from the product type master the manufacturer that is a car manufacturer corresponding to the product type in the work data, and specifying from the manufacturer sales unit price master the sales unit price corresponding to the specified manufacturer and from the authorized dealer purchase unit price master the purchase unit price corresponding to the specified authorized dealer; a creating unit that creates transaction data for the specified manufacturer from the manufacturer sales unit price master and the specified authorized dealer from the authorized dealer purchase unit price master based on the purchase detail work data; To have A genuine product purchasing device characterized by the following.

2. The genuine product purchasing device according to claim 1, The transaction data is Invoice payment schedule data for sales of products to the specified manufacturer from the manufacturer sales price master; Expense payment schedule data for purchasing goods from the specified authorized dealer from the authorized dealer purchase unit price master; containing, A genuine product purchasing device characterized by the following.

3. The genuine product purchasing device according to claim 2, The control unit an output unit that outputs the expense payment schedule data; and A genuine product purchasing device characterized by the following.

4. The genuine product purchasing device according to claim 3, The control unit an analysis unit that calculates the cost price and gross profit amount for each product whose type in the sales data corresponds to a genuine product based on the sales data and the purchase detail work data; and A genuine product purchasing device characterized by the following.

5. The genuine product purchasing device according to claim 4, The analysis unit For products whose product type in the sales data corresponds to a genuine product, the purchase cost in the purchase detail work data is included in the cost amount as an intermediate margin for intermediate transactions, A genuine product purchasing device characterized by the following.

6. A genuine product purchasing method executed by a genuine product purchasing device having a control unit, Sales data that corresponds to at least the billing address, customer, type, product, quantity, and sales date for each sales number, A billing master that associates billing classifications with each billing destination, A product master that associates each product with its manufacturer and genuine product classification, A customer master that associates billing and purchasing destinations for each customer, A manufacturer sales price master that associates the manufacturer and sales price for each product, A master of authorized dealer purchase prices that associates authorized dealers and purchase prices for each product; is accessible to Executed by the control unit, an extraction step of, for each row of the product in the sales data, referring to the genuine product classification in the product classification master from the product type in the sales data, and extracting from the sales data records in which the genuine product classification corresponds to genuine and in which the invoice classification corresponds to aftermarket, as work data for transactions corresponding to the purchase of genuine products in the specified month to be input; a generation step of generating purchase detail work data in which the sales amount, purchase amount, and purchase cost are calculated by using the product type master, the customer master, the manufacturer sales price master, the authorized dealer purchase price master, and the work data to set the sales number and sales date in the work data as a division number and date, identifying from the customer master the authorized dealer that is a purchase destination corresponding to the customer in the work data, and from the product type master the manufacturer that is a car manufacturer corresponding to the product type in the work data, and identifying from the manufacturer sales price master the sales price corresponding to the identified manufacturer and from the authorized dealer purchase price master the purchase price corresponding to the identified authorized dealer; a creating step of creating transaction data for the specified manufacturer from the manufacturer sales unit price master and the specified authorized dealer from the authorized dealer purchase unit price master based on the purchase detail work data; containing, A method of purchasing genuine products that features the following.

7. A genuine product purchase program to be executed by a genuine product purchase device having a control unit, Sales data that associates at least the billing address, customer, product type, product quantity, and sales date for each sales number; A billing master that associates billing classifications with each billing destination, A product master that associates each product with its manufacturer and genuine product classification, A customer master that associates billing and purchasing destinations for each customer, A manufacturer sales price master that associates the manufacturer and sales price for each product, A master of authorized dealer purchase prices that associates authorized dealers and purchase prices for each product; is accessible to To cause the control unit to execute an extraction step of, for each row of the product in the sales data, referring to the genuine product classification in the product classification master from the product type in the sales data, and extracting from the sales data records in which the genuine product classification corresponds to genuine and in which the invoice classification corresponds to aftermarket, as work data for transactions corresponding to the purchase of genuine products in the specified month to be input; a generation step of generating purchase detail work data in which the sales amount, purchase amount, and purchase cost are calculated by using the product type master, the customer master, the manufacturer sales price master, the authorized dealer purchase price master, and the work data to set the sales number and sales date in the work data as a division number and date, identifying from the customer master the authorized dealer that is a purchase destination corresponding to the customer in the work data, and from the product type master the manufacturer that is a car manufacturer corresponding to the product type in the work data, and identifying from the manufacturer sales price master the sales price corresponding to the identified manufacturer and from the authorized dealer purchase price master the purchase price corresponding to the identified authorized dealer; a creating step of creating transaction data for the specified manufacturer from the manufacturer sales unit price master and the specified authorized dealer from the authorized dealer purchase unit price master based on the purchase detail work data; containing, A genuine product purchase program featuring:

Images