MANN-india Technologies

Case Study

Through this System, user can analyse and query the Database by using some criteria. The criterion isnothing but one or more parameters of the report. Theuser builds his query using the search criteria to viewthe required reports. This system supports the user intaking decisions and updating himself.

The framework ofthis system was pre-conceived at the time of databasedesign. Features, which make the system intelligent,are.

  • The system's framework can display Auto generated Reports
  • Graphical Representation of Comparison of the historic data.
  • Comparative Analysis helps the users in making long terms strategies.
  • The system is quick to display intrinsic and complex calculations in short span of time.

International Centre for Genetic Engineering andBiotechnology wanted a Purchase, Stores and Accountsautomation system. The main objective of this automationsystem was to increase the overall efficiency of theadministration section of the organization, smoothen theexisting workflow and have control over the budget. Theusers of the ICGEB organization use following types ofreports.


INFORMATIONALREPORTS
These reports are used to update theuser with the current and historic information of thedata. These report anticipate the users from making anyerrors. The reports also help the user in keeping recordof the request, which he has placed in the past. Theindividual users of the organization can track thestatus of their requests. The mass users of theorganization use these reports. Some of the reports,which fall in this category of reporting, are

Indent List
To purchase anyitem of use in the organization every individual hasto fill the Indent Form. This Indent Form is processedby approval of senior officials of the laboratory andOrganization. This report displays the list of all theindents filled by an individual from his login. So tohelp every individual to track the status of his IndentForm this Indent List is used. Speaking of status meanswho all have approved the Indent Form and who is havingthe Indent Form.

SRF List
To collect itemsarrived in stores every individual has to fill a StoresRequisition Form. This Stores Requisition Form is againprocessed. This report displays the list of all theStores Requisition Form.
So to track the status ofapprovals of Stores Requisition Form every Indenter usesthis Report.

Complaint List
Every userworking in the organization is responsible for themaintenance of his or her environment. Every user canfill a Complaint Form for the repairing of theequipments. The Maintenance Officer looks after thecomplaints. This List Shows the list of complaintsfilled by an individual.

DECISION SUPPORT REPORTS
These are mostimportant among the three categories. Decision supportreports help the use in taking Intelligent Decisions.These report have proved themselves in saving money ofthe Organization. Some of the reports, which fall inthis category, are:

Comparative StatementReport
The Purchase Officer receivesquotations from the suppliers for comparative biding.The unit price of items quoted by the suppliers isdisplayed in a row corresponding each item. This reportis used by the Purchase Committee to make comparisonsbetween quotations.
The supplier who quotes lowestfor the item is selected for that item. This is how thisDecision Support Report helps the Purchase Committee intaking decisions and saving money and thereby making thesystem Intelligent.

Common Indent List
ThePurchase Officer is responsible for the clubbing of theindents filled by the employees in various departments.The Purchase Officer forwards only those Indents, whichhe has to process. This is the list, which is accessibleto the Purchase Officer.

MANDATORY REPORTS
These arethe pre-decided reports. Pre-decided reports means thesereports where requirements of the uses. These are thereports, which users submit to the senior officials ofthe organization. These reports are intelligent toquickly perform complex and intrinsic calculations. Mostof the reports of this type are used by the AccountsDepartment. Some of the reports, which fall in thiscategory, are

Reports In PurchaseDepartment

  • POList
    This report displays the list of PurchaseOrder prepared by the Purchase Officer. This reporthelps the Chief Of Administration in tracking thestatus of Purchase Order.
  • PORegister
    Shows the list of Purchase Order to thePurchase Officer. There is 4 types of purchase orderprepared by the procurement section of theorganization. This report helps the Purchase Officerin maintaining records of all types of purchase order.
  • Minutes Of Meeting
    This list shows the listof Minutes Of Meetings. Purchase Committee meets everyweek to do competitive biding of quotations.
    Arecord of this is meeting is kept for the future use.This report records the number of indents processedand the member who where in the meeting.
Reports Of Accounts Department
  • All thenecessary reports of accounts are auto generated bythe system using this query and reporting framework.Database was designed keeping in view the reporting framework. Theframework was designed in such a manner that it fitsin any kind of report. All these report have almostsame search criteria.
  • Trail Balance, Monthly Expenditure Statement,Cash Reconciliation Report, Ledger Account Report,Bank Cheque Wise Report, Core Account Status, CoreAccount Report
Reports In Stores Department

  • DayBook
    When item arrives in stores StoresOfficer makes the Stores Receipt & AcceptanceVoucher. When item is issued from stores StoresOfficer accepts the Stores Requisition Form beforeissuing item. These SRAV's and SRF's are displayed inthe Day Book.
  • Stock Register
    This Reportshows the stock of the stores. The stores officermaintains a stock register. This stock register isautomated in the system and stores officer can searchthe items in the stock registeralphabetically.