JP5085848B2 - Simulation apparatus, unnecessary data deleting method, and computer program - Google Patents

Description

  The present invention relates to a simulation apparatus, an unnecessary data deletion method, and a computer program.

In a simulation apparatus that performs accounting simulation, simulation is performed using plan data indicating the future plan amount and expected amount of accounting. For comparison of simulation results, when a simulation is to be performed using various types of plan data, the user processes the actual account data or other plan data that has already been generated, and those plans are processed. It was generating data.
On the other hand, Patent Document 1 discloses a technique in which unnecessary data is not left on a memory by deleting intermediate result data calculated by simulation. Patent Document 2 discloses a technique for reducing the simulation time of a common part for a plurality of test data in a simulation system.
JP 09-073442 A Japanese Patent Laid-Open No. 08-161360

  When a user generates accounting plan data used for accounting simulation, unnecessary plan data may be erroneously generated. Since the simulation apparatus also performs simulation on the unnecessary plan data, there is a problem that the execution of the simulation takes time and load, and the performance of the system is deteriorated. Therefore, it is conceivable to delete unnecessary plan data in advance before simulation execution. Conventionally, unnecessary plan data has been searched and manually deleted by the user, which is a complicated operation. It was. However, in Patent Literature 1 and Patent Literature 2, unnecessary plan data is not deleted in advance from accounting plan data to be subject to accounting simulation.

  The present invention has been made in view of such circumstances, and a simulation apparatus, an unnecessary data deleting method, and a computer program capable of deleting unnecessary plan data from accounting plan data to be executed as an accounting simulation. The purpose is to provide.

In order to solve the above-described problems, the present invention provides a simulation apparatus (10) for performing a simulation of accounting, among fiscal year, profit center, account code, debit or credit information, transaction type, or business partner. It shows the key information consisting of 1 or more, and actual data amounts extracted from accounting documents data corresponding to the key information the sum for each phase of accounting, used in the simulation of the accounting, planning amount for each period of the accounting target of stores the actual plan data consisting of one or more planning data, and storage means for storing a summary data indicating the planned amount of each period summarizing any of the planning data (20), the unnecessary data deleted identify and receives the condition including the key information, planning amount for each period of the planning data of said storage means (20) that matches the conditions While deleting the plan data which is the value of the predetermined range assumed not to be a normal value, among the summary data in the storage means (20) corresponding to the deleted plan data, the plan amount for each period Unnecessary data deleting means (16) that deletes summary data that is a value in a predetermined range that is assumed to be not a normal value, and that does not delete summary data that is not a value in the predetermined range. Features.

  Moreover, this invention is the simulation apparatus mentioned above, Comprising: The said unnecessary data deletion means (16) WHEREIN: The plan amount of each period is all 0 among the plan data in the said memory | storage means (20) which meets the said conditions. The plan data is deleted, and the summary data in which the plan amount for each period is all 0 is deleted from the summary data in the storage means (20) corresponding to the deleted plan data.

The present invention also relates to a method for deleting unnecessary data used in a simulation apparatus (10) that performs accounting simulation, and includes a fiscal year, profit center, account code, debit or credit information, transaction type, or transaction and key information consisting of one or more of the preceding, and actual data obtained by adding the amount extracted from the accounting documents data corresponding to each phase of accounting key information used in the simulation of the accounting, planning for each period of the accounting stores the actual plan data consisting of one or more planning data indicating the amount, stored in the storage means (20) provided in the own summary data indicating the planned amount of each period summarizing any of the planning data, identify the target of the unnecessary data deleted, and receives an input of conditions including the key information, the planning data of said storage means (20) that matches the conditions That is, the plan data in a predetermined range in which the plan amount for each period is assumed to be not a normal value is deleted, and the summary data in the storage means (20) corresponding to the deleted plan data Among them, summary data that is a value in a predetermined range in which the planned amount of each period is assumed to be not a normal value is deleted, and summary data that is not a value in the predetermined range is not deleted (steps S250 and S260). ).

