JPH0798788A - Device for managing one item - Google Patents

Abstract

PURPOSE:To accurately search and manage the change of unit price at the arrival of goods of the stock merchandise. CONSTITUTION:The sales change slip which changes the unit price at the arrival of goods specified when they come in into the sales unit price of the same product to be stored in a merchandise master file is automatically prepared and outputted. Every time when the sales unit price to be storey in the merchandise master file is changed, the corresponding sales change slip is automatically prepared and outputted. Thus, all the unit prices of the merchandise to be stocked and managed are integrated and managed by the sales unit price to be stored in the merchandise master file and the change of the unit price at the arrival of goods can be searched from the sales change slip to be automatically outputted at the arrival of goods and at the time of changing the unit price.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a single item management device used for a store processor of a POS (point of sale information management) system.

[0002]

2. Description of the Related Art Generally, a POS system used in a store such as a supermarket is as shown in FIG.
A plurality of POS terminals 1 for registering merchandise sales data and a file processor 2 are connected in a closed loop by a communication line 3, and the file processor 2 is connected to a store processor 4 such as a host computer by another communication line 5. Connected and configured.

The POS terminal 1 is equipped with a keyboard, a bar code scanner, a display unit, an input / output device such as a receipt / journal printer, and obtains and displays single product sales information by inputting a single product code from the bar code scanner.
1 by printing function, keyboard key operation input
It has functions such as obtaining total data of transactions, displaying, printing and issuing receipts.

The file processor 2 includes a single item file 6 and a relay file 7 in which individual item unique information such as a name and a unit price is set corresponding to the individual item code of each item. Upon receiving an information inquiry, a function of searching the single-piece file 6 and reading the corresponding single-piece unique information and transmitting the response. When the response transmission receives the single-piece sales information generated by the POS terminal 1, the information is stored in the relay file 7. It has the function to do.

The store processor 4 stores and manages single item information such as a selling unit price, a name, the number of stocks, the number of sales points, and the amount of sales corresponding to a single item code attached to each product in an external storage device such as a hard disk device. A single-item master file 8 is formed, and a function of creating the single-item file 6 in the file processor 2 based on the single-item information on the single-item master file 8, for example, stored in the relay file 7 in the file processor 2 after the end of a day's work It has a function of collecting the sold single-item sales information and updating the number of stocks, the number of sales points, the sales amount, etc. in the single-item master file 8.

A workstation 9 is connected to the store processor 4 and has a function of updating the data of the single item master file 8 by an operation input of the workstation 9. Specifically, when a business such as receipt, return, disposal, or inventory is performed, the stock quantity of the corresponding product is updated according to the business result. Further, when the unit price is changed due to a special sale or the like, the selling unit price of the corresponding product is updated.

Here, the store processor 4 functions as a single item management device for managing the unit price, the number of stocks, the sales, etc. of the products sold in the store in real time for each individual product.

By the way, in the chain store industry in which each sales office scattered over various places, such as a large-scale supermarket, is centrally managed by the sales office, the sales office is the manufacturer or wholesaler. It purchases a large amount of products in bulk and distributes them to each store for sale. In this case, the sales unit price of the product is determined by the store headquarters from the purchase price and the like, and the headquarters specifies the sales unit price of the product when delivering the product to each store. Each store sells the products that arrive at the unit price determined by the headquarters.

Further, the head office also manages the sale period and the designation of the sale item, and the sale unit price is designated and the sale item is distributed to each store during the sale period. However, it is very difficult for retailers to sell products for which the sale unit price is specified during the special sale period and to switch to products for which the normal sale unit price is specified after the sale period ends. . For this reason, during the special sale period, products that were received with the normal sale unit price specified were sold at the special sale price, or after the special sale period, the special sale price was specified and received. It was often done to sell the product at the normal selling unit price.

In this case, as seen from the store headquarters, the former unit has a decrease in sales unit price, and the latter unit has an increase in sales unit price. Such a change in the selling price is not reflected in the single item sales information at the POS terminal like the price reduction (discount, discount, etc.) that occurs when the customer purchases the product. Therefore, at each retailer, each time a retail price change occurs, a sales change slip that records the content of the retail price change is issued, and the retail store headquarters manages it in order to deal with the retail price change at each retail store. Had to do.

[0011]

However, in order to issue a sales change slip as described above, the sales unit price specified by the headquarters for the product when the clerk displays the product in stock at the sales floor. , And the current selling price of the same product must be checked at all times, but in practice, it is difficult to carry out such a checking operation, and a sales sales slip has not been created. For this reason, the actual situation is that it is not possible to accurately manage price cuts and price increases due to changes in designated unit prices that occur at each store.

In view of the above, the present invention can automatically create and output a sales change slip for changing the unit price at the time of arrival of goods specified at the time of arrival of goods into the sales unit price of the same goods stored in the goods master file. Every time there is a change in the sales unit price stored in the file, a corresponding sales conversion slip can be automatically created and output, so that the unit prices of products managed in inventory are all integrated with the sales unit price stored in the product master file. It is intended to provide a single item management device that can accurately track and manage the change of the unit price at the time of receipt from the sales change slip that is automatically output at the time of arrival or when the unit price is changed. .

[0013]

