Return amount calculation device, return amount calculation method, and return amount calculation program

Abstract

To provide a returned commodity amount calculation device, a returned commodity amount calculation method and a returned commodity amount calculation program capable of reducing business hours and input errors while counting returned commodities by a simple operation.SOLUTION: A return amount calculation apparatus of the present embodiment refers to sales result data, extracts sales result extraction data according to a designated period and a return accounting reference date, aggregates the number of sales and the total number of sales obtained by adding up each number of sales for each sales unit price of the sales result extraction data, calculates a ratio of the number of sales for each sales unit price to the total number of sales, and calculates a return amount by adding up amounts obtained by multiplying a value obtained by proportionally dividing an input return quantity of commodities by the ratio of the number of sales for each sales unit price by an amount for each sales unit price.SELECTED DRAWING: Figure 1

Description

[Technical Field]

[0001] The present invention relates to a return amount calculation device, a return amount calculation method, and a return amount calculation program. [Background technology]

[0002] Patent document 1 discloses a sales data processing device that determines whether the price of the returned product has been entered when processing a return, and does not execute the return processing if the price of the returned product has not been entered. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Publication No. 3-223997 Summary of the Invention [Problem to be solved by the invention]

[0004] In general, the return amount in return processing is calculated based on the original sales data. Therefore, in conventional technologies such as the one described in Patent Document 1, when calculating the return amount based on a certain date, the party receiving the returned goods must identify the sales slip each time and process the return. This work places a heavy burden on the person in charge of data entry, and a technology that can perform this work easily has been desired.

[0005] Furthermore, when accepting a large number of returns at once, the process of identifying past sales slips and entering returned items requires an enormous amount of work for the data entry staff, making the process cumbersome and resulting in errors when transcribing identified sales slip numbers.

[0006] The present invention has been made in consideration of the above, and aims to provide a return amount calculation device, a return amount calculation method, and a return amount calculation program that can record returned products with simple operations, while reducing work time and input errors. [Means for solving the problem]

[0007] In order to solve the above-mentioned problems and achieve the object, the return amount calculation device of the present invention is a return amount calculation device that has a control unit and is able to access sales performance data that corresponds at least to a product code, sales date, shipping date, delivery date, inspection date, sales unit price, sales quantity, and sales amount for each sales number, and the control unit has an extraction unit that references the sales performance data and extracts sales performance extracted data according to a specified period and return recording reference date, an aggregation unit that aggregates the sales quantity for each sales unit price of the sales performance extracted data extracted by the extraction unit and a total sales number by adding up each sales quantity, a ratio calculation unit that calculates the ratio of the sales quantity for each sales unit price to the total sales number, and a return amount calculation unit that calculates the return amount by adding up the amount obtained by multiplying the value obtained by apportioning the returned quantity of the input product based on the ratio of the sales quantity for each sales unit price by the amount for each sales unit price.

[0008] Furthermore, the return amount calculation method according to the present invention is a return amount calculation method executed by a return amount calculation device having a control unit, wherein the return amount calculation device can access actual sales data which associates at least a product code, a sales date, a shipping date, a delivery date, an inspection date, a sales unit price, a sales quantity, and a sales amount for each sales number, and is characterized by including the following steps executed by the control unit: an extraction step which references the actual sales data and extracts actual sales data corresponding to a specified period and a return recording reference date; an aggregation step which aggregates the sales quantity for each sales unit price of the actual sales data extracted in the extraction step and a total sales number by adding up each sales quantity; a proportion calculation step which calculates the proportion of the sales quantity for each sales unit price to the total sales number; and a return amount calculation step which calculates the return amount by adding up the amounts obtained by multiplying the value obtained by apportioning the returned quantity of the input product based on the proportion of the sales quantity for each sales unit price by the amount for each sales unit price.

