Download - Manufacturing and sales management system
Manufacturing And Manufacturing And Sales Management Sales Management
SystemSystem
Developed by ::Developed by ::SMIT PATELSMIT PATEL
Index
No. Detail
1 Project Profile
2 Company Profile
3 Existing System
4 Need for the System
5 Data flow Diagram
6 Entity relationship Diagram
7 Data Dictionary
8 Screen Layout
Project Profile
Project Title : Manufacturing And Sales Management
System
Goal of System : This system gives user friendly Environment which also provide the user a real time data, which helps user to interact with the system very rapidly and easily.
Front End : VB.NET 2005
Back End : SQL Server Express Edition
Reporting Tool : Crystal Report
Company Profile
Company Name:-Jay Plastics PVT. LTD.Ahmedabad.
About Company:-Jay plastics PVT. LTD. Is one of the manufacturing company in Ahmedabad.Company used to manufacture products or items since last 17 years. The work of company is totally done manually.
Existing System
Previously organization was doing all the working manually.
But at present, computers are becoming part of every activity in organization. The more common and obvious applications are business applications.
So with the time, the system must also fit into a competitive environment and must be very easy to use. Above all, the main goal of computer based information system is to speed up the processing. And that is the reason why the new system was proposed.
Existing System
Very time consuming and expensive process.
Lots of paper work.
Manager has to handle the entire process manually.
The same process has to be repeated consecutively for coming years even if employees don’t change.
Need for the New System
Speed and faster Access to the Request and Response.
Reduce Paper Work.
Centralized Database Management
Data Consistency
This System is highly Secured Compare to manual system.
Data Flow Diagram0 LEVEL DFD
Data Flow Diagram1st level DFD
1.0 Login
Admin Employee
Login Detail
Login Approval
Verify Login
Detail
Login Approval
Login Detail
Employee Master
Data Flow Diagram1st level DFD
2.0 Purchase
Admin
Supplier
Supplier Master
Purchase Master
Raw Material Master
Purchase Invoice Detail
Purc
hase
Det
ail
Requ
ired
Raw
Mat
eria
l Det
ails
Purc
hase
Det
ails
Purc
hase
Bill
Raw Material
Details
Supplier Detail
Updates Stock
Purchase Detail Master
Raw Material Details
Data Flow Diagram1st level DFD
3.0Production
AdminRaw-Material Master
Product Master
Employee
Prod
uctio
n Deta
il
Updates Details
Raw
Mater
ial D
etails
Required Production Details
Product Production Details
Prod
uctio
n Deta
ils
Requ
ired R
aw M
ateria
l Deta
il
Updates QOH
Required Product Details
Data Flow Diagram1st level DFD
4.0Sales
Client
Sales Detail Master
Employee
Product Master
Sales Master
Client Master
Category Master
Sales
Detai
ls Available Stock
Product Details Required Product
Product Details
Product Category
Category Details
Product Order Details
Sales Invoice
Clien
t Deta
ilsInv
oice N
o
Sales
Detai
ls
Invoice
Data Flow Diagram1st level DFD
5.0Payment Received
Client
Client Master
Sales Master
Receive Payment MasterEmployee
Receipt
Due Payment
Invoice Detail
Receive payment Detail
Paid Amount
Revised Due List
Payment Detail
Rece
iptDu
e Amo
unt
Paym
ent
Client Detail
E – R Diagram
E – R Diagram
Data Dictionary
Data Dictionary
Employee Master
1)Table Name:- Employee_Master
Description:- Personal Details of the Employee
Field name Data type Size Constraints Description
Emp_id Number 5 PK Identification no of Employee in number.
Emp_Name Varchar 30 Name of the Employee.Street Varchar 30 Street Address of the Employee.Area Varchar 15 Area of the Employee.City Varchar 10 City of the Employee.
Pin_code Varchar 9 Pin Code of the Employee city.
State Varchar 10 State of the Employee.Contact_Number Varchar 15 Contact No of the Employee. E.g. no Email_Id Varchar 255 Email Address of the Employee.Designation Varchar 15 Designation of the Employee.Fax Varchar 15 Fax no of the Employee.
DOB Date 10 Date Of Birth of Employee.
DOJ Date 10 Date of Joining of the Employee.
Login_type Numeric 15 Type of Login .e.g. 1 for Admin, 2 for User
Login_Allowed Boolean 5 Login Allowed to Employee or not.
Login_Name Varchar 15 User Name of the Employee.Login_Password Varchar 15 Password of the Employee.
Foreign Key Detail :-
Foreign Key Field name :-
Category_Master
2)Table Name:- Category Master
Description:-Details of the Product ‘s Category
Field name Data type Size Constraints Description
Cat_id Number 5 PK Category Identification no of the Product.
Cat_Name Varchar 20 Category Name of the Product.Foreign Key Detail :-Foreign Key Field name :-
Raw_Material_Master
3)Table Name:- Raw_Material_Master
Description:- Details About Raw Materials
Field name Data type Size Constraints Description
Raw_id Number 5 PK Identification no of the Raw Material.
Raw_Name Varchar 20 Name of the Raw Material.Raw_Desc Varchar 30 Description About Raw Material.Latest_Purchase_Rate Number 6 Rate at which we Purchase the Material.UOM Varchar 10 Unit of Measurement.e.g in inche
QOH Varchar 10 Quantity On Hand.
Minimum_Qty Number 10 Minimum Stock of Raw Material.Maximum_Order Number 10 Maximum Order of Raw Materials Allowed.Foreign Key Detail :-Foreign Key Field name :-
Supplier_Master
4)Table Name:-Supplier_Master
Description:- Personal Details of the Supplier
Field name Data type Size Constraints Description
Sup_id Number 10 PK Identification no of the Supplier.
Sup_Name Varchar 20 Name of the Supplier.Street Varchar 20 Street address of the Supplier.Area Varchar 20 Area address of the Supplier.City Varchar 20 City address of the Supplier.
Pin_code Varchar 10 Pin code address of the Supplier.
State Varchar 20 State address of the Supplier.Contact_Number Varchar 15 Contact of the Supplier.Email_id Varchar 255 Supplier’s Email Address. Fax Varchar 20 Supplier’s Fax Address.URL Varchar 20 Supplier’s Url Address.
Foreign Key Detail :-
Foreign Key Field name :-
Client_Master
5)Table Name:- Client_Master
Description:- Personal Details of the Client
Field name Data type Size Constraints Description
Client_id Number 5 PK Identification no of the Client.
Client_Name Varchar 20 Name of the Client.Street Varchar 20 Street address of the Client.Area Varchar 20 Area address of the Client.City Varchar 20 City address of the Client.
Pin_code Varchar 10 Pin code address of the Client.
State Varchar 20 State address of the Client.Contact_Number Varchar 15 Contact of the Client.Credit_limit Number 10 Given Credit to client(customer)Email_id Varchar 255 Client’s Email Address. Fax Varchar 20 Client’s Fax Address.
Foreign Key Detail :-
Foreign Key Field name :-
Product_Master
7)Table Name:-Product_Master
Description:- Brief Details of the Products
Field name Data type Size Constraints Description
Pro_id Number 5 PK Identification no of the Product.
Pro_Name Varchar 20 Name of the product. Pro_Size Varchar 10 Size of the product.Cat_id Number 5 FK Identification no of the category.QOH Number 10 Quantity on hand.
Description Varchar 15 Description about Project.
Foreign Key Detail :-Foreign Key Field name :- Category_Master(Cat_id)
Supplier_Raw_Material
)Table Name:-Supplier_Raw_Material
Description:- Details of the Raw Materials that Supplier has Supplied
Field name Data type Size Constraints Description
Sup_Raw_material_id Number 5 PK Identification no of the Supplier Raw Materials.
Sup_id Number 5 FK Identification no of the Supplier.Raw_id Number 5 FK Identification no of the Raw materials.Foreign Key Detail :- Foreign Key Field name :- Supplier_Master(Sup_id) , Raw_Material_Master (Raw_id)
Product_Raw_Material
8)Table Name:-Product_Raw_Material
Description:- Brief Details of the Product Raw Material
Field name Data type Size Constraints Description
Pro_Raw_id Number 5 PK Id of the product raw material.
Pro_id Number 5 FK Id of the product.Raw_id Number 5 FK Id of the Product raw materials.QTY Number 10 Quantity on hand.UOM Varchar 10 Unit Of Measurement.
Foreign Key Detail :-
Foreign Key Field name :- Product_Master (Pro_id) , Raw_Material_Master (Raw_id)
Purchase_Master
9)Table Name:-Purchase _Header
Description:- Brief Details About Purchase
Field name Data type Size Constraints Description
Purchase_id Number 5 PK Id of the Purchase.
Purchase_bill_no Varchar 10 Bill no of the Purchase.Sup_id Number 5 FK Id of the supplier. Purchase_bill_date Date 10 Date of the Purchase.Purchase_Receive_Date Date 10 Date of the Purchase Receive.
Emp_id Number 5 FK Emp id of the Purchase receives.
Total_Amt Number 10 Total Amt of the Purchase.Discount Number 10 Discount given to Purchaser.Tax. Number 10 Tax as per Government Rule.Net _Amt Number 10 Total Amt.Transportation_Details Varchar 50 Details of the Transportation.
Foreign Key Detail :-
Foreign Key Field name :- Supplier_Master ( Sup_id) , Employee_Master(Emp_id)
Purchase_Raw_Material_Detail
10)Table Name:-Purchase_Raw_Material_Detail
Description:- Brief Details About Purchasing Of Raw Material
Field name Data type Size Constraints Description
Purchase_Raw_Material_id Number 5 PK Id of the Purchase Raw material Details.
Purchase_id Number 5 FK Id of the purchase.Raw_id Number 5 FK Id of the Raw materials.QTY Number 10 Quantity on hand.UOM Varchar 10 Unit Of Measurement.
Rate Number 10 Rate of the Purchase Raw Materials.
Amt Number 10 Total Amt of the Raw materials.Foreign Key Detail :-Foreign Key Field name :- Purchase _Master(Purchase_id) , Raw_Material_Master (Raw_id)
Purchase_Return _Header
11)Table Name:-Purchase_Return _Header
Description:- Details About Header of Purchase Raw Materials
Field name Data type Size Constraints Description
Purchase_Return_Header_id Number 5 PK Id of the Purchase Return master.
Purchase_bill_no Varchar 10 Bill no of Purchase.Sup_id Number 5 FK Id of the supplier.Tax Number 10 Tax as Per Government Rules.Discount Number 10 Given Discount.
Total Number 10 Total Amt of Purchase Return.
Foreign Key Detail :-Foreign Key Field name: - Supplier_Master (Sup_id)
Purchase_Return _Details
12)Table Name:-Purchase_Return _Details
Description:- Details About Return Of Purchase Raw Materials
Field name Data type Size Constraints Description
Purchase_Return_Detail_id Number 5 PK Id of the Purchase Return Details
Purchase_Return_Header_id Number 5 FK Id of the Purchase Return Header Master.Purchase_Raw_Material_id Number 5 FK Id of the Purchase Raw Material.QTY Number 10 Quantity on hand.UOM Varchar 10 Unit Of Measurement.
Rate Number 10 Rate of the Purchase Return
Amt Number 10 Total Amt of the Purchase Return Foreign Key Detail :-Foreign Key Field name: - Purchase_Return_Header_Master (Purchase_Return_Header_id), Purchase_Raw_Material_Detail_Master (Purchase_Raw_Material_id)
Sales_Master
13)Table Name:-Sales_Header
Description:- Details About Sales
Field name Data type Size Constraints Description
Sales_id Number 5 PK Id of the sales master.
Sales_bill_no Varchar 10 FK Bill no of the sales.Client_id Number 10 FK Id of the client.Sales_bill_Date Date 10 Date of the sales.Sales_Delivery_Date Date 10 Date on which delivery is done.
Emp_id Number 5 FK Employee id of the sales receive.
Total_Amt Number 10 Total Amt of sales.Discount Number 10 Discount allowed.Tax Number 10 Tax as per Government Rules.Net_ Amt Number 10 Net Amt after deducting discount, tax etc…..Transportation_Details Varchar 20 Details of the Transportations.
L_R_No Varchar 10 Transportation no.
Foreign Key Detail :-
Foreign Key Field name :- Client_Master (Client_id) , Employee_Master (Emp_id)
Sales_Product_Detail
14)Table Name:-Sales_Product_Detail
Description:- Details of the sales product
Field name Data type Size Constraints Description
Sal_Product_detail_id Number 5 PK id of the sales Product Details.
Sales_id Number 5 FK Id of the sales.Pro_id Number 5 FK Id of the Product.QTY Number 10 Quantity on hand.Rate Number 10 Unit Of Measurement.
Amt Number 10 Total Amt.
Foreign Key Detail :-Foreign Key Field name :- Sales_Master (sales_id) , Product_Master (Pro_id)
Sales_Return
15)Table Name:-Sales_Return_Header
Description:- Details of the Return of Products that we have sold
Field name Data type Size Constraints Description
Sales_Return_id Number 5 PK Id of the sales return.
Sales_Return_date Date 10 Date at which sales is return.Client_id Number 5 FK Id of the client.Sales_id Number 5 FK Id of the sales.Total_Amt Number 10 Total Amt of the sales Return.
Discount Number 10 Discount We got.
Tax Number 10 Tax as per Government Rules.Foreign Key Detail :-Foreign Key Field name :- Client_Master(Client_id) , Sales_Master (sales_id)
Sales_Return_Details
16)Table Name:-Sales_Return_Details
Description:- Brief Details of sales Return
Field name Data type Size Constraints Description
Sales_Return_Detail_id Number 5 PK Id of the sales returns details.
Sales_Return_id Number 5 FK Id of the sales return.Pro_id Number 5 FK Id of the Product.QTY Number 10 Quantity on hand.Foreign Key Detail :-
Foreign Key Field name :- Sales_Return_Master (Sales_Return_id)
Receive_Payment
17)Table Name:-Receive_PaymentDescription:- Brief Details of the Received PaymentField name Data type Size Constraints DescriptionReceive_Pay_id Number 5 PK Id of the payment Received.Receive_date Date 10 Date of Receive Payment.Client_id Number 5 FK Id of the client.Emp_id Number 5 FK Id of the Receive_emp. Amt Number 10 Amt of the Received Payment.Mode_of_Payment Number 15 In which mode u want to pay e.g. check or cash.Cheque_No Varchar 15 No of the chequeBank_Name Varchar 20 Name of the bankNotes Varchar 50 Brief Notes about Received Payment.Foreign Key Detail :-Foreign Key Field name :- Client_Master (Client_id) , Employee_Master(Emp_id)
Paid_Payment_Master
18)Table Name:- Paid_Payment
Description:-Brief Details of the Paid Payment
Field name Data type Size Constraints Description
Paid_Payment_id Number 5 PK Id of the paid payment master.
Paid_Date Date 10 Date of paid payment.Sup_id Number 5 FK Id of the supplier.Amt Number 10 Amt of the Paid Payment.Mode_of_Payment Number 10 In which mode you want to pay.
Bank_Name Varchar 20 Name of the bank
Cheque_No Varchar 20 No Of the chequePurchase_bill_Number Varchar 20 Number of the purchase billNotes Varchar 50 Brief Description of paid payment.Foreign Key Detail :-Foreign Key Field name :- Supplier_Master(Sup_id )
Screen Layouts
Screen Layouts