[Means for Solving the Problems] The first invention of the present application is to sell a unit price corresponding to a single code attached to each product,
A single product master file that stores and manages single product information such as name and quantity of stock, and a single product that controls single product sales registration at a product sales data registration terminal connected via a communication line based on the single product information in this single product master file. In the management device, a stock information input means for inputting a single product code, the number of received products, and a unit price at the time of shipment, and a stock number corresponding to the input single product code of the single product master file when the information of the received product is inputted by this input means. The stock inventory update means that adds and updates the stock quantity by the number of arrivals, and the sales unit price on the single item master file of the in-stock item whose inventory quantity is updated by this update means and the unit price at the time of arrival entered by the input means are compared. When the unit price comparison means and the unit price difference are confirmed by this comparison means, the unit price at the time of arrival is the unit price before change, the unit price at sale is the unit price after change, and the number of units received is the unit price. Selling variation slip data editing means for editing the sales variation slip data as the quantity of the changed product, and unit price change information generating means for generating the information of the individual product code and the new unit price of the product requiring the modification of the sales unit price in the individual product master file When the unit price change information is generated by the generating unit, the unit price change processing unit that changes the unit selling price corresponding to the generated unit item code in the unit item master file to a new unit price, and the unit selling price is changed by this processing unit. Edit the sales slip voucher data with the unit sales price before the product change as the unit price before the change, the unit sales price after the change as the unit price after the change, and the inventory quantity corresponding to the unit product code generated in the unit product master file as the unit price change product quantity When changing the unit price, the sales variation slip data editing means,
The sales variation slip output means for outputting the sales variation slip in a predetermined format based on the sales variation slip data edited by each of the slip data editing means.

The second invention of the present application is, in addition to the first invention, a return information input means for inputting a single item code of the returned product, the number of returned products, and a unit price at the time of arrival, and information of the returned product is input by this input means. Then, the stock number corresponding to the single item code is input and the stock number for the returned goods is updated by subtracting the stock number corresponding to the single item code, and the sales unit price of the returned product whose stock number is updated by this updating unit is input as the unit price in the single item master file. When comparing the unit price at the time of return that compares the unit price at the time of arrival entered by the means, and when the unit price is confirmed to be inconsistent by this comparing means, the selling unit price is the unit price before the change and the unit price at the time of the change is the unit price after the change. Provided with a sales variation slip data editing means at the time of return, which edits the sales variation slip data as the quantity of the unit price changed product,
It is possible to output the sales conversion slip based on the sales conversion slip data edited by the sales conversion slip data editing means at the time of return.

The third invention of the present application is, in addition to the first invention of the present application, a disposal information input means for inputting a single product code and the number of discarded products of the disposal product, and a single product when the information of the disposal product is inputted by this input means. The unit price before discarding is the unit for updating inventory at disposal to update the stock number corresponding to the input single item code of the master file by the number of discarded items, and the unit selling price on the single item master file of the discarded item whose inventory number is updated by this updating unit. Selling change voucher data editing means for editing the selling change voucher data editing means for editing the selling change voucher data as the unit price after changing zero and the number of scrapped products as the unit price change. It is possible to output a sales change slip based on.

The fourth invention of the present application is, in addition to the first invention of the present application, an inventory information input means for inputting a single item code and the number of inventories of the inventory product, and a single item when the information of the inventory product is input by this input means. The inventory inventory update means that changes the stock quantity corresponding to the input single item code of the master file to the inventory quantity, and the inventory quantity before the inventory goods update whose inventory quantity is updated by this update means and the entered inventory quantity When the inventory quantity is greater than the inventory quantity by this quantity comparison means and the comparison means, the unit sales price on the single item master file of the inventoried product is the unit price before change, and the unit price after change is zero. Is used as the unit price change product quantity and the first inventory change variable slip data editing means for editing the sales change slip data, and when the inventory quantity is less than the inventory quantity by the comparing means, zero is taken as the unit price before change. shelf A second inventory sales variable slip data editing means is provided for editing the sales variable slip data as the unit price after changing the sales unit price of the product single item master file and the unit price change as the difference between the stock number and the inventory number. It is possible to output the sales change voucher based on the sales change voucher data edited by the first and second inventory sales change voucher data editing means.

In a fifth aspect of the present invention, the single-item master file in the first aspect of the invention stores and manages single-item sales information such as sales points, sales amount, discount points, and discount amounts together with single-item information. A product settlement data collection device that collects individual product sales information of each product registered for sales through a communication line and updates the individual product sales information in the individual product master file, and a single product master file after the data is updated by this settlement device. Product-specific average sales unit price calculation means for calculating the average sales unit price for each product from each of the sales unit price, discount amount and discount point information stored in, and the product-specific average sales unit price calculated by this calculation device and the corresponding product The unit price comparison means at the time of settlement to compare the unit price at the time of settlement and the unit price before change when the disagreement of both unit prices is confirmed by this comparing unit, and the average unit price is calculated as the unit price before change. Selling change voucher data editing means for editing the sales change voucher data that edits the sales change voucher data as the unit price after the renewal and the number of discount points as the unit price change. It is possible to output a sales change slip based on.

[0018]

In the first invention of the present application, when the unit code, the number of items received, and the unit price at the time of arrival (sales unit price designated by the store headquarters) are input, the number of items received will be added to the number of items in stock in the individual item master file. Is added, and the sales unit price of the received product in the single product master file is compared with the unit price at the time of arrival. If the two unit prices do not match, a sales change slip is output in which the unit price before receipt is the unit price before change, the unit price after sale is the unit price after change, and the number of items received is the quantity of the unit price changed product. That is, the sale change processing is performed to change the unit price at the arrival of the received product to the sale unit price of the corresponding product on the single item master file, and the sale change slip corresponding thereto is automatically output.

Further, when the information of the single item code and the new unit price of the product requiring the change of the selling unit price on the single item master file is generated, the selling unit price of the corresponding product in the single item master file is changed to the new unit price and is changed. A sales conversion slip is output in which the previous sales unit price is the unit price before the change, the sales unit price after the change is the unit price after the change, and the inventory quantity of the corresponding product in the unit product master file is the quantity of the unit price changed product. That is, the sale change processing for changing the old unit price of the product requiring the unit price change to the new unit price is performed, and the sale change slip corresponding thereto is automatically output.