[0009] Furthermore, the return amount calculation program of the present invention is a return amount calculation program to be executed by a return amount calculation device having a control unit, wherein the return amount calculation device is capable of accessing actual sales data that associates at least a product code, sales date, shipping date, delivery date, inspection date, unit sales price, sales quantity, and sales amount for each sales number, and causes the control unit to execute the following steps: an extraction step of referencing the actual sales data and extracting actual sales data corresponding to a specified period and return accounting reference date; an aggregation step of aggregating the sales quantity for each unit sales price of the actual sales data extracted in the extraction step and a total sales number by adding up each sales quantity; a proportion calculation step of calculating the proportion of the sales quantity for each unit sales price to the total sales number; and a return amount calculation step of calculating the return amount by adding up the amounts obtained by multiplying the value obtained by apportioning the returned quantity of the input product by the proportion of the sales quantity for each unit sales price by the amount for each unit sales price. [Effects of the Invention]

[0010] According to the present invention, it is possible to record returned products with simple operations, while reducing work time and input 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 returned goods amount calculation device according to an embodiment. [Figure 2] FIG. 2 is a diagram illustrating an example of a sales performance data table of sales performance data stored in the storage unit of the returned goods amount calculation device according to the embodiment. [Figure 3] FIG. 3 is a diagram illustrating an example of a sales reference master table in the sales reference master stored in the storage unit of the returned goods amount calculation device according to the embodiment. [Figure 4] FIG. 4 is a diagram illustrating an example of a return item recording reference date master table in the return item recording reference date master stored in the storage unit of the return item amount calculation device according to the embodiment. [Figure 5]FIG. 5 is a flowchart showing an outline of the process executed by the returned goods amount calculation device according to the embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a basic information screen displayed on the monitor. [Figure 7] FIG. 7 is a diagram showing an example of a return product entry screen displayed on the monitor. [Figure 8] FIG. 8 is a diagram for schematically explaining an outline of the extraction process performed by the extraction unit included in the control unit of the returned goods amount calculation device according to the embodiment. [Figure 9] FIG. 9 is a diagram for schematically explaining an outline of the tallying process by the tallying unit included in the control unit of the returned goods amount calculation device according to the embodiment. [Figure 10] FIG. 10 is a diagram for schematically explaining an outline of the percentage calculation process performed by the percentage calculation unit included in the control unit of the returned goods amount calculation device according to the embodiment. [Figure 11] FIG. 11 is a diagram for schematically explaining an outline of the return amount calculation process performed by the return amount calculation unit included in the control unit of the return amount calculation device according to the embodiment. [Figure 12] FIG. 12 is a diagram showing an example of a return product entry screen displayed on the monitor. [Figure 13] FIG. 13 is a diagram for schematically explaining another outline of the extraction process by the extraction unit included in the control unit of the returned goods amount calculation device according to the embodiment. [Figure 14] FIG. 14 is a diagram for schematically explaining another outline of the tallying process by the tallying unit included in the control unit of the returned goods amount calculation device according to the embodiment. [Figure 15] FIG. 15 is a diagram for schematically explaining another overview of the percentage calculation process by the percentage calculation unit included in the control unit of the returned goods amount calculation device according to the embodiment. [Figure 16] FIG. 16 is a diagram for schematically explaining another outline of the return amount calculation process performed by the return amount calculation unit included in the control unit of the return amount calculation device according to the embodiment. DETAILED DESCRIPTION OF THE INVENTION

[0012] Hereinafter, embodiments of a return amount calculation device, a return amount calculation method, and a return amount calculation program according to the present invention will be described in detail with reference to the accompanying drawings. Note that the present invention is not limited to these embodiments.

[0013] [1. Configuration] An example of the configuration of a return amount calculation 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 return amount calculation device.

[0014] 1 is a commercially available desktop personal computer. Note that the returned goods amount calculation device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0015] The returned goods amount calculation device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the returned goods amount calculation 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 communicatively connects the return amount calculation device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the return amount calculation 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 the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The storage unit 106 can be, for example, a memory device such as RAM (Random Access Memory) or 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 actual sales data 106a, a sales criteria master 106b, and a returned goods accounting reference date master 106c.

[0019] Sales performance data 106a stores sales numbers in association with store codes, product codes, product names, sales dates, shipping dates, inspection dates, sales prices, P / S classifications (P: regular price (proper), S: special price (sale)), sales quantities, and sales amounts.

