CN101482945A

CN101482945A - Method for implementing balance account receiving, distributing and storing query statistics in accounting management process

Info

Publication number: CN101482945A
Application number: CNA200910014099XA
Authority: CN
Inventors: 王兴山; 焦学瑞
Original assignee: Inspur Group Shandong General Software Co Ltd
Current assignee: Inspur Group Shandong General Software Co Ltd
Priority date: 2009-02-11
Filing date: 2009-02-11
Publication date: 2009-07-15

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

The implementation method of the sending and receiving of a kind of management through accounting process balance account, the inquiry statistics of filing for reference

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

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 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.
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.