CN101645158A - Method suitable for parallel computation of multi-currency asset depreciation of multiple assets - Google Patents
Method suitable for parallel computation of multi-currency asset depreciation of multiple assets Download PDFInfo
- Publication number
- CN101645158A CN101645158A CN200910018624A CN200910018624A CN101645158A CN 101645158 A CN101645158 A CN 101645158A CN 200910018624 A CN200910018624 A CN 200910018624A CN 200910018624 A CN200910018624 A CN 200910018624A CN 101645158 A CN101645158 A CN 101645158A
- Authority
- CN
- China
- Prior art keywords
- depreciation
- asset
- assets
- unit
- amortization
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 78
- 238000004364 calculation method Methods 0.000 claims abstract description 8
- 238000004422 calculation algorithm Methods 0.000 claims description 11
- 238000005516 engineering process Methods 0.000 claims description 8
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 238000004321 preservation Methods 0.000 claims description 2
- 238000010586 diagram Methods 0.000 description 5
- 230000006978 adaptation Effects 0.000 description 2
- 230000001413 cellular effect Effects 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 239000012467 final product Substances 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 230000000052 comparative effect Effects 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a method suitable for the parallel computation of the multi-currency asset depreciation of multiple assets, comprising the following steps: establishing the relation between theassets of different categories and an asset depreciation unit according to the definition of the asset depreciation unit and the set of asset card information in the management of intangible asset amortization and fixed asset depreciation calculation in enterprises so as to simultaneously parallel compute the current period depreciation amount of a same asset according to different depreciation methods in global different countries under the requirements of different accounting postulates, and saving a computed result into a asset depreciation table according to months; circularly computing the depreciation amount again according to the depreciation computation method till a current month is computed when an original value and residual value reset condition influences the depreciation ofprevious months; setting the depreciation unit; defining the depreciation methods; defining an asset card; defining the relation between assets and the depreciation unit; and defining the save of depreciation data. Final asset depreciation or amortization amount is in accordance with a depreciation or amortization computation method taking the asset card and the depreciation unit as a core, thus the parallel computation of the multi-currency asset depreciation of multiple assets is finally realized.
Description
Technical field
The present invention relates to the application technology of a kind of computing machine in financial sector, specifically a kind of asset depreciation meter that is used for the multiple assets Multiple Currencies of resource management software adaptation is carried parallel calculating method.
Background technology
Depreciation disposal route for assets in the present erp software mainly is according to accounting standard the capital assets in the enterprise to be carried out calculating and distilling depreciation according to the depreciation method of correspondence, in fact in the assets of enterprise, all need to handle depreciation, amortization, various deferred assets, intangible asset as enterprise, the easy-consumed goods of low value all need calculate the amortization volume each issue according to its value and life expectancy even, and relevant cost, the expenses account of each phase gone at the stand by stages; Difference, depreciation (or amortization) method difference, the money of account do not take different algorithms to calculate on an equal basis respectively during causing different assets because of depreciation (or amortization) like this, cause enterprise asset management to be disperseed, and can not concentrate to manage; Be subjected to the tax in addition, can take into account managerial requirement, can adopt multiple different depreciation method parallel computation to a kind of assets, contrast depreciation and observation are to the influence of enterprise profit; Price volalility was excessive when the residual value of some assets was handled, need to adjust the residual value coefficient, counted the depreciation of proposing during before can influencing like this, depreciation need be recomputated or the like, these demands can cause software often to carry out coding change satisfying enterprise assets and adjust requirement, therefore how to design general suitable all kinds of assets calculating and distilling depreciations (or amortization) algorithm and tackle the complicacy of enterprise assets depreciation flexibly, a kind of implementation method that adapts to the asset depreciation parallel computation of many assets Multiple Currencies that the present invention that Here it is will realize.
Summary of the invention
The purpose of this invention is to provide a kind of method that adapts to the asset depreciation parallel computation of many assets Multiple Currencies.
The objective of the invention is to realize in the following manner, this method comprises the following steps and content:
A, the wide range of information projects of using the depreciation unit (seeing accompanying drawing 1) is set: depreciation element number, title, the corresponding depreciation method etc.
B, the wide range of information projects (seeing accompanying drawing 2) of depreciation (or amortization) is set: depreciation numbering, depreciation title, computing formula.
C, definition assets cards (seeing accompanying drawing 3) comprise assets information, monetary information, value information, deadline information and other self-defined informations that will use.
D, assets and depreciation unit be set concern content (seeing accompanying drawing 4): asset number, depreciation element number; Define the depreciation unit of each each assets correspondence in batches, must method carry out related with the various calculating and distilling depreciations (or amortization) of wanting assets like this; If assets have the depreciation method more than 2 kinds to carry out parallel computation, the corresponding depreciation element number more than 2 of assets must be set then.
E, by the depreciation formula definition of the depreciation method one by one or the depreciation of calculating each assets in batches carry, the result after the calculating is stored in the asset depreciation tables of data and (sees accompanying drawing 5).
The implementation method of F, the concrete business by model instanceization, implementation method comprises 3 steps: (1) determines environment for use, selects IT technology and the instrument realized; (2) design the data structure of the example of this model description, data structure comprises: a) the depreciation cell data structure of core; Depreciation method data structure; Assets card data structure; Assets and depreciation unit relational data structure; Asset depreciation deposit data data structure (3) selects suitable programming tool realization foreground and back-end data mutual, realizes the asset depreciation parallel computation of many assets Multiple Currencies.
In the setting up procedure of depreciation unit, at first to define the various formula that asset depreciation (or amortization) will be used, for the on-fixed assets, the amortization formula of then definition correspondence, when next defines the depreciation unit, the currency and the exchange rate that will use when selecting the corresponding depreciation method and depreciation to calculate according to actual needs; During the initial wealth card image, necessary typing assets information, monetary information, value information and deadline information, asset depreciation information is selected corresponding depreciation unit as country variant, the tax and accounting standard etc. according to actual needs, calls when calculating in order to asset depreciation; If the conversion of asset depreciation method, then need the time of expiration of the old depreciation of typing unit, typing begins the time limit and gets final product in new depreciation unit.
The calculating of asset depreciation (or amortization), the depreciation method that writes down in the depreciation unit according to each asset association, the money of account and the exchange rate are as basis, at first be to resolve the formula that defines in depreciation (or amortization) method, the asset item information that reduction is used, taking out its value corresponding by asset item information in database calculates by the formula after resolving, inconsistent in the computation process as the money of account, then convert by the currency in the depreciation unit and the exchange rate, final cycle calculations goes out the amount of depreciation of each assets in this period in each depreciation unit, and its depreciation data finally are saved in the depreciation tables of data (sees accompanying drawing 5).If, only need repeat top algorithm, until calculating current month according to the depreciation formula during initial because when adjusting amount of depreciation during reasons such as residual value or initial value need recomputate history.
Excellent effect of the present invention is:
Description of drawings
Fig. 1 is a depreciation cellular construction synoptic diagram;
Fig. 2 is depreciation (or amortization) method structural representation;
Fig. 3 is an assets card chip architecture synoptic diagram;
Fig. 4 is that assets and depreciation unit concern synoptic diagram;
Fig. 5 is an asset depreciation structured data repository synoptic diagram.
Embodiment
With reference to Figure of description to explaining below the work of the present invention.
The implementation method of the asset depreciation parallel computation of many assets of adaptation Multiple Currencies of the present invention, comprise the setting (shown in Figure 1) of depreciation unit, the definition (shown in the accompanying drawing 2) of the depreciation method and the definition (shown in Figure 3) of assets card, assets and the related definition of depreciation unit and the preservation definition of depreciation data, final asset depreciation (or amortization) volume is a foundation according to depreciation (or amortization) computational algorithm that is core with assets card and depreciation unit, finally realizes the asset depreciation parallel computation of multiple assets Multiple Currencies:
A. depreciation unit item attribute is described below:
1) depreciation element number: the numbering of certain depreciation unit of unique sign.
2) depreciation unit title: the title of sign depreciation unit correspondence, as the X state X depreciation method
3) the corresponding depreciation method: derive from depreciation method table, identify the depreciation method that this depreciation unit is used.
4) the single numbering of corresponding depreciation (or amortization): during sign depreciation clearing and asset number, during result after unique identification calculates together.
5) calculate Currency Type: the currency of using that depreciation is calculated.
6) exchange rate: the exchange rate of calculating Currency Type conversion standard coin.
B. depreciation method attribute description is as follows:
1) depreciation method item attribute is realized according to the type of structural drawing regulation as depreciation numbering, depreciation title, computing formula, no longer describes.
C. assets card chip architecture attribute description is as follows:
1) asset number: the numbering of unique these some assets of sign.
2) assets title: the title of sign assets.
3) class of assets: identify these assets and belong to which classification,, can segment as capital assets, intangible asset etc.
4) other assets attribute: increase according to actual needs.
5) Currency Type: the transaction currency that identifies these assets.
6) exchange rate: the exchange rate during the sign transaction
7) standard coin: one's own department or unit Currency Type of sign assets in accounting.
8) initial value: the original value when the sign assets form.
9) depreciations already prepared volume: the amount of depreciation that the sign assets have taken place when forming.
10) residual value: the salvage value after the sign asset retirement.
11) term of life: the time bar that can use continuously when the sign assets form.
12) add up service time: already used time bar when the sign assets are initial.
13) meter is carried the time: equal term of life and deduct totally service time.
D. assets and depreciation unit relationship description are as follows:
1) asset number: derive from assets card dictionary, the sign assets.
2) depreciation element number: derive from the depreciation unit-dictionary, the sign assets are used the data cell of depreciation correspondence when calculating, and assets can corresponding a plurality of data cells, but want corresponding one at least.
3) beginning, time of expiration: identify the time limit that these assets can be calculated in this depreciation unit.
E. asset depreciation tables of data attribute description is as follows:
1) asset number: derive from assets card table, the assets that the sign depreciation is calculated.
2) during: during the place that the sign depreciation is calculated.
3) the single numbering of depreciation: the single numbering of depreciation of record depreciation unit, it and asset number, during identify a record in the depreciation table together uniquely.
4) initial depreciation: come from balance brought forward.
5) this month depreciation: the amount of depreciation after asset depreciation is calculated
6) this month, write off depreciation: the amount of depreciation that record needs assets to write off
7) depreciation at the end of month remaining sum: equal initial depreciation+this month depreciation-this month abatement depreciation.
F, be depreciation (or the amortization) computational algorithm of core with assets card and depreciation unit
In the setting up procedure of depreciation unit, at first to define the various depreciation methods that asset depreciation (or amortization) will be used, for the on-fixed assets, the amortization formula of then definition correspondence, when next defines the depreciation unit, the currency and the exchange rate that will use when selecting the corresponding depreciation method and depreciation to calculate according to actual needs; During the initial wealth card image, necessary typing assets information, monetary information, value information and deadline information, asset depreciation information is selected corresponding depreciation unit as country variant, the tax and accounting standard etc. according to actual needs, calls when calculating in order to asset depreciation; If the conversion of asset depreciation method, then need be in assets and depreciation unit relation table time of expiration of the old depreciation of typing unit, typing begins the time limit and gets final product in new depreciation unit.
The calculating of asset depreciation (or amortization), the depreciation method that writes down in the depreciation unit according to each asset association, the money of account and the exchange rate are as basis, at first be to resolve the formula that defines in depreciation (or amortization) method, the asset item information that reduction is used, taking out its value corresponding by asset item information in database calculates by the formula after resolving, inconsistent in the computation process as the money of account, then convert by the currency in the depreciation unit and the exchange rate, final cycle calculations goes out the amount of depreciation of each assets in this period in each depreciation unit, and its depreciation data finally are saved in the depreciation tables of data (sees accompanying drawing 5).If, only need repeat top algorithm, until calculating current month according to the depreciation formula during initial because when adjusting amount of depreciation during reasons such as residual value or initial value need recomputate history.
Embodiment
A. the instantiation method of the asset depreciation parallel computation of multiple assets Multiple Currencies in the asset management process:
Asset management system implementation model is described be the core calculations algorithm with assets card and depreciation unit before, need to use department's dictionary, class of assets dictionary and Asset State dictionary etc. in the asset management system, the relation of record assets and these dictionaries in the assets card is described the relation of sundry assets, the setting of depreciation unit, depreciation unit and assets etc. with assets card model, depreciation model of element and assets card and depreciation unit relational model.Model instanceization needs following steps:
1) 1 data of description structure is at first carried out the definition and the method for data cell with reference to the accompanying drawings.
2) 2 data of description structures are carried out the definition and the method for the depreciation method with reference to the accompanying drawings.
3) 3 data of description structures are carried out the definition and the method for assets card with reference to the accompanying drawings.
4) 4 concern synoptic diagram with reference to the accompanying drawings, set up the management of assets card and depreciation unit relation.
5) after depreciation is calculated and finished, computing information is saved in the depreciation tables of data (seeing accompanying drawing 5)
B. the implementation method after the model instanceization:
By the model instance method the concrete depreciation method, depreciation unit are provided with, after the instantiation of depreciation calculation process, need example are realized out by the IT technology, for final user provides use.The realization of example may further comprise the steps:
1) according to user's environment for use and requirement, select suitable IT technology and instrument, as: database technology, programming tool etc.;
2) according to the technology and the instrument that use, design back-end data structure.The critical field attribute of depreciation cellular construction is with reference to accompanying drawing 1; The critical field attribute of assets card chip architecture is with reference to accompanying drawing 3; The critical field attribute of asset depreciation tables of data is with reference to accompanying drawing 5.
3) use programming tool, realize that the user foreground represents.By the visit of programming realization to data in the back-end data structure, can give that the user carry out multiple asset management usually, multiple Currency Type depreciation meter is carried, multiple depreciation method parallel computation also is analyzed respectively, investigate of the influence of each depreciation method to enterprise profit, enterprise can be provided with flexibly according to actual conditions like this, realizes the calculating of the different depreciation methods of different assets.
Method of the present invention must be including but not limited to described step of claims and content, and the order of step can be adjusted and refinement; In the implementation procedure of model, to satisfy the data structure of describing in the instructions, and realize realizing the asset depreciation parallel computation of many assets Multiple Currencies on this basis according to aforementioned algorithm, thereby solve in the asset depreciation in the resource management software (or amortization) skimble-scamble requirements such as multiple currency, different depreciation method comparative analyses are arranged.
Claims (4)
1, a kind of method that adapts to the asset depreciation parallel computation of many assets Multiple Currencies, it is characterized in that, enterprise amorization of intangible assets, depreciation of fixed assets meter are carried the management in, according to the definition of asset depreciation unit and the setting of assets card image, set up the relation of different classes of assets and asset depreciation unit, thereby realize same assets under global country variant, different accounting standard require according to the different depreciation methods amount of depreciation of parallel computation assets current periods simultaneously, the result after the calculating is by being saved in month in the asset depreciation table; What the appearance initial value was reset, residual value replacement situation influences month depreciation in the past, then according to depreciation algorithm cycle calculations again, until calculating current month, method also comprises the setting of depreciation unit, the definition of the depreciation method and the definition of assets card, assets and the related definition of depreciation unit and the preservation definition of depreciation data, final asset depreciation or amortization volume are foundation according to the depreciation or the amortization computational algorithm that are core with assets card and depreciation unit, and finally realize the asset depreciation parallel computation of multiple assets Multiple Currencies: concrete calculation procedure is as follows:
A, the wide range of information projects that the depreciation unit is used is set: depreciation element number, title, the corresponding depreciation method;
B, the wide range of information projects of depreciation or amortization is set: depreciation numbering, depreciation title, computing formula;
C, definition assets card comprise assets information, monetary information, value information, deadline information and other self-defined informations that will use;
D, the content that concerns of assets and depreciation unit is set: asset number, depreciation element number; Define the depreciation unit of each each assets correspondence in batches, carry out related with the various methods of calculating and distilling depreciation or amortization of wanting assets; Assets have the depreciation method more than 2 kinds to carry out parallel computation, and the corresponding depreciation element number more than 2 of assets then must be set;
E, by the depreciation formula definition of the depreciation method one by one or the depreciation of calculating each assets in batches carry, the result after the calculating is stored in the asset depreciation tables of data.
2, method according to claim 1, it is characterized in that, in the setting up procedure of depreciation unit, at first to define the various formula that asset depreciation or amortization will be used, for the on-fixed assets, the amortization formula of then definition correspondence, when next defines the depreciation unit, the currency and the exchange rate that will use when selecting the corresponding depreciation method and depreciation to calculate according to actual needs; During the initial wealth card image, necessary typing assets information, monetary information, value information and deadline information, asset depreciation information according to actual needs, country variant, the tax and accounting standard are selected corresponding depreciation unit, call when calculating in order to asset depreciation; The conversion of asset depreciation method occurs, then need the time of expiration of the old depreciation of typing unit, typing begins the time limit in new depreciation unit.
3, method according to claim 1, it is characterized in that, the calculating of asset depreciation or amortization, the depreciation method that writes down in the depreciation unit according to each asset association, the money of account and the exchange rate are as basis, at first be to resolve the formula that defines in depreciation or the amortization method, the asset item information that reduction is used, taking out its value corresponding by asset item information in database calculates by the formula after resolving, the money of account is inconsistent in the computation process, then convert by the currency in the depreciation unit and the exchange rate, final cycle calculations goes out the amount of depreciation of each assets in this period in each depreciation unit, its depreciation data finally are saved in the depreciation tables of data, when adjusting the amount of depreciation during residual value or initial value reason need recomputate history, only need to repeat top algorithm, until calculating current month according to the depreciation formula during initial.
4, by the implementation method of model, it is characterized in that comprise following 3 steps: (1) determines environment for use, select IT technology and the instrument realized the concrete business of asset depreciation parallel computation; (2) design the data structure of the example of this model description, data structure comprises: a) the depreciation cell data structure of core; Depreciation method data structure; Assets card data structure; Assets and depreciation unit relational data structure; Asset depreciation deposit data data structure (3) selects suitable programming tool realization foreground and back-end data mutual, realizes the asset depreciation parallel computation of many assets Multiple Currencies.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910018624A CN101645158A (en) | 2009-09-07 | 2009-09-07 | Method suitable for parallel computation of multi-currency asset depreciation of multiple assets |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910018624A CN101645158A (en) | 2009-09-07 | 2009-09-07 | Method suitable for parallel computation of multi-currency asset depreciation of multiple assets |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101645158A true CN101645158A (en) | 2010-02-10 |
Family
ID=41657037
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910018624A Pending CN101645158A (en) | 2009-09-07 | 2009-09-07 | Method suitable for parallel computation of multi-currency asset depreciation of multiple assets |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101645158A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102446304A (en) * | 2010-10-08 | 2012-05-09 | 金蝶软件（中国）有限公司 | Real-time data processing method and device |
| CN104616195A (en) * | 2015-03-04 | 2015-05-13 | 中国农业银行股份有限公司 | Method and apparatus for processing limit-generating data |
| CN109598600A (en) * | 2018-11-13 | 2019-04-09 | 阿里巴巴集团控股有限公司 | A kind of method, device and equipment adjusting tail difference of keeping accounts in foreign currency accounting |
| CN110766536A (en) * | 2019-09-25 | 2020-02-07 | 金蝶软件（中国）有限公司 | Data processing method, data processing device, computer equipment and storage medium |
| CN114611930A (en) * | 2022-03-11 | 2022-06-10 | 佛山职业技术学院 | Intelligent fixed asset management method and system based on cloud platform |
-
2009
- 2009-09-07 CN CN200910018624A patent/CN101645158A/en active Pending
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102446304A (en) * | 2010-10-08 | 2012-05-09 | 金蝶软件（中国）有限公司 | Real-time data processing method and device |
| CN102446304B (en) * | 2010-10-08 | 2015-06-03 | 金蝶软件（中国）有限公司 | Real-time data processing method and device |
| CN104616195A (en) * | 2015-03-04 | 2015-05-13 | 中国农业银行股份有限公司 | Method and apparatus for processing limit-generating data |
| CN109598600A (en) * | 2018-11-13 | 2019-04-09 | 阿里巴巴集团控股有限公司 | A kind of method, device and equipment adjusting tail difference of keeping accounts in foreign currency accounting |
| WO2020098366A1 (en) * | 2018-11-13 | 2020-05-22 | 阿里巴巴集团控股有限公司 | Method, apparatus and device for adjusting accounting tail error in foreign currency accounting |
| CN110766536A (en) * | 2019-09-25 | 2020-02-07 | 金蝶软件（中国）有限公司 | Data processing method, data processing device, computer equipment and storage medium |
| CN110766536B (en) * | 2019-09-25 | 2023-07-07 | 金蝶软件（中国）有限公司 | Data processing method, device, computer equipment and storage medium |
| CN114611930A (en) * | 2022-03-11 | 2022-06-10 | 佛山职业技术学院 | Intelligent fixed asset management method and system based on cloud platform |
| CN114611930B (en) * | 2022-03-11 | 2022-09-27 | 佛山职业技术学院 | Intelligent fixed asset management method and system based on cloud platform |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6904411B2 (en) | Multi-processing financial transaction processing system | |
| US7668768B2 (en) | Computer-implemented method for evaluating an investment | |
| US20050256789A1 (en) | Real-time consolidated accounting systems and real-time consolidated accounting program | |
| CN109670945B (en) | Comprehensive risk early warning decision platform based on big data | |
| Heinze | Cost management of capital projects | |
| CN101645158A (en) | Method suitable for parallel computation of multi-currency asset depreciation of multiple assets | |
| CN112052385A (en) | Investment and financing project recommendation method and device, electronic equipment and readable storage medium | |
| US8229822B2 (en) | Computer-implemented method for financial analysis | |
| US20030105695A1 (en) | Processing system for market efficiency value added | |
| CN101189632A (en) | Data processing method for time optimal computation of large result data sets | |
| US20050234786A1 (en) | General ledger maintenance in an inventory accounting system | |
| CN110968622B (en) | Accounting report customization method, platform and terminal | |
| CN113139740A (en) | Comprehensive information management service system suitable for small-scale operator | |
| CN112950225A (en) | Customer category determination method, device and storage medium | |
| US8359214B1 (en) | System and method for processing data related to charges applicable to investment accounts | |
| CN113538157B (en) | Annuity cost management method and annuity cost management device | |
| CN117437059A (en) | Cash flow data processing method and device | |
| JP2021149688A (en) | Information processing device, information processing method, and program | |
| CN116701424A (en) | Data processing method, apparatus, computer device, storage medium, and program product | |
| Westland et al. | Substantive Tests | |
| CN115660860A (en) | Personal investment internal yield calculation method and system and computer equipment | |
| CN115239477A (en) | Interest calculation method and device | |
| CN114764740A (en) | Data processing method and data processing device | |
| CN113450202A (en) | Credit rating system and credit rating method | |
| Stevenson | Profits in the Modern Economy |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20100210 |