JPH11203509A - System for managing issuing/collection of gift coupon - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide an issuing/collection managing system for easily and securely managing the prepaid slip such as a gift coupon or the like. SOLUTION: The managing system executes a reception processing and a shipping/warehousing processing when the printed gift coupons 21 are supplied, executes issuing, generates effect as a note and executes collection after the gift coupon is collected. Thus, the history and the issued amount, the collected amount and the number of respective gift coupons are grasped/managed. The managing system is constituted of the gift coupons to which a series of ticket managing numbers which are not overlapped are given for the respective tickets, a data base where a processing corresponding to the ticket is recorded and a personal computer 11. The reception processing, the shipping/warehousing processing, the issuing processing and the collection processing of the gift coupons are recorded in the respective managing numbers of the data base.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a management system for gift certificates and gift certificates, and a system for registering data on stock, issuance, and collection of gift certificates and gift certificates, and for easily managing the history of the data on a personal computer. About. Specifically, when dealing with gift certificates and gift certificates, managing the number of issued and uncollected tickets and the number of inventory at each store,
The present invention relates to a system that compiles such data and creates total data and the like necessary for internal management and notification to a public organization.

[0002]

2. Description of the Related Art Gift certificates and gift certificates are given the same value as cash when they are issued. Therefore, each time a printed gift certificate is accepted from the time it is received until it is issued and collected, The department requires inventory management such as ledger management.

[0003] Gift certificates and the like can usually be sorted as follows depending on the condition of the ticket. Stock coupon A gift coupon that is stored in the warehouse of each store. Uncollected ticket A gift certificate sold at each store and not used. Collected ticket A gift certificate used at each store. Scrap ticket A gift certificate that is unused at each store due to soiling or loss. Miscellaneous ticket An uncollected ticket that has passed the miscellaneous accounting date. The miscellaneous billing date is determined according to a certain standard, and all tickets that exceed the reference date are miscellaneous tickets. Miscellaneous tickets: Collected tickets that have passed the date of miscellaneous collection. As described above, since the gift certificate has various states, it is unclear in accounting unless the number and the amount of money are accurately grasped for each section. Also, these vouchers are prepaid vouchers,
As described above, the issue amount, the collected amount, and the number of uncollected sheets must be totaled and reported to the Ministry of Finance at the end of the fiscal year (Act on Prepaid Certificates, etc.). In the following and in the claims, prepaid vouchers such as gift certificates, gift certificates, premium gift certificates, etc. that need to be reported to a public organization are collectively referred to as "gift certificates". It does not exclude gift certificates.

[0004] When a gift certificate is normally delivered from a delivery company such as a printing company to an issuing company (accounting department), it is processed for acceptance.
Next, the in-and-out process for issuing to each branch is performed, the issuance process is performed in each branch, and the collection process is performed at the time of collection. The comprehension became complicated, and many dedicated managers were sometimes required. Conventionally, there has been no system for accurately performing these managements, and therefore, there has been a problem that the number of stocks, an issue amount, and a collection amount cannot be accurately grasped, resulting in improper management.

[0005]

SUMMARY OF THE INVENTION Accordingly, the present invention has been made to easily and reliably perform the issuance and collection management of a gift certificate without requiring any manpower.

[0006]

The first aspect of the management system according to the present invention for solving the above-mentioned problems is that when a printed gift certificate is delivered, an acceptance process and a delivery process are performed.
After that, the issue processing is performed to generate the effect as a voucher, and the collection processing is performed after collecting the gift certificate, so that the history of each gift certificate, the stock value, the issued value, the collected value, and the number of each of them can be determined. A gift voucher issuance / collection management system characterized by grasping and managing. Because of this management system, gift certificates can be managed appropriately.

A second aspect of the management system of the present invention for solving the above-mentioned problems is that a series of gift certificates to which a series of unique ticket management numbers are assigned for each ticket type, And a personal computer, and the corresponding ticket management number of the database stores and records the history of acceptance processing, exit / entry processing, issuance processing, and collection processing of the gift certificate. Gift certificate issuance and collection management system. Because of this management system, gift certificates can be managed appropriately.

