JP2004310186A - Automatic journalization process, device for implementing it, its process program, and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a technique for changing or adding journalization requirements or journalization methods without changing a program when changing or adding the process of journalizing slip data. <P>SOLUTION: An automatic journalization process for performing the work of journalizing slips includes a step for reading an external definition rule file in which the journalization requirements showing the requirements of the journalization process and journalization methods showing the contents of the journalization process are registered and for retaining in a storage device the journalization requirements and the journalization methods registered in the external definition rule file; and a step for reading pre-journalization slip data registered in a pre-journalization slip data file and retaining the data in the storage device. The process further includes a step for journalizing the pre-journalization slip data using a journalization method retained in a pair with a journalization requirement, if the pre-journalization data retained in the storage device meet the journalization requirement, and for retaining the data in the storage device as journalized slip data. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an automatic journal processing apparatus for performing journal entry work, and more particularly to a technique effective when applied to an automatic journal processing apparatus for automatically performing accounting journal entry work using a computer device.
[0002]
[Prior art]
Conventionally, when journalizing accounting slips (for example, “sales slips”) in an accounting operation using a computer, a method of generating credit and debit accounts from accounting slips originally performed manually (hereinafter referred to as “journaling”) is used. It is necessary to automate the business with regard to the journal entry method). First, the accounting slips to be journalized are converted into data, held as slip data in an external storage device, and an automatic journalizing program for performing journal entries is created and stored in a computer. The journal is read by inputting the slip data held in the external storage device and executing the automatic journalizing program by the CPU of the computer.
[0003]
At this time, it is necessary for the automatic journalizing program to determine what kind of journal entry is to be performed on the input slip data. This determination is usually made based on the slip data from the slip item data (for example, “supplier store name”). ), A search of an external storage device such as a database using the slip item data, a journal code indicating the journal entry method (for example, “journal entry method-1”), and automatic journal entry using this journal entry code. A plurality of journalizing methods described in the program or the automatic journalizing program itself in which a single journalizing method is described is selected to determine the journalizing method. After the journalizing method is determined, processing for processing the input slip data in accordance with the journalizing method (hereinafter, journalizing process) is performed.
[0004]
As an example of such an automatic journalizing system, a system and a method for easily creating information on the financial condition and profit and loss of a company from a transaction occurring in the economic activity of the company are provided (for example, see Patent Document 1). The journalizing process is performed by executing a program describing the journalizing method.
[0005]
[Patent Document 1]
JP 2000-215263 A
[0006]
[Problems to be solved by the invention]
In the prior art automatic journalizing process, since the journalizing conditions and the journalizing method are described in a program in the form of a processing algorithm and internal data, a new journalizing method is added or an existing journalizing method is changed. In this case, or when the slip item data for determining the journal entry method is changed, it is necessary to change the program for automatic journal entry processing, and there is a problem that the maintenance cost of the program increases.
SUMMARY OF THE INVENTION An object of the present invention is to solve the above-described problem and provide a technology capable of responding to a change or addition of a journal condition or a journal method without changing a program when changing or adding journal processing of slip data. To provide.
[0007]
[Means for Solving the Problems]
According to the present invention, in an automatic journal processing device that performs a journal journaling operation, journal data is journalized according to journal conditions and a journal method held in an externally defined rule file.
[0008]
In the automatic journal processing apparatus of the present invention, first, as a condition for performing the journal processing, a journal condition defining any item content in the slip data and a content of the journal processing to the slip data matching the journal condition are shown. The external definition rule file in which the journalizing method is registered is read, and the journalizing conditions and the journalizing method registered in the external definition rule file are stored in the storage device.
[0009]
Next, the pre-journalization processing slip data registered in the pre-journalization processing slip data file is read and stored in a storage device, and the item contents in the pre-journalization processing slip data stored in the storage device are stored in the storage device. A search for journal conditions is performed by checking whether or not the contents match any of the slip items indicated in the entered journal conditions.
[0010]
As a result of the search, when a journal condition that satisfies the item content in the pre-journal processing voucher data is searched, the pre-journal processing voucher data is subjected to the journal processing by the journaling method held in pair with the journal condition. Then, it is stored in the storage device as journalized slip data. At that time, the journal is converted by executing a command for converting the data in accordance with a predetermined rule or newly adding data to the slip data (hereinafter, a journal conversion command) or a combination thereof (hereinafter, a journal conversion command designation). The journal processing is performed on the pre-processed slip data to generate journal processed slip data. At this time, a plurality of detailed data may be generated from the detailed data included in the pre-journal processing slip data by the above-mentioned journalizing method.
Then, after performing the journalizing process on all the slip data, all the journalized slip data that have been subjected to the journalizing process and held in the storage device are output to the external storage device.
[0011]
Also, when reading the external definition rule file, a plurality of external definition rule files, from the plurality of external definition rule files, respectively holding different journal conditions and journal methods in a storage device, and before the journal processing slip data held in the storage device Alternatively, the process of performing journaling using the journaling method held in pairs with the corresponding journaling condition may be sequentially executed for the separately held journalizing condition and journalizing method.
[0012]
Further, after the journal processing is completed, another program may be called for the journal processed slip data unit, and the journal processed slip data may be passed to the separate program to perform predetermined processing.
[0013]
As described above, in the present invention, a journal conversion command for converting input slip data according to a predetermined rule or adding new data to slip data, or a journal conversion command designation indicating a combination thereof, is designated as an external storage as a journaling method. Since it is stored in the external definition rule file of the device, when it is necessary to change or add the journal entry method to the slip data, it is possible to respond to the addition / change of the journal entry method without making any changes to the program. .
[0014]
Further, in the present invention, the journal condition used when determining the journal method is set as a journal condition which can arbitrarily set the voucher item data, and the journal condition is retained in an external definition rule file, so that the journal data can be journalized. When it becomes necessary to change or add conditions, it is possible to respond to adding or changing journal conditions without changing the program.
[0015]
As described above, according to the automatic journal processing device of the present invention, the journal data is journalized according to the journal conditions and the journal method retained in the externally defined rule file. In addition, it is possible to respond to a change or addition of a journal condition or a journal method without making a change to the program.
[0016]
BEST MODE FOR CARRYING OUT THE INVENTION
An automatic journal processing apparatus according to an embodiment that performs journal entry processing of voucher data based on journal conditions and a journal method held in an externally defined rule file will be described below.
[0017]
FIG. 1 is a diagram showing the system configuration of the automatic journal processing device of the present embodiment. As shown in FIG. 1, the automatic journal processing device of the present embodiment includes an external definition rule file reading processing unit 112, an item appearance order setting file reading processing unit 113, a pre-journal processing slip data file reading processing unit 114, It has a condition search processing unit 115 and a journal processing unit 117.
[0018]
The external definition rule file reading processing unit 112 reads an external definition rule file in which journal conditions indicating conditions for performing the journal processing and a journal method indicating the contents of the journal processing are registered, and is registered in the external definition rule file. This is a processing unit that stores the journalizing conditions and the journalizing method in the storage device 109.
[0019]
The item appearance order setting file reading processing unit 113 reads the item appearance order setting file in which the appearance order information indicating the appearance order of the slip item data is registered, and stores the appearance order information registered in the item appearance order setting file in the storage device. 109 is a processing unit to be held.
[0020]
The pre-journalization processing slip data file reading processing unit 114 is a processing unit that reads the pre-journalization processing slip data registered in the pre-journalization processing slip data file and stores it in the storage device 109. The journalizing condition search processing unit 115 determines that the item contents in the pre-journalization processing slip data held in the storage device 109 match the contents of any slip item indicated in the journaling conditions held in the storage device 109. This is a processing unit for searching for journalizing conditions by checking whether or not there is a journal entry.
[0021]
The journal processing unit 117 is a processing unit that performs journal processing on the pre-journal processing voucher data using a journal method held in pairs with the searched journal conditions and stores the journal data in the storage device 109 as journal processed voucher data. It executes a journal conversion command for converting according to a predetermined rule or adding new data to the slip data, or a journal conversion command designation indicating a combination thereof.
[0022]
The automatic journal processing apparatus according to the present embodiment includes an external definition rule file reading processing unit 112, an item appearance order setting file reading processing unit 113, a pre-journal processing slip data file reading processing unit 114, a journal condition search processing unit 115, and a journal processing unit. A program for functioning as the program 117 is recorded on a recording medium such as a CD-ROM, stored on a magnetic disk or the like, and then loaded into a memory and executed. The recording medium for recording the program may be a recording medium other than the CD-ROM. Further, the program may be installed from the recording medium to the information processing apparatus and used, or the recording medium may be accessed through a network to use the program.
[0023]
The computer device 107 in FIG. 1 includes a storage device 109 and a CPU 108 that executes a program read by the storage device 109. The storage device 109 includes a storage area used by the program executed by the CPU 108. Have been. The external storage devices 101, 102, 103, 104, 105, 106, and 111 and the input device 110 are connected to the computer device 107. The computer device 107 stores the files stored in each external storage device. It has a function of processing input / output and input from an input device.
[0024]
The external storage device 101 stores a pre-journal processing slip data file as slip data in a state before performing the journal processing (hereinafter, pre-journal processing slip data), and the external storage device 102 and the external storage device 111 store therein. An external definition rule file storing a plurality of journal conditions and journal conversion command designations is stored. The external storage device 103 stores an automatic journal program, which is a program for automatically journalizing input slip data. The external storage device 104 stores an item appearance order setting file in which appearance order information used in the journalizing process is registered. The appearance order information will be described later. The external storage device 105 stores a program different from the automatic journalizing program. The external storage device 106 stores the journal data as the voucher data after the journalizing process (hereinafter, journalized voucher data). Stored slip data file.
[0025]
Next, processing contents of the automatic journalizing program will be described with reference to FIGS. When an automatic journal program execution start command is input from the input device 110, the automatic journal program is read from the external storage device 103, and the respective processing units are formed on the storage device 109. Is performed. At this time, when the execution start command of the automatic journal program is input from the input device 110, the storage locations of the pre-journal processing slip data file, the external definition rule file, the item appearance order setting file, and the journal processed slip data file are simultaneously specified. Shall be The storage location is a name indicating the position of each file in the external storage device.
[0026]
FIG. 2 is a flowchart showing a processing procedure of the automatic journalizing processing according to the present embodiment. When the execution start command of the automatic journalizing program is input from the input device 110, the external definition rule file reading processing unit 112 simultaneously reads the external definition rule file from the external storage device 102 at the designated storage location, and reads the external definition rule file. The journal condition and the journal conversion command designation registered in the definition rule file are stored in the storage device 109. Also, at this time, by accepting the designation of the storage location of the plurality of external definition rule files, the storage device 109 can hold the separate journal condition and journal conversion command designation from the plurality of external definition rule files, respectively. it can. The journalizing process by specifying a plurality of external definition rule files will be described later (step 21).
[0027]
The item appearance order setting file reading processing unit 113 reads the item appearance order setting file from the external storage device 104 in the storage location specified at the same time when the automatic journalizing program is executed, and displays the appearance order information registered in the item appearance order setting file. Is stored in the storage device 109 (step 22).
[0028]
The pre-journal processing slip data file reading processing unit 114 reads one pre-journal processing slip data from the external storage device 101 at the storage location specified at the same time as the automatic journalizing program is executed, and stores it in the storage device 109 (step 23). ).
[0029]
The journalizing condition search processing unit 115 searches for journalizing conditions that match the conditions from the journalizing conditions also stored in the storage device 109 for one pre-journalization processing slip data stored in the storage device 109 in step 23. (Step 24), and it is determined whether the conditions are met (step 25).
If the conditions match, the process proceeds to step 26. If the conditions do not match, the process proceeds to step 27 without executing step 26.
[0030]
If the conditions match in step 25, the journal processing unit 117 performs journal processing on the pre-journal processing slip data that matches the conditions according to the specification of the journal conversion command held in pairs with the journal conditions that matched the conditions in the storage device 109. It is stored in the storage device 109 as processed slip data (step 26).
It is determined whether the pre-journal processing slip data file stored in the external storage device 101 has slip data that has not yet been subjected to journal processing (step 27).
[0031]
If there is slip data for which journal processing has not been performed, the process proceeds to step 23, and if journal data has been processed for all slip data, the process proceeds to step 28.
In step 28, all the journalized slip data that has been subjected to the journalizing process and held in the storage device 109 are output to the external storage device 106. After outputting all journalized slip data, the automatic journalizing process ends.
[0032]
Next, refer to FIG. 3 for a slip data file which is a common format of the pre-journal processing slip data file stored in the external storage device 101 and the journal processing slip data file stored in the external storage device 106. Will be explained.
[0033]
FIG. 3 is a diagram showing an outline of the slip data file of the present embodiment. The slip data file 31 is composed of slip data 32, and a plurality of slip data 32 can be specified in the slip data file 31.
[0034]
The slip data 32 is composed of slip item data 33 and detailed data 36, and a plurality of slip item data 33 and detailed data 36 can be specified in the slip data 32.
The detailed data 36 is composed of the slip item data 37, and a plurality of the slip item data 37 can be specified in the detailed data 36.
The slip item data 33 includes a slip item data name 34, which is the name of the slip item data, and a slip item data value 35, which is the value of the slip item data name 34. Further, there is no difference in the description method of the slip item data 33 and the slip item data 37 constituting the detail data 36. However, the slip item data names in the slip data 32 must not be duplicated.
[0035]
Next, the external definition rule file stored in the external storage device 102 will be described with reference to FIGS.
FIG. 4 is a diagram showing an outline of the external definition rule file of the present embodiment. The external definition rule file 41 includes a rule block 42 in which a journal condition specification 43 and a journal conversion command specification 46 are paired. It is assumed that a plurality of rule blocks 42 can be specified in the externally defined rule file.
[0036]
The journal condition specification 43 is a condition for selecting a journal conversion command specification to be applied to the voucher data before the journal processing, and includes a slip item data name specification 44 and a slip item data value specification 45. It is assumed that a plurality of slip item data names and slip item data values can be specified in the journal condition specification 43.
[0037]
The form item data name designation 44 designates an item name constituting the form data before journal processing, and the form item data value designation 45 designates the value set in the item name.
[0038]
In the journal condition search process according to the present embodiment, in the pre-journal processing form data to be subjected to the journal processing, the form item data name designation constituting the journal condition designation 43 and the form item data value designation of the form item data name are specified. Are all described, the condition is matched, and the journal conversion command designation 46, which forms a pair with the journal condition designation 43, is used for the journalizing process of the slip data before the journalizing process.
[0039]
The journal conversion command designation 46 is composed of a journal conversion command 47 used for journal processing of the pre-journal processing slip data and a conversion value 48 used when the journal conversion command 47 is applied. It is assumed that a plurality of journal conversion commands 47 and conversion values 48 can be specified in the journal conversion command specification 46.
[0040]
Next, a method for specifying journalizing conditions for determining the specification of a journal conversion command to be applied to the voucher data before journalizing processing will be described with reference to FIGS.
FIG. 5 is a diagram illustrating an example of a slip data file according to the present embodiment. The slip data file 51 shown in FIG. 5 stores the slip data 59 from the slip data 52. When the journal processing is performed on the slip data 56, the external definition rule file 41 shown in FIG. By specifying "business office name" in the form item data name specification 44 and "Takaoyama office" in the form item data value specification 45, the conditions are matched and the journal conversion instruction specification to be applied is determined. be able to. This is because, among the slip data 52 to the slip data 59, only the slip data 56 is designated as "Takao Sales Office" in the "business office name".
[0041]
Assuming that the journal data is to be processed in the slip data 57, if the slip item data name specification 44 is specified as “business office name” and the slip item data value specification 45 is specified as “Mt. The slip data is slip data 52, slip data 57, and slip data 59. For this reason, in order to process only the slip data 57, it is necessary to further add a journal condition. As a new journal condition to be added, the “slip date data” is specified in the slip item data name specification 44, In addition, "2003/02/10" is designated in the slip item data value designation 45. As a result, the condition is satisfied for the slip data 57, and the journalizing process can be performed.
[0042]
Next, the appearance order information in which the item appearance order setting file is stored will be described with reference to FIGS. 1, 2, and 6. FIG.
FIG. 6 is a diagram illustrating an example of the appearance order information according to the present embodiment. The item appearance order setting file stored in the external storage device 104 shown in FIG. 1 holds the appearance order information 81 necessary for performing the journalizing process. The appearance order information 81 includes a slip item data name 82 and an appearance order 83. In the slip item data name 82, all the slip item data and the slip item data names specified in the journal conversion command are registered. . The appearance order 83 does not overlap and is a unique number.
[0043]
In step 26, the order of appearance of the slip item data and the slip item data name of the journal conversion command is obtained from the appearance order information 81 held in the storage device 109, and the size is compared to perform the journalizing process.
[0044]
Next, the specification of a journal conversion command to be applied to the slip data to be subjected to the journal processing and the journal processing shown in step 26 of FIG. 2 will be described with reference to FIGS. 1 and 5 to 14.
[0045]
FIG. 7 is a diagram showing an example of specifying a journal conversion command according to the present embodiment. The journal conversion command 62 shown in FIG. 7 includes slip item data name information (for example, “journal processing date of item 1”) indicating which slip item data of the slip data to be subjected to journal processing to be applied, and a conversion operation. The conversion value 63 is composed of the indicated conversion operation information (for example, “add or overwrite”), and the conversion value 63 indicates the slip item data value after the journalizing process. The journal conversion process is performed by using the journal conversion command line including the journal conversion command 62 and the conversion value 63.
[0046]
FIG. 8 is a flowchart illustrating a processing procedure of the journalizing process according to the present embodiment. As shown in FIG. 8, the journal processing unit 117 of the automatic journal processing device performs journal processing on the pre-journal processing voucher data according to the journal method held in pairs with the searched journal conditions and converts the data into journal processed voucher data. The processing held in the storage device 109 is performed. In the example described below, it is assumed that the subject of the journal processing is the slip data 52, and the journal conversion command specification 61 is applied when the condition is matched by the specification of the journal condition.
First, when the journalizing process is started, a process for reading slip data is called (step 701).
[0047]
FIG. 9 is a flowchart showing the processing procedure of the slip data reading processing of the present embodiment. In the slip data reading process, one line of data is extracted from the slip data 52 stored in the storage device 109 (for example, “Draft date-2003/02/01”), and is converted as the conversion target line data into the storage device 109. (Step 702).
[0048]
In step 703, it is determined whether the journal processing has been completed for all the slip item data in the slip data 52. If the journal processing has not been completed, the process proceeds to step 704, and if the journal processing has been completed. To step 705.
[0049]
The slip item data name is acquired from the conversion target row data stored in the storage device 109 (for example, “date of draft”), and the appearance data already stored in the storage device 109 is obtained using the slip item data name. The appearance order 83 (for example, the appearance order becomes “110” in the case of “date of draft”) is obtained from the order information 81, the reading process of the slip data is completed, and the process is returned (step 704).
[0050]
If the journal processing has been completed for all the slip item data in the slip data 52, the appearance order 83 (for example, “999”) is acquired from the appearance order information 81 already stored in the storage device 109. Then, the slip data reading process is terminated, and the process returns (step 705).
Next, in step 706 of FIG. 8, a process of reading the journal conversion command designation is called.
[0051]
FIG. 10 is a flowchart showing the processing procedure of the journal conversion command designation reading process of the present embodiment. In the journal conversion instruction designation reading process, the journal conversion instruction line (for example, “specification 1—journal processing date—addition or overwrite—2003 / 03/10”) is read from the journal conversion instruction designation 61 stored in the storage device 109. It is extracted and stored in the storage device 109 as conversion instruction data (step 707).
[0052]
In step 708, it is determined whether all the journal conversion commands in the journal conversion command specification 61 have been read. If there are journal conversion commands that have not been read yet, the process proceeds to step 709. If all the journal conversion commands have been read, step 710 is performed. Proceed to.
[0053]
The slip item data name is acquired from the conversion command data stored in the storage device 109 (for example, “journal processing date”), and the appearance order already stored in the storage device 109 is used by using the slip item data name. The information 81 (for example, in the case of “journal processing date”, the appearance order is “105”) is obtained, the journal conversion instruction designation reading process is completed, and the process is returned (step 709).
[0054]
If all the conversion command data of the journal conversion command designation 61 has been read, the appearance conversion order 83 (for example, “998”) is acquired from the appearance order information 81 already stored in the storage device 109, and the journal conversion command is acquired. The designated reading process ends, and the process returns (step 710).
[0055]
Based on the conversion command data stored in the storage device 109, a base point for performing the journalizing process is acquired (for example, “specification 1”) and stored in the storage device 109 as base point information (step 711).
[0056]
Next, in step 712 of FIG. 8, the order of appearance of the conversion target line data obtained in the slip data reading process becomes the maximum value, or the order of appearance of the conversion command data obtained in the journal conversion command designation reading process becomes the maximum value. Until the process from step 713 to step 720 is repeated, if either condition is satisfied, the repetition process is terminated and the process proceeds to step 721.
[0057]
The order of appearance of the conversion target line data acquired in the slip data reading process is compared with the order of appearance of the conversion instruction data acquired in the journal conversion instruction designation reading process (step 713). Proceeding to step 714, the process proceeds to step 733 if the order of appearance of the conversion target row data is smaller, and proceeds to step 735 if it is larger.
[0058]
If the appearance order is the same in step 713, the conversion operation information is obtained from the conversion command data stored in the storage device 109, and if the content is, for example, "addition or overwrite", the conversion operation information is stored in the storage device 109. The entry item data value of the conversion target line data is overwritten with the conversion value of the conversion command data, and journal processing is performed (step 714). FIG. 11 shows the types of conversion operation information.
[0059]
FIG. 11 is a diagram showing a list of conversion instructions according to the present embodiment and the contents of the conversion operation. As shown in FIG. 11, the operation at the time of the journalizing process is defined according to the content of the conversion operation information in the conversion command data, and the journalizing process is performed according to the definition.
[0060]
The conversion target row data after the journal processing is performed in step 714 is stored in the storage device 109 as the journalized row data (step 715).
Next, the slip data reading process is called (step 716), the journal conversion command designation reading process is called (step 717), and the base point for performing the journal processing is obtained from the conversion command data stored in the storage device 109 (for example, “Specification 1”), stored in the storage device 109 (Step 718), and compared with the base point information already acquired in Step 711 and stored in the storage device 109.
[0061]
As a result of the comparison, if they are the same, the process proceeds to step 720, and if they are different, the process proceeds to step 728 (step 719).
In step 720, the order of appearance of the conversion target line data obtained in the slip data reading process of step 716 is the maximum value, or the order of conversion command data obtained in the journal conversion command designation reading process of step 717 is the maximum value. If both are not the maximum values, the process proceeds to step 713.
[0062]
FIG. 12 is a flowchart illustrating the processing procedure of the termination processing according to the present embodiment. In the end process, if the appearance order of the conversion target line data obtained in the slip data reading process in step 716 and the appearance order of the conversion command data obtained in the journal conversion command designation reading process in step 717 are the maximum values, Proceeding to step 726, if only the order of appearance of the conversion command data obtained in the journal conversion command designation reading process is the maximum value, proceed to step 722, and if only the order of appearance of the conversion target line data is the maximum value Proceeds to step 727 (step 721).
[0063]
In step 722, if all the journal conversion instruction designations 61 to be applied to the slip data 52 subject to journal processing have been executed, and the reading of the slip data 52 has not been completed, the reading of the slip data 52 is performed. Until the processing ends, the processing from step 723 to step 725 is repeated.
[0064]
The conversion target line data held in the storage device 109 is held as it is as journalized line data in the storage device 109 (step 723), and the slip data reading process is called (step 724), and the reading of the slip data 52 is completed. If not, the process proceeds to step 722. If all processes have been completed, the process proceeds to step 726 (step 725).
[0065]
All the journalized row data held in the storage device 109 are collected and held in the storage device 109 as journalized voucher data or detailed data (step 726), and the end process ends.
[0066]
In step 721, if only the appearance order of the conversion target row data is the maximum value, all the journal conversion commands 62 of the journal conversion command specification 61 applied to the voucher data 52 to be subjected to the journal processing are executed. Since the journal conversion command 62 that has not been executed is executed at this time, steps 727 to 752 are repeated until reading of all the journal conversion command designations 61 is completed (step 727).
[0067]
In other words, the conversion operation information of the conversion instruction data stored in the storage device 109 is acquired, and when the acquired conversion operation information is, for example, “addition or overwrite”, the slip item data name information of the conversion instruction data is obtained. Based on this and the conversion value, the journalized line data is generated and stored in the storage device 109 (step 750), and the journal conversion instruction designation reading process (step 751) is called, and the reading of the journal conversion instruction designation 61 has been completed. If not, the process proceeds to Step 721. If all processes are completed, the process proceeds to Step 726 (Step 752).
[0068]
FIG. 13 is a flowchart showing a processing procedure when the base point information is different in step 719 of the present embodiment. In step 719, if the base point information obtained in step 711 is different from the base point information obtained in step 718, the end processing shown in steps 721 to 726 is performed (step 728).
[0069]
In order to read the form data 52 held in the storage device 109 again from the beginning, the reading position is returned to the top of the form data 52 (step 730), and the form data reading process is called (step 731).
The base point information of the conversion command data acquired in step 718 is stored in the storage device 109 as the current base point (step 732), and the process proceeds to step 712.
[0070]
In step 713 of FIG. 8, as a result of comparing the appearance order of the conversion target line data acquired in the slip data reading process with the appearance order of the conversion instruction data acquired in the journal conversion instruction designation reading process, the appearance order of the conversion target line data If is smaller, the conversion target line data held in the storage device 109 is held as it is as journalized line data in the storage device 109 (step 733), and the slip data reading process is called (step 734). After the slip data reading process is completed, the process proceeds to step 718.
[0071]
In step 713, as a result of comparing the appearance order of the conversion target line data acquired in the slip data reading process with the appearance order of the conversion instruction data acquired in the journal conversion instruction designation reading process, the appearance order of the conversion instruction data is smaller. In this case, the conversion operation information of the conversion instruction data stored in the storage device 109 is obtained. If the obtained conversion operation information is, for example, “addition or overwrite”, the slip item data of the conversion instruction data is obtained. Based on the name information and the converted value, journalized line data is generated and stored in the storage device 109 (step 735), and the process proceeds to step 717.
[0072]
FIG. 14 is a diagram illustrating an example of the slip data after the journalizing process according to the present embodiment. If it is assumed that the journal processing is performed on the slip data 52 and that the journal conversion command specification 61 is applied when the conditions are matched by the specification of the journal conditions, the above-described steps 701 to 735 are performed. The voucher data 52 to be processed is subjected to journalizing processing into journalized voucher data 1002 shown in FIG. 14, and is held in the journalized voucher data file 1001 in step 28.
[0073]
Next, a method of performing a journalizing process on one piece of detailed data included in the slip data and performing a journalizing process on a plurality of detailed data will be described with reference to FIGS. 1 and 5 to 14.
[0074]
The journal processing is performed on the slip data 52. When the journal conversion instruction designation 64 is applied to the slip data 52, the journal conversion instruction 65 in the journal conversion instruction designation 64 is changed to the journal conversion instruction designation reading processing shown in step 717. Until it is read in, the base point information held in the storage device 109 in step 711 is “specification 1”.
[0075]
In step 717, the journal conversion command 65 is read, and in step 718, "specification 2" is acquired as base information from the conversion command data stored in the storage device 109.
[0076]
The base point information “specification 1” held in the storage device 109 and the base point information “specification 2” acquired from the conversion command data held in the storage device 109 are compared in step 719, and the base point information is different. Therefore, the process proceeds to step 728.
[0077]
In the end processing shown in step 728, the journalized line data held in the storage device 109 is held in the storage device 109 as the detail 1 portion 1004 of the journalized slip data 1003, and in step 730, The slip data 52 is returned to the head position (for example, “due date”), and the slip data reading process shown in step 731 is performed. Further, in step 732, the base point information “specification 2” of the journal conversion command 65 is stored as the current base point information in the storage device 109, and the process proceeds to step 712 to execute the journal processing until the journal conversion command designation 64 is completed.
By performing the above-described journal processing, the second detail data of the journalized slip data 1003, which is the second detail data from the slip data 52, is generated.
[0078]
Next, a plurality of externally defined rule files each having a different journaling method are read, held in a storage device of a computer as a separate journaling method, and the slip data before the journalizing process are sequentially held in the storage device. A method for performing the journalizing process according to the journalizing method described above will be described with reference to FIG.
[0079]
When inputting an automatic journal program execution start command from the input device 110, the external definition rule file read processing unit 112 accepts designation of storage locations of a plurality of external definition rule files at the same time. The file is read (for example, the external storage device 102 and the external storage device 111), and the journal conditions and the journal conversion command specification stored in the respective external definition rule files are stored in the storage device 109. It is retained as a journal conversion command specification. Also, the order of the journal processing in which the journal conditions and the journal conversion command specified separately are stored in the storage device 109 can be specified by the specification order of the storage location of the external definition rule file.
[0080]
For example, by specifying the storage location in the order of the external storage device 111 and the external storage device 102, the journal processing unit 117 first executes the journal condition and the journal conversion command of the external definition rule file stored in the external storage device 111. The specification is applied to the voucher data before the journal processing, and after the journal processing is completed, the journal processing is performed by applying the journal condition and the journal conversion command specification of the external definition rule file stored in the external storage device 102 next. Do.
[0081]
Next, a method of passing the journalized voucher data to a program different from the automatic journalizing program in units of the journalized voucher data subjected to the journalizing process and executing the separate program will be described with reference to FIGS. Will be explained.
[0082]
By the journalizing process shown in step 26, the journal data before journal processing held in the storage device 109 is subjected to journal processing, and is held in the storage device 109 as journal processed slip data. The other program indicated by 105 is read into the storage device 109, and the other program read into the storage device 109 is executed using the CPU. At this time, the journalized slip data held in the storage device 109 subjected to the journalizing process in step 26 is transferred at the same time as the command to start execution of another program from the journalizing processor 117.
[0083]
The separate program executed by the journal processing unit 117 performs some processing on the passed journalized slip data, or executes another process without processing the journal processed slip data. When the processing of the separate program is completed, the separate program passes the journal processed slip data to the journal processing unit 117.
[0084]
As described above, according to the present embodiment, the following effects can be obtained. That is, the journalizing method for performing the journalizing process on the input voucher data, and the journalizing conditions for determining this journaling method are held in an external storage device without having the automatic journalizing program, and the By reading the external storage device at the time of execution and holding the data in the storage device of the computer device and performing the journalizing process, it is possible to cope with adding or changing the journalizing method and the journalizing conditions without changing the contents of the program. . In addition, by specifying a journal conversion command for performing the journal processing, a plurality of specifications can be generated from one item data in the slip data, and the journal conditions and the journal method are distributed and held in a plurality of external storage devices. Thus, the number of journal conditions in one external storage device can be reduced.
[0085]
Here, the number of journalizing conditions when the journalizing conditions and the journalizing method are described in the automatic journalizing program using a conventional method will be described with reference to FIG.
FIG. 15 is a diagram showing an example of a combination of a supplier code, a department code, and a processing code in a general automatic journalizing process including a conventional technology. The customer-A to the customer-J shown by 1101 in FIG. 15 have three customer codes 1105 as codes indicating the departments of each customer, respectively. d has three department codes 1106 as codes used in respective departments. The accounting system-α to the accounting system-β denoted by 1103 have processing codes 1107 as codes used in the respective accounting systems. There are five each. In each department 1102, the business partner-A to the business partner-J are used as business partners, and the accounting data-α and the accounting system-β which perform different processing are used to create the slip data 1104, respectively. I have.
[0086]
In the automatic journalizing program 1108, the slip data 1104 is input, and a journalizing method is determined and a journalizing process is performed using the supplier code 1105, the department code 1106, and the processing code 1107 in the slip data as journaling conditions.
[0087]
At this time, the number of combinations and the total number of combinations are as shown in Equation 1 below.
(Equation 1)
Number of supplier code combinations =
Number of business partners × number of business partner codes for each business partner
Number of department code combinations =
Number of departments × number of department codes for each department
Number of processing code combinations =
Number of accounting systems × number of processing codes for each accounting system
Total number of combinations =
Number of business partner code combinations × Number of department code combinations ×
Number of processing code combinations
Then, when the numerical values in FIG. 15 are applied to the above expression, the following Expression 2 is obtained, and the total number of combinations becomes 3,600.
[0088]
(Equation 2)
Total number of combinations = (10 × 3) × (4 × 3) × (2 × 5)
Therefore, in the automatic journalizing program 1108 of the prior art, 3600 kinds of journalizing conditions are required as the journaling conditions as described above, and it is necessary to describe a journaling method in the automatic journalizing program 1108 by the number of the journalizing conditions.
[0089]
Next, referring to FIG. 15, the number of journalizing conditions when the journalizing conditions and the journalizing method are distributed to a plurality of external definition rule files using the present embodiment will be described.
[0090]
In the present embodiment, the number of combinations of the supplier code, the department code and the processing code is the same as the above-described formula 1, but each is defined as a separate external definition rule file, and the journalizing process is divided to obtain the overall combination. The number is as shown in the following Equation 3.
[0091]
[Equation 3]
Total number of combinations =
Number of business partner code combinations + Number of department code combinations +
Number of processing code combinations
[0092]
When the numerical values in FIG. 15 are applied to the above equation, the result is as shown in Expression 4, and the total number of combinations is 52.
(Equation 4)
Total number of combinations = (10 × 3) + (4 × 3) + (2 × 5)
[0093]
That is, in this embodiment, an external definition rule file that specifies a journal condition and a journal method that satisfies the combination of the supplier code 1105, an external definition rule file that specifies the journal condition and the journal method that satisfies the combination of the department code 1106, When an external definition rule file that specifies a journal condition and a journal method that satisfies the combination of the code 1107 is specified when the automatic journal program 1108 is executed, and each external definition rule file is a separate journal method, 52 By describing the different journal conditions and the different journal methods in separate external definition rule files, the journal data 1104 can be journaled for all combinations.
[0094]
As described above, according to the automatic journal processing device of the present embodiment, the journal data is journalized according to the journal conditions and the journal method held in the externally defined rule file. At the time of the change, it is possible to cope with a change or addition of a journal condition or a journal method without making a change to the program.
[0095]
【The invention's effect】
According to the present invention, the journal data is journalized according to the journal conditions and the journal method held in the externally defined rule file. Therefore, when the journal data is changed or added to the journal data, the journal is processed without changing the program. It is possible to respond to changes or additions to conditions or journal entry methods.
[Brief description of the drawings]
FIG. 1 is a diagram showing a system configuration of an automatic journal processing device according to an embodiment.
FIG. 2 is a flowchart illustrating a procedure of an automatic journalizing process according to the embodiment.
FIG. 3 is a diagram showing an outline of a slip data file according to the embodiment.
FIG. 4 is a diagram showing an outline of an external definition rule file of the embodiment.
FIG. 5 is a diagram showing an example of a slip data file according to the embodiment.
FIG. 6 is a diagram illustrating an example of appearance order information according to the embodiment;
FIG. 7 is a diagram showing an example of specifying a journal conversion command according to the embodiment;
FIG. 8 is a flowchart showing a processing procedure of a journalizing process according to the embodiment.
FIG. 9 is a flowchart showing a processing procedure of a slip data reading process according to the embodiment.
FIG. 10 is a flowchart illustrating a processing procedure of a journal conversion command designation reading process according to the embodiment;
FIG. 11 is a diagram showing a list of conversion instructions according to the embodiment and the contents of the conversion operation description;
FIG. 12 is a flowchart illustrating a processing procedure of a termination process according to the embodiment;
FIG. 13 is a flowchart illustrating a processing procedure when base point information is different in step 719 according to the present embodiment.
FIG. 14 is a diagram illustrating an example of slip data after the journalizing process according to the embodiment;
FIG. 15 is a diagram showing an example of a combination of a supplier code, a department code, and a processing code in a general automatic journalizing process including a conventional technique.
[Explanation of symbols]
101, 102, 103, 104, 105, 106, 111: external storage device, 107: computer device, 108: CPU, 109: storage device, 110: input device, 112: external definition rule file read processing unit, 113: item Appearance order setting file reading processing unit, 114: Slip data file reading processing unit before journal processing, 115: Journal condition search processing unit, 117: Journal processing unit, 31: Slip data file, 32: Slip data, 33: Slip item data , 34: slip item data name, 35: slip item data value, 36: detail data, 37: slip item data name, 38: slip item data name, 39: slip item data value, 41: external definition rule file, 42: rule Block, 43: journal entry condition designation, 44: slip item data name designation, 45: slip item data Data specification, 46: journal conversion command specification, 47: journal conversion command, 48: conversion value, 51: slip data file, 52: slip data, 53: draft date, 54: draft date data, 55-59 ... Slip data, 81: appearance order information, 82: slip item data name, 83: appearance order, 61: journal conversion instruction designation, 62: journal conversion instruction, 63: conversion value, 64: journal conversion instruction designation, 65: journal conversion Instructions, 1001... Slip data file, 1002 and 1003... Slip data, 1004... Description 1 part, 1005... Description 2 part, 1101... Business partner, 1102... Department, 1103... Accounting system, 1104. Code: 1106: department code, 1107: processing code, 1108: automatic journalizing program.

