ABSTRACT:
There comes many a situations when knowledge acquired through learning has to be put into practicality. In the computer field this can be achieved by taking up projects related to real life situations. The major objective of Sales Processing in ‘c’ language is to automate all the transactions which includes customer, stock information and billing system, that are used in this process. User can do all manipulations user friendly and very effectively. By selecting the option available on the screen the user can be taken into screens that is related to the selected option.
The ‘C’ language is used is also highly compatible for these kinds of processes. Project description, Data flow diagrams describes how the data transfer from one data file to another file, tables which are used to store data permanently and several types of reports according to our query option, which displays on screen in a format.
Sales processing reduce the manual assistance and avoidance of redundant work that is usually take place in any processing system. It increases accuracy and effectiveness. Any automation system shouldn’t be complicated. The vital importance is given to User friendliness & platform independence, which gives more compatible to a user. This project can run in any operating system that supports Turbo C & graphics.
PROJECT SPECIFICATION:
Multi Chain Market deals with the processing of accessories rates and product maintenance with the three data files to store data permanently. The user should maintain two databases about the customer and products. The customer database consist of customer code, customer name, address, city are the fields. In product database product code, product name, quantity in hand, price of item are the fields. It has a capability to display all the details in a tabular format.
VALIDATIONS:
- Customer number shouldn’t repeat.
- Make sure to save the details of customer after input.
- Supply customer code to modify the customer records.
- Restrict unauthorized usage of product details.
- Make ensure that update the stock when it is purchased.
- Confirm update of product details.
- Make sure that customer code is registered.
- Make ensure the product code is valid while selling product.
- Allow the user to get discount if he is valid.
- Discount criteria
If bill amount
>1000 - 8% on total bill
>500 <1000 - 5% on total bill
<500 - no discount.
TABLES
Customer database:
cno integer,
cname character
add1 character,
city character,
Transaction database:
cno integer,
pno integer,
qtty integer,
cost float,
bill long int,
pname character,
cname character
Product Database:
pno integer
pname character
quantity on hand integer
cost integer
PROJECT DESCRIPTION:
Sales automation system deals with the purchase, billing system of sales and stock availability information. In this system we have maintain three files, which will store information permanently. The three files consist of customer, stock, transaction information. We can retrieve data when we need of those files. When the purchase transaction done by the user, automatically this information will adds to stock data file. If the sales transaction made by the user then the stock and customer data will get updated. According to the transaction in the sales the stock record should be updated. It doesn’t mean that it should obey the business rules, which are standard. Simultaneously the transaction data file gets updated according to the transaction.
Customer information is maintained with all details about name, address, and customer number. Product information maintains details about product code, product name, quantity available, and amount of product. Transaction information consists of sales and bill of product. Each and every screen has an option to come back to previous screen from where the screen came.
In the first screen we have three options of customer, product, transactions options with the input cursor, which is waiting for any one of these four. Where the fourth option is to come out of the project.
When you get into the customer option it will take to select the options to register a new customer. When you select it, the user has to fill up all the details about the customer. The user can continue this process up to
when the user gives input as no to continue. The second option is to list all the customers in a tabular format who are all registered early. It gives with all information about customer. Third option can be used to modify the customer record. The user should know the customer number to modify his details. When the customer is not available with the given number, it gives a message that the customer is not available. Next option deals to delete the unwanted customer details to reduce the size of the data file. If it doesn’t find the details about the customer, it gives a not found message. At last we return to the main screen when the user selected the corresponding option.
When you get into the customer option it will take to select the options to register a new customer. When you selected this option, the user has fill up all the detail about the customer. The user can continue this process up to when the user gives input as no to add user. The second option is to list all the customers in a tabular format who are all registered early. It gives with all information about customer. Third option can be used to modify the customer record. The user should know the customer number to modify his details. When the customer is not available with the given number, it gives a message that the customer is not available. Next option deals to delete the unwanted customer details to reduce the size of the data file. If it doesn’t find the details about the customer, it gives a not found message. When user want to turn back after fulfillment of requirements he has to tap enter key.
If user wants to get into the details about products he has to select product maintenance option from main menu. But it’s restricted. By giving password the user can enter into options available about products. Product menu consist of five options. To add a new product details we have an option called new product details. The user has to input for product code, product name, and quantity on hand, price of individual item. The user should take care not to repeat the Product code. Is it so, the cursor won’t allow filling the next field information. This option allows storing data about product. It allows adding many products continuously. The next option gives the list of products available in the store in a tabular format. To modify any details of products select ‘Modify the Product details’ option from the main menu of products. The user should enter the product code, which he wants to edit. When the user gives conformation about the modified information the data will be stored in the disk permanently. To delete an unnecessary product details the user has to select ‘Delete Product details’ from menu of product. User should supply the product code. The deletion will be confirmed when the ‘deletion completed’ message displays else ‘product not found’ message will be followed. To get back to the screens where the user came from, select ‘Back’ option. When user want to turn back after fulfillment of requirements he has to tap enter key.
The third option in main menu is transactions. It consists sales and bills. The members of the Multi Chain Market only can purchase products. The non-member of market is trying to purchase the goods it gives a message to register you. This menu allows the user to buy several products. If the product is out of stock the user may know by ‘quantity on hand’ option. It displays availability of stock. To get total bill of purchased products get back to transaction menu and select bill option. It gives the total amount. If the customer is allowed to give discount that amount will be subtracted from total amount and net amount be on the screen. When user want to turn back after fulfillment of requirements he has to tap enter key.
SYSTEM REQUIREMENTS
HARWARE REQUIREMENTS
- A PENTIUM PROCESSOR ABOVE 233MhZ
- COLOR MONITOR
- 32MB RAM
- 256KB OF CACHE MEMORY
- 10GB HARD DISK DRIVE
SOFTWARE REQUIREMENTS
OPERATING SYSTEM :
WINDOWS 9X/Me/UNIX/DOS 6.22
CONCLUSION:
The automation of Multi Chain Market monitoring is very helpful to maintain data and reduce the time while comparing to manual operations. It improves accuracy. It’s compatible and platform independence. The program can be executed at minimum system requirements also. The project consists of user-friendly a screen that is helpful to the user with out taking any assistance of skilled person.
Post a Comment