Business support device, business support method and business support program

Abstract

To enable prompt disclosure to a client of an amount payable (debt money) owed to them under a selling consignment business.SOLUTION: A sales data generation unit generates sales data containing a sales date, a client, a transaction type, and a sales amount based on sales entry operations for transaction items, and stores this data in a sales data storage unit. A commission rate calculation result data generation unit references a rate master table in which a commission rate (the ratio of payment amounts to clients relative to total sales amounts) set at least per client and per transaction type, based on the transaction type, then generates commission rate calculation result data containing the commission rate calculation result amount that corresponds to the payment amount per client and per transaction type that is calculated by multiplying the sales amount for each client and each transaction type by the commission rate corresponding to that transaction type, and causes a commission rate calculation result storage unit to store the commission rate calculation result data. An output control unit outputs the commission rate calculation result data stored in the commission rate calculation result storage unit to an output device.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a business support device, a business support method, and a business support program. [Background technology]

[0002] Patent Document 1 (JP 2022-038224 A) discloses a rent calculation process performed by a tenant management device of a tenant management system. In this rent calculation process, the tenant's sales history is referenced, and the total sales amount for the most recent target period, which is the rent calculation period, is calculated as a first total sales amount. In addition, the total sales amount for calculation periods prior to the target period is calculated as a second total sales amount. Then, it is determined whether the first total sales amount is equal to or greater than the second total sales amount.

[0003] If the first total sales amount is less than the second total sales amount, the rent will be set at the amount obtained by multiplying the first total sales amount by the first rate. On the other hand, if the first total sales amount is equal to or greater than the second total sales amount, the rent will be set at the sum of the first rent, which is obtained by multiplying the second total sales amount by the first rate, and the second rent, which is obtained by multiplying the difference between the first total sales amount and the second total sales amount by a second rate that is different from the first rate. This allows for flexible rent calculations for tenants. [Prior art documents] [Patent documents]

[0004] [Patent Document 1] Japanese Patent Publication No. 2022-038224 Summary of the Invention [Problem to be solved by the invention]

[0005] In a sales consignment business, a payment amount (debt amount) to a business partner is generated, after deducting a commission fee according to a commission rate from the sales amount. It is preferable that this debt amount be made public as soon as possible for the business partner's accounting work, etc.

[0006] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a business support device, a business support method, and a business support program that enable the amount of payment (amount of debt) to a business partner for a sales consignment business to be quickly disclosed to the business partner. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the business support device of the present invention has a sales data generation unit that generates sales data including sales date, business partner, transaction object type, and sales amount based on sales input operations for transaction objects and stores the data in a sales data storage unit; a commission rate calculation result data generation unit that references a commission rate master table based on the transaction object type, in which commission rates, which are set at least for each transaction object and transaction object type, are stored, and generates commission rate calculation result data including commission rate calculation result amounts equivalent to the payment amount for each transaction object and for each transaction object, calculated by multiplying the sales amount of the transaction object for each transaction object and for each transaction object type by the commission rate corresponding to the transaction object type, and stores the commission rate calculation result data in the commission rate calculation result storage unit; and an output control unit that outputs the commission rate calculation result data stored in the commission rate calculation result storage unit to an output device.

[0008] In addition, in order to solve the above-mentioned problems and achieve the object, the business support method of the present invention includes a sales data generation step in which a sales data generation unit generates sales data including a sales date, a business partner, a transaction object type, and a sales amount based on a sales input operation of the transaction object, and stores the sales data in a sales data storage unit; a commission rate calculation result data generation step in which a commission rate calculation result data generation unit references, based on the transaction object type, a commission rate master table in which commission rates, which are set at least for each transaction object and for each transaction object type, are stored, and which are the ratios of the amount paid to each transaction object to the total sales amount, and generates commission rate calculation result data including a commission rate calculation result amount equivalent to the payment amount for each transaction object and for each transaction object, calculated by multiplying the sales amount of the transaction object for each transaction object and for each transaction object type by the commission rate corresponding to the transaction object type, and stores the generated commission rate calculation result data in the commission rate calculation result storage unit; and an output control step in which an output control unit outputs the commission rate calculation result data stored in the commission rate calculation result storage unit to an output device.

