JP2012128602A - Sales management device, sales management system, control method and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To perform sales management in connection with returned goods in a system selling a large number of goods that change frequently.SOLUTION: If return information exists in entrustment information indicating past transactions with entrustee or in sales information of the company, the sales management device 104, receiving the return information from a handy terminal 102 and storing the information, performs sales management by calculating the number of goods that can be recorded as returned ones, out of the number of entrusted goods in the entrustment information or the number of sold goods in the sales information, and by automatically reconciling returned goods with entrusted ones or sold ones.

Description

  The present invention relates to a sales management system that manages sales of products, and more particularly to a sales management system that manages sales when products are returned.

  In the distribution industry such as the apparel industry, once sales of a product are recorded, when the product is returned after a predetermined period of time, the returned product is sold at the unit sales price at the time of recording. Management is appropriate for managing sales.

  For example, depending on the period from the time of recording to the return, the sales amount may fluctuate. If the sales amount at the time of return is the return amount of the returned product, there will be a difference from the sales amount at the time of recording. To bring the difficulty.

  Especially in the distribution industry, there are many cases in which sales are discounted from the normal sales amount by setting up a special sale period in consideration of improving sales of the product. When returned to the outside, there is a difference between the sales amount during the special sale period and the sales amount outside the special sale period.

  For this reason, in a system that manages the sales of such products, the cashier determines whether the product was sold at a special price or at a normal price when the product is returned, and the price is directly , Was manually entering the system.

  Therefore, an erroneous price input error occurs, and the sales of the product do not match the actual sales, which makes it difficult to manage the sales appropriately.

  Therefore, in the POS terminal, information on the normal unit price, sale unit price, sale period is stored for each product, the product code of the product purchased on the receipt output when the customer purchases the product, the date of purchase, etc. Is printed.

  Later, when the customer makes a return, the receipt is read using the scanner provided in the POS terminal, and it is determined whether or not the purchase date falls within the sale period. A technique for determining the price returned using the special sale unit price when the price returned using the special sale period is determined is disclosed (for example, see Patent Document 1).

Japanese Patent Laid-Open No. 6-11133

  However, although the technique described in Patent Document 1 is suitable for products sold in stores to general consumers, in the distribution industry, particularly in the apparel industry, brand, season, color, There are many product attributes such as size, gentleman, ladies, etc., there are few classic products, and it is necessary to sell a large amount of products to be sold according to seasonal changes. Therefore, in the technology described in Patent Document 1, it is necessary to store information records such as the sale price and sale period in the POS terminal, and appropriate sales management can be performed. From the viewpoint of cost effectiveness required for personnel costs, etc., it can be said that sales management work in the apparel industry and the like is insufficient for users who manage the system.

  Therefore, in the present invention, in order to solve the above problem, in performing sales management for the return of products in a system that sells a large amount of products that frequently change, by reducing the workload of the user, An object of the present invention is to provide a sales management system, a control method, and a program capable of performing efficient sales management.

  The first invention for achieving the above object includes sales information storage means for storing sales information relating to sales of goods to a customer and return information relating to returns of the goods, and returns information receiving means for receiving the return information. The value obtained by subtracting the number of returned goods from the number of sales within the range not exceeding the number of sales of the sales information stored by the sales information storing means corresponding to the returned information received by the returned information receiving means is used as the number of sales. A sales management apparatus comprising: calculating means for calculating; and return sales information storage means for storing return information on sales in the sales information storage means.

  A second invention for achieving the above object is a sales management system comprising a mobile terminal capable of communicating with a sales management apparatus, wherein the mobile terminal accepts return information regarding return of goods to the sales management apparatus. The sales management device comprises a sales information storage means for storing sales information relating to sales of merchandise to a customer and return information relating to return of the merchandise, and returns information receiving means for receiving the return information. And the value obtained by subtracting the number of returned goods from the number of sales within a range not exceeding the number of sales of the sales information stored by the sales information storing means corresponding to the return information received by the return information receiving means. Sales management, comprising: a calculating means for calculating the sales information; and a return sales information storage means for storing the return information on the sales in the sales information storage means. It is a stem.

  A third invention for achieving the above object is a method of controlling a sales management device, wherein the return information receiving means of the sales management device accepts the return information, the return information receiving step regarding the return of the product, Sales of sales information stored by the sales information storage means for storing the sales information related to the sales of the product to the customer corresponding to the return information received by the return information receiving means and the calculation means of the sales management device. A calculation step of calculating a value obtained by subtracting the number of returned goods from the number of sales within a range not exceeding the number as the number of sales, the return sales information storage means of the sales management device stores the return information on the sales in the sales information storage A sales management apparatus control method comprising a return sales information storage step stored in a means.

  A fourth invention for achieving the above object is a program executable in the sales management apparatus, wherein the return information receiving means for receiving return information regarding the return of goods and the return information received by the return information receiving means Value obtained by subtracting the number of returns from the number of sales within a range not exceeding the number of sales of sales information stored by the sales information storage means for storing the sales information related to the sales of the product to the corresponding customer and the return information As a number of sales, and a return sales information storage means for storing return information on the sales in the sales information storage means.

  A fifth invention for achieving the above object is a method for controlling a sales management system comprising a mobile terminal communicable with a sales management device, wherein the mobile terminal accepts return information relating to the return of goods and receives the sales. The sales management device executes a transmission step of transmitting to the management device, and the sales management device receives the return information related to the return of the product, and the product to the customer corresponding to the return information received by the return information reception step Calculation to calculate the value obtained by subtracting the number of returns from the number of sales within the range not exceeding the number of sales of the sales information stored by the sales information storage means for storing the sales information related to the sales and the return information. Control of a sales management system, characterized by executing a process and a return sales information storage step of storing return information on sales in the sales information storage means It is the law.

  A sixth invention for achieving the above object is a program executed in a sales management system comprising a mobile terminal capable of communicating with a sales management device, wherein the mobile terminal accepts return information regarding return of goods. Functioning as a transmission means for transmitting to the sales management device, the sales management device to a customer corresponding to the return information received by the return information receiving means for receiving the return information on the return of the product and the return information receiving means. The value obtained by subtracting the number of returned goods from the number of sales is calculated as the number of sales within a range not exceeding the number of sales of the sales information stored in the sales information storage means for storing the sales information related to the sales of the product and the return information. And a return sales information storage means for storing return information on the sales in the sales information storage means. Is that program.

  According to the present invention, the user automatically manages the return of the product in the system that sells a large quantity of products with frequent changes by automatically canceling the returned products according to the number of past sales. By reducing the workload, it is possible to perform efficient sales management.