[0020] 2 is a diagram showing an example of a sales performance data table in the sales performance data 106a. As shown in the first row of the sales performance data table T1 shown in Fig. 2, the sales number "U001" is stored in association with the store code "T002," the product code "S001," the product name "Koshihikari 10kg," the sales date "2024 / 04 / 01," the shipping date "2024 / 04 / 01," the delivery date "2024 / 04 / 02," the inspection date "2024 / 04 / 16," the sales price "10,000," the P / S classification "P," the sales quantity "15," and the sales amount "15,000" (15 x 10,000).

[0021] The sales standard master 106b stores a standard code indicating a sales date standard in association with a standard date.

[0022] 3 is a diagram showing an example of a sales criteria master table in the sales criteria master 106b. As shown in the first row of the sales criteria master table T2 shown in FIG. 3, the reference code "0" is stored in association with the reference date "shipment reference."

[0023] The return product recording base date master 106c stores designated dates in association with designated date codes indicating return product recording base dates.

[0024] 4 is a diagram showing an example of a return item recording reference date master table in the return item recording reference date master 106c. As shown in the first row of the return item recording reference date master table T3 shown in FIG. 4, the designated date "sales date" is stored in association with the designated date code "0."

[0025] Returning to FIG. 1, the description of the configuration of the returned goods amount calculation device 100 will continue. The control unit 102 is a CPU or the like that controls the return amount calculation device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing operations based on these stored programs. The control unit 102 includes a display control unit 102a, an extraction unit 102b, a counting unit 102c, a ratio calculation unit 102d, and a return amount calculation unit 102e.

[0026] The display control unit 102a displays a basic information screen for setting the sales recording reference date and the returned goods recording reference date on the monitor 114. The display control unit 102a also displays on the monitor 114 the return price of the returned goods calculated by the returned goods price calculation unit 102e, which will be described later.

[0027] The extraction unit 102b refers to the sales performance data 106a and executes an extraction process to extract sales performance extraction data corresponding to a specified date.

[0028] The tallying unit 102c executes a tallying process of tallying the number of sales for each unit sales price of the sales result extraction data extracted by the extraction unit 102b and the total number of sales obtained by adding up all the sales numbers.

[0029] The ratio calculation unit 102d executes a ratio calculation process for calculating the ratio of the sales volume for each sales price to the total number.

[0030] The return amount calculation unit 102e executes a return amount calculation process to calculate the return amount for each sales price by multiplying the value obtained by dividing the return quantity of the product entered on the return input screen P2 by the ratio of the sales volume for each sales price by the sales price.

[0031] [2. Processing performed by the return amount calculation device] Next, a description will be given of the processing executed by the returned goods amount calculation device 100. Fig. 5 is a flowchart showing an outline of the processing executed by the returned goods amount calculation device 100.

[0032] As shown in FIG. 5, first, the display control unit 102a displays a basic information screen for setting the sales recording base date and the returned goods recording base date on the monitor 114 (step S101).

[0033] Fig. 6 is a diagram showing an example of a basic information screen displayed by monitor 114. The basic information setting screen P1 shown in Fig. 6 includes a sales recording standard input cell A1 into which the user operates input unit 13 to input a standard code for specifying the sales recording standard, and a return recording standard date input cell A2 into which a specified date code for specifying the return recording standard date is input. In the example shown in Fig. 6, the user operates input unit 13 to input "0" into sales recording standard input cell A1 and "0" into return recording standard date input cell A2.

[0034] Returning to FIG. 5, the description of step S102 and subsequent steps will be continued. In step S102, the extraction unit 102b executes a process for setting the sales recording standard and the return recording base date for processing returns based on the standard code entered in the sales recording standard input cell A1 and the specified date code entered in the return recording base date input cell A2 on the basic information setting screen P1, the sales standard master table T2 stored in the sales standard master 106b, and the return recording base date master table T3 stored in the return recording base date master 106c. In the example shown in FIG. 6, because "0" has been entered in the sales recording standard input cell A1, the extraction unit 102b sets the sales recording standard to "shipment standard." Furthermore, because "0" has been entered in the return recording base date input cell A2, the extraction unit 102b sets the return recording base date to "sales date."

[0035] Next, the display control unit 102a causes the monitor 114 to display a return product input screen for the user to operate the input unit 13 and input a predetermined store, period, product, and return quantity (step S103).