A third aspect of the management system of the present invention for solving the above-mentioned problems is a gift certificate management system. The database of the management system stores the gift certificate by the ticket management number of the gift certificate. There is provided a gift certificate issuance / collection management system, which is provided with files of a stock certificate, an issued ticket, an uncollected ticket, and a discarded ticket which can be specified. Because of this management system, gift certificates can be managed appropriately.

[0009]

DESCRIPTION OF THE PREFERRED EMBODIMENTS First, an outline of a management system according to the present invention will be described with reference to the drawings. FIG. 1 is a diagram showing a gift certificate acceptance processing state of the management system of the present invention. The devices used in the system of the present invention are basically a personal computer 11, a printer 12, a hand scanner 13 for bar codes, and a bar code / OCR reader 1.
4. It can be composed of an external storage device or the like not shown. The personal computer 11 includes a control unit, a calculation unit, and a storage unit. The personal computer 11 stores the input ticket management number, ticket type, amount, each processing date, and the like of the gift certificate in the storage unit, and stores it in each file in the external storage device. Rewrite and record. When outputting various lists and reports, the printer 12 calculates the issuance amount, the total amount of the collected amount, and the like, and outputs the calculated amount. The hand scanner 13 is a device for reading a ticket management number or the like by a barcode recorded on a gift certificate, and the barcode / OCR reader 14 is a device for reading a ticket management number by a barcode or OCR. Each device used in the system of the present invention is operated by a "gift certificate management system" which is software used in the system of the present invention. FIG. 1 illustrates a situation in which a gift certificate 21 delivered from a gift certificate delivery company to a receiving department (generally, an accounting department) of each company is inspected and then subjected to a stocking process. After the stocking process, an inventory management table and the like are output by the gift certificate management system of the present invention. The received gift certificate is then delivered to each store

FIG. 2 is a diagram showing a gift certificate issuing processing status of the management system of the present invention. Gift certificates issued to each store are sold to customers and become effective as cash vouchers.
Sales slips of gift certificates sold at each of the stores A, B,..., Z are summarized in a tabulation table 31 on a daily basis and sent to the accounting department.
The form is input to the gift certificate management system, and a management form such as an issue list and a daily report is output. FIG. 3 is a diagram showing a gift certificate collection processing state of the management system of the present invention. Gift certificates sold to customers are collected by stores in exchange for products sold by customers. At the time of collection, the store clarifies that the gift certificate 21 has been stamped or the corners have been cut off and exchanged for goods. At each store, the number is counted for each day and the number of tickets for each ticket type is recorded to create a delivery note 32, which is sent to the accounting department together with the actual gift certificate 21 collected. The data of the delivery note 32 is input to the management system, and the ticket management number of the gift certificate 21 is
The data is read by the OCR reader 14 and directly input to the management system. After the input, management forms such as a list of collected tickets and a daily report are output.

FIG. 4 is a diagram showing a situation in which various management forms are output by the management system of the present invention. As shown in FIG. 4, a situation is shown in which management forms such as a list of uncollected tickets, a daily report, a monthly report, and a term report are output. In addition, it is also possible to output a balance management table of sold and collected gift certificates, a stock table for each store, and the like.

FIG. 5 is a diagram showing an example of a gift certificate handled by the management system of the present invention. As shown in FIG. 5, the gift certificate 21 needs to be provided with a series of ticket management numbers 22 that do not overlap for each ticket type. This ticket management number can be a bar code number, an OCR code number, or the like. When issued on either side of the ticket, the expiration date is 23
May be displayed. Further, when the gift certificate is collected at the store, a seal box 24 or a cutout line 25 at the corner is usually provided to clearly distinguish the gift certificate from an uncollected gift certificate.