1 is a configuration diagram showing a schematic configuration of a sales management system according to an embodiment of the present invention. It is a block diagram which shows the structure of the hardware of the handy terminal which concerns on the implementation dismantling of this invention. It is a block diagram which shows the structure of the hardware of the sales management apparatus which concerns on embodiment of this invention. In embodiment of this invention, it is explanatory drawing for demonstrating the flow of the business of sales management. In embodiment of this invention, it is a block diagram which shows the transition of the screen for inputting return information into a handy terminal. In embodiment of this invention, it is a block diagram which shows the transition of the screen for inputting return information into a handy terminal. In embodiment of this invention, it is a block diagram which shows the structure of the table for memorize | stored the returned goods information taken in from the handy terminal. In embodiment of this invention, it is a block diagram which shows the structure of the table for memorize | storing commission information. In embodiment of this invention, it is a block diagram which shows the structure of the table for memorize | storing sales information. It is a flowchart which shows the process regarding the sales return in the sales management system which concerns on embodiment of this invention. It is a flowchart which shows the screen regarding the menu in the sales management system which concerns on embodiment of this invention.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

  FIG. 1 is a block diagram showing a schematic configuration of a sales management system according to an embodiment of the present invention. A handy terminal 102 used when a return process is performed, and a sales management apparatus for managing sales of products. The handy terminal 102 and the sales management apparatus 104 can communicate with each other.

  The handy terminal 102 shows a handy terminal used by the worker who receives the goods when returning the product. The worker displays the name of the worker, the date of the return on the display of the handy terminal 102. The return place, the shipping destination, and the information currently being input can be input with a classification indicating that the information is related to the return.

  After performing these inputs, the operator uses the bar code reader provided in the handy terminal 102 to read the bar code for identifying the product printed on the product tag 106 attached to the product. Thus, it becomes possible to input information necessary for returning the product (hereinafter referred to as return information).

  When the return information is input by the operator using the handy terminal 102, for example, wirelessly such as Bluetooth or IrDA, or a wired external interface such as a USB cable, IEEE1394, a parallel transfer cable, or the like, The input return information is transmitted to the sales management device 104.

  The sales management apparatus 104 stores the return information transmitted from the handy terminal 102 in a storage medium such as an external memory, and reflects the return information on the already registered sales information.

  FIG. 2 is a configuration diagram showing a schematic configuration of hardware of the handy terminal 102 according to the embodiment of the present invention.

  The system bus 201 means, for example, a PCI bus, an AGP bus, a memory bus, and the like. In FIG. 2, various interfaces such as a chip for connecting between buses, a keyboard interface, and a display interface are omitted.

  The CPU 202 comprehensively controls each device and controller connected to the system bus 201.