[0036] Figure 7 is a diagram showing an example of a return goods input screen displayed on the monitor 114. The return goods input screen P2 shown in Figure 7 includes a store input cell A10 for inputting a store code to specify a store, a period input cell A11 for inputting a period for performing return processing, a product input cell A12 for inputting a product code to specify a product, a return quantity input cell A13 for inputting a return quantity, an execute button A14 for inputting instructions for calculating the return amount for return processing, and a display area R1 in which the return amount for return processing is displayed.

[0037] As shown in FIG. 7, the user operates the input unit 13 to input the store, period, product, and return quantity for returning goods. Specifically, the user operates the input unit 13 to input "T002" into the store input cell A10, "2024 / 04 / 01" and "2024 / 04 / 30" into the period input cell A11, "S001" into the product input cell A12, and "30" into the return quantity input cell A13. In this case, the display control unit 102a references the sales performance data 106a or a store master (not shown) that associates store names with store codes and a product master (not shown) that associates product names with product codes, and causes the return input screen P2 to display "Ginza Store" linked to the store code "T002" entered into the store input cell A10 and "Koshihikari 10kg" linked to the product code "S001" entered into the product input cell A12. This allows the user to intuitively grasp the store name linked to the store code and the product name linked to the product code entered without having to check a slip or the like.

[0038] Returning to FIG. 5, the description of step S104 and subsequent steps will be continued. In step S104, if the user operates the input unit 13 to press the execute button A14 (step S104: Yes), the returned goods amount calculation device 100 proceeds to step S105, which will be described later. On the other hand, if the user does not operate the input unit 13 to press the execute button A14 (step S104: No), the returned goods amount calculation device 100 returns to step S103.

[0039] In step S105, the extraction unit 102b refers to the sales performance data 106a and executes an extraction process to extract sales performance data corresponding to the specified date.

[0040] 8 is a diagram illustrating an outline of the extraction process performed by the extraction unit 102b. As shown in FIG. 8, the extraction unit 102b executes extraction process by referencing the sales performance data 106a, extracting sales performance data corresponding to a specified date, and generating sales performance extraction data. Specifically, the extraction unit 102b extracts sales performance extraction data (see sales performance extraction data table T11 in FIG. 8) from the sales performance data (see sales performance data table T10 in FIG. 8) for the store code "T002," the product code "S001," and the sales dates that fall within the range from the start date "2024 / 04 / 01" to the end date "2024 / 04 / 30" input in FIG. 7 described above, from the sales performance data table T1 (see FIG. 2) in the sales performance data 106a.

[0041] Returning to FIG. 5, the description of step S106 and subsequent steps will be continued. In step S106, the counting unit 102c executes a counting process to count the number of sales for each unit sales price of the sales result extraction data extracted by the extraction unit 102b and the total number of sales obtained by adding up all the sales numbers.

[0042] FIG. 9 is a diagram illustrating an outline of the aggregation process performed by the aggregation unit 102c. As shown in FIG. 9, the aggregation unit 102c executes aggregation processing to aggregate the sales volume and the total sales volume by adding up each sales volume for each unit sales price in the actual sales result extraction data table T11 extracted by the extraction unit 102b. Specifically, the aggregation unit 102c aggregates the sales volume for each unit price of "10,000," "8,000," "7,500," and "7,000." For example, for a unit price of "10,000," the aggregation unit 102c aggregates the sales volume to "55." Then, the aggregation unit 102c calculates an aggregate total of "130" by adding up each sales volume for all unit sales prices.

[0043] Returning to FIG. 5, the description of step S107 and subsequent steps will be continued. In step S107, the ratio calculation unit 102d executes a ratio calculation process to calculate the ratio of the sales volume for each sales price to the total number.

[0044] Fig. 10 is a diagram for schematically explaining an outline of the ratio calculation process by the ratio calculation unit 102d. As shown in Fig. 10, the ratio calculation unit 102d executes the ratio calculation process to calculate the ratios "0.423077", "0.115385", "0.076923", and "0.384615" of the sales volume for each unit sales price "55", "15", "10", and "50" to the total count "130", and generates the ratio calculation table T13.