[0009] In addition, in order to solve the above-mentioned problems and achieve the object, the business support program of the present invention causes a computer to function as: a sales data generation unit that generates sales data including a sales date, business partner, transaction object type, and sales amount based on sales input operations for the transaction object, and stores the data in a sales data storage unit; a commission rate calculation result data generation unit that references, based on the transaction object type, a commission rate master table in which commission rates, which are set at least for each transaction object and each transaction object type and are the ratio of the amount paid to the transaction object to the total sales amount, are stored, and generates commission rate calculation result data including a commission rate calculation result amount equivalent to the payment amount for each transaction object and for each transaction object, calculated by multiplying the sales amount of the transaction object for each transaction object and for each transaction object type by the commission rate corresponding to the transaction object type, and stores the generated commission rate calculation result data in a commission rate calculation result storage unit; and an output control unit that outputs the commission rate calculation result data stored in the commission rate calculation result storage unit to an output device. [Effects of the Invention]

[0010] The present invention can quickly disclose to a trading partner the amount of payment (amount of debt) due to a sales consignment business. [Brief explanation of the drawings]

[0011] [Figure 1] FIG. 1 is a block diagram illustrating a hardware configuration of a task assistance device according to an embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of a performance rate master table provided in the task assistance device according to the embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of a supplier master table provided in the business support device according to the embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of a store master table provided in the business support device according to the embodiment. [Figure 5] FIG. 5 is a diagram illustrating an example of a product type master table provided in the business support device according to the embodiment. [Figure 6] FIG. 6 is a diagram illustrating an example of a product master table provided in the business support device according to the embodiment. [Figure 7] FIG. 7 is a diagram illustrating an example of sales data stored in a sales data storage unit provided in the business support device according to the embodiment. [Figure 8] FIG. 8 is a diagram illustrating an example of the yield calculation result data stored in the yield calculation result storage unit provided in the task assistance device according to the embodiment. [Figure 9] FIG. 9 is a diagram illustrating an example of a purchase lump sum accounting screen displayed on the business support device according to the embodiment. [Figure 10] FIG. 10 is a diagram illustrating an example of the first transaction data generated by the transaction data generating unit. [Figure 11] FIG. 11 is a diagram showing an example of the yield calculation result data before the transaction number update process. [Figure 12] FIG. 12 is a diagram illustrating an example of the second transaction data generated by the transaction data generating unit. [Figure 13] FIG. 13 is a diagram showing an example of the yield calculation result data after the transaction number update process. [Figure 14] FIG. 14 is a diagram illustrating an example of the scheduled payment total data generated by the scheduled payment total data generating unit. DETAILED DESCRIPTION OF THE INVENTION

[0012] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS A task support device according to an embodiment of the present invention will be described in detail below with reference to the accompanying drawings. However, the present invention is not limited to the following embodiment.

[0013] (overview) In sales consignment business, liabilities are generated based on sales details and the commission rate. However, in the case of retail stores such as supermarkets, the number of sales details is enormous, so if liabilities slips are recorded each time, management becomes cumbersome and the data volume becomes bloated, which is not desirable.

[0014] The business support system of the embodiment focuses on the fact that the disclosure information required by business partners is the amount information and quantity calculated from the supplier information, quantity, and commission rate information (consignment sales commission) of each item. Therefore, the business support system of the embodiment stores the amount information calculated from the supplier information, quantity, and commission rate information (consignment sales commission) of each item when recording sales. This makes it possible to disclose information (inquire) to business partners.

[0015] Furthermore, the business support device of the embodiment performs a lump-sum accounting process for debt information on a monthly basis, thereby enabling the accounting of debt information without affecting the amount of data held.

[0016] Furthermore, the business support device of the embodiment associates each statement with a summary debt voucher, thereby realizing a data structure that enables statement information and payment information to be associated and made public to the business partner.

[0017] (Hardware configuration) As shown in Fig. 1, the business support device 1 of the embodiment includes a storage unit 2, a control unit 3, a communication interface unit 4, and an input / output interface unit 5. An input device 6 and an output device 7 are connected to the input / output interface unit 5. The output device 7 corresponds to a display unit such as a monitor device (including a home television), a printing device, or a speaker device. The input device 6 may be a keyboard device, a mouse device, a microphone device, or a monitor device that cooperates with a mouse device to realize a pointing device function.

