Commodity sales data processing apparatus and program

Abstract

To execute sales data processing related to tax exemption in a case where a plurality of types of commodities different in tax rate are mixed.SOLUTION: According to an embodiment, a commodity sales data processor has storage means, input means, first calculation means, second calculation means, and output means. The storage means stores, per commodity code of an alcoholic beverage, liquor tax data indicating the type of a liquor tax and commodity master data in which a volume is set in association with the commodity code. The input means inputs a commodity code of an alcoholic beverage to be a purchase target. On the basis of the liquor tax data and the volume of the alcoholic beverage corresponding to the commodity code input by the input means, the first calculation means adds up the volumes of alcoholic beverages corresponding to a plurality of the commodity codes per liquor tax data to calculate a liquor tax amount per liquor tax data. The second calculation means adds up liquor tax amounts per liquor tax data to calculate a liquor tax total amount. The output means outputs the liquor tax total amount.SELECTED DRAWING: Figure 1

Description

Technical Field

[0001] Embodiments of the present invention relate to a product sales data processing apparatus and a program.

Background Art

[0002] When an operator who manages an export goods sales venue (duty-free store) sells goods to non-residents such as foreign travelers, there is a so-called duty-free system that exempts consumption tax on the goods. Further, as of October 1, 2017, for alcoholic beverages sold to foreign travelers visiting Japan, a system that exempts liquor tax in addition to consumption tax is scheduled to be implemented.

[0003] The new system that exempts liquor tax is a system applied to sales stores within liquor manufacturing facilities such as wineries. Also, even for alcoholic beverages sold at sales stores within manufacturing facilities, liquor tax exemption is only applied to in-house products. Further, there are multiple types of alcoholic beverages, such as sparkling alcoholic beverages, fermented alcoholic beverages, distilled alcoholic beverages, and blended alcoholic beverages, and different tax rates (liquor tax amounts) are determined for each.

[0004] Therefore, at sales stores that exempt liquor tax, it is necessary to perform appropriate sales data processing according to multiple types of alcoholic beverages with different manufacturers and different liquor tax amounts included in multiple products that foreign travelers visiting Japan intend to purchase.

Prior Art Documents

Patent Documents

[0005]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0006] The problem to be solved by the present invention is to provide a product sales data processing apparatus and a program capable of executing sales data processing related to duty-free when multiple types of products with different tax rates are mixed.

Means for Solving the Problem

[0007] According to an embodiment, For liquor tax a merchandise sales data processing apparatus that conducts duty-free transactions includes a registration means, a first display means, a calculation means, and a second display means. The registration means registers merchandise. The first display means Registered displays on a display unit a screen including a display area When there is liquor subject to liquor tax exemption among the registered liquors showing the volume of liquor For contained in the merchandise. The calculation means calculates the liquor tax amount from the volume of liquor input with respect to the display area and the tax rate corresponding to the liquor. The second display means Tax exemption displays the liquor tax amount Tax exemption on the display unit.

Brief Description of the Drawings

[0008]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Mode for Carrying Out the Invention

[0009] Hereinafter, this embodiment will be described with reference to the drawings.

[0010] FIG. 1 is a block diagram showing the system configuration of a checkout system provided with a product sales data processing device according to this embodiment.

[0011] In FIG. 1, the checkout system is connected such that a plurality of POS terminals 10 (10-1, 10-2,..., 10-n) and a server 12 (server 12) can communicate with each other via a network such as a LAN (Local Area Network) 14. 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. Note that the exemption from taxes for product sales targets not only liquor tax but also other taxes such as consumption tax. However, in the following embodiments, the description will mainly focus on liquor tax exemption.

[0012] Note that the product sales data processing device may be composed of one POS terminal 10 and a server 12, or may be composed of a plurality of POS terminals 10 and a server 12.

[0013] The POS terminal 10 implements the functions of a computer and includes a processor (such as a CPU (central processing unit)) 11a, a ROM (read-only memory) 11b, a RAM (random-access memory) 11c, a storage unit 11d, a change dispenser 11e, a communication unit 11f, a scanner 11g, a touch panel 11h, a keyboard 11j, a printer 11k, a card reader / writer 11m, a display 11n, and a passport reader 11p.

[0014] The processor 11a is a circuit for controlling each part in order 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.

[0015] In addition to various programs executed by the processor 11a, the ROM 11b and the RAM 11c record data that the processor 11a refers to when performing various processes. For example, when a process of registering product information is executed, a registered product table in which product information to be purchased by a customer is registered is recorded in the RAM 11c. Also, data of a screen to be displayed on the touch panel 11h and the display 11n is stored in the RAM 11c.

[0016] The program executed by the processor 11a includes a control program for executing a scan process for inputting product information (such as product codes) through the scanner 11g, a product registration process for generating transaction information used in a settlement process according to the information of the products registered in the registered product table, a settlement process based on the transaction information, and the like. Further, it includes a program for executing a tax exemption process for the products registered by the product registration process for tax exemption. The tax exemption process includes not only a consumption tax exemption process but also a liquor tax exemption process corresponding to a system (hereinafter referred to as the new liquor tax exemption system) that exempts the liquor tax applied to the sales stores within the liquor manufacturing plant. By executing the control program, the processor 11a causes the touch panel 11h to display a screen for processing related to the sale of products (including registration processing and settlement processing).

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

