JP4220006B2 - Gift certificate management system - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a gift certificate and gift certificate management system, and relates to a system for registering inventory, issuance, and collection data of gift certificates and gift certificates, and managing their history simply with a personal computer. Specifically, when handling gift certificates and gift certificates, manage the number of issued and uncollected tickets and the number of stocks in each store, and aggregate those data for internal management and public institutions. The present invention relates to a system for creating aggregate data necessary for reporting to a company.
[0002]
[Prior art]
Gift certificates and gift certificates are given the same value as cash when they are issued, so each department manages the ledger from when a printed gift certificate is received until it is issued and collected. Inventory management is required.
[0003]
Gift certificates and the like can usually be sorted as follows according to the state of the ticket.
(1) Stock voucher A gift voucher stored in the warehouse of each store.
(2) Uncollected tickets Gift certificates that are sold at each store and are not used.
(3) Collected tickets Refers to gift certificates used at each store.
(4) Disused ticket Refers to a gift certificate that has become unused at each store due to corruption or loss.
(5) Miscellaneous ticket An uncollected ticket that has passed the miscellaneous recording date. The miscellaneous recording date is determined according to a certain standard, and all tickets exceeding the standard date are regarded as miscellaneous tickets.
(6) Miscellaneous ticket Refers to a collected ticket that exceeds the date of accrual.
As described above, since there are various states of gift certificates, it is unclear for accounting unless the number and amount of money are accurately grasped for each category.
In addition, these vouchers fall under the prepaid type voucher, and as described above, the issue amount, the collected amount, and the number of uncollected items are counted and reported to the Ministry of Finance at the end of the fiscal year (Act on Regulations for Prepaid Voucher) .
In the following and claims, pre-payment-type vouchers such as gift certificates, gift certificates, premium gift certificates, etc. that need to be reported to public institutions are collectively referred to as `` gift certificates ''. It does not exclude gift certificates.
[0004]
A gift certificate is usually processed when it is delivered from a delivery company such as a printing company to an issuing company (accounting department), and then it is processed for delivery to and from each branch, and issued at each branch. The collection process is performed at the time of collection. However, it is sometimes necessary to have a large number of full-time managers because it is complicated to grasp the actual inventory amount and issue amount due to the inbound and outbound between branches. Conventionally, since there has been no system for accurately performing these managements, there has been a problem that the number of stocks, the amount of money to be issued, and the amount of money to be collected cannot be accurately grasped and management becomes inappropriate.
[0005]
[Problems to be solved by the invention]
Therefore, the present invention has been made in order to easily and reliably perform gift certificate issuance / collection management without requiring manual labor.
[0006]
[Means for Solving the Problems]
A first aspect according to the present invention for solving the above problem is a computer system for managing a gift certificate composed of at least one kind of ticket, Inventory voucher table that records information on gift certificates delivered , Information on gift certificates moved from the inventory ticket table Expiration date information Added An uncollected ticket table for recording information; The deadline is expiration date Beyond Gift certificates of A miscellaneous ticket table for recording information and collected gift certificates of Collected ticket table to record information and collection Day expiration date Beyond Gift certificates of A miscellaneous ticket table that records information, a history table, and scrap Store inventory ticket of Storage means for storing a waste ticket table for recording information; Issue Accept input, For gift certificates with accepted issuance inputs Whether the information is a stock voucher table Not yet In the collection ticket table Move, add expiry date information to the information of the gift certificate that has been moved, Issuance management means to be registered and uncollected ticket table If the expiry date of the gift certificate information exceeds the closing date, this expiration date has exceeded the closing date. Gift certificates Information On the miscellaneous ticket table Move A miscellaneous ticket table maintenance management means, Accept collection input and accept collection input The Of gift certificates Whether the information is uncollected ticket table Times To the collected ticket table Move Gift certificate collection management means to collect and gift certificate collected of expiration date If the deadline has passed, expiration date Has passed the deadline Gift certificates Information From the miscellaneous ticket table Miscellaneous On the non-ticket table Move Miscellaneous ticket management means, Scrapped ticket Accept input, inventory card table Et On the scrap ticket table Accepted Scrapped ticket input The Have Gift certificate information Move And a history registration unit that creates record information of processing performed by each of the previous management units and registers it in a history table.
The second aspect of the present invention is the gift certificate management system according to claim 1, wherein the issuing process and the collecting process status are output to a form.
A third aspect of the present invention is the gift certificate management system according to claim 1, wherein a series of ticket management numbers that do not overlap each other are attached to the gift certificate.
A fourth aspect according to the present invention is a computer system that manages a gift certificate to which a series of non-overlapping ticket management numbers are attached for each ticket type, Inventory voucher table that records information on gift certificates delivered , Information on gift certificates moved from the inventory ticket table Expiration date information Added An uncollected ticket table for recording information; The deadline is expiration date Beyond Gift certificates of A miscellaneous ticket table for recording information and collected gift certificates of Collected ticket table to record information and collection Day expiration date Beyond Gift certificates of A miscellaneous ticket table that records information, a history table, and scrap Store inventory ticket of Storage means for storing a waste ticket table for recording information; Issuing from start ticket management number to end ticket management number Accept input, Accepted Has ticket management number Gift certificate information A stock voucher table or Not yet In the collection ticket table Move, add expiry date information to the information of the gift certificate that has been moved, Issuance management means to be registered and uncollected ticket table Gift certificate information has expiration date If the expiry date of the gift certificate exceeds the closing date, information Miscellaneous To the ticketing table Move A miscellaneous ticket table maintenance management means, Received and accepted collection input from the start ticket management number to the end ticket management number Ticket management number Information on gift certificates with Uncollected ticket table Times To the collected ticket table Move Gift certificate collection management means, If the expiry date of the collected gift certificate exceeds the closing date, the gift certificate whose expiration date exceeds the closing date Information on miscellaneous ticket table Miscellaneous On the non-ticket table Move Miscellaneous ticket management means, Starting ticket management number-end Ticket management number Used tickets until Accept input, inventory card table Abolished On ticket table Accepted Includes ticket management number Musho Gift certificate information Move And a history registration unit that creates record information of processing performed by each of the previous management units and registers it in a history table.
According to a fifth aspect of the present invention, there is provided a computer system for managing a gift certificate to which a ticket management number specifying a gift certificate is attached. Inventory voucher table that records information on gift certificates delivered , Information on gift certificates moved from the inventory ticket table Expiration date information Added An uncollected ticket table for recording information; The deadline is expiration date Beyond Gift certificates of A miscellaneous ticket table for recording information and collected gift certificates of Collected ticket table to record information and collection Day expiration date Beyond Gift certificates of A miscellaneous ticket table that records information, a history table, and scrap Store inventory ticket of Storage means for storing a waste ticket table for recording information; Issuing from start ticket management number to end ticket management number Accept input, Accepted Has ticket management number Gift certificate information A stock voucher table or Not yet In the collection ticket table Move, add expiry date information to the information of the gift certificate that has been moved, Issuance management means to be registered and uncollected ticket table Gift certificate information has expiration date If the expiry date of the gift certificate exceeds the closing date, information Miscellaneous To the ticketing table Move Miscellaneous ticket Table maintenance Management means; Received and accepted collection input from the start ticket management number to the end ticket management number Ticket management number Information on gift certificates with Uncollected ticket table Times To the collected ticket table Move Gift certificate collection management means, If the expiry date of the collected gift certificate exceeds the closing date, the gift certificate whose expiration date exceeds the closing date Information on miscellaneous ticket table Miscellaneous On the non-ticket table Move Miscellaneous ticket management means, Starting ticket management number-end Ticket management number Used tickets until Accept input, inventory card table Abolished On ticket table Accepted Includes ticket management number Musho Gift certificate information Move A gift certificate management system comprising: a waste ticket management unit that performs processing and a history registration unit that creates record information of processing performed by each of the previous management units and registers the information in a history table.
According to a sixth aspect of the present invention, the storage means stores an acceptance history table in which the ticket management number of the recorded gift certificate cannot be deleted, and accepts input of gift certificate acceptance information including the ticket management number, 6. The gift certificate management system according to claim 4, further comprising gift certificate acceptance management means for recording in an inventory ticket table and an acceptance history table.
[0009]
DETAILED DESCRIPTION OF THE INVENTION
First, the outline of the management system of the present invention will be described with reference to the drawings.
FIG. 1 is a diagram showing a gift certificate receiving process status of the management system of the present invention. The apparatus used in the system of the present invention can basically be composed of a personal computer 11, a printer 12, a bar code hand scanner 13, a bar code / OCR reader 14, an external storage device not shown. The personal computer 11 includes a control unit, a calculation unit, and a storage unit. The personal computer 11 accumulates the ticket management number, ticket type, amount of money, each processing date, etc. of the input 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 issued amount, the accumulated amount of the collected amount, etc. are calculated and output from the printer 12. 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 goods voucher 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 warehousing processing. After the warehousing process, an inventory management table or the like is output by the gift certificate management system of the present invention. The gift certificate that has been processed is then issued to each store.
[0010]
FIG. 2 is a diagram showing a gift certificate issuance processing status of the management system of the present invention. The gift certificate issued at each store is sold to the customer and becomes effective as a cash voucher. The sales slips of the gift certificates sold at each store A, B, .., Z are summarized daily in the aggregation table 31 and sent to the accounting department. The management form is output.
FIG. 3 is a diagram showing the gift certificate collection processing status of the management system of the present invention. The gift certificate sold to the customer is collected at the store by exchanging it with a product sold by the customer at the store. At the time of collection, the store either stamps the gift certificate 21 or cuts out the corner to clarify that it has been exchanged for the product. At each store, the total number is calculated by daily closing, the number of each ticket type is recorded, a delivery form 32 is created, and sent together with the collected gift certificate 21 to the accounting department. The data of the delivery form 32 is input to the management system, and the ticket management number of the gift certificate 21 is also read by the barcode / OCR reader 14 and directly input to the management system. After the input, management forms such as a collection ticket list and daily reports are output.
[0011]
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, daily reports, monthly reports, and quarterly reports are output. In addition, it is also possible to output a balance management table of sold and collected gift certificates, an inventory table for each store, and the like.
[0012]
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 have 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 or an OCR code number. The expiration date 23 may be displayed on the front or back of the ticket when it is issued. Further, when the gift certificate is collected at the store, a stamping column 24 or a cut line 25 at the corner is usually provided in order to clarify the distinction from the uncollected gift certificate.
[0013]
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.
(1) Default A folder in which empty data files of data files used in the gift certificate management system are stored.
{Circle around (2)} Ken This is a folder in which a history file for each gift certificate is stored, and is further hierarchized for each cash voucher category and ticket type.
(3) Rireki This is a folder in which a history file for each process is stored.
(4) System Folder for storing contents registered by system registration.
(5) Shori A folder that stores data such as daily reports, monthly reports, and cumulative tables.
(6) Work A folder in which temporary files are stored.
[0014]
Hereinafter, each of the above folders will be described in detail.
(1) Default folder
A folder in which empty data files used in the gift certificate management system are stored. It is prepared to acquire files necessary for each process, and is absolutely necessary to operate the system.
[0015]
(2) Ken folder
It is a folder that stores a history file for each gift certificate of inventory tickets, uncollected tickets, collected tickets, scrapped tickets, miscellaneous tickets, and miscellaneous tickets. Folders are hierarchized for each ticket type. The hierarchical folder name for each voucher category / ticket type is a character string connecting the voucher category code and the ticket type code. This folder is created when a new ticket type is registered. In addition, when deleting the voucher classification and the ticket type, since the entire folder is deleted, the history data for each gift certificate is lost and the gift certificate cannot be handled at the same time.
For example, if the voucher classification code is “1” and the ticket type code is “0003”,
A code such as “0010003” is attached, and the file is classified into non-collected, collected, discarded tickets, miscellaneous tickets, and the like.
[0016]
(3) Rireki folder
It is a folder in which a history file of each process is stored, and the output process of the reception history, the loading / unloading history, the issue history, the collection history, and the waste ticket history is output using the files in this folder. Other than the acceptance history file, it is divided into monthly files.
In the acceptance processing history file, the acceptance management ticket management numbers are continuously recorded. The gift certificate to be delivered has a series of ticket management numbers that do not overlap, so at the time of acceptance processing, check whether the gift certificate from the start ticket management number to the end ticket management number has been accepted in the past . Therefore, if the ticket management number recorded in this file is deleted, there is a possibility that it will be accepted erroneously, so that the deletion from the file cannot be performed in principle.
[0017]
(4) System folder
This folder stores data files that store the contents registered in the system registration process. These include, for example, cash voucher classification data file, ticket type data file, store / store data file, scrap ticket classification data file, user data file, data file storing the monthly updated month, and cash voucher registration screen. In the file where the registered cash voucher category is stored, the file where the voucher type registered on the voucher registration screen is stored, the file registered at the store registration screen and the settlement amount of the store, the waste voucher category registration screen A file that stores the registered waste ticket classification, a file that stores the registered user on the user registration screen, and the like are included.
[0018]
(5) Shori folder
A folder in which data files necessary to output daily, monthly reports, cumulative tables, and simple forms are stored.
For example, a file that stores the current inventory ticket, uncollected ticket, miscellaneous ticket, number of miscellaneous tickets and amount of money is a simple form of inventory ticket, uncollected ticket, miscellaneous ticket, miscellaneous ticket list output process. It is created based on this file when it is output, and it is also created based on this file when the cumulative table is output. In addition, a file for storing a monthly report, a file for storing a daily report, a data file for storing data that is the basis of a cumulative table, and the like can be provided.
[0019]
▲ 6 ▼ Work folder
A folder that stores temporary files used in monthly update processing and collection receipt processing.
For example, the ticket management number and batch information of gift certificates that have not been received yet (scheduled / not scheduled to be received) in the collection receipt process, the file that stores the batch information, and the collection ticket management number read in the monthly update process and collection receipt process This file is used for temporarily storing a file, and a file used for counting daily reports, miscellaneous tickets, and counting the number of miscellaneous tickets can be provided in the monthly update process.
[0020]
FIG. 6 shows the types of menus displayed when processing is performed in this system.
The “gift certificate management system” displays the menu of FIG. 6 upon login, and can select and perform each process of display. Hereinafter, main processes will be described.
(1) Acceptance processing
This refers to the process of entering the ticket management number of a gift certificate delivered by a printing company or the like, and all the gift certificates entered are stock certificates at the (accounting) headquarters. Usually, data in which a ticket management number attached to the serial number of a gift certificate to be delivered is recorded in advance is submitted from a printing company or the like to a company that delivers it. In principle, the receiving 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 entered cannot be deleted.
[0021]
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.
{Circle around (1)} Checking with the past acceptance history, it is confirmed whether the acceptance start ticket management number to the end ticket management number have already been accepted. In the case of an already accepted ticket management number, acceptance is excluded.
{Circle around (2)} If the ticket has not been accepted, a delivery ticket management number text file is created and stored in the inventory ticket table.
(3) Store all the contents of the delivery ticket management number text file in the inventory ticket table and delete the delivery text file.
(4) Store the accepted contents in the acceptance history table.
(5) Register the entry / exit history. Indicate "accept" in the remarks column and indicate that the receipt occurred in the acceptance process.
(6) The date of receipt, the number of receipts and the amount of money received for the receipt store are stored in the daily store handling number table.
[0022]
FIG. 8 is a diagram for explaining the processing flow when the acceptance registration is deleted. When selecting from the acceptance history and pressing the delete button, acceptance deletion is executed as follows.
(1) It is checked whether or not the input start ticket management number to the end ticket management number are registered in the stock ticket table as stock tickets of the receiving store to be deleted.
(2) If registered, delete the receipt ticket management number to the termination ticket management number from the inventory ticket table.
(3) Delete the acceptance history selected from the acceptance history.
(4) Delete the receipt history selected from the entry / exit history.
(5) The deleted number is subtracted from the daily handling number table and the inventory ticket number table.
(6) Subtract the deleted number from the inventory ticket number table.
[0023]
(2) Entry / exit processing
Refers to the process of inputting gift certificates sorted from the headquarters to each store. In addition to the transfer between headquarters and stores, it is also possible to input transfer between stores. The gift certificates that are classified and input are stored as stock certificates of each store.
[0024]
FIG. 9 is a diagram illustrating a processing flow at the time of entry / exit registration. In the process at the time of entry / exit registration, the following process is performed.
(1) It is checked whether or not the starting ticket management number to the ending ticket management number are in the inventory ticket table as issuing store inventory certificates.
(2) Overwrite the store information on the inventory ticket table.
(3) Record information (amount and number minus the amount) from the departure store and information (amount and number plus) entered at the entry store in the entry / exit history table.
(4) Record information (amount of money / number of sheets minus) from the store of delivery and information (amount of money / number of sheets plus) of goods received at the store of entry in the daily handling number table.
(5) The information issued from the issuing store (amount and number are minus) and the information received at the receiving store (amount and number are added) are recorded in the inventory ticket number table.
[0025]
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 goods movement.
(1) Check whether the starting ticket management number to the ending ticket management number are in the inventory ticket table as warehousing store inventory tickets.
(2) Overwrite the store information on the inventory ticket table.
{Circle around (3)} The information issued from the warehousing store (minus amount / number of sheets) and the information entered into the warehousing store (plus the amount / number of sheets) are recorded in the warehousing / receipt history table.
(4) Record information (amount of money / number of sheets minus) from the store of entry and information (amount of money / number of sheets plus) of goods received at the store of delivery in the daily handling number table.
(5) Record information (amount of money / number of sheets minus) from the store of receipt and information (amount of money / number of sheets plus) of goods received at the store of delivery in the inventory number table.
[0026]
(3) Issuing process
This refers to the process of inputting (issued) gift certificates sold at each store. Legally, it will be effective as a voucher at this point. Rather than issuing each time when a price is received from a customer, the actual sales are often issued at the headquarters in a lump. The issued and registered ticket becomes an uncollected ticket, and the expiration date is determined at the time of issue. The expiration date may be the miscellaneous income recording date.
[0027]
FIG. 11 is a diagram illustrating a processing flow at the time of issue registration. In the process at the time of issue registration, the following process is performed.
(1) Check whether the starting ticket management number to the ending ticket management number are in the inventory ticket table as issued store inventory certificates.
(2) Move from the start ticket management number to the end ticket management number from the inventory ticket table to the uncollected ticket table. When moving, issue history and expiration date are added.
(3) Record the issue history in the issue history table.
(4) Record the issued number and amount in the daily handling number table.
(5) Record the number of issued sheets minus in the inventory ticket number table.
(6) Record the number of issued sheets plus in the uncollected number table.
[0028]
FIG. 12 is a diagram for explaining the processing flow at the time of canceling the issuance registration. In the case of issuance cancellation, the following processing is performed.
(1) Check whether the starting ticket management number to the ending ticket management number are in the uncollected ticket table as issued store uncollected tickets.
(2) Move from the start ticket management number to the end ticket management number from the uncollected ticket table to the inventory ticket table. When moving, the issue history part and the expiration date are deleted.
(3) Record the amount and number of gift certificates canceled in the issuance history table in minus.
(4) Subtract the issued number and amount from the daily handling number table.
(5) The number of issued and canceled tickets is added and recorded in the inventory ticket number table.
(6) Subtract and record the number of issued / cancelled items in the uncollected number table.
[0029]
(4) Collection processing
This refers to the process of inputting the gift certificate collected at each store, and reads the ticket management number of the collected ticket. The ticket management number is read by the hand scanner 13 or the barcode / OCR reader 14 (FIG. 1).
FIG. 13 is a diagram illustrating a processing flow at the time of collection processing. Unlike other processes, it is performed by reading and inputting an actual gift certificate using a reader. The collection reading process is performed by starting control software for operating the collection ticket reading apparatus. 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 receipt process, and the collected ticket becomes a collected ticket.
[0030]
FIG. 14 is a diagram for explaining the flow at the time of collection ticket reception processing. Analyzes the file read by the recovery reading process and detects errors. This is done by checking whether or not the read ticket management number is registered in the list of receipt schedules (or not scheduled to be received), and those with errors will remain unreceived. If there is no error and receipt is selected, the ticket will be collected.
[0031]
For example, the error can be detected by the following items.
(1) Collection date error Is the collection date recognized as a date?
(2) Store error Is the recoverable store code correctly entered?
(3) Cash voucher classification error Is the cash voucher classification code entered correctly?
(4) Ticket type error Is the ticket type code entered correctly?
(5) Management number error Is the check digit and number of digits of the ticket management number correct?
(6) Unissued error Is the ticket stored in the uncollected ticket table? If it is not in the uncollected ticket table, is it stored in the miscellaneous ticket table?
(7) Collected sheet number error Does the entered collected sheet number match the actual number of scanned sheets?
(8) Duplicate reading error Is the same ticket read more than once?
After performing error detection as described above, if there are batches with errors, the “Not scheduled to receive list” screen is displayed. If no errors are detected in all batches, the “Scheduled to receive list” screen is displayed. indicate.
Even for a recovered ticket in which an error has been detected, items similar to the above are checked at a later date, and if there are no errors, they are re-received and processed upon the next receipt.
[0032]
FIG. , Received It is a figure explaining the flow at the time of a process. Processing upon receipt is as follows. In addition, Re-acknowledgment refers to the process of checking the same contents as error detection items and receiving those that have no errors. It is a thing The following processing is performed.
(1) The contents of the work collection information table are moved to the collection history table.
(2) Find the ticket management number with the batch number moved above from the work collection ticket, search for the same ticket management number from the uncollected ticket table (if not available, the miscellaneous ticket table), and collect and collect the ticket history. Add history section and move to collected table.
(3) Record the number of collected sheets and the amount collected in the daily handling number table.
(4) If the ticket is in the uncollected ticket table, the number of tickets is subtracted from the uncollected ticket number table.
(5) If the ticket is in the miscellaneous ticket table, the ticket number is subtracted from the miscellaneous ticket table.
[0033]
It is also possible to perform cancellation registration of the collected registration, and in this case, the following processing is performed.
(1) Check whether the starting ticket management number to the ending ticket management number are registered in the collected table as collected tickets.
{Circle around (2)} The number and the amount of money cancelled are registered in the collection history table.
(3) Move from the collected ticket table to the uncollected ticket table from the starting ticket management number to the ending ticket management number.
(4) The number of collected sheets is subtracted from the daily handling number table.
(5) Add the uncollected number table.
[0034]
(5) Waste ticket processing
Refers to the process of turning off each store inventory ticket. Waste tickets are managed for each store.
[0035]
FIG. 16 is a diagram illustrating a processing flow at the time of scrap ticket registration. The contents of registration performed at the time of scrap ticket registration are as follows.
(1) Check whether the starting ticket management number to the ending ticket management number are in the inventory ticket table as scrap ticket store inventory tickets.
(2) Move from the start ticket management number to the end ticket management number from the inventory ticket table to the scrap ticket table. When moving, a waste ticket history part is added.
(3) Record the used ticket history in the used ticket history table.
(4) Record the number of used tickets and the amount in the daily handling number table.
(5) Subtract the number of discarded tickets from the inventory ticket number table.
[0036]
FIG. 17 is a diagram for explaining a processing flow at the time of canceling the waste ticket registration. The registration details performed when canceling the registration of scrapped tickets are as follows.
{Circle around (1)} Check whether the starting ticket management number to the ending ticket management number are in the scrap ticket table as scrap ticket store scrap tickets.
(2) Move from the start ticket management number to the end ticket management number from the scrap ticket table to the stock ticket table. When moving, delete the scrap ticket history section.
(3) Record the amount and number of canceled gift certificates in the scrapped ticket history table as negative.
(4) Record the number of discarded ticket cancellations and the amount of money in the daily handling number table in minus.
(5) Add the number of canceled tickets to the inventory ticket number table.
[0037]
(6) History output processing
This refers to a process of outputting a form of each history of the above processes. “Detailed form output” including the ticket management number and “simple form output” that outputs only the number of each ticket type necessary for managing the number of sheets can be performed. It is also possible to output by specifying the ticket type and the store.
The output history list includes (1) acceptance history, (2) entry / exit history, (3) issuance history, (4) collection history, and (5) waste ticket history.
[0038]
(7) Store inventory list output
This is for browsing the inventory tickets of each store, and can output "simple store inventory list" and "detailed store inventory list". The list can be output by inputting the voucher classification, ticket type, and store type.
[0039]
(8) Ticket history reference processing
Refers to the history of the gift certificate. Enter the ticket status (inventory ticket, unrecovered ticket, recovered ticket, etc.), cash voucher classification, ticket type, ticket ticket management number, handling store, and gift certificate history. Can be viewed. As a range to be output, “ticket state”, “date”, “cash voucher classification”, “ticket type”, “store”, and “ticket ticket management number” can be selected.
[0040]
(9) Daily report output
In the process of outputting the daily report on the specified date, the number of warehousing / deleting items, the number of issued items, the number of collected items, the number of discarded tickets, the number of stocks, etc. for each store on the specified date can be output on the form.
[0041]
(10) Monthly processing
Monthly processing is monthly closing processing performed at the end of the month, and includes the following processing.
(1) Monthly update process Updates the specified month. In the monthly renewal process, miscellaneous ticket counting process (unrecovered ticket → miscellaneous ticket), miscellaneous loss accounting process (collected ticket → miscellaneous ticket), and monthly report creation.
(2) Monthly report output process This is a process for outputting a list of the number of handled items for each month. The number of inventory carried forward, the number of goods in and out of the previous month, the number of issued items, the number of collected items, the number of used tickets / inventories, miscellaneous tickets are counted for each store. A list of the number of sheets and the number of miscellaneous items recorded can be output.
(3) Others Cumulative list processing, uncollected ticket list output processing, miscellaneous ticket list output processing, miscellaneous ticket list output processing, and the like can be performed.
[0042]
FIG. 18 is a diagram for explaining the flow of the monthly update process. In the monthly update process, the following process is performed.
(1) Prepare monthly reports and record miscellaneous goods and miscellaneous tickets.
(2) Counting miscellaneous tickets is moved from the uncollected ticket table to the miscellaneous ticket table for gift certificates whose deadline has exceeded the expiration date. Add miscellaneous ticketing date when moving.
(3) In order to count miscellaneous tickets, items whose collection date exceeds the expiration date are moved from the collected ticket table in the closing process month to the miscellaneous ticket table. Add the date on which the miscellaneous ticket is recorded when moving.
(4) To create a monthly report, group the daily handling number table by store, by cash voucher, and by ticket type. Capture the number counted above and complete the monthly report.
(5) The moved miscellaneous ticket number and the number of miscellaneous tickets are moved to the uncollected ticket number table, the miscellaneous ticket number table, and the miscellaneous ticket number table.
[0043]
(11) System registration
Refers to the process of registering information necessary to operate the system of the present invention, (1) store registration for registering store names, etc., (2) cash voucher classification for handling gift certificates and voucher classification -Ticket type registration, (3) User registration for registering the user code for operating the system, (5) Waste ticket category registration for registering the classification (stained, lost, damaged) when performing waste ticket processing, etc. There is.
[0044]
【Example】
(Example)
Hereinafter, an embodiment of processing of the management system of the present invention will be described with reference to a display screen or the like.
FIG. 19 is an input screen at the time of acceptance processing. At the time of acceptance processing, the data file is provided at the same time as the gift certificate of the product by entering the receipt date, ticket classification, ticket type, ticket management number, total number of sheets, total amount of gift certificate, etc. from the printing company that delivers the gift certificate The
For example, on the input screen at the time of acceptance processing in FIG. 19, it is displayed that 1000 gift certificates with a unit price of 1000 yen were delivered on July 18, 1997, and in the column of the ticket management number, from 00001 to 000106 Ticket management number (a part of 1000) is displayed. The number at the end of the ticket management number is a check digit. If there is no mistake in comparing the ticket management number with the actual management number of the gift certificate, an arrow button 191 is clicked. As a result, the acceptance process is confirmed.
[0045]
FIG. 20 is an input screen at the time of entry / exit processing. In the loading / unloading process, when a ticket type (ticket unit price, etc.) required at each store and the number of sheets are input, a loading / unloading process between stores including the head office (accounting department) is performed. In FIG. 20, it is displayed that 1000 1000-yen coupons are issued from the main store to the Tokyo store. If there is no problem in this processing, the downward arrow button 201 is clicked. The loading / unloading process can be performed in the opposite direction. For example, the loading / unloading process from the Tokyo store to the main store is also possible. In this case, the upward arrow button 202 is clicked.
Of course, these processes are problems in the management ledger, and actual physical tickets are moved between stores based on this process.
[0046]
FIG. 21 is an input screen at the time of issue processing. As described above, the gift certificate issued at each store is sold to the customer and becomes effective as a cash voucher. The sales slips of the gift certificates sold at each store are summarized in the tabulation table 31 by daily closing, 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 unit coupons at the Tokyo store is 500, the number is entered so that it becomes the number, and then the downward arrow button 211 is clicked. By this operation, the expiration date of the gift certificate issued on that day (March 31, 2002) is also input, and the number of uncollected gift certificates is changed from 1500 to 2000.
The upward arrow button 212 is for canceling the issuing process.
Although description of an Example is abbreviate | omitted about the input screen after collection | recovery processing, etc., it can carry out similarly to the warehousing process and issuing process.
[0047]
Next, an example of a management list and report output by the management system of the present invention will be described.
FIG. 22 is a diagram showing an inventory ticket list (simple), and FIG. 23 is a diagram showing an inventory ticket list (details). In the simple list, the number of tickets for each ticket type is displayed, and in the detailed list, the management number of the gift certificate stocked for each ticket type is 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 is displayed, and in the detailed list, the management number of the gift certificate stocked for each ticket type is displayed.
FIG. 26 is a diagram illustrating an example of a monthly report. The number of goods and gift certificates at the headquarters in the previous month, the number of goods in and out (current month), issuance ticket, collection ticket, scrapped ticket, current month inventory ticket, miscellaneous ticket, and miscellaneous ticket type, each showing the number and amount Has been.
[0048]
The management system of the present invention can output not only the list and report in the above example, but also various other lists necessary for the management of gift certificates, reports necessary for public institution notifications, and the like.
[0049]
【The invention's effect】
The gift certificate management system of the present invention is managed based on a gift certificate management number that does not overlap for each ticket type. Since the expiration date is managed when an in-store gift certificate is issued, the status of issuance and collection of gift certificates collected within the expiration date, gift certificates recovered after the expiration date, unrecovered gift certificates expired, etc. It is possible to accurately manage the state of the gift certificate indicating. Alternatively, when the unissued gift certificate of stock is abolished, the waste ticket is managed, so that the stock status can be appropriately managed. Therefore, Since the gift certificate management system of the present invention can easily output various lists, reports, and public institution notifications necessary for management, office work can be reduced.
[Brief description of the drawings]
FIG. 1 is a diagram showing a gift certificate acceptance processing status of a management system of the present invention.
FIG. 2 is a diagram showing a gift certificate issuance processing status of the management system of the present invention.
FIG. 3 is a diagram showing a gift certificate issuing process status of the management system of the present invention.
FIG. 4 is a diagram illustrating a situation in which various management forms are 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 in this system.
FIG. 7 is a diagram illustrating a processing flow at the time of acceptance registration.
FIG. 8 is a diagram for explaining a processing flow when an acceptance registration is deleted.
FIG. 9 is a diagram illustrating a processing flow at the time of entry / exit registration.
FIG. 10 is a diagram for explaining a processing flow at the time of canceling 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 canceling issuance registration.
FIG. 13 is a diagram illustrating a processing flow at the time of collection processing.
FIG. 14 is a diagram illustrating a flow at the time of collection ticket reception processing.
FIG. 15 Receiving It is a figure explaining the flow at the time of a process.
FIG. 16 is a diagram illustrating a processing flow when registering a scrap ticket.
FIG. 17 is a diagram for explaining a processing flow at the time of canceling scrap ticket registration;
FIG. 18 is a diagram illustrating a flow of monthly update processing.
FIG. 19 is an input screen at the time of acceptance processing.
FIG. 20 is an input screen during entry / exit processing;
FIG. 21 is an input screen during issue processing;
FIG. 22 is a diagram showing an inventory ticket list (simple).
FIG. 23 is a diagram showing an inventory ticket 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]
11 Personal computer
12 Printer
13 Hand scanner
14 Barcode / OCR reader
21 gift certificate
22 ticket management number
23 Expiration Date
24 Sealing column
25 Cut line
31 summary table
32 Sending form
191, 201, 202, 211, 212 Click button

