JPH0746397B2 - Product sales data processing device - Google Patents

Description

The present invention relates to a product sales data processing device that has a single product table provided in at least a unit price setting area and a sales amount accumulation area and performs registration and settlement operations.

[Conventional technology]

For example, a POS system is an application of this type of device. In this system, for example, a plurality of POS terminals composed of electronic cash registers are connected to a file controller in a loop, and one of the POS terminals is a master and the rest are satellites. The file controller is connected to a memory that has a single-item table, and this single-item table stores an area that stores the code attached to each individual item, a product name area that stores the product name, and a unit price setting that stores the unit price. An area, an area for accumulating sales points and an area for accumulating sales amounts are provided. Here, when the POS terminal sends a single product code to the file controller during registration work, this file controller searches the single product table for the same code, reads the product name and unit price corresponding to this code, and sends the POS. Send it back to the terminal. As a result, the POS terminal performs the registration process for a single item. Further, the file controller receives the registered product sales data from the POS terminal and accumulates the corresponding product sales total area and total sales area. In this way, for example, when the registration work for one day is completed, the file controller reads the number of sales and the amount of sales for each individual item from the individual item table in response to a command from the master POS terminal and returns it to the master POS terminal. . The master POS terminal prints out the number of sales and the amount of sales for each single item received and issues a settlement report. Then, when the printing output is completed, the file controller clears the sales points and the sales amount of the single item table.

[Problems to be solved by the invention]

As described above, since the sales points and sales amounts of each individual product are printed out in the single-item settlement business, it is possible to know which products have the most sales and which have the least sales on that day. By the way, in order to manage sales, it is necessary to grasp the products that have no sales for several days, but in the above system, to grasp the products that have no sales for several days, you have to look at the settlement report up to several days ago. There is a problem that confirmation work becomes troublesome and oversight occurs.

Therefore, it is an object of the present invention to provide a product sales data processing device capable of easily and surely confirming products without sales.

[Means for solving problems]

As shown in FIG. 1, the present invention has a unit price table 3 having at least a unit price setting area 1 for each unit and a sales amount cumulative area 2 corresponding to these units, and the unit price from the unit price table 3 is registered at the time of registration work. In the product sales data processing device having a function of reading out and accumulating the sales amount obtained based on this unit price in the sales amount accumulation area 2 and outputting and clearing the data of the sales amount accumulation area 2 at the time of settlement work, The date counting means 4 for counting, the sales date area 5 provided for each individual item, and the sales date in the sales date area 5 corresponding to the individual item registered at the time of registration work become the counting date of the date counting means 4. Sales date updating means 6 to be updated,
Output means 7 for outputting the sales date of the sales date area 5
It is a commodity sales data processing device which is equipped with and aims to achieve the above object.

[Action]

By providing such means, the sales date in the sales date area 5 corresponding to a single item registered at the time of registration work is updated by the sales date updating means 6 to the date counted by the date counting means 4. In other words, the contents of the sales date area 5 corresponding to the unregistered single item are not updated. Then, the contents of the sales date area 5 are output by the output means when necessary.

〔Example〕

An embodiment of the present invention will be described below with reference to the drawings.

FIG. 1 is a block diagram of a POS system to which the device of the present invention is applied. In this POS system, a file controller 20 is connected to a host computer 10, and further, POS terminals 31-1, 31-2, 31- which are composed of electronic cash registers connected to the file controller 20 in a loop.
3 to 31-n are connected. These POS
Any one of the terminals 31-1 to 31-n, for example, the POS terminal 31-1 has a function as a master, and the other POS terminal 3
1-2 to 31-n function as satellites. By the way, these POS terminals 31-1 to 31-n are configured as shown in FIG. The CPU (central processing unit) 32 has a built-in arithmetic circuit, etc., performs various arithmetic processing based on input information from the keyboard 33, and fixes control programs etc. via the address bus 34, data bus 35, and control line 36. A ROM (read only memory) 37 that stores data and a RAM (random access memory) 38 that stores sales data such as the sales amount of each product keyed in are operated. . Also, a transmission control circuit 39 and a keyboard 3 connected to the file controller 20 via a transmission path.
The key board input circuit 40 to which the key signal from 3 is input, the display control circuit 42 that sends a display signal to the display unit 41, the printer control circuit 44 of the dot printer 43 that prints and outputs to the receipt paper are the address bus 34 and the data bus, respectively. 35 and the control line 36. Further, the keyboard 33 is provided with a report key for issuing a specific code for printing out the data of each individual item stored in the file controller 20 (hereinafter, abbreviated as a report) and the product key to be printed out. A date key for designating the sales date is provided. So, for example, 1987
When grasping a product that has not been sold before July 1, 1987, this date is specified by keying in the date July 1, 1987.