Hereinafter, the gift certificate management system of the present invention will be described more specifically. The "gift certificate management system" is composed of the following folders. Default A folder in which an empty data file of a data file used in the gift certificate management system is stored. Ken This is a folder in which a history file for each gift certificate is stored, and is further hierarchized for each note classification and ticket type. Rireki A folder in which a history file of each process is stored. System Folder in which contents registered in system registration are stored. Shori A folder that stores data resulting from processing such as daily reports, monthly reports, and total tables. Work Refers to a folder in which temporary files are stored.

Hereinafter, each of the above folders will be described in detail. Default folder This folder stores empty data files used in the gift certificate management system. It is prepared to obtain the necessary files for each process, and is always required for the system to operate.

Ken folder A folder in which a history file for each gift certificate such as a stock ticket, an uncollected ticket, a collected ticket, a scrapped ticket, a miscellaneous ticket, and a miscellaneous ticket is stored. Furthermore, folders are hierarchized for each one note classification and one note type. The hierarchical folder name for each note type / note type is a character string connecting the note type code and the note type code, and this folder is created when a new note type is registered. In addition, since the entire folder is deleted at the time of deleting the note classification / note type, the history data for each gift certificate is lost and the gift certificate cannot be handled at the same time. For example, if the bill classification code is “1” and the bill type code is “0003”, “0010003”
And a file such as uncollected, collected, discarded ticket, miscellaneous ticket, etc. is filed.

Rireki folder This folder stores the history files of the respective processes. The output process of the reception history, the receipt / delivery history, the issuance history, the collection history, and the scrap ticket history is performed using the files in this folder. Other than the reception history file, it is divided into monthly files. In the reception processing history file, the ticket management numbers subjected to the reception processing are continuously recorded. Since the gift certificate to be delivered is provided with a series of unique ticket management numbers, it is checked during the acceptance process whether gift certificates from the start ticket management number to the end ticket management number have not been accepted in the past. . Therefore, if you delete the ticket management number recorded in this file, there is a possibility that it will be accepted incorrectly,
Deletion from files is not allowed in principle.

System folder This is a folder for storing data files for storing the contents registered in the system registration process. These include, for example,
Voucher classification data file, ticket type data file, store /
Store-specific data file, scrap ticket classification data file, user data file, data file storing the month of monthly update processing, file storing the voucher classification registered on the voucher registration screen, voucher registered on the ticket type registration screen A file storing the seed, a file storing the store registered on the store registration screen and the settlement amount of the store, a file storing the revoked ticket classification registered on the revoked ticket classification registration screen, and a file registered on the user registration screen This file includes a file in which the user is stored.

Shori folder A folder in which data files required to output daily and monthly reports / totals and simple forms are stored. For example, a file in which the current stock ticket, uncollected ticket, miscellaneous ticket, miscellaneous ticket number, and amount are stored is a simple form of the inventory ticket, uncollected ticket, miscellaneous ticket, miscellaneous ticket list output processing. The file is created based on this file when outputting, and is also created based on this file when outputting the total table. In addition, a file for storing a monthly report, a file for storing a daily report, a data file for storing data serving as a source of a cumulative table, and the like can be provided.

Work folder A folder in which temporary files used in monthly update processing and collection / reception processing are stored. For example, a file in which the ticket management number of the gift certificate that has not yet been received (scheduled to be received / not scheduled to be received) and its batch information in the collection / reception processing, the collection ticket management number read in the monthly update processing and the collection / reception processing Can be provided for temporarily storing the number of miscellaneous bills, the number of miscellaneous bills, and the number of miscellaneous bills recorded in the monthly update process.

FIG. 6 shows the types of menus displayed when processing is performed by the present system. "Gift certificate management system"
When the user logs in, the menu shown in FIG. 6 is displayed, and each process of the display can be selected and performed. Hereinafter, main processing will be described. (1) Acceptance processing This refers to the processing of inputting the ticket management number of a gift certificate delivered from a printing company or the like, and all of the entered gift certificates become stock tickets of the (accounting) headquarters. Usually, data in which a ticket management number attached to the serial of a gift certificate to be delivered is recorded in advance is submitted from a printing company or the like to a company to be delivered. In principle, the accepting company confirms that the serial ticket management number matches the actual ticket management number attached to the gift certificate. As described above, it is preferable that the ticket management number once input cannot be deleted.

