Multi Chain Market Monitoring in VB

PROJECT SPECIFICATION:

Multi Chain Market Monitoring 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

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.
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.  I hope that this project will help the users and benefit from it immensely.