The ROM 203 stores a BIOS (Basic Input / Output System), which is a control program for the CPU 202, and the memory 204 has an operating system program (hereinafter referred to as OS) and functions executed by the handy terminal 102. Various programs and the like to be described later necessary for the realization are stored.

  Each terminal further includes a hard disk (not shown) or a so-called silicon disk composed of a large-capacity flash memory, and stores operating system programs and application programs on the hard disk and silicon disk. A form in which each program is read from the silicon disk into the memory 204 and executed is also possible.

  The communication adapter 205 connects and communicates with an external device via a network, and executes a communication control process via a communication line (not shown).

  The display 206 (display unit) displays a screen for inputting return information and has a touch panel function. The keyboard 207 is used for inputting various instructions and numerical values.

  The bar code reader 208 reads the bar code printed on the product tag. Thereafter, under the control of the CPU 202, the bar code reader 208 identifies the read bar code by the conversion program stored in the memory 204 and converts it into character data. Convert.

  FIG. 3 is a configuration diagram showing a schematic hardware configuration of the sales management apparatus 104 according to the embodiment of the present invention.

  The CPU 301 comprehensively controls each device and controller connected to the system bus 304. In addition, the ROM 302 or the external memory 311 is necessary for realizing a basic input / output system (BIOS) or an operating system program (hereinafter referred to as an OS) that is a control program of the CPU 301 and functions executed by each server or each terminal. Various programs to be described later are stored. A RAM 303 functions as a main memory, work area, and the like for the CPU 301.

  The CPU 301 implements various operations by loading a program or the like necessary for execution of processing into the RAM 303 and executing the program.

  An input controller (input C) 305 controls input from an input unit 309 indicating a pointing device such as a keyboard or a mouse (not shown).

  A video controller (VC) 306 controls display on a display unit such as the display unit 310. The display device may be a liquid crystal display regardless of the CRT. These are used by the administrator as needed. The present invention is not directly related.

  A memory controller (MC) 307 is a hard disk (HD), floppy disk (registered trademark FD) or PCMCIA card slot for storing a boot program, browser software, various applications, font data, user files, editing files, various data, and the like. Controls access to an external memory 311 such as a CompactFlash (registered trademark) memory connected via an adapter.

  A communication I / F controller (communication I / FC) 308 is connected to and communicates with an external device via a network, and executes communication control processing in the network. For example, Internet communication using TCP / IP is possible.

  Note that the CPU 301 enables display on the display unit 310 by executing outline font rasterization processing on a display information area in the RAM 303, for example. In addition, the CPU 301 enables a user instruction with a mouse cursor (not shown) on the display unit 310.

  A program for executing the sales return processing for realizing the present invention is recorded in the external memory 311 and is executed by the CPU 301 by being loaded into the RAM 303 as necessary. Furthermore, definition files and various information tables used by the program according to the present invention are stored in the external memory 311, and detailed descriptions thereof will be described later.

  FIG. 4 is a flowchart illustrating the overall flow of sales return business in the sales management system 100 according to the embodiment of the present invention. However, although each step of this flowchart shows what is executed in an information processing apparatus such as a computer, it is merely a drawing for explaining the flow of work, and processing is performed in the information processing apparatus. The figure includes steps that are not performed. Sales return processing in the sales management system 100 according to the embodiment of the present invention will be described later.

  As for step S100, the sales management system 100 captures sales information and return information related to product sales from the handy terminal 102, and the sales management system 100 stores the sales information and return information directly without going through the handy terminal 102. This indicates that there is a case where input is performed.

  Step S102 indicates that there is a case where the sales management system 100 fetches sales information or return information from the handy terminal 102 and performs processing related to sales or returns. When processing is performed, sales are counted in step S104, and when returning information is fetched from the handy terminal 102, return processing is performed in step S106. The processing from step S100 to step S106 is automatically performed using an information processing apparatus or the like.

  Step S108 indicates that the sale of the product may be outsourced to another company or the case where the product is sold in-house. For example, the menu screen of the sales management system 100 shown in FIG. In order to perform processing on a product that is entrusted, the administrator presses the button for canceling entrustment on the menu screen, and in step S110, the administrator performs the operation and processes the product that is sold in-house. When performing the above, the administrator presses the sales record button on the menu screen, and performs the operation in step S112.

  For step S110, after consigning the desired number of sales to other companies, obtain sales information by fax etc. from the consignee, display a screen to cancel the consignment, and obtain the sales information It is indicated that the processing for counting the number of sales received for the number of consignments is performed by inputting “” or by acquiring and importing sales information in a file such as CSV format.

  For step S112, if you sell the product in-house, display the screen for recording sales and enter the sales information for the number of sales, or obtain the sales information in a CSV format file etc. It shows that the processing to record sales is performed by taking in.

  The main process of the sales return process in the embodiment of the present invention is the process from step S100 to step S106.

  FIG. 5 shows a transition of a screen used when an operator who receives a cargo performs return processing using the handy terminal 102 to input return information. The screen is displayed on the handy terminal 102. Are displayed on the display 206 having the touch panel function, and input is performed by the touch panel function, the keystroke of the keyboard 207, or the like.

  First, the worker inputs a person-in-charge code for identifying the worker on the screen in order to input the worker information.

  Specifically, as shown in 401, after a field for inputting an operator is displayed on the screen, as shown in 402, a person-in-charge code for identifying the operator, 9999 is the keyboard 207. The name of the worker corresponding to the input person-in-charge code is displayed as indicated by reference numeral 403.

  After inputting the worker information, the worker inputs the return date for accepting the return of the merchandise. However, as shown at 404, the worker inputs the date in the field for inputting the return date on the screen. As an initial value, the date of the day is displayed in the column.

  After entering the return date, the operator inputs the return location. As shown in 405, the field for inputting the return location on the screen has a configuration for displaying and selecting possible locations as the return location. The operator selects a return place using the touch panel function or the keyboard 207.

  After inputting the return place, the worker inputs a shipping destination code for identifying the shipping destination on the screen in order to input the shipping destination.

  Specifically, as shown in 406, after a field for inputting a shipping destination is displayed on the screen, as shown in 407, a shipping destination code for identifying the shipping destination, 200001 is the keyboard 207. As shown in 408, the name and rate of the shipping destination corresponding to the input shipping destination code (where P is the rate for the normal price, and S is the rate at the time of sale) However, it is not related to the gist of the present invention.) Is displayed.

  After entering the ship-to party, the worker enters a category indicating returned goods in order to indicate that information relating to returned goods is being entered, but the field for entering the category on the screen as shown in 409 is a handy It has a configuration in which the type of work using the terminal 102 is displayed and selected, and the operator selects a return category using the touch panel function or the keyboard 207.

  After entering the return category, the operator enters the JAN code of the product to be returned. As shown in 410 in FIG. 6, a field for entering the JAN code is displayed on the screen. Thereafter, the barcode reader 208 of the handy terminal 102 is used for the barcode printed on the product tag attached to the product to be returned, and the JAN code obtained by analyzing the barcode is as indicated by 411. Display in the relevant column.

  After inputting the JAN code, the worker inputs the quantity of the product to be returned on the screen.

  Specifically, as shown in 412, after a field for inputting a quantity is displayed on the screen, as shown in 413, the quantity 3 is input using the keyboard 207. Yes.

  Thereafter, the worker performs the input shown in 410 to 413 when there are other products for the input return date, return place, shipping destination, and classification.

  Next, FIG. 7 shows a configuration of a table for storing return information input using the handy terminal 102, and is provided in a storage medium such as the external memory 211 of the sales management apparatus 104.

  The return information table 700 includes a worker 701 indicating a worker who has performed work using the handy terminal 102, a return date 702 indicating a date when the return of the product is accepted, a return location 703 indicating a location where the product is returned, and sales. It is composed of a shipping destination 704 indicating the destination of the shipment at times, a category 705 indicating the business type, a JAN code 706 of the product, and a return number 707 indicating the number of returned products.

  Next, FIG. 8 shows a configuration of a table that stores consignment information indicating transaction contents when consigning sales to a consignee, and is provided in a storage medium such as the external memory 211 of the sales management device 104. ing.

  The consignment information table 800 includes consignment NO 801 for uniquely identifying a transaction when consigned to another company, a category 802 for identifying whether the consignment information is consignment or return, and a consignment date 803 indicating the date of consignment. , Customer 804 indicating the customer who is regularly entrusted, product 805 indicating the entrusted product, JAN code 806 of the product, entrustment number 807 indicating the quantity of the entrusted product, actual of the entrusted product A consumption sales number 808 indicating the quantity of sales is provided.

  The consumption sales number 808 was obtained after commissioning the desired number of sales to other companies, obtaining sales information by fax etc. from the consignee, and displaying a screen for performing the commission application. By storing sales information or by acquiring and importing sales information in a CSV format file etc., additional storage is performed when processing the number of sales received for the commissioned number. .

  In this case, the sales information corresponding to the commission information can be specified systematically based on the commission NO or the like, but if it can be identified, other codes may be used for the correspondence.

  In addition, the consignment information table 800 shows the consumption consignment remaining number 809 indicating the number of remaining sales obtained from the difference between the consignment number 807 and the consumption sales number 808. A returnable pegging number 810 and a return entrustment remaining number 809 are provided with a pegging remaining number 811 indicating the number of returns that can be applied to the entrusted number obtained from the difference obtained by subtracting the return pegging number 810 from the difference. Needless to say, the number of consumption sales 808 is set within the range of the number of consignments 807.

  An upper price 812 indicating the selling price of the product, a rate of the unit price for the upper price 812, for example, a rate 813 indicating the wholesale rate, a unit price 814 indicating the amount obtained by multiplying the upper rate 812 by the rate 813, and the number of consignments 807 An amount 815 indicating the total amount obtained by multiplying the unit price 814 is provided.

  In the entrustment information table 800, entrustment information related to transactions with entrustees is activated by displaying a screen (not shown) for entering entrustment information by pressing the entrustment count button on the menu screen shown in FIG. The administrator makes input.

  At the time of this input, entrustment No 801, entrustment to category 802, entrustment date 803, customer 804, product 805, JAN code 806, entrustment number 807, cost 812, multiplication rate 813, entrustment number 807 are entered and stored, 0 is stored in the number of sales sales 808 and 0 is stored in the number of returned items attached 810, and the values calculated as described above are stored in the application entrustment remaining number 809, the remaining number of associations 811, the unit price 814, and the amount 815.

  Next, FIG. 9 shows a configuration of a table for storing sales information for a result of selling a product to a customer or the like without performing consignment, and storing in an external memory 211 or the like of the sales management apparatus 104 It is provided in the medium.

  The sales information table 900 includes a sales number 901 for uniquely identifying sales, a category 902 for identifying whether the sales information is sales or returns, a sales date 903 indicating the date when sales are recorded, and regular sales. Customer 904 indicating the customer who is performing, Product 905 indicating the product sold, JAN code 906 of the product, Number of sales 907 indicating the quantity of the product sold, and if returned, indicates the amount returned There is provided a remaining pegable number 909 indicating the number of returns that can be erased with respect to the number of sales obtained from the difference obtained by subtracting the number of returned pegs 908 from the number of returned pegs 908 and sales 907. Needless to say, the returned return number 908 is set within the range of the sales number 907.

  An upper price 910 indicating the sales price of the product, a rate of unit price for the upper price 910, for example, a rate 911 indicating the wholesale rate, a unit price 912 indicating the amount obtained by multiplying the price 910 by the rate 911, and the number of sales 907 An amount 913 indicating the total amount obtained by multiplying the unit price 912 is provided.

  In the sales information table 900, the commission information related to the transaction to the special commissioner is activated by displaying a screen (not shown) for inputting the sales information by pressing the sales recording button on the menu screen shown in FIG. Let the administrator do the input.