In the present invention, the computer used in the simulation apparatus (10) for simulating accounting can be one or more of the fiscal year, profit center, account code, debit or credit information, transaction type, or business partner. and the key information composed of the actual data amounts extracted from accounting documents data corresponding to the key information the sum for each phase of accounting, used in the simulation of the accounting, 1 or more indicating the planned amount for each period of the accounting of stores planned actual plan data comprising the data storage means (20) for storing a summary data indicating the planned amount of each period summarizing any of the planning data, identifies the target of the unnecessary data deleted and receives input conditions including the key information, plans amount for each period of the planning data of said storage means (20) that match the conditions normally The plan data within a predetermined range assumed not to be a value is deleted, and the plan amount for each period is normal among the summary data in the storage means (20) corresponding to the deleted plan data A computer program for deleting summary data that is a value in a predetermined range that is assumed not to be a negative value and functioning as unnecessary data deleting means (16) that does not delete summary data that is not a value in the predetermined range It is.
It should be noted that “(sign)” referred to in this column only exemplifies a corresponding configuration in a column (the best mode for carrying out the invention) to be described later, and does not indicate any claim in the claims. The interpretation is not limited.

  According to the above invention, the plan data indicating the planned amount for each period of accounting used for the simulation of the accounting satisfies the condition specified by the user, and the planned amount for each period is outside the range of assumed amounts. The plan data, in particular, the plan data in which the plan amount for each period is all “0” is deleted. Accordingly, it is possible to delete only unnecessary plan data created by mistake while protecting the necessary plan data, and it is possible to reduce the burden on the user related to the deletion of unnecessary plan data. In addition, the time required for accounting simulation processing can be shortened, and the load on the system can be reduced.

Hereinafter, an embodiment of the present invention will be described with reference to the drawings.
FIG. 1 is a block diagram illustrating a configuration of an accounting apparatus 10 as a simulation apparatus according to an embodiment of the present invention, and only functional blocks related to the present invention are extracted and shown. The accounting device 10 can be configured by a computer device such as a server or a personal computer, for example. The accounting apparatus 10 includes an input unit 11, an output unit 12, an accounting processing unit 13, an actual / plan data editing unit 14, a simulation executing unit 15, an unnecessary data deleting unit 16, and a storage unit 20.

The input means 11 is a keyboard, a mouse, or the like, and has a function for acquiring information input by the user. Information may be received from a client terminal such as a personal computer or PDA (Personal Digital Assistants) connected via a network.
The output means 12 is a display such as a CRT (cathode ray tube) or LCD (liquid crystal display). Image information to be displayed on a client terminal connected via a network may be output.

The storage unit 20 includes an accounting slip data storage unit 21, an actual / plan data storage unit 22, and a summary data storage unit 23.
The accounting slip data storage means 21 stores accounting slip data indicating information on accounting slips generated by various transactions. The actual / plan data storage means 22 stores actual / plan data consisting of actual data indicating actual amounts in accounting and plan data indicating planned amounts for accounting used for accounting simulation. The summary data storage means 23 stores summary data indicating the planned amount of money that is a collection of arbitrary plan data.

  The accounting processing means 13 generates accounting slip data from the transaction information received via the input means 11 and registers it in the accounting slip data storage means 21. The actual / plan data editing unit 14 edits the generation / update / deletion of the actual / plan data based on the instruction received via the input unit 11, and the edited actual / plan data is used as the actual / plan data. Register in the plan data storage means 22. The simulation execution means 15 executes the accounting simulation process using the plan data in the actual / plan data storage means 22. The unnecessary data deleting means 16 deletes unnecessary data from the plan data and summary data that meet the conditions specified by the user.

Next, a configuration example of each data held by the accounting apparatus 10 will be described.
FIG. 2 is a diagram showing a configuration example of accounting slip data stored in the accounting slip data storage means 21.
The accounting slip data includes header information and one or more detailed information. The header information includes information such as a slip number, a fiscal year, a slip date, a profit center, a transaction type, and a business partner. The slip number uniquely identifies accounting slip data. The profit center indicates a minimum organization as a unit for managing accounting. The detail information includes a record including information such as a detail number, item code, product name, account code, debit / credit, unit price, quantity, and amount. The item number uniquely identifies the item information in the accounting slip data. The product name indicates the name of an article or the like to be traded. The item code is a code for identifying an item such as an article to be traded. The account code is a code for identifying an account item.