[0045] Returning to FIG. 5, the description of step S108 and subsequent steps will be continued. In step S108, the return amount calculation unit 102e executes a return amount calculation process to calculate the return amount for each sales price by multiplying the value obtained by dividing the return quantity of the product entered on the return input screen P2 by the ratio of the sales volume for each sales price by the sales price.

[0046] 11 is a diagram illustrating an outline of the return amount calculation process performed by the return amount calculation unit 102e. As shown in FIG. 11, the return amount calculation unit 102e calculates the return amounts for each unit sales price of "126923.077", "27692.308", "17307.692", and "80769.231" by multiplying the return quantities "12.6923", "3.46154", "2.30769", and "11.5385" that are obtained by prorating the return quantity "30" of the product entered on the return input screen P2 by the sales unit price ratios "0.423077", "0.115385", "0.076923", and "0.384615" by the unit sales prices "10,000", "8,000", "7,500", and "7,000". Next, the return amount calculation unit 102e calculates the total amount of returned goods, "252,692.308", by adding up the respective return amounts. In this case, the return amount calculation unit 102e calculates the return amount of "252,692" by rounding off to the first decimal place.

[0047] Returning to FIG. 5, the description of step S109 and subsequent steps will be continued. In step S109, the display control unit 102a displays the return price of the returned product calculated by the return price calculation unit 102e in the display area R1 of the return product entry screen P2.

[0048] Fig. 12 is a diagram showing an example of the return goods input screen P2 displayed on the monitor 114. As shown in Fig. 12, the display control unit 102a displays the return amount of the returned product, "252,692", calculated by the return amount calculation unit 102e, in the display area R1 of the return goods input screen P2. This allows the user to intuitively grasp the return amount of the returned product with a simple operation.

[0049] Returning to FIG. 5, the description of step S110 and subsequent steps will be continued. In step S110, if the user operates the input unit 13 to perform an end operation to end the returned goods amount processing (step S110: Yes), the returned goods amount calculation device 100 ends this processing. On the other hand, if the user does not operate the input unit 13 to perform an end operation to end the returned goods amount processing (step S110: No), the returned goods amount calculation device 100 returns to step S101.

[0050] [3. Other processes performed by the return amount calculation device] Here, we will explain a case where the user sets the return accounting reference date to another specified date, for example, the inspection date, in the processing by the return amount calculation device 100. Specifically, we will explain a case where the user operates the input unit 13 to select and set "3" in the return accounting reference date input cell A2 on the basic information setting screen P1 in Figure 6 described above.

[0051] 13 is a diagram illustrating another outline of the extraction process performed by the extraction unit 102b. As shown in FIG. 13, the extraction unit 102b executes extraction process by referencing actual sales data 106a and extracting actual sales data corresponding to a specified date to generate actual sales data. Specifically, the extraction unit 102b extracts actual sales data (see actual sales data table T21 in FIG. 13) from actual sales data table T1 (see FIG. 2) in the sales data 106a, including the store code "T002," the product code "S001," and the sales data (see actual sales data table T20 in FIG. 13) for the inspection date that falls within the range of the start date "2024 / 04 / 01" to the end date "2024 / 04 / 30."

[0052] FIG. 14 is a diagram illustrating another outline of the aggregation process performed by the aggregation unit 102c. As shown in FIG. 14, the aggregation unit 102c executes aggregation processing to aggregate the sales figures and total sales figures by unit price in the actual sales result extraction data table T21 extracted by the extraction unit 102b. Specifically, the aggregation unit 102c aggregates the sales figures for each unit price of "10,000," "8,000," "7,500," and "7,000." For example, for a unit price of "10,000," the aggregation unit 102c aggregates the sales figure to "55." The aggregation unit 102c then aggregates the sales figures for all unit prices to calculate an aggregate total of "105."

[0053] Fig. 15 is a diagram illustrating another outline of the percentage calculation process by the percentage calculation unit 102d. As shown in Fig. 15, the percentage calculation unit 102d executes the percentage calculation process to calculate the percentages of the sales volume for each of the unit sales prices "55," "15," "10," and "25" to the total count "105," that is, "0.5238095" (for example, 55÷105=0.5238095), "0.1428571," "0.0952381," and "0.2380952," and generates the percentage calculation table T23.

