JPH05225446A - Sales tabulator - Google Patents

Abstract

PURPOSE:To provide a sales tabulator capable of improving accuracy in the rough profit calculation of goods sold at special prices. CONSTITUTION:When ordinary sales price data, ordinary cost data, special sales price data. and special cost data are set on a goods table 13, and the sales tabulation processing of a goods code set on a special sales table 14 is performed, a special time control part 12 performs such setting that the special sales data and the special cost data can be referred to instead of the ordinary sales price data and the ordinary cost data.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention In the present invention, sales are summed up for each product using data of either a normal selling price for selling at a normal selling price or a special selling price for selling at a special selling price. Relating to a sales tallying device.

[0002]

2. Description of the Related Art In recent years, a POS (Point Of Sales) system for centrally managing product inventory management and sales totalization has been introduced to stores in the distribution business. A product code is added to the products handled by this POS system, and P
Prior to operation, the OS system is provided with a table that associates product codes with selling prices and costs. When recording the sales of a product (when performing settlement processing), for example, grasp the product code from the barcode attached to each product, search the table based on this product code, and based on the selling price and cost. Calculate the sales that you made. Here, the POS system that realizes such processing will be referred to as a sales totalizing device.

FIG. 2 shows a conceptual diagram of a conventional sales totalizing device. As shown in the figure, the sales totaling device 1 is provided with a processor 2, a keyboard 3, a display 4, a printer 5, a memory 6, and a hard disk device 7 connected to the processor 2. The processor 2 controls each part of the sales totaling device 1, and mainly sells the product for each customer (sales processing) or total sales for one day (settlement processing). And the cost is added.

The keyboard 3 is composed of keys for inputting a product code, the number of products and the like, a bar code reader and the like. The display 4 displays a product name, a product code, an amount of money, etc. associated with the sales total. The printer 5 prints a receipt or the like showing the result of sales totalization. The memory 6 is the processor 2
Programs and data referenced by the processor 2
Processing product table 8 which is composed of a RAM or the like for temporarily storing processing results of
Is provided.

The structure of the processing product table 8 will be described with reference to FIG. FIG. 3 is an explanatory diagram of the conventional processing product table 8. The processing product table 8 is
The item 8e includes a product code area 8a, a department area 8b, a selling price area 8c, and a cost area 8d.

The product code area 8a is an area in which numerical information corresponding to a bar code for specifying a product is set, for example. The department area 8b is an area in which information for identifying a department to which a product belongs, such as food and clothing, is set. The selling price area 8c is an area in which the selling price of the product is set. The cost area 8d is an area in which the cost of the product is set. The item 8e having the above configuration is prepared for all the products for which sales are to be aggregated.

Returning to FIG. 2 again, the hard disk device 7
Stores programs and data referred to by the processor 2, processing results of the processor, and the like, and is further provided with a product table 9 and a special sale table 10 which are referred to in order to generate the processing product table 8a. The product table 9 is similar to the processing product table 8, and includes a product code area 9a, a department area 9b, and a selling price area 9.
c, an item 9e having a cost area 9d. The selling price area 9c and the cost area 9d of the product table 9 are
This is an area where the selling price (ordinary selling price) and the cost (ordinary cost) of the product to be sold at normal times (at the time of normal business when no special discount is performed) are set.

The structure of the special sale table 10 will be described with reference to FIG. FIG. 4 is an explanatory diagram of the conventional special sale table 10. As shown in the figure, the special sale table 10 includes a special sale period area 10a and a product code area 10
b, an item 10d having a special sale price area 10c. The special sale period area 10a is an area in which a period for performing the special sale, that is, a date is set. Product code 10
b is an area in which a product code for specifying a product for which a special sale is performed is set. The special sale price area 10c is an area in which the sale price at the time of special sale (special sale price) is set. The bargain time refers to a special business period when a special discount is set and a product is sold.