Claims (24)

In the automatic journal processing method for journal entry work,
Reads an external definition rule file in which journal conditions indicating conditions for performing the journal processing and a journal method indicating the contents of the journal processing are registered, and stores the journal conditions and the journal methods registered in the external definition rule file in a storage device. Holding the
Reading the pre-journal processing slip data registered in the pre-journal processing slip data file and holding it in a storage device;
When the pre-journal processing voucher data held in the storage device satisfies the journal conditions, the pre-journal processing voucher data is subjected to journal processing by a journaling method held in pairs with the journal conditions, and the journal data is processed as journal processed voucher data. Storing in a storage device. From a plurality of externally defined rule files, separate journal conditions and journal methods are respectively stored in a storage device, and the journal data before journal processing held in the storage device is stored in a pair with the corresponding journal condition. 2. The automatic journalizing method according to claim 1, wherein the journalizing process is performed sequentially on the separately held journalizing conditions and the journalizing method. In the automatic journal processing method for journal entry work,
Reading the pre-journal processing slip data registered in the pre-journal processing slip data file and holding it in a storage device;
If the item content of the pre-journal processing slip data held in the storage device satisfies the journal condition indicating the content of any slip item, the journal processing of the pre-journal processing slip data is performed by a journaling method corresponding to the journal condition. Holding the data as journalized slip data in a storage device. In the automatic journal processing method for journal entry work,
Reading the pre-journal processing slip data registered in the pre-journal processing slip data file and holding it in a storage device;
When the item content of the pre-journal processing slip data held in the storage device satisfies a predetermined journal condition, the journal processing is performed according to a journal method including a command for converting according to a predetermined rule or newly adding data to the slip data. Journalizing the previous voucher data and holding the same as journalized voucher data in a storage device. 5. The journal processing according to claim 1, wherein the journal processing is performed by generating a plurality of detailed data from the detailed data included in the voucher data before the journal processing by the journal method. 6. Automatic journal processing method. 4. The system according to claim 1, wherein after the journal processing is completed, another program is called for each of the journal processed slip data units, and the journal processed slip data is passed to the separate program to perform predetermined processing. 5. The automatic journal processing method according to any one of 5. In an automatic journal processing unit that performs journal entry work,
Reads an external definition rule file in which journal conditions indicating conditions for performing the journal processing and a journal method indicating the contents of the journal processing are registered, and stores the journal conditions and the journal methods registered in the external definition rule file in a storage device. External definition rule file reading processing unit to be stored in the
A pre-journal processing slip data file reading processing unit that reads the pre-journal processing slip data registered in the pre-journal processing slip data file and holds the data in a storage device;
When the pre-journal processing voucher data held in the storage device satisfies the journal conditions, the pre-journal processing voucher data is subjected to journal processing by a journaling method held in pairs with the journal conditions, and the journal data is processed as journal processed voucher data. An automatic journal processing device, comprising: a journal processing unit that holds the data in a storage device. The external definition rule file reading processing unit stores, in a storage device, different journal conditions and a different journaling method from a plurality of external definition rule files, and the journal processing unit stores the journal stored in the storage device. It is characterized in that the process of performing journalizing on the pre-processing slip data by the journalizing method held in pairs with the corresponding journaling conditions is sequentially executed for the separately held journalizing conditions and the journalizing method. 8. The automatic journal processing device according to claim 7, wherein: In an automatic journal processing unit that performs journal entry work,
A pre-journal processing slip data file reading processing unit that reads the pre-journal processing slip data registered in the pre-journal processing slip data file and holds the data in a storage device;
If the item content of the pre-journal processing slip data held in the storage device satisfies the journal condition indicating the content of any slip item, the journal processing of the pre-journal processing slip data is performed by a journaling method corresponding to the journal condition. And a journal processing unit for holding the journal data as journal processed slip data in a storage device. In an automatic journal processing unit that performs journal entry work,
A pre-journal processing slip data file reading processing unit that reads the pre-journal processing slip data registered in the pre-journal processing slip data file and holds the data in a storage device;
When the item content of the pre-journal processing slip data held in the storage device satisfies a predetermined journal condition, the journal processing is performed according to a journal method including a command for converting according to a predetermined rule or newly adding data to the slip data. A journal processing unit for journalizing pre-voucher data and holding the same as journalized voucher data in a storage device. 7. The journal processing unit according to claim 7, wherein the journal processing unit generates the plurality of detailed data from the detailed data included in the pre-journal processing slip data by the journal method and performs the journal processing. Item 11. The automatic journal processing device according to any one of Items 10. After the journal processing is completed, the journal processing unit calls a separate program for the journal processed slip data unit, and passes the journal processed slip data to the separate program to perform a predetermined process. The automatic journal processing apparatus according to claim 7, wherein the automatic journalizing processing apparatus includes: In a program for causing a computer to function as an automatic journal processing device that performs journal entry work,
Reads an external definition rule file in which journal conditions indicating conditions for performing the journal processing and a journal method indicating the contents of the journal processing are registered, and stores the journal conditions and the journal methods registered in the external definition rule file in a storage device. External definition rule file reading processing unit to be stored in the
A pre-journal processing slip data file reading processing unit that reads the pre-journal processing slip data registered in the pre-journal processing slip data file and holds the data in a storage device;
When the pre-journal processing voucher data held in the storage device satisfies the journal conditions, the pre-journal processing voucher data is subjected to journal processing by a journaling method held in pairs with the journal conditions, and the journal data is processed as journal processed voucher data. A program for causing a computer to function as a journal processing unit held in a storage device. The external definition rule file reading processing unit stores, in a storage device, different journal conditions and a different journaling method from a plurality of external definition rule files, and the journal processing unit stores the journal stored in the storage device. It is characterized in that the process of performing journalizing on the pre-processing slip data by the journalizing method held in pairs with the corresponding journaling conditions is sequentially executed for the separately held journalizing conditions and the journalizing method. The program according to claim 13, wherein: In a program for causing a computer to function as an automatic journal processing device that performs journal entry work,
A pre-journal processing slip data file reading processing unit that reads the pre-journal processing slip data registered in the pre-journal processing slip data file and holds the data in a storage device;
If the item content of the pre-journal processing slip data held in the storage device satisfies the journal condition indicating the content of any slip item, the journal processing of the pre-journal processing slip data is performed by a journaling method corresponding to the journal condition. A program that causes a computer to function as a journal processing unit that holds the journal processed slip data in a storage device. In a program for causing a computer to function as an automatic journal processing device that performs journal entry work,
A pre-journal processing slip data file reading processing unit that reads the pre-journal processing slip data registered in the pre-journal processing slip data file and holds the data in a storage device;
When the item content of the pre-journal processing slip data held in the storage device satisfies a predetermined journal condition, the journal processing is performed according to a journal method including a command for converting according to a predetermined rule or newly adding data to the slip data. A program for causing a computer to function as a journal processing unit for journalizing pre-slip data and holding the journal data as journal processed slip data in a storage device. 14. The journal processing unit according to claim 13, wherein the journal processing unit generates the plurality of detail data from the detail data included in the pre-journal processing slip data by the journal method and performs the journal processing. Item 18. The program according to any one of items 16. After the journal processing is completed, the journal processing unit calls a separate program for the journal processed slip data unit, and passes the journal processed slip data to the separate program to perform a predetermined process. The program according to any one of claims 13 to 17, characterized by: In a computer-readable recording medium that records a program for causing a computer to function as an automatic journal processing device that performs a journal entry operation,
Reads an external definition rule file in which journal conditions indicating conditions for performing the journal processing and a journal method indicating the contents of the journal processing are registered, and stores the journal conditions and the journal methods registered in the external definition rule file in a storage device. External definition rule file reading processing unit to be stored in the
A pre-journal processing slip data file reading processing unit that reads the pre-journal processing slip data registered in the pre-journal processing slip data file and holds the data in a storage device;
When the pre-journal processing voucher data held in the storage device satisfies the journal conditions, the pre-journal processing voucher data is subjected to journal processing by a journaling method held in pairs with the journal conditions, and the journal data is processed as journal processed voucher data. A computer-readable recording medium on which a program for causing a computer to function as a journal processing unit held in a storage device is recorded. The external definition rule file reading processing unit stores, in a storage device, different journal conditions and a different journaling method from a plurality of external definition rule files, and the journal processing unit stores the journal stored in the storage device. It is characterized in that the process of performing journalizing on the pre-processing slip data by the journalizing method held in pairs with the corresponding journaling conditions is sequentially executed for the separately held journalizing conditions and the journalizing method. 20. The computer-readable recording medium according to claim 19, wherein: In a computer-readable recording medium that records a program for causing a computer to function as an automatic journal processing device that performs a journal entry operation,
A pre-journal processing slip data file reading processing unit that reads the pre-journal processing slip data registered in the pre-journal processing slip data file and holds the data in a storage device;
If the item content of the pre-journal processing slip data held in the storage device satisfies the journal condition indicating the content of any slip item, the journal processing of the pre-journal processing slip data is performed by a journaling method corresponding to the journal condition. A computer-readable recording medium characterized by recording a program for causing a computer to function as a journal processing unit that holds the journal processed slip data in a storage device. In a computer-readable recording medium that records a program for causing a computer to function as an automatic journal processing device that performs a journal entry operation,
A pre-journal processing slip data file reading processing unit that reads the pre-journal processing slip data registered in the pre-journal processing slip data file and holds the data in a storage device;
When the item content of the pre-journal processing slip data held in the storage device satisfies a predetermined journal condition, the journal processing is performed according to a journal method including a command for converting according to a predetermined rule or newly adding data to the slip data. A computer-readable recording medium in which a program for causing a computer to function as a journal processing unit for journalizing pre-slip data and holding the journal data as journal processed slip data in a storage device is recorded. 20. The journal processing unit according to claim 19, wherein the journal processing unit generates the plurality of item data from the item data included in the voucher data before the journal processing by the journal method and performs the journal processing. Item 23. A computer-readable recording medium according to any one of Item 22. After the journal processing is completed, the journal processing unit calls a separate program for the journal processed slip data unit, and passes the journal processed slip data to the separate program to perform a predetermined process. A computer-readable recording medium according to any one of claims 19 to 23.

Images