Commodity sales data processor 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] An embodiment of the present invention relates to a product sales data processing device and a program. [Background technology]

[0002] There is a so-called tax exemption system in place that exempts businesses that operate export goods sales outlets (duty-free shops) from paying consumption tax on goods when they sell them to non-residents such as foreign tourists. Furthermore, from October 1, 2017, a system is scheduled to be implemented that will exempt alcoholic beverages sold to foreign tourists visiting Japan from liquor tax in addition to consumption tax.

[0003] The new liquor tax exemption system applies to retailers within liquor manufacturing facilities such as sake breweries. Even if liquor is sold at retailers within a manufacturing facility, the liquor tax exemption only applies to the company's own products. Furthermore, there are several types of liquor, including sparkling liquor, brewed liquor, distilled liquor, and mixed liquor, and each type has a different tax rate (amount of liquor tax).

[0004] Therefore, retailers offering liquor tax exemptions must process sales data appropriately to accommodate the multiple alcoholic beverages from different manufacturers and with different liquor tax rates that are included in the multiple products that foreign tourists visiting Japan are attempting to purchase. [Prior art documents] [Patent documents]

[0005] [Patent Document 1] Japanese Patent Application Laid-Open No. 2016-057781 Summary of the Invention [Problem to be solved by the invention]

[0006] 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 multiple types of products with different tax rates are mixed together. [Means for solving the problem]

[0007] According to an embodiment, a product sales data processing device for conducting liquor tax-exempt transactions has a registration means, a first display means, a calculation means, and a second display means. The registration means registers products. The first display means displays a screen on the display unit including a display area for displaying the volume of liquor when any of the liquor contained in the registered product is exempt from liquor tax. The calculation means calculates the liquor tax-exempt amount from the volume of liquor entered in the display area and the tax rate corresponding to the liquor. The second display means displays the liquor tax-exempt amount on the display unit. [Brief explanation of the drawings]

[0008] [Figure 1] 1 is a block diagram showing the system configuration of a checkout system provided with a product sales data processing device according to an embodiment of the present invention. [Figure 2] 3A and 3B are diagrams showing an example of product master data stored in a server and a POS terminal according to the embodiment. [Figure 3] FIG. 4 is a diagram showing an example of liquor tax data stored in a server in this embodiment. [Figure 4] 6 is a flowchart showing an example of the operation of the POS terminal in the present embodiment. [Figure 5] 10 is a flowchart showing an example of a liquor tax calculation process in this embodiment. [Figure 6] 10 is a flowchart showing an example of a liquor tax confirmation process in this embodiment. [Figure 7] FIG. 10 is a diagram showing an example of a confirmation screen for a tax exemption amount according to the embodiment. [Figure 8] FIG. 10 is a diagram showing an example of a screen for calculating the liquor tax exemption amount in this embodiment. [Figure 9] FIG. 10 is a diagram showing an example of a screen for confirming the liquor tax exemption amount in this embodiment. [Figure 10] 10A and 10B are diagrams showing an example of a transaction receipt and purchase details when tax exemption processing is performed in this embodiment. [Figure 11]FIG. 10 is a diagram showing an example of a tax-free export goods purchase record slip printed when tax-free processing is performed in this embodiment. [Figure 12] FIG. 10 is a diagram showing an example of a pledge to purchase duty-free export goods that is printed when the tax-free processing is performed according to the present embodiment. DETAILED DESCRIPTION OF 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 includes a plurality of POS terminals 10 (10-1, 10-2, ..., 10-n) and a server 12 (server 12), which are connected to each other via a network such as a LAN (Local Area Network) 14 so that they can communicate with each other. The product sales data processing device of this embodiment will be described as being implemented 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 that can execute product data processing corresponding to liquor tax exemption. Note that tax exemption on product sales applies not only to liquor tax but also to other taxes such as consumption tax, but the following embodiment will mainly focus on liquor tax exemption.

[0012] The product sales data processing device may be configured with one POS terminal 10 and server 12, or may be configured with a plurality of POS terminals 10 and servers 12.

[0013] The POS terminal 10 is equipped with computer functions and includes a processor (CPU (central processing unit), etc.) 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 to realize various operations of the POS terminal 10 based on an operating system, middleware, and application programs stored in the ROM 11b and RAM 11c.

[0015] The ROM 11b and RAM 11c store various programs executed by the processor 11a as well as data referenced by the processor 11a when it performs various processes. For example, when a process for registering product information is executed, the RAM 11c stores a registered product table in which information about products to be purchased by customers is registered. The RAM 11c also stores data for screens to be displayed on the touch panel 11h and the display 11n.

[0016] The programs executed by the processor 11a include a control program for executing a scanning process that inputs product information (such as product codes) using the scanner 11g, a product registration process that generates transaction information used in payment processing according to product information registered in the registered product table, and payment processing based on the transaction information. The program also includes a program for executing tax exemption processing for products registered by the product registration process. The tax exemption processing includes not only consumption tax but also liquor tax exemption processing in accordance with a system that exempts retailers from liquor tax within liquor manufacturing plants (hereinafter referred to as the "new liquor tax exemption system"). By executing the control program, the processor 11a displays a screen for product sales processing (including registration processing and payment processing) on ​​the touch panel 11h.