Now, returning to FIG. 2, the operation of the conventional sales totalizing device 1 will be described. Note that the hard disk device 7 is provided with a product table 9 and a special sale table 10. In the sales totalizing device 1 having the above configuration, the processing product table 8 does not exist on the memory 6 immediately after starting. Therefore, the processor 2 uses the product table 9 and the special sale table 10 on the hard disk device 7.
With reference to, processing for constructing the processing product table 8 is performed.

First, the commodity table 9 is read from the hard disk device 7, copied to the memory 6, and a temporary processing commodity table 8 is constructed. After that, the bargain sale period 10a of the bargain sale table 10 is searched, and the item including the current date is extracted. Product code area 1 of the extracted item
0b and the contents of the bargain sale price area 10c are read, and the item of the processing product table 8 that matches the read product code is searched.

Corresponding item 8 on the processing commodity table 8
When e is extracted, the contents of the selling price area 8c on this item 8e are changed to the contents read from the selling price area 10c of the selling table 10 first, that is, the selling price. By performing the above processing for all the items of the special sale table 10, the temporary processing product table 8 becomes the regular processing product table 8 to be referred to for sales totalization.

[0012]

Conventionally, the cost of the item 8e on the processing product table 8 for the product to be sold specially remains at the value corresponding to the selling price at the normal time. In general, the price of a special sale item is often set to a different price from the normal cost (special sale price). There was a problem that profits could not be calculated. The present invention has been made in view of the above points, and it is an object of the present invention to provide a sales totaling device that can improve the accuracy of gross profit calculation of a special sale product.

[0013]

The sales totalizing device of the present invention uses a normal selling price data and a normal cost data which are effective in a normal time of selling a product at a normal selling price for each product code specifying a product, and a special selling price. A product table in which special sale price data and special cost data valid at a special time of sale are set, a special sale table in which a product code of the product corresponding to the special time is set, and sales are accumulated for each product code. At the time of the sales totalization process, the special sale price data and the special cost data are referred to for the product code set in the special sale table, and the normal sale price data and the normal cost data are referred to for other product codes. And a special time control unit for making the following settings.

[0014]

[Function] This device sets the normal sale price data and the normal cost data, the special sale price data and the special cost data in the product table, and when performing the sales total processing for the product code set in the special sale table, the normal sale price data is set. The special time control unit is set to refer to the special selling price data and the special cost data instead of the data and the normal cost data.

[0015]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 is a conceptual diagram of a sales totalizing device of the present invention. Compared with the sales totalizing device 1 described above with reference to FIG. 2, the sales totaling device 11 shown in the figure is provided with a special time control unit 12 in the processor 2, and further includes a product table 13 on the hard disk device 7. And the structure of the special sale table 14 is different. Since other configurations are the same as those of the conventional one, duplicate description will be omitted.

The structure of the product table 13 will be described with reference to FIG. FIG. 5 is an explanatory diagram of the product table 13 according to the present invention. As shown in the figure, the product table 13 includes items 13g including a product code region 13a, a department region 13b, a selling price region 13c, a cost region 13d, a special sale price region 13e, and a special sale cost region 13f.

Product code area 13a to cost area 13d
Is the same as that described above with reference to FIG. The special sale price area 13e is an area in which the sale price at the time of special sale (special sale price) is set. The special sale cost area 13f is an area in which the cost of the commodity at the time of special sale (special cost) is set.

Next, FIG. 6 shows a special sale table 1 according to the present invention.
It is explanatory drawing of FIG. Sale table 14 as shown
Is composed of an item 14c including a special sale period area 14a and a product code area 14b. Special sale period area 14a
Is an area where a period for carrying out the special sale, that is, a date is set. The product code 14b is an area in which a product code for specifying a product for which a special sale is performed is set.

Now, returning to FIG. 1 again, the operation of the sales totalizing device 11 of the present invention will be described with reference to FIG. FIG. 7 is a flowchart according to the present invention. Here, in a state where the product table 13 and the special sale table 14 are set and the processing product table 8 is not constructed,
It is assumed that the sales totalizing device 11 is activated.

