JP4981246B2 - Budget planning processing system and method, and computer program - Google Patents

Description

  The present invention relates to a budget planning processing system that performs budget planning processing using a computer, a method thereof, and a computer program thereof.

In companies, organizations, public institutions, etc., when performing budget planning processing using a computer, the organization may be changed after budget planning work. Also, organizational changes may be made or planned in parallel during the budget planning work period. Here, the organization change means that a unit organization such as a business division, a department, a section, or a room is newly established, abolished, or integrated.
Generally, Patent Document 1 is an example of an organization change handling process in a computer system used in a company or the like.

According to claim 1 of this patent document 1, the position of the “entity” in the organization is determined (position determination means), the relative relation between positions is determined (relation determination means), and the relative relation is determined according to the relative relation. A configuration is described in which information on a certain entity is specified whether it is accessible or impossible from other entities, and the access is controlled (information control means).
Further, claim 2 of the same document describes a configuration including data change enabling means for enabling change operation of at least one of position data and relation data in claim 1 described above.
JP 2004-126994 A

  In the above-mentioned patent document 1, no particular mention is made of the budget planning process associated with the organizational change. Organizational changes are frequently made in companies, etc., but once a budget plan is established, if the organization is consolidated or abolished, organizations that are no longer needed (including organizations that belong to the budget planning unit) Therefore, it is necessary to make the budget plan value appropriate for a newly redesigned organization (including an organization that is a budget planning unit belonging thereto).

  The present invention has been made in view of such circumstances, and an object of the present invention is to provide a budget planning processing system that can solve the above-described problems and can easily cope with organizational changes.

The present invention has been made to solve the above problems.
The budget plan processing system according to the present invention updates the budget plan value stored in the budget plan value storage means based on budget plan value storage means for storing the budget plan value for each organization and given transfer slip data. A budget plan processing system comprising: an update unit; a reception unit that receives an input of designation of an organization to be processed; and a budget plan value related to a process target organization that is received by the reception unit from the budget plan value storage unit Reading means for reading, and posting slip data generating means for generating posting slip data for clearing the budget plan value to “0” based on the budget plan value read by the reading means , When the abolished organization is identified by the acceptance means, the budget plan value of the parent organization of the abolished organization identified in the organization having a tree structure is identified. It is characterized in that only budget planned amount of tissue Deprecated be reduced.

  Further, the present invention is the above-described budget plan processing system, wherein the budget plan value storage unit is a budget plan value table storing a budget plan value for each organization, and the reception unit specifies an organization to be processed. And the designation of the target fiscal year and the target plan version are received, and the reading means reads the budget plan value corresponding to the specified organization, fiscal year and plan version from the budget plan value table. The posting slip data generation means calculates a summary value for each predetermined period based on the budget plan value read by the reading means, and multiplies the summary value by “−1” (minus 1) to obtain the posting slip data. It is characterized by generating.

  In the budget plan processing system described above, the present invention updates the corresponding amount item on the update detail storage table to “0” (zero) corresponding to the posting slip data generated by the posting slip data generation means. It further comprises a detail storage table update means.

  In the budget plan processing system according to the present invention, the budget plan value storage unit is a budget plan value table and an update information history table for storing a budget plan value for each organization, and the reception unit is a processing target. And the designation of the target fiscal year, the target plan version, and the target instruction number, and the reading means reads the specified organization, fiscal year, plan version, and instruction number. Is read from the update information history table, and the posting slip data generation means multiplies the budget planning value read by the reading means by “−1” (minus 1) to generate posting slip data. Furthermore, the update information history table is set with the amount corresponding to the budget plan value read by the reading means as “0” (zero). It is characterized in that it comprises the update information history table updating means to update.

Further, the present invention provides budget plan value storage means for storing a budget plan value for each organization, and update means for updating the budget plan value stored in the budget plan value storage means based on given transfer slip data. , a reception unit, a reading unit, a budget planning processing method in budget planning process system comprising a posting documents data generating means, a Keru with receives the specification of the tissue in which the receiving unit is processed accepted comprising the steps, wherein a budget planning values the reading means reading the read process from the budget planning value storing means about the organization of the processing target that has been received by the receiving process, based on the budget planning values read by the reading process, have a, and posting documents data generation process of the posting documents data generation means generates the posting documents data in order to clear the budget plan value to "0", you in the acceptance process When tissue is identified to be abolished Te, the budgeting value of parent organization of the tissue to be obsolete identified in tissue with a tree structure, it is reduced by the budget planned amount of tissue to be obsolete identified Is a budget plan processing method characterized by

