JP6314185B2 - Sales data processing apparatus and program - Google Patents

Description

  Embodiments described herein relate generally to a sales data processing apparatus and a program.

  Conventionally, the contents of a commercial transaction registered by a POS (Point Of Sale) terminal installed at each store are managed as a journal by a server of the general center.

  However, in the prior art, when it is desired to pick up a predetermined commercial transaction with the server of the general center, it is necessary to check the transactions managed in the journal one by one and find out the commercial transaction to be picked up, which is inconvenient. In particular, when managing many stores, there is a huge amount of journals, so it has been desired to easily find a desired commercial transaction.

In order to solve the above-described problem, the sales data processing apparatus according to the embodiment includes a collection unit, a search condition reception unit, a search unit, and an output unit. The collecting means includes a transaction number for identifying transaction details, date and time information indicating the date and time when the commercial transaction was performed, transaction information regarding a product sold in the commercial transaction, store information indicating a store where the transaction was performed, and commercial transaction. Journal files including terminal information indicating the performed terminals are collected from the terminals of a plurality of stores. The search condition accepting unit accepts an input of a start number and an end number of the transaction number related to a commercial transaction to be searched as a search condition for transaction details of a commercial transaction. The search means searches the journal file for the transaction number corresponding to the transaction number from the start number to the end number received by the search condition receiving means, the date / time information, and the transaction information as the transaction details. To do. The output means uses the transaction number, the date / time information, and the transaction information of the transaction details searched by the search means as transaction details images, and the transaction corresponding to the transaction details at a higher position of the transaction details image. A number is arranged and displayed and output , and the name of the journal file related to the transaction detail image currently displayed is displayed and output . Then, the search means determines the transaction details having the same transaction number as the start number and the end number on condition that the start number and the end number received by the search condition receiving means are the same. Search for.

The program of the embodiment causes the computer of the sales data processing apparatus to function as a collecting unit, a search condition receiving unit, a search unit, and an output unit. The collecting means includes a transaction number for identifying transaction details, date and time information indicating the date and time when the commercial transaction was performed, transaction information regarding a product sold in the commercial transaction, store information indicating a store where the transaction was performed, and commercial transaction. Journal files including terminal information indicating the performed terminals are collected from the terminals of a plurality of stores. The search condition accepting unit accepts an input of a start number and an end number of the transaction number related to a commercial transaction to be searched as a search condition for transaction details of a commercial transaction. The search means searches the journal file for the transaction number corresponding to the transaction number from the start number to the end number received by the search condition receiving means, the date / time information, and the transaction information as the transaction details. To do. The output means uses the transaction number, the date / time information, and the transaction information of the transaction details searched by the search means as transaction details images, and the transaction corresponding to the transaction details at a higher position of the transaction details image. A number is arranged and displayed and output , and the name of the journal file related to the transaction detail image currently displayed is displayed and output . Then, the search means determines the transaction details having the same transaction number as the start number and the end number on condition that the start number and the end number received by the search condition receiving means are the same. Search for.

