RICE BUZZ
Objective: The main objective of this Project is to maintain the total life cycle of Rice Mill. The purpose of developing this web application is to share the up to date information of their Rice business within the organization and across the countries.
Benefits to Organization: •
Multiple users can access the data at a time.
Confidential Page 1 of 75
Suwin Software Solutions Pvt Ltd
•
The main Admin have all the rights to assign roles to users.
•
The page wise and event wise security is provided to application.
•
Only authorized users can access the data and manipulate it.
•
Every day the total information regarding to the Stock and the value of the Stock will be known to the Organization.
• •
Alerts on Stock Shortage. Consumption status of the Mill machineries.
Software and Hardware Specifications:
Hardware: Processor
:
Intel Pentium or more
Ram
:
256 MB or more
Cache
:
512 KB
Hard disk
:
16 GB hard disk recommended for primary partition.
Software: Operating system
:
Windows 2000 or later
Technology and Languages
:
ASP.NET 2.0, C#.NET, AJAX. Crystal Reports.
Development Environment
:
Microsoft Visual Studio 2005
Back End Software
:
Ms SQLSERVER 2005
Screens: Confidential Page 2 of 75
Suwin Software Solutions Pvt Ltd
User Login :
This is the home page of the application.This application starts with the security check where the user has to enter their user name and password.If the user is authorised user then it redirects to next page.
This application has totally 8 modules. Confidential Page 3 of 75
Suwin Software Solutions Pvt Ltd
1. Admin 2. Inventory 3. Purchase 4. Production 5. Sales 6. Finance 7. Stores 8. Employee
1 . Admin Module :
Create User: The users are created in this page by the Admin only. Admin will give the user type and his role at the time of user creation. Confidential Page 4 of 75
Suwin Software Solutions Pvt Ltd
It maintains two types of users 1. Private 2. Public. This application consists of two types of database for their personal purposes. Private users can access only private database and public user can access only public database. Based on role access to the page will be given to the user.
Add New Page:
Adding a new page if any pages further added to the application. This is used in the next page ‘Create new Role’
Confidential Page 5 of 75
Suwin Software Solutions Pvt Ltd
Create New Role :
All the pages we entered in create new page will be displayed in this page .This screen is used to create new role and access to the pages and events for that role will be given here.
Confidential Page 6 of 75
Suwin Software Solutions Pvt Ltd
2. Inventory Module: This module is used to enter all the master details of the Rice Mill.
Item Master
Here we can create the Varieties of Rice and Paddy.
Confidential Page 7 of 75
Suwin Software Solutions Pvt Ltd
Mill Master:
This screen is used to create new Mill and to enter details of their mills.
Confidential Page 8 of 75
Suwin Software Solutions Pvt Ltd
Godown Master:
This screen is used to enter all the godown details of the rice mill.
Confidential Page 9 of 75
Suwin Software Solutions Pvt Ltd
Way Bills Master: A series of Way Bills are generated at a time in this Page.
Confidential Page 10 of 75
Suwin Software Solutions Pvt Ltd
NOC’s Master:
A series of NOC’s (No Objection Certificate) are generated at a time.
Confidential Page 11 of 75
Suwin Software Solutions Pvt Ltd
Permits Master:
Confidential Page 12 of 75
Suwin Software Solutions Pvt Ltd
A series of permits are generated with their details like time durations and maximum quantity on that permit.
Lorry Master:
Confidential Page 13 of 75
Suwin Software Solutions Pvt Ltd
To enter lorry details this screen is used.
Confidential Page 14 of 75
Suwin Software Solutions Pvt Ltd
Agent Master:
Rice mill will have number of purchase and sales agents. Those agent details will be entered here.
Confidential Page 15 of 75
Suwin Software Solutions Pvt Ltd
Gunnies Master:
Opening stock of the Gunnies and also with their weights will be entered in this screen.
Confidential Page 16 of 75
Suwin Software Solutions Pvt Ltd
Stock Master:
Enter the opening stock Rice, Paddy, Broken. Entering the Yielding, Vat, CST percentages of the available Items.
Confidential Page 17 of 75
Suwin Software Solutions Pvt Ltd
Tax Master:
Create various Tax Rates and their details.
Confidential Page 18 of 75
Suwin Software Solutions Pvt Ltd
Hamali Master:
Creating Hamali rates based on the areas like Unloading, Loading, and Transferring. .etc.
Confidential Page 19 of 75
Suwin Software Solutions Pvt Ltd
Gunny Weight Master:
Enter the Gunny weight which used at purchase to reduce the weight from the total weight of paddy.
Confidential Page 20 of 75
Suwin Software Solutions Pvt Ltd
Weighment Shortage Master:
Confidential Page 21 of 75
Suwin Software Solutions Pvt Ltd
Enter the weight which is average short at the Weigh Bridge .Which is also reduced from the net weight in the Paddy Purchase.
Expenditure Master:
Confidential Page 22 of 75
Suwin Software Solutions Pvt Ltd
Enter various types of Expenditures occurred at the time of billing of sales items.
Load Freight Master:
Confidential Page 23 of 75
Suwin Software Solutions Pvt Ltd
Enter the fright rates for different distances.
FCI Rates: Confidential Page 24 of 75
Suwin Software Solutions Pvt Ltd
Enter the rates of each item based on the Qualities of Paddy and Rice according to the Food Corporation of India.
Confidential Page 25 of 75
Suwin Software Solutions Pvt Ltd
Moisture Master:
Enter the Moisture Percentage and the shortage percent.
Confidential Page 26 of 75
Suwin Software Solutions Pvt Ltd
3.Purchase Module: Issue Way Bills/NOC’s/Gunnies:
Here we can enter the details of issuing way bills, NOC’s, Gunnies to the purchase agents who are going to purchase paddy from the formers.
Confidential Page 27 of 75
Suwin Software Solutions Pvt Ltd
Return Way Bills/NOC’s/Gunnies:
Here we have to enter the details of returned waybills, NOC’s which are unused by the Agents and also gunnies which are not filled.
Confidential Page 28 of 75
Suwin Software Solutions Pvt Ltd
Paddy purchase:
Here we can enter all the Purchase details of the Paddy, Rice and Broken.
Confidential Page 29 of 75
Suwin Software Solutions Pvt Ltd
Purchase Approval:
Confidential Page 30 of 75
Suwin Software Solutions Pvt Ltd
The details which are entered in the purchase Paddy form will not effected to the data base directly. When we come in to the approval page the authorized person will approve the Purchase by selecting appropriate invoice number.
Zero invoice:
Confidential Page 31 of 75
Suwin Software Solutions Pvt Ltd
Here we will get the purchase data which is not approved till now. From this Page also we can give approval to the purchases.
Create Patti:
Confidential Page 32 of 75
Suwin Software Solutions Pvt Ltd
The purchases belongs one person are grouped into single Patti (which is a list of purchase details). The amounts belongs to these purchases are summed. And any other commissions, Rusum, Advance Amounts all are calculated and the net amount of the Patti is generated.
Payments: Confidential Page 33 of 75
Suwin Software Solutions Pvt Ltd
Once the Patti is generated then the Payments can be done in the Payments Page. The cash transactions can be done at the cash voucher page. Once the payment to the particular person is done . Then it will show in the payments page. By the information provided from the cash voucher we will finish the Purchase Module by entering amount details in the payments page.
Confidential Page 34 of 75
Suwin Software Solutions Pvt Ltd
Advance Payments:
Here we can enter the amount if any advances paid to the Agents or to the Customers. That will effect in the Payments.
Confidential Page 35 of 75
Suwin Software Solutions Pvt Ltd
Gunny Purchase:
Here we can enter the details of Gunny Purchase. The details like Type of Gunny, Brand of Gunny, Rate, Tax (%)…etc.
Confidential Page 36 of 75
Suwin Software Solutions Pvt Ltd
4.Production: Batch:
Here the batch means the paddy which is sent for processing is treated as Batch. And estimating the output of the batch after the processing.
Confidential Page 37 of 75
Suwin Software Solutions Pvt Ltd
Hulling:
Here we can enter the details of paddy which is going to process. The details are like Which Batch is going for milling, from which godown it is taken, the quantity of the material, which lorry used to bring the material.
Confidential Page 38 of 75
Suwin Software Solutions Pvt Ltd
Rejected Items:
Enter the details of items which are rejected at processing.
Confidential Page 39 of 75
Suwin Software Solutions Pvt Ltd
Yielding:
Entering Details of Rice and Broken after the processing.
Confidential Page 40 of 75
Suwin Software Solutions Pvt Ltd
Bran/Husk/Ash Stock:
Entering the opening stock or Quantity after the processing of Bran, Husk, Ash.
Confidential Page 41 of 75
Suwin Software Solutions Pvt Ltd
Stock Transfer:
Confidential Page 42 of 75
Suwin Software Solutions Pvt Ltd
Entering the details of stock transfer from one Godown to another Godown or from one type of bag to another type of bag.
Damaged Gunnies:
Confidential Page 43 of 75
Suwin Software Solutions Pvt Ltd
Enter the Details of the Damaged Gunnies after the Hulling or after the stock transfer.
5.Sales: Contracts:
Confidential Page 44 of 75
Suwin Software Solutions Pvt Ltd
This screen is used to enter the contract details.
Consignment Loading:
Confidential Page 45 of 75
Suwin Software Solutions Pvt Ltd
Consignment loading is nothing but wagon loading. The details of loading like the item details, the Source and Destinations of the wagon, Lorry number and Way bill Number, Freight for the wagon are entered here.
Consignment Sales:
Confidential Page 46 of 75
Suwin Software Solutions Pvt Ltd
Enter the details of sales for the items which are sent through the wagon.
Confidential Page 47 of 75
Suwin Software Solutions Pvt Ltd
FCI Loading:
This screen is used to enter the details of Items which are loading to sent to the Food Corporation of India.
Confidential Page 48 of 75
Suwin Software Solutions Pvt Ltd
FCI Returns:
Enter the details of Items which are sent back to the Godown by Food Corporation of India.
Confidential Page 49 of 75
Suwin Software Solutions Pvt Ltd
FCI Acknowledgement:
We have to enter the details of Acknowledgement from FCI.
Confidential Page 50 of 75
Suwin Software Solutions Pvt Ltd
FCI Bill:
The FCI Bill contains all the details of the transaction with the FCI. By Selecting the ACK No we will get all the details. After submitting the bills for one or more cknowledgements we will go to the receipt button. There we can enter the Amounts and check details which are paid by the FCI.
Confidential Page 51 of 75
Suwin Software Solutions Pvt Ltd
Sales:
Here we can enter the Sales Details of Rice, Paddy Items.
Confidential Page 52 of 75
Suwin Software Solutions Pvt Ltd
Bran Sales:
Here we can enter the details of Bran sales based on the contracts or permits if any. And also the details of the bags which belongs Bran.
Confidential Page 53 of 75
Suwin Software Solutions Pvt Ltd
Husk/Ash Sales:
Confidential Page 54 of 75
Suwin Software Solutions Pvt Ltd
Here we can enter the details of Husk or Ash sales based on the contracts if any, and also the details of the bags which belongs to the Bran.
Receipts:
Confidential Page 55 of 75
Suwin Software Solutions Pvt Ltd
Here we will generate receipts for all the sales. The receipts are differentiated by the sales type and by selecting the Party name. The bill amounts are displayed automatically. We can add or subtract the bill Amount if needed. If we get the amount through the bank, then we can enter the bank details like bank name, check number, check date and check Amount.
Sales Actual Weight:
Confidential Page 56 of 75
Suwin Software Solutions Pvt Ltd
If the weight of the material has to change after the sales page submitting, we have the sales actual weight page to modify the weight. Then the bill amount also modified accordingly.
6.Finance: Ledger Master: Confidential Page 57 of 75
Suwin Software Solutions Pvt Ltd
This screen is used to create new ledger accounts under the selected category.
Confidential Page 58 of 75
Suwin Software Solutions Pvt Ltd
Ledger master bank:
To create bank account numbers and to perform banking transactions like bank withdraw, bank remittance and transferring amount from one bank account to another bank account.
Confidential Page 59 of 75
Suwin Software Solutions Pvt Ltd
Cash Voucher:
All the amount transactions which are done at the cash counter will be entered here.
Confidential Page 60 of 75
Suwin Software Solutions Pvt Ltd
Cash View:
Cash transactions which are done by the unauthorized cashier will be sent to this screen. These transactions will be sent to the database only when the authorized person approves.
Confidential Page 61 of 75
Suwin Software Solutions Pvt Ltd
Depositors:
All the depositors’ details of the mill will be entered here.
Confidential Page 62 of 75
Suwin Software Solutions Pvt Ltd
7. Stores: Stores Master:
Here we can save opening stock of the mill missionary. By clicking the link add new group we can create new Item.
Confidential Page 63 of 75
Suwin Software Solutions Pvt Ltd
Stores Purchase:
Here we can enter the purchase details of the Mill missionary, and also the details of where we are storing them.
Confidential Page 64 of 75
Suwin Software Solutions Pvt Ltd
Stores Inward:
Confidential Page 65 of 75
Suwin Software Solutions Pvt Ltd
Here we can enter the details of Mill missionary which we can bring from outside mills.
Inward Return:
Confidential Page 66 of 75
Suwin Software Solutions Pvt Ltd
Here we can enter the details of the returned missionary which are of Inward.
Outward from Mill:
Confidential Page 67 of 75
Suwin Software Solutions Pvt Ltd
Here we can enter the Details of missionary which are sent for repair from mill.
Confidential Page 68 of 75
Suwin Software Solutions Pvt Ltd
Consumption/Outward:
Here we can enter the details of missionary which are sent for usage, and also which are sent out side to other mills.
Confidential Page 69 of 75
Suwin Software Solutions Pvt Ltd
Outward Return:
Here we can add the returned missionary, which are sent as Outward.
Confidential Page 70 of 75
Suwin Software Solutions Pvt Ltd
8. Employee:
Employee Details: Here we can enter the details of mill Employees.
Confidential Page 71 of 75
Suwin Software Solutions Pvt Ltd
Attendance: Here we have to save the presence of the employees. Here we have two shifts of attendance available. Based on this attendance the salary cuttings can be done.
Salaries: Here we have 3 types of salaries available. 1. Monthly Salaries 2. Weekly Salaries 3. Daily Salaries
Confidential Page 72 of 75
Suwin Software Solutions Pvt Ltd
1. Monthly Salaries: In this we will get the details like monthly salary, cuttings, loss of pay, part paid (if any advance payments in the middle of the month).
Confidential Page 73 of 75
Suwin Software Solutions Pvt Ltd
2. Weekly Salaries: In this we will get the details like weekly salary, cuttings, loss of pay.
Confidential Page 74 of 75
Suwin Software Solutions Pvt Ltd
3. Daily Wages: In this we can enter the details of the daily wages.
Confidential Page 75 of 75
Suwin Software Solutions Pvt Ltd