JP2933183B2 - Sales aggregation device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention sums up sales for each product using either data of a normal selling price at which selling is performed at a normal selling price or a special selling price at which selling is performed at a special selling price. It relates to a sales aggregation device.

[0002]

2. Description of the Related Art In recent years, POS (Point Of Sales) systems for centrally managing inventory management of goods and totaling of sales have been introduced to stores in the distribution industry. A product code is given to the product handled by this POS system, and
Prior to operation, the OS system is provided with a table for associating a product code with a selling price and a cost. When accounting for product sales (when performing a checkout process), for example, the product code is determined from the barcode attached to each product, a table is searched based on the product code, and the sales price and cost are calculated based on the product code. Perform sales summarization. Here, a 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 totaling apparatus. As shown in the figure, the sales aggregation 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 unit constituting the sales totaling device 1 and mainly sells prices associated with totaling of sales of goods (sales processing) and daily total sales (payment processing) for each customer. And the cost.

[0004] The keyboard 3 is composed of a key for inputting a product code, a number, and the like, a bar code reader, and the like. The display 4 displays a product name, a product code, a price, and the like associated with the sales totalization. The printer 5 prints a receipt or the like indicating the result of the sales totalization. The memory 6 includes the processor 2
Programs and data to be referred to, and the processor 2
, Which temporarily stores the processing results and the like, and is referred to when totaling sales.
Is provided.

The configuration of the processing product table 8 will be described with reference to FIG. FIG. 3 is an explanatory diagram of a conventional processing product table 8. Processing product table 8
It is composed of an item 8e having 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, for example, a bar code for specifying a product is set. The section area 8b is an area in which information for identifying the section to which the product belongs, for example, food or clothing, is set. The selling price area 8c is an area where 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 products to be counted for sales.

Returning to FIG. 2, the hard disk drive 7
Stores a program and data referred to by the processor 2 and a processing result of the processor, and further includes a product table 9 and a special sale table 10 referred to for generating the processing product table 8a. The product table 9 is the same as the processing product table 8, and includes a product code area 9a, a department area 9b, 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
This is an area in which the selling price (normal selling price) and the cost (normal cost) of a product to be sold during normal times (during normal business hours where no special discount is performed) are set.

Here, the structure of the special sale table 10 will be described with reference to FIG. FIG. 4 is an explanatory diagram of a conventional special sale table 10. As shown in FIG. As shown in the figure, the special sale table 10 includes a special sale period area 10a, 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 special sale period, that is, a date is set. Product code 10
“b” is an area where a product code for specifying a product to be sold is set. The special sale price area 10c is an area in which a sale price (special sale price) at the time of a special sale is set. The term “sale time” refers to, for example, a special business period in which a special discount is set and the product is sold.

Here, returning to FIG. 2, the operation of the conventional sales totaling apparatus 1 will be described. The hard disk device 7 is provided with a product table 9 and a special sale table 10. In the sales totaling apparatus 1 having the above configuration, the processing product table 8 does not exist in the memory 6 immediately after the activation. For this reason, the processor 2 includes a product table 9 and a special sale table 10 on the hard disk device 7.
, A process for constructing the processing product table 8 is performed.

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

The corresponding item 8 on the processing product 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 earlier, that is, the selling price. By performing the above processing for all items of the special sale table 10, the provisional processing product table 8 becomes a regular processing product table 8 that is referred to for totaling sales.

[0012]

Conventionally, the cost of the item 8e on the processing product table 8 for the product to be sold at a price corresponding to the normal selling price has been conventionally used. In general, products that carry out bargain sale are often set at a different cost from the normal cost (bargain sale price). There has been a problem that profit calculation and the like cannot be performed. The present invention has been made in view of the above points, and an object of the present invention is to provide a sales totaling device capable of improving the accuracy of gross profit calculation of a bargain product.

[0013]