FIG. 1 is a schematic diagram showing the configuration of a product sales system. FIG. 2 is a conceptual diagram showing the structure of a journal file record. FIG. 3 is a block diagram illustrating a hardware configuration of the headquarter server. FIG. 4 is a flowchart illustrating an example of the operation of the headquarter server. FIG. 5 is a conceptual diagram illustrating an example of a display screen. FIG. 6 is a conceptual diagram illustrating an example of a display screen. FIG. 7 is a conceptual diagram illustrating an example of a sheet.

  Hereinafter, embodiments of a sales data processing device and a program will be described in detail with reference to the accompanying drawings. The embodiment described below is an application example to a headquarter server of a merchandise sales system in which a plurality of stores that are chain-expanded are communicatively connected. Needless to say, the sales data processing apparatus and the program according to the embodiment may be applied to a store server or a POS terminal in addition to the application to the headquarter server described below.

  FIG. 1 is a schematic diagram showing the configuration of a product sales system. As shown in FIG. 1, the product sales system is configured by connecting a general center 1 and a plurality of stores F (F1, F2, F3...) Via a communication network 3 such as the Internet.

  The central center 1 is provided with a headquarter server 2 that collects and manages data relating to commercial transactions performed at each store F. The headquarter server 2 includes an HDD 20 (Hard Disk Drive) for storing data related to commercial transactions collected from each store F. The HDD 20 has a PLU file 21 (Price Look Up) in which product data including product names and prices handled at each store F is registered, and identifies the business transaction for each business transaction performed at each store F. A journal file 22 for recording the transaction details to which identification information for performing the transaction is assigned is stored.

  Each store F is provided with a store server 4 that collects and manages data related to commercial transactions for each store, and one or more POS terminals 5 and 6. The store server 4 and the POS terminals 5 and 6 are connected to each other via a LAN 7 (Local Area Network) built in the store so that they can communicate with each other. The store server 4 and the headquarter server 2 are connected via a communication network 3 so that they can communicate with each other.

  The store server 4 includes a PC (Personal Computer) configured by connecting an output unit such as a hard disk drive, a display, and an input unit such as a keyboard to a control circuit mainly composed of a CPU (Central Processing Unit). It is. The store server 4 assigns a transaction number to the hard disk drive and manages the transaction details transmitted when the POS terminals 5 and 6 register the commercial transaction. The store server 4 transmits data related to the daily business transaction managed by the hard disk drive to the headquarter server 2 via the communication network 3 at a predetermined timing (for example, when the business of the day is completed). The headquarter server 2 records the data transmitted from the store server 4 in the journal file 22. In this way, the headquarter server 2 manages the data related to the commercial transaction performed at each store F by the journal file 22.

  FIG. 2 is a conceptual diagram showing the record structure of the journal file 22. As shown in FIG. 2, the journal file 22 includes a transaction number storage area 42a, a date / time storage area 42b, a transaction details storage area 42c, and the like. The transaction number storage area 42a stores a transaction number uniquely assigned to identify the transaction details of the commercial transaction as the identification information of the commercial transaction. The date and time storage area 42b stores the date and time when the commercial transaction was performed. The transaction details storage area 42c stores product data sold in one commercial transaction. The product data stored in the transaction details storage area 42c includes a product code for identifying a product, a name, a unit price, and the like. Note that a portion (not shown) in the record includes information indicating the store F in which the transaction has been performed, information for distinguishing the POS terminals 5 and 6 in which the commercial transaction has been performed, and the like.

  FIG. 3 is a block diagram showing a hardware configuration of the headquarter server 2. As shown in FIG. 3, the headquarter server 2 includes a control unit 30 having a computer configuration including a CPU, a ROM (Read Only Memory), a RAM (Random Access Memory), etc., a communication I / F 32, and an I / O device. The control unit 33 is connected by a bus 31. The headquarter server 2 communicates online with the store server 4 of each store F via the communication I / F 32 and the communication network 3 (see FIG. 1). In addition, a keyboard 34, a display device 35 such as a liquid crystal display, a printer 36, and the HDD 20 are connected to the control unit 30 via a bus 31 and an I / O device control unit 33. Note that the hardware configuration of the headquarter server 2 shown in the figure, such as devices connected via the I / O device control unit 33, is an example, and for example, a touch panel or a mouse may be provided in addition to the keyboard 34. Needless to say.

  The HDD 20 stores various control programs for operating the CPU of the control unit 30 in addition to the PLU file 21 and the journal file 22 described above. The control unit 30 functions as a search condition receiving unit 301, a journal search unit 302, a journal display unit 303, and a journal printing unit 304 by causing the CPU to expand the control program stored in the HDD 20 onto the RAM and sequentially executing the control program. Realize.

  The search condition receiving unit 301 receives a transaction number, which is identification information of a desired commercial transaction, from the user as a search condition for searching for a commercial transaction recorded in the journal file 22. Specifically, the search condition receiving unit 301 displays a display screen for receiving a search condition for searching for a commercial transaction recorded in the journal file 22 on the display 35 and receives a transaction number by an operation input using the keyboard 34.

  The journal search unit 302 searches for the commercial transaction corresponding to the transaction number received by the search condition reception unit 301 from the commercial transactions recorded in the journal file 22. Specifically, the journal search unit 302 searches the record that matches the transaction number received by the search condition receiving unit 301 with reference to the journal file 22. The information stored in the transaction number storage area 42a, the date / time storage area 42b, and the transaction details storage area 42c of the retrieved record is the transaction details of the commercial transaction that matches the search conditions received by the search condition receiving unit 301.

  The journal display unit 303 displays and outputs the transaction details of the commercial transaction searched by the journal search unit 302 on the display screen of the display unit 35. The journal printing unit 304 prints out the transaction details of the commercial transaction searched by the journal search unit 302 on a sheet by the printer 36. The transaction details of the commercial transaction searched by the journal search unit 302 may be output by at least one of display output by the journal display unit 303 and print output by the journal printing unit 304. For example, after the journal display unit 303 first displays and outputs on the display screen of the display unit 35, the journal printing unit 304 may print out the paper when a printing instruction is given by operating the keyboard 34 or the like.

  Next, the operation of the headquarter server 2 will be described. FIG. 4 is a flowchart showing an example of the operation of the headquarter server 2. The flowchart of FIG. 4 shows an example of processing that is started when a search for the journal file 22 is instructed by an operation instruction from the keyboard 34, for example.

  As shown in FIG. 4, when the process is started, the search condition receiving unit 301 displays a display screen for receiving a search condition for searching for a commercial transaction recorded in the journal file 22 on the display 35, and the keyboard 34. The operation input by is received, and the transaction number concerning the commercial transaction to be searched is received (S1).

  FIG. 5 is a conceptual diagram showing an example of the display screen G. As shown in FIG. 5, the display screen G relating to the search for the journal file 22 includes a search condition input area G1, a search result display area G2, and an operation button area G3. In the search condition input area G1, a search start number input area K1 for inputting a start number of a transaction number related to a search target commercial transaction and an end number of a transaction number related to the search target commercial transaction are input as search conditions for the commercial transaction. And a search end number input area K2 for this purpose. The user operates the keyboard 34 to input the start number of the transaction number to be searched in the search start number input area K1, and input the end number of the transaction number to be searched in the search end number input area K2. By this input, it is possible to search for a commercial transaction corresponding to the end number input in the search end number input area K2 from the start number input in the search start number input area K1. When searching for a single commercial transaction, the same transaction number is input as the start number and the end number, so that a commercial transaction corresponding to the transaction number can be searched.

  Next, the journal search unit 302 reads the journal file 22 stored in the HDD 20 (S2), and searches for a commercial transaction corresponding to the transaction number accepted in S1 from the records stored in the journal file 22 (S3). Next, the journal display unit 303 displays and outputs the transaction details of the commercial transaction searched by the journal search unit 302 on the display screen of the display 35 (S4). Therefore, the user can easily find a desired commercial transaction from among a large number of commercial transactions managed by the journal file 22 by setting the transaction number as a search condition.

  FIG. 6 is a conceptual diagram illustrating an example of the display screen G. As shown in FIG. 6, in the search result display area G2, a transaction detail image G21 that is read from the journal file 22 and displayed for transaction details of the commercial transaction searched by the journal search unit 302 is displayed. At this time, the journal display unit 303 arranges the transaction number at a higher position in the transaction details displayed as the transaction details image G21. As described above, when the transaction details of the commercial transaction searched by the journal search unit 302 are output, the transaction number is placed at the top and output, thereby confirming whether or not the business transaction of the transaction number as the search condition is correctly searched. It is easy to do.

  Next, the control unit 30 determines whether or not a printing instruction has been given by operating the keyboard 34 (S5). This print instruction may be an operation of a print button in the operation button region G3 on the display screen G on which the transaction detail image G21 is displayed, as shown in FIG. When a print instruction is issued (S5: YES), the journal printing unit 304 prints out the transaction details of the commercial transaction searched by the journal search unit 302 on a sheet by the printer 36 (S6).

  FIG. 7 is a conceptual diagram illustrating an example of the sheet R1. As shown in FIG. 7, in S6, the transaction details of the commercial transaction searched by the journal search unit 302, that is, the contents corresponding to the transaction details image G21 (see FIG. 6) are printed out on the paper R1. Thereby, the user can confirm the transaction details of a desired commercial transaction not only on the display screen G of the display 35 but also on the paper R1.

  Note that the program executed by the headquarter server 2 of the present embodiment is provided by being incorporated in advance in a ROM or the like. The program executed by the headquarter server 2 of the present embodiment is a file in an installable format or an executable format, and is a computer such as a CD-ROM, a flexible disk (FD), a CD-R, or 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 headquarter server 2 of the present embodiment may be configured to be provided by being stored on a computer connected to a network such as the Internet and downloaded via the network. The program executed by the headquarter server 2 of the present embodiment may be provided or distributed via a network such as the Internet.

  The program executed by the headquarter server 2 of this embodiment has a module configuration including the above-described units (search condition receiving unit 301, journal search unit 302, journal display unit 303, journal printing unit 304). As hardware, a CPU (processor) reads out a program from the ROM and executes the program, so that each unit is loaded onto the main storage device and generated on the main storage device.

  DESCRIPTION OF SYMBOLS 1 ... Control center, 2 ... Central server, 3 ... Communication network, 4 ... Store server, 5, 6 ... POS terminal, 7 ... LAN, 20 ... HDD, 21 ... PLU file, 22 ... Journal file, 30 ... Control part, 31 ... Bus, 32 ... Communication I / F, 33 ... I / O device control unit, 34 ... Keyboard, 35 ... Display, 36 ... Printer, 42a ... Transaction number storage area, 42b ... Date storage area, 42c ... Transaction details Storage area 301... Search condition reception unit 302. Journal search unit 303. Journal display unit 304. Journal printing unit F. Store G Display screen G 1 Search condition input area G 2 Search result display area , G3 ... operation button area, G21 ... transaction details image, K1 ... search start number input area, K2 ... search end number input area, R1 ... paper

