JP6736535B2 - Product sales data processing device and program - Google Patents

Description

The embodiment of the present invention relates to a product sales data processing device and a program.

There is a so-called tax exemption system that exempts consumption tax on goods when a business operator of an export goods sales area (duty-free shop) sells goods to non-residents such as foreign tourists. In addition, from October 1, 2017, a system will be implemented to exempt liquor tax in addition to consumption tax for liquor sold to foreign tourists visiting Japan.

The new liquor tax exemption system applies to retailers of alcoholic beverages such as sake breweries within the manufacturing plant. In addition, even for alcoholic beverages sold at stores in the factory, the liquor tax exemption applies only to own products. Further, there are plural kinds of liquor such as sparkling liquor, brewed liquor, distilled liquor, and mixed liquor, and different tax rates (liquor tax amounts) are determined for each.

Therefore, at stores that are exempt from liquor tax, appropriate sales data should be provided according to the liquors of different manufacturing sites and the liquors of different liquor tax included in the products that foreign tourists visiting Japan purchase. It needs to be processed.

JP, 2016-057781, A

The problem to be solved by the present invention is to provide a product sales data processing device and program capable of executing sales data processing related to tax exemption when a plurality of types of products having different tax rates are mixed.

Further, according to the embodiment, the product sales data processing device has a storage unit, an input unit, a first calculation unit, a data input unit, a second calculation unit, a third calculation unit, and an output unit. The storage means stores, for each product code of liquor, liquor tax data indicating the type of liquor tax in association with the product code and product master data in which a capacity is set. The input means inputs the product code of the alcoholic beverage to be purchased. The first calculating means sums up the capacities of the liquor corresponding to the plurality of product codes for each liquor tax data based on the liquor tax data of the liquor corresponding to the product code input by the inputting device and the capacity. Then, the amount of liquor tax for each liquor tax data is calculated. The second calculating means calculates the total amount of liquor tax by adding up the amount of liquor tax for each liquor tax data. The data input means, when the liquor tax data corresponding to the product code input by the input means is not set in the product master data, sets the liquor tax data and the capacity corresponding to the product code according to a user operation. input. The second calculating means adds up the capacities of the liquor corresponding to the plurality of product codes for each liquor tax data based on the data input by the data inputting means, and calculates the liquor tax amount for each liquor tax data. The third calculating means adds up the liquor tax amounts for each liquor tax data calculated by the first calculating means and the second calculating means to calculate a total liquor tax amount. The output means outputs the total amount of liquor tax.

The block diagram which shows the system configuration of the checkout system which provided the goods sales data processing apparatus in this embodiment. The figure which shows an example of the goods master data memorize|stored in the server and POS terminal in this embodiment. The figure which shows an example of the liquor tax data memorize|stored in the server in this embodiment. The flowchart which shows an example of operation|movement of the POS terminal in this embodiment. The flowchart which shows an example of the liquor tax calculation processing in this embodiment. The flowchart which shows an example of the liquor tax confirmation processing in this embodiment. The figure which shows an example of the screen for confirmation of the tax exemption amount in this embodiment. The figure which shows an example of the screen for calculating the liquor tax exemption amount in this embodiment. The figure which shows an example of the screen for confirming the liquor tax exemption amount in this embodiment. The figure which shows an example of the transaction receipt and the purchase details when tax exemption processing is performed in this embodiment. The figure which shows an example of the export tax exemption goods purchase record slip printed when the tax exemption process in this embodiment is carried out. The figure which shows an example of the export duty-free article purchase oath printed when the tax exemption process in this embodiment is carried out.

Hereinafter, the present embodiment will be described with reference to the drawings.
FIG. 1 is a block diagram showing a system configuration of a checkout system provided with a product sales data processing device according to this embodiment.

In FIG. 1, in the checkout system, a plurality of POS terminals 10 (10-1, 10-2,..., 10-n) and a server 12 (server 12) are connected via a network such as a LAN (Local Area Network) 14. Are connected so that they can communicate with each other. The product sales data processing device of this embodiment will be described as being realized by a POS (Point Of Sales) terminal 10 used in a store that sells alcoholic beverages. The POS terminal 10 is provided with a function capable of executing product data processing corresponding to liquor tax exemption. The tax exemption on the sale of goods is not limited to the liquor tax, but other taxes such as the consumption tax. However, in the following embodiments, the tax exemption will be mainly described.

The product sales data processing device may be composed of one POS terminal 10 and server 12, or may be composed of a plurality of POS terminals 10 and server 12.

The POS terminal 10 has a computer function implemented therein, and includes a processor (CPU (central processing unit) or the like) 11a, a ROM (read-only memory) 11b, a RAM (random-access memory) 11c, a storage unit 11d, and a change dispenser. 11e, communication unit 11f, scanner 11g, touch panel 11h, keyboard 11j, printer 11k, card reader/writer 11m, display 11n, and passport reader 11p.

The processor 11a is a circuit for controlling each unit to realize various operations as the POS terminal 10 based on the operating system, middleware, and application programs stored in the ROM 11b and the RAM 11c.

The ROM 11b and the RAM 11c record various programs executed by the processor 11a, as well as data referred to when the processor 11a performs various processes. For example, the RAM 11c stores a registered product table or the like in which the information of the product to be purchased by the customer is registered when the process of registering the product information is executed. Further, the RAM 11c stores data of screens displayed on the touch panel 11h and the display 11n.

The program executed by the processor 11a generates transaction information used for a scan process of inputting product information (product code etc.) through the scanner 11g and a payment process according to the product information registered in the registered product table. It includes a control program for executing product registration processing and settlement processing based on transaction information. Further, a program for executing tax exemption processing for tax exemption on the product registered by the product registration process is included. The tax exemption processing includes not only the consumption tax but also a liquor tax exemption processing corresponding to a system (hereinafter, referred to as a new liquor tax exemption system) which is applied to a liquor tax applied to a shop in a liquor factory. By executing the control program, the processor 11a causes the touch panel 11h to display a screen for processing related to product sales (including registration processing and payment processing).