As a result, the unit prices of all products managed as inventory at the store are always integrated and managed by the sales unit price in the unit product master file. It will be possible to accurately track and manage changes (price reduction, price increase) from the sales change slip.

For example, if the sales unit price at the time of receipt of a product whose unit price at the time of arrival is 100 yen is 80 yen, a sales change slip of 20 yen price reduction is output. After that, when the sales unit price of this product is changed to 90 yen, a sales change slip of 10 yen price increase is output. Therefore, at this point, it can be seen that the product is sold from the two sales slips with the price reduced by 10 yen with respect to the unit price at the time of arrival.

In the second invention of the present application, when the product code is returned, the single item code, the number of returned products, and the unit price at the time of arrival are input, the returned product number is subtracted from the stock number of the returned products in the single product master file. At the same time, the selling unit price of the returned product in the unit product master file is compared with the unit price at the time of arrival. If the two unit prices do not match, a sales change slip in which the selling unit price is the unit price before the change, the unit price at the time of arrival is the unit price after the change, and the number of returned products is the quantity of the unit price changed product is output. As a result, it is possible to reliably obtain a sales change slip indicating that the selling unit price of the returned merchandise has been changed to the unit price at the time of arrival.

Further, in the third invention of the present application, when the individual product code and the number of discarded products of the discarded product are input when the product is discarded, the number of discarded products is subtracted from the stock number of the discarded products in the single product master file, and A sales change slip in which the selling unit price of the discarded product in the master file is the unit price before the change, zero is the unit price after the change, and the number of discarded products is the quantity of the unit price changed product is output. As a result, it is possible to reliably obtain a sales change slip indicating that the selling unit price of the discarded product has been changed to 0 yen.

Further, in the fourth aspect of the present invention, when a stock item code and the number of stocks of the stocked product are input when stocking of the product is carried out, the stock quantity of the stocked product in the single product master file is changed to the stock quantity. , The inventory quantity before the change and the inventory quantity are compared. If the inventory quantity is greater than the inventory quantity, the unit sales price on the single item master file of the inventory goods is the unit price before change, and the unit price is zero after change.The difference between the inventory quantity and the inventory quantity is the quantity of the unit price change product. A sales change slip is output. On the other hand, if the number of stocks is less than the number of stocktakings, a sales change slip is output in which zero is the unit price before change, the selling unit price is the unit price after change, and the difference between the number of stocks and the number of stocktakings is the quantity of the unit price changed product.

If the number of stocks in the single item master file is larger than the number of stocktakings, the stocked products have been lost due to shoplifting, etc., so a sales change slip indicating that the sales unit price of the lost product has been changed to 0 yen It is definitely obtained. On the other hand, when the number of stocks in the single item master file is less than the number of stocktakings, there are some unmanaged stocks of stocked products, so the assumed unit price of 0 yen for the unmanaged stocks is changed to the current sales unit price. You can certainly get a sales change slip that shows that.

Further, in the fifth aspect of the present invention, when the sales settlement operation is executed, the individual items are stored and managed in the individual item master file according to the individual item sales information of each item registered for sale by the item sales data registration terminal. The individual item sales information such as the number of sales points, the amount of sales, the number of discount points, and the amount of discount is updated. After that, the average selling unit price is automatically calculated from the information on the selling unit price, the discount amount, and the discount points for each product, and the average selling unit price is compared with the selling unit price of the corresponding product. If the two unit prices do not match, a sales change slip is output in which the selling unit price is the unit price before change, the average selling unit price is the unit price after change, and the discount points are the quantity of the unit price change product. As a result, it is possible to surely obtain a sales change slip showing the amount of the unit price changed by the discount at the time of sales registration at the product sales data registration terminal.

[0027]

DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment in which the present invention is applied to the store processor 4 of the POS system shown in FIG. 17 will be described below with reference to the drawings.

FIG. 1 is a block diagram showing a main configuration of the store processor 4. This store processor 4
Includes a CPU (central processing unit) 11 as a control unit main body, and a ROM (read only memory) 12 and a RAM (random access memory) 13 as a main storage unit.

The store processor 4 is also equipped with a hard disk device 14 and a floppy disk device 15 as external storage devices, and the HDD controller 16 controls data input / output between the CPU 11 and the hard disk device 14, and the CPU 11 Data input / output between the FDD controller 17 and the floppy disk device 15
Is controlled by.

Further, the store processor 4 has a keyboard interface 1 as well as a communication interface 18 for controlling data communication performed through the communication line 5.
9, an input / output device interface such as a printer interface 20 and a display interface 21 is mounted. The keyboard 9-1 that constitutes the workstation 9 is connected to the keyboard interface 19.
A CRT display device 9-2 which also constitutes the workstation 9 is connected to the display interface 21.
Also, the printer interface 20 includes a slip printer 2
2 is connected.

The store processor 4 also has a built-in clock circuit 23 for counting the current date and time.

