CN101482945A - Method for implementing balance account receiving, distributing and storing query statistics in accounting management process - Google Patents
Method for implementing balance account receiving, distributing and storing query statistics in accounting management process Download PDFInfo
- Publication number
- CN101482945A CN101482945A CNA200910014099XA CN200910014099A CN101482945A CN 101482945 A CN101482945 A CN 101482945A CN A200910014099X A CNA200910014099X A CN A200910014099XA CN 200910014099 A CN200910014099 A CN 200910014099A CN 101482945 A CN101482945 A CN 101482945A
- Authority
- CN
- China
- Prior art keywords
- voucher
- year
- attribute
- initial
- model
- 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
Images
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a method for integrating account balance in a financial management software, specifically a method for inquiring and counting accepting, distributing and storing of a balance account book in an accountant management course. The method comprises steps of specially marking account vouchers to mainly identify vouchers of normal services automatically generated at end of a year, integrating balance at beginning of the year of automatically generated vouchers, integrating amount at beginning and generation amount of vouchers of normal services, and finally deducting the account balance thereof; automatically generating a year end automatically generated mark blue voucher according to year end amount at every annual account time, a red voucher corresponding to amount of the blue voucher, so as not to affect accuracy of data when inquiring at a split year.
Description
Technical field
Patent of the present invention is to be used for a kind of implementation method that the financial management software subject balance collects, and is the sending and receiving of a kind of management through accounting process balance account specifically, files for reference and ask the implementation method of statistics.
Background technology
In present financial software system, to collecting of subject balance generally is to set up the subject balance table separately, at ordinary times by accounting voucher case-by-case registration subject balance table, this design is big and give or other reasons causes some accounting voucher to be failed when registration subject balance table easily the user, thereby causes the data mistake.When inquiry comprises the subject balance account of accounting voucher not,, can cause performance slower in addition owing to will from subject balance table, 2 tables of credentials table, collect data.Therefore how to guarantee account, voucher data consistent and improve query performance, management through accounting process balance account sending and receiving that this patent will realize that Here it is, file for reference and ask the implementation method of statistics.
Summary of the invention
The present invention provided a kind of technology with the professional management through accounting process balance account sending and receiving that combine, file for reference and ask the implementation method of statistics, this method comprises the following steps and content:
A, set up initial attribute, service identification attribute, the single identity property of red indigo plant and other related content accounting voucher models by whether;
B, constitute the whether initial attribute of this model: initially, not initial
C, constitute the service identification attribute of this model: a year knot forms voucher, regular traffic voucher
D, constitute the single attribute of red indigo plant of this model: negative voucher, positive number voucher
The implementation method of E, 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: whether a) contain the data structure of initial attribute, service identification attribute, the single identity property of red indigo plant; (3) select suitable programming tool realization foreground and back-end data mutual, realize balance account sending and receiving, the inquiry of filing for reference.
In the remaining sum statistic processes, at first judge whether as for enabling year, to be that initial voucher collects initial number then according to initial attribute for enabling year; As then at first not collecting the service identification attribute for the indigo plant that year knot forms voucher collects number at the beginning of the year only according to card for enabling, the voucher that collects regular traffic again forms initial number, number and remaining sum thereof takes place.Straddle over year when collecting data,,, simplify collecting process, improved query performance owing to add up to zero owing to exist indigo plant simultaneously only according to card, clearance permit voucher.
Description of drawings
Fig. 1 is the accounting voucher structural representation
Embodiment
The setting of balance account sending and receiving of the present invention, the initial voucher when asking setting that statistical method comprises the accounting voucher structure and enabling of filing for reference, balance book collects algorithm definition and query contents setting from accounting voucher, finally realizes the inquiry of subject balance table data:
A. the accounting voucher field attribute is described below:
Whether whether 1) initial: identifying this voucher is initial voucher.
2) whether service identification: identifying this voucher is that a year knot generates voucher or regular traffic voucher.
3) red blue single sign: identifying this voucher is normal voucher or recoil voucher.
4) other attributes as voucher numbering, symbolization of accounts etc., are no longer described.
B, collect algorithm
In the inquiry into balance statistic processes, at first whether place year as for enabling year, is that initial voucher collects initial number according to initial attribute for enabling year then during the judgement inquiry; As then at first not collecting the service identification attribute year for the indigo plant that year knot forms voucher collects number at the beginning of the year only according to card for enabling, the voucher that collects regular traffic again forms initial number, number and remaining sum thereof takes place.Straddle over year when collecting data,,, do not influence Query Result,, improved performance owing to collect data from a table owing to add up to zero owing to exist indigo plant simultaneously only according to card, clearance permit voucher.
C, year knot voucher automatic generating calculation
The year knot that the year knot that year when knot forms a blue single sign during next automatically according to the ending balance in the current year that collects generates a voucher and a clearance permit sign generates voucher.
Embodiment
The instantiation method of A. balance account sending and receiving, the inquiry statistics of filing for reference:
Before the account book purpose data classifying that the accounting system implementation model is described, need use a model and describe the bookkeeping voucher structure, and the realization of description algorithm etc.Model instanceization needs following steps:
1) the 1 data of description structure definition of at first setting up the bookkeeping voucher structure with reference to the accompanying drawings.
2) according to collecting algorithm, computing bookkeeping voucher data also form the management of balance sheet query script.
3) according to knot function of automatic production algorithm process accounting system year of knot voucher in year.
B. the implementation method after the model instanceization:
By the model instance method with concrete voucher structure exampleization after, need example be 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: the database skill
Art, programming tool etc.;
2) according to the technology and the instrument that use, design back-end data structure.The critical field attribute of voucher data structure is with reference to accompanying drawing 1;
3) use programming tool, realize that the user foreground represents.By the visit of programming realization to data in the back-end data structure, carry out accounting voucher system list usually can for the user, collect data by above-mentioned algorithm, the user can inquire about the subject account at any time like this.
Step and content that method of the present invention must be described including but not limited to claims 1 E that addresses,
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 inquiry of remaining sum on this basis, thereby solve balance book and voucher data consistent and improve the performance of inquiry according to aforementioned algorithm.
Claims (3)
- The implementation method of 1, a kind of management through accounting process balance account sending and receiving, the inquiry statistics of filing for reference, it is characterized in that basis is by carrying out special identifier to bookkeeping voucher, the voucher of main identification automatic generation at the year end, regular traffic, by collecting number at its to automatically generating voucher the year end at beginning of the year, voucher to regular traffic collects its initial number and number takes place, and finally derives its section's purpose remaining sum; Every year when knot according to the year end number generate automatically that to generate sign automatically a year end blue only according to card, a corresponding blue clearance permit voucher only according to the card amount of money does not influence the accuracy of data when straddling over year inquiry with solution, concrete step is:A, set up initial attribute, service identification attribute, the single identity property of red indigo plant and other related content accounting voucher models by whether;B, constitute the whether initial attribute of this model: initially, not initialC, constitute the service identification attribute of this model: a year knot forms voucher, regular traffic voucherD, constitute the single attribute of red indigo plant of this model: negative voucher, positive number voucherThe implementation method of E, 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: whether a) contain the data structure of initial attribute, service identification attribute, the single identity property of red indigo plant; (3) select suitable programming tool realization foreground and back-end data mutual, realize balance account sending and receiving, the inquiry of filing for reference.
- 2, method according to claim 1, its feature also are and need blue, the red two kinds of sign vouchers of voucher definition of sign at the beginning of the year be generated when tying in year automatically.
- 3, method according to claim 1, its feature also be when anti-year knot, to delete automatically its correspondence the beginning of the year sign indigo plant, clearance permit voucher.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA200910014099XA CN101482945A (en) | 2009-02-11 | 2009-02-11 | Method for implementing balance account receiving, distributing and storing query statistics in accounting management process |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA200910014099XA CN101482945A (en) | 2009-02-11 | 2009-02-11 | Method for implementing balance account receiving, distributing and storing query statistics in accounting management process |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101482945A true CN101482945A (en) | 2009-07-15 |
Family
ID=40880044
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNA200910014099XA Pending CN101482945A (en) | 2009-02-11 | 2009-02-11 | Method for implementing balance account receiving, distributing and storing query statistics in accounting management process |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101482945A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101789100A (en) * | 2010-02-01 | 2010-07-28 | 袁义军 | Processing method and system of accounting data |
CN103903177A (en) * | 2012-12-26 | 2014-07-02 | 远光软件股份有限公司 | Payment account checking method and system |
CN110458674A (en) * | 2018-05-07 | 2019-11-15 | 北京中海汇银财税服务有限公司 | A kind of method and system generating bookkeeping voucher |
-
2009
- 2009-02-11 CN CNA200910014099XA patent/CN101482945A/en active Pending
Cited By (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101789100A (en) * | 2010-02-01 | 2010-07-28 | 袁义军 | Processing method and system of accounting data |
CN103903177A (en) * | 2012-12-26 | 2014-07-02 | 远光软件股份有限公司 | Payment account checking method and system |
CN103903177B (en) * | 2012-12-26 | 2017-12-15 | 远光软件股份有限公司 | A kind of method and system for paying reconciliation |
CN110458674A (en) * | 2018-05-07 | 2019-11-15 | 北京中海汇银财税服务有限公司 | A kind of method and system generating bookkeeping voucher |
CN110458674B (en) * | 2018-05-07 | 2022-12-06 | 北京中海汇银财税服务有限公司 | Method and system for generating bookkeeping voucher |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108734528A (en) | A kind of electronic invoice keeps accounts method automatically | |
CN108509392B (en) | Multi-mechanism account checking method, system, computer equipment and storage medium | |
EP2924588A1 (en) | Report creation method, device and system | |
CN102880956B (en) | Paying server and payment channel integration method | |
CN104317806B (en) | Financial data inquiry method and financial data system | |
CN102799690A (en) | Method for verifying page input by using database technology | |
CN111275037B (en) | Bill identification method and device | |
CN104536965B (en) | A kind of data query display systems under the conditions of big data and method | |
CN110188336B (en) | Method and device for generating reimbursement bill based on OA application form | |
CN107689009A (en) | Annuity data processing method, device, server and storage medium | |
CN106384280B (en) | Artificial intelligence accounting system and calculation method thereof | |
CN110019194A (en) | Verification of data method, apparatus, computer equipment and storage medium | |
CN113379526A (en) | Intelligent invoice reimbursement method and device, electronic equipment and computer storage medium | |
CN107358525A (en) | A kind of account trading method and apparatus | |
CN106547646A (en) | A kind of data backup and restoration methods, data backup and recovery device | |
CN103377403B (en) | Business event assembly modeling method and system | |
CN101482945A (en) | Method for implementing balance account receiving, distributing and storing query statistics in accounting management process | |
CN110942066A (en) | Bill checking method and device | |
CN110298692A (en) | Method, system and the storage medium of customer data unified management by all kinds of means | |
CN105656706B (en) | Service data processing method and device | |
WO2020006936A1 (en) | Fund management method and apparatus, computer device, and computer-readable storage medium | |
CN102521757A (en) | One-key application method for commercial tenant membership card on the basis of intelligent terminal | |
CN107025556A (en) | A kind of membership management system suitable for trading processing | |
CN107273279A (en) | A kind of bill management method and device | |
CN102750822B (en) | Intelligent traffic service processing system and service processing method |
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: 20090715 |