[0018] The communication interface unit 4 is connected to a network 50, which may be a wide area network such as the Internet or a private network such as a local area network (LAN). One or more customer terminal devices 51 of business partners who are entrusted with the sale of goods or services that are the subject of a commercial transaction are connected to the network 50. The customer terminal device 51 can access the business support device 1 via the network 50 and obtain public information such as the entrustment of the sale of the commercial transaction subject and the customer's share of the sales amount of the entrusted commercial transaction subject.

[0019] A storage device such as a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), or an SSD (Solid State Drive) can be used as the storage unit 2. The storage unit 2 stores a business support program that enables the amount of payment (amount of debt) to a business partner for a sales consignment business to be promptly disclosed to the business partner.

[0020] In addition, this memory unit 2 is provided with a commission rate master table 11, a customer master table 12, a store master table 13, a product type master table 14, a product master table 15, a sales data memory unit 16, a commission rate calculation result memory unit 17, a transaction data memory unit 18, and a total scheduled payment data memory unit 19, each of which is a memory area.

[0021] The commission rate master table 11 stores commission rates, which are set at least for each business partner and each type of commercial transaction object, and which are the ratios of the amount paid to each business partner to the total sales amount. Specifically, as shown in Figure 2, the commission rate master table 11 stores the name of the business that has undertaken consignment sales from the business partner, the name of the store that will be selling on consignment, the business partner name, the variety, and the commission rate by type at the business partner store (hereinafter simply referred to as "commission rate"), all associated with each other. The example in Figure 2 shows that "vegetables" with a variety code of "H001" that have been consigned for sale by "XX Corporation" with a business partner code of "SI001" are sold at the "Ginza Main Store" with a store code of "T1" under the jurisdiction of the "Tokyo Business Office" with a commission rate of "90%", and therefore "90%" of the sales are paid to "XX Corporation."

[0022] In addition, the example in Figure 2 shows that "vegetables" with variety code "H001" that are entrusted for sale by "Producer A" with business partner code "SI002" are sold at the "Ginza Main Store" with store code "T1" under the jurisdiction of the "Tokyo Office" with store code "Z1", and since the commission rate is "80%," "80%" of the sales is paid to "Producer A".

[0023] In addition, the example in Figure 2 shows that "vegetables" with variety code "H001" that are entrusted for sale by "Producer A" with business partner code "SI002" are sold at "Akihabara Store" with store code "T2" under the jurisdiction of "Tokyo Office" with business partner code "Z1", and since the commission rate is "70%", "70%" of the sales is paid to "Producer A".

[0024] In the supplier master table 12, supplier codes and supplier names are stored in association with each other as shown in Figure 3. The example in Figure 3 shows that the supplier code of a supplier with the supplier name "XX Corporation" is "SI001." It also shows that the supplier code of a supplier with the supplier name "Producer A" is "SI002."

[0025] Store master table 13 stores store codes and store names in association with each other, as shown in Figure 4. The example in Figure 4 shows that the store name "Ginza Main Store" has a store code of "T1." The example in Figure 4 also shows that the store name "Akihabara Store" has a store code of "T2."

[0026] Variety codes and variety names are associated and stored in the variety master table 14. The example in Fig. 5 shows that the variety code for the variety name "vegetable" is "H001".

[0027] As shown in Fig. 6, the product master table 15 stores product codes, product names, variety codes, and variety names in association with each other. The example in Fig. 6 shows that the product name "cucumber" has a variety code of "H001", a variety name of "vegetable", and a product code of "S001". The example in Fig. 6 also shows that the product name "eggplant" has a variety code of "H001", a variety name of "vegetable", and a product code of "S002". The example in Fig. 6 also shows that the product name "carrot" has a variety code of "H001", a variety name of "vegetable", and a product code of "S003".

[0028] (Functional configuration of business support device) Next, the control unit 3 executes the business support program stored in the storage unit 2, thereby functioning as a data generation unit 21 and an output control unit 22, as shown in Fig. 1. The data generation unit 21 includes the functions of a sales data generation unit 23, a commission calculation result data generation unit 24, a transaction data generation unit 25, and a total scheduled payment data generation unit 26.