[0017] The storage unit 11d stores data used by the processor 11a when it performs 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 processes and the like, and liquor tax data 22 (described later) referenced in liquor tax processes, which are received from the server 12. For example, a hard disk drive (HDD) or a solid state drive (SSD) can be used as the storage unit 11d.

[0018] The change dispenser 11e receives coins and bills that are inserted and dispenses coins and bills that are used 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 a photographed image of the product. The scanner 11g may be of one type or multiple types.

[0020] The touch panel 11h is a device on which an employee (cashier) performs input operations 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, price, etc.) related to products registered for purchase and a subtotal, a menu including multiple keys corresponding to various functions, and an operation screen including keys for inputting commands to execute various functions. The display device may be a well-known device, such as a color LCD (Liquid Crystal Display). The touch sensor is placed over the display surface of the display device. The touch sensor detects the position of the operator's touch on the display surface of the display device and sends the position information to the processor 11a. The touch sensor may be a well-known device.

[0021] The keyboard 11j is a device on which an employee (cashier) performs input operations, and has, for example, an arrangement of multiple keys, each of which is assigned a specific function.

[0022] The printer 11k is, for example, a thermal printer or a dot matrix printer, and issues transaction receipts and the like on which transaction details such as product name, unit price, total amount, and information related to tax exemption including liquor tax are printed by printing various character strings, images, code patterns (barcodes, 2D codes, etc.) on receipt paper.

[0023] The card reader / writer 11m reads data recorded on a card and writes data to the card. Cards include payment cards such as credit cards, debit cards, electronic money cards, and prepaid cards, as well as various cards that record information related to payment processing, such as membership cards and point cards. The card reader / writer 11m may be a magnetic, contact, or non-contact device, or may include multiple types of devices.

[0024] The display 11n is a device used to provide information to customers, for example, and may be a well-known device such as a color LCD.

[0025] The passport reader 11p is a reading device for reading information recorded on a passport to confirm that the person is eligible for tax exemption when tax exemption processing is performed for a foreign tourist visiting Japan. The passport reader 11p reads character information optically 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 unit to realize various operations of the server 12 based on an operating system, middleware, and application programs stored in the ROM 21b and RAM 21c.

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

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

[0030] The storage unit 21d stores data used by the processor 21a when it performs various processes or data generated by the processes performed by the processor 21a. For example, an HDD or an SSD can be used as the storage unit 21d. The storage unit 21d stores product master data 21, liquor tax data 22, sales management data (sales data (including product name, price, time of sale, number of sales, etc.), inventory data, etc.) used in the process for selling products at the POS terminal 10, etc.

[0031] The communication unit 21f controls communication with the POS terminal 10 and the like via the LAN 14. The keyboard 21g is used by an employee to input data to the server 12. The server 12 may be provided with an input device other than the keyboard 21g (such as a touch panel or a mouse). The display 21h displays a screen according to the POS function executed by the processor 21a. The communication unit 21p controls communication with external devices such as servers (websites, etc.) 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 this embodiment. As shown in FIG. 2, the product master data 21 stores product classification, product name, price, tax-free type, and the like, in association with a product code unique to the product. Product classification is information for classifying products, and is divided into, for example, major, medium, and minor categories. Product classification includes data indicating the classification of alcoholic beverages. Price may be the price excluding consumption tax, the price including consumption tax, or the price excluding liquor tax. Tax-free type indicates whether the item (product) eligible for tax exemption is a general item or a consumable. Consumable items include alcoholic beverages. Furthermore, for alcoholic beverages included in general items, the product master data 21 stores data on the tax-exempt flag (exemption data), liquor tax code, and volume for liquor tax exemption processing in accordance with the new liquor tax exemption system.

[0033] The tax exemption flag is data indicating that even alcoholic beverages that are eligible for liquor tax exemption are not subject to liquor tax exemption (for example, setting the tax exemption flag to "1" indicates that they are not eligible for liquor tax exemption). In other words, the new liquor tax exemption system applies to retailers within liquor manufacturing facilities such as sake breweries, and liquor tax exemption applies only to the company's own products. For this reason, even if the same type of alcoholic beverage is sold at a retailer within a manufacturing facility, alcoholic beverages manufactured at other manufacturing facilities must be exempt from liquor tax exemption. For this reason, the tax exemption flag is set to "1" for alcoholic beverages that are not eligible for liquor tax exemption (liquor tax calculation). The liquor tax code is set to reference the tax rate, etc., corresponding to the type of alcoholic beverage from the liquor tax data 22. The volume is referenced to calculate the liquor tax amount for each type of alcoholic beverage of the same type.