[0018] The change dispenser 11e receives the inserted coins and banknotes and discharges the coins and banknotes as change. The communication unit 11f controls communication with the server 12 and other POS terminals 10 via the LAN 14.

[0019] The scanner 11g reads product information by optical scanning, for example, and inputs a product code unique to the product. The scanner 11g may be a fixed or handheld two-dimensional code scanner, or may be a type that identifies products using image recognition technology from an image of the photographed product. Also, the scanner 11g may be provided with only one type or a plurality of types.

[0020] The touch panel 11h is a device operated by an employee (cashier) for input, and includes a display device and a touch sensor. The display device displays any screen such as a GUI (Graphical User Interface) screen. For example, the display device displays a registration screen (product list screen) including a list of transaction information (product name, amount, etc.) regarding products registered for purchase, a subtotal amount, etc., a menu including a plurality of keys corresponding to each of various functions, and an operation screen including keys for inputting commands for instructing execution of various functions. As the display device, a well-known device such as a color LCD (Liquid Crystal Display) can be used. The touch sensor is disposed over the display surface of the display device. The touch sensor detects the touch position of an operator on the display surface of the display device and sends the position information to the processor 11a. As the touch sensor, a well-known device can be used.

[0021] The keyboard 11j is a device operated by an employee (cashier) for input, and for example, a plurality of keys to which specific functions are individually assigned are arranged.

[0022] The printer 11k is, for example, a thermal printer or a dot impact printer, etc., and prints various character strings, images, code patterns (barcodes, two-dimensional codes, etc.) on receipt paper to issue a transaction receipt, etc. on which transaction details including product name, unit price, total amount, duty-free related information including liquor tax are printed.

[0023] The card reader / writer 11m reads data recorded on a card and writes data to the card. The card includes various cards for recording information related to settlement processes such as membership cards and point cards, in addition to settlement cards such as credit cards, debit cards, electronic money cards, and prepaid cards. The card reader / writer 11m may be any of a magnetic, contact, or non-contact device, or may include a plurality of types of devices.

[0024] The display 11n is a device used, for example, for the customer side to provide information to customers, and well-known devices such as color LCDs can be used.

[0025] The passport reader 11p is a reading device for reading information recorded in a passport in order to confirm that a person is eligible for duty-free treatment when conducting duty-free processing for foreign travelers visiting Japan. The passport reader 11p performs optical character information reading or reads information from the storage medium (IC) of an electronic passport.

[0026] The server 12 includes a processor (such as a CPU) 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 the functions of a computer.

[0027] The processor 21a is a circuit for controlling each part in order 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.

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

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

[0030] The memory unit 21d stores data used by the processor 21a to perform various processes, or data generated by the processes in the processor 21a. As the memory unit 21d, for example, an HDD or an SSD can be used. In the memory unit 21d, product master data 21, liquor tax data 22, sales management data (including sales data (including product name, price, sales time, number of sales, etc.), inventory data, etc.) used for product sales processing in the POS terminal 10 are stored.

[0031] The communication unit 21f controls communication with the POS terminal 10 etc. via the LAN 14. The keyboard 21g inputs data for the server 12 according to the operations by employees. Note that the server 12 may be provided with input devices (touch panels, mice, 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 external devices such as a server (such as a website) via an external network such as the Internet.

[0032] 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 the present embodiment. As shown in FIG. 2, in the product master data 21, product classification, product name, price, duty-free type, etc. are registered in association with a product code unique to the product. The product classification is information for classifying products, and is divided into, for example, major classification, medium classification, and minor classification. The product classification includes data indicating the classification of liquors. The price may be the price excluding consumption tax, the price including consumption tax, or the price excluding liquor tax. The duty-free type indicates whether the duty-free target item (product) is a general item or a consumable. Consumables include liquors. Further, in the product master data 21, for liquors included in general items, for the liquor tax duty-free process corresponding to the new liquor tax duty-free system, each data of a duty-free target exclusion flag (exclusion data), liquor tax code, and volume is registered.

[0033] The non-tax-exempt flag is data indicating that even if the liquor is subject to liquor tax exemption, it is not subject to liquor tax exemption (for example, setting the non-tax-exempt flag to "1" indicates that it is not subject to liquor tax exemption). That is, the new liquor tax exemption system is a system applied to sales stores within liquor manufacturing facilities such as breweries, and it is assumed that liquor tax exemption applies only to in-house products. For this reason, even for the same type of liquor sold in a sales store within a manufacturing facility, it is necessary to exclude liquors manufactured by other manufacturing facilities, etc. from the scope of liquor tax exemption. Therefore, the non-tax-exempt flag is set to "1" for liquors that are not subject to liquor tax exemption (liquor tax calculation). The liquor tax code is set to refer to tax rates, etc. corresponding to the liquor of the product from the liquor tax data 22. The volume is referred to for calculating the liquor tax amount for each type of liquor.

[0034] In the POS terminal 10 of this embodiment, for the liquor tax exemption process corresponding to the new liquor tax exemption system, a first processing method and a second processing method are used. The first processing method is a method of registering in advance in the product master data 21 each data of the non-tax-exempt flag, liquor tax code, and volume for liquors (products) subject to liquor tax exemption. The second processing method is a method of inputting, by an operation of an employee, the data necessary for the liquor tax exemption process corresponding to the new liquor tax exemption system without registering in advance in the product master data 21 each data of the non-tax-exempt flag, liquor tax code, and volume. Liquors for which each data of the non-tax-exempt flag, liquor tax code, and volume is not registered in advance in the product master data 21 are described as unregistered liquors.

[0035] In the first processing method, when selling liquor to foreign tourists visiting Japan, it is possible to execute accounting processing corresponding to liquor tax exemption corresponding to the new liquor tax exemption system without increasing the workload of the employee operating the POS terminal 10. In the second processing method, even when maintenance of the product master data 21 cannot be handled due to reasons such as large fluctuations in the liquors handled and a large variety of liquor types in a sales store within a liquor manufacturing facility such as a brewery, when selling liquor to foreign tourists visiting Japan, it is possible to perform accounting processing corresponding to liquor tax exemption corresponding to the new liquor tax exemption system by individual response.

[0036] Figure 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. It is associated with a unique liquor tax code for each type of liquor, and data indicating the liquor tax amount (tax rate), the name used when displaying on the screen (screen), and the name used when printing on the receipt (printing) are associated. The liquor tax amount (tax rate) has different tax rates (tax amount per 1 kl) set for each of, for example, 12 types of liquor classifications. For example, when the liquor classification is "sparkling wine (malt ratio less than 25% to 50%)", the tax rate is set at "178,125 yen" per 1 kl, and when it is "sake", the tax rate is set at "120,000 yen" per 1 kl.

[0037] The liquor tax data 22 refers to each data including the tax rate corresponding to the liquor based on the liquor tax code of the product code (product) set in the product master data 21.

[0038] Next, the operation of the POS terminal 10 in the present embodiment will be described. FIG. 4, FIG. 5, and FIG. 6 are flowcharts showing an example of the operation of the POS terminal 10 in the present embodiment.

[0039] First, in the POS terminal 10, product registration is performed for the 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).