In the budget plan processing method described above, the budget plan value storage means may be a budget plan value table in which a budget plan value for each organization is stored. Specifies receives with vignetting Rutotomoni, accepted the designation of plan version as a fiscal year, and the target of interest, in the read process, budget planning value a corresponding to the specified organization and year and plan version read from the budget planning value table, in the posting documents data generation process, the summary value is calculated on the basis of the read budget planned value for each predetermined period in the reading process, "-1" is multiplied by the summary value it is characterized in that provided by posting documents data is generated.

Further, according to the present invention, in the budget plan processing step, the budget plan processing system further includes an update detail storage table update unit, and the update detail storage table update unit generates the posting generated in the posting slip data generation step. budget planning processing method further comprising the updated item storage table updating process of updating the appropriate amount fields on slip data to update item storage table corresponds to "0", the.

In the budget plan processing method described above, the budget plan value storage means may include a budget plan value table and an update information history table in which a budget plan value for each organization is stored. The designation of the target organization is accepted, and the designation of the target fiscal year, the target plan version, and the target instruction number are accepted. In the reading process, the specified organization, fiscal year, and plan are specified. The budget plan value corresponding to the version and the instruction number is read from the update information history table, and in the posting slip data generation process, the budget plan value read in the reading process is multiplied by "-1" to post the posting slip. are those data are generated, the budget planning processing system further comprises an update information history table updating means, said update information history tape That Le updating means, characterized by further comprising an update information history table update process of the amount corresponding to the budget planning value read out by said read and process set to "0" for updating the update information history table It is.

  Further, the present invention is a computer program that causes a computer to execute any one of the budget plan processing methods described above.

  Hereinafter, the best mode for carrying out the present invention will be described.

  Hereinafter, an embodiment of the budget plan processing system of the present invention will be described. FIG. 1 is a schematic diagram showing a configuration of a budget plan processing system according to the present embodiment. In FIG. 1, reference numeral 1 denotes a budget plan processing system. Reference numeral 2 denotes a user terminal device. The user can access the budget plan processing system 1 by operating the user terminal device 2 to execute processing functions provided in the system or refer to data stored in the system. The budget plan processing system 1 exists as a partial function of an accounting system (not shown).

  The budget plan processing system 1 includes a processing unit 11 and a storage unit 12 therein. The processing unit 11 executes various processes for the budget planning process, and is realized using, for example, a computer system. The storage unit 12 stores various data necessary for budget planning processing, and is realized using, for example, a storage device (semiconductor storage device, magnetic hard disk device, optical disk device, etc.) of a computer system. The processing unit 11 includes a transcription processing unit 111 for performing a transcription process. The storage unit 12 includes a budget plan management table 121, posting slip data 122, an update details storage table 123, and an update information history table 124. The meaning of these various tables or data will be described later.

  Next, the organization handled by the budget plan processing system 1 will be described. FIG. 2 is a schematic diagram illustrating an example of an organization handled by the budget plan processing system 1. The organization shown in FIG. 2 has a hierarchical structure, and the “whole” of the first layer (the uppermost layer) represents the whole company or the like. In the second layer, “organization A” and “organization B” exist, and these organizations belong to the above-mentioned “entire”. In the third layer (the lowest layer in this example), “organization A1”, “organization A2”, “organization A3”, “organization B1”, and “organization B2” exist. Among these third layer organizations, “organization A1” to “organization A3” belong to the “organization A”, and “organization B1” and “organization B2” belong to the “organization B”. ing. As described above, in the example illustrated in FIG. 2, the tissue in the lower layer belongs to one of the tissues in the upper layer. In other words, these organizations constitute a tree structure.

  FIG. 3 is an example of an organization table expressing the organization shown in FIG. 2 as data on a computer system. This organization table exists on the storage unit 12. The organization table shown in FIG. 3 is relational data in a tabular format, and includes columns of organization code, organization name, and parent organization. The organization code is a code for uniquely identifying each organization. The organization name is the name of the organization. The parent organization is the organization code of the parent organization to which the organization directly belongs. For example, in the first line of the data illustrated in FIG. 3, the organization code is “100001”. The organization name of the organization “100001” is “whole”. Since the organization is the top-level organization, there is no parent organization, and therefore “(None)” is recorded in the parent organization column. Also, for example, in the fourth row, the organization code is “100004”. The organization name of the organization “100004” is “organization A1”. Since the organization code of the parent organization of the organization is “100002” (its organization name is “organization A”), “100002” is recorded in the parent organization column. The same applies to the other rows of the data.

  FIG. 4 is a schematic diagram illustrating an example of a budget plan value in an organization. In FIG. 4, the organization configuration exemplified in FIGS. 2 and 3 and the budget plan value for each organization in the organization are shown in correspondence with each other. The budget plan value is a value of a specific item in the organization's budget, and specifically, is a sales plan value, a specific cost plan value, an asset amount plan value, or the like.

  In the example shown in FIG. 4, the budget plan values of the organization A1, organization A2, and organization A3, which are the lowest organizations, are “10,000,000”, “11,000,000”, and “80,000”, respectively. is there. The budget plan value of the organization A that is the parent organization of these organizations A1 to A3 is “21,800,000”, which is the sum of the budget plan values. Further, the budget plan values of the organization B1 and the organization B2, which are the lowest layers, are “10,000,000” and “12,000,000”, respectively. The budget plan value of the organization B which is the parent organization of these organizations B1 and B2 is “22,000,000” which is a value obtained by adding these. The budget plan value of “overall” which is the highest organization is “43,800,000” which is a value obtained by adding the budget plan values of organization A and organization B. The unit of the budget plan value shown here is, for example, a currency unit such as “yen”, “dollar”, “euro”, and the same applies to the following description.

  FIG. 5 is an example of a budget plan value table (budget plan value storage means) representing the budget plan values shown in FIG. 4 as data on a computer system. This budget plan value table exists on the storage unit 12. The organization table shown in FIG. 5 is relational data in the form of a table and includes columns of organization code and budget plan value. For example, the second line of the data illustrated in FIG. 5 represents an organization whose organization code is “100002”, that is, organization A, and its budget plan value is “21,800,000”. Further, for example, the fourth row of the data represents an organization whose organization code is “100004”, ie, organization A1, and its budget plan value is “10,000,000”.