The storage unit 11d stores data used by the processor 11a for performing various kinds of processing or data generated by the processing of the processor 11a. The storage unit 11d stores product master data 21 (described later) used in product registration processing and the like, liquor tax data 22 (described later) referred to in liquor tax processing, which is received from the server 12. As the storage unit 11d, for example, an HDD (hard disk drive), SSD (solid state drive), or the like can be used.

The change machine 11e receives coins and banknotes that are input, and discharges coins and banknotes that are used as change.
The communication unit 11f controls communication with the server 12 and another POS terminal 10 via the LAN 14.

The scanner 11g reads product information by, for example, optical scanning and inputs a product code unique to the product. The scanner 11g may be a fixed type or a handy type two-dimensional code scanner, or may be a type that identifies an item for sale by using an image recognition technique from an image obtained by photographing the item for sale. Further, the scanner 11g may be provided with only one type, or may be provided with a plurality of types.

The touch panel 11h is a device that is input by an employee (casher), and includes a display device and a touch sensor. The display device displays an arbitrary screen such as a GUI (Graphical User Interface) screen. For example, the display device has a registration screen (product list screen) including a list of transaction information (product name, price, etc.) related to products registered as purchase targets, a product list screen, and a plurality of screens corresponding to various functions. An operation screen including a menu including keys and keys for inputting commands instructing execution of various functions is displayed. A known device such as a color LCD (Liquid Crystal Display) can be used as the display device. The touch sensor is arranged so as to overlap the display surface of the display device. The touch sensor detects the touch position of the operator on the display surface of the display device and sends the position information to the processor 11a. A known device can be used as the touch sensor.

The keyboard 11j is a device that an input operation is performed by an employee (casher), and for example, a plurality of keys to which specific functions are individually assigned are arranged.

The printer 11k is, for example, a thermal printer or a dot impact printer, and prints various character strings, images, code patterns (bar codes, two-dimensional codes, etc.) on receipt paper to obtain product names, unit prices, Issue transaction receipts printed with transaction details such as total amount and information related to tax exemption including liquor tax.

The card reader/writer 11m reads the data recorded on the card and writes the data to the card. The card includes various types of cards such as credit cards, debit cards, electronic money cards, prepaid cards, and other payment cards as well as members cards, point cards, and the like for recording information related to payment processing. The card reader/writer 11m may be a magnetic type, a contact type, or a non-contact type device, or may include a plurality of types of devices.

The display 11n is a device used as a customer screen for providing information to the customer, and a known device such as a color LCD can be used.

The passport reader 11p is a reading device for reading the information recorded in the passport in order to confirm that the person is a tax exemption target when performing tax exemption processing for foreign tourists visiting Japan. The passport reader 11p executes optical character information reading or information reading from a storage medium (IC) of an electronic passport.

The server 12 includes a processor (CPU or the like) 21a, a ROM 21b, a RAM 21c, a storage unit 21d, a communication unit 21f, a keyboard 21g, a display 21h, and a communication unit 21p. The server 12 is an information processing device having a computer function.

The processor 21a is a circuit for controlling each unit to realize various operations as the server 12 based on the operating system, middleware, and application programs stored in the ROM 21b and the RAM 21c.

The ROM 21b and the RAM 21c store programs such as an operating system, middleware, and application programs executed by the processor 21a, as well as data referred to when the processor 21a performs various processes.

The programs executed by the processor 21a include programs for controlling the processes executed in the plurality of POS terminals 10.

The storage unit 21d stores data used by the processor 21a for performing various kinds of processing or data generated by the processing by the processor 21a. As the storage unit 21d, for example, an HDD or SSD can be used. In the storage unit 21d, product master data 21, liquor tax data 22, and sales management data (including sales data (including product name, price, sales time, number of sales, etc.) used in processing for selling products in the POS terminal 10). , Inventory data, etc.) and the like are stored.

The communication unit 21f controls communication with the POS terminal 10 and the like via the LAN 14.
The keyboard 21g inputs data for the server 12 according to an operation by an employee. The server 12 may be provided with an input device (touch panel, mouse, etc.) other than the keyboard 21g.
The display 21h displays a screen corresponding to the POS function executed by the processor 21a.
The communication unit 21p controls communication with an external device such as a server (website) via an external network such as the Internet.

FIG. 2 is a diagram showing an example of the product master data 21 stored in the server 12 and the POS terminal 10 in this embodiment.
As shown in FIG. 2, in the product master data 21, product classification, product name, price, tax exemption rate, etc. are registered in association with a product code unique to the product. The product classification is information for classifying products, and is classified into, for example, a large classification, a middle classification, and a small classification. The product classification includes data indicating the classification of alcoholic beverages. The price may be a price excluding consumption tax, a price including consumption tax, or a price excluding liquor tax. The tax exemption rate indicates whether the goods (products) subject to tax exemption are general goods or consumable goods. Consumables include alcoholic beverages. Further, in the product master data 21, for the sake included in general goods, each data of a tax exemption exemption flag (exempt data), a liquor tax code, and a capacity is registered for liquor tax exemption processing corresponding to the new liquor tax exemption system. To be done.

The tax exemption exemption flag is data indicating that the liquor tax exemption target is not subject to the liquor tax exemption (for example, setting of the tax exemption exemption flag “1” indicates that the liquor tax exemption is not applicable). .. In other words, the new liquor tax exemption system is a system that is applied to retailers of alcoholic beverages such as sake breweries within a manufacturing plant, and the liquor tax exemption is applied only to own products. For this reason, it is necessary to exclude the liquor of the same kind sold at a shop in the brewery from the liquor tax exemption for the liquor manufactured in other breweries. For this reason, the liquor tax exemption flag (1) is set to the liquor exempted from liquor tax exemption (liquor tax calculation). The liquor tax code is set so that the liquor tax data 22 can refer to a tax rate or the like according to the liquor of the product. The capacity is referred to in order to calculate a liquor tax amount for each liquor of the same type.