[0054] FIG. 16 is a diagram for explaining another outline of the return amount calculation process by the return amount calculation unit 102e. As shown in FIG. 16, the return amount calculation unit 102e calculates the return amounts for each unit sales price of "157142.857", "34285.714", "21428.571", and "50000.000", by multiplying the return quantities "15.7143", "4.28571", "2.85714", and "7.14286", which are the values ​​obtained by apportioning the return quantity "30" of the product entered on the return input screen P2 by the sales unit price ratios "0.5238095", "0.1428571", "0.0952381", and "0.2380952", respectively, by the unit sales prices "10,000", "8,000", "7,500", and "7,000". The return amount calculation unit 102e calculates the total return amount of "262,857.143" by adding up the respective return amounts. In this case, the return amount calculation unit 102e calculates the return amount of "262,857" by rounding to the first decimal place. The display control unit 102a then displays the return amount of the returned items, "262,857," calculated by the return amount calculation unit 102e, in the display area R1 of the return entry screen P2.

[0055] In this way, the return amount calculation device 100 can select the sales accounting standard from any one of the shipping standard, arrival standard, and inspection standard, and can also select the return accounting standard date from any one of the sales date, shipping date, delivery date, and inspection date, so that the user can easily calculate the return amount based on the standard they desire and on a specified date with simple operations.

[0056] According to the embodiment described above, the return amount calculation unit 102e executes a return amount calculation process in which the return quantity of the product entered on the return input screen P2 is apportioned in proportion to the sales volume for each sales price, and the result is multiplied by each sales price to calculate the return amount for each sales price. Therefore, by storing the unit price at the time of sale in the actual sales data 106a, the return amount can be easily calculated with a single simple operation based on the past unit price without specifying the original data.

[0057] Furthermore, according to the embodiment, the display control unit 102a displays the return amount in the display area R1 of the return item entry screen P2, so that the user can intuitively grasp the return amount.

[0058] Furthermore, according to the embodiment, the extraction unit 102b extracts actual sales data from the actual sales data 106a according to the return accounting reference date and period specified by the user, which is either the sales date, shipping date, delivery date, or inspection date, so that the return amount can be easily calculated based on the return accounting reference date desired by the user.

[0059] Furthermore, according to the embodiment, the user can calculate the return amount with a single input operation, thereby reducing the work time required to record returns on a sales slip basis and reducing input errors.

[0060] Furthermore, according to the embodiment, even if the actual sales data 106a includes items with the same product code but different sales prices during a specified period, the return amount calculation unit 102e calculates the return amount for each sales price by multiplying the value obtained by dividing the return quantity of the product entered on the return input screen P2 by the ratio of the sales volume for each sales price, thereby making it possible to calculate an appropriate past unit price, which can contribute to further improving business productivity.

[0061] In the embodiment, the extraction unit 102b extracts the sales actual data (see sales actual data table T11 in FIG. 8) from the sales actual data table T1 (see FIG. 2) in the sales actual data 106a, including the store code "T002," the product code "S001," and the sales dates that fall within the range of the start date "2024 / 04 / 01" to the end date "2024 / 04 / 30" entered in FIG. 7 (see sales actual data table T10 in FIG. 8). However, the present invention is not limited to this and can be modified as appropriate. Specifically, the store code and product code are not required, and the extraction unit 102b may extract only data that fall within a period designated by the user from the sales actual data table T1. Of course, the extraction unit 102b may also extract data that fall within each of the product codes and periods designated by the user from the sales actual data table T1.

