JP3869835B2 - Product price management method and apparatus, and product price management program - Google Patents

Description

  The present invention relates to a product price management method and apparatus for managing a product price file storing the price of each product, and a product price management program for causing a computer having the product management file to realize desired price management.

  In recent years, POS (Point Of Sales) systems have been introduced in retail stores such as supermarkets and convenience stores. The POS system is composed of a plurality of POS terminals that process sales data of products purchased by customers and a store computer that functions as a host device, and each POS terminal and the store computer are connected by wire or wirelessly. . The store computer collects product sales data processed at each POS terminal, and performs sales analysis by, for example, totaling by product or time zone.

  Further, the store computer manages a product master file that stores product data such as the product name and price of the product corresponding to the product code for identifying each product. When a product code is input at the POS terminal, product data such as product name and price corresponding to the product code is extracted from the product master file and responds to the POS terminal. The POS terminal processes the sales data of the product at the price in the response product data. Therefore, when the price of a product is changed, it can be dealt with by changing the price data stored in the product master file to the changed price.

  Conventionally, when a price change of an arbitrarily designated product is instructed, a price change rate is calculated from the pre-change price and post-change price of this product, and this price change rate is a preset price change tolerance There is already known a technique for determining whether or not the product is within the allowable range, changing the price of the product to the post-change price, and making the price change an error if it is not within the allowable range (for example, patents). Reference 1).

Now, in Japan, a consumption tax is introduced as a tax imposed on personal consumption. In retail stores, an external tax method is generally used in which a consumption tax is calculated from the total transaction amount at each transaction with a customer. For this reason, in the conventional POS system, the main unit price excluding tax is registered in the product master file for most products excluding domestic tax products such as cigarettes whose consumption tax is included in the price. The total price of products purchased by customers excluding tax-excluded products and tax-exempt products (prepaid cards, gift certificates, etc.), and the consumption tax amount is calculated for the total amount. It has been displayed as the customer's payment amount (see, for example, Patent Document 2).
Japanese Patent No. 3382493 Japanese Patent Laid-Open No. 6-301861

  Now, as a result of the tax system revision in Japan, the total amount display method that requires the display of the total payment amount including the amount equivalent to the consumption tax when prices are displayed on price tags and advertisements to consumers has been started. For this reason, when a customer registers a product to be purchased in the POS terminal, it is desired that the total payment amount including tax is displayed on the display instead of the main unit price to match the price tag. Therefore, it is possible to support the total amount display method by changing the price data registered in the product price file (for example, product master file) that stores the price of each product from the tax-excluded main unit price to the total payment including tax. It was done.

  However, when registering the total amount including tax in the product price file, it was necessary to pay attention to the following points. In other words, when the consumption tax rate is 5%, if the tax amount less than 1 yen, which is the minimum unit of currency, is rounded down, for example, if 41 yen is included in the total payment including tax, the tax amount included in this 41 yen is calculated by the following [1] Calculated as 1 yen.

[1 set] Total payment including tax x (tax rate / (1 + tax rate)) = tax amount
41 yen x (0.05 / 1.05) = 1.95 ...
= 1 yen (rounded down to the nearest 1 yen)
For this reason, the main body price of a product with a total payment including tax of 41 yen is 40 yen.

  However, the consumption tax amount calculated from the main unit price of 40 yen is calculated as 2 yen according to the following [Formula 2].