In the POS terminal 10 of the present embodiment, the first processing method and the second processing method are used for the liquor tax exemption processing corresponding to the new liquor tax exemption system. The first processing method is a method of preliminarily registering each data of a tax exemption exemption flag, a liquor tax code, and a capacity in the product master data 21 for a liquor (product) to be exempted from liquor tax. The second processing method is that the data necessary for the liquor tax exemption processing corresponding to the new liquor tax exemption system is operated by the employee without registering each data of the tax exemption exemption flag, the liquor tax code, and the capacity in advance in the product master data 21. It is a method of inputting. Alcoholic beverages for which the tax exemption exemption flag, liquor tax code, and capacity data are not registered in advance in the product master data 21 will be described as unregistered liquor.

According to the first processing method, when selling alcoholic beverages to foreign tourists visiting Japan, accounting treatment corresponding to liquor tax exemption corresponding to the new liquor tax exemption system without increasing the work burden on employees who operate the POS terminal 10 is performed. Can be performed. In the second processing method, there is a case in which the product master data 21 cannot be maintained due to a large variation in the liquor to be handled or a large variety of liquor in the liquor store such as a brewery. However, when selling alcohol to foreign tourists visiting Japan, individual treatment will enable accounting treatment corresponding to the new liquor tax exemption system.

FIG. 3 is a diagram showing an example of the liquor tax data 22 stored in the server 12 in the present embodiment.
The liquor tax data 22 indicates liquor information used for liquor tax exemption processing, and is used when displaying on the screen data indicating the liquor tax amount (tax rate) in association with a liquor tax code unique to each type of liquor. The name (screen) and the data of the name (print) used when printing on the receipt are associated with each other. As the liquor tax amount (tax rate), for example, different tax rates (tax amount per 1 kl) are set for each of 12 kinds of liquor categories. For example, when the liquor category is "Happoshu (malt ratio 25 to less than 50%)", the tax rate is set to "178,125 yen" per 1 kl, and when "Sake" is selected, the tax rate is 1 kl. Therefore, "120,000 yen" is set.

As the liquor tax data 22, each data including the tax rate corresponding to alcoholic beverages is referred to based on the liquor tax code of the product code (product) set in the product master data 21.

Next, the operation of the POS terminal 10 in this embodiment will be described.
4, 5 and 6 are flowcharts showing an example of the operation of the POS terminal 10 in this embodiment.

First, the POS terminal 10 performs product registration for a product that the customer intends to purchase. When the barcode attached to the product is scanned by the scanner 11g (Act1), the processor 11a executes a product registration process based on the product code indicated by the barcode (Act2).

In the product registration process, the processor 11a searches the product master data 21 acquired in advance from the server 12 using the product code as a key, and extracts the product information (product name, product classification, tax exemption rate, price, etc.) for the product code. And record it in the registered product table.

If a plurality of the same products are to be purchased, numerical data indicating the number (quantity) is input by operating the numeric keys on the touch panel 11h or the keyboard 11j. When the numerical data is input after the product code is input, the processor 11a records the product information corresponding to the number (quantity) indicated by the numerical data in the registered product table.

The processor 11a displays purchase information (for example, product name, tax exemption rate, price, number (quantity), etc.) of the product information on the touch panel 11h for employees and the display 11n for customers, for example.

Further, the processor 11a determines whether the product corresponding to the product code is unregistered liquor. That is, the processor 11a determines that the product category corresponding to the product code is liquor and at least the liquor tax code is not registered among the tax exemption target flag, the liquor tax code, and the capacity, as unregistered liquor. If the tax exemption exemption flag is set to "1", the liquor is not subject to the liquor tax exemption according to the new liquor tax exemption system, and therefore it is not determined to be unregistered liquor.

When the product (liquor) whose product code is read is determined as unregistered liquor (Act 3, Yes), the processor 11a stores the corresponding product (liquor) in the RAM 11c as unregistered liquor, and the touch panel 11h. to display that it is a trade name and unregistered alcoholic beverages both of products for. In other words, by displaying to employees that they are unregistered alcoholic beverages, it is necessary to enter the data necessary for the alcoholic tax exemption processing for the alcoholic tax exemption processing (second processing method) under the new alcohol tax exemption system. Notify that there is. It should be noted that not only the unregistered alcoholic beverage may be notified by the display on the touch panel 11h, but also a predetermined sound may be notified.

Similarly, when there are other products to be purchased, the barcodes attached to the products are sequentially scanned and the product registration processing is executed. In addition, when there is a product that is determined to be unregistered liquor, the corresponding product name is displayed on the touch panel 11h. In addition, when there are a plurality of unregistered alcoholic beverages, the processor 11a may display a list of the plurality of unregistered alcoholic beverages on the touch panel 11h.

Here, when it is detected that the subtotal key has been operated (Act 6, Yes), the processor 11 a performs a tax-free payment process when the tax-exempt key has not been exempted by the tax-exempt key operation (Act 20, No). Execute (Act8). That is, the processor 11a generates transaction information for settlement of the product to be purchased registered in the registered product table, and processes the transaction information using cash or a payment card (credit card or the like). When the payment is completed, the processor 11a causes the printer 11k to print the transaction content on a receipt sheet and issues a transaction receipt and purchase details.

On the other hand, when tax exemption processing is required, the employee operates the tax exemption key. When the processor 11a detects that the tax exemption key has been operated (Act5, Yes), the amount displayed on the tax exemption amount confirmation screen based on the product information of the product to be purchased registered in the registered product table. The tax exemption confirmation calculation for displaying the information such as "execution" is executed (Act10). The processor 11a displays a tax exemption amount confirmation screen on the touch panel 11h based on the calculation result of the tax exemption confirmation calculation (Act 11).

