JP5838020B2 - Accounting equipment - Google Patents

Description

  The present invention relates to an accounting processing apparatus.

A conventional accounting processing device (POS (Point Of Sales) register) has a function of outputting various types of reports based on a data file that records an operation history of the accounting processing device (for example, Patent Document 1). reference).
For example, in the accounting processing device, when the amount of money in the drawer becomes a certain amount or more, an operation for collecting tens of thousands of tickets is performed in which a part of the amount (high money bill) is taken out of the drawer and stored in another place (payment / dispensing room). At this time, a report in which the details of the cash taken out from the drawer and the details of the cash left as change in the drawer is printed is output. This report is collected with cash (high bills) stored elsewhere in the drawer.
Japanese Patent Laid-Open No. 05-325040

However, in the report issued by the accounting processing device when performing the ticket collection operation, the cash register operator and the history of operation time are not printed, so you can see who performed what operation at what time by looking at the report It was difficult. Further, the conventional accounting processing apparatus has a drawback that it is not possible to add or delete the print items of the report output by the user.
Therefore, in order to add or delete items to be printed on the report, inform the manufacturer of the accounting processing device of the purpose of use and the item to be added or deleted and have the program of the accounting processing device currently in operation changed, or There is a problem that extra time and cost are required because a new program must be created and added.

  The present invention has been made in view of the above points, and an object thereof is to provide an accounting processing apparatus capable of easily outputting items requested by a user to a report.

The present invention has been made to solve the above problems, one aspect of the present invention, the accounting system stores generated for each transaction the electronic journal data to be recorded accounting history in accounting device, printing The designation means for accepting designation input of items included in the electronic journal data generated and stored for each transaction , the printed contents of the issued receipt and the operation history of the person in charge who has operated , the designation input by the designation means A condition adding means for receiving an input of an additional condition corresponding to an item, reading the electronic journal data for each transaction, the item specified by the specifying means and the additional condition input by the condition adding means The number of the electronic journal data of the matching transaction is totaled, and the electronic journal data of the matching transaction is stored. A collecting unit that aggregates the values of the total amount in the transaction that corresponds to the pressure condition, said generated for each transaction that matches with the additional condition input by the specified input the item the condition adding means by the specifying means The electronic journal data consisting of the stored printed contents of the receipt and the operation history of the person in charge who operates it, the totaling result of the number of the electronic journal data totaled by the totaling means, and the total amount value is zero that there fact has and an output means for printing or displaying the zero as an aggregate result of the values of the total amount in the trade corresponding to by that the additional condition to said aggregator when it is entered as the additional condition This is a characteristic accounting processing apparatus.

According to this invention, since the designation input of the item included in the electronic journal data is accepted, the user can designate and input the item that the user wants to output to the report. Moreover, since it totals and outputs based on the input item, the result which totaled the item which a user requires can be output. Thereby, it is possible to easily output an item requested by the user in a report that allows easy viewing. In addition, according to the present invention, the electronic journal data is aggregated according to the additional conditions, so that the target report can be output with fine conditioning.

Further, according to one aspect of the present invention, in the above accounting processing apparatus, the accounting apparatus includes a period setting unit that receives an input of a target period for the item specified and input by the specifying unit, and the counting unit includes the period setting unit The total number of electronic journal data and the value of the total amount in the transaction corresponding to the additional condition are tabulated based on the period input by the above.

  According to the present invention, since the period for counting items can be set, it is possible to count and output a report in a period that matches the purpose of use. As a result, it is possible to output a report that is easier to view except for a period that is not necessary.