FIG. 7 is a diagram for explaining a processing flow at the time of acceptance registration. In the processing at the time of acceptance registration, the following processing is performed. It is compared with the past reception history, and it is confirmed whether or not the reception start ticket management number to the end ticket management number have already been received. If the ticket management number has already been accepted, acceptance is excluded. If the ticket does not have the accepted ticket management number, a delivery ticket management number text file is created and stored in the stock ticket table. The contents of the delivery ticket management number text file are all stored in the stock certificate table, and the delivery text file is deleted. Store the accepted content in the acceptance history table. Register the goods movement history. In the remarks column, write "accept",
Specify that the receipt occurred during the receiving process. In the daily store handling number table, the receiving date, the classification of the voucher, the type of ticket, the number of received items and the amount of money for the receiving store are stored.

FIG. 8 is a diagram for explaining a processing flow when receiving registration is deleted. When selecting from the reception history and pressing the delete button, the reception is deleted as follows. It is checked whether or not the input start ticket management number to end ticket management number are registered in the stock ticket table as stock certificates of the receiving store to be deleted. If it is registered, delete from the stock ticket table the acceptance ticket management number to the end ticket management number. Delete the selected reception history from the reception history. Delete the reception history selected from the entry / exit history. The number deleted from the daily handling number table and the stock number table is subtracted. The number deleted from the stock ticket number table is subtracted.

(2) Entry / Exit Processing This is processing for inputting the gift certificates sorted into each store from the headquarters. It is possible to input not only the transfer between the headquarters and the store but also the transfer between the stores. Sorted and input gift certificates are stored as stock certificates at each store.

FIG. 9 is a diagram for explaining a processing flow at the time of entry / exit registration. In the processing at the time of entry / exit registration, the following processing is performed. It is checked whether or not the starting ticket management number to the ending ticket management number are in the stock ticket table as the issuing store stock tickets. Overwrite the store information to the stock certificate table. In the entry / exit history table, the information (the amount and the number of sheets) issued from the outlet store and the information (the amount and the number of sheets added) received at the store are recorded. The information (the amount and the number of sheets) taken out from the outlet store and the information (the amount and the number of sheets added) received at the receiving store are recorded in the daily handling number table. The information issued from the outlet store (the amount and the number of sheets minus) and the information received at the receiving store (the amount and the number of sheets plus) are recorded in the stock ticket number table.

FIG. 10 is a diagram for explaining the processing flow at the time of canceling the entry / exit registration. The following processing is performed in the case of a warehouse cancellation. It is checked whether or not the starting ticket management number to the ending ticket management number are in the stock ticket table as receiving store stock tickets. Overwrite the store information to the stock certificate table. In the entry / exit history table, information (minus the amount / number of sheets) issued from the receiving store and information entered into the exiting store (plus the amount / number of sheets) are recorded. The information (the amount and the number of sheets) taken out from the receiving store and the information (the amount and the number of sheets added) received at the issuing store are recorded in the daily handling number table. The information (the amount and the number of sheets) taken out from the receiving store and the information (the amount and the number of sheets added) received at the issuing store are recorded in the stock number table.

(3) Issuing process This is a process of inputting a gift certificate sold (issued) at each store. Under the law, the voucher will take effect at this point. It is often the case that the sales on the day are issued collectively at the headquarters instead of the issuing process each time the price is received from the customer. Tickets issued and registered become uncollected tickets, and the expiration date is determined at the time of issuance. The expiration date can be a miscellaneous income accounting date.

FIG. 11 is a diagram for explaining a processing flow at the time of issue registration. In the processing at the time of issue registration, the following processing is performed. It is checked whether the starting ticket management number to the ending ticket management number are in the stock ticket table as issuing store stock certificates. The start ticket management number to the end ticket management number are moved from the stock ticket table to the uncollected ticket table. When moving,
Add issue history and expiration date. Record the issue history in the issue history table. The number of issued sheets and the amount of money are recorded in the daily handling number table. The number of issued tickets is negatively recorded in the stock ticket number table. The number of issued sheets is recorded in the uncollected number table plus.