Next, the change of the organization and the change of the budget plan value associated therewith will be described.
FIG. 6 is a schematic diagram illustrating an example of organization change. FIG. 6 shows that among the above-mentioned organizations, the organization A1 is abolished and the organization B1 is integrated into the organization A3.

  FIG. 7 is a schematic diagram showing a change in the budget plan value associated with the above-described organization change example. In the table shown in FIG. 7, the original budget plan value of the organization A1 is “10,000,000”, but since the organization is abolished, its correct value should be “0”. Similarly, the original budget plan value of the organization B1 is “10,000,000”, but since the organization is integrated into the organization A3 (that is, the organization B1 itself is abolished), the correct value is “ Should be “0”.

  FIG. 8 is a schematic diagram showing a budget plan value table that is updated in accordance with the organizational change when the organizational change is made. Corresponding to the “correct value” shown in FIG. 7, in FIG. 8, the budget plan value is updated to “0” in the row where the organization code is “100004” (that is, the row corresponding to the organization A1). . Similarly, in the row where the organization code is “100007” (that is, the row corresponding to the organization B1), the budget plan value is updated to “0”.

  An example of a processing procedure for updating as shown in FIG. 8 is as follows. That is, first, an organization to be abolished (including a case of being abolished by integration with another organization) is designated from outside. Specifically, for example, an organization code is input from the outside, or a target organization name is selected from the organization name list. The function (accepting means, accepting process) in the processing unit 11 accepts this selection performed by the user via the user terminal device (2). Based on this, the transfer processing unit (111) performs processing to read out the budget plan value of the target organization from the budget plan value table (reading means, read process), and based on the read budget plan value Then, posting slip data for updating the budget plan value is generated (posting slip data generation means, posting slip data generation process). This posting slip data is data for updating so that the budget plan value is cleared to zero. Based on the posting slip data, the budget plan value is updated by the updating means that the accounting system originally has. The update means originally possessed by the accounting system not only updates only the budget plan value but also updates related data together, so that the consistency of data in the system is maintained and no flaws occur.

  Next, a more specific example of the above process will be described.