Further, according to one aspect of the present invention, in the above-described accounting processing apparatus, the electronic journal data for each transaction includes a printed content of a receipt issued by the accounting processing apparatus and an operation history of a person in charge who operates the accounting processing apparatus. Is stored for each transaction. Further, according to one aspect of the present invention, in the above accounting processing device, the electronic journal data for each transaction includes a total amount as an item, and the condition adding unit includes a total amount as the additional condition corresponding to the total amount The input of the additional condition whose value is 0 is received.

  According to the present invention, since the designation input of the item included in the electronic journal data in which the transaction with the customer is stored is accepted, the item to be output to the report can be designated by the user. Moreover, since the receipt information handed to the customer and the operation history information of the store clerk are totaled and output based on the designated input item, the result of totaling the items required by the user can be output. Accordingly, it is possible to easily output an item requested by the user as an easy-to-see report from the receipt information handed to the customer and the operation history information of the clerk.

Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.
FIG. 1 is an external front view and a side view of an accounting processing apparatus 1 according to an embodiment of the present invention. FIG. 2 is a block diagram showing a configuration of an electric circuit built in the accounting processing apparatus 1 shown in FIG.
1 and 2, reference numeral 11 denotes a CPU (central processing unit) that controls the entire operation of the accounting apparatus 1, and is connected to each of the other components as shown. Reference numeral 12 denotes a ROM (Read Only Memory) in which a program executed by the CPU 11 is stored, and stores a program that defines the processing of the CPU 11 and the like. Reference numeral 13 denotes a RAM (Random Access Memory) used in the arithmetic processing of the CPU 11.

  Reference numeral 14 denotes a display unit for a clerk (touch panel) that functions as an operation unit for a clerk capable of performing input operations such as mode switching, setting, and registration. Reference numeral 15 denotes an operation unit that is provided with input means for inputting the completion of product registration or inputting numeric data such as a deposit amount received from a customer at the time of payment, and supplies the input data to the CPU 11. Reference numeral 16 denotes a customer display that notifies the customer of the product name and price by displaying predetermined information in accordance with a display instruction from the CPU 11.

  Reference numeral 17 denotes an automatic change machine that automatically discharges at least the coins of the calculated change to the change discharge port 17a. is there. Reference numeral 18 denotes a scanner unit that reads a barcode attached to a product and supplies the data to the CPU 11. Reference numeral 19 denotes a receipt printing unit that prints a receipt or the like of a product registered and settled according to a printing instruction from the CPU 11. Reference numeral 20 denotes a communication unit that exchanges data with the outside (for example, a store controller) by communication via a LAN. For example, the communication unit 20 downloads a PLU file (product master) for registration processing held by the store controller, or uploads sales data to the store controller.

Although the scanner unit 18 is not shown in FIG. 1, it may be configured to be connected to the accounting processing apparatus 1 main body shown in FIG. 1 by wire and to transmit the read data to the apparatus main body by wire. Further, it may be configured to be connected to the apparatus main body wirelessly and to transmit the read data to the apparatus main body wirelessly. Reference numeral 30 denotes a cash drawer in which money is stored.
The CPU 11, the ROM 12, the RAM 13, the store clerk display unit 14, the operation unit 15, the customer display unit 16, the automatic change machine 17, the receipt printing unit 19, the communication unit 20, and the cash drawer 30 are connected via a bus. They can communicate with each other.

FIG. 3 is a block diagram showing a configuration of a POS system to which the accounting processing apparatus 1 in the present embodiment is applied.
The POS system includes a plurality of POS registers (accounting processing devices) 1 and a store controller 2. The store controller 2 and the accounting processing device 1 are connected via a LAN (Local Area Network). Further, the store controller 2 and the accounting processing apparatus 1 can transmit and receive data to and from each other. The store controller 2 is installed in an area (for example, an office) where business decisions such as data aggregation and accounting processing, and decision-making regarding the purchase amount, production / processing amount, and the like are performed based on this data, and are related to product registration. Holds various files.