FIG. 3 is a diagram showing a configuration example of the actual / plan data stored in the actual / plan data storage means 22 and the summary data stored in the summary data storage means 23.
The actual / plan data includes key information, actual data, and one or more plan data. Here, the key information is the fiscal year, the profit center, and the account code, but debit / credit, transaction type, business partner, etc. may be added to the key information. The actual data indicates the actual amount for each accounting period. The plan data indicates the plan amount for each accounting period. The actual / plan data includes a plurality of plan data entries, and identification information of plan 1, plan 2, plan 3,... Is assigned to the first, second, third,. The accounting period can be any period such as every month, every quarter, etc. For example, in the case of every month, accounting period 1 is January, accounting period 2 is February, etc. be able to. In the figure, the key information of the actual / plan data is the fiscal year “200X”, the profit center “xxxxxxxx”, and the account code “YY”, and the actual amount of the actual data is “100” in the accounting period 1 Period 2 is “200”, accounting period 3 is “0”, and so on. In addition, the plan amount of “plan 1”, which is the plan data of the first entry, is “100” for the accounting period 1, “200” for the accounting period 2, “0” for the accounting period 3, and so on. The plan amount of “plan 2”, which is the plan data of the entry “”, is “0” for the accounting period 1, “0” for the accounting period 2, “0” for the accounting period 3,.

  The summary data consists of the planned amount obtained by summing the planned amounts for each accounting period for one or more arbitrary planned data in the actual / planned data, and the above-mentioned plan data from which this planned amount was calculated. It consists of key information in the actual / plan data included. For example, the plan data can be generated for each detailed category, and a comprehensive plan amount combining them can be shown as summary data. In the figure, the key information of the summary data includes the fiscal year “200X”, the profit center “xxxxxxxx”, and the account code “YY”. For the plan data of the second entry (plan 2) and the third entry (plan 3), the sum of the plan amounts for each accounting period is set.

Next, the operation of the accounting apparatus 10 will be described.
The accounting apparatus 10 stores accounting slip data in the accounting slip data storage unit 21.
Specifically, every time a transaction occurs, the user inputs information on the generated transaction to the accounting apparatus 10 by the input means 11. The transaction information includes fiscal year, slip date, profit center, transaction type, business partner, item code, product name, account code, debit / credit, unit price, quantity, amount, and the like. Upon receipt of the transaction information input from the input means 11, the accounting processing means 13 assigns a slip number to generate accounting slip data and writes it to the accounting slip data storage means 21.