[Type 2] Base price x (1 + tax rate) = tax-included price (40 yen x 1.05)-40 yen = 2 yen Even if the total amount display system is introduced, the store will not accept tax-excluded products. The tax amount calculated from the main unit price will be paid. For this reason, when a sales transaction for a product with a total payment of 41 yen including tax is made, the store side must pay a consumption tax of 2 yen, so the store side has actually lost 1 yen.

  In addition, when rounding up the tax amount of less than 1 yen, for example, if 43 yen is included in the total payment amount including tax, the tax amount included in this 43 yen is calculated as 3 yen when applied to the above [1 formula]. Will be 40 yen.

  However, since the consumption tax amount calculated from the main unit price of 40 yen is calculated as 2 yen according to the above-mentioned [Formula 2], if a sales transaction for a product with a total payment including tax of 43 yen is established, the store side will consider the consumption tax 2 It is only necessary to pay a yen. In effect, the customer lost 1 yen.

  As described above, depending on the price of the total payment including tax, the store side may lose or the customer side may lose. For this reason, there has been a demand for prohibiting setting a price at which damage occurs on the store side or the customer side as a total payment amount including tax. However, in the conventional product price file management technology, it is actually impossible to prevent a specific price from being registered.

  The present invention has been made based on such circumstances, and the purpose of the present invention is to register in the commodity price file the total price including tax, which is inconvenient for damage to the store or customer. It is an object of the present invention to provide a commodity price management method, apparatus, and program that can prevent the occurrence of the problem.

  When price data corresponding to the total amount of tax-included payment registered in the product price file is input, the present invention determines whether or not the price of the input price data matches a preset registration prohibited price. If not, the input price data is registered in the product price file as a total payment including tax, and if they match, an error is reported.

  In addition, when the price data corresponding to the total amount of tax-included payment registered in the product price file is input, the present invention calculates the product main body price obtained by subtracting the tax amount from the price of the input price data. Calculate the tax-included price, compare the tax-included price with the price of the input price data, and if the two match, register the input price data as the total payment including tax in the product price file. It is to inform.

  According to the present invention in which such a measure is taken, it is possible to prevent a price that causes inconvenience that causes damage on the store side or on the customer side from being registered in the product price file as a total payment including tax.