FIG. 4 is a schematic diagram illustrating a data configuration and a data example of the product master according to the present embodiment. The accounting processing apparatus 1 acquires the product master from the store controller 2 and stores it in the RAM 13.
As shown in the figure, the product master is a two-dimensional tabular data consisting of rows and columns, and a department code, department name, product identification code, product name, standard price, current price, and special sale. It has a column for each item of price. The main key of the product master is a product identification code. Each row of the product master exists for each product.
The department code is a code for uniquely identifying the department. The product identification code is a code for uniquely identifying a product. The normal price is a price at which the product is normally sold. The current price is the price at which the product is currently being sold. The special sale price is a price when the product is special sale.

FIG. 5 is a schematic diagram illustrating a data configuration and a data example of electronic journal data held by the accounting processing device 1 according to the present embodiment. The accounting processing apparatus 1 stores the electronic journal data in the RAM 13. The electronic journal data stores the printed contents of the receipt printed and issued by the accounting processing device 1 and the operation history of the person in charge operating the accounting processing device 1. The accounting history is the receipt printing contents and operation history.
The electronic journal data is accounting processing data including an operation history such as all printed contents of a receipt issued by the accounting processing apparatus 1. As shown in the figure, the electronic journal data is data composed of items and their values. The items stored in each row are different data, and the data is in a two-dimensional table format stored in a conventional POS register or the like. Is different. The electronic journal data stores the contents printed on the receipt and the history operated by the cashier in charge of text conversion. One transaction data 200 stored in the electronic journal data includes a header 201, a cashier 202 (name and identification number), and a product description 203.

The details of the stored electronic journal data will be described. A header beginning with “******” is added to the head of one transaction. The header “****” (7 asterisks) has a transaction date or output date and a day of the week surrounded by (), a time separated by “:”, “ A cash register number starting with “#”, a transaction number starting with “R”, and a receipt issuing number assigned for each receipt issuing starting with “J” are stored, and the last is “****** (asterisk 9). )) ”Is stored. The transaction data 200 for one transaction is from the header starting with “******” to the previous line of the next transaction header “******”. Note that a number beginning with a single “*” means a customer number. Further, the transaction details are described in the details of the product, such as the product code starting with “P” (JAN code, etc.), the department to which the product starts with “S”, and the department to which the “S” starts. Next, the product name stored as a character string, the amount or unit price stored at a location beginning with “\” or “−”, and the point of purchase when there is a point after the number are stored. A number without a symbol at the head is a person-in-charge code, and the person-in-charge name is stored after the person-in-charge code. A partition 204 with the symbol “-------- (continuous minus)” indicates that the transaction is closed (the subtotal key is pressed). Subtotal), consumption tax amount (consumption tax), total amount (total), deposit amount (custody), change amount (catch), etc. are stored. Further, when the report is output, the total details and the like are stored thereafter.
In addition, for example, when a discount operation or discount operation is performed by operating a category batch discount button for batch discounting products of a certain category, a category batch discount button for batch discounting of products of a certain category, etc. The journal data includes the store clerk's operation history, store clerk number, store clerk name, date, hour, minute, target product details, operation button name, discount or discount rate and amount, All of the sales amount, deposit amount, change amount, etc. are stored. Every time a store clerk presses an operation button to perform an operation, the name of the operated button (for example, a name that can be understood by everyone, such as a category batch discount button, a category batch discount button, etc.) is stored in the electronic journal data. Confirmation of input and output contents becomes easy.

  In addition to the items shown in FIG. 5, the electronic journal data includes items such as tax amount, change amount, customer number, customer name, number of transactions, points, etc., but detailed description of these items is omitted here. However, the accounting processing device 1 is responsible for all receipts (transactions, corrections, returns, etc.) and reports (sales, inspections, deposits, balances, change details) that are output before the accounting processing device 1 is turned off. , Totals, transaction details, etc.) and all operation histories are stored as electronic journal data.