[0034] In the POS terminal 10 of this embodiment, a first processing method and a second processing method are used for the liquor tax exemption processing in accordance with the new liquor tax exemption system. The first processing method is a method in which the data of the tax exemption flag, liquor tax code, and volume for liquor (product) that is subject to liquor tax exemption is registered in advance in the product master data 21. The second processing method is a method in which the data necessary for the liquor tax exemption processing in accordance with the new liquor tax exemption system is input by an employee's operation, without registering the data of the tax exemption flag, liquor tax code, and volume in advance in the product master data 21. Liquor for which the data of the tax exemption flag, liquor tax code, and volume are not registered in advance in the product master data 21 will be described as unregistered liquor.

[0035] In the first processing method, when selling alcoholic beverages to foreign tourists visiting Japan, accounting procedures that comply with the new liquor tax exemption system can be performed without increasing the workload of employees who operate the POS terminal 10. In the second processing method, even if a retailer within a liquor manufacturing facility such as a sake brewery is unable to maintain the product master data 21 due to a large variation in the types of alcoholic beverages they handle or a large variety of alcoholic beverages, accounting procedures that comply with the new liquor tax exemption system can be performed on an individual basis when selling alcoholic beverages to foreign tourists visiting Japan.

[0036] FIG. 3 is a diagram showing an example of the liquor tax data 22 stored in the server 12 in this embodiment. The liquor tax data 22 indicates liquor information used in liquor tax exemption processing, and each type of liquor is associated with a unique liquor tax code, and data indicating the liquor tax amount (tax rate), the name to be used when displayed on the screen (screen), and the name to be used when printed on a receipt (printed) are associated with each other. For example, a different liquor tax amount (tax rate) (tax amount per 1 kL) is set for each of 12 types of liquor categories. For example, for the liquor category "happoshu (malt ratio 25 to less than 50%)," the tax rate is set to "178,125 yen per 1 kL," and for "refined sake," the tax rate is set to "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 commodity code (commodity) set in the commodity master data 21.

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

[0039] First, product registration of a product that a customer intends to purchase is performed at the POS terminal 10. When the barcode attached to the product is scanned by the scanner 11g (Act 1), the processor 11a executes product registration processing based on the product code indicated by the barcode (Act 2).