<Example 1>
First, the organizational budget planning process will be described.
The budget planning process possessed by the accounting system according to the prior art does not correct the original data when the transfer destination is originally changed. For this reason, it is necessary to manually correct the original data. However, if correction processing is performed manually, wrinkles may occur in other parts of the system. Therefore, in this embodiment, a target organization is provided with a function of clearing a value.

  FIG. 9 is a schematic diagram showing the flow of the organization-specific budget planning process. As shown in FIG. 9, budget plan posting processing is executed (executed by the posting processing unit 111) based on data input by the user on the processing screen. As a result, the budget plan slip posting processing is started.

  FIG. 10 is a schematic diagram showing the procedure of the organization-specific budget planning process. As shown in the figure, as a processing procedure, first, in (1), an execution condition is checked. Next, in (2), budget plan data posted under the above execution conditions is acquired. This budget plan data is included in the budget plan value table (budget plan value storage means) in the budget plan management table (121), and corresponds to the budget plan value. Next, in (3), calculation processing is performed on the data acquired in (2). Next, in (4), the budget plan is transferred using the calculation processing result in (3), that is, the budget plan value table is updated.

FIG. 11 is a schematic diagram showing a processing screen for organization-specific budget planning processing. Each item shown in FIG. 11 will be described.
The company code is a mandatory input item, and specifies the company code to be processed. A single company code is specified.
The version is an indispensable input item and designates a plan version to be processed. That is, even if there are a plurality of (different versions) budget plans, it can be handled. Multiple versions can be specified.
The organization is an indispensable input item and designates the organization to be processed. Multiple organizations can be specified.
The fiscal year is a mandatory input item, and the target fiscal year is specified. A single fiscal year is specified.
The period (From and to) specifies the update period of the processing target data. In other words, in the fiscal year specified above, what number of accounting periods (here, “accounting period” is typically a month) to what number of accounting periods is to be processed. specify. If there is no input in this item, accounting periods 1 to 12 are targeted.
The processing data target selection is for selecting data to be processed. This is based on the assumption that there are a plurality of budget plan value update processes for the same organization, and the selection candidates in the case illustrated in FIG. 11 are “update process 1”, “update process 2”, “update process 3”. ”. When “update process 1” on the screen is selected, the data updated in “update process 1” is targeted. When “update process 2” is selected, the data updated in “update process 2” is targeted. When “update process 3” is selected, the data updated in “update process 3” is targeted.
The slip text is a text added as information to the budget plan value table.
Data of these items specified from the processing screen is received by a partial function of the processing unit 11 (accepting means, accepting process).

The processing target data acquisition in (2) shown in FIG. 10 reads and acquires the target amount for each target version, target organization, and fiscal year from the budget plan value table based on the following conditions (reading means, reading) process). The reason for acquiring by target version, target organization, and fiscal year is that a plurality of items can be specified on the processing screen as described above.
Data acquisition conditions are the company code specified on the processing screen, the company code is the plan version specified on the processing screen, the organization is the organization specified on the processing screen, and the fiscal year is processed The fiscal year specified on the screen is an AND (logical product) condition for the update data identification classification having a code corresponding to the processing target data selected on the processing screen.
The budget plan value table is a tabular relational table, and has columns such as company code, plan version, organization, fiscal year, and update data identification category. Furthermore, the period (within the fiscal year) (Period) column may be included.

  In the calculation process in (3) shown in FIG. 10, the calculation process is performed based on the value acquired from the process target data acquisition. At this time, the accounting period to be calculated is the accounting period specified on the processing screen. The calculation process first sorts the acquired data, calculates a summary value of the amount for each period, multiplies the summary value by “−1”, and updates budget plan update data (posted slip data (122)). Is generated (posted slip data generating means, posting slip data generating process).

  In the budget plan posting process in (4) shown in FIG. 10, based on the budget plan update data created above, the budget plan value table is created using the functions that the accounting system has as standard. Update (update means). That is, since the budget plan update data is a value obtained by multiplying the above summarized value by “−1”, by updating the budget plan value table using this budget plan update data, the numerical value is obtained as a result. Is cleared to zero. The updating method that the accounting system originally has is not only to update the data in the budget plan value table, but also to update the related data together. Does not occur.