FIG. 7 is a diagram showing an example of a tax exemption amount confirmation screen in the present embodiment. Hereinafter, the tax exemption amount confirmation screen will be described as a tax exemption confirmation pop-up D1.

In the tax exemption confirmation pop-up D1, for example, a general goods total amount display area 31, a general goods shortage amount display area 32, a consumables total amount display area 33, a consumables shortage amount display area 34, a liquor shortage amount display area 35, and a tax exemption amount. A display area 36 and a liquor tax exemption amount display area 37 are provided. In the general item total amount display area 31, the total amount of commodities targeted for general items is displayed. In the general item shortage amount display area 32, the amount of money until the tax exemption is established for the product targeted for the general item is displayed. In the consumables total amount display area 33, the total amount of commodities targeted for consumables is displayed. In the consumable item shortage amount display area 34, the amount of money until the tax exemption is established for the consumable item is displayed. In the liquor shortage amount display area 35, the price of liquor satisfying the shortage amount until the tax exemption of consumables is completed is displayed. In the tax exemption amount display area 36, the total tax exemption amount (general tax exemption amount) for each of general goods and consumables is displayed. The liquor tax tax exemption amount display area 37 displays the liquor tax tax exemption amount for the liquor included in the consumables according to the new liquor tax tax exemption system.

General goods and consumables are basically tax exempt when the total amount after tax exemption is equal to or more than the tax exemption standard amount (5000 yen). Therefore, when the total amount after tax exemption does not reach the tax exemption standard amount, the shortage amount is displayed in the general item shortage amount display area 32 and the consumables shortage amount display area 34, respectively, and the employee is deducted from the customer. Can be notified of the required amount up to the tax exemption standard amount. Thereby, the support employee can further encourage the customer to purchase the product. In addition, the customer can purchase the products up to the tax exemption standard amount according to the advice from the employee and can benefit from the tax exemption.

Further, the tax exemption confirmation pop-up D1 displays the amount of money required to make up for the tax exemption standard amount by purchasing alcohol in the alcohol shortage amount display area 35. For alcoholic beverages, a liquor tax is included in the price of the product. Therefore, even if the total amount of consumables reaches the tax exemption standard amount by additionally purchasing based on the price of liquor, the tax exemption tax exemption may not reach the tax exemption standard amount. For this reason, in the liquor shortage amount display area 35, by displaying the shortage amount until the tax exemption is established (the tax exemption standard amount) when purchasing alcoholic beverages, the employee can be sure to reach the customer by the tax exemption standard amount. You can notify the amount of alcohol required.

The amounts displayed in the general item shortage amount display area 32, the consumables shortage amount display area 34, and the alcoholic beverage shortage amount display area 35 do not have to be accurate amounts up to the tax exemption standard amount, and are, for example, less than 10 yen. Any amount that reaches the tax exemption standard amount may be used, such as rounding up the amount to display in units of 10 yen.

In the tax exemption amount display area 36, the tax exemption amount calculated when at least one of general goods and consumables has reached the tax exemption reference amount is displayed. The liquor tax exemption amount display area 37 displays the liquor tax exemption amount calculated by the liquor tax exemption processing when the application of the liquor tax exemption corresponding to the new liquor tax exemption system is instructed by the operation on the liquor tax exemption button 40 described later.

Further, the tax exemption confirmation pop-up D1 is provided with a compulsory tax exemption button 38 corresponding to general items, a compulsory tax exemption button 39 corresponding to consumables, and a liquor tax exemption button 40 corresponding to alcoholic beverages. The compulsory tax exemption button 38 is a button for instructing to perform tax exemption processing on general goods regardless of whether the total amount has reached the tax exemption standard amount. The compulsory tax exemption button 39 is a button for instructing to perform tax exemption processing on consumables regardless of whether or not the total amount has reached the tax exemption standard amount.

The compulsory tax exemption button 38 and the compulsory tax exemption button 39 are, for example, buttons for calculating a tax exemption amount for a product to be currently purchased. The liquor tax exemption button 40 is a button for instructing to apply liquor tax exemption corresponding to the new liquor tax exemption system and for instructing execution of liquor tax exemption processing. Detailed processing when the liquor tax exemption button 40 is operated will be described later.

Further, the tax exemption confirmation pop-up D1 is provided with a confirm button 41 and a cancel button 42. The confirm button 41 is a button for instructing to confirm the tax exemption with the tax exemption amount displayed in the tax exemption amount display area 36 and the liquor tax exemption amount display area 37. The stop button 42 is a button for instructing to stop applying the tax exemption.

When the total amount of products for general products displayed in the general product total amount display area 31 does not reach the tax exemption standard amount, the processor 11a detects an input operation to the compulsory tax exemption button 38 (Act 12, Yes), The tax exemption calculation process is executed for the current general goods to be purchased (Act 13). The processor 11a displays the tax exemption amount calculated by the tax exemption calculation process in the tax exemption amount display area 36. If the tax exemption amount display area 36 previously displays the tax exemption amount corresponding to the consumable item, the processor 11a displays the total amount added to the tax exemption amount corresponding to the consumable item.

Similarly, when the processor 11a detects an input operation to the compulsory tax exemption button 39 when the total amount of the consumables-targeted products displayed in the consumables total amount display area 33 has not reached the tax exemption reference amount (Act12). , Yes), and calculates the tax exemption amount for the current consumable item to be purchased and displays it in the tax exemption amount display area 36. Similarly, if the tax exemption amount display area 36 previously displays the tax exemption amount corresponding to the general item, the processor 11a displays the total amount added to the tax exemption amount corresponding to the general item.