FIG. 6 is a schematic diagram illustrating a data configuration and a data example of total designation data generated by the accounting processing device 1 according to the present embodiment.
As shown in the figure, the total designation data is two-dimensional tabular data composed of rows and columns, and includes designated items, periods, and columns of additional conditions. The total designation data is stored in the RAM 13.

The accounting processing apparatus 1 has a designation unit that accepts designation input of items to be printed on a report among items included in the electronic journal data. Specifically, the designating means displays items included in the electronic journal data and data indicating the items on the store clerk display unit 14, and accepts selection of the displayed items and data indicating the items. Alternatively, the designation unit may display a screen that accepts input of an item name directly. The user operates the clerk display unit 14 or the operation unit 15 to input an item or data indicating the item. And the designation | designated means memorize | stores the data which show the input item or item as a designation | designated item in total designation | designated data. The accounting processing apparatus 1 stores data indicating items and items in association with each other.
Moreover, the accounting processing apparatus 1 has a period setting means for displaying a screen for inputting a period corresponding to the designated item stored in the total designation data and receiving an input of the period. The period setting means stores the input period in the total designation data. The period is input as “year-month-day-year-month-day”. For example, “2008901 to 20080930” represents the period from September 01, 2008 to September 30, 2008.
Moreover, the accounting processing apparatus 1 has a condition addition means for displaying a screen for inputting a condition corresponding to a designated item stored in the total designation data and receiving an input of the condition. The condition adding means stores the input condition as an additional condition in the total designation data. The value of each item of the electronic journal data is set as the additional condition.

  In the example shown in FIG. 6, the data in the first row includes the specified item “all items”, the period “200808908 to 200808908”, the additional conditions “money amount = 0” and “accounting time = 15: 00” 18:00 ". The additional condition “total = 0” represents that the value of the item “total” in the electronic journal data is zero. “Accounting time = 15: 00 to 18:00” represents that the time of the item “operation date” in the electronic journal data is from 15:00 to 18:00. In other words, the data in the first row represents that data having a total of 0 is output to the report between 18:00 and 18:00 on September 08, 2008.

  The designated input “2008908” is divided into 2008, 09 and 08, and the header “****** (7 asterisks)” stored in the electronic journal data is stored in the row. The transaction date or the output date is collated. Also, the designated input time “15:00 to 18:00” is replaced with 15 and 18, and collated with the head time separated by “:” in the header line of the electronic journal data.

Next, a report output processing procedure by the accounting processing apparatus 1 will be described. FIG. 7 is a flowchart showing a procedure of report output processing by the accounting processing apparatus 1 in the present embodiment.
First, in step S <b> 101, the CPU 11 reads the total designation data from the work area of the RAM 13.
Next, in step S102, the CPU 11 reads one line of data from the electronic journal data.
Next, in step S103, the CPU 11 determines whether all data in the electronic journal data has been read. If all have been read, the process proceeds to step S113. On the other hand, if not read, the process proceeds to step S104.

In step S104, the CPU 11 determines whether or not a period is set in the total designation data. If set, the process proceeds to step S105. On the other hand, if not set, the process proceeds to step S106.
In step S105, the CPU 11 determines whether or not the transaction date or output date of the data read in step S102 is within the set period. Specifically, the CPU 11 collates the transaction date or output date in the row of the header “****** (7 asterisks)” with the set period, If the product description line includes a product code (such as JAN code) that starts with “P” that appears later, the next header “****** (7 asterisks)” Skip reading until a line appears, and return to step S102. Thereby, it is possible to realize fast and efficient search and aggregation. On the other hand, if it is within the period, the CPU 11 branches to step S106 to check each row stored after the header row.