[0040] In the product registration process, the processor 11a searches the product master data 21 previously acquired from the server 12 using the product code as a key, extracts product information (product name, product classification, tax exemption type, price, etc.) for the product code, and records it in the registered product table.

[0041] In the case where a plurality of the same products are to be purchased, numerical data indicating the quantity is input by operating the numeric keys on the touch panel 11h or the keyboard 11j. After the product code is input, when the numerical data is input, the processor 11a records product information corresponding to the quantity indicated by the numerical data in the registered product table.

[0042] The processor 11a displays purchase information (e.g., product name, duty-free type, price, quantity, etc.) among the product information on, for example, the touch panel 11h for employees and the display 11n for customers.

[0043] Further, the processor 11a determines whether the product corresponding to the product code is an unregistered liquor. That is, the processor 11a determines that it is an unregistered liquor when the product classification corresponding to the product code is liquor and at least the liquor tax code among the non-duty-free target flag, liquor tax code, and volume is not registered. In addition, when "1" is set in the non-duty-free target flag, it is determined not to be an unregistered liquor because it is a liquor that is not subject to liquor tax exemption under the new liquor tax exemption system.

[0044] When the product (liquor) whose product code has been read is determined to be an unregistered liquor (Act3, Yes), the processor 11a stores the corresponding product (liquor) as an unregistered liquor in the RAM 11c and displays on the touch panel 11h that it is an unregistered liquor together with the product name of the corresponding product. That is, by displaying to the employee that it is an unregistered liquor, it is notified that it is a liquor for which it is necessary to input data required for liquor tax exemption processing (the second processing method) under the new liquor tax exemption system. Note that not only the display on the touch panel 11h may be used to notify that it is an unregistered liquor, but also a predetermined sound may be used for notification.

[0045] Similarly, if there are other products to be purchased, the barcodes attached to the products are sequentially scanned and product registration processing is executed. Also, if a product is determined to be unregistered liquor, the product name corresponding to the touch panel 11h is displayed. Note that if there are multiple unregistered liquors, the processor 11a may display a list of the multiple unregistered liquors on the touch panel 11h.

[0046] Here, when it is detected that the subtotal key has been operated (Act6, Yes), if the tax exemption process has not been executed by operating the tax exemption key (Act20, No), the processor 11a executes a non-tax-exempt settlement process (Act8). That is, the processor 11a generates transaction information for settling the products to be purchased registered in the registered product table, and processes the settlement using cash or a settlement card (such as a credit card) for the transaction information. When the settlement is completed, the processor 11a causes the printer 11k to print the transaction details on receipt paper to issue a transaction receipt and a purchase statement.

[0047] On the other hand, when tax exemption processing is required, an employee operates the tax exemption key. When the processor 11a detects that the tax exemption key has been operated (Act5, Yes), based on the product information of the products to be purchased registered in the registered product table, it executes a tax exemption confirmation calculation for displaying the amount and the like to be displayed on the tax exemption confirmation screen (Act10). Based on the calculation result of the tax exemption confirmation calculation, the processor 11a causes the tax exemption confirmation screen to be displayed on the touch panel 11h (Act11).