Next, when the processor 11a detects an input operation on the liquor tax exemption button 40 (Act 14, Yes), the processor 11a determines whether or not unregistered liquor is stored in the RAM 11c. When unregistered liquor is stored in the product to be currently purchased (Act 15, Yes), the processor 11a performs a liquor tax calculation process (second processing method) for calculating the liquor tax exemption amount for the unregistered liquor. Execute (Act16).

FIG. 5 is a flowchart showing an example of the liquor tax calculation process in this embodiment.
When the liquor tax calculation process is started, the processor 11a causes the touch panel 11h to display a screen for calculating the liquor tax exemption amount (Act 31).

FIG. 8 is a diagram showing an example of a screen for calculating the liquor tax exemption amount in the present embodiment. Hereinafter, the screen for calculating the liquor tax exemption amount will be described as a liquor tax exemption popup D2 (liquor tax exemption popup 1). In the liquor tax exemption pop-up D2, the liquor tax exemption amount can be calculated according to the designation of the liquor category of unregistered liquor, the capacity of liquor, and the quantity of liquor input by the input operation of the employee. In the liquor tax calculation process, multiple liquors (commodities) to be purchased are added together in capacity for each liquor category (liquor tax code), the liquor tax amount for each liquor tax code is calculated, and the liquor tax amount for each liquor tax code is added Calculate the liquor tax amount (total liquor tax amount).

The liquor tax exemption pop-up D2 is provided with, for example, liquor category display areas 51-1, 51-2, 51-3, 51-4, 51-5, 51-6 corresponding to a plurality of liquor categories, respectively. .. In addition, in one screen of the liquor tax exemption pop-up D2, only the liquor category display areas 51-1 to 51-6 corresponding to the six liquor categories among the twelve liquor categories are displayed. In response to the operation on the upper button 56A or the lower button 56B, a display area for each of the six alcoholic beverage categories corresponding to the remaining six alcoholic beverage categories is displayed.

Alcoholic beverage category display areas 51-1 to 51-6 are provided with alcoholic beverage category name display area 52, tax rate display area 53, capacity display area 54, and liquor tax amount display area 55, respectively.

The name of the alcoholic beverage category is displayed in the alcoholic beverage category name display area 52. Alcoholic beverages include sparkling liquor, sparkling liquor (malt ratio 25 to less than 50%), happoshu (malt ratio less than 25%), and other sparkling liquor, brewed liquor, sake, fruit liquor and distilled liquor. There are brandy spirits, mixed liquors, synthetic sake, and sweet fruit liquor.

The tax rate display area 53 displays the tax rate (tax amount per 1 kl) for each liquor category recorded in the liquor tax data 22. In the capacity display area 54, the total capacity of alcoholic beverages in the same alcoholic beverage category to be purchased is displayed. In the liquor tax amount display area 55, the liquor tax amount corresponding to the liquor category calculated based on the tax rate and the capacity composition displayed in the capacity display area 54 is displayed.

The liquor tax exemption pop-up D2 is provided with a total capacity display area 57, a liquor quantity display area 58, and a liquor tax total amount display area 59. The total capacity display area 57 displays the total capacity (total capacity) displayed in the capacity display areas 54 corresponding to all liquor categories. In the liquor quantity display area 58, the number of liquors (products) to be exempted from liquor tax is displayed. In the liquor tax total amount display area 59, the total liquor tax amount displayed in the liquor tax amount display area 55 corresponding to all liquor categories (total liquor tax amount) is displayed.

Further, the liquor tax exemption pop-up D2 is provided with a numerical value input area 60 for accepting an input operation, a subtraction button 61, a confirm button 62, and a cancel button 63. A message display area 64 is provided at the bottom of the liquor tax exemption pop-up D2 to display a message for guiding the input operation. In the numerical value input area 60, numeral buttons from "00", "0" to "9", a clear button for instructing to clear the input by operating the number buttons, and an instruction for confirming the input by operating the number buttons Includes an enter button. The subtraction button 61 is a button for instructing the subtraction of the input capacity and quantity.

First, the processor 11a acquires liquor information from the liquor tax data 22, displays the name of the liquor category in the liquor category name display area 52 of the liquor tax exemption popup D2, and displays the tax amount in the tax rate display area 53 according to each liquor category. Is displayed. The alcoholic beverage category name display area 52 corresponding to each of the plurality of alcoholic beverage categories can be arbitrarily designated by a touch operation. The processor 11a causes the message display area 64 to display a message such as “Please select a liquor category”.

For example, the employee refers to the unregistered liquor listed in the touch panel 11h and confirms the liquor category corresponding to the unregistered liquor. Then, one of the alcoholic beverage category name display areas 52 corresponding to the corresponding alcoholic beverage category is touch-operated. The processor 11a selects the liquor (liquor category) to be the target of the liquor tax calculation in accordance with the touch operation on the liquor category name display area 52. Next, the processor 11a causes the message display area 64 to display, for example, a message "Please input the capacity".

The employee can input a numerical value indicating the capacity of one unregistered liquor (product) by an input operation on the numerical buttons in the numerical input area 60, and can instruct the confirmation of the input by operating the enter button. it can. The processor 11a detects the input operation of the numeric buttons and the enter key in the numeric input area 60, and inputs the numeric value indicating the capacity corresponding to the input operation (Act 34). Further, the processor 11a causes the message display area 64 to display a message such as "Please input the quantity".

Next, the employee can input the number of unregistered alcoholic beverages by operating the numerical value input area 60 in the same manner as described above. For example, if the unregistered liquor is an effervescent type (beer) and you are going to purchase in units of 6 bottles, for example, after inputting the capacity for one bottle, the quantity “6 bottles” is input. It The processor 11a inputs a numerical value indicating the quantity of unregistered liquor in response to an input operation on the numerical value input area 60 (Act 35).

When the numerical value indicating the quantity is input after the capacity, the processor 11a calculates the capacity of the liquor by the capacity×the quantity, and according to the input capacity and the numerical value in the capacity display area 54 of the liquor tax exemption popup D2. Display capacity. If the previously entered capacity is displayed, it is displayed in addition to the previously entered capacity.