[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 for the product code (product name, product classification, tax-free type, price, etc.), and records it in the registered product table.

[0041] If multiple units of the same product 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 product information corresponding to the number (quantity) indicated by the numerical data in the registered product table.

[0042] The processor 11a displays purchase information (for example, product name, tax-free type, price, quantity (amount), etc.) from the product information on, for example, a touch panel 11h for staff and a display 11n for customers.

[0043] The processor 11a also determines whether the product corresponding to the product code is an unregistered alcoholic beverage. That is, the processor 11a determines that the product is an unregistered alcoholic beverage if the product classification corresponding to the product code is an alcoholic beverage and at least the liquor tax code among the tax exemption flag, liquor tax code, and volume is not registered. Note that if the tax exemption flag is set to "1," the alcoholic beverage is not subject to liquor tax exemption under the new liquor tax exemption system, and therefore the product is not determined to be an unregistered alcoholic beverage.

[0044] If the product (alcoholic beverage) whose product code has been read is determined to be an unregistered alcoholic beverage (Act 3, Yes), the processor 11a stores the product (alcoholic beverage) in RAM 11c as an unregistered alcoholic beverage and displays the product name and the fact that it is an unregistered alcoholic beverage on the touch panel 11h. In other words, by displaying the fact that the product is an unregistered alcoholic beverage to the employee, the employee is notified that the alcoholic beverage requires the entry of data necessary for liquor tax exemption processing (second processing method) under the new liquor tax exemption system. Note that the fact that the alcoholic beverage is an unregistered alcoholic beverage may be notified not only by displaying the information on the touch panel 11h but also by a predetermined sound.

[0045] Similarly, if there are other products to be purchased, the barcodes attached to the products are scanned one by one and the product registration process is executed. If there is a product determined to be an unregistered alcoholic beverage, the corresponding product name is displayed on the touch panel 11h. If there are multiple unregistered alcoholic beverages, the processor 11a may display a list of the multiple unregistered alcoholic beverages on the touch panel 11h.

[0046] Here, when it is detected that the subtotal key has been operated (Act 6, Yes), if the tax exemption process has not been executed by operating the tax exemption key (Act 20, No), the processor 11a executes a settlement process without tax exemption (Act 8). 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 (credit card, etc.) for the transaction information. When the settlement is completed, the processor 11a causes the printer 11k to print the transaction details on receipt paper and issue a transaction receipt and purchase details.

[0047] On the other hand, if 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 (Act 5, Yes), it executes a tax exemption confirmation calculation to display the amount, etc., to be 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 (Act 10). Based on the calculation result of the tax exemption confirmation calculation, the processor 11a displays the tax exemption amount confirmation screen on the touch panel 11h (Act 11).

[0048] 7 is a diagram showing an example of a confirmation screen for the tax exemption amount in this embodiment. Hereinafter, the confirmation screen for the tax exemption amount will be described as a tax exemption confirmation pop-up D1.

[0049] The tax exemption confirmation pop-up D1 is provided with, for example, a general goods total amount display area 31, a general goods shortage amount display area 32, a consumable goods total amount display area 33, a consumable goods shortage amount display area 34, a liquor tax shortage amount display area 35, a tax exemption amount display area 36, ​​and a liquor tax exemption amount display area 37. The general goods total amount display area 31 displays the total amount of general goods. The general goods shortage amount display area 32 displays the amount remaining until tax exemption is achieved for general goods. The consumable goods total amount display area 33 displays the total amount of consumable goods. The consumable goods shortage amount display area 34 displays the amount remaining until tax exemption is achieved for consumable goods. The liquor shortage amount display area 35 displays the prices of liquor that will cover the shortfall until tax exemption is achieved for consumable goods. The tax exemption amount display area 36 displays the sum of the tax exemption amounts for general goods and consumable goods (total tax exemption amount). The liquor tax exemption amount display area 37 displays the liquor tax exemption amount under the new liquor tax exemption system for the liquor included in the consumable goods.

[0050] General goods and consumables are generally eligible for tax exemption if the total amount after tax exemption is equal to or exceeds the tax exemption threshold (5,000 yen). Therefore, if the total amount after tax exemption does not reach the tax exemption threshold, the shortfall amount is displayed in the general goods shortage display area 32 and the consumable goods shortage display area 34, respectively, and the employee can notify the customer of the amount needed to reach the tax exemption threshold. This allows the employee to encourage the customer to purchase more products. Furthermore, the customer can follow the employee's advice and purchase products up to the tax exemption threshold, thereby enjoying the benefits of tax exemption.

[0051] Furthermore, the tax-free confirmation pop-up D1 displays the amount of alcohol shortage display area 35 that is required to purchase alcohol to make up the shortfall up to the tax-free threshold. For alcohol, the liquor tax is included in the product price. Therefore, even if the total amount of consumables reaches the tax-free threshold by purchasing additional items based on the price of alcohol, it may not reach the tax-free threshold once the liquor tax is exempted. For this reason, by displaying the shortfall up to the tax-free threshold (tax-free threshold) when purchasing alcohol in the liquor shortage display area 35, employees can reliably inform customers of the amount of alcohol required to make up the tax-free threshold.

[0052] The amounts displayed in the general goods shortage display area 32, consumables shortage display area 34, and alcohol shortage display area 35 do not need to be the exact amount up to the tax-free standard amount, but may be amounts up to the tax-free standard amount, for example, amounts less than 10 yen may be rounded up to the nearest 10 yen.

[0053] The tax-free amount display area 36 displays the tax-free amount calculated when at least one of the general goods and consumables reaches the tax-free standard amount. The liquor tax-free amount display area 37 displays the liquor tax-free amount calculated by the liquor tax-free processing when application of the liquor tax-free system corresponding to the new liquor tax-free system is instructed by operating the liquor tax-free button 40 described later.

[0054] Furthermore, the tax exemption confirmation pop-up D1 is provided with a compulsory tax exemption button 38 corresponding to general goods, a compulsory tax exemption button 39 corresponding to consumable goods, and a liquor tax exemption button 40 corresponding to alcoholic beverages. The compulsory tax exemption button 38 is a button for instructing that tax exemption processing be performed for general goods regardless of whether the total amount reaches the tax exemption threshold amount. The compulsory tax exemption button 39 is a button for instructing that tax exemption processing be performed for consumable goods regardless of whether the total amount reaches the tax exemption threshold amount.

[0055] The forced tax exemption button 38 and the forced tax exemption button 39 are buttons for calculating the tax exemption amount for the product currently being purchased, for example. 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. Detailed processing when the liquor tax exemption button 40 is operated will be described later.

[0056] The tax exemption confirmation pop-up D1 also has a confirm button 41 and a cancel button 42. The confirm button 41 is a button for instructing to confirm 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 to cancel the application of tax exemption.

[0057] When the total amount of the general goods displayed in the general goods total amount display area 31 does not reach the tax exemption threshold amount, upon detecting an input operation on the forced tax exemption button 38 (Act 12, Yes), the processor 11a executes tax exemption calculation processing for the general goods currently being purchased (Act 13). The processor 11a displays the tax exemption amount calculated by the tax exemption calculation processing in the tax exemption amount display area 36. Note that, when the tax exemption amount corresponding to a consumable item has already been displayed in the tax exemption amount display area 36, ​​the processor 11a displays the total amount added to the tax exemption amount corresponding to this consumable item.

[0058] Similarly, when the processor 11a detects an input operation on the forced tax exemption button 39 (Act 12, Yes) if the total amount of the consumable products displayed in the consumable total amount display area 33 has not reached the tax exemption threshold amount, the processor 11a calculates the tax exemption amount for the consumable products currently being purchased and displays it in the tax exemption amount display area 36. Similarly, when the tax exemption amount corresponding to general goods has previously been displayed in the tax exemption amount display area 36, ​​the processor 11a displays the total amount added to 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 (Act 14, Yes), it determines whether an unregistered liquor is stored in the RAM 11c. If an unregistered liquor is stored in the product currently being purchased (Act 15, Yes), the processor 11a executes a liquor tax calculation process (second processing method) to calculate the liquor tax exemption amount for the unregistered liquor (Act 16).

[0060] FIG. 5 is a flowchart showing an example of the liquor tax calculation process in this embodiment. When the processor 11a starts the liquor tax calculation process, the processor 11a displays a screen for calculating the liquor tax exemption amount on the touch panel 11h (Act 31).

[0061] Fig. 8 is a diagram showing an example of a screen for calculating the liquor tax exemption amount in this 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). The liquor tax exemption pop-up D2 can calculate the liquor tax exemption amount according to the liquor category designation of the unregistered liquor, the volume of the liquor, and the quantity of the liquor entered by the employee's input operation. In the liquor tax calculation process, the volumes of multiple liquor categories (liquor tax codes) of the liquor (products) to be purchased are added together to calculate the liquor tax amount for each liquor tax code, and the liquor tax amounts for each liquor tax code are added together to calculate the liquor tax exemption amount (total liquor tax amount).

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