JP 2011-54125 A

Claims (6)

A transaction number identifying the transaction details of a commercial transaction, date and time information indicating the date and time when the commercial transaction was performed, transaction information regarding a product sold in the commercial transaction, store information indicating a store where the transaction was performed, and a terminal that performed the commercial transaction A collecting means for collecting a journal file including terminal information from the terminals of a plurality of stores;
Search condition accepting means for accepting input of a start number and an end number of the transaction number related to a commercial transaction to be searched as a search condition for a transaction description of a commercial transaction;
Search means for searching the journal file as the transaction details, the transaction number corresponding to the transaction number from the start number to the end number received by the search condition receiving means, the date and time information, and the transaction information;
The transaction number, the date / time information, and the transaction information of the transaction details searched by the search means are used as transaction details images, and the transaction numbers corresponding to the transaction details are arranged at a higher position of the transaction details image. An output means for displaying and outputting the name of the journal file related to the transaction statement image currently being displayed ;
With
The search means searches for the transaction details having the same transaction number as the start number and the end number on condition that the start number and the end number received by the search condition receiving means are the same. Sales data processing device. It further comprises recording means for recording in the journal file the transaction details given the transaction number for each commercial transaction conducted at each store,
The search means searches the corresponding transaction details from the journal file recorded by the recording means,
The sales data processing apparatus according to claim 1, wherein the output unit reads the transaction details searched by the search unit from the journal file and displays and outputs the transaction details as the transaction details image. The transaction unit searched by the search unit is printed and output as a transaction statement image, and further includes a printing unit that prints out the transaction number corresponding to the transaction statement at a higher position of the transaction statement image.
The sales data processing device according to claim 1 or 2. Sales data processing computer
A transaction number identifying the transaction details of a commercial transaction, date and time information indicating the date and time when the commercial transaction was performed, transaction information regarding a product sold in the commercial transaction, store information indicating a store where the transaction was performed, and a terminal that performed the commercial transaction A collecting means for collecting a journal file including terminal information from the terminals of a plurality of stores;
Search condition accepting means for accepting input of a start number and an end number of the transaction number related to a commercial transaction to be searched as a search condition for a transaction description of a commercial transaction;
Search means for searching the journal file as the transaction details, the transaction number corresponding to the transaction number from the start number to the end number received by the search condition receiving means, the date and time information, and the transaction information;
The transaction number, the date / time information, and the transaction information of the transaction details searched by the search means are used as transaction details images, and the transaction numbers corresponding to the transaction details are arranged at a higher position of the transaction details image. An output means for displaying and outputting the name of the journal file related to the transaction statement image currently being displayed ;
To function,
The search means searches for the transaction details having the same transaction number as the start number and the end number on condition that the start number and the end number received by the search condition receiving means are the same. Program for. It further comprises recording means for recording in the journal file the transaction details given the transaction number for each commercial transaction conducted at each store,
The search means searches the corresponding transaction details from the journal file recorded by the recording means,
The program according to claim 4, wherein the output means reads out the transaction details searched by the search means from the journal file and displays and outputs the transaction details as the transaction details image. The transaction unit searched by the search unit is printed and output as a transaction statement image, and further includes a printing unit that prints out the transaction number corresponding to the transaction statement at a higher position of the transaction statement image.
The program according to claim 4 or 5.

Images