Further, the processor 11a calculates the liquor tax amount for the liquor category subject to the liquor tax calculation in accordance with the tax rate of the liquor category subject to the liquor tax calculation and the capacity and the numerical value (Act 36). The processor 11a displays the liquor tax amount obtained by the calculation in the liquor tax amount display area 55. If the liquor tax amount already entered is displayed, it is displayed in addition to the liquor tax amount previously calculated.

Further, the processor 11a calculates the total amount of liquor tax by summing it with the amount of liquor tax for other liquor categories, and displays the total amount of liquor tax in the total amount of liquor tax display area 59 (Act 37). Further, the processor 11a updates the total capacity displayed in the total capacity display area 57 according to the input capacity, and the number of liquor displayed in the liquor number display area 58 according to the input quantity. To update.

If there is another unregistered liquor (Act 38, No), the processor 11a calculates the liquor tax amount for each liquor category according to the selection of the liquor category, the input of the capacity and the quantity in the same manner as described above. Calculate the total amount (Act 31-37).

Therefore, in the liquor tax exemption pop-up D2, the total amount of unregistered liquor is calculated for each liquor category, and the liquor tax amount for each liquor category (liquor tax code) is calculated based on the different tax rate (tax amount per 1 kl) for each liquor category. Can be calculated and the liquor tax amount for each liquor category can be summed up to calculate the tax-free liquor tax amount (total liquor tax amount).

The subtraction button 61 is used to cancel the input capacity and quantity. When the processor 11a detects that the subtraction button 61 has been operated, it selects the liquor category, inputs the capacity and the quantity, and subtracts the entered capacity and numerical value for the corresponding liquor category, in the same manner as described above. At the same time, the liquor tax amount and the liquor tax total amount for the liquor category are subtracted.

Also, for alcoholic beverages manufactured at other factories that are not exempt from alcoholic tax under the new alcoholic tax exemption system, even if they are registered as unregistered alcoholic beverages, they will be exempt from alcoholic tax exemption unless the alcoholic tax is calculated through the alcoholic tax exemption popup D2. can do.

When the confirmation of the liquor tax calculation is instructed by the operation on the confirm button 62 (Act 38, Yes), the processor 11a records the data and the calculation result input through the liquor tax exemption pop-up D2 in the storage unit 11d, and the liquor tax exemption pop-up D2 is displayed. It erases from the touch panel 11h (Act 39).

Further, the processor 11a displays the tax exemption amount displayed in the tax exemption amount display area 36 of the tax exemption confirmation popup D1 by adding the total amount of liquor tax to the liquor tax exemption amount display area 37 (Act 40). , The liquor tax calculation process ends.

Next, when it is determined that unregistered liquor is not stored in the product to be currently purchased (Act 15, No), and after the liquor tax calculation process is executed, the processor 11 a registers the product master data 21. A liquor tax confirmation process for calculating a liquor tax based on each of the data of the exempted tax exemption target flag, the liquor tax code, and the capacity is executed (Act 17).

FIG. 6 is a flowchart showing an example of the liquor tax confirmation processing according to this embodiment.
When the liquor tax confirmation process is started, the processor 11a sets “1” indicating that the product category is liquor and the tax exemption exemption flag indicates exemption from the liquor tax exemption among the products registered in the registered product table by the product registration process. For each liquor (product) that does not exist, each data of the liquor tax code and capacity set in the product master data 21 and the number (quantity) registered in the registered product table is acquired (Act 51).

Since the exemption target flag is set in the product master data 21, even if the same liquor sold at a store in the manufacturing site is liquor manufactured at another manufacturing site, the new liquor tax exemption is applied. It can be treated as exempt from liquor tax exemption by the system.

When there are a plurality of liquors (products) of the same liquor category (liquor tax code) in the registered product table, the processor 11a determines the capacity and quantity of one liquor (product) in the same manner as the liquor tax calculation process. Then, the total capacity is calculated for each liquor category, and the liquor tax amount for each liquor category is calculated based on the total capacity and the liquor tax corresponding to the liquor tax code.

Further, when the liquor tax calculation process is executed first, the processor 11a reads the calculation result for the unregistered liquor calculated in the liquor tax calculation process from the storage unit 11d, and the above-described product master data 21 and the registered product. It is added to the calculation result calculated based on the table (Act 52).

Thereby, the total amount of liquor tax by liquor tax exemption corresponding to the new liquor tax exemption system including the liquor registered in the product master data 21 and the unregistered liquor (unregistered liquor) can be obtained.

The processor 11a displays the total amount of liquor tax added up by adding the total amount of liquor tax to the tax exemption amount displayed in the tax exemption amount display area 36 of the tax exemption confirmation pop-up D1. Further, the processor 11a displays the total amount of liquor tax in the liquor tax exemption amount display area 37 (Act 53).

Next, the processor 11a displays a screen for confirming the liquor tax amount and the liquor tax exemption amount (total amount) for each liquor category on the touch panel 11h (Act 54). Hereinafter, a screen for confirming the liquor tax exemption amount will be described as a liquor tax exemption popup D3 (liquor tax exemption popup 2).

FIG. 9 is a diagram showing an example of a screen (liquor tax exemption pop-up D3 (liquor tax exemption pop-up 2)) for confirming the liquor tax exemption amount in the present embodiment.

The liquor tax exemption pop-up D3 basically has the same format as the liquor tax exemption pop-up D2 described above. However, in the liquor tax exemption pop-up D3, since no data is input for liquor tax calculation, the numerical value input area 60, the subtraction button 61, the cancel button 63, and the message display area 64 in the liquor tax exemption pop-up D2 are omitted.

