Gas payments.

SA "Events" based application. Regional solution. Allocated data as remote views based on master database site.

Russian language...

In 2003-2004 we created a solution for Bryansk's department of Russian "GASPROM". The solution is based on "Events" accounting system (c) Andrei Evsikow 1999-2005 used in large russian companies before.

Synopsys:

	A uniform scheme of gasification sites with references to areas or separate items.
	Centralized database with a set of functions: Invoice creation, Printing of the receipts, Operative data, Reports, Reception of payments and corrections from sites, Reception of the obverse bills (new and changes) from sites - these are major areas of work.
	Offline (based on the central base) or online data views on sites with a set of functions: creation and supporting of the obverse bills, Reception of payment, Correction of charges, Operative data and verification with the clients, Local reports - is the main scheme of work.
	Due to organization solutions (distribution of functions in the scheme of gasification sites) almost all functions can be redistributed between sites and the central office. So it is possible to pass functions of invoice creation automatically to all or separate areas as well as responsibility, if there's trained personnel on site). It is possible to take away functions of reception of cash, non-cash payment or grants from separate areas in the centre. Only directions of periodic exchange of separate types of data between areas and central site will change.
	Data exchange mechanism between areas and central site by means of "update grammes" does not require fixed exchange times (monthly, weekly, ...) and can be carried out using removable devices (CD, Flash, ...), FTP, e-mail.
	Online work with direct access to the central base. With a channel of 1 mb / with (the telephone line) proves incomparably more effective site work directly with the central base, all possible exchanges and synchronization are excluded.
	Maximum flexibility of algorithms of account of gas charges on the basis of AS "Events" documents and "Paper Edit" technology . All changes to account algorithm are made without participation of the developer.
	Ability to allocate a process of automatic invoices creating in the central base between several computers (by areas) at the same time allows to solve the task of monthly charges in one day (~400000 invoices in Bryansk region).
	The dynamic data and reports are generated directly from the entered primary documents without any modes of intermediate calculations. Any change in any document directly results in changes in all account areas.
	The continuous accounting with any period duration from months up to years without any monthly calculations of balance with irreversible changes in data. Period duration is regulated only by hardware limitations.
	Ability to calculate intermediate balance with transition of each month to accelerate reports creation. If you decide to close the previous month, you also activate the date restriction of the documents which can be produced. After that it is possible to calculate intermediate balance and store it in separate tables (not necessary). During report creation for the current month, the program will use this intermediate balance and ignore millions of documents with earlier dates, and this will dramatically speed up calculation process. If reports use date intervals earlier than intermediate balance date, the program will ignore intermediate balance.
	Ability to cancel or block continuous accounting by closing the period for each month.

Characteristic features and requirements of the system:

Three components (client parts): "Gas payments" (for central management), "Site control terminal" and SA "Events" are created with MS Visual FoxPro. The application framework provides the needed level of abstraction from the data access technology . The same programs work with the data in DBF file format (on sites), and with MS SQL-Server database( at the central site).

The results of working with the database after 7 months ( quantity of the obverse bills ~400 000 (Bryansk)) on a server with a disk array HP (3+3+2) and four processors are:

	The largest quantity of records in the table (positions of the documents) ~ 120 000 000;
	The size of the database ~ 35Gb;
	Opening / saving any separate document - within one second;
	Creating and saving invoice for gas to one recipient in batch mode ~ 0.5 seconds;
	Time of creating of invoices to all recipients using local stations P-IV 2.6Ghz SATA RAM500Mb Dual channel ~ 15 hours;
	Call of the operative data on recipient - about 6 seconds;
	"Update grams" with invoices creation for sending to one area ~ 10 minutes (with checksum creation);
	Reception of the documents from an area ~ 10 minutes (with checksum creation);
	Turnover sheet "Gas payments" for the period of one month: creation time ~ 1 hour;

***

Developers consulting and exclusive software solution projects in USA, Canada, Mexico, Europe, Australia, ...: www.lespinter.com

Home