The user generates actual / plan data before performing the accounting simulation.
FIG. 4 shows a flowchart of the actual / plan data editing process of the accounting apparatus 10.
The actual / plan data editing means 14 receives from the input means 11 key information as editing target conditions such as the fiscal year, profit center, and account code entered by the user (step S110). The actual / plan data editing means 14 searches the actual / plan data storage means 22 based on the received editing target condition, and determines whether the actual / plan data matching the editing target condition has been registered (step S120).

  When the actual / plan data matching the editing target condition has already been registered (step S120: Yes), the actual / plan data editing unit 14 reads the actual / plan data from the actual / plan data storage unit 22 (step S120). S130). On the other hand, when the actual / plan data that matches the editing target condition is not registered (step S120: No), the actual / plan data editing means 14 newly generates actual / plan data (step S140). The actual / plan data editing means 14 sets the key information input as the editing target condition in the key information of the newly generated actual / plan data. Further, the actual / plan data editing means 14 reads accounting slip data that matches the editing target condition from the accounting slip data storage means 21. Then, the amount is extracted from the read accounting slip data, totaled for each accounting period, and written in the actual data in the actual / plan data. The accounting period can be specified from the slip date. Subsequently, the actual / plan data editing means 14 copies the actual data to the plan data of the first entry.

  Next, the actual / plan data editing means 14 edits the plan data such as addition, update, and deletion according to the instruction input by the user through the input means 11 (step S150). The planned amount for each accounting period when adding or updating the plan data is, for example, an arbitrary calculation (eg, 10% increase, 100 addition, etc.) for the actual amount of actual data or the planned amount of other plan data. Alternatively, it is set by copying or inputting an arbitrary amount of money. By generating plan data based on the actual data, it is possible to create a highly accurate plan amount.

  After finishing the editing of the plan data, the actual / plan data editing means 14 adds or updates the summary data corresponding to the edited plan data in accordance with the instruction input by the user via the input means 11 (step S160). That is, the user inputs an entry of plan data that is a target for generating summary data via the input unit 11. When the summary data generated based on the designated plan data has already been registered in the summary data storage means 23, the actual / plan data editing means 14 will make the plan amount for each accounting period of the designated plan data. To calculate the planned amount and update the summary data. When the summary data generated based on the designated plan data is not registered in the summary data storage unit 23, the actual / plan data editing unit 14 generates and registers new summary data. In the generated summary data, the plan amount calculated by summing the plan amount for each fiscal period of the specified plan data and the key information of the actual / plan data including the specified plan data are set. The The actual / plan data editing means 14 registers the actual / plan data obtained by editing the plan data (step S170).

  After editing the plan data, the user inputs an accounting simulation execution instruction by the input means 11. The simulation execution means 15 executes an accounting simulation process using the plan data in the results / plan data registered in the results / plan data storage means 22. The accounting simulation process is executed by existing accounting simulation application software or the like. After executing the simulation, the simulation execution unit 15 outputs the used plan data, summary data generated using the plan data, simulation results, and the like from the output unit 12.

  In the editing of the plan data in the above step S150, when the plan amount is cleared to 0, the copy source actual amount is “0”, or there is an error in calculation, the plan amount for each accounting period is Plan data of all “0” may be generated. In addition, when all of the planned amounts for each accounting period of all the planning data from which summary data is calculated are set to “0” by editing the planning data, all the planned amounts for each accounting period of this summary data are also “ 0 ". When the accounting simulation is executed, the simulation process is also performed on unnecessary plan data whose plan amounts for all the accounting periods are all “0”, so that it takes time and load to execute the simulation, and the performance of the accounting apparatus 10 is increased. Will fall. Therefore, unnecessary plan data is deleted in advance before executing the simulation. However, the plan data in which the plan amount for each accounting period is all “0” is not necessarily unnecessary plan data. For this reason, the user designates the condition for the unnecessary data deletion execution target, and deletes the plan data in which the plan amounts for each accounting period are all “0” within the range of the condition.

FIG. 5 shows a flowchart of unnecessary data deletion processing of the accounting apparatus 10.
The user inputs conditions for executing unnecessary data deletion to the accounting apparatus 10 via the input unit 11 (step S210). Conditions for executing unnecessary data deletion are specified by identification of profit center, account code, fiscal year, plan data, and the like. The unnecessary data deleting unit 16 receives information on the condition for executing unnecessary data deletion from the input unit 11. The unnecessary data deleting means 16 checks whether or not the input unnecessary data deletion execution condition is valid (step S220). For example, whether or not the profit center, account code, and fiscal year values are valid, and whether or not the plan data that matches the conditions for executing unnecessary data deletion is registered in the actual / plan data storage means 22. to decide.

  When the unnecessary data deleting means 16 determines that the check is OK (step S230: Yes), the plan data that matches the condition of the unnecessary data deletion execution target (hereinafter referred to as “plan data of the unnecessary data deletion execution target”) is described. ) And the summary data generated based on the plan data are locked so that they cannot be accessed by other processes such as reading and writing (step S240).

Next, the unnecessary data deleting means 16 deletes the entry of the plan data whose plan amounts for each accounting period are all “0” from the plan data to be subjected to unnecessary data deletion execution (step S250). Furthermore, the unnecessary data deleting means 16 searches the summary data generated based on the plan data deleted in step S250, and deletes the summary data in which all the plan amounts for each accounting period are “0” (step S260). The unnecessary data deleting unit 16 unlocks the actual / plan data and summary data locked in step S240, and enables access such as reading and writing from other processes (step S270). The unnecessary data deletion means 16 displays the unnecessary data deletion execution result (step S280). The unnecessary data deletion execution result includes conditions for executing unnecessary data deletion, the number of deleted plan data, summary data, and the like.
If it is determined in step S230 that the check is not OK (step S230: NO), it is output that the inputted unnecessary data deletion execution target condition is invalid and the unnecessary data deletion processing has not been executed. (Step S280).