FIG. 12 is a diagram for explaining a processing flow at the time of issuing registration cancellation. In the case of cancellation, the following processing is performed. It is checked whether the starting ticket management number to the ending ticket management number are in the uncollected ticket table as issuing store uncollected tickets. The start ticket management number to the end ticket management number are moved from the uncollected ticket table to the stock ticket table. When moving,
Delete issue history section and expiration date. The value and the number of canceled gift certificates are recorded as minus in the issue history table. Subtract the number of issued sheets and the amount of money to the daily handling number table. The number of issued and canceled sheets is added and recorded in the stock ticket number table. The number of unissued sheets is subtracted from the uncollected number table.

(4) Collection processing This is the processing for inputting the gift certificate collected at each store.
Read the ticket management number of the collection ticket. Reading of the ticket management number is performed by the hand scanner 13 or the barcode / OCR reader 14 (FIG. 1). FIG. 13 is a diagram illustrating a processing flow during the collection processing. Unlike other processes, the processing is performed by reading and inputting an actual gift certificate using a reading device. The collection reading process is performed by activating control software for operating the collection ticket reading device. The read data read by the reading process is stored in a text file in a predetermined text format. Collected ticket data and collection history data are created by the collection and reception process, and the collected ticket is a collected ticket.

FIG. 14 is a diagram for explaining the flow at the time of collection ticket reception processing. The file read in the collection reading process is analyzed to detect an error. This is performed by checking whether the read ticket management number is registered in the list to be received (or not to be received), and the one with an error remains without being received. If receipt is selected without error, it will be a collected ticket.

The detection of an error can be performed, for example, in the following items. Collection date error Can the collection date be recognized as a date? Store error Is the correctable store code entered? Banknote classification error Is the banknote classification code entered correctly? Issue type error Is the issue type code entered correctly? Management number error Are the check digit and number of digits of the ticket management number correct? Unissued error Is the ticket stored in the uncollected ticket table? If it is not in the uncollected ticket table, is it not stored in the miscellaneous ticket table? Recovered number error Check if the input recovered number matches the actual read number. Read duplicate error Is the same ticket read more than once? After performing the above error detection, if there is a batch with an error, display the "Received Unscheduled List" screen if there is an error, and if no errors are detected in all the batches, display the "Received Schedule List" screen. indicate. Even for a collected ticket in which an error has been detected, the same items as described above are checked at a later date. If the error has disappeared, the ticket is re-received, and the process for the next receipt is performed.

FIG. 15 is a view for explaining the flow at the time of re-reception processing. Re-reception refers to a process of checking the same content as an error detection item and receiving an error-free item. In the process at the time of re-reception, the following process is performed. Move the contents of the work collection information table to the collection history table. Find the ticket management number with the batch number moved above from the work collection ticket, and find the same ticket management number from the uncollected ticket table (or the miscellaneous ticket table if there is no one), and record the history and collection of the ticket Add a history section and move to the collected table. Record the number of collections and the amount of money collected in the daily handling number table. If the ticket is in the uncollected ticket table, the number of the uncollected tickets is subtracted from the uncollected ticket table. If the ticket is present in the miscellaneous ticket table, the number of tickets is subtracted from the miscellaneous ticket table.

[0033] Cancellation registration of the collected registration can also be performed. In this case, the following processing is performed. It is checked whether the start ticket management number to the end ticket management number are registered in the collected table as collected tickets. In the collection history table, the number and the amount of the collection canceled are negatively registered. The start ticket management number to the end ticket management number are moved from the collected ticket table to the uncollected ticket table. Subtract the collection number from the daily handling number table. Add the uncollected number table.

(5) Discarded ticket processing This refers to the processing of discarding each store stock ticket. Abolished tickets are managed for each store.

