JP2020004451A - Commodity data processing device and program - Google Patents

Abstract

To provide a commodity data processing device and a program that are capable of changing the tax rate imposed on a commodity according to the number of commodities bought.SOLUTION: A commodity data processing device comprises: first acceptance means for accepting an input of a commodity code for specifying a commodity; second acceptance means for accepting an input of the number of bought commodities of the same type among commodities specified by the commodities codes; specifying means for specifying the tax rate corresponding to the conditions of a commodity specified by a commodity code and the number of the commodity bought, on the basis of tax setting information in which each range of the number of sales set for each type of commodities is associated with the tax rate of the range; and calculation means for calculating the amount of tax imposed on the commodity specified by the commodity code on the basis of the tax rate specified by the specifying means.SELECTED DRAWING: Figure 7

Description

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

  2. Description of the Related Art Conventionally, in a product data processing device such as a POS (Point Of Sale) terminal that handles product data for a product specified based on a product code, a tax rate is set for each product. As for the tax rate, there is a tax system such as a reduced tax rate which determines a tax rate lower than the original tax rate for a specific product such as food.

  Incidentally, it is conceivable that the above-mentioned tax system such as the reduced tax rate is implemented in various forms. For example, a tax system that changes a tax rate (consumption tax) on a particular product according to the number of sales points of the product may be considered. However, the conventional product data processing device cannot change the tax rate according to the number of sales points, and cannot cope with such a tax system.

  The product data processing device according to the embodiment includes a first receiving unit, a second receiving unit, a specifying unit, a display unit, and a calculating unit. The first receiving means receives an input of a product code for specifying a product. The second receiving means receives an input of the sales points of the same type of product among the products specified by the product code. The specifying means, based on tax setting information that associates each range of the sales points set for each type of the product with a tax rate of each range, the product specified by the product code and the product Identify tax rates that meet the conditions for sales points. The display means displays conditions for specifying the tax rate of the product. The calculating means calculates a tax amount of the product specified by the product code based on the tax rate specified by the specifying means.