[0063] Each of the liquor category display areas 51-1 to 51-6 includes an 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.

[0064] The name of the alcoholic beverage category is displayed in the alcoholic beverage category name display area 52. The alcoholic beverage categories include sparkling alcoholic beverages, happoshu (malt ratio of 25 to less than 50%), happoshu (malt ratio of less than 25%), other sparkling alcoholic beverages, brewed alcoholic beverages, sake, fruit wine, distilled alcoholic beverages including whiskey, brandy, spirits, mixed alcoholic beverages, synthetic sake, sweet fruit wine, and liqueur.

[0065] 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. The volume display area 54 displays the total volume of the liquor of the same liquor category to be purchased. The liquor tax amount display area 55 displays the liquor tax amount corresponding to the liquor category, calculated based on the tax rate and the combined volume displayed in the volume display area 54.

[0066] The liquor tax exemption pop-up D2 also has a total volume display area 57, a number of liquor items display area 58, and a total liquor tax display area 59. The total volume display area 57 displays the total volume (total volume) displayed in the capacity display area 54 corresponding to all liquor categories. The number of liquor items display area 58 displays the number of liquor items (products) that are subject to liquor tax exemption. The total liquor tax display area 59 displays the total liquor tax amount (total liquor tax) displayed in the liquor tax amount display area 55 corresponding to all liquor categories.

[0067] Furthermore, the liquor tax exemption pop-up D2 is provided with a numeric value input area 60 for accepting input operations, a subtraction button 61, a confirm button 62, and a cancel button 63. At the bottom of the liquor tax exemption pop-up D2 is provided a message display area 64 for displaying messages to guide input operations. The numeric value input area 60 includes number buttons from "00" and "0" to "9," a clear button for instructing to clear input made by operating the number buttons, and an enter button for instructing to confirm input made by operating the number buttons. The subtraction button 61 is a button for instructing to subtract from the volume and quantity already entered.

[0068] First, the processor 11a acquires liquor information from the liquor tax data 22, displays the names of liquor categories in the liquor category name display area 52 of the liquor tax exemption pop-up D2, and displays the tax amount for each liquor category in the tax rate display area 53. The liquor category name display areas 52, each corresponding to a plurality of liquor categories, can be selected by touch operation. The processor 11a then displays a message in the message display area 64, such as "Please select a liquor category."

[0069] For example, the employee refers to the list of unregistered alcoholic beverages displayed on the touch panel 11h and confirms the alcoholic beverage category that corresponds to the unregistered alcoholic beverage. Then, the employee touches one of the alcoholic beverage category name display areas 52 that corresponds to the relevant alcoholic beverage category. In response to the touch operation on the alcoholic beverage category name display area 52, the processor 11a selects the alcoholic beverage (alcoholic beverage category) that is the subject of the liquor tax calculation. Next, the processor 11a displays a message in the message display area 64, such as "Please enter the volume."

[0070] The employee can input a value indicating the volume of one unregistered alcoholic beverage (product) by operating the number buttons in the value input area 60, and can confirm the input by operating the Enter button. The processor 11a detects the input operation of the number buttons and the Enter key in the value input area 60, and inputs a value indicating the volume according to the input operation (Act 34). The processor 11a also displays a message in the message display area 64, such as "Please enter the quantity."

[0071] Next, the employee can input the quantity of the unregistered alcoholic beverage by operating the numeric value input area 60 in the same manner as described above. For example, if the unregistered alcoholic beverage is a sparkling type (beer) and the employee is trying to purchase a case of six bottles, the volume of one bottle is input, and then the quantity "6 bottles" is input. Processor 11a inputs a numeric value indicating the quantity of the unregistered alcoholic beverage in response to the input operation in the numeric value input area 60 (Act 35).