FIG. 16 is a diagram for explaining a processing flow at the time of registration of a revoked ticket. The details of registration at the time of revoked ticket registration are as follows. It is checked whether the starting ticket management number to the ending ticket management number are in the stock ticket table as the discarded store stock certificate. The start ticket management number to the end ticket management number are moved from the stock ticket table to the waste ticket table. When moving, a waste ticket history unit is added. Record the waste ticket history in the waste ticket history table. The number of discarded tickets and the amount of money are recorded in the daily handling number table. The number of discarded tickets is subtracted from the stock ticket number table.

FIG. 17 is a diagram for explaining a processing flow at the time of canceling registration of a revoked ticket. The details of registration at the time of cancellation of registration of abolished tickets are as follows. It is checked whether the starting ticket management number to the ending ticket management number are in the revoked ticket table as revoked ticket store revoked tickets. The start ticket management number to the end ticket management number are moved from the waste ticket table to the stock ticket table. When moving, the deleted ticket history section is deleted. The value and the number of canceled gift certificates are recorded as minus in the scrap ticket history table. The number of canceled tickets and the amount of money are recorded in the daily handling number table as minus. The number of discarded tickets is added to the stock ticket number table.

(6) History output processing This processing is to output each history of the above processing to a form. "Detailed form output" including the ticket management number and "simple form output" in which only the number of sheets for each ticket type necessary for managing the number of sheets can be performed. In addition, it is also possible to specify a ticket type and a store and output them. The output history list includes lists such as a reception history, a storage / reception history, an issuance history, a collection history, and a waste ticket history.

(7) Store Inventory List Output This is for browsing inventory tickets of each store, and can output a “simple store inventory list” and a “detailed store inventory list”. In the list, it is possible to input and output the note type, ticket type, and store type.

(8) Ticket history reference processing This refers to the processing of referring to the history of handled gift certificates. The state of the tickets (stock tickets, uncollected tickets, collected tickets, etc.), cash voucher classification, ticket type,
The user can input the voucher management number and the handling store and browse the history of gift certificates. The output ranges include "ticket status", "date", "cash voucher classification", "ticket type", "store",
"Sheet ticket management number" can be selected.

(9) Daily Report Output The process of outputting a daily report on a specified date, including the number of incoming and outgoing tickets, the number of issued tickets, the number of collected tickets, the number of discarded tickets, the number of inventories, etc. for each store on the specified date. It can be output on a form.

(10) Monthly Processing Monthly processing is a monthly closing processing performed at the end of the month and includes the following processing. Monthly update process Updates the specified month. In the monthly renewal processing, miscellaneous bill accounting processing (uncollected ticket → miscellaneous ticket), miscellaneous loss accounting processing (collected ticket → miscellaneous damaged ticket), and creation of a monthly report are performed. Monthly report output processing A process to output a list of the number of sheets handled each month.The number of stocks carried forward, the number of warehouses, the number of issues, the number of collections, the number of discarded / stocked, the number of miscellaneous tickets, the number of miscellaneous bills, etc. A list of the number of loss accounts can be output. Others It is possible to perform an accumulation list process, an uncollected ticket list output process, a miscellaneous ticket list output process, a miscellaneous ticket list output process, and the like.

FIG. 18 is a diagram for explaining the flow of the monthly update process. In the monthly update processing, the following processing is performed. Create monthly reports and account for miscellaneous and miscellaneous bills. The miscellaneous ticket is counted from the uncollected ticket table to the miscellaneous ticket table for a gift certificate whose closing date has exceeded the expiration date. Add a miscellaneous ticket accounting date when moving. The miscellaneous bills are calculated by moving, from the collected ticket table in the closing month, those whose collection date has exceeded the expiration date to the miscellaneous bill table. Add a date of miscellaneous bill when moving. To create a monthly report, the daily handling number table is stored for each store,
Group aggregation is performed for each voucher category and ticket type. Complete the monthly report by taking in the number counted above. The moved number of miscellaneous and miscellaneous tickets are moved to the uncollected ticket number table, miscellaneous ticket number table, and miscellaneous ticket number table.