[0062] [4. 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.

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

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

[0065] 5. 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.

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

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

[0068] Furthermore, with regard to the returned goods amount calculation device 100, the components shown in the figures are functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.

[0069] For example, all or any part of the processing functions of the returned goods amount calculation 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 returned goods amount calculation 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.

[0070] This computer program may also be stored in an application program server connected to the returned goods amount calculation device 100 via any network, and all or part of it may be downloaded as needed.

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

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

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

[0074] The returned goods amount calculation device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as an information processing device connected to any peripheral device. The returned goods amount calculation device 100 may be realized by installing software (including programs or data) that causes the device to perform the processing described in this embodiment.

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

[0076] The present invention is useful in the wholesale industry or trading companies in general where there is a return business. [Explanation of symbols]

[0077] 100 Return amount calculation device 102 Control section 102a Display control unit 102b Extraction part 102c Aggregation Unit 102d Percentage calculation section 102e Return amount calculation section 104 Communication interface unit 106 Storage section 106a Sales performance data 106b Sales Standard Master 106c Return Accounting Reference Date Master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A return amount calculation device including a control unit, For each sales number, it is possible to access sales performance data that associates at least the product code, sales date, shipping date, delivery date, inspection date, sales unit price, sales quantity, and sales amount, The control unit an extraction unit that refers to the sales performance data and extracts sales performance extraction data corresponding to a designated period and a return recording reference date; a counting unit that counts the number of sales for each unit sales price of the sales performance extracted data extracted by the extraction unit and a total number of sales obtained by adding up each number of sales; a ratio calculation unit that calculates a ratio of the number of sales for each sales price to the total number of sales; a return amount calculation unit that calculates a return amount by adding up the amount obtained by dividing the input return quantity of the product proportionally based on the ratio of the sales volume for each sales price and multiplying the amount by the amount for each sales price; Equipped with Return amount calculation device.

2. 2. The return amount calculation device according to claim 1, The control unit a display control unit that displays the return amount on a monitor; Further provided with Return amount calculation device.

3. 3. The return amount calculation device according to claim 2, The return accounting reference date is It can be the sales date, shipping date, delivery date, or inspection date. The extraction unit extracting the sales performance extracted data from the sales performance data according to the return accounting reference date and the period, which is specified as one of the sales date, shipping date, delivery date, and inspection date; Return amount calculation device.

4. 4. The return amount calculation device according to claim 3, The extraction unit extracting the sales performance extraction data corresponding to the designated product code from the sales performance data; Return amount calculation device.

5. 5. The return amount calculation device according to claim 4, The extraction unit extracting the extracted sales performance data from the sales performance data in accordance with a sales accounting standard designated as one of a shipping standard, an arrival standard, and an inspection standard; Return amount calculation device.

6. 6. The return amount calculation device according to claim 5, The sales performance data is Including items with the same product code but different sales prices, Return amount calculation device.

7. 7. The return amount calculation device according to claim 6, The sales performance data is Each sales number is further associated with a store code. The extraction unit further extracting the sales performance extracted data corresponding to the designated store code from the sales performance data; Return amount calculation device.

8. A return amount calculation method executed by a return amount calculation device having a control unit, The return amount calculation device For each sales number, it is possible to access sales performance data that associates at least the product code, sales date, shipping date, delivery date, inspection date, sales price, sales quantity, and sales amount, Executed by the control unit, an extraction step of referring to the sales performance data and extracting sales performance extraction data corresponding to a specified period and a return recording reference date; a counting step of counting the number of sales for each unit sales price of the sales performance extracted data extracted in the extraction step and a total number of sales obtained by adding up each number of sales; a ratio calculation step of calculating a ratio of the number of sales for each sales unit price to the total number of sales; a return amount calculation step of calculating a return amount by adding up the amount obtained by dividing the input return quantity of the product proportionally based on the ratio of the sales volume for each sales price and multiplying the amount by the amount for each sales price; containing, A method for calculating a return amount, characterized by:

9. A return amount calculation program to be executed by a return amount calculation device having a control unit, The return amount calculation device For each sales number, it is possible to access sales performance data that associates at least the product code, sales date, shipping date, delivery date, inspection date, sales price, sales quantity, and sales amount, The control unit an extraction step of referring to the sales performance data and extracting sales performance extraction data corresponding to a specified period and a return recording reference date; a counting step of counting the number of sales for each unit sales price of the sales performance extracted data extracted in the extraction step and a total number of sales obtained by adding up each number of sales; a ratio calculation step of calculating a ratio of the number of sales for each sales unit price to the total number of sales; a return amount calculation step of calculating a return amount by adding up the amount obtained by dividing the input return quantity of the product proportionally based on the ratio of the sales volume for each sales price and multiplying the amount by the amount for each sales price; To execute the A return amount calculation program characterized by the above.

Images