The file controller 20 is provided with a CPU 21, and the CPU 21 is provided to the host computer 1 via the transmission control circuit 22.
0 is connected and each POS terminal 31-1 to 31-n is connected via the transmission control circuit 23. Also, this CPU21
Is a RO that stores the file controller program, etc.
M24, a clock circuit 25 as a date counting means for counting date and time, and a RAM 26 are connected. By the way, a single item table is provided in a predetermined area of the RAM 26. This single item table is, as shown in FIG. 4, a code area A in which a code set for each individual item is stored, a product name area B in which the product name of the individual item is stored, and a unit price setting area C in which the unit price is stored. There are provided a status area D, a cumulative sales point area E indicating the number of sales, and a total sales amount area F for totaling the total sales amount calculated from the total sales. Further, this single item table is provided with a sales date area G for writing the date of sales for each individual item. The CPU 21 receives each code sent from each POS terminal 31-1 to 31-n at the time of registration work, searches the single item table, searches for the code, reads the product name and unit price of the code, and thereafter Sales date update means for updating the sales date in the sales date area G corresponding to the searched code separately to the date counted by the clock circuit 25, and the report command from the master POS terminal 31-1 and the host computer 10 and this. It has a function to retrieve the code of the date earlier than the specified date when receiving the report date from the single item table and send it back to the master POS terminal 3-1 and the host computer 10 for which the report command was issued. ing.

Next, the operation of the POS system configured as described above will be described.

First, the registration work is performed according to the registration processing flowchart shown in FIG. When a decision is made in step s1 to execute registration work, the process moves to the next step s2.
Receive codes from POS terminals 31-1 to 31-n. For example, a barcode scanner of the POS terminal 31-2 reads a code, for example, "01020304", and the code "0120304"
020304 ”is converted into a predetermined message and sent to the CPU 21 through the transmission control circuit 23 of the file controller 20, the CPU 21 retrieves each code stored in the code area A of the single item table provided in the RAM 26. To find the same code "01020304". When this code "01020304" is searched, the CPU 21 reads the product name "butaniku" and unit price "230" corresponding to this code "01020304" from the product name area B and unit price area C, respectively, and acquires the product name "butaniku" and POS the unit price of “230” through the transmission control circuit 23
It is converted into a predetermined message and returned to the terminal 31-2. And the file controller 20 is the master POS terminal 31
When the product sales data is received from -1, the total number of sales in the total sales area E is "1", for example, "28", and the total sales amount area F is calculated from the number of sales "1" and the unit price "230". The total sales amount "230" is added to the previous sales amount "6210" to become "6540". Next, in step s3, the CPU 21 reads the date “87 07 01” from the count of the clock circuit 25, and in the next step s4, the date “87 07 01” is assigned to the sales date corresponding to the code “01020304”. Write in area G and update. In this case, since the sales of "Butnik" had already been made on the same day, "87
It is still '07 01 '. Then, when the POS terminal 31-2 sends another product code "01020305" to the CPU 21, this C
The PU21 executes steps s1 to s4 again to search each code in the single item table for the same code "01020305". When this code "01020305" is searched, the CPU21 corresponds to this code "01020305". Product name "Juice" and unit price "100" are the product name area B and unit price area C, respectively
Read from these product names "juice" and unit price "10
"0" is returned to the POS terminal 31-2 through the transmission control circuit 23. Then, the file controller 20 is the POS terminal 31-
When the product sales data is received from 1, the sales amount accumulated area E accumulates only the sales amount “1” and the sales amount accumulated area F accumulates the sales amount “1” and the sales amount “100” calculated from the unit price “100”. To do. Next, in step s3, the CPU 21 determines the date and time "87 07 0" from the count of the clock circuit 25.
Read “1”, and in the next step s4, select “87 07 0
Write "1" in the sales date area G corresponding to the code "01020305" and update the previous date "87 06 30". In this way, the file controller 20 is connected to each POS terminal 31-
Product name and unit price corresponding to each code from 1 to 31-n is PO
Return to S terminals 31-1 to 31-n, accumulate sales points and sales amount, and further, file controller
20 updates the date in the sales date area G corresponding to the code.