[0048] FIG. 7 is a diagram showing an example of a tax exemption confirmation screen in the present embodiment. Hereinafter, the tax exemption confirmation screen will be described as a tax exemption confirmation popup D1.

[0049] In the tax-free confirmation pop-up D1, for example, there are provided 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, an alcoholic beverages shortage amount display area 35, a tax-free amount display area 36, and a liquor tax-free amount display area 37. In the general goods total amount display area 31, the total amount of goods subject to general goods is displayed. In the general goods shortage amount display area 32, the amount until tax-free eligibility for goods subject to general goods is displayed. In the consumables total amount display area 33, the total amount of goods subject to consumables is displayed. In the consumables shortage amount display area 34, the amount until tax-free eligibility for consumable goods is displayed. In the alcoholic beverages shortage amount display area 35, the price of alcoholic beverages that fills the shortage amount until tax-free eligibility for consumables is displayed. In the tax-free amount display area 36, the total of the tax-free amounts for each of the general goods and consumables (total tax-free amount) is displayed. The liquor tax-free amount display area 37 displays the liquor tax-free amount under the new liquor tax exemption system for the alcoholic beverages included in the consumables.

[0050] Generally, general goods and consumables are basically subject to tax exemption when the total amount after tax exemption for each reaches or exceeds the tax exemption standard amount (5,000 yen). Therefore, when the total amount after tax exemption has not reached the tax exemption standard amount, the shortage amounts can be displayed in the general goods shortage amount display area 32 and the consumables shortage amount display area 34 respectively, and the amount required to reach the tax exemption standard amount can be notified to the customer from the employee to the customer. As a result, the employee can encourage the customer to purchase more goods. Also, the customer can purchase goods until reaching the tax exemption standard amount following the advice from the employee and enjoy the benefits of tax exemption.

[0051] Furthermore, in the duty-free confirmation pop-up D1, in the alcohol shortage display area 35, the amount necessary to make up for the shortage up to the duty-free standard amount by purchasing alcohol is displayed. Alcohol tax is included in the price of alcohol. Therefore, even if the total amount for consumables reaches the duty-free standard amount by additional purchase based on the price of alcohol, there may be cases where the alcohol tax is exempted and cases where it does not reach the duty-free standard amount. For this reason, by displaying the shortage amount up to the establishment of duty-free (duty-free standard amount) when purchasing alcohol in the alcohol shortage display area 35, the employee can surely notify the customer of the amount of alcohol necessary to reach the duty-free standard amount.

[0052] Note that the amounts displayed in the general goods shortage display area 32, the consumables shortage display area 34, and the alcohol shortage display area 35 do not have to be the exact amounts up to the duty-free standard amount. For example, amounts less than 10 yen can be rounded up to be displayed in units of 10 yen, as long as they are amounts that reach the duty-free standard amount.

[0053] In the duty-free amount display area 36, the duty-free amount calculated when at least one of the general goods and consumables reaches the duty-free standard amount is displayed. The alcohol tax duty-free amount display area 37 displays the alcohol tax duty-free amount calculated by the alcohol tax duty-free process when the application of alcohol tax duty-free corresponding to the new alcohol tax duty-free system is instructed by an operation on the alcohol tax duty-free button 40 described later.

[0054] Furthermore, the duty-free confirmation pop-up D1 is provided with a mandatory duty-free button 38 corresponding to general goods, a mandatory duty-free button 39 corresponding to consumables, and an alcohol tax duty-free button 40 corresponding to alcohol. The mandatory duty-free button 38 is a button for instructing duty-free processing for general goods regardless of whether the total amount reaches the duty-free standard amount. The mandatory duty-free button 39 is a button for instructing duty-free processing for consumables regardless of whether the total amount reaches the duty-free standard amount.

[0055] The forced tax exemption buttons 38 and 39 are buttons for calculating, for example, the tax exemption amount for the currently targeted item for purchase. The liquor tax exemption button 40 is a button for instructing the application of liquor tax exemption corresponding to the new liquor tax exemption system and for instructing the execution of liquor tax exemption processing. The detailed processing when the liquor tax exemption button 40 is operated will be described later.

[0056] In addition, the tax exemption confirmation pop-up D1 is provided with an OK button 41 and a cancel button 42. The OK button 41 is a button for instructing the confirmation of tax exemption at the tax exemption amount displayed in the tax exemption amount display area 36 and the liquor tax exemption amount display area 37. The cancel button 42 is a button for instructing the cancellation of the application of tax exemption.

[0057] When the total amount of general goods displayed in the general goods total amount display area 31 has not reached the tax exemption standard amount, if the processor 11a detects an input operation on the forced tax exemption button 38 (Act12, Yes), the processor 11a executes tax exemption calculation processing for the currently targeted general goods (Act13). The processor 11a causes the tax exemption amount calculated by the tax exemption calculation processing to be displayed in the tax exemption amount display area 36. Note that when the tax exemption amount corresponding to the consumables has been previously displayed in the tax exemption amount display area 36, the processor 11a displays the total amount obtained by adding the tax exemption amount corresponding to the consumables.