Next, in step S106, the CPU 11 reads each line after the read header line, and determines whether or not the transaction data matches the specified item of the total specified data (the specified item is stored in the transaction data). To do. If it matches the specified item, the process proceeds to step S107. On the other hand, if it does not match the specified item, the process returns to step S102. However, if “all items” is designated as the designated item of the aggregate data, the process always proceeds to step S107.
In step S107, the CPU 11 determines whether or not an additional condition is set for the total designation data. If additional conditions are set, the process proceeds to step S108. On the other hand, if no additional condition is set, the process proceeds to step S110.

  In step S108, the CPU 11 determines whether the read electronic journal data includes an additional condition item. If an additional condition item is included, the process proceeds to step S109. On the other hand, if the additional condition item is not included, the process returns to step S102.

In step S109, the CPU 11 determines whether or not the read electronic journal data matches the additional condition. For example, when the additional condition is “total = 0”, the CPU 11 determines that the additional condition is met when the value of the item “total” in the transaction data is zero. If the additional condition is met, the process proceeds to step S110. On the other hand, if the additional conditions are not met, the process returns to step S102.
Next, in step S110, the CPU 11 performs a tabulation process for the designated item. Specifically, for example, when the designated item is “all items”, the CPU 11 counts the number of transaction data that matches the period and additional conditions. That is, the CPU 11 (aggregating means) reads the electronic journal data and aggregates the electronic journal data for the designated item. Further, the CPU 11 (aggregating means) aggregates electronic journal data that meets the additional conditions. Further, the CPU 11 (aggregation means) aggregates electronic journal data for the period of the aggregation designation data.
Next, in step S111, the CPU 11 performs a total process. Specifically, for example, when the designated item is “all items”, the CPU 11 sums up the values of the item “total” of the transaction data matching the period and the additional conditions. Also, for example, if the designated item that is designated and input is other than a product that includes the product code “P”, the transaction data of the product that includes the product code “P” is the summation process in step S110 and the total in S111. Removed from processing.
Next, in step S112, the CPU 11 temporarily stores the total result calculated in step S110, the total calculated in step S111, and the read transaction data in the RAM 13.

On the other hand, in step S113, the CPU 11 reads the data temporarily stored in the RAM 13.
Next, in step S114, the CPU 11 outputs the read result as a report. Specifically, the CPU 11 prints a report from the receipt printing unit 19. Alternatively, the CPU 11 may display the report on the clerk display unit 14. That is, the CPU 11 (output unit) prints or displays the counting result.

FIG. 8 is a schematic diagram illustrating an example of a report output by the accounting processing apparatus 1 according to the present embodiment.
The example shown in this figure is a report that is output when the data example shown in FIG. 6 is set as aggregation designation data.
In the report shown in FIG. 8, an additional condition and a period are output at reference numeral 101. Reference numeral 102 indicates the value of the designated item in the electronic journal data. In the data example shown in FIG. 6, since “all items” is set as the designated item, all items stored in the electronic journal data are output to the report. In addition, a count result is output at reference numeral 103. In the data example shown in FIG. 6, “20080908 to 200808908” is set for the period, and “total = 0” and “accounting time = 15: 00 to 18:00” are set as the additional conditions. For this reason, the accounting processing apparatus 1 totals transaction data whose operation date and time is between 15:00 and 18:00 on September 08, 2008 and whose total is 0. In the example shown in the figure, the transaction data that matches the period and the additional condition is one, so the total number is 1. The total, which is the total result, is 0 yen.

  The report shown in FIG. 8 is used, for example, for fraud confirmation by a cashier person. For example, if the cashier in charge performs a batch cancellation operation after registering a product once in the accounting processing apparatus 1, the total amount (total) in this transaction becomes zero. However, since the receipt for this transaction is issued, even if the customer takes the goods home without paying for the goods, it appears to the surroundings as if they had made a normal accounting process. For this reason, it has been difficult to find fraudulent clerk in this transaction. With respect to this problem, in the present embodiment, transaction data having a total of 0 can be printed and issued as a report, so that it can be known at a glance who has performed a transaction suspected of fraudulently and when.