First, the sales totaling device 11 refers to the product table 13 and the special sale table 14, and the special time control unit 12 is activated to execute the process of constructing the processing product table 8. The special time control unit 12 firstly sells the special sale table 1
The special sale period area 14a of No. 4 is searched, and the item in which the period including the current date is set is extracted (step S1). When the corresponding item is extracted, the product code is read from the product code area 14b and temporarily stored in the register or the like which is the work area of the processor 2 (step S2).

After that, the special time control unit 12 reads the content of the product code 13a for each item of the product table 13 and determines whether or not it matches the product code on the work area (step S3). When the result of step S3 is YES, that is, when the product codes match, it is determined that the product code area 13a is an item of the product corresponding to the special time sale,
Department area 13b, and sale price 13e and sale cost 13
The contents of f are transferred to the processing product table 8 (step S4).

If the result of step S3 is NO, that is, if the product codes do not match, the product code area 13a, the department area 13b, the selling price area 13c, and the cost are regarded as items of the product corresponding to the normal sale. Area 13d
Is transferred to the processing product table 8 (step S
5). After performing steps S4 and S5, the product table 1
It is determined whether or not there is an item to be transferred on item 3 (step S6). If the result of step S6 is YES, that is, if there is an item to be transferred, the process returns to step S2 and the result is N.
In the case of O, the processing is terminated, and the processor 2 executes the sales totalization processing with reference to the processing product table 8.

In this case, the gross profit calculation with reference to the processing commodity table 8 is carried out based on the special sale price and the special sale price for the special sale commodity and based on the sale price and the cost of the other commodity. It is possible to obtain results that reflect various costs.

By the way, the storage capacity required for each item of the product table 13 is ensured to be a power of 2 bit for easy management. Therefore, there is an area in which no data is stored. By adding the special sale price 13e and the special sale cost 13f to this area,
New data can be added without changing each item and the storage capacity of the processing product table 8.

When the current date has passed the period indicated by the contents of the special sale period 14a of the special sale table 14, the item 14c relating to the special sale period 14a is deleted from the special sale table 14, but the special sale price on the product table 13g. Area 13
The contents of e and the sale price area 13f are saved.

Therefore, when a new item is set in the special sale table 14 under the control of the special time control unit 12, the special sale price 13e of the corresponding item 13g on the product table 13 is set.
Also, the contents of the special sale price 13f are read out, and a new special sale price or special sale price can be input only when updating is necessary. In other cases, the already set value can be diverted, and the time and effort for data entry can be saved. You can

[0027]

As described above, according to the sales totalizing device of the present invention, when the cost changes due to the change in the selling price, the sales totaling process can be performed based on the accurate cost corresponding to the selling price. Therefore, an accurate processing result can be obtained.

[Brief description of drawings]

FIG. 1 is a conceptual diagram of a sales totalizing device of the present invention.

FIG. 2 is a conceptual diagram of a conventional sales tallying device.

FIG. 3 is an explanatory diagram of a conventional processing product table.

FIG. 4 is an explanatory diagram of a conventional special sale table.

FIG. 5 is an explanatory diagram of a product table according to the present invention.

FIG. 6 is an explanatory diagram of a sale table according to the present invention.

FIG. 7 is a flowchart according to the present invention.

[Explanation of symbols]

 8 Processing Product Table 12 Special Time Control Section 13 Product Table 14 Special Sale Table

Claims (1)

[Claims] 1. A normal selling price data and a normal cost data which are effective at a normal selling price and a special selling price data and a special special selling price data which are effective at a special selling price for each product code specifying a product. A product table in which cost data is set, a special sale table in which a product code of the product corresponding to the special time is set, and a sales total processing for accumulating sales for each of the product codes, is set in the special sale table For product code,
Sales totals characterized by including the special selling price data and the special cost data, and for other product codes, a special time control unit that is set to refer to the normal selling price data and the normal cost data apparatus.