[0072] When a numerical value indicating the quantity is entered after the volume, the processor 11a calculates the volume of the alcoholic beverage by multiplying the volume by the quantity, and displays the volume according to the entered volume and the numerical value in the volume display area 54 of the liquor tax exemption pop-up D2. If a volume that has already been entered is displayed, the new volume is added to the previously entered volume and displayed.

[0073] The processor 11a also calculates the amount of liquor tax for the liquor category subject to the liquor tax calculation, based on the tax rate, volume, and numerical value of the liquor category subject to the liquor tax calculation (Act 36). The processor 11a displays the calculated liquor tax amount in the liquor tax amount display area 55. If a previously input liquor tax amount is displayed, the calculated liquor tax amount is added to the previously calculated liquor tax amount and displayed.

[0074] The processor 11a also calculates the total amount of liquor tax by adding it to the liquor tax amounts for the other liquor categories, and displays the total amount of liquor tax in the liquor tax total amount display area 59 (Act 37). The processor 11a also 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 quantity display area 58 according to the input quantity.

[0075] If there are other unregistered alcoholic beverages (Act 38, No), the processor 11a calculates the amount of liquor tax for each alcoholic beverage category based on the selection of the alcoholic beverage category, the volume and the quantity input, in the same manner as described above, and determines the total amount of liquor tax (Acts 31 to 37).

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

[0077] To cancel the volume and quantity that have already been input, the subtraction button 61 is used. When the processor 11a detects that the subtraction button 61 has been operated, it selects the alcoholic beverage category, inputs the volume and quantity, and subtracts the volume and numerical value that have already been input from the corresponding alcoholic beverage category, as described above, and also subtracts the liquor tax amount and total liquor tax amount for the alcoholic beverage category.

[0078] In addition, for alcoholic beverages manufactured at other factories that are not exempt from liquor tax under the new liquor tax exemption system, even if they are registered as unregistered alcoholic beverages, they can be exempt from liquor tax exemption if the liquor tax is not calculated through the liquor tax exemption pop-up D2.

[0079] When the confirmation button 62 is pressed to confirm the liquor tax calculation (Act 38, Yes), the processor 11a records the data entered through the liquor tax exemption pop-up D2 and the calculation result in the memory unit 11d, and erases the liquor tax exemption pop-up D2 from the touch panel 11h (Act 39).

[0080] In addition, the processor 11a adds the total amount of liquor tax to the tax-exempt amount displayed in the tax-exemption amount display area 36 of the tax-exemption confirmation pop-up D1 and displays the result, and displays the total amount of liquor tax in the liquor tax-exemption amount display area 37 (Act 40), and then ends the liquor tax calculation process.

[0081] Next, if it is determined that the product currently being purchased does not contain any unregistered alcoholic beverages (Act 15, No), and after the liquor tax calculation process has been executed, the processor 11a executes a liquor tax confirmation process to calculate the liquor tax based on the tax exemption flag, liquor tax code, and volume data registered in the product master data 21 (Act 17).

[0082] FIG. 6 is a flowchart showing an example of the liquor tax confirmation process in this embodiment. When the processor 11a starts the liquor tax confirmation process, for each liquor (product) that has been registered in the registered product table by the product registration process and whose product classification is liquor and whose tax exemption flag is not "1" indicating that the product is not subject to liquor tax exemption, the processor 11a obtains the liquor tax code and volume set in the product master data 21, and the number (quantity) registered in the registered product table (Act 51).

[0083] In the product master data 21, the non-tax exemption flag is set, so even if the same alcoholic beverage is sold at a retail store within the manufacturing plant, if it is manufactured at a different manufacturing plant, it can be treated as not being subject to liquor tax exemption under the new liquor tax exemption system.

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

[0085] Furthermore, if the liquor tax calculation process has been executed previously, the processor 11a reads out the calculation results for unregistered liquors calculated in the liquor tax calculation process from the memory unit 11d and adds them to the calculation results calculated based on the aforementioned product master data 21 and registered product table (Act 52).

[0086] This makes it possible to calculate the total amount of liquor tax under the new liquor tax exemption system, including liquor registered in the product master data 21 and liquor not registered (unregistered liquor).

[0087] The processor 11a displays the total amount of liquor tax, which is the sum of the liquor tax amounts for each liquor category, 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. The processor 11a also displays the total amount of liquor tax in the liquor tax-exemption amount display area 37 (Act 53).

[0088] 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, 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 this embodiment.

[0090] The liquor tax exemption pop-up D3 basically has the same format as the liquor tax exemption pop-up D2 described above. However, since the liquor tax exemption pop-up D3 does not require data entry for liquor tax calculation, it does not include the numeric input area 60, subtraction button 61, cancel button 63, and message display area 64 of the liquor tax exemption pop-up D2.

