omkar distb
TRANSCRIPT
SALES AND PURCHASE SYSTEM forOMKAR DISTRIBUTORS-Consumer Products,Kalwa
Distributor is an important entity in supply chain management.
DISTRIBUTERDISTRIBUTER
CUSTOMERCUSTOMER
He is responsible for handling large amount of data in systematic and effective working of his agency.
RETAILER_INFORMATIONRETAILER_INFORMATION
SUPPLIER/COMPANY INFORMATION
SUPPLIER/COMPANY INFORMATION
PRODUCT_INFORMATIONPRODUCT_INFORMATION
SALES/PURCHASE DETAILSSALES/PURCHASE DETAILS
PAYMENT-DETAILS
PAYMENT-DETAILSSTOCK_DETAILSSTOCK_DETAILS
And many more details…………
Handling the distributor data is rather a tedious and difficult task that requires proper control over inventory and accounts of the agency which will help the distributor to attain maximum profit.
This can be achieved by an effective management of the available resources.
A system can be developed which does this job.
REQUIREMENT
DETAILS
PROCESSOR Minimum Processor:Pentium IV
HARD DISK MIN. 80GB
RAM MIN. 256MB
PRINTER DOT MATRIX
REQUIREMENT DETAILS
FRONT END JAVA DEVELOPMENT KIT
BACK END MySQL Server 5.1
OPERATING SYSTEM
Windows XP
HARDWARE REQUIREMENTS SOFTWARE REQUIREMENTS
Company Name: OMKAR DISTRIBUTORS- Consumer products Product supplied: GITS,PERFITTE,KELLOGS,PRIYA
GOLD,GINI OIL…
Company Address: Shop No. 1/B, Shreenath A, Old Belapur
Road,Kalwa,Thane
OMKAR DISTRIBUTORS
Area covered: KALWA-MUMBRA
Omkar distributor is organization which distributes consumer products to retailer.
It has variety of good quality consumer products to offer. The business started in 1998 ,earlier the business started with few products to
distribute that was easy to handle physically and accounts of same were maintained manually.
But the increase in business the products increased and amount of work load also increased considerably.
CURRENTLY USED SYSTEM “BILLBASE SYSTEM”—Its only use is to keep record of bills of retailers.
The system has some major drawbacks. One of the drawback is that it does not have a user friendly graphical interface.
NO. Requirement Description Remarks
1. User Classification Different privileges for different employees
Logins will be assigned by Admin
2. Sales and Purchase entry Sales and Purchase entry carried out simultaneously
-
3. Profit Loss Assessment Profit should be calculated by the system separately
Will help in further enhancement of business
4. Report Facility Daily Reports of sales ,purchase, return should be maintained
Will help the manager to take important decisions
5. Security Should provide security for critical financial data
Employee should not be able to see critical data
…..more later
Classification of the users Store-Update1.Customer
2.Supplier 3.Products 4.Orders given by supplier
5.Orders placed by customer 6.Inventory management
Report Generation Provide attractive interface
Efficient handling of information – Retailers & Suppliers
Keep important information about the products.
To keep the order details.
To maintain inventory information integrated and handle inventory efficiently.
To provide Reports for taking decisions.
SALES & PURCHASE SYSTEM
CUSTOMER ENTRY
CUSTOMER REPORTCUSTOMER PRODUCT
PRODUCT ENTRY
PRODUCT REPORT
RETURN ENTRY
RETURN
RETURN REPORT
SALES
SALES
SALES REPORT
SUPPLIER
SUPPLIER ENTRY
SUPPLIER REPORT PURCHASE
PURCHASE ENTRY
PURCHASE REPORT
An Integrated Development Environment is a computer software to help computer programmers develop software.
The Leaders: - NetBeans- Microsoft Visual Studio- Eclipse
A fast fully-featured Integrated Development Environment (IDE) with support for Java.
Compliant applications for accelerating development across all major OS platforms.
Provides an open source, high performance, modular, extensible, multi-platform Java IDE for GUI, mobile tools, Web, and Desktop applications.
Written in java and therefore runs on every operating system that supports Java VM.
http://dev.mysql.com http://www.netbeans.com Sams.Teach.Yourself.MySQL.in.10.Minutes.May.2006-Chris
Newman