The voucher printer 22 prints and issues a sales change voucher 30 in a predetermined format shown in FIG. The sales change slip 30 includes a series of slip numbers 31, a slip classification 32 indicating that it is a sales change slip, and a date 33, followed by a single item code, an item name, a class, a unit price before change, a quantity, a sale price before change (= change). Unit price before × quantity), unit price after change, quantity,
Selling price after change (= unit price after change x quantity), selling price change amount (=
Sale change slip data 34 consisting of (sales price after change-sale price before change)
Is recorded up to 10 lines (34-1, 34-2, ..., 34-9,
34-0), and the total selling price change amount of 35 is recorded.

In the hard disk device 14, as shown in FIG. 3, a single item master file 41, a receipt slip file 42, a discard file 43, an inventory count file 44, a unit price change reservation file 45, a unit price change log file 46, and a sales transaction file. Various data files such as 47 are formed in advance.

Incidentally, the single master file 41 is shown in FIG.
As shown in, corresponding to the individual product code 51 attached to each product sold in the store, the individual product information such as the class code 52 to which the product belongs, the individual product name 53, the selling unit price 54, and the stock number 55 are stored and managed. In addition, the daily sales information of individual items such as the number of sales 56, the amount of sales 57, the number of discount points 58, and the amount of discount 59 is stored and managed.

The receipt slip file 42 is a file for accumulating the data of the receipt slip attached to the product received from the store headquarters and the return slip issued when the product is returned to the store headquarters, and the discard file 43 is The inventory accumulation file 44, which is a file for accumulating data of discarded products, is a file for accumulating and storing data obtained as a result of the inventory work.

The unit price change reservation file 45 is a file for registering unit price change information such as a unit price code, a new unit price, and a unit price change date of a product whose unit price needs to be changed due to a special sale, and the unit price change log file 46 is a unit price. This is a file that stores changes such as the single item code, old unit price, new unit price of the changed product.

The sales transaction file 47 is the single-item sales information collected from the relay file 7 of the file processor 2 via the communication line 5 (the single-item code, the number of sales points, and the sales amount generated by the single-item sales registration work at each POS terminal 1). ，
This is a file that temporarily stores information such as discount points and discount amounts.

Therefore, the CPU 11 of the file processor 4 in particular performs the slip input operation shown in FIG.
The disposal operation shown in Fig. 7, the inventory operation shown in Fig. 7, the unit price changing operation shown in Fig. 8 and the daily total settlement operation shown in Fig. 9 are programmed to selectively execute the predetermined key operations on the keyboard 9-1. There is.

The flow of each work will be specifically described below.

When a slip input operation is selected by operating a predetermined key on the keyboard 9-1, the CPU 11 first waits for the input of information on the receipt slip or the return slip, as shown in FIG. Then, as the information of the receipt slip or the return slip, the slip number, slip classification, supplier code, receipt or return date,
When information such as the individual item code of the received product or the returned product, the number of received or returned products, and the unit price at the time of arrival (sales unit price specified by the store headquarters) is entered by key, these input information are additionally registered in the inbound delivery file 42. In order to do so, the receipt slip file 42 is updated. Here, the keyboard 9-1 constitutes an arrival information input means and a return information input means.

Next, the entered slip classification is checked. When the slip classification indicates an incoming slip, single item information such as a class code, a single item name, and a selling unit price corresponding to the single item code input from the single item master file 41 is read. Then, the unit price T1 at the time of arrival and the unit price T2 at the sale are compared (unit price comparison unit at the time of arrival).

As a result, when a discrepancy between the unit prices T1 and T2 is confirmed, the unit price T1 at the time of arrival is set as the unit price before change,
The sale conversion slip data 34 is edited by setting the sales unit price T2 as the unit price after change and using the input number of received items as the quantity of the unit price changed product. In the sales conversion slip data 34, the single product code is the input single product code, the product name and class code are the single product name and class code read from the single product master file 41, and the selling price before change, the selling price after change and the selling price change The amount of money is a calculated value from the unit price before change, the unit price after change and the quantity (sales change slip data editing means upon receipt).

When it is confirmed that the unit prices T1 and T2 match each other, the above-mentioned sales conversion slip data editing process is not performed.

After that, the number of stocks is added and updated to the number of stocks corresponding to the individual product code of the in-stock product on the individual product master file 41 (inventory inventory updating means).

On the other hand, when the slip classification indicates a return slip, the single item information such as the class code, the single item name, and the selling unit price corresponding to the single item code input from the single item master file 41 is read. Then, the unit price T1 at the time of arrival and the unit price T2 at the sale are compared (unit price comparison unit at the time of return).

Accordingly, when it is confirmed that the unit prices T1 and T2 do not coincide with each other, the selling unit price T2 is the unit price before the change, the unit price T1 at the time of arrival is the unit price after the change, and the entered number of returned goods is the quantity of the unit price changed product. The sales conversion slip data 34 is edited as (sales conversion slip data editing means at the time of return).

When it is confirmed that the unit prices T1 and T2 match each other, the above-mentioned sales conversion slip data editing process is not performed.

After that, the number of returned products is subtracted from the number of stocks corresponding to the individual product code of the in-stock product on the single product master file 41 and updated (returning stock update means).

After that, when the information of the next receipt slip or return slip is input, the above process is repeated. Also, if a key input is issued to instruct the end of work,
Based on the edited sales change slip data, the slip sales slip 30 is printed out by the slip printer 22, and the slip input operation is completed. Here, the slip printer 22 constitutes a sales change slip output means.

When the discard operation is selected by operating a predetermined key on the keyboard 9-1, the CPU 11 first waits for the input of the discard information, as shown in FIG. Then, when the discard information such as the individual product code of the discarded product and the number of discarded products is key-input, the discard file 43 is updated to additionally register the input information in the discard file 43. Here, the keyboard 9-1 constitutes a discard information input means.

Next, single item information such as a class code, a single item name, and a selling unit price corresponding to the single item code input from the single item master file 41 is read. Then, the sales unit price is set as the unit price before change, zero is set as the unit price after change, and the sales conversion slip data 34 is edited with the input discard quantity as the quantity of the unit price changed product (sales conversion slip data editing means at disposal).

After that, the discard number is updated by subtracting the discard number from the inventory number corresponding to the individual item code of the abandoned item on the individual item master file 41 (inventory updating unit).

After that, when the information of the next discarded product is input, the above process is repeated. Further, when a key input for instructing the end of work is made, the sales change slip 30 is displayed by the slip printer 22 based on the edited sales change slip data.
Is printed out, and this disposal operation is completed.

When the stocktaking operation is selected by operating a predetermined key on the keyboard 9-1, the CPU 11 first waits for the input of stocktaking information, as shown in FIG. Then, when inventory information such as the individual item code of the inventory item and the inventory number (actual inventory number) is key-input, the inventory aggregation file 44 is updated to additionally register the input information in the inventory inventory file 44. Here, the keyboard 9-1 constitutes an inventory information input means.

Next, the individual item information such as the class code, the individual item name, the selling unit price, and the stock quantity corresponding to the individual item code input from the individual item master file 41 is read. Then, the input inventory quantity S1 is compared with the inventory quantity S2 read from the single item master file 41 (quantity comparing means).

As a result, when the stock quantity S2 is larger than the stocktaking quantity S1, the sales unit price of the stocked merchandise read from the single item master file 41 is the unit price before change, zero is the unit price after change, and the inventory quantity S2 is counted. Value S2-S obtained by subtracting the number S1
The sales conversion slip data is edited with 1 as the quantity of the unit price changed product (first inventory sales conversion slip data editing means).

On the other hand, when the stock quantity S2 is smaller than the stocktaking quantity S1, zero is set as the unit price before change, and the single item master file 4
The sales unit price of the inventoried product read from 1 is used as the unit price after the change, and the value S1-S2 obtained by subtracting the inventory count S2 from the inventory count S1 is used as the quantity of the unit price change product, and the sales change slip data is edited (second inventory count). Sales slip data editing means).