[0091] The liquor tax exemption pop-up D3 has liquor category display areas 61-1, 61-2, 61-3, 61-4, 61-5, and 61-6 corresponding to each of the multiple liquor categories. Depending on the operation of the up button 66A or the down button 66B, the liquor category display areas corresponding to the remaining six liquor categories are displayed. Each of the liquor category display areas 61-1 to 61-6 includes an 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.

[0092] The liquor category name display area 62 displays the name of the liquor category. The tax rate display area 63 displays the tax rate for each liquor category. The volume display area 64 displays the total volume for each liquor category calculated using the above-mentioned calculation. The liquor tax amount display area 65 displays the liquor tax amount corresponding to the liquor category based on the combined tax rate and volume calculated using the above-mentioned calculation.

[0093] The liquor tax exemption pop-up D3 also has a total volume display area 67, a number of liquor items display area 68, and a total liquor tax display area 69. The total volume display area 67 displays the sum of the volumes (total volumes) displayed in the capacity display areas 64 corresponding to all liquor categories. The number of liquor items display area 68 displays the number of liquor items (products) that are subject to liquor tax exemption. The total liquor tax display area 69 displays the sum of the liquor tax amounts (total liquor tax) displayed in the liquor tax amount display areas 65 corresponding to all liquor categories.

[0094] The liquor tax exemption pop-up D3 is also provided with a Confirm button 62. When the Confirm button 62 is operated to instruct completion of the liquor tax confirmation (Act 55, Yes), the processor 11a erases the liquor tax exemption pop-up D3 from the touch panel 11h (Act 56), and ends the liquor tax confirmation process.

[0095] The employee can confirm the tax exemption amount and the liquor tax exemption amount based on the tax exemption confirmation pop-up D1, which reflects the results of the liquor tax confirmation process and the liquor tax calculation process that is executed when there are unregistered liquors. Here, the employee can execute the same process as described above (Acts 12 to 17) by again operating the forced tax exemption buttons 38, 39 or operating the liquor tax exemption button 40 (Act 18, No). Once the employee has completed the confirmation in the tax exemption confirmation pop-up D1, he or she can operate the confirm button 41 to end the tax exemption confirmation.