[0058] Similarly, when the total amount of consumables displayed in the consumables total amount display area 33 has not reached the tax exemption standard amount and the processor 11a detects an input operation on the forced tax exemption button 39 (Act12, Yes), the processor 11a calculates the tax exemption amount for the currently targeted consumables and causes it to be displayed in the tax exemption amount display area 36. Similarly, when the tax exemption amount corresponding to the general goods has been previously displayed in the tax exemption amount display area 36, the processor 11a displays the total amount obtained by adding the tax exemption amount corresponding to the general goods.

[0059] Next, when the processor 11a detects an input operation on the liquor tax exemption button 40 (Act14, Yes), it determines whether unregistered liquor is stored in the RAM 11c. If unregistered liquor is stored in the currently purchased item (Act15, Yes), the processor 11a executes a liquor tax calculation process (second processing method) for calculating the liquor tax exemption amount for the unregistered liquor (Act16).

[0060] FIG. 5 is a flowchart showing an example of the liquor tax calculation process in the present embodiment. When starting the liquor tax calculation process, the processor 11a causes the touch panel 11h to display a screen for calculating the liquor tax exemption amount (Act31).

[0061] 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 the liquor tax exemption pop-up D2 (liquor tax exemption pop-up 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, the volume of the liquor, and the quantity of the liquor of the unregistered liquor input by the employee's input operation. In the liquor tax calculation process, a plurality of liquors (items) to be purchased are volume-aggregated for each liquor category (liquor tax code), the liquor tax amount for each liquor tax code is calculated, and the liquor tax exemption amount (total liquor tax amount) is calculated by aggregating the liquor tax amounts for each liquor tax code.

[0062] The liquor tax exemption pop-up D2 is provided with, for example, liquor category-specific display areas 51-1, 51-2, 51-3, 51-4, 51-5, 51-6 corresponding to each of a plurality of liquor categories. Note that only the liquor category-specific display areas 51-1 to 51-6 corresponding to six of the twelve liquor categories are displayed on one screen of the liquor tax exemption pop-up D2. In response to an operation on the up button 56A or the down button 56B, the liquor category-specific display areas corresponding to the remaining six liquor categories are displayed.

[0063] In the alcohol category display areas 51-1 to 51-6, there are provided a liquor category name display area 52, a tax rate display area 53, a volume display area 54, and a liquor tax amount display area 55, respectively.

[0064] In the liquor category name display area 52, the name of the liquor category is displayed. The liquor categories include sparkling liquors, sparkling wines (malt ratio less than 25% to 50%), sparkling wines (malt ratio less than 25%), other sparkling liquors, brewed liquors, sake, fruit wines, distilled liquors such as whisky, brandy, spirits, blended liquors, synthetic sake, sweet fruit wines and liqueurs.

[0065] In the tax rate display area 53, the tax rate (tax amount per 1 kl) for each liquor category recorded in the liquor tax data 22 is displayed. In the volume display area 54, the total volume of the liquors of the same liquor 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 volume combination displayed in the volume display area 54 is displayed.

[0066] Also, in the liquor tax exemption pop-up D2, there are provided a total volume display area 57, a liquor number display area 58, and a total liquor tax amount display area 59. In the total volume display area 57, the total volume (total volume) of the volumes displayed in the volume display area 54 corresponding to all liquor categories is displayed. In the liquor number display area 58, the number of liquors (products) subject to liquor tax exemption is displayed. In the total liquor tax amount display area 59, the total of the liquor tax amounts displayed in the liquor tax amount display area 55 corresponding to all liquor categories (total liquor tax amount) is displayed.

[0067] Furthermore, the liquor tax exemption pop-up D2 is provided with a numerical input area 60 for receiving an input operation, a subtraction button 61, an OK button 62, and a cancel button 63. Also, at the bottommost position of the liquor tax exemption pop-up D2, a message display area 64 for displaying a message for guiding the input operation is provided. The numerical input area 60 includes digit buttons from "00", "0" to "9", a clear button for instructing the clearing of the input by operating the digit buttons, and an enter button for instructing the confirmation of the input by operating the digit buttons. The subtraction button 61 is a button for instructing the subtraction of the input volume and quantity.

[0068] 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 pop-up D2, and displays the tax amount in the tax rate display area 53 according to each liquor category. The plurality of liquor category name display areas 52 corresponding to each liquor category can be arbitrarily specified by a touch operation. The processor 11a displays a message such as "Please select a liquor category" in the message display area 64.

[0069] The employee refers to the unregistered liquors listed on the touch panel 11h, for example, and confirms the liquor category corresponding to the unregistered liquor. Then, the employee performs a touch operation on any of the liquor category name display areas 52 corresponding to the applicable liquor category. The processor 11a selects the liquor (liquor category) to be subject to liquor tax calculation according to the touch operation on the liquor category name display area 52. Next, the processor 11a displays a message such as "Please enter the volume" in the message display area 64.

[0070] Employees can input a numerical value indicating the volume of one portion of unregistered liquor (product) by operating the numeric buttons in the numeric input area 60, and can indicate the confirmation of the input by operating the enter button. The processor 11a detects the input operations of the numeric buttons and the enter key in the numeric input area 60, and inputs a numerical value indicating the volume corresponding to the input operation (Act34). Further, the processor 11a causes a message such as "Please input the quantity" to be displayed in the message display area 64.

[0071] Next, employees can input the quantity of unregistered liquor in the same manner as described above by operating on the numeric input area 60. For example, if the unregistered liquor is of the sparkling type (beer) and is to be purchased in case units of, for example, 6 bottles, after the volume of one portion is input, the quantity "6 pieces" is input. The processor 11a inputs a numerical value indicating the quantity of unregistered liquor according to the input operation on the numeric input area 60 (Act35).

[0072] When a numerical value indicating the quantity is input following the volume, the processor 11a calculates the volume of the liquor by volume × quantity, and causes the volume display area 54 of the liquor tax exemption pop-up D2 to display the volume corresponding to the input volume and numerical value. If the volume that has been input previously is being displayed, it is added to and then displayed with the previously input volume.

[0073] Further, the processor 11a calculates the liquor tax amount for the liquor category subject to liquor tax calculation according to the tax rate of the liquor category subject to liquor tax calculation, the volume, and the numerical value (Act36). The processor 11a causes the calculated liquor tax amount to be displayed in the liquor tax amount display area 55. If the liquor tax amount that has been input previously is being displayed, it is added to and then displayed with the previously calculated liquor tax amount.

[0074] Further, the processor 11a obtains the total liquor tax amount by adding up the liquor tax amounts for other liquor categories, and causes the total liquor tax amount to be displayed in the total liquor tax amount display area 59 (Act37). Also, the processor 11a updates the total volume displayed in the total volume display area 57 according to the input volume, and updates the number of liquors displayed in the liquor number display area 58 according to the input quantity.

[0075] If there are unregistered liquors other than those already entered (Act38, No), the processor 11a calculates the liquor tax amount for each liquor category according to the selection of the liquor category, the input volume, and the input quantity in the same manner as described above, and obtains the total liquor tax amount (Act31~37).

[0076] Therefore, in the liquor tax exemption pop-up D2, for unregistered liquors, the total volume is calculated for each liquor category, and based on different tax rates (tax amount per 1 kl) for each liquor category, the liquor tax amount for each liquor category (liquor tax code) is calculated, and the liquor tax amounts for each liquor category are added up to calculate the liquor tax exemption amount (total liquor tax amount).

[0077] When canceling the already entered volume and quantity, the subtraction button 61 is used. When the processor 11a detects that the subtraction button 61 has been operated, in the same manner as described above, it selects the liquor category, inputs the volume and quantity, subtracts the already entered volume and value for the corresponding liquor category, and subtracts the liquor tax amount and the total liquor tax amount for the liquor category.

[0078] Also, for liquors manufactured at other distilleries, etc. that are not eligible for liquor tax exemption under the new liquor tax exemption system, even if they are registered as unregistered liquors, they can be excluded from liquor tax exemption if liquor tax calculation is not performed through the liquor tax exemption pop-up D2.

[0079] When the processor 11a is instructed to confirm the liquor tax calculation by an operation on the confirmation button 62 (Act38, Yes), it records the data and calculation results input through the liquor tax exemption pop-up D2 in the storage unit 11d, and deletes the liquor tax exemption pop-up D2 from the touch panel 11h (Act39).

[0080] Further, the processor 11a adds the total liquor tax amount to the tax-free amount displayed in the tax-free amount display area 36 of the tax-free confirmation pop-up D1 and causes it to be displayed, and causes the total liquor tax amount to be displayed in the liquor tax-free amount display area 37 (Act40), and ends the liquor tax calculation process.

[0081] Next, when it is determined that unregistered liquor is not stored in the currently targeted product for purchase (Act15, No), and after the liquor tax calculation process has been executed, the processor 11a executes a liquor tax confirmation process for calculating the liquor tax based on each data of the non-tax-free target flag, liquor tax code, and volume registered in the product master data 21 (Act17).

[0082] FIG. 6 is a flowchart showing an example of the liquor tax confirmation process in the present embodiment. When starting the liquor tax confirmation process, the processor 11a obtains, for each liquor (product) whose product classification is liquor and whose non-tax-free target flag is not "1" indicating not subject to liquor tax exemption among the products registered in the registered product table by the product registration process, each data of the liquor tax code and volume set in the product master data 21 and the quantity (number) registered in the registered product table (Act51).

[0083] In the product master data 21, since the non-tax-free target flag is set, even for the same liquor sold at a sales store within the manufacturing plant, liquors manufactured at other manufacturing plants etc. can be processed as not subject to liquor tax exemption under the new liquor tax exemption system.

[0084] When there are multiple liquors (products) of the same liquor category (liquor tax code) in the registered product table, the processor 11a calculates the total volume for each liquor category based on the volume and quantity of one liquor (product) in the same way as the liquor tax calculation process, and calculates the liquor tax amount for each liquor category based on the total volume and the liquor tax corresponding to the liquor tax code.

[0085] Further, when the liquor tax calculation process has been executed previously, the processor 11a reads out the calculation results for the unregistered liquors calculated in the liquor tax calculation process from the storage unit 11d, and adds them to the calculation results calculated based on the above-described product master data 21 and the registered product table (Act52).

[0086] Thereby, it is possible to obtain the total liquor tax amount due to liquor tax exemption corresponding to the new liquor tax exemption system, including the liquors registered in the product master data 21 and the unregistered liquors (unregistered liquors).

[0087] The processor 11a causes the total liquor tax amount obtained by adding up the liquor tax amounts for each liquor category to be displayed by adding the total liquor tax amount 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 liquor tax amount in the liquor tax exemption amount display area 37 (Act53).

[0088] Next, the processor 11a causes a screen for confirming the liquor tax amount and the liquor tax exemption amount (total amount) for each liquor category to be displayed on the touch panel 11h (Act54). Hereinafter, the screen for confirming the liquor tax exemption amount will be described as the liquor tax exemption pop-up D3 (liquor tax exemption pop-up 2).

[0089] 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.

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

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

[0092] In the liquor category name display area 62, the name of the liquor category is displayed. In the tax rate display area 63, the tax rate for each liquor category is displayed. In the volume display area 64, the total volume for each 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 volume combination obtained by the above-described calculation is displayed.

[0093] Also, in the liquor tax exemption pop-up D3, a total volume display area 67, a liquor item number display area 68, and a total liquor tax amount display area 69 are provided. In the total volume display area 67, the total (total volume) of the volumes displayed in the volume display areas 64 corresponding to all liquor categories is displayed. In the liquor item number display area 68, the number of liquors (products) subject to liquor tax exemption is displayed. In the total liquor tax amount display area 69, the total (total liquor tax amount) of the liquor tax amounts displayed in the liquor tax amount display areas 65 corresponding to all liquor categories is displayed.

[0094] Also, in the liquor tax exemption pop-up D3, a confirmation button 62 is provided. When the processor 11a is instructed to complete liquor tax confirmation by an operation on the confirmation button 62 (Act55, Yes), the liquor tax exemption pop-up D3 is deleted from the touch panel 11h (Act56), and the liquor tax confirmation process is terminated.

[0095] Based on the tax exemption confirmation popup D1 that reflects the liquor tax confirmation process and the result of the liquor tax calculation process when there is unregistered liquor, the employee can confirm the tax exemption amount and the liquor tax exemption amount. Here, again, by operating the forced tax exemption buttons 38, 39 or by operating the liquor tax exemption button 40 (Act18, No), the same processing as described above can be executed (Act12 - 17). When the confirmation is completed in the tax exemption confirmation popup D1, the employee can operate the confirmation button 41 to instruct the end of the tax exemption confirmation.

[0096] When the processor 11a detects an operation on the confirmation button 41 (Act18, Yes), it deletes the tax exemption confirmation popup D1 from the touch panel 11h (Act19) and returns to the execution state of the product registration process. Furthermore, if there is no product registration, the subtotal key is operated by the employee. When detecting that the subtotal key has been operated (Act6, Yes), the processor 11a determines whether tax exemption processing is being executed by operating the tax exemption key. If tax exemption processing is being executed (Act20, Yes), after the settlement process, the processor 11a inputs the passport information that needs to be printed on the export tax - exempt goods purchase record form and the export tax - exempt goods purchase affidavit. When a passport presented by a foreign traveler who intends to purchase goods is set on the passport reader 11p, the passport reader 11p reads the passport information (name, date of birth, type of travel document, nationality, etc.) recorded in the passport. The processor 11a stores the passport information read by the passport reader 11p in the RAM 11c. The processor 11a executes a settlement process that includes the tax exemption details confirmed in the tax exemption confirmation popup D1 (Act8).

[0097] When the settlement is completed, the processor 11a causes the printer 11k to print the transaction details on the receipt paper to issue a transaction receipt and a purchase details. When tax exemption processing has been performed, the processor 11a prints information regarding tax exemption on the transaction receipt and the purchase details. Furthermore, the processor 11a causes the export tax - exempt goods purchase record form and the export tax - exempt goods purchase affidavit for the transaction with tax exemption processing to be printed on the receipt paper to issue a receipt.

[0098] FIG. 10 is a diagram showing an example of a transaction receipt R1 and a purchase details R2 in the case of tax exemption processing in the present embodiment. As shown in FIG. 10, on the transaction receipt R1, in addition to information (name, unit price, subtotal, etc.) R10 regarding the purchased goods, information R11 to R18 related to tax exemption and the total amount R19 after tax exemption are printed. The information R11 to R18 related to tax exemption includes the total amount R12 of tax-exempt general goods, the total amount R13 of tax-exempt consumables, the total amount (ex-tax amount) R14 of tax-exempt items (general goods and consumables), the tax exemption amount (total of foreign tax / domestic tax portions) R15, the tax target amount of the SI classification set as non-taxable R16, the liquor tax amount to be tax-exempted R17, and the rounding-off amount R18. In the transaction receipt R1 in the present embodiment, since the liquor tax amount R17 to be tax-exempted is printed, it is possible to confirm that the liquor tax is tax-exempt and the tax exemption amount of the liquor tax exemption.

[0099] As shown in FIG. 10, on the purchase details R2, information (name, amount, subtotal, etc.) R20 regarding the goods corresponding to the purchased general goods and the total general goods tax-exempt target R21, and information (name, amount, subtotal, etc.) R22 regarding the goods corresponding to the purchased consumables and the total consumables tax-exempt target R23 are printed. Further, on the purchase details R2, as information related to tax exemption, the total tax-exempt target R24, the tax exemption amount R25, and the liquor tax exemption amount R26 are printed. Also, on the purchase details R2, information (salesperson, responsible person, transaction No., purchase count) R27 related to the store is printed. In the purchase details R2 in the present embodiment, not only can the total tax-exempt target for general goods and consumables be confirmed, but also the liquor tax exemption amount R26 can be individually confirmed.

[0100] FIG. 11 is a diagram showing an example of an export tax-exempt goods purchase record form R3 printed in the case of tax exemption processing in the present embodiment. As shown in Fig. 11, in the export duty-free goods purchase record form R3, in addition to the date and time information, passport information R30, purchase details R31 (the same as the purchase details R2), and a cautionary note R33 in Japanese and the language corresponding to the nationality included in the passport information are printed. The purchase details R31 include the liquor tax exemption amount R32. In addition, in the export duty-free goods purchase record form R3, an additional note R34 on the liquor tax rate application classification is printed. In the additional note R34 on the liquor tax rate application classification, for the liquor classification (liquor tax rate) in the liquor tax calculation corresponding to the goods subject to liquor tax exemption, the name R35 of the liquor classification (tax rate classification), the total volume, and the tax rate R36 are printed. If other goods with different liquor classifications (liquor tax rates) are purchased, for each of them, the name R37 of the liquor classification (tax rate classification), the total volume, and the tax rate R38 are printed.

[0101] In the export duty-free goods purchase record form R3, since the name R35, R37 of the liquor classification (tax rate classification), the total volume, and the tax rate R36, R38 for the liquor classification (tax rate classification) subject to liquor tax exemption are printed, it is possible to confirm which of the 12 types of liquor classifications is subject to liquor tax exemption, and the volume and tax rate for the exempted items.

[0102] Fig. 12 is a diagram showing an example of the export duty-free goods purchase affidavit R4 printed when the duty-free process in this embodiment is performed. As shown in Fig. 12, in the export duty-free goods purchase affidavit R4, in addition to the date and time information, passport information R40 (including the signature area R41), and purchase details R42 (the same as the purchase details R2) are printed. The purchase details R42 include the liquor tax exemption amount R43. In addition, in the export duty-free goods purchase affidavit R4, an additional note R45 on the liquor tax rate application classification is printed in the same way as in the export duty-free goods purchase record form R3.

[0103] In the export duty-free goods purchase affidavit R4, in the same way as in the export duty-free goods purchase record form R3, it is possible to confirm which of the 12 types of liquor classifications is subject to liquor tax exemption, and the volume and tax rate for the exempted items.

[0104] According to the embodiment described above, in the POS terminal 10 (commodity sales data processing device) in this embodiment, it is possible to perform sales data processing for tax exemption on alcoholic beverages corresponding to the new liquor tax exemption system. As a result, in a store that exempts liquor tax, appropriate sales data processing can be performed according to multiple types of alcoholic beverages with different manufacturers and different liquor tax amounts included in multiple commodities that foreign tourists visiting Japan intend to purchase, and the burden on employees can also be significantly reduced.

[0105] In addition, in this embodiment, although the sales data processing corresponding to the new liquor tax exemption system is described as an example, it can be applied to a commodity sales data processing device that requires sales data processing related to tax exemption when multiple types of commodities with different tax rates are mixed, such as the alcoholic beverages described above.

[0106] Although several 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 gist 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 its equivalent scope.

[0107] Also, the processing described in the above-described embodiment can be provided to various devices by writing it as a program that can be executed by a computer on a recording medium such as a magnetic disk (flexible disk, hard disk, etc.), an optical disk (CD-ROM, DVD, etc.), or a semiconductor memory. It can also be transmitted through a communication medium and provided to various devices. The computer reads the program recorded on the recording medium or receives the program via the communication medium, and executes the above-described processing by being controlled by this program.

Explanation of Reference Numerals

[0108] 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

1. A product data processing device for conducting duty-free transactions on liquor tax, comprising: registration means for registering products; first display means for causing a display unit to display a screen including a display area for displaying the volume of liquor when there is liquor subject to duty-free liquor tax among the liquors included in the registered product; calculation means for calculating the duty-free liquor tax amount from the volume of liquor input to the display area and the tax rate corresponding to the liquor; second display means for causing the display unit to display the duty-free liquor tax amount; A product data processing device having the above.

2. The first display means causes a screen including the display area corresponding to each of a plurality of liquor categories to be displayed, The calculation means calculates the duty-free liquor tax amount for each liquor category. The product data processing device according to Claim 1.

3. The second display means displays the total of the duty-free liquor tax amounts for each liquor category. The product data processing device according to Claim 2.

4. The product data processing device according to Claim 2 or Claim 3, further comprising third display means for causing the display unit to display the number of liquors subject to calculation of the duty-free liquor tax amount.

5. A program for causing a computer installed in a product data processing device for conducting duty-free transactions on liquor tax to function as registration means for registering products; first display means for causing a display unit to display a screen including a display area for displaying the volume of liquor when there is liquor subject to duty-free liquor tax among the liquors included in the registered product; calculation means for calculating the duty-free liquor tax amount from the volume of liquor input to the display area and the tax rate corresponding to the liquor; second display means for causing the display unit to display the duty-free liquor tax amount.

Images