After that, the stock quantity corresponding to the stock code of the stocked goods on the stocked master file 41 is changed to the input stock quantity (inventory stock updating means).

If the stock quantity S2 and the stocktaking quantity S1 match, the above processing is not performed.

After that, when the information of the next inventory product is input, the above process is repeated. Further, when a key input for instructing the end of work is made, the sales change slip 30 is displayed by the slip printer 22 based on the edited sales change slip data.
Is printed out and the inventory work is completed.

When the unit price change work is selected by operating a predetermined key on the keyboard 9-1 (usually selected before the opening of the store for one day), the CPU 11 first, as shown in FIG. To search. Then, when the unit price change information in which the unit price change date matches the current date measured by the clock circuit 23 is acquired, the unit code and the new unit price in the unit price change information are read out (unit price change information generating means).

Then, the selling unit price (old unit price) corresponding to the unit code of the unit master file 41 is changed to the new unit price. Further, the unit price change log file 46 is updated to additionally register the changed contents such as the unit price code, old unit price, new unit price, etc. in the unit price change log file 46 (unit price change processing means).

Next, the old unit price (sales unit price before change) additionally registered in the unit price change log file 46 is used as the unit price before change, and the new unit price (sales unit price after change) is used as the unit price after change. The sales variation slip data 34 is edited with the stock quantity corresponding to the code as the quantity of the unit price change product (sales variation slip data editing means at the time of changing the unit price).

In this way, the unit price change reservation file 45 is sequentially searched, and when the above process is completed for all the products requiring unit price change, the sales change slip 30 is printed by the slip printer 22 based on the edited sales change slip data. Output and end this unit price change operation.

When the daily checkout operation is selected by operating a predetermined key on the keyboard 9-1 (usually selected after the store is closed for one day), the CPU 11 first sets the sales transaction file 47 as shown in FIG. The collected single item sales information (single item code, number of points sold, amount of sale, number of discount points, amount of discount) is sequentially read, and the daily total area (number of points of sale, amount of sales, Cumulatively update the discount points and discount amount). Also, the number of sales points is subtracted from the number of stocks corresponding to the corresponding single item code in the single item master file 41 (sales settlement means).

When the above processing is completed for all the single item sales information collected in the sales transaction file 47, next, from the first record of the single item master file 41, a single item code, a class code, a single item name, and a selling unit price. ，
Read each data of discount amount and discount points. Then, the average selling unit price U is calculated for each record by the following formula (1).
1 is calculated (mean sales unit price calculation means for each product) Average sales unit price U1 = Sales unit price U2- (Discount amount / Discount points) (1) Next, this average sales unit price U1 and sales unit price U2 are compared. If the unit price U1 and U2 do not match, the selling unit price U2 is the unit price before the change, the average selling unit price U1 is the unit price after the change, and the discount points are the unit price change products. The sales variation slip data 34 is edited as the quantity of (the sales variation slip data editing means at the time of settlement).

If it is confirmed that the unit prices U1 and U2 are the same, the above-mentioned sales conversion slip data editing process is not performed.

In this way, if the above-mentioned processing is executed for all the records of the single item master file 41, the sales change slip 30 is printed out by the slip printer 22 based on the edited sales change slip data, and this slip input operation is completed. To do.

In the store processor 4 of the present embodiment configured as described above, when the goods are received and the arrival slip is acquired, the slip input work is selected by the operation input of the keyboard 9-1 and then the slip is displayed on the slip. Slip number, slip classification,
Supplier code, arrival date, individual item code of the item received, number of items received, unit price at the time of receipt (sales unit price specified by the store headquarters)
Key in etc.