FIG. 6 shows an example of an unnecessary data deletion execution target condition input screen output by the accounting apparatus 10 in order to allow the user to input the unnecessary data deletion execution target condition in step S210 of FIG.
In the figure, an input field A1 for inputting a code for identifying a company code, profit center group, profit center, account group, account code, fiscal year, and plan data entry is displayed as a condition for executing unnecessary data deletion. ing. The company and the profit center group include one or more profit centers. Therefore, a profit center is specified by designating a company or profit center group. In addition, an account group is configured by collecting any one or more account codes. Therefore, the account code is specified by specifying the account group.
The user inputs an unnecessary data deletion execution target condition and then clicks the execution button A2 by clicking with the mouse. Thereby, the unnecessary data deletion process shown in FIG. 5 is executed. The unnecessary data deletion processing may be executed immediately after the execution button A2 is pressed, or may be executed when the load on the accounting apparatus 10 is low due to batch processing or the like.

  FIG. 7 shows an example of an unnecessary data deletion execution result display screen output by the accounting apparatus 10 in step S280 of FIG. In the figure, the number of plan data and summary data deleted as unnecessary data for each company code and fiscal year is displayed.

  In the above, the plan data and summary data in which the plan amount for each accounting period is all “0” are deleted, but the plan amount for each accounting period is a predetermined value or a value within a predetermined range. Data and summary data may be deleted. For example, plan data and summary data in which a plan amount that is clearly larger than an assumed plan amount is set can be deleted as having been generated due to a mistake.

  According to the above embodiment, the unnecessary data deleting unit 16 of the accounting apparatus 10 satisfies the conditions specified by the user among the plan data in the actual / plan data storage unit 22 used for the accounting simulation, and each period The plan data in which the plan amount is outside the range of the assumed amount, in particular, plan data in which the plan amount for each period is all “0” is deleted. Accordingly, it is possible to delete only unnecessary plan data created by mistake while protecting the necessary plan data, and it is possible to reduce the burden on the user related to the deletion of unnecessary plan data. Further, the time required for the accounting simulation process of the accounting apparatus 10 can be shortened, and the load on the system can be reduced.

  The accounting apparatus (simulation apparatus) 10 described above has a computer system inside. The operation process of the accounting processing means 13, the actual / planned data editing means 14, the simulation executing means 15 and the unnecessary data deleting means 16 of the accounting apparatus 10 described above is recorded on a computer-readable recording medium in the form of a program. The above processing is performed by the computer system reading and executing this program. The computer system here includes an OS and hardware such as peripheral devices.

  In addition to ROM, “computer-readable recording medium” refers to a portable medium such as a magnetic disk, a magneto-optical disk, a CD-ROM, a DVD-ROM, or a storage device such as a hard disk built in a computer system. That means. Furthermore, the “computer-readable recording medium” refers to a volatile memory (RAM) inside a computer system that becomes a client or a system when a program is transmitted via a network such as the Internet or a communication line such as a telephone line. In addition, those holding programs for a certain period of time are also included.

Further, the “computer system” includes a homepage providing environment (or display environment) if a WWW system is used.
The “computer-readable recording medium” refers to a storage device such as a flexible medium, a magneto-optical disk, a portable medium such as a ROM and a CD-ROM, and a hard disk incorporated in a computer system. Furthermore, the “computer-readable recording medium” dynamically holds a program for a short time like a communication line when transmitting a program via a network such as the Internet or a communication line such as a telephone line. In this case, a volatile memory in a computer system serving as a server or a client in that case, and a program that holds a program for a certain period of time are also included. The program may be a program for realizing a part of the functions described above, and may be a program capable of realizing the functions described above in combination with a program already recorded in a computer system.