Claims (6)

A computer system for managing gift certificates composed of at least one ticket type,
A stock voucher table that records information on the gift vouchers delivered ;
An uncollected ticket table for recording information obtained by adding expiration date information to information on gift certificates moved from the inventory ticket table ;
And ZatsuIri ticket table closing date to record the information of the vouchers beyond the expiration date,
And a recovery already ticket table to record the collected information of the gift certificate,
And Zatsuson ticket table to record the information of the gift certificate that the recovery date is beyond the expiration date,
A storage means for storing the waste ticket table to record the information of the history table waste store inventory tickets,
Accepts issued input, go to the stock ticket table or we uncollected ticket table the information of the gift certificate with the issue input that has been received, by adding an expiration date information to the moved gift certificate of information, issue management to be registered Means,
If the expiry date of the gift certificate information in the uncollected ticket table exceeds the closing date, maintain the miscellaneous ticket table to move the information of the gift certificate whose expiration date exceeds the closing date to the miscellaneous ticket table. Management means;
It accepts the recovery input, and gift certificates collection management means for moving the information of the gift certificate in uncollected ticket table or we recovered pre-ticket table having collected input that has been received,
If the expiration date of the recovered goods ticket long beyond the closing date, and Zatsuson ticket management means the expiration date to move the information of the gift certificate that is beyond the closing date, to miscellaneous unfit table from ZatsuIri ticket table,
Accept the waste ticket input, the stock ticket table or we waste ticket table, and a waste ticket management means for moving a gift certificate information with the waste tickets input that has been received,
History registration means for creating record information of processing performed by each of the previous management means and registering it in the history table;
A gift certificate management system comprising: 2. The gift certificate management system according to claim 1, wherein the issuing process and the collecting process status are output to a form. 2. The gift certificate management system according to claim 1, wherein a series of non-overlapping ticket management numbers is attached to each gift certificate. A computer system that manages a gift certificate that has a series of ticket management numbers that do not overlap for each ticket type,
A stock voucher table that records information on the gift vouchers delivered ;
An uncollected ticket table for recording information obtained by adding expiration date information to information on gift certificates moved from the inventory ticket table ;
And ZatsuIri ticket table closing date to record the information of the vouchers beyond the expiration date,
And a recovery already ticket table to record the collected information of the gift certificate,
And Zatsuson ticket table to record the information of the gift certificate that the recovery date is beyond the expiration date,
A storage means for storing the waste ticket table to record the information of the history table waste store inventory tickets,
Accept the issuance input until the start of ticket management number-end ticket management number, the information of the gift certificate with a ticket management issue that has been received to move to the stock ticket table or we uncollected ticket table, to move the gift certificate information Issuing management means for adding and registering expiration date information ,
If beyond the expiration date closing date the information of the gift certificate of uncollected ticket table has, ZatsuIri ticket table maintenance management to move the information of the gift certificate that the expiration date is beyond the closing date in miscellaneous Iriken table Means,
It accepts the recovery input until the start of ticket management number-end ticket management number, and gift certificates collection management means for moving the information of the gift certificate in uncollected ticket table or we recovered pre-ticket table having a ticket management number that has been received,
If the expiration date of the recovered goods ticket long beyond the closing date, and Zatsuson ticket management means for moving the information of the gift certificate that the expiration date is beyond the closing date to ZatsuIri ticket table or we miscellaneous unfit table,
Accept the waste tickets input until the start of ticket management number-end ticket management number, the stock ticket table or we waste ticket table, and a waste ticket management means for moving including merchandise ticket information the ticket management number that has been received,
History registration means for creating record information of processing performed by each of the previous management means and registering it in the history table;
A gift certificate management system comprising: A computer system for managing a gift certificate with a ticket management number identifying a gift certificate,
A stock voucher table that records information on the gift vouchers delivered ;
An uncollected ticket table for recording information obtained by adding expiration date information to information on gift certificates moved from the inventory ticket table ;
And ZatsuIri ticket table closing date to record the information of the vouchers beyond the expiration date,
And a recovery already ticket table to record the collected information of the gift certificate,
And Zatsuson ticket table to record the information of the gift certificate that the recovery date is beyond the expiration date,
A storage means for storing the waste ticket table to record the information of the history table waste store inventory tickets,
Accept the issuance input until the start of ticket management number-end ticket management number, the information of the gift certificate with a ticket management issue that has been received to move to the stock ticket table or we uncollected ticket table, to move the gift certificate information Issuing management means for adding and registering expiration date information ,
If beyond the expiration date closing date the information of the gift certificate of uncollected ticket table has, the expiration date miscellaneous Iriken table maintenance management to move the information of the gift certificate that is beyond the closing date in miscellaneous Iriken table Means,
It accepts the recovery input until the start of ticket management number-end ticket management number, and gift certificates collection management means for moving the information of the gift certificate in uncollected ticket table or we recovered pre-ticket table having a ticket management number that has been received,
If the expiration date of the recovered goods ticket long beyond the closing date, and Zatsuson ticket management means for moving the information of the gift certificate that the expiration date is beyond the closing date to ZatsuIri ticket table or we miscellaneous unfit table,
Accept the waste tickets input until the start of ticket management number-end ticket management number, the stock ticket table or we waste ticket table, and a waste ticket management means for moving including merchandise ticket information the ticket management number that has been received,
A gift certificate management system comprising: history registration means for creating record information of processing performed by each of the previous management means and registering it in a history table. The storage means stores an acceptance history table in which the ticket management number of the recorded gift certificate cannot be deleted,
Gift certificate acceptance management means for accepting input of gift certificate acceptance information including a ticket management number and recording it in an inventory ticket table and an acceptance history table,
The gift certificate management system according to claim 4, wherein the gift certificate management system is provided.

Images