Then, the number of items received is added to the number of items in stock in the single item master file 41, and
The unit price T1 at the time of arrival is compared with the unit price T2 of the arrival product in the single item master file 41. And both unit price T
When the disagreement between T1 and T2 is confirmed, the sales conversion slip data 34 in which the unit price T1 at the time of arrival is the unit price before the change, the unit price T2 is the unit price after the change, and the number of items received is the quantity of the unit price changed product is edited, The sales slip 30 is printed out by the slip printer 22. That is, the sale change processing for changing the unit price at the time of arrival of the received product to the sale unit price of the corresponding product on the single item master file 41 is performed, and the sales change slip 30 corresponding thereto is automatically output.

FIG. 10 shows a product AAA whose unit price is 88 yen when received.
This is an output example of the sales conversion slip 30-1 when the sales unit price of the product AAA is 100 yen when 360 items are received.
By checking this sales change slip 30-1, the newly received product AAA is 12 per unit against the unit price at the time of arrival.
You can see that the stock is managed with a price increase of 4320 yen for all 360 yen.

On the other hand, for example, when the unit price change operation is selected by operating the keyboard 9-1 before opening the store, the unit price change reservation file 45 is searched and the unit product code of the product for which the unit sales price on the unit product master file 41 needs to be changed. When the information on the new unit price is generated, the selling unit price of the corresponding product in the unit item master file 41 is changed to the new unit price, and the contents of the unit price change are stored in the unit price change log file 46.

Further, the sales change slip data in which the sales unit price before the change is the unit price before the change, the sales unit price after the change is the unit price after the change, and the stock number of the corresponding product in the single product master file 41 is the quantity of the unit price changed product. 34 is edited, and the sales change slip 30 is printed out by the slip printer 22. That is, the sale change processing for changing the old unit price of the product requiring the unit price change to the new unit price is performed, and the sale change slip 30 corresponding thereto is automatically output.

FIG. 11 shows an output example of the sales change slip 30-2 when the selling unit price of the product AAA is changed from 100 yen to 88 yen, and the number of stocks is 417. This sales slip 3
Inventory is managed by checking 0-2 417
It can be seen that the unit price is changed by 12 yen for each product AAA, and the price of all 417 products is reduced by 5004 yen.

As a result, the unit prices of all commodities managed as inventory at the store are always managed by being integrated with the unit price on the unit master file 41. As a result, at the time of arrival and every time a unit price change occurs, a change in the unit price at the time of arrival of the product under inventory management (price reduction, price increase) is made into the sales conversion slip 30-1,
You will be able to track accurately from 30-2.

Further, in the store processor 4, when a merchandise item is returned and a return slip is acquired, the slip input operation is selected by operating the keyboard 9-1 as in the case of receiving the goods, and then the return slip is displayed. Slip number, slip classification, supplier code, return date, single item code of returned product,
Number of returned goods, unit price at the time of arrival (check from the invoice of returned goods)
Key in etc.

Then, the number of returned products is subtracted from the stock number of returned products in the single item master file 41, and the unit price T1 at the time of arrival is compared with the sales unit price T2 of the returned products in the single item master file 41. When the disagreement between the unit prices T1 and T2 is confirmed, the sales unit price T2 is the unit price before the change, the unit price T1 at the time of arrival is the unit price after the change, and the sale sales slip data 34 in which the number of returned products is the quantity of the unit price changed product is obtained. After being edited, the slip printer 30 prints out the sales change slip 30. That is, the sale change processing for changing the sale unit price on the single item master file 41 of the returned product to the unit price at the time of arrival is performed, and the sale change slip 30 corresponding thereto is automatically output.

FIG. 12 shows an output example of the sales conversion slip 30-3 when 24 items AAA whose unit price for sale is 100 yen and whose unit price for receipt is 88 yen are returned. By checking this sales change slip 30-3, the price of the returned goods AAA will be reduced by 12 yen per unit, 288 yen per 24 units,
In other words, it can be seen that the unit price was returned when the product arrived, and it was returned.

Further, in the store processor 4, when the disposal of the product occurs, the disposal operation is selected by the operation input of the keyboard 9-1 and then the individual product code and the discard number of the discarded product are key-inputted.

Then, the number of discarded products is subtracted from the stock number of discarded products in the single item master file 41, the selling unit price of the discarded products in the single item master file 41 is set as the unit price before change, zero is set as the unit price after change, and the number of discarded items is set. The sale-change slip data 34, which is the quantity of the unit price changed product, is edited, and the sale-change slip 30 is printed out by the slip printer 22. That is, the sale change processing of changing the sale unit price on the single item master file 41 of the discarded product to 0 yen is performed,
The sales conversion slip 30 corresponding thereto is automatically output. As a result, it is possible to reliably obtain the sales conversion slip 30 indicating that the disposal unit price of the discarded product has been changed to 0 yen and the product has been discarded.

FIG. 13 shows a product AAA whose selling price is 100 yen.
It is an output example of the sales conversion slip 30-4 when two of the two are discarded. By checking the sales change slip 30-4, it can be understood that the product AAA for which inventory management has been performed caused a loss corresponding to the sales unit price due to disposal.

In the store processor 4, when inventory work is performed and inventory information of each product is generated, the inventory operation is selected by operating the keyboard 9-1 and then the individual item code and inventory of the inventory product are selected. Key in the number.

Then, the inventory number S2 of the inventory items in the single item master file 41 is compared with the input inventory number S1. Then, when the inventory quantity S2 is greater than the inventory quantity S1, the selling unit price on the single item master file 41 of the inventory item is the unit price before change, the unit price after change is zero, and the inventory quantity S1 is subtracted from the inventory quantity S2. The sales conversion slip data 34 having the value as the quantity of the unit price changed product is edited, and the sales conversion slip 30 is output by the slip printer 22. On the other hand, the stock quantity S
If 2 is less than the inventory count S1, zero is the unit price before the change, the sales unit price is the unit price after the change, and the value obtained by subtracting the inventory number from the inventory count is the quantity of the unit price changed product.
Is edited and the sale-change slip 30 is output by the slip printer 22.