<Example 2>
Next, an example of replacement calculation (planning) processing will be described.
The replacement calculation (planning) process possessed by the accounting system according to the prior art does not correct the original data when the transfer destination is originally changed. For this reason, it is necessary to manually correct the original data. However, the update to the budget plan value is a value in which the details of the processing results are further aggregated into organizational units, etc., so if manual correction processing is performed, there is a possibility that defects will occur in other parts of the system is there. Therefore, in this embodiment, a target organization is provided with a function of clearing a value.

  FIG. 12 is a schematic diagram showing the flow of replacement calculation (planning) processing. As shown in FIG. 12, budget plan posting processing is executed (executed by the posting processing unit 111) based on the data input by the user on the processing screen, and the process proceeds to budget plan slip posting processing as a result. Further, the update detail storage table is updated as a result of the budget plan posting process.

  FIG. 13 is a schematic diagram showing the procedure of replacement calculation (planning) processing. As shown in the figure, as a processing procedure, first, in (1), an execution condition is checked. Next, in (2), budget plan data that has been posted is acquired under the above execution conditions. This budget plan data is included in the budget plan value table (budget plan value storage means) in the budget plan management table (121), and corresponds to the budget plan value. Next, in (3), calculation processing is performed on the data acquired in (2). Next, in (4), the budget plan is transferred using the result of the calculation process in (3), that is, the budget plan value table is updated. Next, in (5), based on the information in (4) above, the amount of the target data on the update detail storage table is updated to “0”.

FIG. 14 is a schematic diagram showing a processing screen for replacement calculation (planning) processing. Each item shown in FIG. 14 will be described.
The company code is a mandatory input item, and specifies the company code to be processed. A single company code is specified.
The version is an indispensable input item and designates a plan version to be processed. That is, even if there are a plurality of (different versions) budget plans, it can be handled. Multiple versions can be specified.
The organization is an indispensable input item and designates the organization to be processed. Multiple organizations can be specified.
The fiscal year is a mandatory input item, and the target fiscal year is specified. A single fiscal year is specified.
The slip text is a text added as information to the budget plan value table.
Data of these items specified from the processing screen is received by a partial function of the processing unit 11 (accepting means, accepting process).

The processing target data acquisition in (2) shown in FIG. 13 reads and acquires the target amount for each target version, target organization, and fiscal year from the budget plan value table based on the following conditions (reading means, reading) process). The reason for acquiring by target version, target organization, and fiscal year is that a plurality of items can be specified on the processing screen as described above.
Data acquisition conditions are the company code specified on the processing screen, the company code is the plan version specified on the processing screen, the organization is the organization specified on the processing screen, and the fiscal year is processed This is the AND (logical product) condition of the fiscal year specified on the screen and the update data identification classification having a code corresponding to replacement calculation or amortization Sim (simulation). The replacement calculation depreciation Sim is a precondition for execution of replacement calculation (planning), and should be started as a pair, and therefore is always processed in the same version. Therefore, in this example, the selection item of the processing target data is not provided on the processing screen as in <Example 1>.
The budget plan value table is a tabular relational table, and has columns such as company code, plan version, organization, fiscal year, and update data identification category. Furthermore, the period (within the fiscal year) (Period) column may be included.

  In the calculation process in (3) shown in FIG. 13, the calculation process is performed based on the value acquired from the acquisition of the processing target data. The calculation process first sorts the acquired data, calculates a summary value of the amount for each period, multiplies the summary value by “−1”, and updates budget plan update data (posted slip data (122)). Is generated (posted slip data generating means, posting slip data generating process).

  In the budget plan posting process in (4) shown in FIG. 13, based on the budget plan update data created above, the budget plan value table is updated using the functions that the accounting system has as standard. (Update means). That is, since the budget plan update data is a value obtained by multiplying the above summarized value by “−1”, by updating the budget plan value table using this budget plan update data, the numerical value is obtained as a result. Is cleared to zero. The updating method that the accounting system originally has is not only to update the data in the budget plan value table, but also to update the related data together. Does not occur.

  In the update detail storage table update process in (5) shown in FIG. 13, the amount item in the update detail storage table is updated to “0” based on the information on the data updated in (4) above (update details) Storage table update means, update details storage table update process).