The best mode for carrying out the present invention will be described below with reference to the drawings.
First, a first embodiment will be described with reference to FIGS.

  FIG. 1 is a schematic diagram of a POS system installed in a retail store such as a supermarket or a convenience store. This POS system includes a plurality of POS terminals 1 that process sales data of products purchased by customers, and a store computer 2 that functions as a host device. Each POS terminal 1 and store computer 2 are wired or wireless. LAN (Local Area Network) 3.

  An input device 4 and a display device 5 functioning as a man-machine interface are connected to the store computer 2. In this man-machine interface, the input device 4 and the display device 5 may be directly connected to the store computer 2 independently, and software for controlling the input device 4 and the display device 5 may be installed in the store computer 2. The software of a personal computer connected via the computer and input / output devices such as a keyboard, a mouse, and a display may be applied. Alternatively, any one of the POS terminals 1 may be set as a master machine, software as a man-machine interface may be installed in the master machine, and a keyboard and a display may be used as the input device 4 and the display device 5.

  In addition, as shown in FIG. 3, the store computer 2 is provided with a product master file 6 for storing product data such as the product name and price of the product corresponding to the product code for identifying each product. A price management program 7 is installed as software for managing the product master file 6. In the product master file 6, the total amount of tax-included payment obtained by adding the consumption tax amount to the main unit price for products other than tax-free products is registered as price data.

  Here, the merchandise master file 6 functions as a merchandise price file that stores the total amount including tax as the price of each merchandise. Further, the store computer 2 functions as a product price management device that manages a product price file.

  FIG. 2 is a block diagram showing a main configuration of the store computer 2. The store computer 2 includes a central processing unit (CPU) 21 that performs various arithmetic controls, a read only memory (ROM) 22 that stores the price management program, and various memory areas that store variable data. Random Access Memory (RAM) 23, a clock unit 24 that measures the current date and time, a communication interface 25 connected to the LAN 3, an HDD (Hard Disk Drive) device 26 that stores and holds the product master file 6 and the like, the input An input device interface 27 to which the device 4 is connected, a display device interface 28 to which the display device 5 is connected, and the like. The CPU 21, ROM 22, RAM 23, clock unit 24, communication interface 25, HDD device 26, input device interface 27, and display device interface 28 are connected by a bus line 29 such as an address bus or a data bus.

  Now, in the present embodiment, as shown in FIG. 4 in particular, a registration prohibition price table 8 capable of storing a plurality of price data is formed in the RAM 23 of the store computer 2. The registration prohibition price table 8 is preset with price data that is prohibited from being registered in the product master file 6 because damage occurs on the store side or on the customer side, and functions as a registration prohibition price storage means. To do.

  For the tax amount calculated by rounding the minimum unit of currency from the tax-included price and its tax rate, the tax-included price that increases the tax amount for the main unit price excluding the tax amount from the tax-included price is Damage is caused only by the tax difference. In addition, with respect to the tax amount calculated by rounding off the minimum unit of currency from the tax-included price and its tax rate, the tax-included price that reduces the tax amount for the main unit price excluding the tax amount from the tax-included price is Damage will occur on the side of the tax difference.

  FIG. 4 shows a registration-prohibited price table 8 for a store where the consumption tax rate is 5% and the tax amount is calculated by rounding off fractions less than the minimum currency unit. For example, if the price data of 20 yen is assumed to be the total payment including tax, the tax amount is 0 yen according to [Formula 1], so the main body price calculated by subtracting the tax amount from the total payment including tax is 20 yen. The tax-included price for the main unit price of 20 yen is 21 yen according to the above [2 formula], so the store side loses 1 yen. Similarly, for the price data 41 yen, 62 yen, etc., the store side loses 1 yen. Therefore, price data such as 20 yen, 41 yen, and 62 yen is set in the registration prohibition price table 8 as registration prohibition price data.

  In the case of calculating the tax amount by rounding off the fraction less than the minimum unit of currency, if the total payment including tax is set to 10 yen, 31 yen, 52 yen, etc., the store side loses 1 yen. Therefore, in this case, 10 yen, 31 yen, 52 yen, etc. may be set in the registration prohibition price table 8 as registration prohibition price data.

  In addition, when calculating the tax amount by rounding up the fraction less than the minimum unit of currency, if the total amount of payment including tax is set to 1 yen, 22 yen, 43 yen, etc., the customer loses 1 yen. Therefore, in this case, 1 yen, 22 yen, 43 yen, etc. may be set in the registration prohibition price table 8 as registration prohibition price data.

  In the case of an apparatus that can arbitrarily select fraction processing less than the minimum unit of currency, all the registration prohibition price data for each fraction processing is set in the registration prohibition price table 8 and any fraction processing is selected. What is necessary is just to program so that the registration prohibition price data with respect to the fraction processing may be validated. Or you may provide the registration prohibition price table 8 for every fraction process.

  Thus, when the price management program 7 is started by an operation input of the input device 4, the CPU 21 of the store computer 2 executes the price registration management process of the procedure shown in the flowchart of FIG.

  That is, the CPU 21 waits for a product code to be input as ST (step) 1. When a product code is input by an operation input of the input device 4, the product master file 6 is searched as ST2, and it is determined whether or not the input product code exists in the product master file 6.

  If there is no corresponding product code as ST3, the CPU 21 displays a product input error on the display device 5 as ST4. Thereafter, the process waits for an error clear input as ST5, and when the clear input is performed by the operation input of the input device 4, the CPU 21 erases the display of the commodity input error as ST6. Then, the process returns to ST1 and waits for the next product code to be input.

  When the corresponding product code exists in the product master file 6 in ST3, the CPU 21 calls the product name data set corresponding to the product code from the product master file 6 in ST7, and displays the product on the display device 5. Display the name.

  Next, the CPU 21 waits for price data to be input in ST8 (registered price input receiving means). When the price data is input by the operation input of the input device 4, it is determined whether or not the input price data matches any of the registration prohibition price data set in the registration prohibition price table 8 as ST9. (Price data verification means). As a result, if they match, the input price data is data that is prohibited from being registered in the product master file 6 as the total amount including tax, so the CPU 21 causes the display device 5 to display a price input error as ST10 (error notification). means). Thereafter, the CPU 21 waits for an error clear input as ST11, and when the clear input is performed by the operation input of the input device 4, the CPU 21 erases the display of the price input error as ST12. Then, the process returns to ST8 and waits for the next price data to be input.

  If the input price data is not set in the registration prohibition price table 8 in ST9, the CPU 21 stores the input price data in the product master file 6 as the total tax-included payment amount of the product in which the product code is set in ST13. Register (price data registration means). Thereafter, it is determined in ST14 whether or not a process end command has been input. If not, the process returns to ST1 and waits for the next product code to be input. If a process end command has been input, the price setting process ends.

  As described above, in the present embodiment, for example, when it becomes necessary to register the total amount of tax-included payment for a product whose price has been changed or a product added as a new product in the product master file 6, the operator uses the input device 4. By operating, the price management program 7 installed in the store computer 2 is started. Next, the input device 4 is operated to input the product code and price data of the product for which the total amount including tax is registered. At this time, if the input price data is a value that is not set in the registration prohibition price table 8, the input price data is registered in the product master file 6 as the total tax-included payment amount of the product. On the other hand, if the input price data is a value set in the registration prohibition price table 8, a price input error is displayed on the display device 5 and notified to the operator. Therefore, the registration prohibition price data set in advance in the registration prohibition price table 8 is not registered in the product master file 6 as the total amount including tax.

  In a store that calculates the tax amount by rounding off fractions less than the minimum unit of currency, the tax amount is excluded from the tax-included price for the tax amount calculated by rounding the minimum unit of currency from the tax-included price and its tax rate. The tax-included price that increases the tax amount for the main unit price is set in the registration prohibition price table 8 in advance as registration prohibition price data. 6 can be prevented in advance.

  Similarly, stores that calculate the amount of tax by rounding off fractions less than the minimum unit of currency also calculate the tax amount from the tax-included price to the tax amount calculated by rounding the minimum unit of currency from the tax-included price and the tax rate. The tax-included price that increases the tax amount for the main unit price excluding the price is set in the registration prohibition price table 8 in advance as registration prohibition price data. Problems that are registered in the product master file 6 can be prevented in advance.

  Also, a store that calculates the tax amount by rounding up the fraction less than the minimum unit of currency calculates the tax amount from the tax-included price with respect to the tax amount calculated by rounding the minimum unit of currency from the tax-included price and its tax rate. By including the tax-inclusive price that reduces the amount of tax imposed on the excluded main unit price in the registration-prohibited price table 8 as registration-prohibited price data in advance, the total amount including tax that causes 1 yen of damage on the customer side is the product. Problems that are registered in the master file 6 can be prevented in advance.

  Next, a second embodiment of the present invention will be described with reference to FIG. In the second embodiment, only part of the processing of the price management program 7 installed in the store computer 2 is changed, and FIGS. 1 to 3 are used in common.

  In the second embodiment, when the price management program 7 is activated by an operation input of the input device 4, the CPU 21 of the store computer 2 executes the price registration management process of the procedure shown in the flowchart of FIG.

  This price registration management process is the same as that in the first embodiment from ST1 to ST8. In this embodiment, when the price data is input by the operation input of the input device 4 at ST8 (registered price input receiving means), the CPU 21 sets the input price A and the preset tax rate C as ST21. Therefore, the tax amount B included in the input price A is calculated by the following [Formula 3]. At this time, the fraction of the tax amount less than the minimum currency unit is rounded by any of the round-down process, round-off process, and round-up process.