FIG. 14 shows a product AAA whose sales unit price is 100 yen.
The stock number S2 in the single item master file 41 of is the inventory number S1
It is an output example of the sales conversion slip 30-5 when there are eight more than the above. By checking this sales change slip 30-5, 8 of the products AAA managed in inventory are lost due to shoplifting, etc., and there is a loss of the sales unit price per one in inventory management. I understand.

FIG. 15 shows a product AAA whose sales unit price is 100 yen.
The stock number S2 in the single item master file 41 of is the inventory number S1
It is an output example of the sales change slip 30-6 when there are three less than. By checking the sales change slip 30-6, it can be seen that the three products AAA are present as unmanaged inventory, and a profit corresponding to the sales unit price per one is generated in inventory management.

Further, in the store processor 4, single item sales information of each product registered for sale at each POS terminal 1 is collected via the file processor 2 and sequentially stored in the sales transaction file 37. After the store is closed, when the daily total settlement operation is selected by operating the key on the keyboard 9-1, the daily total area of the individual item master file 41 is cumulatively updated by the all individual item sales information stored in the sales transaction file 37. Also, the sales quantity is subtracted from the stock quantity of the file 41 and updated.

Thereafter, the average selling unit price U is calculated from the above equation (1) for each item-specific data of the individual item master file 41.
1 is calculated, and when the average selling unit price U1 and the corresponding selling unit price U2 do not match, that is, in the case of a product for which a unit price change has occurred due to a discount at the time of sales registration at the POS terminal 1, A sales change slip 30 is output in which the selling unit price U2 is the unit price before the change, the average selling unit price U1 is the unit price after the change, and the discount points are the quantity of the unit price changed product.

FIG. 16 shows an output example of the sales conversion slip 30-7 when a discount of 40 yen in total is made for only two points when the sales AAA of the product AAA of the sales unit price of 100 yen is registered. In this case, the average selling unit price U1 is [100− (40/2) = 80] yen, and by checking this sales change slip 30-7, the product AAA has a unit price of 40 yen due to the price reduction at the time of sales registration. You can see that a change has occurred.

The present invention is not limited to the above embodiment. For example, in the above-mentioned embodiment, the keyboard 9-1 is used as each input means of the arrival information, the returned goods information, the disposal information, and the inventory information, but other data input devices (handy terminal, scanner, touch panel, etc.) may be used. It goes without saying that it is good.

Although the slip printer 22 is shown as the sales change slip output means, the screen of the sales change slip may be displayed and output on the CRT display device 9-2. Further, it is possible to transmit and output the image data of the sales change slip to the host computer of the store headquarters through the communication line, and to print or display output on the host computer side.

In addition to the above, various kinds of files can be formed on a storage medium such as a floppy disk or a RAM, and various modifications can be made without departing from the scope of the invention.

[0092]

As described above in detail, according to the present invention, a sales change slip for automatically changing the unit price at the time of arrival of a product specified at the time of arrival of the product to the sales unit price of the same product stored in the product master file is automatically created. It is possible to automatically output a corresponding sales change slip every time there is a change in the sales unit price stored in the product master file. Therefore, it is possible to integrate and manage the unit price of the products managed in inventory with the sales unit price stored in the product master file. Therefore, the unit price at the time of arrival from the sales conversion slip that is automatically output at the time of arrival or when the unit price is changed. It is possible to provide a single-item management device capable of accurately tracking and managing changes in the.

Further, it is possible to automatically obtain a sales change slip indicating that the selling unit price of the returned product has been changed to the unit price at the time of arrival by simply inputting the information of the returned product.

Further, by simply inputting the information of the discarded product, it is possible to automatically obtain the sales change slip for the loss due to the disposal of the product.

Further, by simply inputting the information of the inventoried goods, it is possible to automatically obtain the lost sales sales slip for the lost goods and the additional sales sales slip for the unmanaged inventory.

Furthermore, there is an effect that a sales change slip showing the portion whose unit price is changed by a discount at the time of registration of sales at the POS terminal can be obtained.

[Brief description of drawings]

FIG. 1 is a block diagram showing a main configuration of a store processor according to an embodiment of the present invention.

FIG. 2 is a plan view showing a format of a sales conversion slip printed out by the embodiment.

FIG. 3 is a diagram showing a main file structure formed in the hard disk device of the embodiment.

FIG. 4 is a diagram showing a record format of the single item master file shown in FIG.

FIG. 5 is a flowchart showing a slip input operation executed by the CPU of the embodiment.

FIG. 6 is a flowchart showing a discarding work executed by the CPU of the embodiment.

FIG. 7 is a flowchart showing inventory work executed by the CPU of the embodiment.

FIG. 8 is a flowchart showing a unit price change operation executed by the CPU of the embodiment.

FIG. 9 is a flowchart showing a daily total settlement task executed by the CPU of the embodiment.

FIG. 10 is a plan view showing an example of output of a sales variation slip upon arrival in the embodiment.

FIG. 11 is a plan view showing an output example of a sales change voucher when a unit price is changed in the embodiment.

FIG. 12 is a plan view showing an output example of a sales variation slip at the time of return in the embodiment.

FIG. 13 is a plan view showing an example of output of an odd sale voucher at the time of disposal in the embodiment.