At the time of this input, sales NO 901, sales 903, customer 904, product 905, JAN code 906, sales number 907, upper cost 910, and rate 911 are entered and stored, and returned return number 908 is set to 0. The stored values 909, unit price 912, and amount 913 store the values calculated as described above.

  Next, FIG. 10 shows a flowchart showing the flow of sales return processing in the sales management system 100 according to the embodiment of the present invention. Note that each step in this flowchart is executed under the control of the CPU 301 of the sales management apparatus 104.

  In step S200, one piece of return information is acquired from the return information table 700. In the next step S202, it is determined whether or not all the return information stored in the return information table 700 has been acquired. Terminates the process and proceeds to step S204 if it is not determined that it has been acquired.

  In step S204, in order to determine whether the return information acquired in step S202 is due to consignment or whether the return information is due to own sales, a determination is made based on whether the return information exists in the consignment information table 800 or not. .

  In this case, out of the records in which the shipping destination 704 and the JAN code 706 included in the return information match the customer 804 and the JAN code 806 in the consignment information table 800, the consignment date 803 is smaller than the return date 702 and can be linked. A record in which the remaining number 811 is greater than 0 and the category 802 is entrusted is acquired. When there are a plurality of records, the latest or oldest record is determined and acquired by the commission date 803.

  In step S206, it is determined whether or not the remaining number 811 that can be associated with the consignment information acquired in step S204 is equal to or greater than the number of returns 707 of the return information. If it is determined that, the process proceeds to step S208.

  In step S208, the remaining number of possible associations 811 is used as the number of returned goods, and the number of returned goods is obtained from the number of returned goods 707 as the remaining number of returned goods. In step S210, the number of returned goods 707 is used as the number of returned goods. The amount obtained by multiplying by is calculated as the return amount.

  In step S214, the entrustment information entrustment date 803, the customer 804, the product 805, the JAN code 806, the upper price 812, the rate 813, and the unit price 814 of the entrustment information acquired in step S204, and the entrustment information entrustment NO801 are A value obtained by adding 1 to the maximum value of entrusted NO 801 that has already been stored is stored, entrusted return is stored in category 802, and the number of returns in step S208 or S210 is stored in entrusted number 807. From the number of sales 808 to the remaining number 811 that can be associated, 0 is stored, and in the amount 815, the return amount calculated in step S212 is stored.

  In step S216, the returned return number 810 of the consignment information acquired in step S204 is acquired, and the return number in step S208 or step S210 is added to the previously stored return number attached 810 and stored.

  In step S218, the number that can be obtained by subtracting the return pegging number 810 obtained in this step from the consumption entrustment remaining number 809 is stored in the pegging remaining number 811.

  In step S220, it is determined whether or not all the returns 707 have been erased. If it is determined that they have been erased, the process proceeds to step S200. If it is not determined that they have been erased, the process proceeds to step S204. Proceed.

  The determination method in this step is based on whether or not the remaining number of returned goods in step S208 is 0. If the remaining number of returned goods is 0, the process proceeds to step S200, and the remaining number of returned goods is not 0. Then, the process proceeds to step S204.

  In step S224, determination is made based on whether or not the return information acquired in step S202 exists in the sales information table 900. If it is determined that the return information exists, the process proceeds to step S226, and if it is not determined that it exists, step S242 is performed. Proceed to the process.

  In this case, among the records in which the shipping destination 704 and the JAN code 706 included in the return information match the customer 904 and the JAN code 906 in the sales information table 900, the sales date 903 is smaller than the return date 702 and can be linked. A record is acquired in which the remaining number 909 is greater than 0 and the category 902 is sales. When there are a plurality of records, the latest or oldest record is determined by the sales date 903 and acquired.

  In step S226, it is determined whether or not the remaining number 909 that can be associated with the sales information acquired in step S224 is equal to or greater than the number of returned goods 707 in the return information. If it is determined that the number is greater, the process proceeds to step S228. If it is determined that, the process proceeds to step S230.

  In step S228, the remaining number of possible associations 909 is used as the number of returned goods, and the number of returned goods is obtained from the number of returned goods 707 as the remaining number of returned goods. In step S230, the number of returned goods 707 is used as the number of returned goods. The amount obtained by multiplying by is calculated as the return amount.

  In step S234, the sales date 903, customer 904, product 905, JAN code 906, sales number 907, sales 910, multiplication rate 911, and unit price 912 of the sales information acquired in step S224 are used, and the sales information sales. In NO901, a value obtained by adding 1 to the maximum value of the sales NO901 already stored is stored. In the category 902, returned goods are stored. In the sales number 907, the number of returned goods in step S228 or S230 is stored. In addition, “0” is stored in the returned return number 908 and the remaining possible number 909, and the return amount calculated in step S232 is stored in the amount 913.

  In step S236, the return number 908 of the sales information acquired in step S206 is acquired, and the return number in step S228 or step S230 is added to the previously stored return number 908 and stored.

  In step S238, the number obtained by subtracting the returned return number 908 obtained in this step from the sales number 907 is stored in the remaining number 909 that can be associated.

  In step S240, it is determined whether or not all the returns 707 have been erased. If it is determined that they have been erased, the process proceeds to step S200. If it is not determined that they have been erased, the process proceeds to step S224. Proceed.

  The determination method in this step is based on whether or not the remaining number of returned goods in step S228 is 0. If the remaining number of returned goods is 0, the process proceeds to step S200, and the remaining number of returned goods is not 0. Then, the process proceeds to step S224.

  In step S242, after displaying a screen (not shown) for warning that there is an abnormality in the return information, the process ends.

  As described above, according to the present invention, when automatically managing returns for sales in accordance with the number of past sales, when managing sales for returns of products in a system that sells a large quantity of products that frequently change, By reducing the user workload, efficient sales management can be performed.

  In addition, the present invention can take an embodiment as, for example, a method, a program, or a storage medium. Specifically, the present invention may be applied to a system including a plurality of devices. You may apply to the apparatus which consists of one apparatus.

  The program according to the present invention is a program that allows a computer to execute (read) each processing method, and the storage medium according to the present invention stores a program that allows the computer to execute each processing method.

  The program in the present invention may be a program for each processing method of each device.