[Formula 3] B ← A × (C / (1 + C))
Next, as ST22, the CPU 21 calculates the main body price D from the input price A and the tax amount B by the following [Formula 4] (main body price calculating means).

[Formula 4] D ← AB
Next, in step ST23, the CPU 21 calculates a tax-included price E from the main body price D and the tax rate C by the following [Formula 5]. At this time, the fraction less than the minimum currency unit of the tax amount is rounded by the same fraction processing as the processing of ST21 (tax included price calculation means).

[Formula 5] E ← D × (1 + C)
Next, CPU21 compares whether the tax-included price E corresponds with the input price A as ST24 (price comparison means). Here, when the tax-included price E does not match the input price A, the input price A is a price that causes damage to the store side or the customer side when it is registered in the product master file 6 as a total amount including tax. Since the price is forbidden, the CPU 21 causes the display device 5 to display a price input error as ST10 (error notification means) as in the first embodiment. Thereafter, the CPU 21 waits for an error clear input as ST11, and when the clear input is performed by the operation input of the input device 4, the CPU 21 erases the display of the price input error as ST12. Then, the process returns to ST8 and waits for the next price data to be input.

  On the other hand, if the tax-included price E matches the input price A in ST24, the input price A is a price that does not cause damage on the store side or the customer side even if it is registered in the product master file 6 as the total amount including tax. Therefore, the CPU 21 registers the input price data in the product master file 6 as a tax-included payment total amount of the product for which the product code is set (price data registration means) as ST13. Thereafter, it is determined in ST14 whether or not a process end command has been input. If not, the process returns to ST1 and waits for the next product code to be input. If a process end command has been input, the price setting process ends.

  Also in the present embodiment configured as described above, the price at which damage occurs on the store side or the customer side is registered in the commodity master file 6 as the total amount including tax, as in the first embodiment. There is an effect that can be prevented. Moreover, according to this 2nd Embodiment, there also exists an effect which can make the registration prohibition price table 8 unnecessary.

  In each of the above embodiments, the present invention is applied to the store computer 2 that manages the product master file 6 as a product price management device that manages the product price file. In a POS system in which a copy file is downloaded to each POS terminal 1 and the price can be changed for each POS terminal 1, the present invention may be applied to each POS terminal 1.

1 is a schematic diagram of a POS system according to an embodiment of the present invention. The block diagram which shows the principal part structure of the store computer in the POS system. The schematic diagram which shows the data structure of the goods master file which the store computer memorize | stores. The schematic diagram which shows an example of the registration prohibition price table formed in RAM of the store computer. The flowchart which shows the process sequence in 1st Embodiment of the price setting program mounted in the store computer. The flowchart which shows the process sequence in 2nd Embodiment of the price setting program mounted in the store computer.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... POS terminal, 2 ... Store computer, 4 ... Input device, 5 ... Display apparatus, 6 ... Product master file, 7 ... Price management program, 8 ... Registration prohibition price table.

Claims (7)

In the product price management method that manages the product price file that stores the total amount including tax as the price of each product,
When price data corresponding to the total amount of tax-included payment registered in the product price file is input, it is determined whether or not the price of the input price data matches a preset registration prohibition price. Registers the input price data as a total payment amount including tax in the product price file, and if they match, an error is notified. In the product price management method that manages the product price file that stores the total amount including tax as the price of each product,
When the price data corresponding to the total tax-included payment registered in the product price file is input, the product body price obtained by subtracting the tax amount from the price of the input price data is calculated, and the tax-included price is calculated from the product body price. The tax-included price is compared with the price of the input price data, and if the two match, the input price data is registered in the product price file as a tax-included total payment amount, and if the two do not match, an error is notified. Product price management method characterized by In the product price management device that manages the product price file that stores the total payment amount including tax as the price of each product,
Registered price input receiving means for receiving input of price data corresponding to the total amount of tax-included payment registered in the product price file;
Registration prohibition price storage means for storing price data prohibiting registration in the product price file;
Price data collating means for determining whether or not the input price data received by the registered price input receiving means matches the registration prohibited price data stored in the registration prohibited price storage means;
Price data registration means for registering the input price data in the commodity price file as a tax-inclusive payment amount when it is determined by the price data collating means that the input price data does not match the registration-prohibited price data;
Error notification means for notifying an error when it is determined by the price data matching means that the input price data matches the registration prohibition price data;
A product price management apparatus comprising:   The registration-prohibited price storage means increases the amount of tax imposed on the body price excluding the tax amount from the tax-included price, with respect to the tax amount calculated by rounding the minimum unit of currency from the tax-included price and the tax rate. Tax-included price, and tax amount calculated by rounding off the minimum unit of currency from the tax-included price and tax rate, at least the tax-included price that reduces the tax amount imposed on the body price excluding the tax amount from the tax-included price 4. The commodity price management apparatus according to claim 3, wherein one of the two is stored as registration prohibition price data. In the product price management device that manages the product price file that stores the total payment amount including tax as the price of each product,
Registered price input receiving means for receiving input of price data corresponding to the total amount of tax-included payment registered in the product price file;
A body price calculating means for calculating a product body price obtained by subtracting a tax amount from the price of the input price data received by the registered price input receiving means;
Tax-included price calculation means for calculating the tax-included price from the product body price calculated by the body price calculation means,
Price comparison means for comparing whether the tax-included price calculated by the tax-included price calculation means matches the price of the input price data,
Price data registration means for registering the input price data as a total amount including tax when the tax-included price matches the price of the input price data by the price comparison means;
An error notification means for notifying an error when the price comparison means does not match the tax-inclusive price with the price of the input price data;
A product price management apparatus comprising: On the computer that manages the product price file that stores the total payment amount including tax as the price of each product,
A function of accepting input of price data corresponding to the total payment amount including tax registered in the product price file;
A function for determining whether or not the input price data that received the input matches preset registration prohibition price data;
A function of registering the input price data in the product price file as a total amount including tax when the input price data does not match the registration prohibition price data;
A commodity price management program that realizes a function of notifying an error when the input price data matches the registration prohibition price data. On the computer that manages the product price file that stores the total payment amount including tax as the price of each product,
A function of accepting input of price data corresponding to the total payment amount including tax registered in the product price file;
A function to calculate the price of the product itself by subtracting the tax amount from the input price corresponding to the price data accepted,
A function to calculate the price including tax from the calculated product body price,
A function for comparing whether or not the calculated tax-included price matches the price of the input price data;
When the tax-included price matches the price of the input price data, the function to register the input price data in the product price file as a total payment including tax;
A function of notifying an error when the tax-included price does not match the price of the input price data;
Product price management program characterized by realizing

Images