Roofing Fabrication System is mainly about to automate the existing system of manually maintaining the invoice records, tax invoice records, customer details, product details, employee details, maintaining the day to day attendance records and generating invoice bills. It is beneficiary for Admin to assign tasks and duties to the employees instead of doing in paper works and it will also help in keeping all customer details, product details, tax and billing details into database. It helps users calculate taxes and provide details to the customers in a very easy and efficient manner and reduces consumption of time. Thus it decreases human effort and makes the system less time consuming.
This project has been developed using VB.net as the front end and SQL Server as the back end.
In Scope
- The system is very user friendly and it saves time, effort and money.
- Day to day attendance is generated.
- Invoice details are calculated
- Tax details are calculated
- All details are stored and can be retrieved whenever required.
Out Scope
- Salary Calculation
The major features of Roofing Fabrication System are as follows:
- Customer details are maintained.
- Reports are updated frequently.
- Product details are maintained.
- Employee details are maintained.
- Day to day attendance is maintained.
- Tax invoice is Calculated and maintained.
- Invoice is calculated and maintained.
- Transportation details are maintained.
Modules of Roofing Fabrication System:
Customer Details:
- Introduction: Stores Customer details.
- Input: Customer name, Customer Id, Customer Address, Delivery address, Phone number, TIN nests knock no, Mobile no, status.
- Processing: Data will be stored.
- Output: Proper detail will be stored as well as retrieved.
Attendance Details:
- Introduction: Stores employee attendance details.
- Input: Attendance ID, Employee ID, Attendance date, status
- Processing: Attendance is calculated and Data will be stored.
- Output: Proper detail will be stored as well as retrieved.
Employee Details:
- Introduction: Stores Employee details.
- Input: Employee ID, Employee name, Employee Address, Employee phone no, Date of birth, Gender
- Processing: Data will be stored.
- Output: Proper detail will be stored as well as retrieved.
Invoice Details:
- Introduction: Stores Invoice Details
- Input: Invoice ID, Invoice no, Customer id, Date, Customer order reference, Dispatched through, E-Sugam no, Dispatched date, Invoice type, Status, Basic, Vat, Load transaction, Subtotal, Gate pass no, Delivery time.
- Processing: Invoice details are calculated and Data will be stored.
- Output: Proper detail will be stored as well as retrieved.
Invoice Record Details:
- Introduction: Stores Invoice Details
- Input: Invoice record id, Invoice ID, Serial no, Product code, Product description, Material, Thickness, Width, Length, Quantity, Rate, Quantity in Sq. feet/Kg.
- Processing: Data will be stored.
- Output: Proper detail will be stored as well as retrieved.
Product details:
- Introduction: Stores Product details
- Input: Product code, Product description, Material, Thickness, Note, Status.
- Processing: Data will be stored.
- Output: Proper detail will be stored as well as retrieved.
Tax Details:
- Introduction: Calculates Tax Report.
- Input: Tax ID, Tax type, Tax percentage, Status.
- Processing: Data will be stored.
- Output: Proper detail will be stored as well as retrieved.
Tax Invoice Details:
- Introduction: Stores tax invoice Details.
- Input: Tax invoice id, SL no, Quantity, Particulars, Rate, Amount.
- Processing: Data will be stored.
- Output: Proper detail will be stored as well as retrieved.
Users of the System
- Admin: Admin is the main user of this software, he has got all the controls. Admin can add employee and add attendance details.
- User: User has some option enabled for him and he cannot use all the features of the software. Admin will verify entered users data
ER diagram:
