CN109785106A - A kind of ERP system account checking method - Google Patents
A kind of ERP system account checking method Download PDFInfo
- Publication number
- CN109785106A CN109785106A CN201910164424.4A CN201910164424A CN109785106A CN 109785106 A CN109785106 A CN 109785106A CN 201910164424 A CN201910164424 A CN 201910164424A CN 109785106 A CN109785106 A CN 109785106A
- Authority
- CN
- China
- Prior art keywords
- business
- reconciliation
- erp system
- finance
- checking method
- 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 description 22
- 230000008520 organization Effects 0.000 claims description 3
- 238000007726 management method Methods 0.000 description 34
- 238000004519 manufacturing process Methods 0.000 description 9
- 230000006870 function Effects 0.000 description 5
- 238000010276 construction Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 4
- 230000010354 integration Effects 0.000 description 2
- 238000012423 maintenance Methods 0.000 description 2
- 238000013439 planning Methods 0.000 description 2
- 238000004886 process control Methods 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000002787 reinforcement Effects 0.000 description 1
- 230000004044 response Effects 0.000 description 1
- 238000013068 supply chain management Methods 0.000 description 1
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present invention is more particularly directed to a kind of ERP system account checking methods.The ERP system account checking method carries out the configuration of voucher total value allocation plan finance, and setting account of finance calculates special project, and increases reconciliation unit；Voucher total value allocation plan business configuration, setting business datum document, table, access and financial affair work corresponding relationship are carried out, and is fetched according to business financial data relationship；Data during query unit subject show business financial data difference.The ERP system account checking method, it can be with the special corresponding relationship with business datum, service fields of the accounting of each account of finance of flexible setting, and the finance in any date section of each unit, each subject, the initial amount of money of business, the end of term amount of money, this month generation-debit, this month generation-credit side can quickly, be accurately and efficiently inquired by the allocation plan of setting, construction enterprises can be helped quickly to check financial data and business datum, quickly check enterprise account and be of great significance.
Description
Technical field
The present invention relates to data analysis technique field, in particular to a kind of ERP system account checking method.
Background technique
ERP (Enterprise Resource Planning, Enterprise Resources Plan) system is that one kind is mainly directed towards manufacture
Industry carries out the enterprise information management system of physical resources, fund resources and information resources integration integrated management.ERP is one
Using Management Accounting as core can provide it is trans-regional, trans-departmental, the business management software of real time information, needle are even integrated across company
To materials and equipment resources management (logistics), human resource management (stream of people), financial resources management (wealth stream), the management of information resources (information
Stream) integrated business management software.
The it is proposed of ERP system and the high development of computer technology are undivided, and user has bigger active to system
Property, as function involved in computer-aided management considerably beyond the range of MRP II.The function of ERP system include in addition to
MRP II (manufacture, supply and marketing, finance) further includes multi-plant management, quality management, laboratory room managing, management of equipment maintenance, storehouse outside
Depositary management reason, transportation management, process control interface, data acquisition interface, telecommunications, Email, regulation and standard, project pipe
Reason, financial investment management, market information management etc..It will redefine every business and its correlation, in management and group
It knits and takes more flexible mode, to the variation of relation between supply and demand in supply chain (including caused by regulation, standard and technology develop
Change), it synchronizes, is quick, making a response in real time；Grasp it is accurate, in time, complete information on the basis of, make correct decisions,
It takes measures actively.Compared with MRP II, ERP system additionally uses computer technology other than expanding management function
Last word, such as extend one's service custom field, Object-oriented Technique, client/server architecture, multitype database
Platform, SQL structured query language, graphic user interface, 4GL/CASE, window technique, artificial intelligence, emulation technology etc..
ERP system includes following major function: supply chain management, sale and market, distribution, customer service, financial management,
Manufacturing management, stock control, factory and plant maintenance, human resources, report, manufacturing execution system (Manufacturing
Executive System, MES), workflow service and enterprise information system etc..In addition, further including financial investment management, quality
The supplementary functions such as management, transportation management, project management, regulation and standard and process control.
ERP system is that all resources of enterprise are carried out integration management, is briefly by the three of enterprise big streams: object
Stream, cash flow, information flow carry out the management information system of entirely integrating management.Its functional module is different from the past
The module of MRP or MRPII, it cannot be only used for the management of manufacturing enterprise, and for example some non-in the enterprise of many other types
The enterprise of production, utility carries out resources planning and management also into ERP system.
In enterprise, general management mainly includes the content of three aspects: production control (plan, manufacture), logistics management
(distribution, buying, stock control) and financial management (accounting, financial management).This three digest journals inherently conglomerate, it
Have corresponding interface from each other, can be good at combining to be managed enterprise.In addition as enterprise is to people
The reinforcement that human resource management is paid attention to has had more and more ERP manufacturers that human resource management is incorporated to one of ERP system
Important component.
Attention with country to construction enterprises' informationization, each construction enterprises online information system one after another.Big portion information
After online implementing, business, financial data amount are big, and there are account of finance to calculate special one-to-many, many-to-one business datum.Enterprise
Industry business personnel's reconciliation heavy workload, and inefficiency, the not only burden of increased business event personnel, while manual reconciliation standard
True rate is lower.
Based on the status of construction enterprises' information system reconciliation, the invention proposes a kind of ERP system account checking methods.The party
Method can quick search business datum and the initial amount of money of financial data, the end of term amount of money, this month generation (debit), this month generation (loan
Side).
Summary of the invention
In order to compensate for the shortcomings of the prior art, the present invention provides a kind of ERP system account checking methods being simple and efficient.
The present invention is achieved through the following technical solutions:
A kind of ERP system account checking method, which comprises the following steps:
(1) configuration of voucher total value allocation plan finance is carried out, setting account of finance calculates special project, and increases reconciliation unit；
(2) voucher total value allocation plan business configuration, setting business datum document, table, access and financial affair work are carried out
Corresponding relationship, and fetched according to business financial data relationship；
(3) data during query unit subject show business financial data difference.
In the step (1), it includes organization that account of finance, which is calculated special, and Course in English borrows or lends money direction, calculates class
Type calculates special number, calculates special title, makes one and phase in odd-numbered day processed.
The accounting type includes that contact is calculated, and department calculates, and individual calculates and product is calculated.
In the step (2), increase the business paper for needing the account of finance accounting now of corresponding reconciliation section special, and add
The number of each business paper, title, business source, business source table, business id field, table information left join, amount of money word
Section, date field and business number field.
In the step (2), special and business datum document, table, access are calculated by setting account of finance, in business number
According to corresponding access relationship is established between financial data, typonym and service fields name are set, then in service fields relationship
Whether part configuration control sql, compare financial value field, compare business value field and enable.
In the step (2), by establishing corresponding access relationship between business datum and financial data, report tool is removed
Report style is arranged in prefabricated access sql；By being carried out during selecting reconciliation unit, reconciliation subject and business to occur in report
Reconciliation inquiry.
In the step (2), each business paper corresponds to selected account of finance and calculates in special project, subsequent increasing
It does not need to reconfigure when adding other business papers, it is only necessary to increase business paper item.
In the step (2), other subjects can be increased after setting completed and calculate special document, business paper is sorted out
It is corresponding with financial accounting special project, to mitigate the workload of business personnel's reconciliation, it is accurately calculated data.
In the step (3), reconciliation is carried out during selecting reconciliation unit, reconciliation subject and business to occur in report and is looked into
It askes, reconciliation section purpose financial data and business datum under ERP system displaying reconciliation unit, including the initial amount of money, the end of term amount of money, this
Month generation-debit, this month generation-credit side are intuitive to show the different of business datum and financial data by one-to-one relationship
Together, it is finally reached the purpose of quick reconciliation.
The beneficial effects of the present invention are: the ERP system account checking method, it can be special with the accounting of each account of finance of flexible setting
The corresponding relationship of item and business datum, service fields, and can quickly, accurately and efficiently be inquired by the allocation plan of setting
The finance in any date section of each unit, each subject, the initial amount of money of business, the end of term amount of money, this month, occur-borrow out
Side, this month generation-credit side, can help construction enterprises quickly to check financial data and business datum, quickly check account to enterprise
Business is of great significance.
Detailed description of the invention
Attached drawing 1 is ERP system account checking method schematic diagram of the present invention.
Specific embodiment
In order to which technical problems, technical solutions and advantages to be solved are more clearly understood, tie below
Drawings and examples are closed, the present invention will be described in detail.It should be noted that specific embodiment described herein is only used
To explain the present invention, it is not intended to limit the present invention.
The ERP system account checking method, comprising the following steps:
(1) configuration of voucher total value allocation plan finance is carried out, setting account of finance calculates special project, and increases reconciliation unit；
(2) voucher total value allocation plan business configuration, setting business datum document, table, access and financial affair work are carried out
Corresponding relationship, and fetched according to business financial data relationship；
(3) data during query unit subject show business financial data difference.
In the step (1), it includes organization that account of finance, which is calculated special, and Course in English borrows or lends money direction, calculates class
Type calculates special number, calculates special title, makes one and phase in odd-numbered day processed.
The accounting type includes that contact is calculated, and department calculates, and individual calculates and product is calculated.
1 voucher total value allocation plan finance allocation list of table
In the step (2), increase the business paper for needing the account of finance accounting now of corresponding reconciliation section special, and add
The number of each business paper, title, business source, business source table, business id field, table information left join, amount of money word
Section, date field and business number field.
In the step (2), special and business datum document, table, access are calculated by setting account of finance, in business number
According to corresponding access relationship is established between financial data, typonym and service fields name are set, then in service fields relationship
Whether part configuration control sql, compare financial value field, compare business value field and enable.
In the step (2), by establishing corresponding access relationship between business datum and financial data, report tool is removed
Report style is arranged in prefabricated access sql；By being carried out during selecting reconciliation unit, reconciliation subject and business to occur in report
Reconciliation inquiry.
In the step (2), each business paper corresponds to selected account of finance and calculates in special project, subsequent increasing
It does not need to reconfigure when adding other business papers, it is only necessary to increase business paper item.
In the step (2), other subjects can be increased after setting completed and calculate special document, business paper is sorted out
It is corresponding with financial accounting special project, to mitigate the workload of business personnel's reconciliation, it is accurately calculated data.
2 voucher total value allocation plan service allocation list of table
In the step (3), reconciliation is carried out during selecting reconciliation unit, reconciliation subject and business to occur in report and is looked into
It askes, reconciliation section purpose financial data and business datum under ERP system displaying reconciliation unit, including the initial amount of money, the end of term amount of money, this
Month generation-debit, this month generation-credit side are intuitive to show the different of business datum and financial data by one-to-one relationship
Together, it is finally reached the purpose of quick reconciliation.
Claims (8)
1. a kind of ERP system account checking method, which comprises the following steps:
(1) configuration of voucher total value allocation plan finance is carried out, setting account of finance calculates special project, and increases reconciliation unit；
(2) voucher total value allocation plan business configuration is carried out, setting business datum document, table, access and financial affair work are corresponding
Relationship, and fetched according to business financial data relationship；
(3) data during query unit subject show business financial data difference.
2. ERP system account checking method according to claim 1, it is characterised in that: in the step (1), account of finance core
Calculating special includes organization, and Course in English borrows or lends money direction, calculates type, calculates special number, calculates special title, and system is single
People and phase in odd-numbered day processed.
3. ERP system account checking method according to claim 2, it is characterised in that: the accounting type includes that contact is calculated,
Department calculates, and individual calculates and product is calculated.
4. ERP system account checking method according to claim 2 or 3, it is characterised in that: in the step (2), increase and need
Now account of finance calculates special business paper for corresponding reconciliation section, and adds the number of each business paper, and title, business is come
Source, business source table, business id field, table information left join, amount field, date field and business number field.
5. ERP system account checking method according to claim 4, it is characterised in that: in the step (2), by the way that wealth is arranged
Business subject calculates special and business datum document, table, access, and foundation corresponds to access and closes between business datum and financial data
Typonym and service fields name is arranged in system, then configures control sql in service fields relationship part, compares financial value field,
Control business value field and whether enable.
6. ERP system account checking method according to claim 5, it is characterised in that: in the step (2), by business
Corresponding access relationship is established between data and financial data, removes the prefabricated access sql of report tool, and report style is set；By
Reconciliation inquiry is carried out during selecting reconciliation unit, reconciliation subject and business to occur in report.
7. ERP system account checking method according to claim 6, it is characterised in that: in the step (2), each business
Document all corresponds to selected account of finance and calculates in special project, and when subsequent increases others business paper does not need to match again
It sets, it is only necessary to increase business paper item.
8. ERP system account checking method according to claim 6, it is characterised in that: in the step (3), selected in report
Reconciliation unit is selected, reconciliation subject and business carry out reconciliation inquiry during occurring, ERP system shows reconciliation section purpose under reconciliation unit
Financial data and business datum, including the initial amount of money, the end of term amount of money, this month generation-debit, this month generation-credit side, by one by one
Corresponding relationship, the intuitive similarities and differences for showing business datum and financial data, is finally reached the purpose of quick reconciliation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910164424.4A CN109785106A (en) | 2019-03-05 | 2019-03-05 | A kind of ERP system account checking method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910164424.4A CN109785106A (en) | 2019-03-05 | 2019-03-05 | A kind of ERP system account checking method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109785106A true CN109785106A (en) | 2019-05-21 |
Family
ID=66487649
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910164424.4A Pending CN109785106A (en) | 2019-03-05 | 2019-03-05 | A kind of ERP system account checking method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109785106A (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110928962A (en) * | 2019-11-26 | 2020-03-27 | 山东浪潮通软信息科技有限公司 | Query report generation method based on dynamic fields |
| CN111209273A (en) * | 2019-12-29 | 2020-05-29 | 航天信息股份有限公司企业服务分公司 | Configurable ERP system data unloading method and device |
| CN111476661A (en) * | 2020-05-04 | 2020-07-31 | 武汉众邦银行股份有限公司 | General ledger system batch processing method for cyclic check entry |
| CN112232818A (en) * | 2020-10-15 | 2021-01-15 | 金蝶软件（中国）有限公司 | Data reconciliation method and device, computer equipment and storage medium |
| CN112529675A (en) * | 2020-12-21 | 2021-03-19 | 柏丽德珠宝(广州)有限公司 | Asset estimation method and device based on financial data |
| CN112948441A (en) * | 2021-03-26 | 2021-06-11 | 浪潮通用软件有限公司 | Financial data-oriented multidimensional data aggregation method and equipment |
| CN114004412A (en) * | 2021-11-05 | 2022-02-01 | 云南电网有限责任公司信息中心 | Financial data optimization method based on RPA |
| CN115081978A (en) * | 2022-05-25 | 2022-09-20 | 山东浪潮科学研究院有限公司 | Method for realizing registration of inventory ledger and balance ledger in ERP product based on configuration |
| CN115619512A (en) * | 2022-10-13 | 2023-01-17 | 北京中电普华信息技术有限公司 | Reconciliation processing method, device, computer readable medium and computer program product |
| CN119648439A (en) * | 2024-11-11 | 2025-03-18 | 北京久其金建科技有限公司 | Account reconciliation method, device, electronic device and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106408410A (en) * | 2016-11-29 | 2017-02-15 | 用友网络科技股份有限公司 | Automatic account checking method and device |
| US20170097996A1 (en) * | 2015-10-06 | 2017-04-06 | Green Dot Corporation | Systems and Methods for Privacy Preservation |
| CN107038634A (en) * | 2017-03-13 | 2017-08-11 | 苏州益萃网络科技有限公司 | A kind of second account system for being used to manage business finance |
-
2019
- 2019-03-05 CN CN201910164424.4A patent/CN109785106A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20170097996A1 (en) * | 2015-10-06 | 2017-04-06 | Green Dot Corporation | Systems and Methods for Privacy Preservation |
| CN106408410A (en) * | 2016-11-29 | 2017-02-15 | 用友网络科技股份有限公司 | Automatic account checking method and device |
| CN107038634A (en) * | 2017-03-13 | 2017-08-11 | 苏州益萃网络科技有限公司 | A kind of second account system for being used to manage business finance |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110928962A (en) * | 2019-11-26 | 2020-03-27 | 山东浪潮通软信息科技有限公司 | Query report generation method based on dynamic fields |
| CN110928962B (en) * | 2019-11-26 | 2024-03-26 | 浪潮通用软件有限公司 | Query report generation method based on dynamic field |
| CN111209273A (en) * | 2019-12-29 | 2020-05-29 | 航天信息股份有限公司企业服务分公司 | Configurable ERP system data unloading method and device |
| CN111209273B (en) * | 2019-12-29 | 2023-11-14 | 航天信息股份有限公司企业服务分公司 | Configurable ERP system data unloading method and device |
| CN111476661B (en) * | 2020-05-04 | 2023-07-11 | 武汉众邦银行股份有限公司 | Batch processing method of general ledger system for cyclic check-in account |
| CN111476661A (en) * | 2020-05-04 | 2020-07-31 | 武汉众邦银行股份有限公司 | General ledger system batch processing method for cyclic check entry |
| CN112232818A (en) * | 2020-10-15 | 2021-01-15 | 金蝶软件（中国）有限公司 | Data reconciliation method and device, computer equipment and storage medium |
| CN112529675A (en) * | 2020-12-21 | 2021-03-19 | 柏丽德珠宝(广州)有限公司 | Asset estimation method and device based on financial data |
| CN112948441B (en) * | 2021-03-26 | 2023-09-29 | 浪潮通用软件有限公司 | Multi-dimensional data collection method and equipment for financial data |
| CN112948441A (en) * | 2021-03-26 | 2021-06-11 | 浪潮通用软件有限公司 | Financial data-oriented multidimensional data aggregation method and equipment |
| CN114004412A (en) * | 2021-11-05 | 2022-02-01 | 云南电网有限责任公司信息中心 | Financial data optimization method based on RPA |
| CN114004412B (en) * | 2021-11-05 | 2024-05-14 | 云南电网有限责任公司信息中心 | Financial data optimization method based on RPA |
| CN115081978A (en) * | 2022-05-25 | 2022-09-20 | 山东浪潮科学研究院有限公司 | Method for realizing registration of inventory ledger and balance ledger in ERP product based on configuration |
| CN115619512A (en) * | 2022-10-13 | 2023-01-17 | 北京中电普华信息技术有限公司 | Reconciliation processing method, device, computer readable medium and computer program product |
| CN119648439A (en) * | 2024-11-11 | 2025-03-18 | 北京久其金建科技有限公司 | Account reconciliation method, device, electronic device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109785106A (en) | A kind of ERP system account checking method | |
| Azeroual et al. | The effects of using business intelligence systems on an excellence management and decision-making process by start-up companies: A case study | |
| US9740992B2 (en) | Data warehouse system | |
| CN106776822B (en) | Conglomerate's report data extracting method and system | |
| CN113034053A (en) | Modeling method based on matching and evaluation between policy information and service object | |
| CN110751361B (en) | Bank demand entry level management method and system | |
| CN112270444A (en) | Light APS double-bridge planning system | |
| CN112748910B (en) | System, method and equipment for product assembly research and development based on SaaS mode | |
| CN108846645A (en) | A kind of enterprise's flattened management method and system | |
| Murdihardjo et al. | Implementing INTACS Dynamics Enterprise Resources Planning System for Financial Statements | |
| US20040122758A1 (en) | Budget and financial analysis system and method | |
| Saputra et al. | Utilization of Service Oriented Architecture to Customize Accounting Business Process in Open ERP System for Smart SME’s | |
| CN101122991A (en) | The fourth generation finance core business system systematic structure and intelligent financial accounting method | |
| Arndt et al. | A 2007 Social Accounting Matrix (SAM) for Mozambique | |
| Prawiro | Internet Marketing By Implementing Enterprise Resource Planning (Erp) At The Mukomuko Milk Center Using Php Programming Language And Mysql Database | |
| CN102411758A (en) | Import and export trade financial service system and data integration exchange method thereof | |
| Supangi et al. | Analysis of Implementation and Proposal Development of ERP System in CV Indah Jaya | |
| US20250077742A1 (en) | Automatic entity evaluation and selection | |
| US20170140399A1 (en) | Commitments and forecasting management | |
| Wang et al. | A financial assets and liabilities management support system | |
| Csikósová et al. | CRM system implementation in IT company | |
| Ma | Measuring the economic scope of NPOs in China–2016 Report | |
| CN118014399A (en) | Implementation method for automatically calculating DICT project benefit evaluation result | |
| Kartamyshev et al. | Development of an effective system of information support for management decision-making at the enterprisesof the rocket and space industry | |
| Broersen et al. | Preparing for AnaCredit: A timely start is crucial |
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 |
Application publication date: 20190521 |
|
| RJ01 | Rejection of invention patent application after publication |