[0029] The sales data generation unit 23 generates sales data including the sales date, business partner, type of transaction object (product type shown in Figures 5 and 6) and sales amount based on the sales input operation of the transaction object, and stores the data in the sales data storage unit 16.

[0030] The yield calculation result data generation unit 24 references the yield master table 11, in which the yields described above are stored, based on the type of commercial transaction object, and multiplies the sales amount for each transaction object for each customer and type of commercial transaction object by the yield corresponding to the type of commercial transaction object. As a result, the yield calculation result data generation unit 24 generates yield calculation result data including yield calculation result amounts equivalent to the payment amounts for each customer and each transaction object, and stores this in the yield calculation result storage unit 17 (see Figure 8).

[0031] The output control unit 22 outputs the step rate calculation result data stored in the step rate calculation result storage unit 17 to an output device. This step rate calculation result data may be output as a display output, a print output, or an audio output via a monitor device, a printer, or a speaker device, which are examples of the output device 7, or may be sent to the customer terminal device 51 via the communication interface unit 4 and the network 50 to disclose the step rate calculation result (payment amount: debt amount) to the customer.

[0032] The sales data generation unit 23 also stores the sales data generated based on the daily sales input operations in the sales data storage unit 16. The sales data generation unit 23 also generates sales data including the total sales amount totaled for each business partner and each commercial transaction object for a specified period (e.g., monthly) based on the sales date of each sales data (see FIG. 7).

[0033] The transaction data generation unit 25 generates first transaction data including each business partner, each transaction object, and the total sales amount corresponding to each business partner and each transaction object as a first transaction amount (see FIG. 10). The transaction data generation unit 25 also generates second transaction data for each business partner and each transaction object, including the debt amount, which is the amount to be paid to each business partner according to the commission rate, as a second transaction amount (see FIG. 12).

[0034] The scheduled payment total data generation unit 26 generates scheduled payment total data for each trading partner and each transaction object, which includes the amount obtained by subtracting the second transaction amount in the second transaction data from the first transaction amount in the first transaction data as the scheduled payment amount to each trading partner (see Figure 14).

[0035] In addition, the transaction data generation unit 25 generates at least the second transaction data by assigning a transaction number different from that of the first transaction data for each trading partner and each commercial transaction object (see the transaction numbers in Figures 10 and 12. The transaction number of the second transaction data is the transaction number shown in Figure 12).

[0036] The yield calculation result data generation unit 24 updates the transaction number of the yield calculation result data for each corresponding trading partner and each trading target with the transaction number of the second transaction data for each trading partner and each trading target (see the transaction number of the yield calculation result data in Figure 13).

[0037] (Daily sales recording) Next, a description will be given of the daily sales entry operation in the business support device 1 according to this embodiment. When it is time to enter daily sales, the person in charge manually enters the daily sales data via a sales entry screen (not shown). Note that sales data may also be imported in bulk from a predetermined sales file.

[0038] Based on the sales input by the person in charge, the sales data generation unit 23 generates sales data including the sales number, sales date, store name, customer (customer code and customer name), variety (variety code and variety name), product (product code and product name), sales quantity, and sales amount, as illustrated in Figure 7, and stores the data in the sales data storage unit 16.

[0039] The example in Figure 7 shows that 10 cucumbers, consigned for sale by "XX Corporation," were sold at the "Ginza Main Store" on "December 3, 2023," for a sales amount of 100 yen. The example in Figure 7 also shows that 5 eggplants, consigned for sale by "Producer A," were sold at the "Ginza Main Store" on "January 1, 2024," for a sales amount of 160 yen. The example in Figure 7 also shows that 3 carrots, consigned for sale by "Producer A," were sold at the "Akihabara Store" on "January 31, 2024," for a sales amount of 210 yen.

[0040] Once the daily sales data has been generated in this manner, the commission calculation result data generation unit 24 references the commission master table 11 shown in Figure 2 based on the client and product type to detect the commission rate corresponding to each client and product type. As shown in Figure 2, the commission rate for the "vegetable" product type of "XX Co., Ltd." is "90%," the commission rate when the "vegetable" product type of "Producer A" is sold at the "Ginza Main Store" is "80%, and the commission rate when the "vegetable" product type of "Producer A" is sold at the "Akihabara Store" is "70%."