<Example 3>
Next, an example of the depreciation expense calculation process will be described.
The depreciation expense calculation process possessed by the accounting system according to the prior art does not modify the original data when the transfer destination is originally changed. For this reason, it is necessary to manually correct the original data. However, if correction processing is performed manually, wrinkles may occur in other parts of the system. Therefore, in this embodiment, a target organization is provided with a function of clearing a value.

  FIG. 15 is a schematic diagram showing the flow of the depreciation expense calculation process. As shown in FIG. 15, budget plan posting processing is executed (executed by the posting processing unit 111) based on data input by the user on the processing screen, and as a result, the budget plan slip posting processing is started.

  FIG. 13 is a schematic diagram showing the procedure of the depreciation expense calculation process. As shown in the figure, as a processing procedure, first, in (1), an execution condition is checked. Next, in (2), data is acquired from the update information history table (124, budget plan value storage means) under the above execution conditions. This data corresponds to the budget plan value. Next, in (3), calculation processing is performed on the data acquired in (2). Next, in (4), the budget plan is transferred using the result of the calculation process in (3), that is, the budget plan value table is updated. Next, in (5), the amount of data extracted from the update information history table in (2) is updated to “0”.

FIG. 17 is a schematic diagram showing a processing screen for the depreciation expense calculation processing. Each item shown in FIG. 17 will be described.
The company code is a mandatory input item, and specifies the company code to be processed. A single company code is specified.
The version is an indispensable input item and designates a plan version to be processed. In other words, it is possible to cope with a plurality of (different versions) budget plans. Multiple versions can be specified.
The organization is an indispensable input item and designates the organization to be processed. Multiple organizations can be specified.
The internal order is data (instruction number) updated by the internal order. It is possible to specify multiple internal instructions.
The fiscal year is a mandatory input item, and the target fiscal year is specified. A single fiscal year is specified.
The period (From and to) specifies the update period of the processing target data. In other words, in the fiscal year specified above, what number of accounting periods (here, “accounting period” is typically a month) to what number of accounting periods is to be processed. specify. If there is no input in this item, accounting periods 1 to 12 are targeted.
The slip text is a text added as information to the budget plan value table.
Note that the organization and internal instructions are not inputs under AND (logical product) conditions.
Data of these items specified from the processing screen is received by a partial function of the processing unit 11 (accepting means, accepting process).

The acquisition of processing target data in (2) shown in FIG. 16 is based on the following conditions, based on the following conditions, from the update information history table, the target amount (budget plan) by company code, target version, fiscal year, target organization, target instruction number Value) is read and acquired (reading means, reading process).
The data acquisition conditions are the company code specified on the processing screen, the company code is the plan version specified on the processing screen, the fiscal year is the fiscal year specified on the processing screen, and the organization The organization is designated on the processing screen, and the order number is the order number designated on the processing screen.
The update information history table is a tabular relational table with columns such as company code, plan version, fiscal year, organization, and instruction number, and a column for the period (period within the fiscal year). You may do it.

  In the calculation processing in (3) shown in FIG. 16, the calculation processing is performed based on the value acquired from the processing target data acquisition. At this time, the accounting period to be calculated is the accounting period specified on the processing screen. The calculation processing is to generate budget plan update data (posted slip data (122)) by multiplying the amount of acquired data by “−1” (posted slip data generating means, posting slip data generating process).

  In the budget plan posting process in (4) shown in FIG. 16, based on the budget plan update data created above, the budget plan value table is updated using the functions that the accounting system has as standard. (Update means). That is, since the budget plan update data is a value obtained by multiplying the acquired amount by “−1”, by updating the budget plan value table using this budget plan update data, the numerical value is obtained as a result. Is cleared. The updating method that the accounting system originally has is not only to update the data in the budget plan value table, but also to update the related data together. Does not occur.

  In the update processing of the update information history table in (5) shown in FIG. 16, only the amount corresponding to the accounting period specified on the processing screen is “0” in the data acquired in (2) above. Then, the update information history table is updated (update information history table update means, update information history table update process).