As described above, a recording medium that records a program that implements the functions of the above-described embodiments is supplied to a system or apparatus, and a computer (or CPU or MPU) of the system or apparatus stores the program stored in the recording medium. It goes without saying that the object of the present invention can also be achieved by performing reading.

  In this case, the program itself read from the recording medium realizes the novel function of the present invention, and the recording medium storing the program constitutes the present invention.

  As a recording medium for supplying the program, for example, a flexible disk, hard disk, optical disk, magneto-optical disk, CD-ROM, CD-R, DVD-ROM, magnetic tape, nonvolatile memory card, ROM, EEPROM, silicon A disk or the like can be used.

  Further, by executing the program read by the computer, not only the functions of the above-described embodiments are realized, but also an OS or the like operating on the computer based on an instruction of the program is a part of the actual processing or It goes without saying that the case where the functions of the above-described embodiments are realized by performing all of the above processing is also included.

  Furthermore, after the program read from the recording medium is written to the memory provided in the function expansion board inserted into the computer or the function expansion unit connected to the computer, the function expansion board is based on the instructions of the program code. It goes without saying that the case where the CPU or the like provided in the function expansion unit performs part or all of the actual processing and the functions of the above-described embodiments are realized by the processing.

  Further, the present invention may be applied to a system composed of a plurality of devices or an apparatus composed of a single device. Needless to say, the present invention can be applied to a case where the present invention is achieved by supplying a program to a system or apparatus.

  In this case, by reading a recording medium storing a program for achieving the present invention into the system or apparatus, the system or apparatus can enjoy the effects of the present invention.

  Furthermore, by downloading and reading a program for achieving the present invention from a server, database, etc. on a network using a communication program, the system or apparatus can enjoy the effects of the present invention. In addition, all the structures which combined each embodiment mentioned above and its modification are also included in this invention.