Next, the report processing will be described with reference to the report processing flowchart shown in FIG. Master POS terminal 3
The report key of 1-1 is operated and the date "87 06 20" is keyed in by the date designation key, and these report commands and their date commands are stored in the file controller 20.
When sent to the CPU 21, the CPU 21 determines in step e1 to execute the report and moves to the next step e2 to specify the specified date "87 06 20" and the sales date area G of each code.
It is judged whether it is before the specified date "87 06 20" by comparing it with the date written in. According to this judgment, the sales date of the product “Butanik” with the code “01020304” is “87 07 01”, so it is after the specified date “87 06 20”, so the CPU 21 proceeds to the next code “01020305” and goes to the first. Compare with the updated date "87 07 01". Since this date is also after the specified date “87 06 20”, the process proceeds to the next code “01020306”. This code "010203
Since the sales date of "06" is "87 02 03", it is earlier than the specified date "87 06 20". Therefore, CPU2
1 moves to step e3 and the code "010" from code area A
20306 ”, the product name“ Maki ”from the product name area B, and the sales date“ 87 02 03 ”from the sales date area G are read out and converted into predetermined messages, and the master POS terminal 3
Return to 1-1. In this way, the CPU 21 converts the product name and sales date of the code whose sales date is earlier than the specified date “87 06 20” by comparing with the sales date of each code into a predetermined electronic message, POS terminal 31-1
Return to. Thus, the master POS terminal 31-1 prints the code, product name and sales date sent from the file controller 20 on the settlement report paper 50 as shown in FIG. In this case, it can be understood that “chocolate” has no sales from the date “87 06 18” in addition to the “maki”.

In addition, the single item settlement operation is performed as follows. master's
When the settlement selection switch of the POS terminal 31-1 is operated,
A payment command is sent from the POS terminal 31-1 to the CPU 21 through the transmission control circuit 23. Then, the CPU 21 reads the code, the product name, the unit price, the point, the sales amount and the sales date from the single item table, converts them into a predetermined electronic message, and sends it back to the master POS terminal 31-1. And
When all the codes, product name, unit price, points, sales amount and sales date are read out and the fact that these data have been received is returned from the POS terminal 31-1, the CPU 21 displays the points and sales amount. clear. At this time, the CPU 21 does not clear each date written in the sales date area G but keeps that state. Then, the POS terminal 31-1 receiving the code, product name, unit price, point, sales amount and sales date prints the code, product name, unit price, points, sales amount and sales date on the settlement report sheet. Output. When the registration operation is performed again, the CPU 21 updates the date in the sales date area G at the time of this registration.

As described above, in the above-described embodiment, the sales date in the sales date area G corresponding to a single item registered at the time of registration is updated to the date counted by the clock circuit 25 by the sales date updating means, and the sales date area G is further updated. Since the POS terminal 31-1 with the master sales date is configured to print it on the settlement report paper together with each product name, the final sales date of the product that has no sales is printed from the settlement report paper that is printed out during the single item settlement work. You can grasp it immediately. Also, by designating the final sales date, only the products before the final sales date can be printed out, and only the products without sales can be clearly grasped.

It should be noted that the present invention is not limited to the above-described embodiment, and may be modified without departing from the spirit of the invention. For example, the present apparatus may be applied not to a POS system but to a single electronic cash register for performing various operations such as registration, settlement, and inspection. Further, the sales date area G may be formed in a predetermined area in the RAM 26 so as to correspond to each code area A, instead of being formed together with the single item table. In addition, settlement and reporting are done by the master POC terminal 31
The command may be received not only from the host computer 10 but also from the host computer 10 and executed.

〔The invention's effect〕

As described in detail above, according to the present invention, it is possible to provide a product sales data processing device that allows easy and reliable confirmation of products without sales.

[Brief description of drawings]

FIG. 1 is a functional block diagram of a product sales data processing device according to the present invention, and FIGS. 2 to 7 are diagrams for explaining an embodiment in which the product sales data processing device according to the present invention is applied to a POS system. So, Fig. 2 is the overall configuration diagram, and Fig. 3 is the PO.
FIG. 4 is a configuration diagram of the S terminal, FIG. 4 is a schematic diagram of a single item table, FIG. 5 is a registration processing flowchart, FIG. 6 is a report processing flowchart, and FIG. 10 ... Host computer, 20 ... File controller, 21 ... CPU, 22,23 ... Transmission control circuit, 25 ... Clock circuit, 26 ... RAM, 31-1 to 31-n ... POS terminal.

Claims (1)

[Claims] 1. A single item table having at least a unit price setting area for each individual item and a sales amount cumulative area corresponding to these individual items, the unit price being read from the single item table at the time of registration work, and obtained based on this unit price. In the product sales data processing device having a function of accumulating the amount of sales in the total amount of sales area and outputting and clearing the data in the total area of sales amount at the time of settlement, a date counting means for counting the date, and A sales date area provided for a single item, and a sales date updating means for updating the sales date of the sales date area corresponding to the single item registered at the time of registration to the date counted by the date counting means, And a means for outputting the sales date of the sales date area. Sales data processing apparatus.