[0096] When the processor 11a detects an operation on the Confirm button 41 (Act 18, Yes), it removes the tax-exemption confirmation pop-up D1 from the touch panel 11h (Act 19) and returns to the state of executing the product registration process. Furthermore, if there is no product registration, the employee operates the subtotal key. When it detects that the subtotal key has been operated (Act 6, 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 (Act 20, Yes), the processor 11a inputs passport information that needs to be printed on the export tax-exempt goods purchase record slip and the export tax-exempt goods purchase pledge after the payment process. When the passport presented by the foreign tourist who wishes to purchase a product is set in the passport reader 11p, it reads the passport information recorded on the passport (such as name, date of birth, type of passport, nationality, etc.). The processor 11a stores the passport information read by the passport reader 11p in the RAM 11c. The processor 11a executes the payment process including the tax exemption details confirmed in the tax exemption confirmation popup D1 (Act 8).

[0097] When the payment is completed, the processor 11a causes the printer 11k to print the transaction details on receipt paper and issue a transaction receipt and purchase details. If tax exemption processing is performed, the processor 11a prints information about tax exemption on the transaction receipt and purchase details. Furthermore, the processor 11a causes the printer 11k to print an export tax-exempt goods purchase record slip and an export tax-exempt goods purchase pledge for the tax-exempt transaction on receipt paper and issues a receipt.

[0098] FIG. 10 is a diagram showing an example of a transaction receipt R1 and purchase details R2 when tax exemption processing is performed in this embodiment. As shown in Figure 10, transaction receipt R1 prints information R10 about the purchased items (such as product name, unit price, and subtotal), as well as tax-exemption-related information R11-R18 and a post-tax total R19. The tax-exemption-related information R11-R18 includes the total tax-exempt amount for general items R12, the total tax-exempt amount for consumables R13, the total tax-exempt amount (general items and consumables) R14 (amount excluding tax), the tax-exempt amount (total of tax-excluded and tax-inclusive amounts) R15, the taxable amount for SI categories set as tax-exempt R16, the liquor tax amount to be processed for tax-exemption R17, and the fractional amount discounted R18. In this embodiment, transaction receipt R1 prints the liquor tax amount to be processed for tax-exemption R17, allowing users to confirm that liquor tax has been exempted and the amount of the liquor tax exemption.

[0099] As shown in FIG. 10, the purchase details R2 prints information about the purchased general goods (such as name, price, and subtotal) R20, a general goods tax-exempt total R21, information about the purchased consumable goods (such as name, price, and subtotal) R22, and a consumable goods tax-exempt total R23. The purchase details R2 also prints tax-exemption-related information, such as the tax-exempt total R24, tax-exempt amount R25, and liquor tax-exempt amount R26. The purchase details R2 also prints information about the retailer (salesperson, manager, transaction number, and number of items purchased) R27. In this embodiment, the purchase details R2 not only allows users to check the tax-exempt total for general goods and consumable goods, but also allows users to check the liquor tax-exempt amount R26 individually.

[0100] FIG. 11 is a diagram showing an example of a tax-free export goods purchase record slip R3 that is printed when tax-free processing is performed in this embodiment. As shown in Figure 11, the export duty-free goods purchase record slip R3 is printed with date and time information, as well as passport information R30, purchase details R31 (same as purchase details R2), and a note R33 in Japanese and the language corresponding to the nationality included in the passport information. The purchase details R31 includes the liquor tax exemption amount R32. The export duty-free goods purchase record slip R3 also prints an addendum R34 for the applicable liquor tax rate. The addendum R34 for the applicable liquor tax rate prints the name of the liquor category (tax rate category) R35, the total volume, and the tax rate R36 for the liquor category (liquor tax rate) used in calculating the liquor tax for the product eligible for liquor tax exemption. If other products with different liquor categories (liquor tax rates) were purchased, the name of the liquor category (tax rate category) R37, the total volume, and the tax rate R38 for each product are printed.

[0101] The Export Duty-Free Goods Purchase Record Form R3 prints the name of the liquor category (tax rate category) that is subject to liquor tax exemption R35, R37, the total volume, and the tax rate R36, R38, so you can check which of the 12 liquor categories is subject to liquor tax exemption, and the volume and tax rate that are subject to exemption.

[0102] FIG. 12 is a diagram showing an example of the export duty-free goods purchase pledge R4 that is printed when the duty-free processing according to this embodiment is performed. As shown in Figure 12, the export duty-free goods purchase pledge R4 includes date and time information, as well as passport information R40 (including a signature area R41) and a purchase statement R42 (the same as the purchase statement R2). The purchase statement R42 includes the liquor tax exemption amount R43. In addition, the export duty-free goods purchase pledge R4 includes an addendum R45 indicating the liquor tax rate application category, just like the export duty-free goods purchase record slip R3.

[0103] The Export Duty-Exempt Goods Purchase Pledge Form R4, like the Export Duty-Exempt Goods Purchase Record Form R3, allows you to check which of the 12 alcohol categories are eligible for liquor tax exemption, as well as the volume and tax rate of the exemption.

[0104] According to the embodiment described above, the POS terminal 10 (product sales data processing device) of this embodiment is capable of processing sales data for tax exemption of alcoholic beverages that comply with the new liquor tax exemption system. This enables retailers offering liquor tax exemptions to process sales data appropriately according to the multiple alcoholic beverages from different manufacturers and with different liquor tax amounts included in the multiple products that foreign tourists visiting Japan are trying to purchase, and significantly reduces the burden on employees.

[0105] In addition, in this embodiment, an example of sales data processing corresponding to the new liquor tax exemption system is described, but it can also be applied to a product sales data processing device that requires sales data processing related to tax exemption when multiple types of products with different tax rates are mixed together, such as the alcoholic beverages mentioned 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 embodied in various other forms, and various omissions, substitutions, and modifications can be made without departing from the spirit of the invention. These embodiments and their modifications are included within the scope and spirit of the invention, and are also included in the scope of the invention and its equivalents as defined in the claims.

[0107] Furthermore, the processes described in the above-described embodiments can be written as a program that can be executed by a computer onto a recording medium such as a magnetic disk (flexible disk, hard disk, etc.), an optical disk (CD-ROM, DVD, etc.), or a semiconductor memory, and provided to various devices. They can also be transmitted via a communications medium and provided to various devices. A computer reads a program recorded on a recording medium or receives a program via a communications medium, and executes the above-described processes by having its operation controlled by the program. [Explanation of symbols]

[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 performing liquor tax-exempt transactions, a registration means for registering a product; a first display means for displaying a screen including a display area for displaying the volume of alcoholic beverages when the alcoholic beverages included in the registered products are exempt from liquor tax; a calculation means for calculating the liquor tax exemption amount based on the volume of liquor inputted into the display area and the tax rate corresponding to the liquor; a second display means for displaying the liquor tax exemption amount on a display unit; A product data processing device having the same.

2. the first display means displays a screen including the display areas corresponding to each of a plurality of alcoholic beverage categories; The product data processing device according to claim 1 , wherein the calculation means calculates the liquor tax exemption amount for each liquor category.

3. 3. The product data processing device according to claim 2, wherein said second display means displays a total of the liquor tax exemption amounts for each of said liquor categories.

4. 4. The product data processing device according to claim 2, further comprising a third display means for displaying on said display unit the number of alcoholic beverages for which said liquor tax exemption amount is to be calculated.

5. A computer implemented in a product data processing device that performs liquor tax-exempt transactions, a registration means for registering a product; a first display means for displaying a screen including a display area for displaying the volume of alcoholic beverages when the alcoholic beverages included in the registered products are exempt from liquor tax; a calculation means for calculating the liquor tax exemption amount based on the volume of liquor inputted into the display area and the tax rate corresponding to the liquor; a program for causing the program to function as a second display means for displaying the liquor tax exemption amount on a display unit;

Images