[0041] For this reason, the commission rate calculation result data generation unit 24 multiplies the sales amount for each store, each customer, and each type of product by the corresponding commission rate, and calculates the commission rate calculation result amount corresponding to each store, each customer, and each type of product.

[0042] Specifically, in the example of FIG. 7, the sales amount for the "vegetable" variety of "XX Co., Ltd." is "100 yen," and the commission rate is "90%." Therefore, the commission rate calculation result data generation unit 24 calculates the commission rate calculation result amount of "90 yen" by calculating "sales amount 100 yen x commission rate 90%." Similarly, in the example of FIG. 7, the sales amount for the "vegetable" variety of "Producer A" at the "Ginza Main Store" is "200 yen," and the commission rate is "80%." Therefore, the commission rate calculation result data generation unit 24 calculates the commission rate calculation result amount of "160 yen" by calculating "sales amount 200 yen x commission rate 80%." Similarly, in the example of FIG. 7, the sales amount for the "vegetable" variety of "Producer A" at the "Akihabara Store" is "300 yen," and the commission rate is "70%." Therefore, the commission rate calculation result data generating unit 24 calculates the commission rate calculation result amount of "210 yen" by calculating "sales amount 300 yen x commission rate 70%".

[0043] The yield calculation result data generation unit 24 generates yield calculation result data including the sales number, sales date, store, transaction number, customer, variety, product, sales quantity, and the calculated yield calculation result amount, as shown in Figure 8, and stores it in the yield calculation result memory unit 17.

[0044] When a customer shown in Figure 1 inquires about the payment amount, the output control unit 22 reads the commission rate calculation result data corresponding to that customer from the commission rate calculation result storage unit 17 and transmits it to the customer terminal device 51 via the communication interface unit 4 and the network 50. This allows the customer to quickly disclose (inquire) the payment amount (debt amount). The commission rate calculation result data may be disclosed, for example, by sending it via email or by using a virtual table called a "View."

[0045] (Monthly sales booking) Next, the monthly sales accounting operation in the business support device 1 of this embodiment will be described. When it is time to account for monthly sales, the person in charge performs a designation operation to display a purchase lump sum accounting screen. When this designation operation is performed, the output control unit 22 displays the purchase lump sum accounting screen shown in FIG. 9 via the output device 7. On this purchase lump sum accounting screen, the person in charge inputs the business establishment for which purchase lump sum accounting will be performed, the accounting date, and the closing date, and also selects a positive or negative amount sign.

[0046] The example in Figure 9 is an example in which a "plus" amount code is used to specify the lump-sum accounting of purchases up to "January 31, 2024" for the "Tokyo Office" with the office code "A100." As a result, the sales data generation unit 23 aggregates the sales data for the "Tokyo Office" up to "January 31, 2024" from among the daily sales data stored in the sales data storage unit 16. As a result, for example, as shown in Figure 7, sales data for a sales amount of "100 yen" with sales number "U01," a sales amount of "200 yen" with sales number "U02," and a sales amount of "300 yen" with sales number "U03" are aggregated.

[0047] Next, the transaction data generation unit 25 generates first transaction data including a transaction amount (first transaction amount) that is the same as the sales amount of the aggregated sales data, as shown in Figure 10. Note that this first transaction data is the same as the aggregated sales data in terms of the transaction date, customer, store, and number of transactions, except for the transaction number. The first transaction amount is also "100 yen," "200 yen," or "300 yen," the same as the sales amount of the aggregated sales data.

[0048] 11, the transaction data generation unit 25 calculates a second transaction amount equivalent to the commission fee for the sales amount as a negative amount by calculating "(sales amount x (100% - commission rate)) x -1" based on the sales amount of the aggregated sales data. Then, the transaction data generation unit 25 generates second transaction data including the calculated negative second transaction amount by assigning a new transaction number different from the transaction number of the above-mentioned first transaction data, and stores the second transaction data in the transaction data storage unit 18.

[0049] Specifically, the transaction data generation unit 25 assigned transaction numbers "S01," "S02," and "S03" to the first transaction data shown in Figure 10, whereas it assigns new transaction numbers "S04," "S05," and "S06" to the second transaction data shown in Figure 12 that are different from "S01," "S02," and "S03."