The terms used in the above description will be supplementarily explained here.
“Replacement calculation” refers to asset acquisition / removal and repair / retirement costs based on information such as construction cost, attachment / removal quantity, asset ledger, etc.・ Calculation of loss on disposal. Assets subject to replacement calculation are fixed assets that have the same type and quality, and are used in large quantities for the same purpose (for example, in the electric power industry, fixed assets consisting of large amounts of utility poles, electric wires, and other items) ) Refers to those parts that can no longer be used and can be replaced by almost the same quantity every fiscal year.
The “internal instruction” is one of the units for making a budget plan, and is used as a more detailed unit than an organization or when making a budget plan that spans multiple organizations.

The above-described budget plan processing system 1 has a computer system therein.
The series of processes related to the budget plan (processes executed by the processing unit 11) are stored in a computer-readable recording medium in the form of a program, and the computer reads and executes the program. The above processing is performed.
That is, each processing means and processing unit in the budget plan processing system 1 is such that a central processing unit such as a CPU reads the above program into a main storage device such as a ROM or RAM and executes information processing / calculation processing. Is realized.
Here, the computer-readable recording medium means a magnetic disk, a magneto-optical disk, a CD-ROM, a DVD-ROM, a semiconductor memory, or the like. Alternatively, the computer program may be distributed to the computer via a communication line, and the computer that has received the distribution may execute the program.
The storage unit 12 included in the budget plan processing system 1 is a storage device including a magnetic disk, a magneto-optical disk, a CD-ROM, a DVD-ROM, a semiconductor memory, and the like. This storage device also receives data from the computer. It is possible to read and write.

As described above, according to the budget planning processing system of the present invention, the user designates an organization that becomes unnecessary due to an organization change or the like, whereby the accepting unit accepts an input of designation of the organization to be processed, The reading unit reads the budget plan value relating to the accepted organization to be processed from the budget plan value storage unit, and the transfer slip data generation unit clears the budget plan value to zero based on the read budget plan value. In order to generate the posting slip data for this purpose, the updating means clears the budget plan value, so that it is possible to obtain a correct budget plan value.
Moreover, since the budget plan value is updated using the updating means provided in the standard accounting system, the budget plan value can be cleared so that no data flaws occur between the parts on the system.

Even when the system does not automatically aggregate the budget plan values for the upper hierarchy of the organization, or when the budget plan of the integration destination organization is newly formulated when a certain organization is integrated It is also possible to easily plan a new value by clearing the budget plan value of the corresponding organization by the configuration of the present invention.
In the examples from FIG. 2 to FIG. 8, only the total budget plan value is described for each organization for the sake of simplification. However, in actual work, more detailed units such as monthly and account items are used. It is thought that they are making a budget plan.
In this case, assuming that only the conventional technology is used, in order to input a new budget plan value to the system, the difference between the budget plan value that has already been established and the revised value is calculated, or unnecessary details are specified. It will be necessary to do troublesome work.
However, since the budget plan value can be easily cleared by using the present invention, there is an advantage that it is only necessary to input a newly revised value.

It is the schematic which shows the structure of the budget plan processing system by one Embodiment of this invention. It is the schematic showing an example of the organization which the budget plan processing system by the embodiment handles. The organization table showing the said organization on the budget plan processing system by the embodiment is shown. It is the schematic which shows the example of the budget plan value in the budget plan processing system by the embodiment It is an example of the budget plan value table which expressed the said budget plan value on the budget plan processing system by the embodiment. It is the schematic which shows an example of the change of the structure | tissue in the budget plan processing system by the embodiment. In the budget plan processing system by the embodiment, it is the schematic which shows the change of the budget plan value accompanying said organization change example. In the budget plan processing system by the embodiment, it is the schematic which shows the budget plan value table updated with the organization change. It is the schematic which shows the flow of the budget plan process classified by organization by the embodiment. It is the schematic which shows the procedure of the budget plan process classified by organization by the embodiment. It is the schematic which shows the process screen for the budget plan process classified by organization by the embodiment. It is the schematic which shows the flow of the replacement calculation (plan) process by the embodiment. It is the schematic which shows the procedure of the replacement calculation (plan) process by the embodiment. It is the schematic which shows the process screen for the replacement calculation (plan) process by the embodiment. It is the schematic which shows the flow of the depreciation expense calculation process by the embodiment. It is the schematic which shows the procedure of the depreciation expense calculation process by the embodiment. It is the schematic which shows the process screen for the depreciation expense calculation process by the embodiment.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 ... Budget plan processing system, 11 ... Processing part, 12 ... Storage part, 111 ... Transfer processing part, 121 ... Budget plan management table, 122 ... Posting slip data, 123 ... Update details preservation table, 124 ... Update information history table

