This page provides the Project Synopsis of the Gas Agency Management System. The “Gas Agency Management System” initiative is undertaken in order to make the manual process simpler by making it a computerized billing and stock maintenance system. Customer data maintenance, inventory tracking (cylinders), printing bills, and producing information are taken care of by this Gas Agency Management System. The framework was developed as a Front-End Platform under Microsoft Visual Basic 6.0 and Oracle 8.0 as a Back-End Tool.
Existing System:
We are actually using the manual method, all we have to do with data entry in this by writing facts into the book, paper papers. Consumer details, product details, inventory of retailer data and customer requests are handled manually. All the operations are performed manually by the customer. Since bills are processed manually, there is a potential for mistakes in bills to occur. The downside to this method is that it is harder to scan for a particular document and it requires more time to locate documents in ledgers. It is also not easy to recover information.
Gas Agency Management System
Adding, updating, removing, and querying the database takes care of the customer maintenance module. Stock tracking means that the stock is available at the gas agency. The module for printing bills requires printing bills for any sale made and the reports are gradually produced on the basis of the transactions made.
Based on their demand and previous delivery date, the customer makes order requests to the Gas Agency for gas cylinders, and then the gas agency sends the gas cylinders to their address. Customer records such as the name of the customer, address, and stock information are stored in a database until the customer is registered with this system. This makes billing easy for consumers and only after finishing a certain time from the previous supply can the gas agent approve customer order for the gas cylinder. The gas inventory and all its data are processed rapidly.
The below are the various databases that are included in this project:
1) Billing Details
2) Price Details
3) Delivery Details
4) Customer Details
5) Stock Details
6) Booking Details
DOWNLOAD NOW