[0050] Furthermore, the transaction data generation unit 25 generates second transaction data with a second transaction amount that is a minus amount equivalent to the commission fee corresponding to the commission rate of the sales amount. In the example of FIG. 12, the record with transaction number "S04" has a sales amount of "100 yen" and a commission rate of "90%." Therefore, the transaction data generation unit 25 calculates the second transaction amount by subtracting the commission fee from the sales amount by calculating "(sales amount 100 yen x (100% - commission rate 90%)) x -1 = -10 yen," and generates second transaction data that includes this.

[0051] 12, the details (record) for transaction number "S05" have a sales amount of "200 yen" and a commission rate of "80%." Therefore, the transaction data generation unit 25 calculates the second transaction amount by subtracting the commission fee from the sales amount by calculating "(sales amount 200 yen x (100% - commission rate 80%)) x -1 = -40 yen," and generates second transaction data including this.

[0052] 12, the record with transaction number "S06" details a sales amount of "300 yen" and a commission rate of "70%." Therefore, the transaction data generation unit 25 calculates a second transaction amount by subtracting the commission fee from the sales amount by calculating "(sales amount 300 yen x (100% - commission rate 70%)) x -1 = -90 yen," and generates second transaction data including this second transaction amount.

[0053] Next, total scheduled payment data generation unit 26 calculates the scheduled payment amount for each customer and each product type by subtracting the commission fee (= second transaction amount) from the sales amount (= first transaction amount) by subtracting the second transaction amount shown in Figure 12 from the first transaction amount shown in Figure 10. Total scheduled payment data generation unit 26 then generates scheduled payment data including the scheduled payment amount calculated for each customer and each product type, as shown in Figure 14, and stores this in total scheduled payment data storage unit 19.

[0054] Specifically, the sales amount of the product that was consigned for sale by "XX Corporation" and sold at the "Ginza Main Store" is "100 yen (first transaction amount)" as shown in Figure 10, and the minus amount of the consignment fee is "-10 yen (second transaction amount)" as shown in Figure 12. Therefore, the total scheduled payment data generation unit 26 calculates the "sales amount 100 yen + consignment fee (-10 yen)" to calculate the scheduled payment amount of "90 yen" for the product that was consigned for sale by "XX Corporation" and sold at the "Ginza Main Store", and generates total scheduled payment data including this and stores it in the total scheduled payment data storage unit 19, as shown in Figure 14.

[0055] Furthermore, the sales amount of the goods consigned for sale by "Producer A" and sold at the "Ginza Main Store" is "200 yen (first transaction amount)" as shown in Figure 10, and the minus amount of the commission fee is "-40 yen (second transaction amount)" as shown in Figure 12. Therefore, the total scheduled payment data generation unit 26 calculates the "sales amount 200 yen + commission fee (-40 yen)" to calculate the scheduled payment amount of "160 yen" for the goods consigned for sale by "Producer A" and sold at the "Ginza Main Store", and generates total scheduled payment data including this and stores it in the total scheduled payment data storage unit 19, as shown in Figure 14.

[0056] Furthermore, the sales amount of the goods consigned for sale by "Producer A" and sold at "Akihabara Store" is "300 yen (first transaction amount)" as shown in Figure 10, and the minus amount of the commission fee is "-90 yen (second transaction amount)" as shown in Figure 12. Therefore, the total scheduled payment data generation unit 26 calculates the "sales amount 300 yen + commission fee (-90 yen)" to calculate the scheduled payment amount of "210 yen" for the goods consigned for sale by "Producer A" and sold at "Akihabara Store", and generates total scheduled payment data including this and stores it in the total scheduled payment data storage unit 19, as shown in Figure 14.

[0057] In this way, debt information is recorded in a lump sum on a monthly basis, making it possible to record debt information without affecting the amount of data held.

[0058] Next, when the yield calculation result data generation unit 24 generates second transaction data including a second transaction amount equivalent to the commission fee shown in Figure 12, it updates each transaction number of the yield calculation result data corresponding to the trading partner, store, product type, etc. with each transaction number of this second transaction data.