FIG. 1 is a schematic configuration diagram of a POS system according to the embodiment. FIG. 2 is a block diagram schematically illustrating a functional configuration of the store server. FIG. 3 is a diagram illustrating a data configuration of the product master. FIG. 4 is a diagram showing a data configuration of the tax division master. FIG. 5 is a diagram showing a data configuration of the condition setting master. FIG. 6 is an external perspective view of the POS terminal. FIG. 7 is a block diagram schematically illustrating a functional configuration of the POS terminal. FIG. 8 is a flowchart illustrating a procedure of an operation performed by the POS terminal. FIG. 9 is a conceptual diagram illustrating an example of a receipt sheet printed by the POS terminal.

  An embodiment of a product data processing device and a program will be described below with reference to the accompanying drawings. In this embodiment, a case will be described in which a product data processing device and a program are applied to a POS terminal used in a store such as a supermarket.

  FIG. 1 is a schematic configuration diagram of a POS system 1 according to the embodiment. As shown in FIG. 1, a POS system 1 connects a plurality of (two in the figure) POS terminals 2 as merchandise data processing devices and these POS terminals 2 via a network such as a LAN (Local Area Network) 3. And a store server 4 for centralized management.

  The store server 4 is responsible for controlling the entire POS system 1. FIG. 2 is a block diagram schematically showing a functional configuration of the store server 4. As shown in FIG. The store server 4 includes a control unit 41 having a computer configuration including a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), a communication I / F 43, and an I / O device control unit. 44 are connected by a bus 42. The store server 4 mutually communicates online with a plurality of POS terminals 2 via the communication I / F 43 and the LAN 3 (see FIG. 1). A keyboard 45, a display 46, a printer 47, and a hard disk drive (HDD) 48 are connected to the control unit 41 via a bus 42 and an I / O device control unit 44. The HDD 48 stores a product master M and a tax rate setting database DB, in addition to various control programs for operating the CPU of the control unit 41.

  FIG. 3 is a diagram illustrating a data configuration of the product master M. As shown in FIG. 3, the product master M stores product information such as a product name and a product price in association with a “product code” of each product. The “product code” is identification information uniquely set for each product, and is used to specify a product. For example, in a store, a product code set for the product is described in a label attached to the product. Then, the commodity code described on the label is input by the scanner 19 (see FIG. 6) of the POS terminal 2 connected via the bus 42 or the communication I / F 43 or the like. The store server 4 can specify a product by referring to the product master M with the input product code.

  The tax rate setting database DB is a database in which tax information on products is set for each product set in the product master M, that is, for each product handled in the store. Specifically, the tax rate setting database DB includes a tax classification master D1 and a condition setting master D2.

  FIG. 4 is a diagram showing a data configuration of the tax division master D1. As shown in FIG. 4, the tax category master D1 stores a "tax category name" and a "tax rate" in association with a "tax category ID" for identifying a tax category. “Tax classification ID” is identification information uniquely set for each tax classification. In the present embodiment, the type of the consumption tax imposed according to the number of sales points of each product is a tax category. The “tax category name” indicates the name of the tax category identified by the “tax category ID”. FIG. 4 illustrates an example in which “necessities”, “daily necessities”, and “preferences” are set as “tax category names”. The “tax rate” indicates a tax rate applied to the “tax classification ID”.

  FIG. 5 is a diagram showing a data configuration of the condition setting master D2. As shown in FIG. 5, the condition setting master D2 stores “application conditions” and “tax classification ID” in association with “product code”. Here, the “application condition” is used to specify the tax category of the product identified by the “product code”. The “application condition” includes a “condition ID”, a “sales point lower limit”, and a “sales point upper limit”. “Condition ID” is identification information uniquely set for each application condition. In addition, the lower limit of the number of sales points is set in “sales point lower limit”, and the upper limit value of the sales points is set in “sales point upper limit”. Each of the application conditions is defined by a range of sales points set by the “lower sales points” and the “upper sales points”. Note that "null" in the "sales point upper limit" means that the upper limit is unlimited.

  For example, if the sales number of the product A is “00101” for the product A having the “product code” of “00101”, it corresponds to the application condition of the condition ID “201”, and the tax rate “0” of the tax classification ID “102” is applicable. .05 "applies. Further, if the sales number of the product A is two or more for the product A having the “product code” of “00101”, it corresponds to the application condition of the condition ID “202”. The tax rate "0.02" applies.

  Next, the POS terminal 2 will be described. FIG. 6 is an external perspective view of the POS terminal 2. As shown in FIG. 6, the POS terminal 2 is mounted on a drawer 12 for storing cash and the like, and controls opening and closing of a drawer 12a of the drawer 12. On the front side of the POS terminal 2, a mode key 14 for selecting various business modes such as registration, inspection, settlement, setting, and the like is provided. The keyboard (13) provided on the front of the POS terminal 2 allows an operator (store clerk) to enter, for example, a numeric key for inputting a deposit amount, a sales number, and the like, and a product for which sales registration has been performed as one commercial transaction. Operation keys for performing various operation inputs such as a total key for instructing total output are arranged.

  Further, the POS terminal 2 is provided with a store clerk display 15 on the front side and a customer display 16 on the back side. For example, a liquid crystal display or the like is used as the display 15 for the clerk and the display 16 for the customer, and the name, price, total amount of one commercial transaction, change amount, and the like of the registered product are displayed. The POS terminal 2 has a built-in printer 17 for printing receipts and journals. The receipt printed by the printer 17 is issued from a receipt issuing port 18 formed on the front side of the POS terminal 2. Further, the POS terminal 2 is connected to a scanner 19 for reading a barcode given to the product.

  FIG. 7 is a block diagram schematically illustrating a functional configuration of the POS terminal 2. The POS terminal 2 includes a control unit 21 having a computer configuration including a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), and the like (all not shown). The ROM stores various programs executed by the CPU and various data. The RAM temporarily stores data and programs when the CPU executes various programs. Further, the RAM stores sales data indicating sales records of commodities, and various screen display data displayed on the clerk display 15 and the customer display 16.

  The control unit 21 controls I / O devices such as the keyboard 13, the clerk display 15, the customer display 16, the printer 17, and the scanner 19 via the I / O device control unit 24 and the bus 22. The control unit 21 communicates with the store server 4 via the communication I / F 23 and the LAN 3 (see FIG. 1).

  The control unit 21 allows the CPU to expand the program stored in the ROM into the RAM and execute the program, thereby receiving the product code receiving unit 31, the sales point receiving unit 32, the tax rate specifying unit 33, and the sales registering unit 34. , A display control unit 35 and a print control unit 36.

  When the barcode attached to each product is scanned by the scanner 19, the product code accepting unit 31 reads and accepts the product code from the barcode data. Note that the product code receiving unit 31 may receive a product code input using a key input from the keyboard 13. Further, the product code receiving unit 31 may read a product code from another code symbol such as a two-dimensional code and receive the input.

  The sales point receiving unit 32 receives an input of the sales points of the same type of product classified under a predetermined condition among the products specified by the product code received by the product code receiving unit 31. Here, the “same type” is, for example, a product specified by the same product code, and the number of the products is input as a sales point via a numeric key of the keyboard 13 or the like. When the operation of the numeric key is not performed, the sales quantity “1” may be input as a default value. In addition, the input method of the sales point is not limited to the number key, and among the product codes received by the product code receiving unit 31, the number of duplicate product codes is received as the sales point of the product specified by the product code. You may.

  The tax rate specifying unit 33 refers to the product master M and the tax rate setting database DB of the store server 4 via the communication I / F 23 based on the product code received by the product code receiving unit 31 and the sales points of the product code. By doing so, the tax rate imposed on the product specified by the product code is specified.

  Specifically, the tax rate specifying unit 33 refers to the condition setting master D2 of the store server 4 based on the product code and the sales points received by the product code receiving unit 31 and the sales point receiving unit 32, The “tax classification ID” corresponding to the condition of the product code and the number of sales points is acquired. Next, the tax rate specifying unit 33 acquires the tax rate associated with the tax category ID by referring to the tax category master D1 in the tax rate setting database DB based on the acquired tax category ID.

  The sales registration unit 34 performs sales registration of the product specified by the product code received by the product code reception unit 31. Specifically, the store server 4 is inquired about the product code received by the product code receiving unit 31 via the communication I / F 23, and the product name and the price set in the product master M for the product code are acquired. . Next, a tax amount and a tax-inclusive price are calculated based on the acquired price and the “tax rate” acquired by the tax rate specifying unit 33. Specifically, the sales registration unit 34 calculates a tax amount imposed on the product by multiplying the acquired price by the “tax rate” acquired by the tax rate specifying unit 33. In addition, the sales registration unit 34 calculates the tax-inclusive price by adding the calculated tax amount to the price of the product. Then, the sales registration unit 34 registers a product name, a price, a tax amount, a tax-inclusive price (sales price), and the like as information of the sold product.

  The display control unit 35 displays the product name, price, tax amount, tax-inclusive price, and the like of each product registered by the sales registration unit 34 on the display 15 for clerks and the display 16 for customers. Specifically, based on the determination result by the tax rate specifying unit 33, the display control unit 35 determines, for each tax category, information (product name, price, price including tax) indicating the product for which the tax category is determined, The tax amount on the product is displayed (details will be described later). It is not necessary to display all of the display contents displayed by the display control unit 35 on both the clerk display 15 and the customer display 16, and the display contents may be appropriately sorted and displayed according to convenience. .

  The print control unit 36 prints the store name and contact information of the store, the product name, price, tax-inclusive price, tax amount, and the like of each product registered by the sales registration unit 34 on the receipt paper by the printer 17. Specifically, based on the determination result by the tax rate specifying unit 33, the print control unit 36 determines, for each tax category, information (product name, price, price including tax) indicating the product for which the tax category is determined, The tax amount of the product is printed on receipt paper (details will be described later). The printed receipt paper is issued from the receipt issuing port 18.

  Next, the procedure of the operation performed by the POS terminal 2 will be described. FIG. 8 is a flowchart showing the procedure of the operation performed by the POS terminal 2.

  First, at the POS terminal 2, the barcode attached to the product is scanned by the scanner 19. The product code receiving unit 31 waits until the barcode is scanned by the scanner 19 (step S11: No). When the barcode is scanned by the scanner 19, the product code receiving unit 31 reads and receives the product code from the barcode data (Step S11: Yes). In addition, at this time, when the sales points of the scanned product are input by operating the numeric keys or the like, the sales point receiving unit 32 receives the input sales points (step S12).

  Subsequently, the tax rate specifying unit 33 determines the condition based on the tax distinction ID of the product corresponding to the product code received by the product code receiving unit 31 and the sales quantity of the product received by the sales point receiving unit 32. Is acquired from the condition setting master D2 (step S13). Next, the tax rate specifying unit 33 acquires the tax rate specified by the tax category ID from the tax category master D1 based on the tax category ID acquired in step S13 (step S14).

  The sales registration unit 34 acquires the product information such as the product name and the price set in the product master M for the product code, and calculates the tax amount and the tax-inclusive price based on the tax rate acquired by the tax rate specifying unit 33. (Step S15). Next, the sales registration unit 34 stores the tax category and the tax rate acquired by the tax rate identification unit 33 in the RAM in association with the product information of the product specified by the product code and the calculated tax amount (step S16). Specifically, the product code received by the product code receiving unit 31 and the calculated tax amount are stacked in an array (storage area) reserved for a “tax distinction ID” indicating a tax distinction.

  Subsequently, the sales registration unit 34 registers information of the sold product such as a product name, a price, a tax amount, a tax-inclusive price, and the number of sales (Step S17). Next, the display control unit 35 displays the product name, price, tax amount, tax-inclusive price, and the like of each product registered by the sales registration unit 34 on the clerk display 15 and the customer display 16 (step S18).

  Next, the POS terminal 2 determines whether or not the current total key has been pressed on the keyboard 13 (Step S19). While the current key is not depressed (Step S19: No), the process returns to Step S11 and the processes of Steps S11 to S19 are continued until the sales registration of all the commodities is completed. Therefore, in step S16, the products and the calculated tax amount for each tax category are stacked and stored in the RAM for all the products registered for sale.

  When the current key is depressed (step S19: Yes), the print control unit 36 sequentially reads out the product and the tax amount stored in the RAM for each tax category, and reads the product name, price, and the like of each product for each tax category. The amount of tax, the price including tax, the number of sales, etc. are printed on the receipt paper (step S20). Specifically, the commodity code stored in the RAM is sequentially read out for each tax division, and the contents registered in step S17 for the commodity specified by the commodity code are read out and printed on receipt paper. In addition, the print control unit 36 reads the “tax category name” for each tax category from the tax category master D1, and prints information on the tax category, such as the tax rate applied to the price of the product in the tax category, on the receipt paper. I do.

  FIG. 9 is a conceptual diagram illustrating an example of a receipt sheet printed by the POS terminal 2. As shown in FIG. 9, the product name and tax amount of each product are printed on the receipt paper for each tax category in step S20. In the illustrated example, the product name (such as "product A") and the tax amount (such as "$ 8") are printed on the receipt paper for each of the tax categories "necessities", "daily necessities", and favorite items. In addition, a tax rate (“Zay: 2%” or the like) to be imposed on the commodity price is printed as information on the tax classification.

  Returning to FIG. 8, the print control unit 36 issues the printed receipt paper from the receipt issuing port 18 (step S21). Then, the clerk performs the accounting process and ends the sales registration process of one accounting.

  In the present embodiment, the operation of printing on the receipt paper in steps S20 and S21 is described as an example, but the display control unit 35 displays the content to be printed on the receipt paper in steps S20 and S21 described above. May be displayed on the customer display 16. That is, at least one of the display on the store clerk display 15 and the customer display 16 by the display control unit 35 and the printing on the receipt paper by the print control unit 36 may be output.

  As described above, the POS terminal 2 specifies the tax rate corresponding to the sales point of the product specified by the same product code, and calculates the tax amount and the tax-inclusive price calculated based on the tax rate. Use it to register for sales. As a result, the tax rate imposed on the product can be changed according to the sales points of the product, so that it is possible to cope with a tax system in which the tax rate (consumption tax) is changed based on the sales points of the product. . Further, the POS terminal 2 of the present embodiment outputs, for each tax category, information indicating a product such as a product name and a tax-inclusive price, and a tax amount on the product for sale and registration. Therefore, the clerk and the customer can easily know, for each tax category, the product and the tax amount of the tax category for each product registered for sale.

  As described above, the embodiments of the present invention have been described. However, the above embodiments have been presented as examples, and are not intended to limit the scope of the invention. The above embodiment can be implemented in other various forms, and various omissions, replacements, and changes can be made without departing from the spirit of the invention. The above-described embodiment and its modifications are included in the scope and spirit of the invention, and are also included in the invention described in the claims and the equivalents thereof.

  For example, in the above-described embodiment, the products of the same type are products specified by the same product code. However, the present invention is not limited to this, and products belonging to the same category (for example, liquor) are regarded as products of the same type. Is also good. In this case, the product master M stores a classification code for identifying the category to which the product belongs in association with the product code of each product, and the condition setting master D2 associates the classification code with the classification code and And the tax classification ID are stored in association with each other. Then, the sales point receiving unit 32 receives an input of the sales points for each of the product groups belonging to the same category among the products registered for sale. By adopting such a configuration, it is possible to change the tax rate imposed on the product group according to the sales points of the product group belonging to the same category. The classification code may be included in a part of the product code (for example, the upper three digits).

  Further, in the above-described embodiment, the product in which the tax rate does not depend on the number of sales points and the product with a constant tax rate is registered in the condition setting master D2 (see the product code “00102” in FIG. 5), but is not limited thereto. It is also possible to use a form in which the information is registered in the area. For example, for a product with a fixed tax rate, the tax rate may be stored in the product master M in association with the product code of the product. In the case of adopting this configuration, the tax rate specifying unit 33 searches the condition setting master D2 for the product code received by the product code receiving unit 31, and if there is no corresponding product code (applicable condition), the product master M See Then, the tax rate specifying unit 33 specifies the tax rate by reading the tax rate corresponding to the product code received by the product code receiving unit 31 from the product master M.

  In the above-described embodiment, the store server 4 holds the product master M and the tax rate setting database DB. However, the present invention is not limited to this, and a part or all of the product master M and the tax rate setting database DB may be stored in the POS terminal 2. May be held.

  The program executed by the POS terminal 2 according to the present embodiment is provided by being incorporated in a ROM or the like in advance. The program executed by the POS terminal 2 of the present embodiment is a file in an installable format or an executable format in a computer such as a CD-ROM, a flexible disk (FD), a CD-R, and a DVD (Digital Versatile Disk). You may comprise so that it may record and provide on a readable recording medium.

  Furthermore, the program executed by the POS terminal 2 of the present embodiment may be stored on a computer connected to a network such as the Internet, and provided by being downloaded via the network. Further, the program executed by the POS terminal 2 of the present embodiment may be provided or distributed via a network such as the Internet.

  The programs executed by the POS terminal 2 according to the above-described embodiment include the above-described units (product code receiving unit 31, sales point receiving unit 32, tax rate specifying unit 33, sales registration unit 34, display control unit 35, print control unit 36). The CPU (processor) reads and executes a program from the ROM as actual hardware, so that the respective units are loaded on the main storage device and generated on the main storage device. It has become.

  DESCRIPTION OF SYMBOLS 1 ... POS system, 2 ... POS terminal, 3 ... LAN, 4 ... Store server, 12 ... Drawer, 12a ... Drawer, 13 ... Keyboard, 14 ... Mode key, 15 ... Display for clerk, 16 ... Display for customer, 17 ... Printer, 18 Receipt issuing port, 19 Scanner, 21 Control part, 22 Bus, 23 Communication I / F, 24 I / O device control part, 31 Product code receiving part, 32 Sales point receiving part 33, a tax rate specifying unit, 34, a sales registration unit, 35, a display control unit, 36, a print control unit, 41, a control unit, 42, a bus, 43, a communication I / F, 44, an I / O device control unit, 45 keyboard, 46 display, 47 printer, 48 HDD, M product master, DB tax rate setting database, D1 tax classification master, D2 condition setting master