Claims (7)

Budget plan value storage means for storing a budget plan value , a fiscal year, and a plan version for each organization having a tree structure composed of a subordinate organization and a superordinate organization in a budget plan value table ;
Updating means for updating the budget plan value stored in the budget plan value storage means based on the given posting slip data;
In a budget plan processing system comprising:
Accepting means for accepting input of condition designation of subordinate organization to be abolished, fiscal year and plan version ,
Reading means for reading out the budget plan value corresponding to the subordinate organization, the fiscal year and the plan version to be abolished accepted by the accepting means from the budget plan value table stored in the budget plan value storage means;
In order to clear the budget plan value read by the reading means to “0”, a summary value is calculated for each predetermined period based on the read budget plan value, and the summary value is multiplied by “−1” to give the posting slip data. Posting slip data generation means to generate,
Comprising
When the subordinate organization to be abolished is specified by the accepting means, the budget plan value of the upper organization higher than the subordinate organization to be abolished is reduced by the budget plan value of the subordinate organization to be abolished by the updating means. A budget planning processing system characterized by that. In the budget plan processing system according to claim 1 ,
An update details storage table update means for updating the corresponding amount item on the update details storage table to “0” corresponding to the posting slip data generated by the posting slip data generation means;
The budget plan processing system characterized by further comprising. In the budget plan processing system according to claim 1,
The budget plan value storage means is a budget plan value table and an update information history table for storing a budget plan value for each organization,
The accepting unit accepts designation of an organization to be processed and accepts designation of a target fiscal year, a target plan version and a target instruction number,
The reading means reads the budget plan value corresponding to the designated organization, fiscal year, plan version, and instruction number from the update information history table,
The posting slip data generation means generates posting slip data by multiplying the budget plan value read by the reading means by “−1”.
The budget plan processing system further comprises update information history table update means for updating the update information history table with an amount corresponding to the budget plan value read by the read means as “0”. Budget plan value storage means for storing a budget plan value , a fiscal year, and a plan version for each organization having a tree structure composed of a subordinate organization and a superordinate organization in a budget plan value table ;
Updating means for updating the budget plan value stored in the budget plan value storage means based on the given posting slip data, a receiving means, a reading means, a posting slip data generating means,
A budget plan processing method in a budget plan processing system comprising:
The accepting means for accepting input of condition designation of a subordinate organization to be abolished, a fiscal year and a plan version ;
A reading process in which the reading unit reads out from the budget plan value table stored in the budget plan value storage unit the budget plan value corresponding to the abolished organization, fiscal year, and plan version received in the reception process;
Based on the budget plan value read in the reading process, the posting slip data generation means clears the budget plan value to “0”, so that a summary value is calculated for each predetermined period based on the read budget plan value. A transfer slip data generation process for generating the transfer slip data by multiplying the summary value by “−1” ;
Have
When a subordinate organization to be abolished in the reception process is specified, the budget plan value of the superior organization higher than the subordinate organization to be abolished is reduced by the budget plan value of the subordinate organization to be abolished. A budget plan processing method characterized by that. In the budget planning process according to claim 4 ,
The budget plan processing system further comprises an update details storage table update means,
An update detail storage table update process in which the update detail storage table update means updates the corresponding amount item on the update detail storage table to “0” corresponding to the posting slip data generated in the posting slip data generation process;
A budget plan processing method characterized by further comprising: In the budget plan processing method according to claim 4 ,
The budget plan value storage means is a budget plan value table and an update information history table in which a budget plan value for each organization is stored,
In the reception process, designation of an organization to be processed is accepted, and designation of a target fiscal year, a target plan version, and a target instruction number are received,
In the reading process, the budget plan value corresponding to the designated organization, fiscal year, plan version, and instruction number is read from the update information history table,
In the posting slip data generation process, the budget plan value read in the reading process is multiplied by “−1” to generate posting slip data,
The budget plan processing system further comprises update information history table update means,
The update information history table update means further includes an update information history table update process for updating the update information history table with an amount corresponding to the budget plan value read in the read process as “0”. Budget planning processing method. A computer program for causing a computer to execute the budget planning processing method according to any one of claims 4 to 6 .

Images