(11) System registration A process for registering information necessary to operate the system of the present invention. Store registration for registering a store name, etc., and registration of a cash voucher classification and a ticket type of a gift certificate to be handled. When performing banknote classification and ticket type registration, user registration for registering the user code that operates the system, and disposal of waste tickets, the classification (stain,
Lost and damaged) registrations are available.

[0044]

DESCRIPTION OF THE PREFERRED EMBODIMENTS (Embodiments) Hereinafter, embodiments of the processing of the management system of the present invention will be described with reference to display screens and the like. FIG. 19 shows an input screen at the time of the receiving process. At the time of acceptance processing, from the printing company that delivers gift certificates, etc.
The voucher classification, ticket type, ticket management number, total number, total value of the gift certificate, and the like are input, and the data file is provided simultaneously with the gift certificate of the product. For example, on the input screen at the time of the reception process in FIG. 19, it is displayed that 1000 pieces of gift certificates with a unit price of 1000 yen have been delivered on July 18, 1997, and the fields of the ticket management number include 000101 to 000106. Is displayed (a part of 1000 tickets).
The number at the end of the ticket management number is a check digit. The ticket management number is compared with the actual gift certificate management number, and if there is no mistake, the arrow button 191 is clicked. Thereby, the receiving process is determined.

FIG. 20 shows an input screen at the time of the entry / exit processing. In the entry / exit process, when a ticket type (unit price, etc.) and the number of sheets required at each store are input, the entry / exit process between stores including the head office (accounting department) is performed. In FIG. 20, it is displayed that 1000 1,000 yen tickets are issued from the head office to the Tokyo office, but if there is no problem in this processing, the down arrow button 201 will be clicked. The in-and-out processing can be performed in the reverse direction. For example, the in-and-out processing can be performed from the Tokyo store to the main store. In this case, the user clicks the upward arrow button 202. These processes are, of course, problems in the management ledger, and the actual physical ticket is moved between stores based on this process.

FIG. 21 shows an input screen at the time of issuing processing.
As described above, the gift certificate issued to each store is sold to the customer and becomes effective as a cash voucher. Sales slips of gift certificates sold at each store are compiled in a tabulation table 31 on a daily basis, sent to the accounting department, and input to the gift certificate management system. As shown in the screen of FIG. 21, if the number of issued 1000-yen gift certificates at the Tokyo store is 500, after inputting such numbers, the user clicks the downward arrow button 211. With this operation, the expiration date of the gift certificate issued on the day (March 31, 2002) is also input, and the number of uncollected gift certificates is also increased from 1500 to 2000.
It will be changed to sheets. Note that the upward arrow button 212 is for canceling the issuing process.
Although the description of the embodiment is omitted for the input screen and the like after the collection process, it can be performed in the same manner as the entry / exit process and the issue process.

Next, an example of a management list and a report output by the management system of the present invention will be described. FIG.
FIG. 23 is a diagram showing a stock certificate list (simple), and FIG. 23 is a diagram showing a stock certificate list (details). In the simple list, the number of tickets for each ticket type at each store is displayed, and in the detailed list, the management numbers of the gift certificates to be stocked for each ticket type are displayed. FIG. 24 is a diagram showing an uncollected ticket list (simple), and FIG. 25 is a diagram showing an uncollected ticket list (details). Similarly, in the simple list, the number of tickets for each ticket type at each store is displayed, and in the detailed list, the management numbers of the gift certificates to be stocked for each ticket type are displayed.
FIG. 26 is a diagram illustrating an example of a monthly report. The number and the amount of money are displayed for the number of stocks carried over the previous month, the number of warehouses in and out (the current month), issued tickets, collection tickets, scrap tickets, stock certificates for the month, miscellaneous tickets and miscellaneous tickets at the headquarters. Have been.

The management system of the present invention can output not only the above-described list and report but also various other lists required for the management of gift certificates, reports and the like required for notification of a public organization. It is.

[0049]