JP 2012-181752 A

The product data processing device according to the embodiment includes a receiving unit, a counting unit, a first specifying unit, a second specifying unit, a calculating unit, and an output unit. The receiving means receives an input of a product code for specifying a product. The counting means counts the number of sales points in one transaction of the product specified by the product code. The first specifying means is based on first tax setting information in which a product code of each product is associated with a tax category applied in accordance with the sales points, and the sales points of the products counted by the counting means. Identify tax categories that meet the conditions of The second specifying means is configured to determine the tax rate of the tax category specified by the first specifying means based on second tax setting information in which each of the tax categories is associated with a tax rate applied to the tax category. To identify. The calculating means calculates the tax amount of the product specified by the product code based on the tax rate of the tax category specified by the second specifying means. The output means, for a product specified by the product code input in one transaction, information indicating the product and the number of sales points counted by the counting means, for each tax category specified by the first specifying means Output to

Claims (6)

First receiving means for receiving input of a product code for specifying a product,
Second receiving means for receiving an input of the number of sales points of the same type of product among the products specified by the product code;
Each range of the sales points set for each type of the product, based on the tax setting information that associates the tax rate of each range, based on the product specified by the product code and the sales points of the product Means for identifying tax rates that meet the conditions of
Display means for displaying conditions relating to the specification of the tax rate of the product,
Calculating means for calculating a tax amount of a product specified by the product code based on the tax rate specified by the specifying means;
Product data processing device comprising: The second receiving means receives an input of the sales points for each product specified by the same product code,
The said specification means specifies the tax rate for every goods specified by the said goods code based on the said tax setting information in which the tax rate of each said range was set for every goods specified by the said goods code. A product data processing device according to item 1. The second receiving means receives an input of the sales points for each product group belonging to a predetermined category,
2. The product data processing device according to claim 1, wherein the specifying unit specifies a tax rate for each of the product groups based on the tax setting information in which a tax rate in each of the ranges is set for each of the product groups. 3.   The product data processing device according to any one of claims 1 to 3, further comprising an output unit configured to output information indicating a product specified by the product code and a tax amount of the product calculated by the calculation unit. . Further comprising sales registration means for performing sales registration of the product specified by the product code,
5. The product data processing device according to claim 4, wherein the output unit outputs, for the product registered for sale, information on the product and a tax rate. 6. Computer of the product data processing device,
First receiving means for receiving input of a product code for specifying a product,
Second receiving means for receiving an input of the number of sales points of the same type of product among the products specified by the product code;
Each range of the sales points set for each type of the product, based on the tax setting information that associates the tax rate of each range, based on the product specified by the product code and the sales points of the product Means for identifying tax rates that meet the conditions of
Display means for displaying conditions relating to the specification of the tax rate of the product,
Calculating means for calculating a tax amount of a product specified by the product code based on the tax rate specified by the specifying means;
Program to make it work.

Images