It is a block diagram of the accounting apparatus as a simulation apparatus by one Embodiment of this invention. It is a figure which shows the structural example of the accounting slip data by the embodiment. It is a figure which shows the structural example of the results, plan data, and summary data by the embodiment. It is a figure which shows the flowchart of the performance and plan data edit process in the accounting device by the embodiment. It is a figure which shows the flowchart of the unnecessary data deletion process in the accounting apparatus by the embodiment. It is a figure which shows the example of the condition input screen of the unnecessary data deletion execution object by the embodiment. It is a figure which shows the example of the unnecessary data deletion execution result display screen by the embodiment.

Explanation of symbols

10 ... Accounting equipment (simulation equipment)
DESCRIPTION OF SYMBOLS 11 ... Input means 12 ... Output means 13 ... Accounting processing means 14 ... Result / plan data editing means 15 ... Simulation execution means 16 ... Unnecessary data deletion means 20 ... Storage means 21 ... Accounting slip data storage means 22 ... Actual / plan data storage means 23 ... Summary data storage means

Claims (4)

In a simulation device that performs accounting simulation,
Accounting year, profit center, account code, debit or credit information, transaction type, or key information consisting of one or more of the business partners and the amount extracted from the accounting slip data corresponding to the key information and actual data obtained by summing the each term is used in the simulation of the accounting, stores the actual plan data consisting of one or more planning data indicating the planned amount for each period of the accounting, summarizes any of the planning data a storage means for storing the summary data that shows the plan the amount of each period,
The target for deleting unnecessary data is specified , and the condition including the key information is input, and the planned amount of each period of the planned data in the storage means that matches the condition is not a normal value It is assumed that plan data that is a value in a predetermined range assumed is deleted, and that the plan amount for each period is not a normal value among the summary data in the storage means corresponding to the deleted plan data. Unnecessary data deleting means that deletes summary data that is a value in a predetermined range and does not delete summary data that is not a value in the predetermined range;
A simulation apparatus comprising: The unnecessary data deleting unit deletes the plan data in which the plan amount of each period is all zero from the plan data in the storage unit that matches the condition, and the storage unit corresponding to the deleted plan data Delete the summary data for which the planned amount for each period is all 0
The simulation apparatus according to claim 1. A method for deleting unnecessary data used in a simulation apparatus for simulating accounting,
Accounting year, profit center, account code, debit or credit information, transaction type, or key information consisting of one or more of the business partners and the amount extracted from the accounting slip data corresponding to the key information and actual data obtained by summing the each term is used in the simulation of the accounting, stores the actual plan data consisting of one or more planning data indicating the planned amount for each period of the accounting, summarizes any of the planning data stores the summary data that shows the plan the amount of each period in a storage unit provided in the own,
The target for deleting unnecessary data is specified , and the condition including the key information is input, and the planned amount of each period of the planned data in the storage means that matches the condition is not a normal value It is assumed that plan data that is a value in a predetermined range assumed is deleted, and that the plan amount for each period is not a normal value among the summary data in the storage means corresponding to the deleted plan data. Delete summary data that is a value within a predetermined range, and do not delete summary data that is not a value within the predetermined range.
An unnecessary data deletion method characterized by the above. A computer used in a simulation device that performs accounting simulation,
Accounting year, profit center, account code, debit or credit information, transaction type, or key information consisting of one or more of the business partners and the amount extracted from the accounting slip data corresponding to the key information and actual data obtained by summing the each term is used in the simulation of the accounting, stores the actual plan data consisting of one or more planning data indicating the planned amount for each period of the accounting, summarizes any of the planning data storage means for storing the summary data that shows the plan the amount of each period,
The target for deleting unnecessary data is specified , and the condition including the key information is input, and the planned amount of each period of the planned data in the storage means that matches the condition is not a normal value It is assumed that plan data that is a value in a predetermined range assumed is deleted, and that the plan amount for each period is not a normal value among the summary data in the storage means corresponding to the deleted plan data. Unnecessary data deleting means for deleting summary data that is a value in a predetermined range and not deleting summary data that is not a value in the predetermined range;
Computer program to function as.

Images