According to the gift certificate management system of the present invention, the management is performed based on the unique gift certificate management number for each ticket type, and each of the actual gift certificate acceptance, entry / exit, issue, and collection is performed. By performing the input processing sequentially each time the processing is performed, it is possible to perform the issuing and collection management of the gift certificate without error.
Further, the gift certificate management system of the present invention can be processed by a personal computer without the need for a large-sized computer, so that the management can be easily performed without requiring a specialized person or a large number of personnel. Further, the gift certificate management system according to the present invention can easily output various lists, reports, and reports from public institutions required for management, thereby reducing office work.

[Brief description of the drawings]

FIG. 1 is a diagram showing a gift certificate acceptance processing state of a management system of the present invention.

FIG. 2 is a diagram showing the status of a gift certificate issuance process of the management system of the present invention.

FIG. 3 is a diagram showing a gift certificate issuance processing status of the management system of the present invention.

FIG. 4 is a diagram showing a situation in which various management forms are being output by the management system of the present invention.

FIG. 5 is a diagram showing an example of a gift certificate handled by the management system of the present invention.

FIG. 6 shows the types of menus displayed when processing is performed by the present system.

FIG. 7 is a diagram illustrating a processing flow at the time of acceptance registration.

FIG. 8 is a diagram illustrating a processing flow at the time of acceptance registration deletion.

FIG. 9 is a diagram illustrating a processing flow at the time of entry / exit registration.

FIG. 10 is a diagram illustrating a processing flow at the time of canceling the entry / exit registration.

FIG. 11 is a diagram illustrating a processing flow at the time of issue registration.

FIG. 12 is a diagram illustrating a processing flow at the time of issuing registration cancellation.

FIG. 13 is a diagram illustrating a processing flow during the collection processing.

FIG. 14 is a diagram illustrating a flow at the time of collection ticket reception processing.

FIG. 15 is a diagram illustrating a flow at the time of re-reception processing.

FIG. 16 is a diagram illustrating a processing flow at the time of revoked ticket registration.

FIG. 17 is a diagram illustrating a processing flow at the time of canceling registration of a revoked ticket.

FIG. 18 is a diagram illustrating a flow of a monthly update process.

FIG. 19 is an input screen at the time of an acceptance process.

FIG. 20 is an input screen at the time of the entry / exit processing.

FIG. 21 is an input screen at the time of issuing processing.

FIG. 22 is a diagram showing a stock certificate list (simple).

FIG. 23 is a diagram showing a stock certificate list (details).

FIG. 24 is a diagram showing an uncollected ticket list (simple).

FIG. 25 is a diagram showing an uncollected ticket list (details).

FIG. 26 is a diagram showing an example of a monthly report.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 11 Personal computer 12 Printer 13 Hand scanner 14 Barcode / OCR reader 21 Gift certificate 22 Ticket management number 23 Expiration date 24 Sealing box 25 Cut-out line 31 Total table 32 Sending document 191, 201, 202, 211, 212 Click button

Claims (6)

[Claims] 1. When a printed gift certificate is delivered, an acceptance process and a delivery / reception process are performed, thereafter, an issuing process is performed to generate an effect as a cash voucher, and after the gift certificate is collected, A gift certificate issuance / collection management system characterized by grasping and managing the history, stock value, issuance value, collection amount, and the number of each gift certificate by performing a collection process. 2. The gift certificate issuing / collecting management system according to claim 1, wherein a status of the issuing process and the collecting process is output to a form. 3. A gift certificate is provided with a series of unique ticket management numbers for each ticket type.
Gift certificate issuance and collection management system described. 4. A gift certificate having a series of unique ticket management numbers for each ticket type, a database in which processing corresponding to the ticket management number is recorded, and a personal computer. The ticket management number includes
A gift certificate issuance / collection management system, in which a history of receipt processing, exit / inbound processing, issuance processing, and collection processing of the gift certificate is accumulated and recorded. 5. A gift certificate management system, wherein a database of the gift certificate includes a stock certificate, an issued ticket, an uncollected ticket, and a waste card that can specify the gift certificate by a ticket management number of the gift certificate. A gift voucher issuance / collection management system, wherein each file of the voucher is provided. 6. The gift certificate issuing / collecting management system according to claim 4, wherein the ticket management number of the gift certificate once input cannot be deleted from the database in principle.