[0059] Figure 11 is an example of the yield calculation result data before the transaction number is updated, and Figure 13 is an example of the yield calculation result data before the transaction number is updated. As can be seen by comparing Figures 11 and 13, each transaction number of the second transaction data is added to the corresponding yield calculation result data. This makes it possible to associate the yield calculation result data with the second transaction data indicating the commission fee, and makes it possible to disclose (inquire about) details such as sales amount, commission fee, and estimated payment amount for each store and product type to business partners.

[0060] (Effects of the embodiment) As is clear from the above explanation, the business support device 1 of the embodiment can make information available to business partners by retaining amount information calculated from business partner information, quantity, and commission rate information (commission sales commission) for each item when recording sales.

[0061] Furthermore, debt information can be recorded in a lump sum on a monthly basis, so that debt information can be recorded without affecting the amount of data held.

[0062] In addition, by linking each item to a summary payable slip, it is possible to disclose the item information and payment information to business partners in association with each other.

[0063] In addition, when conducting sales consignment business, sales data is aggregated after taking into account the commission calculation rate, and payable slips to each supplier can be recorded in a lump sum. In this case, by retaining each item of purchase performance information (commission fees) separately from the payable slips until the lump sum is calculated, it is possible to disclose information at the item level to business partners.

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

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

[0066] Furthermore, the present invention can contribute to strengthening control and governance, thereby contributing to the achievement of Goal 16 of the SDGs.

[0067] [Other embodiments] The present invention can be implemented in various different forms other than the above-described embodiments within the scope of the technical concept described in the claims.

[0068] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically may be performed manually, or all or part of the processes described as being performed manually may be performed automatically using a known method or the like.

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

[0070] Furthermore, the components of the business support device 1 shown in the figure are conceptual functional components and do not necessarily have to have the physical configuration shown in the figure. For example, all or any part of the processing functions of the business support device 1, particularly the processing functions performed by the control unit 3, may be realized by a program interpreted and executed by the control unit 3 (CPU: Central Processing Unit), or may be realized by hardware using wired logic.

[0071] 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 the embodiments, and is mechanically read by the business support device 1 as needed. That is, a computer program is recorded in the storage unit 2, such as a ROM or HDD, for working with an OS (Operating System) to give instructions to a control unit 3 (CPU) and perform various processes. The computer program is loaded into RAM, expanded, and executed by the control unit 3 as appropriate.

[0072] In addition, the business support program of this business support device 1 may be stored in another server device connected to the business support device 1 via any network, and all or part of it may be downloaded and executed as needed.

[0073] Furthermore, the business support program for executing the processes described in the embodiments may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product.

[0074] Here, the "recording medium" can be any "portable physical medium" such as a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), an EEPROM (registered trademark) (Electrically Erasable and Programmable Read Only Memory), a CD-ROM (Compact Disk Read Only Memory), an MO (Magneto-Optical Disk), a DVD (Digital Versatile Disk), and a Blu-ray (registered trademark) Disc.

[0075] 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.

[0076] It should be noted that a "program" is not necessarily limited to a single structure, but includes a structure that is distributed as multiple modules or libraries, and a structure that achieves its function by working together with other programs, such as an OS.

[0077] Furthermore, the specific configuration for reading the recording medium in the task support device 1 of the embodiment, the reading procedure, and the installation procedure after reading can be any known configuration or procedure.

[0078] The memory unit 2 is a storage means such as a memory device such as RAM or ROM, a fixed disk device such as a hard disk, a flexible disk, or an optical disk, and stores various programs, tables, databases, web page files, etc. used for various processes or to provide websites.

[0079] The business support device 1 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as an information processing device connected to any peripheral device. The information processing device may be implemented with software (including programs or data) that realizes the processes described in the embodiments.

[0080] Furthermore, the specific forms of distribution and integration of the devices are not limited to those shown in the drawings, and all or part of them can be functionally or physically distributed or integrated in any unit depending on various additions or functional loads. In other words, the above-mentioned embodiments can be selectively implemented by combining them in any way. [Industrial Applicability]

[0081] The present invention is suitable for application to the management of payments (debt amounts) to business partners in sales consignment business. [Explanation of symbols]