100 Sales Management System 102 Handy Terminal 104 Sales Management Device 201 System Bus 202 CPU
203 ROM
204 Memory 205 Communication adapter 206 Display 207 Keyboard 208 Bar code reader 301 CPU
302 ROM
303 RAM
304 system bus 305 input controller 306 video controller 307 memory controller 308 communication I / F controller 309 input unit 310 display unit 311 external memory

Claims (12)

Sales information storage means for storing sales information related to sales of products to customers and return information related to returns of the products;
Return information receiving means for receiving the return information;
The value obtained by subtracting the number of returned goods from the number of sales is calculated as the number of sales within a range not exceeding the number of sales of the sales information stored by the sales information storage means corresponding to the return information received by the return information receiving means. Calculating means for
Returns sales information storage means for storing return information in the sales in the sales information storage means;
A sales management device comprising:   The calculation means obtains a value obtained by subtracting the number of returned goods from the number of sales within a range not exceeding the number of sales of the sales information in the order of the oldest sales information stored in the sales information storage means to the new sales information. The sales management apparatus according to claim 1, wherein the sales management apparatus calculates the number of sales.   The calculation means obtains a value obtained by subtracting the number of returned goods from the number of sales within a range not exceeding the number of sales of the sales information in the order of the oldest sales information from the latest sales information stored by the sales information storage means. The sales management apparatus according to claim 1, wherein the sales management apparatus calculates the number of sales. Consignment information storage means for storing consignment information related to transactions for consigning sales of products to a consignee;
Consignment sales information storage means for accepting consignment sales information related to sales of products in the consignment and storing the number of sales of the consignment information;
The calculation means returns the product within a range that does not exceed the consumption commission remaining number obtained by subtracting the number of sales from the commission information of the commission information stored in the commission information storage means corresponding to the return information accepted by the return information acceptance means. Calculate the number,
Consignment sales information storage means for storing the return information in the consignment in the consignment information storage means;
The sales management device according to any one of claims 1 to 3, further comprising:   The calculation means, in the order of the oldest commission information stored in the commission information storage means to the new commission information, the number of returns within a range not exceeding the consumption commission remaining number obtained by subtracting the number of sales from the commission number of the commission information. The sales management device according to claim 4, wherein   The calculation means is the number of returned goods in a range not exceeding the consumption commission remaining number obtained by subtracting the number of sales from the commission number of the commission information in order of the old commission information from the newest commission information stored by the commission information storage means. The sales management device according to claim 4, wherein   When the return information received by the return information receiving means is present in the commission information stored in the commission information storage means, the calculation means is a consumption commission balance obtained by subtracting the number of sales from the commission number of the commission information. The number of returned goods is calculated within a range not exceeding the number. On the other hand, the returned information received by the returned information receiving means does not exist in the commissioned information stored in the commissioned information storing means and is stored by the sales information storing means. If the sales information exists, a value obtained by subtracting the number of returned goods from the sales number within a range not exceeding the sales number of the sales information is calculated as the sales number. The sales management device according to any one of the above. A sales management system comprising a mobile terminal capable of communicating with a sales management device,
The portable terminal is
Receiving means for receiving return information related to the return of the product and transmitting it to the sales management device;
The sales management device is:
Sales information storage means for storing sales information related to sales of products to customers and return information related to returns of the products;
Return information receiving means for receiving the return information;
The value obtained by subtracting the number of returned goods from the number of sales is calculated as the number of sales within a range not exceeding the number of sales of the sales information stored by the sales information storage means corresponding to the return information received by the return information receiving means. Calculating means for
Returns sales information storage means for storing return information in the sales in the sales information storage means;
A sales management system characterized by comprising: A method of controlling a sales management device,
The return information receiving means of the sales management device accepts the return information for the return of the product for receiving the return information,
The sales management device calculates the sales information related to the sales of the product to the customer corresponding to the return information received by the return information receiving means and the sales information storage means for storing the return information. A calculation step for calculating the value obtained by subtracting the number of returned goods from the number of sales within the range not exceeding the number of sales,
The returned goods sales information storage means of the sales management device stores the returned goods information in the sales in the sales information storage means,
A method for controlling a sales management apparatus, comprising: A program executable in the sales management device,
A return information receiving means for receiving return information related to the return of the product;
Sales within a range that does not exceed the number of sales of the sales information stored in the sales information storage means that stores the sales information related to the sales of the merchandise to the customer corresponding to the return information received by the return information receiving means. A calculation means for calculating the value obtained by subtracting the number of returned goods from the number as the number of sales,
Returns sales information storage means for storing return information in the sales in the sales information storage means;
A program characterized by making it function. A method for controlling a sales management system comprising a mobile terminal capable of communicating with a sales management device,
The portable terminal is
Execute a transmission step of receiving return information related to the return of the product and transmitting it to the sales management device,
The sales management device is:
A return information receiving process for receiving return information related to the return of the product;
Sales within a range that does not exceed the number of sales of the sales information stored by the sales information storage means for storing the sales information and the sales information of the product to the customer corresponding to the return information received by the return information receiving step. A calculation process to calculate the value obtained by subtracting the number of returned goods from the number as the number of sales,
Return sales information storage step of storing the return information in the sales in the sales information storage means,
A method of controlling a sales management system, characterized in that A program executed in a sales management system including a portable terminal capable of communicating with a sales management device,
The portable terminal;
Function as a transmission means for receiving return information regarding the return of goods and transmitting it to the sales management device;
The sales management device;
A return information receiving means for receiving return information related to the return of the product;
Sales within a range that does not exceed the number of sales of the sales information stored in the sales information storage means storing the sales information and the sales information storage means for storing the returned goods information to the customer corresponding to the return information received by the return information receiving means. A calculation means for calculating the value obtained by subtracting the number of returned goods from the number as the number of sales,
Returns sales information storage means for storing return information in the sales in the sales information storage means;
A program characterized by functioning.

Images