The liquor tax exemption pop-up D3 is provided with liquor category-specific display areas 61-1, 61-2, 61-3, 61-4, 61-5, 61-6 corresponding to a plurality of liquor categories. In response to an operation on the up button 66A or the down button 66B, a display area for each of the six alcoholic beverage categories corresponding to the remaining six alcoholic beverage categories is displayed.
Alcoholic beverage category display areas 61-1 to 61-6 are provided with alcoholic beverage category name display areas 62, tax rate display areas 63, capacity display areas 64, and liquor tax amount display areas 65, respectively.

The name of the alcoholic beverage category is displayed in the alcoholic beverage category name display area 62. In the tax rate display area 63, the tax rate for each liquor category is displayed. In the capacity display area 64, the total capacity by liquor category obtained by the above-described calculation is displayed. In the liquor tax amount display area 65, the liquor tax amount corresponding to the liquor category based on the tax rate and the capacity composition, which is obtained by the above-described calculation, is displayed.

The liquor tax exemption pop-up D3 is provided with a total capacity display area 67, a liquor quantity display area 68, and a liquor tax total amount display area 69. In the total capacity display area 67, the total capacity (total capacity) displayed in the capacity display areas 64 corresponding to all liquor categories is displayed. In the liquor quantity display area 68, the number of liquors (products) to be exempted from liquor tax is displayed. The total amount of liquor tax displayed in the liquor tax amount display area 65 corresponding to all liquor categories is displayed in the total liquor tax amount display area 69 (total liquor tax amount).

Further, a confirmation button 62 is provided on the liquor tax exemption pop-up D3. When the liquor tax confirmation completion is instructed by operating the confirm button 62 (Act 55, Yes), the processor 11a erases the liquor tax exemption popup D3 from the touch panel 11h (Act 56) and ends the liquor tax confirmation process.

The employee can confirm the tax exemption amount and the tax exemption amount based on the tax exemption confirmation pop-up D1 that reflects the results of the liquor tax confirmation process and the liquor tax calculation process executed when there is unregistered liquor. .. Here, the same processing as described above can be executed again by operating the compulsory tax exemption buttons 38, 39 or the liquor tax exemption button 40 (Act 18, No) (Acts 12 to 17). When the confirmation is completed in the tax exemption confirmation pop-up D1, the employee can operate the confirm button 41 to instruct the end of the tax exemption confirmation.

When the processor 11a detects an operation on the confirm button 41 (Act 18, Yes), the tax exemption confirmation pop-up D1 is erased from the touch panel 11h (Act 19), and the state returns to the execution state of the merchandise registration process. Further, if the merchandise is not registered, the employee operates the subtotal key. When detecting that the subtotal key is operated (Act 6, Yes), the processor 11a determines whether the tax exemption process is being executed by operating the tax exemption key. When the tax exemption processing is being executed (Act 20, Yes), the processor 11a inputs passport information that needs to be printed on the export duty-free article purchase record slip and the export duty-free article purchase pledge after the settlement processing. The passport reader 11p reads the passport information (name, date of birth, type of passport, nationality, etc.) recorded in the passport when the passport presented by the foreign traveler who intends to purchase the product is set. .. The processor 11a stores the passport information read by the passport reader 11p in the RAM 11c. The processor 11a executes a settlement process including the tax exemption content confirmed in the tax exemption confirmation pop-up D1 (Act8).

When the payment is completed, the processor 11a causes the printer 11k to print the transaction content on a receipt sheet and issues a transaction receipt and purchase details. When the tax exemption processing is performed, the processor 11a prints the tax exemption information on the transaction receipt and the purchase details. Further, the processor 11a prints the export duty-free article purchase record slip and the export duty-free article purchase pledge for the tax-exempted transaction on the receipt paper and issues the receipt.

FIG. 10 is a diagram showing an example of a transaction receipt R1 and purchase details R2 when tax exemption processing is performed in the present embodiment.
As shown in FIG. 10, in addition to information (name, unit price, subtotal amount, etc.) R10 regarding the purchased product, information R11 to R18 relating to tax exemption and the total amount R19 after tax exemption are printed on the transaction receipt R1. .. The information R11 to R18 related to tax exemption includes the total amount R12 of tax exemption objects for general goods, the total amount R13 of tax exemption objects for consumables, the total amount R14 (tax excluded amount) for tax exemption objects (general goods and consumables), The tax exemption amount (excluding tax/internal tax) R15, the taxable amount R16 of the SI category set as tax exemption, the liquor tax amount R17 to be exempted, and the fractional amount discount R18 are included. In the transaction receipt R1 according to the present embodiment, since the liquor tax amount R17 to be subjected to tax exemption processing is printed, it is possible to confirm that the liquor tax is exempt and the liquor tax exemption amount.

As shown in FIG. 10, the purchase details R2 includes information (name, amount, subtotal, etc.) R20 regarding products corresponding to purchased general items, general item tax exemption target R21, and items corresponding to purchased consumable items. Information (name, amount, subtotal amount, etc.) R22 and consumables tax exemption target total R23 are printed. Further, on the purchase statement R2, a tax exemption target total R24, a tax exemption amount R25, and a liquor tax exemption amount R26 are printed as information related to tax exemption. In addition, information (salesperson, person in charge, transaction number, number of points purchased) R27 related to the store is printed on the purchase statement R2. In the purchase specification R2 in the present embodiment, not only the total tax exemption target for general goods and consumables can be confirmed, but also the liquor tax exemption amount R26 can be individually confirmed.

FIG. 11 is a diagram showing an example of the export tax-exempt article purchase record slip R3 printed when the tax-exempt processing is performed in the present embodiment.
As shown in FIG. 11, in the export duty-free article purchase record sheet R3, in addition to date and time information, passport information R30, purchase statement R31 (same as purchase statement R2), Japanese and nationality included in the passport information A note R33 in different languages is printed. The purchase statement R31 includes a tax exemption amount R32. In addition, the export tax exemption article purchase record R3 is printed with an additional record R34 of the liquor tax rate application category. In addition to the liquor tax rate application category R34, the liquor category (liquor tax rate) name R35, the total capacity and the tax rate R36 are printed for the liquor category (liquor tax rate) in the liquor tax calculation corresponding to the product subject to liquor tax exemption. .. If another product having a different liquor category (liquor tax rate) is purchased, the name R37 of the liquor category (tax rate category), the total capacity, and the tax rate R38 are printed for each.