[0082] 1 Business support equipment 2 Storage section 3. Control Unit 4. Communication interface section 5 Input / output interface section 6 Input Devices 7 Output Devices 11. Pound rate master table 12 Customer Master Table 13 Store Master Table 14 Product Master Table 15 Product Master Table 16 Sales data storage section 17 Strate calculation result storage unit 18 Transaction data storage unit 19 Total payment schedule data storage section 21 Data Generation Unit 22 Output control section 23 Sales Data Generation Department 24. Step rate calculation result data generation unit 25 Transaction data generation unit 26 Total payment schedule data generation section 50 Network 51 Customer terminal equipment

Claims

1. a sales data generating unit that generates sales data including a sales date, a customer, a type of transaction object, and a sales amount based on a sales input operation of the transaction object, and stores the sales data in a sales data storage unit; a commission rate calculation result data generation unit that references a commission rate master table that stores commission rates, which are set at least for each customer and each type of commercial transaction object, based on the type of commercial transaction object, and that multiplies the sales amount of the commercial transaction object for each customer and each type of commercial transaction object by the commission rate corresponding to the type of commercial transaction object, to generate commission rate calculation result data including a commission rate calculation result amount equivalent to the payment amount for each customer and each type of commercial transaction object, and stores the calculated data in a commission rate calculation result storage unit; an output control unit that outputs the step rate calculation result data stored in the step rate calculation result storage unit to an output device; A business support device having the above.

2. the sales data generation unit stores the sales data generated based on the daily sales input operation in the sales data storage unit, and generates sales data including an aggregated sales amount for each of the business partners and each of the commercial transaction objects for a specified period based on the sales date of each of the sales data; a transaction data generation unit that generates first transaction data including, as a first transaction amount, each of the business partners, each transaction object, and the aggregated sales amount corresponding to each of the business partners and each of the transaction objects, and also generates second transaction data for each of the business partners and each of the transaction objects, including, as a second transaction amount, a debt amount that is an amount to be paid to each of the business partners according to the commission rate; a total payment schedule data generating unit that generates, for each of the trading partners and each of the commercial transaction targets, total payment schedule data including an amount obtained by subtracting the second transaction amount of the second transaction data from the first transaction amount of the first transaction data as a payment schedule amount to each of the trading partners; 2. The business support device according to claim 1, wherein:

3. the transaction data generation unit generates at least the second transaction data by assigning a transaction number different from that of the first transaction data to each of the trading partners and each of the commercial transaction objects; the yield calculation result data generation unit updates the transaction numbers of the yield calculation result data of the corresponding trading partners and the corresponding trading objects with the transaction numbers of the second transaction data of the corresponding trading partners and the corresponding trading objects; 3. The business support device according to claim 2, wherein:

4. a sales data generation step in which a sales data generation unit generates sales data including a sales date, a business partner, a type of commercial transaction object, and a sales amount based on a sales input operation of the commercial transaction object, and stores the sales data in a sales data storage unit; a commission rate calculation result data generation step in which the commission rate calculation result data generation unit references a commission rate master table in which commission rates, which are set at least for each customer and each type of commercial transaction object and are the ratio of the amount paid to each customer to the total sales amount, are stored based on the type of commercial transaction object, and generates commission rate calculation result data including commission rate calculation result amounts equivalent to the amount paid for each customer and each type of commercial transaction object, calculated by multiplying the sales amount of the commercial transaction object for each customer and each type of commercial transaction object by the commission rate corresponding to the type of commercial transaction object, and stores the generated commission rate calculation result data in the commission rate calculation result storage unit; an output control step in which an output control unit outputs the step rate calculation result data stored in the step rate calculation result storage unit to an output device; A business support method having the above.

5. Computer, a sales data generating unit that generates sales data including a sales date, a customer, a type of transaction object, and a sales amount based on a sales input operation of the transaction object, and stores the sales data in a sales data storage unit; a commission rate calculation result data generation unit that references a commission rate master table that stores commission rates, which are set at least for each customer and each type of commercial transaction object, based on the type of commercial transaction object, and that multiplies the sales amount of the commercial transaction object for each customer and each type of commercial transaction object by the commission rate corresponding to the type of commercial transaction object, to generate commission rate calculation result data including a commission rate calculation result amount equivalent to the payment amount for each customer and each type of commercial transaction object, and stores the calculated data in a commission rate calculation result storage unit; an output control unit that outputs the step rate calculation result data stored in the step rate calculation result storage unit to an output device; A business support program that functions as a

Images