SUMMARY OF THE INVENTION According to the present invention , normal sale price data indicating a unit price of a normal sale price , ordinary cost data at the time of purchase, and unit price of a special sale price are provided for each product code specifying a product.
Product table in which special price data indicating the special price and the special cost data at the time of purchase are set, and the special price is started.
And the sale period data indicating the end correspond to the product code
And a bargain table set, before the bargain table
Applicable to the current bargain period based on the bargain period data
The product code is determined, and less
And the special sale price data corresponding to the determined product code.
Data and the special cost data, and
Product table for gross margin and sales calculation based on data
And a special time control unit for generating a file .

[0014]

[Function] This device sets normal sales price data and normal cost data, special sales price data and special cost data in the product table, and uses the special sale period data in the special sale table to
It was out the gross margin counting processing for product code in between
For this purpose, a processing product table is generated using the special sale price data and the special cost data corresponding to the product code .

[0015]

DESCRIPTION OF THE PREFERRED EMBODIMENTS FIG. 1 is a conceptual diagram of a sales totalizing apparatus according to the present invention. The sales totaling device 11 shown in the figure is different from the sales totaling device 1 described above with reference to FIG. 2 in that a special time control unit 12 is provided in the processor 2 and the product table 13 on the hard disk device 7, The configuration of the special sale table 14 is different. The other configuration is the same as that of the related art, and the 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 area 13a, a department area 13b, a selling price area 13c, a cost area 13d, a special selling price area 13e, and a special selling cost area 13f.

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

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

Now, returning to FIG. 1, the operation of the sales totaling apparatus 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 totaling device 11 has been 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 construction process of the processing product table 8. First of all, the special time control unit 12 sets the special sale table 1
A search is made for the item 4 for which the period including the current date is set (step S1). When the corresponding item is extracted, the product code is read from the product code area 14b and temporarily stored in a register or the like which is a work area of the processor 2 (step S2).

Thereafter, the special time control unit 12 reads the contents of the product code 13a for each item of the product table 13 and determines whether or not the content matches the product code in the work area (step S3). If the result of step S3 is YES, that is, if the product codes match, the product code area 13a
Department area 13b, special sale price 13e, special 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, department area 13b, selling price area 13c, cost Area 13d
Is transferred to the processing product table 8 (step S
5). After steps S4 and S5, the product table 1
It is determined whether there is an item to be transferred on 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 process ends, and the processor 2 performs the sales totaling process with reference to the processing product table 8.

In this case, the gross profit calculation with reference to the processing product table 8 is performed based on the special sale price and the special sale cost for the special sale product, and based on the sales price and the cost for the other products. The results can be obtained reflecting the high cost.

By the way, the storage capacity required by each item of the product table 13 has a power-of-two bit configuration for easy management. For this reason, there is an area where no data is stored . By assigning a special sale price 13e and a special sale cost 13f to this area,
New data can be added without changing the storage capacity of each item of the processing product table 8.

When the current date passes 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 13 is displayed. Area 13e
The contents of the special sale cost area 13f are stored.

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.
And read the contents of the special sale cost 13f, and enter a new special sale price or special sale cost only when updating is necessary. In other cases, the previously set value can be diverted, eliminating the need for data entry. Can be.

[0027]

As described above, according to the sales summarizing apparatus of the present invention, when the cost fluctuates due to the fluctuation of the selling price, the gross profit calculating process is accurately performed based on the exact cost corresponding to the selling price.
It is possible to carry out management, it is possible to obtain an accurate sales processing results.

[Brief description of the drawings]

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

FIG. 2 is a conceptual diagram of a conventional sales aggregation 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 special 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 unit 13 Product table 14 Special sale table

Claims (1)

(57) [Claims] [Claim 1] Normal sales for each product code that specifies a product
Normal selling price data indicating the unit price of the price, normal cost data at the time of purchase , special selling price data indicating the unit price of the special selling price, and
The product table in which the special cost data at the time of purchase is set, and the special sale period data indicating the start and end of the special sale price are
Based on the bargain table set corresponding to the product code and the bargain period data in the bargain table,
The product code corresponding to the special sale period of
At least the product code determined from the product table
Corresponding special price data and special cost data
Gross profit and sales calculation based on the searched data
And a special time control unit for generating a product table for processing .