FIG. 14 is a plan view showing an example of output of a strange slip at the time of inventory in the same embodiment.

FIG. 15 is a plan view showing an example of output of an inventory voucher strange slip in the embodiment.

FIG. 16 is a plan view showing an example of output of a variable sales slip at the time of settlement in the embodiment.

FIG. 17 is a schematic diagram showing a schematic configuration of a general POS system.

[Explanation of symbols]

 1 ... POS terminal (terminal for registering product sales data) 4 ... Store processor (single item management device) 9-1 ... Keyboard 9-2 ... CRT display device 11 ... CPU 14 ... Hard disk device 22 ... Voucher printer 30 ... Sales change Voucher 41 ... Single master file

Claims (5)

[Claims] 1. A single product master file that stores and manages single product information such as a sales unit price, name, and inventory quantity corresponding to a single product code assigned to each product, and a communication line is based on the single product information on the single product master file. In the single-item management device that controls the single-item sales registration at the product sales data registration terminal connected via, the receipt information input means for inputting the single-item code, the number of items received, and the unit price at the time of arrival When the information of the received goods is input, the stock-in-stock updating means for adding and updating the stock quantity corresponding to the input single-piece code of the single-piece master file with the arrival quantity, and the stock quantity of the arrival goods whose inventory quantity is updated by the updating means Incoming unit price comparison means that compares the selling price on the single item master file with the input unit price at the time of arrival, and this comparison means confirms the disagreement between both unit prices And the arrival time of sale strange slip data editing means for editing the Uhen slip data as the quantity of the stock number of the unit price change products and the sales price after the change unit price as before the change of the stock at the unit price bid,
Unit price change information generating means for generating unit price code and new unit price information of a product requiring a change in sales unit price on the unit price master file, and generation of the unit price master file when unit price change information is generated by this generating means. Unit price change processing means for changing the sales unit price corresponding to the single unit code to the new unit price, and the sales unit price of the product whose sales unit price is changed by this processing means the unit price before change and the unit sale price after change A unit price change sales change slip data editing means for editing the sales change slip data as the subsequent unit price and the inventory quantity corresponding to the generated single product code in the single product master file as the unit price change product quantity, and each of the slip data editing means And a sales change slip output means for outputting a sales change slip having a predetermined format based on the sales change slip data edited by Management device. 2. A returned product information input means for inputting a single product code of a returned product, the number of returned products, and a unit price at the time of arrival, and when information of the returned product is inputted by this input device, it corresponds to the input single product code of the single product master file. At the time of a return, in which the inventory quantity is subtracted by the number of returned goods and updated When comparing the inventory update means with the sales unit price on the single item master file of the returned goods whose inventory quantity is updated by this update means, the entered unit price at the time of receipt When the unit price comparison unit and the unit price comparison unit confirm that the unit prices do not match, the sales unit price is the unit price before the change, the unit price at the time of receipt is the unit price after the change, and the number of returned products is the unit price change product quantity. The sales variation slip data editing means for editing is provided, and it is possible to output the sales variation slip data based on the sales variation slip data edited by the sales return variation slip data editing means. The single item management device according to claim 1, wherein: 3. Disposal information input means for inputting the individual product code and the number of discarded products of the discarded product, and when the information of the discarded product is inputted by this input means, the stock quantity corresponding to the input single product code of the individual product master file is discarded. Number-of-wastes inventory renewal means for decrementing and updating by the number, and the selling unit price on the above-mentioned single-item master file of the abandoned product whose inventory number is updated by this renewing means It is possible to output a sales conversion voucher based on the sales conversion voucher data edited by the disposal sales conversion voucher data editing means for editing the sales conversion voucher data as a quantity of The single item management device according to claim 1, wherein 4. An inventory information input means for inputting a single item code and the number of inventories of an inventory item, and the inventory number corresponding to the input single item code of the individual item master file when inventory item information is input by this input means. The inventory inventory updating means for changing to the number, the quantity comparing means for comparing the inventory quantity before update of the inventory goods whose inventory quantity is updated by this updating means and the entered inventory quantity, and the inventory quantity by this comparing means If there is more than the number of inventories, the unit sales price on the single item master file of the inventoried product is the unit price before change, zero is the unit price after change, and the difference between the inventory number and the inventory count is the quantity of the unit price change product. When the inventory count variable slip data editing means for editing the data and the comparing means indicate that the inventory quantity is less than the inventory quantity, zero is set as the unit price before change on the single item master file of the inventory goods. And a second inventory-selling variable slip data editing means for editing the sales variable slip data as the unit price after the change and the difference between the number of stocks and the inventory quantity as the quantity of the unit price changed product. 2. The single-item management device according to claim 1, wherein it is possible to output the sales conversion slip based on the sales conversion slip data edited by the second inventory sales conversion slip data editing means. 5. The single-item master file stores and manages single-item sales information such as sales points, sales amount, discount points, and discount amounts together with the single-item information, and sales are registered at each product sales data registration terminal. Sales settlement means for collecting single-item sales information of each product through a communication line and updating the single-item sales information of the single-item master file, and the sales unit price and discount amount stored in the single-item master file after updating the data by the settlement means. At the time of settlement to compare the average sales unit price for each product, which calculates the average sales unit price for each product from each item of discount points and the information, and the average sales unit price for each product calculated by this calculation unit, and the sales unit price of the corresponding product. Unit price comparison means,
If this comparison means that the unit prices do not match, the selling unit price is the unit price before change, the average selling unit price is the unit price after change, and the discount points are the unit price change. 2. The single-item management device according to claim 1, further comprising data editing means, which enables output of the sales variation slip based on the sales variation slip data edited by the settlement sales variation slip data editing means.