As described above, according to the present embodiment, the accounting processing apparatus 1 accepts input of items included in the electronic journal data in which the printed contents of the report handed over in the transaction with the customer and the operation history of the person in charge are stored. To specify, the user can select the item he / she wants to output in the report. In addition, since the data is aggregated and output based on the designated and input items, it is possible to output the result of the aggregation of only the items required by the user. Thereby, the item which a user requests | requires can be output to a report easily.
Moreover, since the accounting processing apparatus 1 totals the electronic journal data according to the additional conditions, the target report can be output with fine conditioning.
Further, since the accounting processing apparatus 1 can set a period for counting the specified items, it can count only the period that matches the purpose of use and output a report, except for a period that is not necessary. This makes it possible to output a report that is easier to view.

As described above, the embodiment of the present invention has been described in detail with reference to the drawings. However, the specific configuration is not limited to the above, and various design changes and the like can be made without departing from the scope of the present invention. It is possible to
Further, in this embodiment, the accounting processing device 1 totals and outputs the operation history of the cashier staff. However, the present invention is not limited thereto. For example, items related to sales information such as store daily reports are totaled and output from electronic journal data. May be. In this case, who performed the operation of outputting the store daily report and the result thereof are also stored as electronic journal data, and therefore it is possible to output as a report who has output what report and when.

It is the external appearance front view and side view of the accounting processing apparatus by one Embodiment of this invention. It is a block diagram which shows the structure of the electric circuit incorporated in the accounting processing apparatus in this embodiment. It is a block diagram which shows the structure of the POS system to which the accounting processing apparatus in this embodiment is applied. It is the schematic which shows the data structure and data example of the goods master which the accounting processing apparatus 1 in this embodiment hold | maintains. It is the schematic which shows the data structure and data example of the electronic journal data which the accounting processing apparatus 1 in this embodiment hold | maintains. It is the schematic which shows the data structure of the aggregation designation | designated data which the accounting processing apparatus 1 in this embodiment produces | generates, and a data example. It is a flowchart which shows the procedure of the report output process by the accounting processing apparatus 1 in this embodiment. It is the schematic which shows an example of the report which the accounting processing apparatus 1 in this embodiment outputs.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Accounting processing apparatus 2 ... Store controller 11 ... CPU 12 ... ROM 13 ... RAM 14 ... Display part for salesclerks 15 ... Operation part 16 ... Display part for customers 17 ... Automatic change machine 17a ... Change discharge port 17b ... Deposit input port 18 ... Scanner unit 19 ... Receipt printing unit 20 ... Communication unit 30 ... Cash drawer

Claims (2)

In the accounting processing device that generates and stores electronic journal data for each transaction, which records the accounting history in the accounting processing device,
A designation means for accepting designation input of items included in the electronic journal data generated and stored for each transaction , the printed contents of the printed receipt and the operation history of the person in charge who has operated ,
Condition adding means for receiving an input of an additional condition corresponding to the item specified and input by the specifying means;
Read the electronic journal data for each transaction, total the number of the electronic journal data of the transactions that match the item specified and input by the specifying means and the additional condition input by the condition adding means, A counting means for counting the value of the total amount in the transaction corresponding to the additional condition stored in the electronic journal data of the matching transaction;
From said generated for each transaction stored operation history of the person who operated the printing contents of the receipt that matches with the additional condition input by the specified input the item the condition adding means by the specifying means an electronic journal data comprising a total result of the number of aggregated the electronic journal data is by the collecting unit, Ru good to the aggregator if that value of the total amount is zero is entered as the additional condition An output means for printing or displaying zero as a total result of the total amount in the transaction corresponding to the additional condition ;
An accounting processing apparatus comprising: A period setting unit that receives an input of a target period in the item specified and input by the specifying unit;
The counting means includes
2. The accounting according to claim 1, wherein the number of cases of the electronic journal data and the value of the total amount in the transaction corresponding to the additional condition are tabulated based on the period input by the period setting means. Processing equipment.

Images