On the export duty-free goods purchase record R3, the names R35 and R37 of the liquor categories (tax rate categories) subject to the liquor tax exemption, the total capacity and the tax rates R36 and R38 are printed. It is tax exempt and you can check the tax exempt capacity and tax rate.

FIG. 12 is a diagram showing an example of the export duty-free article purchase pledge R4 printed when the tax-exempt processing is performed in the present embodiment.
As shown in FIG. 12, passport information R40 (including signature area R41) and purchase statement R42 (same as purchase statement R2) are printed on the export duty-free article purchase pledge R4, in addition to date and time information. The purchase statement R42 includes a tax exemption amount R43. Further, on the export duty-free article purchase pledge R4, an additional note R45 of the taxation rate applicable to liquor tax is printed in the same manner as the export duty-free article purchase record slip R3.

In the export duty-free article purchase pledge R4, similarly to the export duty-free article purchase record slip R3, any of the twelve liquor categories is subject to liquor tax exemption, and the capacity and tax rate subject to tax exemption can be confirmed.

According to the embodiment described above, the POS terminal 10 (commodity sales data processing device) according to the present embodiment can perform sales data processing for performing tax exemption processing on liquor corresponding to the new liquor tax exemption system. As a result, retailers that are exempt from liquor tax will be able to purchase appropriate products according to the liquor from different manufacturing sites and liquor with different liquor tax included in multiple products that foreign tourists visiting Japan will purchase. Data processing becomes possible and the burden on employees can be greatly reduced.

In addition, in the present embodiment, the sales data processing corresponding to the new liquor tax exemption system is described as an example, but sales related to tax exemption when a plurality of types of products having different tax rates are mixed such as the above-mentioned alcoholic beverages. It can be applied to a product sales data processing device that requires data processing.

Although some embodiments of the present invention have been described, these embodiments are presented as examples and are not intended to limit the scope of the invention. These novel embodiments can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the spirit of the invention. These embodiments and their modifications are included in the scope and gist of the invention, and are also included in the invention described in the claims and the scope of equivalents thereof.

Further, the processing described in the above-described embodiments is a recording medium such as a magnetic disk (flexible disk, hard disk, etc.), optical disk (CD-ROM, DVD, etc.), semiconductor memory, etc., as a program that can be executed by a computer. Can be provided to various devices. It is also possible to transmit the data via a communication medium and provide it to various devices. The computer reads the program recorded in the recording medium or receives the program via the communication medium, and the operation is controlled by the program to execute the above-described processing.

10... POS terminal, 11a... Processor, 11b... ROM, 11c... RAM, 11d... Storage unit, 11e... Change machine, 11f... Communication unit, 11g... Scanner, 11h... Touch panel, 11j... Keyboard, 11k... Printer, 11p... Passport reader, 12... Server.

Claims (5)

Storage means for storing, for each product code of liquor, liquor tax data indicating the type of liquor tax in association with the product code and product master data in which the capacity is set,
An input means for inputting the product code of the alcoholic beverage to be purchased,
Based on the liquor tax data and the capacity of the liquor corresponding to the product code entered by the input means, the liquor capacities corresponding to the plurality of product codes are added up for each liquor tax data, A first calculating means for calculating the amount of liquor tax,
When the liquor tax data corresponding to the product code input by the input means is not set in the product master data, the data input means for inputting the liquor tax data and the capacity corresponding to the product code according to a user operation. When,
Second calculating means for calculating the liquor tax amount for each liquor tax data by summing up the liquor capacities corresponding to the plurality of the product codes for each liquor tax data based on the data input by the data inputting means,
Third calculating means for calculating the total amount of liquor tax by adding up the amount of liquor tax for each liquor tax data calculated by the first calculating means and the second calculating means ,
A product sales data processing device comprising: output means for outputting the total amount of liquor tax. In the product master data, in association with the product code of liquor, set non-target data indicating that it is excluded from the calculation of the liquor tax amount,
The product sales data processing device according to claim 1, wherein the first calculation unit excludes alcoholic beverages corresponding to the product code for which the exclusion data is set, from the calculation of the liquor tax amount. The product sales data processing device according to claim 1 or 2, wherein the output means displays, together with the total amount of liquor tax, the price of alcoholic beverages up to a tax exemption standard amount for the exemption of the total amount of liquor tax. And the output means, liquor the liquor in the respective data tax and the liquor total printed on receipt paper, merchandise sales data processing apparatus according to any one of claims 1 to 3 issues a receipt. Computer,
Storage means for storing, for each product code of liquor, liquor tax data indicating the type of liquor tax in association with the product code and product master data in which the capacity is set,
An input means for inputting the product code of the alcoholic beverage to be purchased,
Based on the liquor tax data and the capacity of the liquor corresponding to the product code entered by the input means, the liquor capacities corresponding to the plurality of product codes are added up for each liquor tax data, A first calculating means for calculating the amount of liquor tax,
When the liquor tax data corresponding to the product code input by the input means is not set in the product master data, the data input means for inputting the liquor tax data and the capacity corresponding to the product code according to a user operation. When,
Second calculating means for calculating the liquor tax amount for each liquor tax data by summing up the liquor capacities corresponding to the plurality of the product codes for each liquor tax data based on the data input by the data inputting means,
Third calculating means for calculating the total amount of liquor tax by adding up the amount of liquor tax for each liquor tax data calculated by the first calculating means and the second calculating means ,
A program for functioning as an output means for outputting the total amount of liquor tax.