CN109598484A - A kind of project under construction turns fixed assets number auditing method and device - Google Patents
A kind of project under construction turns fixed assets number auditing method and device Download PDFInfo
- Publication number
- CN109598484A CN109598484A CN201811475736.9A CN201811475736A CN109598484A CN 109598484 A CN109598484 A CN 109598484A CN 201811475736 A CN201811475736 A CN 201811475736A CN 109598484 A CN109598484 A CN 109598484A
- Authority
- CN
- China
- Prior art keywords
- audit
- data
- regulation
- articles
- under construction
- 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 51
- 238000010276 construction Methods 0.000 title claims abstract description 36
- 238000012550 audit Methods 0.000 claims abstract description 262
- 239000000463 material Substances 0.000 claims description 28
- 238000012546 transfer Methods 0.000 claims description 7
- 238000000605 extraction Methods 0.000 claims description 3
- 239000007787 solid Substances 0.000 description 14
- 238000004519 manufacturing process Methods 0.000 description 10
- 230000008569 process Effects 0.000 description 8
- 238000007726 management method Methods 0.000 description 6
- 230000005540 biological transmission Effects 0.000 description 5
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000000116 mitigating effect Effects 0.000 description 3
- 238000012545 processing Methods 0.000 description 3
- 230000009466 transformation Effects 0.000 description 3
- 241001269238 Data Species 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000005259 measurement Methods 0.000 description 2
- 238000012360 testing method Methods 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000008901 benefit Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 210000001520 comb Anatomy 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 238000009472 formulation Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 1
- 239000010931 gold Substances 0.000 description 1
- 229910052737 gold Inorganic materials 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/08—Construction
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the present application discloses a kind of project under construction and turns fixed assets number auditing method, comprising: the initial value of default N is 1, S1: according to the audit demand got, from transferring in database and the associated data information of trial engineering in audit demand；S2: the N articles audit regulation is read from default audit regulation table；S3: it is extracted and the N articles associated Audit data of audit regulation from data information；S4: sentencing formula according to the logic in the N articles audit regulation, and the logic operation result of corresponding the N articles audit regulation is calculated using Audit data；S5: if logic operation result is very, Audit data to be labeled as problem data；S6: making the N that N+1 is new, judges the audit regulation item number whether new N is greater than in default audit regulation table, if it is not, S2 is returned to, if so, terminating；It solves in traditional audit, auditor's heavy workload, low efficiency, audit project technical problem at high cost.
Description
Technical field
This application involves fields of automation technology more particularly to a kind of project under construction to turn fixed assets number auditing party
Method, device and storage medium.
Background technique
Project under construction can regard the process for collecting project cost as, and project under construction is changed into fixed assets (letter
Claim to turn solid), it is the process that project switchs to individual event assets, and from the management of project cost to the transformation of asset management.
Turn one of the content that solid audit is state-owned assets auditing work.When carrying out turning to audit admittedly, auditor is by looking into
Engineering project archives papery document file is read, inquiry correlation is by auditor, in conjunction with systems such as operation system, the asset management systems
Derived underlying assets list audits relevant information point according to auditor's professional experiences one by one, and makes specially
Industry judgement.However, in this mode of operation, no matter simple or complicated, all project information require auditor
Processing, workload is huge, heavy operating pressure is brought to auditor, and audit efficiency is low.
Summary of the invention
The embodiment of the present application, which provides a kind of project under construction and turns fixed assets number auditing method, device and storage, to be situated between
Matter is solved when turning to audit admittedly, and all project datas require auditor's processing, and auditor's pressure is overweight and examines
The technical issues of counting inefficiency.
In view of this, the application first aspect, which provides a kind of project under construction, turns fixed assets number auditing method, wrap
Include: the initial value of default N is 1,
S1: it according to the audit demand got, is associated with from being transferred in database with the trial engineering in the audit demand
Data information；
S2: the N articles audit regulation is read from default audit regulation table；
S3: it is extracted and the associated Audit data of the N articles audit regulation from the data information；
S4: sentencing formula according to the logic in the N articles audit regulation, calculates the corresponding N using the Audit data
The logic operation result of audit regulation；
S5: if the logic operation result is very, the Audit data to be labeled as problem data；
S6: the N for keeping N+1 new, judge the audit the rule whether new N is greater than in the default audit regulation table
Then item number, if it is not, the S2 is returned to, if so, terminating.
Preferably, after the S5 further include:
Described problem data are output to audit issues inventory.
Preferably, after the S5 further include:
Described problem data are graphically associated with the N articles audit regulation and export display.
Preferably, the S1 is specifically included:
According to the audit demand got, transferred from goods and materials database, financial database and project database and institute
State the associated data information of trial engineering in audit demand.
Preferably, after the S1 further include:
The data information is screened, invalid data is removed.
Preferably, described that the data information is screened, after removal invalid data further include:
The data information is exported to display in the form of wide table.
The application second aspect provides a kind of project under construction and turns fixed assets number audit device, comprising:
Module is reset, the initial value for presetting N is 1.
Data transfer module, for according to the audit demand that gets, from transferred in database in the audit demand
The associated data information of trial engineering；
Read module, for reading the N articles audit regulation from default audit regulation table；
Extraction module, for being extracted and the associated Audit data of the N articles audit regulation from the data information；
Logical operation module utilizes the Audit data meter for sentencing formula according to the logic in the N articles audit regulation
Calculate the logic operation result of corresponding the N articles audit regulation；
Mark module, if being very, the Audit data to be labeled as problem data for the logic operation result；
Cycle criterion module, the N for keeping N+1 new judge whether the new N is greater than the default audit rule
The then audit regulation item number in table, if it is not, the S2 is returned to, if so, terminating.
Preferably, further includes:
Audit issues inventory generation module, for described problem data to be output to audit issues inventory.
Preferably, further includes:
Chart generating module, for being graphically associated with described problem data simultaneously with the N articles audit regulation
Output display.
The application third aspect provides a kind of computer readable storage medium, and the computer readable storage medium is used for
Program code is stored, said program code turns amount of fixed assets for executing any project under construction described in above-mentioned first aspect
Word auditing method.
As can be seen from the above technical solutions, the embodiment of the present application has the advantage that
In the embodiment of the present application, provides a kind of project under construction and turn fixed assets number auditing method, by setting in advance
Determine audit regulation table, can will simply summarize the audit regulation come and be described in the form of logic sentences formula.Also, it is each
Audit regulation is associated with logic and sentences the Audit data for needing to use in formula, therefore when there is audit demand, can be purposeful
Property according to the related information between audit regulation and Audit data, extract the audit number in the data information of trial engineering
According to.Using the Audit data, formula can be sentenced with arithmetic logic, the logic operation result of obtained this audit regulation.If logic is transported
It is true for calculating result, then it represents that the Audit data does not meet audit regulation, is suspectable data, therefore be marked as problem
Data, auditor need to only investigate the corresponding objective evidence of problem data, so that it may obtain compliance audit judging result.
It can be seen that method provided by the embodiments of the present application realizes the audit of the digitlization to engineering project data, by setting in advance
Determine audit regulation table, enabling to turn compliance audit in solid audit work is to audit, and auditor only needs by computer generation
Other auditing objectives, the audit work amounts such as the objective evidence verification and post project evaluation of concern compliance audit greatly reduce,
The efficiency of audit is also improved while mitigating auditor's operating pressure.
Detailed description of the invention
Fig. 1 is one embodiment that a kind of project under construction provided by the present application turns fixed assets number auditing method
Flow chart；
Fig. 2 is second embodiment that a kind of project under construction provided by the present application turns fixed assets number auditing method
Flow chart；
Fig. 3 is one embodiment that a kind of project under construction provided by the present application turns fixed assets number audit device
Flow chart.
Specific embodiment
In order to make those skilled in the art more fully understand application scheme, below in conjunction in the embodiment of the present application
Attached drawing, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described embodiment is only this
Apply for a part of the embodiment, instead of all the embodiments.Based on the embodiment in the application, those of ordinary skill in the art exist
Every other embodiment obtained under the premise of creative work is not made, shall fall in the protection scope of this application.
Project under construction refers to that the newly-built, renovating and enlarging or technological transformation of fixed corporate assets, equipment updates and general overhaul
The engineering expenditure in progress such as engineering.And fixed assets refer to for manufacturer's product, utility service, taxi or management and hold
Have, service life is more than the physical assets of an accounting period.Project under construction can be changed into solid from project under construction in the finished
Determine assets, and this also means that from the management of project cost to the transformation of asset management.
The solid process of assets turn, inside control system, laws and regulations are very clear, turn solid audit, principally fall into compliance audit.
The process that compliance audit is found the problem is exactly substantially that potential problems point is collected and combs problem and relates to
And the information arrived is come then according to laws and regulations and inside control system, business administration principle, the even common sense that is recognized and confirms
Information is combed, and is made a decision.Some problems are plain, it is clear that, then the data being related to are few, rule compared with
It is simple；There are some problems more complicated, needs multiple precondition that can just be judged, then the data being related to are more, rule
It is complex.It is either simple or complicated, it transfers to computer to carry out if the part can work, is first carried out before audit work
The digitlization of computer is audited, then can largely reduce the workload of auditor.
Below referring to Figure 1, Fig. 1 is that a kind of project under construction provided by the present application turns fixed assets number auditing method
The flow chart of one embodiment, this method comprises:
Before the method for execution the step of, it is necessary first to which the initial value of default N is 1.It should be noted that N expression one is whole
Number, but before method execution, it is preset equal to 1, certainly, step content can be answered in the implementation procedure of method and is become
Change, and on-fixed is equal to 1.
The audit demand that step 101, basis are got, is associated with from transferring in database with the trial engineering in audit demand
Data information.
Audit demand is that auditor fills in and sends, and it includes the trial engineerings for having auditor to want to audit
Title, therefore can summarize in database according to the title of the trial engineering and transfer relevant data information.
In turning solid audit, the data information for needing to audit has very much, generally includes following data: project information data,
Material information data, financial information data, contract information data.Wherein, project information include: project name, project number,
Area's coding, voltage class, project content, settlement time, project category, project manager, the project application date, is stood investment amount
The item time, risk score value；Other information include buying order number, operating efficiency title, actual purchase quantity, measurement unit,
Unit price of procurement, sub-project title, buying hour, item obtainment time, material requistion ID, neck material money title, receives number at procurement value
Amount, measurement unit, unit price, the amount of money, buying first for the goods and materials amount of money, receive first for the goods and materials amount of money, cancelling stocks first for the goods and materials amount of money, budgetary estimate
When middle first stops power transmission record, power transmission for the goods and materials amount of money, project time of completion, project settlement time, project production time, project
Between, production time, temporarily estimate turn a solid time, production time, the financial system project neck material amount of money, the goods and materials system item neck material amount of money,
Vendor name, procurement contract title etc..
Step 102 reads the N articles audit regulation from default audit regulation table.
Default audit regulation table be according to the professional standing and experience of auditor, historical auditing problem, laws and regulations and
Inside control system, easily determines when to audit and judging result is clear uniquely partially refines, summarize by a rule
The audit regulation table that audit regulation is formed.
There are many formulation modes of default audit regulation table, and the application provides the exemplary example of a default audit regulation table
Son, use for reference only, not to the restriction of default audit regulation table, which, which presets audit regulation, specifically may include three
Aspect: do not complete first clearing, the super investment of clearing volume and turn consolidate not in time.The audit point that these three aspects are related to is distributed in work
Journey item purpose engineering neck material, is temporarily estimated in turn solid, Engineering Settlement, subsequent O&M link operation power transmission.
It is interim, it does not complete the audit point first settled accounts and audit regulation includes:
1, the operating efficiency arrival time is greater than production time, and needing to input information has: the project purchasing goods and materials arrival time
(A), the logical operation of project production time (B), corresponding audit regulation are: A >=B.
2, still expect that needing to input information has: project goods and materials item obtainment time (A), project production time in neck after project puts into operation
(B), the logical operation of corresponding audit regulation is: A >=B.
3, spending beyond the original estimation purchase and receive first for goods and materials, needing to input information has: buying first for the goods and materials amount of money (A), receive first
For the goods and materials amount of money (B), cancelling stocks first for first in the goods and materials amount of money (C), budgetary estimate for the goods and materials amount of money (D), the logic fortune of corresponding audit regulation
At last: A+B-C > D.
4, end of the year surprise puts into operation, and needing to input information has: project time of completion (A), project settlement time (B), project
The logical operation of production time (C), corresponding audit regulation is: C >=and in November (B >=November orA >=November).
5, without power transmission record is stopped, needing to input information has for scheduling: project stops power transmission record (A), and corresponding audit regulation is patrolled
Collecting operation is: A is null.
6, stop electric power feeding time and production time gap is excessive, needing to input information has: electric power feeding time (A), production time
(B), the logical operation of threshold value (C), corresponding audit regulation are: A-B > C.
7, temporarily estimate before going into operation and turn solid, needing to input information has: temporarily estimating and turn solid time (A), production time (B), corresponding audit
The logical operation of rule is: B > A.
8, Closing Check content and live completion content are inconsistent, and needing to input information has: site inspection situation (A) shows
Closing Check content (B) corresponding to content is reconnoitred in field, and the logical operation of corresponding audit regulation is: A<>B.
9, remember the expense of idleness, needing to input information has: clearing work holdup expense (A), according to visa and log recording calculating
The logical operation of work holdup expense (B), corresponding audit regulation is: A > B.
10, finance neck material data and logistics neck material data mismatch, and needing to input information has: financial system project neck material gold
The logical operation of volume (A), the goods and materials system item neck material amount of money (B), corresponding audit regulation is: A<>B.
11, without operational plan or test plan after putting into operation, needing to input information has: project puts into operation record (A), operational plan
(B), test plan record (C) are recorded, the logical operation of corresponding audit regulation is: A is not null and (B is null
or C is null)。
As it can be seen that default audit regulation table contains a plurality of preset audit regulation, and in the step, have read N
Audit regulation, for method is initial, due to N=1, that is, what is read is the 1st article of audit regulation.
Step 103 is extracted and the N articles associated Audit data of audit regulation from data information.
By, as it can be seen that each audit regulation, which sets logic, sentences formula, logic sentences the fortune of formula in the explanation of above-mentioned steps 102
Calculation is needed using Audit data, therefore each audit regulation can be associated in advance with the Audit data that it is needed, in data
The Audit data of needs then can be accurately obtained when extracting data in information according to the association.
Step 104 sentences formula according to the logic in the N articles audit regulation, calculates corresponding the N articles audit using Audit data and advises
Logic operation result then.
Using the Audit data extracted, substitutes into logic and sentence formula progress logical operation, this audit regulation can be calculated
Corresponding logic operation result, the i.e. corresponding logic operation result of the N articles audit regulation.
If step 105, logic operation result are very, Audit data to be labeled as problem data.
If logic operation result is true, it is believed that Audit data does not meet audit regulation, it is likely that there are problems, need at this time
Auditor's further progress judgement, it is therefore desirable to problematic Audit data under a cloud is labeled as problem data, for examining
Meter personnel carry out secondary audit.
Further, if logic operation result is vacation, with no treatment, step is performed the next step.
It should be noted that logic operation result is true only a kind of illustrative statement, indicate in the present embodiment
Audit regulation is not met, but by simply changing, can also make logic operation result is false to indicate not meeting audit regulation, ability
Field technique personnel should know.
Step 106, the N for keeping N+1 new judge the audit regulation item number whether new N is greater than in default audit regulation table,
If it is not, return step 102, if so, terminating.
The step realizes the audit regulation read in default audit regulation table one by one, when new N is greater than default audit rule
The then audit regulation item number in table, it is meant that all preset audit regulations have passed through computer auditing, can be with ending method.
Certainly, the application uses the scheme audited one by one, but can also audit simultaneously to a plurality of audit regulation.
In the application one embodiment, provides a kind of project under construction and turn fixed assets number auditing method, pass through
Audit regulation table is preset, the audit regulation come can will be simply summarized and is described in the form of logic sentences formula.And
And each audit regulation is associated with logic and sentences the Audit data for needing to use in formula, therefore when there is audit demand, it can be with
It is purposive according to the related information between audit regulation and Audit data, extract examining in the data information of trial engineering
It counts.Using the Audit data, formula can be sentenced with arithmetic logic, the logic operation result of obtained this audit regulation.If patrolling
It is true for collecting operation result, then it represents that the Audit data does not meet audit regulation, is suspectable data, therefore be marked as
Problem data facilitates the secondary audit of auditor.
It can be seen that method provided by the embodiments of the present application realizes the audit of the digitlization to engineering project data, by setting in advance
Determine audit regulation table, enable to turn in solid audit work it is more suspenseful, can the part of unartificial judgement be by computer generation
Audit, and auditor need to only veritify the corresponding objective evidence of problem data, audit work amount greatly reduces, and improves careful
The efficiency of meter.
The above are first implementations for turning fixed assets number auditing method to a kind of project under construction provided by the present application
The detailed description of example, refers to Fig. 2 below, and Fig. 2 is that a kind of project under construction provided by the present application turns the audit of fixed assets numberization
The flow chart of second embodiment of method, this method comprises:
The audit demand that step 201, basis are got, from goods and materials database, financial database and project database
It transfers and the associated data information of trial engineering in audit demand.
Data information of the engineering project in goods and materials field, financial field and project fields is required to audit, and three
The data information of aspect usually stores in respective database, that is, goods and materials database, financial database and item number
According to library, therefore the data information of needs can be transferred from three libraries respectively.
Step 202 screens data information, removes invalid data, and data information is exported in the form of wide table
Display.
It specifically may be various types of documents in the data information transferred out, wherein also include many invalid data,
For example null value or abnormal data, these data can remove these invalid datas in pretreatment without reference to value.
It is of course also possible to carry out classification or by the data summarization of same type at data module to data, then by data
Information is exported with wide sheet form and is shown, auditor is facilitated to consult.
Step 203 reads the N articles audit regulation from default audit regulation table.
The step is identical as the step 102 in the application one embodiment, repeats no more.
Step 204 is extracted and the N articles associated Audit data of audit regulation from data information.
The step is identical as the step 103 in the application one embodiment, repeats no more.
Step 205 sentences formula according to the logic in the N articles audit regulation, calculates corresponding the N articles audit using Audit data and advises
Logic operation result then.
The step is identical as the step 104 in the application one embodiment, repeats no more.
If step 206, logic operation result are very, Audit data to be labeled as problem data.
The step is identical as the step 105 in the application one embodiment, repeats no more.
Problem data is output to audit issues inventory by step 207.
Audit data can be convenient auditor's access labeled as problem data, but by the way that problem data to be directly output to
In audit issues inventory, problem data after auditor being made more intuitively to be summarized analyze problem data.
Problem data is graphically associated with the N articles audit regulation and exports display by step 208.
The step associates problem data with the audit regulation for finding the problem data, is exported by way of chart
It has been shown that, facilitates auditor to check.
Step 209, the N for keeping N+1 new judge the audit regulation item number whether new N is greater than in default audit regulation table,
If it is not, return step 103, if so, terminating.
The step is identical as the step 106 in the application one embodiment, repeats no more.
In second embodiment of the application, provides a kind of project under construction and turn fixed assets number auditing method, pass through
Audit regulation table is preset, the audit regulation come can will be simply summarized and is described in the form of logic sentences formula.And
And each audit regulation is associated with logic and sentences the Audit data for needing to use in formula, therefore when there is audit demand, it can be with
It is purposive according to the related information between audit regulation and Audit data, extract examining in the data information of trial engineering
It counts.Using the Audit data, formula can be sentenced with arithmetic logic, the logic operation result of obtained this audit regulation.If patrolling
It is true for collecting operation result, then it represents that the Audit data does not meet audit regulation, is suspectable data, therefore be marked as
Problem data facilitates the secondary audit of auditor.
Compared to one embodiment, data information has been carried out pretreatment and will by second embodiment provided by the present application
Data information is aggregated into Output of for ms, also graphically carries out table with the form of audit issues inventory for problem data
It is existing, apparent intuitive for auditor, its convenient audit work.
Method provided by the embodiments of the present application realizes the audit of the digitlization to engineering project data, careful by presetting
Rule list is counted, makes to turn compliance audit in solid audit work and is audited by computer generation, and auditor only needs to examine default
Rest part not to be covered is audited in meter rule list, and audit work amount greatly reduces, and is mitigating auditor's operating pressure
While also improve the efficiency of audit.
The above are second implementations for turning fixed assets number auditing method to a kind of project under construction provided by the present application
The detailed description of example, refers to Fig. 3 below, and Fig. 3 is that a kind of project under construction provided by the present application turns the audit of fixed assets numberization
The flow chart of one embodiment of device, the device include:
Module 301 is reset, the initial value for presetting N is 1.
Data transfer module 302, for according to the audit demand that gets, from transferred in database in audit demand
The associated data information of trial engineering；
Read module 303, for reading the N articles audit regulation from default audit regulation table；
Extraction module 304, for being extracted and the N articles associated Audit data of audit regulation from data information；
Logical operation module 305 utilizes Audit data calculating pair for sentencing formula according to the logic in the N articles audit regulation
Answer the logic operation result of the N articles audit regulation；
Mark module 306, if being very, Audit data to be labeled as problem data for logic operation result；
Cycle criterion module 307, the N for keeping N+1 new judge whether new N is greater than in default audit regulation table
Audit regulation item number, if it is not, S2 is returned to, if so, terminating.
Further, further includes: audit issues inventory generation module 308, for problem data to be output to audit issues
Inventory.
Further, further includes: chart generating module 309, for by problem data and the N articles audit regulation with chart
Form is associated with and exports display.
This application provides one embodiment that a kind of project under construction turns fixed assets number audit device, by pre-
Audit regulation table is first set, the audit regulation come can will be simply summarized and is described in the form of logic sentences formula.Also,
Each audit regulation is associated with logic and sentences the Audit data for needing to use in formula, therefore when there is audit demand, Ke Yiyou
Purpose according to the related information between audit regulation and Audit data, extract the audit in the data information of trial engineering
Data.Using the Audit data, formula can be sentenced with arithmetic logic, the logic operation result of obtained this audit regulation.If logic
Operation result is true, then it represents that the Audit data does not meet audit regulation, is suspectable data, therefore be marked as asking
Data are inscribed, the secondary audit of auditor is facilitated.
It can be seen that device provided by the embodiments of the present application realizes the audit of the digitlization to engineering project data, by setting in advance
Determine audit regulation table, makes to turn compliance audit in solid audit work and audited by computer generation, and auditor only needs to veritify
The corresponding objective evidence of problem data, audit work amount greatly reduce, and also improve while mitigating auditor's operating pressure
The efficiency of audit.
It is apparent to those skilled in the art that for convenience and simplicity of description, the module of foregoing description
Specific work process, can refer to corresponding processes in the foregoing method embodiment, details are not described herein.
The embodiment of the present application also provides a kind of computer readable storage medium, for storing program code, the program code
Turn appointing in fixed assets number auditing method for executing a kind of project under construction described in each embodiment of preceding method
It anticipates a kind of embodiment.
The description of the present application and term " first " in above-mentioned attached drawing, " second ", " third ", " the 4th " etc. are (if deposited
) it is to be used to distinguish similar objects, without being used to describe a particular order or precedence order.It should be understood that use in this way
Data are interchangeable under appropriate circumstances, so that embodiments herein described herein for example can be in addition to illustrating herein
Or the sequence other than those of description is implemented.In addition, term " includes " and " having " and their any deformation, it is intended that
Cover it is non-exclusive include, for example, containing the process, method, system, product or equipment of a series of steps or units need not limit
In step or unit those of is clearly listed, but may include be not clearly listed or for these process, methods, produce
The other step or units of product or equipment inherently.
It should be appreciated that in this application, " at least one (item) " refers to one or more, and " multiple " refer to two or two
More than a."and/or" indicates may exist three kinds of relationships, for example, " A and/or B " for describing the incidence relation of affiliated partner
It can indicate: only exist A, only exist B and exist simultaneously tri- kinds of situations of A and B, wherein A, B can be odd number or plural number.Word
Symbol "/" typicallys represent the relationship that forward-backward correlation object is a kind of "or"." at least one of following (a) " or its similar expression, refers to
Any combination in these, any combination including individual event (a) or complex item (a).At least one of for example, in a, b or c
(a) can indicate: a, b, c, " a and b ", " a and c ", " b and c ", or " a and b and c ", and wherein a, b, c can be individually, can also
To be multiple.
In several embodiments provided herein, it should be understood that disclosed device and method can pass through it
Its mode is realized.For example, the apparatus embodiments described above are merely exemplary, for example, the division of the unit, only
Only a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can be tied
Another system is closed or is desirably integrated into, or some features can be ignored or not executed.Another point, it is shown or discussed
Mutual coupling, direct-coupling or communication connection can be through some interfaces, the INDIRECT COUPLING or logical of device or unit
Letter connection can be electrical property, mechanical or other forms.
The unit as illustrated by the separation member may or may not be physically separated, aobvious as unit
The component shown may or may not be physical unit, it can and it is in one place, or may be distributed over multiple
In network unit.It can select some or all of unit therein according to the actual needs to realize the mesh of this embodiment scheme
's.
It, can also be in addition, each functional unit in each embodiment of the application can integrate in one processing unit
It is that each unit physically exists alone, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of software functional units.
If the integrated unit is realized in the form of SFU software functional unit and sells or use as independent product
When, it can store in a computer readable storage medium.Based on this understanding, the technical solution of the application is substantially
The all or part of the part that contributes to existing technology or the technical solution can be in the form of software products in other words
It embodies, which is stored in a storage medium, including some instructions are used so that a computer
Equipment (can be personal computer, server or the network equipment etc.) executes the complete of each embodiment the method for the application
Portion or part steps.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (full name in English: Read-Only
Memory, english abbreviation: ROM), random access memory (full name in English: Random Access Memory, english abbreviation:
RAM), the various media that can store program code such as magnetic or disk.
The above, above embodiments are only to illustrate the technical solution of the application, rather than its limitations；Although referring to before
Embodiment is stated the application is described in detail, those skilled in the art should understand that: it still can be to preceding
Technical solution documented by each embodiment is stated to modify or equivalent replacement of some of the technical features；And these
It modifies or replaces, the spirit and scope of each embodiment technical solution of the application that it does not separate the essence of the corresponding technical solution.
Claims (10)
1. a kind of project under construction turns fixed assets number auditing method characterized by comprising the initial value of default N is 1,
S1: according to the audit demand got, from being transferred in database and the associated number of trial engineering in the audit demand
It is believed that breath；
S2: the N articles audit regulation is read from default audit regulation table；
S3: it is extracted and the associated Audit data of the N articles audit regulation from the data information；
S4: sentencing formula according to the logic in the N articles audit regulation, calculates corresponding described the N articles using the Audit data and examines
Count the logic operation result of rule；
S5: if the logic operation result is very, the Audit data to be labeled as problem data；
S6: the N for keeping N+1 new judges the audit regulation the item whether new N is greater than in the default audit regulation table
Number, if it is not, the S2 is returned to, if so, terminating.
2. a kind of project under construction according to claim 1 turns fixed assets number auditing method, which is characterized in that described
After S5 further include:
Described problem data are output to audit issues inventory.
3. a kind of project under construction according to claim 1 turns fixed assets number auditing method, which is characterized in that described
After S5 further include:
Described problem data are graphically associated with the N articles audit regulation and export display.
4. according to power to go 1 described in a kind of project under construction turn fixed assets number auditing method, which is characterized in that it is described
S1 is specifically included:
According to the audit demand got, transfers from goods and materials database, financial database and project database and examined with described
The associated data information of trial engineering in meter demand.
5. a kind of project under construction according to claim 1 turns fixed assets number auditing method, which is characterized in that described
After S1 further include:
The data information is screened, invalid data is removed.
6. a kind of project under construction according to claim 5 turns fixed assets number auditing method, which is characterized in that described
The data information is screened, after removal invalid data further include:
The data information is exported to display in the form of wide table.
7. a kind of project under construction turns fixed assets number audit device characterized by comprising
Module is reset, the initial value for presetting N is 1；
Data transfer module, for according to the audit demand that gets, from transferred in database in the audit demand to
Examine the associated data information of engineering；
Read module, for reading the N articles audit regulation from default audit regulation table；
Extraction module, for being extracted and the associated Audit data of the N articles audit regulation from the data information；
Logical operation module utilizes Audit data calculating pair for sentencing formula according to the logic in the N articles audit regulation
Answer the logic operation result of the N articles audit regulation；
Mark module, if being very, the Audit data to be labeled as problem data for the logic operation result；
Cycle criterion module, the N for keeping N+1 new, judges whether the new N is greater than the default audit regulation table
In audit regulation item number, if it is not, return to the S2, if so, terminating.
8. a kind of project under construction according to claim 7 turns fixed assets number audit device, which is characterized in that also wrap
It includes:
Audit issues inventory generation module, for described problem data to be output to audit issues inventory.
9. a kind of project under construction according to claim 7 turns fixed assets number audit device, which is characterized in that also wrap
It includes:
Chart generating module, for described problem data to be graphically associated with and exported with the N articles audit regulation
Display.
10. a kind of computer readable storage medium, which is characterized in that the computer readable storage medium is for storing program generation
Code, said program code require the described in any item projects under construction of 1-6 to turn fixed assets number auditing party for perform claim
Method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811475736.9A CN109598484A (en) | 2018-12-04 | 2018-12-04 | A kind of project under construction turns fixed assets number auditing method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811475736.9A CN109598484A (en) | 2018-12-04 | 2018-12-04 | A kind of project under construction turns fixed assets number auditing method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109598484A true CN109598484A (en) | 2019-04-09 |
Family
ID=65961046
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811475736.9A Pending CN109598484A (en) | 2018-12-04 | 2018-12-04 | A kind of project under construction turns fixed assets number auditing method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109598484A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110532302A (en) * | 2019-08-30 | 2019-12-03 | 广西电网有限责任公司南宁供电局 | Auditing method, system and readable storage medium storing program for executing |
| CN111709651A (en) * | 2020-06-18 | 2020-09-25 | 江西财经职业学院 | Digital auditing method and device for converting construction project into fixed asset |
| CN112884442A (en) * | 2021-03-01 | 2021-06-01 | 广东铭太信息科技有限公司 | Audit monitoring data acquisition method and system based on audit model |
| CN113052547A (en) * | 2020-12-30 | 2021-06-29 | 宁波东海蓝帆科技有限公司 | Capital transfer management method and management system for construction project in petrochemical industry |
| CN115794803A (en) * | 2023-01-30 | 2023-03-14 | 北京至臻云智能科技有限公司 | Engineering audit problem monitoring method and system based on big data AI technology |
| CN117541173A (en) * | 2023-10-31 | 2024-02-09 | 青矩技术股份有限公司 | Forensic sheet generation method, forensic sheet generation device, forensic sheet generation equipment and computer-readable storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060248591A1 (en) * | 2005-05-02 | 2006-11-02 | Christopher Day | Information security auditing and incident investigation system |
| CN103049708A (en) * | 2012-12-27 | 2013-04-17 | 华为技术有限公司 | Audit configuration method and audit configuration system for database |
| CN107506383A (en) * | 2017-07-25 | 2017-12-22 | 中国建设银行股份有限公司 | A kind of audit data processing method and computer equipment |
-
2018
- 2018-12-04 CN CN201811475736.9A patent/CN109598484A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060248591A1 (en) * | 2005-05-02 | 2006-11-02 | Christopher Day | Information security auditing and incident investigation system |
| CN103049708A (en) * | 2012-12-27 | 2013-04-17 | 华为技术有限公司 | Audit configuration method and audit configuration system for database |
| CN107506383A (en) * | 2017-07-25 | 2017-12-22 | 中国建设银行股份有限公司 | A kind of audit data processing method and computer equipment |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110532302A (en) * | 2019-08-30 | 2019-12-03 | 广西电网有限责任公司南宁供电局 | Auditing method, system and readable storage medium storing program for executing |
| CN110532302B (en) * | 2019-08-30 | 2024-01-19 | 广西电网有限责任公司南宁供电局 | Audit method, system and readable storage medium |
| CN111709651A (en) * | 2020-06-18 | 2020-09-25 | 江西财经职业学院 | Digital auditing method and device for converting construction project into fixed asset |
| CN113052547A (en) * | 2020-12-30 | 2021-06-29 | 宁波东海蓝帆科技有限公司 | Capital transfer management method and management system for construction project in petrochemical industry |
| CN112884442A (en) * | 2021-03-01 | 2021-06-01 | 广东铭太信息科技有限公司 | Audit monitoring data acquisition method and system based on audit model |
| CN112884442B (en) * | 2021-03-01 | 2024-05-03 | 广东铭太信息科技有限公司 | Audit monitoring data acquisition method and system based on audit model |
| CN115794803A (en) * | 2023-01-30 | 2023-03-14 | 北京至臻云智能科技有限公司 | Engineering audit problem monitoring method and system based on big data AI technology |
| CN117541173A (en) * | 2023-10-31 | 2024-02-09 | 青矩技术股份有限公司 | Forensic sheet generation method, forensic sheet generation device, forensic sheet generation equipment and computer-readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109598484A (en) | A kind of project under construction turns fixed assets number auditing method and device | |
| CN103154991B (en) | Credit risk is gathered | |
| US8170998B2 (en) | Methods, systems, and computer program products for estimating accuracy of linking of customer relationships | |
| US9075848B2 (en) | Methods, systems, and computer program products for generating data quality indicators for relationships in a database | |
| CN109754200A (en) | Bill of material management method, apparatus and computer readable storage medium | |
| CN104636338B (en) | A kind of data cleansing storage method for the monitoring of value-added tax negative and positive ticket | |
| CN107688591A (en) | A kind of actuarial treating method and apparatus | |
| CN108711104A (en) | Physical assets information flow method, apparatus and equipment based on block chain | |
| CN109815480B (en) | Data processing method and device and storage medium | |
| CN106651575A (en) | Data processing method and device | |
| CN108062632A (en) | Methods of risk assessment and device, equipment and storage medium | |
| CN106951913A (en) | The method for carrying out data exchange, cloud platform and system | |
| Aksoy et al. | Artificial intelligence in computer-aided auditing techniques and technologies (CAATTs) and an application proposal for auditors | |
| Hu | Predicting and improving invoice-to-cash collection through machine learning | |
| Kumar et al. | Achieving market segmentation from B2B insurance client data using RFM & K-Means Algorithm | |
| Du et al. | Automated fashion size normalization | |
| CN110458581A (en) | Merchant business turnover abnormal recognition methods and device | |
| Huang et al. | A framework for analyzing the US coin supply chain | |
| CN108763233A (en) | The method and apparatus of the identification of doubtful fake products commodity and classification based on big data | |
| CN112053217A (en) | Financial valuation statement generation method and device | |
| Jericevich et al. | Comparing the market microstructure between two South African exchanges | |
| JP6279782B1 (en) | Information processing terminal, information processing method, and program | |
| CN112633936A (en) | Supplier hidden cost prediction method, supplier hidden cost prediction device, server and storage medium | |
| Khan et al. | Computer-aided process planning in prismatic shape die components based on Standard for the Exchange of Product model data | |
| Purohit et al. | Data mining, applications and knowledge discovery |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190409 |